[wp-hackers] A "terms" table

Matt Mullenweg 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.

On style:

* _id is lowercase on new stuff.
* _slug instead of _nicename.

On substance:

>  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.

Matt Mullenweg
  http://photomatt.net | http://wordpress.org
http://automattic.com | http://akismet.com

More information about the wp-hackers mailing list