[wp-cvs] wordpress/wp-admin upgrade-schema.php,1.24,1.25

[Matthew Mullenweg]

Update of /cvsroot/cafelog/wordpress/wp-admin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15748/wp-admin

Modified Files:
	upgrade-schema.php 
Log Message:
Be a little more forward-looking

Index: upgrade-schema.php
===================================================================
RCS file: /cvsroot/cafelog/wordpress/wp-admin/upgrade-schema.php,v
retrieving revision 1.24
retrieving revision 1.25
diff -C2 -d -r1.24 -r1.25
*** upgrade-schema.php	2 Feb 2005 13:58:14 -0000	1.24
--- upgrade-schema.php	4 Feb 2005 22:55:11 -0000	1.25
***************
*** 3,7 ****
  
  $wp_queries="CREATE TABLE $wpdb->categories (
!   cat_ID int(4) NOT NULL auto_increment,
    cat_name varchar(55) NOT NULL default '',
    category_nicename varchar(200) NOT NULL default '',
--- 3,7 ----
  
  $wp_queries="CREATE TABLE $wpdb->categories (
!   cat_ID bigint(20) NOT NULL auto_increment,
    cat_name varchar(55) NOT NULL default '',
    category_nicename varchar(200) NOT NULL default '',
***************
*** 12,16 ****
  );
  CREATE TABLE $wpdb->comments (
!   comment_ID int(11) unsigned NOT NULL auto_increment,
    comment_post_ID int(11) NOT NULL default '0',
    comment_author tinytext NOT NULL,
--- 12,16 ----
  );
  CREATE TABLE $wpdb->comments (
!   comment_ID bigint(20) unsigned NOT NULL auto_increment,
    comment_post_ID int(11) NOT NULL default '0',
    comment_author tinytext NOT NULL,
***************
*** 32,36 ****
  );
  CREATE TABLE $wpdb->linkcategories (
!   cat_id int(11) NOT NULL auto_increment,
    cat_name tinytext NOT NULL,
    auto_toggle enum('Y','N') NOT NULL default 'N',
--- 32,36 ----
  );
  CREATE TABLE $wpdb->linkcategories (
!   cat_id bigint(20) NOT NULL auto_increment,
    cat_name tinytext NOT NULL,
    auto_toggle enum('Y','N') NOT NULL default 'N',
***************
*** 48,52 ****
  );
  CREATE TABLE $wpdb->links (
!   link_id int(11) NOT NULL auto_increment,
    link_url varchar(255) NOT NULL default '',
    link_name varchar(255) NOT NULL default '',
--- 48,52 ----
  );
  CREATE TABLE $wpdb->links (
!   link_id bigint(20) NOT NULL auto_increment,
    link_url varchar(255) NOT NULL default '',
    link_name varchar(255) NOT NULL default '',
***************
*** 67,71 ****
  );
  CREATE TABLE $wpdb->options (
!   option_id int(11) NOT NULL auto_increment,
    blog_id int(11) NOT NULL default '0',
    option_name varchar(64) NOT NULL default '',
--- 67,71 ----
  );
  CREATE TABLE $wpdb->options (
!   option_id bigint(20) NOT NULL auto_increment,
    blog_id int(11) NOT NULL default '0',
    option_name varchar(64) NOT NULL default '',
***************
*** 82,94 ****
  );
  CREATE TABLE $wpdb->post2cat (
!   rel_id int(11) NOT NULL auto_increment,
!   post_id int(11) NOT NULL default '0',
!   category_id int(11) NOT NULL default '0',
    PRIMARY KEY  (rel_id),
    KEY post_id (post_id,category_id)
  );
  CREATE TABLE $wpdb->postmeta (
!   meta_id int(11) NOT NULL auto_increment,
!   post_id int(11) NOT NULL default '0',
    meta_key varchar(255) default NULL,
    meta_value text,
--- 82,94 ----
  );
  CREATE TABLE $wpdb->post2cat (
!   rel_id bigint(20) NOT NULL auto_increment,
!   post_id bigint(20) NOT NULL default '0',
!   category_id bigint(20) NOT NULL default '0',
    PRIMARY KEY  (rel_id),
    KEY post_id (post_id,category_id)
  );
  CREATE TABLE $wpdb->postmeta (
!   meta_id bigint(20) NOT NULL auto_increment,
!   post_id bigint(20) NOT NULL default '0',
    meta_key varchar(255) default NULL,
    meta_value text,
***************
*** 98,102 ****
  );
  CREATE TABLE $wpdb->posts (
!   ID int(11) unsigned NOT NULL auto_increment,
    post_author int(4) NOT NULL default '0',
    post_date datetime NOT NULL default '0000-00-00 00:00:00',
--- 98,102 ----
  );
  CREATE TABLE $wpdb->posts (
!   ID bigint(20) unsigned NOT NULL auto_increment,
    post_author int(4) NOT NULL default '0',
    post_date datetime NOT NULL default '0000-00-00 00:00:00',
***************
*** 123,128 ****
  );
  CREATE TABLE $wpdb->users (
!   ID int(10) unsigned NOT NULL auto_increment,
!   user_login varchar(20) NOT NULL default '',
    user_pass varchar(64) NOT NULL default '',
    user_firstname varchar(50) NOT NULL default '',
--- 123,128 ----
  );
  CREATE TABLE $wpdb->users (
!   ID bigint(20) unsigned NOT NULL auto_increment,
!   user_login varchar(60) NOT NULL default '',
    user_pass varchar(64) NOT NULL default '',
    user_firstname varchar(50) NOT NULL default '',