[wp-hackers] Taxonomy Schema Proposal

Jamie Talbot wphackers at jamietalbot.com
Fri Apr 20 00:03:36 GMT 2007

Steve Lewis wrote:
> 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.

- From the email you replied to:

"And after all this, there is a unique key on the proposed terms table term_slug anyway, as well as
on the term taxonomy table for the (term_id, taxonomy) tuple.  Or if there isn't I just missed it
off and there should be."




More information about the wp-hackers mailing list