Re: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

[Dotan Cohen]

On Thu, Jan 20, 2011 at 17:22, Peter Brawley
<peter.brawley@stripped> 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