On Thu, Jan 20, 2011 at 17:22, Peter Brawley <peter.braw...@earthlink.net> wrote: > I'd exclude (1) because new tags require restructuring the table, (2) > and (3) because they break a cardinal rule of design and will be a mess > to query, leaving ... > > 4) Standard many-many bridge table: > mysql> CREATE TABLE items_tags ( > id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, > itemID int, > tagID INT > ); > > Will not require a major overhaul if you later turn categories into a tree. >
Terrific, Peter, this looks like the right direction. I appreciate the input. -- Dotan Cohen http://gibberish.co.il http://what-is-what.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org