[wp-hackers] A "terms" table
m at mullenweg.com
Sun Apr 15 23:48:14 GMT 2007
Ryan Boren wrote:
> I'll borrow and corrupt Drupal's vocabulary terminology. We have
> three vocabularies: link categories, post categories, and post tags.
> We want a term with a given name to always have the same id but be
> able to participate independently in each of these vocabularies. If
> we pare down the tables to the least we can get away with, we end with
> with three.
* _id is lowercase on new stuff.
* _slug instead of _nicename.
> KEY object_ID (object_ID,term_ID),
I don't think this is needed.
> KEY term_ID (term_ID,object_ID)
I think you can leave object_ID out of this.
http://photomatt.net | http://wordpress.org
http://automattic.com | http://akismet.com
More information about the wp-hackers