[wp-hackers] Taxonomy Schema Proposal

Steve Lewis stevelle at gmail.com
Thu Apr 19 16:44:53 GMT 2007

Poor form, replying to self...

On 4/19/07, Steve Lewis <stevelle at gmail.com> wrote:
> but if you do put a UNIQUE on the term_slug then you might find it
> difficult to create a 'friends' tag if you already have a 'friends'
> category, no?  To do what you want, you should put a compound UNIQUE on the
> taxonomy table: UNIQUE(taxonomy, term_id).

Scratch that, you want the UNIQUE on the term_slug.  The terms to taxonomy
relation isn't 1:1.  I believe you still want your KEY (taxonomy, term_id)
to be a UNIQUE, however.


More information about the wp-hackers mailing list