Make WordPress Core

Changeset 2213


Ignore:
Timestamp:
02/04/2005 10:55:11 PM (20 years ago)
Author:
saxmatt
Message:

Be a little more forward-looking

File:
1 edited

Legend:

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

    r2207 r2213  
    33
    44$wp_queries="CREATE TABLE $wpdb->categories (
    5   cat_ID int(4) NOT NULL auto_increment,
     5  cat_ID bigint(20) NOT NULL auto_increment,
    66  cat_name varchar(55) NOT NULL default '',
    77  category_nicename varchar(200) NOT NULL default '',
     
    1212);
    1313CREATE TABLE $wpdb->comments (
    14   comment_ID int(11) unsigned NOT NULL auto_increment,
     14  comment_ID bigint(20) unsigned NOT NULL auto_increment,
    1515  comment_post_ID int(11) NOT NULL default '0',
    1616  comment_author tinytext NOT NULL,
     
    3232);
    3333CREATE TABLE $wpdb->linkcategories (
    34   cat_id int(11) NOT NULL auto_increment,
     34  cat_id bigint(20) NOT NULL auto_increment,
    3535  cat_name tinytext NOT NULL,
    3636  auto_toggle enum('Y','N') NOT NULL default 'N',
     
    4848);
    4949CREATE TABLE $wpdb->links (
    50   link_id int(11) NOT NULL auto_increment,
     50  link_id bigint(20) NOT NULL auto_increment,
    5151  link_url varchar(255) NOT NULL default '',
    5252  link_name varchar(255) NOT NULL default '',
     
    6767);
    6868CREATE TABLE $wpdb->options (
    69   option_id int(11) NOT NULL auto_increment,
     69  option_id bigint(20) NOT NULL auto_increment,
    7070  blog_id int(11) NOT NULL default '0',
    7171  option_name varchar(64) NOT NULL default '',
     
    8282);
    8383CREATE TABLE $wpdb->post2cat (
    84   rel_id int(11) NOT NULL auto_increment,
    85   post_id int(11) NOT NULL default '0',
    86   category_id int(11) NOT NULL default '0',
     84  rel_id bigint(20) NOT NULL auto_increment,
     85  post_id bigint(20) NOT NULL default '0',
     86  category_id bigint(20) NOT NULL default '0',
    8787  PRIMARY KEY  (rel_id),
    8888  KEY post_id (post_id,category_id)
    8989);
    9090CREATE TABLE $wpdb->postmeta (
    91   meta_id int(11) NOT NULL auto_increment,
    92   post_id int(11) NOT NULL default '0',
     91  meta_id bigint(20) NOT NULL auto_increment,
     92  post_id bigint(20) NOT NULL default '0',
    9393  meta_key varchar(255) default NULL,
    9494  meta_value text,
     
    9898);
    9999CREATE TABLE $wpdb->posts (
    100   ID int(11) unsigned NOT NULL auto_increment,
     100  ID bigint(20) unsigned NOT NULL auto_increment,
    101101  post_author int(4) NOT NULL default '0',
    102102  post_date datetime NOT NULL default '0000-00-00 00:00:00',
     
    123123);
    124124CREATE TABLE $wpdb->users (
    125   ID int(10) unsigned NOT NULL auto_increment,
    126   user_login varchar(20) NOT NULL default '',
     125  ID bigint(20) unsigned NOT NULL auto_increment,
     126  user_login varchar(60) NOT NULL default '',
    127127  user_pass varchar(64) NOT NULL default '',
    128128  user_firstname varchar(50) NOT NULL default '',
Note: See TracChangeset for help on using the changeset viewer.