[wp-hackers] Taxonomy Schema Proposal

[Steve Lewis]

On 4/19/07, Jamie Talbot <wphackers at jamietalbot.com> wrote:
>
> > Sorry, I'm not buying that.  Terms have a taxonomy which may be Category
> or
> > Tag or some other.  That means Categories and Tags are Terms.  That
> > suggests I shouldn't care which taxonomy is associated with the Term.
>
> That doesn't necessarily follow.  I could want a post_category called
> news, and want to tag certain


It doesn't have to.  The example you provided is understood.

> I think it
> > will be both easier to use for authors and easier to support for the
> > community if *or* is considered to be *xor* in
> implementation.  Hopefully I
> > made that clear.
>
> Isn't that exactly what we *don't* want?  If I understand you correctly,
> you want to a term to be
> either a post_category, or a post_tag, but not both?


We want different things.  I don't want to share tables across different
taxonomies unless the terms are exclusive.

As I understand it, this was a big complaint about the
> integration of link and post categories and exactly the thing we're trying
> to avoid here.


Our understanding of the complaints re: link and post categories is
different. The complaints I am familiar with were that the release that
merged them broke APIs without sufficient warning.  My recollections are
most likely the least reliable in the room because they were personal and
emotional when my stuff got broken and I had to roll back.

If you want that functionality, it's not clear what exactly you are buying
by having everything in one table.  Maybe I was clear on some value in doing
that before, but I forgot.  Either way, that argument seems to be going
nowhere.

After grousing as much as I have, i should take a moment to review the php
you outlined--and actually contribute something useful[gdr].  I haven't read
it yet, and will try to make some time to soon, 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).

-- 
SteveL