[geeklog-devel] Blocks again...
Tony Bibbs
tony at tonybibbs.com
Wed Jul 7 14:49:01 EDT 2004
Dirk Haun wrote:
>Actually, my main concern here is with the representation of this
>information in the database. The topics have a topic id of up to 20
>characters. Instead of one topic, we now need to store a list of topics.
>Any suggestions?
>
>
You'd want an associative table called block_topic. It would have the
block_id and topic_id as the primary key.
I think this might also be a good time to consider getting rid of the
text-based primary key on the topic table and introduce a new
auto_increment value.
Just a thought,
--Tony
More information about the geeklog-devel
mailing list