[wp-hackers] Taxonomy Schema Proposal

Bas Bosman wordpress at nazgul.nu
Thu Apr 19 16:21:59 GMT 2007

> CREATE TABLE $wpdb->terms (
>  term_id bigint(20) NOT NULL auto_increment,
>  term_name varchar(55) NOT NULL default '',
>  term_slug varchar(200) NOT NULL default '',
>  term_group bigint(10) NOT NULL default 0
>  PRIMARY KEY  (term_ID),
>  UNIQUE KEY term_slug (term_slug)
> );

I think it's just a typo, but in every iteration of the scheme i've seen
on this list there is a field called term_id and a primary key called

The same also applies to object_id in one of the other tables.

Bas Bosman (Nazgul)

More information about the wp-hackers mailing list