| 151 | | ) $charset_collate;"; |
|---|
| 152 | | |
|---|
| 153 | | // Old tables that will die soon |
|---|
| 154 | | $wp_queries.="CREATE TABLE $wpdb->categories ( |
|---|
| 155 | | cat_ID bigint(20) NOT NULL auto_increment, |
|---|
| 156 | | cat_name varchar(55) NOT NULL default '', |
|---|
| 157 | | category_nicename varchar(200) NOT NULL default '', |
|---|
| 158 | | category_description longtext NOT NULL, |
|---|
| 159 | | category_parent bigint(20) NOT NULL default '0', |
|---|
| 160 | | category_count bigint(20) NOT NULL default '0', |
|---|
| 161 | | link_count bigint(20) NOT NULL default '0', |
|---|
| 162 | | posts_private tinyint(1) NOT NULL default '0', |
|---|
| 163 | | links_private tinyint(1) NOT NULL default '0', |
|---|
| 164 | | PRIMARY KEY (cat_ID), |
|---|
| 165 | | KEY category_nicename (category_nicename) |
|---|
| 166 | | ) $charset_collate; |
|---|
| 167 | | CREATE TABLE $wpdb->link2cat ( |
|---|
| 168 | | rel_id bigint(20) NOT NULL auto_increment, |
|---|
| 169 | | link_id bigint(20) NOT NULL default '0', |
|---|
| 170 | | category_id bigint(20) NOT NULL default '0', |
|---|
| 171 | | PRIMARY KEY (rel_id), |
|---|
| 172 | | KEY link_id (link_id,category_id) |
|---|
| 173 | | ) $charset_collate; |
|---|
| 174 | | CREATE TABLE $wpdb->post2cat ( |
|---|
| 175 | | rel_id bigint(20) NOT NULL auto_increment, |
|---|
| 176 | | post_id bigint(20) NOT NULL default '0', |
|---|
| 177 | | category_id bigint(20) NOT NULL default '0', |
|---|
| 178 | | PRIMARY KEY (rel_id), |
|---|
| 179 | | KEY post_id (post_id,category_id) |
|---|
