Changeset 2213
- Timestamp:
- 02/04/2005 10:55:11 PM (20 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/wp-admin/upgrade-schema.php
r2207 r2213 3 3 4 4 $wp_queries="CREATE TABLE $wpdb->categories ( 5 cat_ID int(4) NOT NULL auto_increment,5 cat_ID bigint(20) NOT NULL auto_increment, 6 6 cat_name varchar(55) NOT NULL default '', 7 7 category_nicename varchar(200) NOT NULL default '', … … 12 12 ); 13 13 CREATE TABLE $wpdb->comments ( 14 comment_ID int(11) unsigned NOT NULL auto_increment,14 comment_ID bigint(20) unsigned NOT NULL auto_increment, 15 15 comment_post_ID int(11) NOT NULL default '0', 16 16 comment_author tinytext NOT NULL, … … 32 32 ); 33 33 CREATE TABLE $wpdb->linkcategories ( 34 cat_id int(11) NOT NULL auto_increment,34 cat_id bigint(20) NOT NULL auto_increment, 35 35 cat_name tinytext NOT NULL, 36 36 auto_toggle enum('Y','N') NOT NULL default 'N', … … 48 48 ); 49 49 CREATE TABLE $wpdb->links ( 50 link_id int(11) NOT NULL auto_increment,50 link_id bigint(20) NOT NULL auto_increment, 51 51 link_url varchar(255) NOT NULL default '', 52 52 link_name varchar(255) NOT NULL default '', … … 67 67 ); 68 68 CREATE TABLE $wpdb->options ( 69 option_id int(11) NOT NULL auto_increment,69 option_id bigint(20) NOT NULL auto_increment, 70 70 blog_id int(11) NOT NULL default '0', 71 71 option_name varchar(64) NOT NULL default '', … … 82 82 ); 83 83 CREATE 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', 87 87 PRIMARY KEY (rel_id), 88 88 KEY post_id (post_id,category_id) 89 89 ); 90 90 CREATE 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', 93 93 meta_key varchar(255) default NULL, 94 94 meta_value text, … … 98 98 ); 99 99 CREATE TABLE $wpdb->posts ( 100 ID int(11) unsigned NOT NULL auto_increment,100 ID bigint(20) unsigned NOT NULL auto_increment, 101 101 post_author int(4) NOT NULL default '0', 102 102 post_date datetime NOT NULL default '0000-00-00 00:00:00', … … 123 123 ); 124 124 CREATE 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 '', 127 127 user_pass varchar(64) NOT NULL default '', 128 128 user_firstname varchar(50) NOT NULL default '',
Note: See TracChangeset
for help on using the changeset viewer.