Make WordPress Core

Changeset 5516


Ignore:
Timestamp:
05/22/2007 08:59:00 PM (17 years ago)
Author:
ryan
Message:

Keep the old tables in the schema until everything is converted. see #4189

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/wp-admin/upgrade-schema.php

    r5515 r5516  
    149149  KEY user_id (user_id),
    150150  KEY meta_key (meta_key)
     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;
     167CREATE 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;
     174CREATE 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)
    151180) $charset_collate;";
    152181
Note: See TracChangeset for help on using the changeset viewer.