[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,


More information about the geeklog-devel mailing list