| Index: trunk/phase3/maintenance/archives/patch-rename-group.sql |
| — | — | @@ -1,10 +0,0 @@ |
| 2 | | - |
| 3 | | -RENAME TABLE /*$wgDBprefix*/`group` TO /*$wgDBprefix*/groups; |
| 4 | | -ALTER TABLE /*$wgDBprefix*/groups |
| 5 | | - CHANGE group_id gr_id int(5) unsigned NOT NULL auto_increment, |
| 6 | | - CHANGE group_name gr_name varchar(50) NOT NULL default '', |
| 7 | | - CHANGE group_description gr_description varchar(255) NOT NULL default '', |
| 8 | | - CHANGE group_rights gr_rights tinyblob; |
| 9 | | - |
| Index: trunk/phase3/maintenance/archives/patch-userlevels-rights.sql |
| — | — | @@ -1,5 +0,0 @@ |
| 2 | | - |
| 3 | | -ALTER TABLE /*$wgDBprefix*/groups ADD gr_rights tinyblob; |
| Index: trunk/phase3/maintenance/archives/patch-usernewtalk2.sql |
| — | — | @@ -1,6 +0,0 @@ |
| 2 | | -CREATE TABLE /*$wgDBprefix*/user_newtalk ( |
| 3 | | - user_id int(5) NOT NULL default '0', |
| 4 | | - user_ip varchar(40) NOT NULL default '', |
| 5 | | - INDEX user_id (user_id), |
| 6 | | - INDEX user_ip (user_ip) |
| 7 | | -); |
| Index: trunk/phase3/maintenance/archives/patch-userlevels-defaultgroups.sql |
| — | — | @@ -1,30 +0,0 @@ |
| 2 | | - |
| 3 | | -INSERT INTO /*$wgDBprefix*/groups (gr_id,gr_name,gr_description,gr_rights) |
| 4 | | - VALUES ( |
| 5 | | - 1,':group-anon-name',':group-anon-desc', |
| 6 | | - 'read,edit,createaccount' |
| 7 | | - ); |
| 8 | | -INSERT INTO /*$wgDBprefix*/groups (gr_id,gr_name,gr_description,gr_rights) |
| 9 | | - VALUES ( |
| 10 | | - 2,':group-loggedin-name',':group-loggedin-desc', |
| 11 | | - 'read,edit,move,upload,validate,createaccount' |
| 12 | | - ); |
| 13 | | -INSERT INTO /*$wgDBprefix*/groups (gr_id,gr_name,gr_description,gr_rights) |
| 14 | | - VALUES ( |
| 15 | | - 3,':group-admin-name',':group-admin-desc', |
| 16 | | - 'read,edit,move,upload,validate,createaccount,delete,undelete,protect,block,upload,asksql,rollback,patrol,editinterface,import' |
| 17 | | - ); |
| 18 | | -INSERT INTO /*$wgDBprefix*/groups (gr_id,gr_name,gr_description,gr_rights) |
| 19 | | - VALUES ( |
| 20 | | - 4,':group-bureaucrat-name',':group-bureaucrat-desc', |
| 21 | | - 'read,edit,move,upload,validate,createaccount,delete,undelete,protect,block,upload,asksql,rollback,patrol,editinterface,import,makesysop' |
| 22 | | - ); |
| 23 | | -INSERT INTO /*$wgDBprefix*/groups (gr_id,gr_name,gr_description,gr_rights) |
| 24 | | - VALUES ( |
| 25 | | - 5,':group-steward-name',':group-steward-desc', |
| 26 | | - 'read,edit,move,upload,validate,createaccount,delete,undelete,protect,block,upload,asksql,rollback,patrol,editinterface,import,makesysop,userrights,grouprights,siteadmin' |
| 27 | | - ); |
| Index: trunk/phase3/maintenance/archives/patch-ss_images.sql |
| — | — | @@ -1,5 +1,5 @@ |
| 2 | 2 | -- More statistics, for version 1.6 |
| 3 | 3 | |
| 4 | | -ALTER TABLE /*$wgDBprefix*/site_stats ADD ss_images int(10) default '0'; |
| | 4 | +ALTER TABLE /*$wgDBprefix*/site_stats ADD ss_images int default '0'; |
| 5 | 5 | SELECT @images := COUNT(*) FROM /*$wgDBprefix*/image; |
| 6 | 6 | UPDATE /*$wgDBprefix*/site_stats SET ss_images=@images; |
| Index: trunk/phase3/maintenance/archives/patch-categorylinks.sql |
| — | — | @@ -5,7 +5,7 @@ |
| 6 | 6 | -- |
| 7 | 7 | CREATE TABLE /*$wgDBprefix*/categorylinks ( |
| 8 | 8 | -- Key to page_id of the page defined as a category member. |
| 9 | | - cl_from int(8) unsigned NOT NULL default '0', |
| | 9 | + cl_from int unsigned NOT NULL default '0', |
| 10 | 10 | |
| 11 | 11 | -- Name of the category. |
| 12 | 12 | -- This is also the page_title of the category's description page; |
| — | — | @@ -17,11 +17,9 @@ |
| 18 | 18 | -- isn't always ideal, but collations seem to be an exciting |
| 19 | 19 | -- and dangerous new world in MySQL... |
| 20 | 20 | -- |
| 21 | | - -- For MySQL 4.1+ with charset set to utf8, the sort key *index* |
| 22 | | - -- needs cut to be smaller than 1024 bytes (at 3 bytes per char). |
| 23 | | - -- To sort properly on the shorter key, this field needs to be |
| 24 | | - -- the same shortness. |
| 25 | | - cl_sortkey varchar(86) binary NOT NULL default '', |
| | 21 | + -- Truncate so that the cl_sortkey key fits in 1000 bytes |
| | 22 | + -- (MyISAM 5 with server_character_set=utf8) |
| | 23 | + cl_sortkey varchar(70) binary NOT NULL default '', |
| 26 | 24 | |
| 27 | 25 | -- This isn't really used at present. Provided for an optional |
| 28 | 26 | -- sorting method by approximate addition time. |
| Index: trunk/phase3/maintenance/archives/patch-rc_id.sql |
| — | — | @@ -1,7 +1,7 @@ |
| 2 | 2 | -- Primary key in recentchanges |
| 3 | 3 | |
| 4 | 4 | ALTER TABLE /*$wgDBprefix*/recentchanges |
| 5 | | - ADD rc_id int(8) NOT NULL auto_increment, |
| | 5 | + ADD rc_id int NOT NULL auto_increment, |
| 6 | 6 | ADD PRIMARY KEY rc_id (rc_id); |
| 7 | 7 | |
| 8 | 8 | |
| Index: trunk/phase3/maintenance/archives/patch-rev_parent_id.sql |
| — | — | @@ -6,4 +6,4 @@ |
| 7 | 7 | -- |
| 8 | 8 | |
| 9 | 9 | ALTER TABLE /*$wgDBprefix*/revision |
| 10 | | - ADD rev_parent_id int(8) unsigned default NULL; |
| | 10 | + ADD rev_parent_id int unsigned default NULL; |
| Index: trunk/phase3/maintenance/archives/patch-filearchive.sql |
| — | — | @@ -14,33 +14,33 @@ |
| 15 | 15 | -- Which storage bin (directory tree or object store) the file data |
| 16 | 16 | -- is stored in. Should be 'deleted' for files that have been deleted; |
| 17 | 17 | -- any other bin is not yet in use. |
| 18 | | - fa_storage_group varchar(16), |
| | 18 | + fa_storage_group varbinary(16), |
| 19 | 19 | |
| 20 | 20 | -- SHA-1 of the file contents plus extension, used as a key for storage. |
| 21 | 21 | -- eg 8f8a562add37052a1848ff7771a2c515db94baa9.jpg |
| 22 | 22 | -- |
| 23 | 23 | -- If NULL, the file was missing at deletion time or has been purged |
| 24 | 24 | -- from the archival storage. |
| 25 | | - fa_storage_key varchar(64) binary default '', |
| | 25 | + fa_storage_key varbinary(64) default '', |
| 26 | 26 | |
| 27 | 27 | -- Deletion information, if this file is deleted. |
| 28 | 28 | fa_deleted_user int, |
| 29 | | - fa_deleted_timestamp char(14) binary default '', |
| | 29 | + fa_deleted_timestamp binary(14) default '', |
| 30 | 30 | fa_deleted_reason text, |
| 31 | 31 | |
| 32 | 32 | -- Duped fields from image |
| 33 | | - fa_size int(8) unsigned default '0', |
| 34 | | - fa_width int(5) default '0', |
| 35 | | - fa_height int(5) default '0', |
| | 33 | + fa_size int unsigned default '0', |
| | 34 | + fa_width int default '0', |
| | 35 | + fa_height int default '0', |
| 36 | 36 | fa_metadata mediumblob, |
| 37 | | - fa_bits int(3) default '0', |
| | 37 | + fa_bits int default '0', |
| 38 | 38 | fa_media_type ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL, |
| 39 | 39 | fa_major_mime ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart") default "unknown", |
| 40 | | - fa_minor_mime varchar(32) default "unknown", |
| | 40 | + fa_minor_mime varbinary(32) default "unknown", |
| 41 | 41 | fa_description tinyblob, |
| 42 | | - fa_user int(5) unsigned default '0', |
| | 42 | + fa_user int unsigned default '0', |
| 43 | 43 | fa_user_text varchar(255) binary default '', |
| 44 | | - fa_timestamp char(14) binary default '', |
| | 44 | + fa_timestamp binary(14) default '', |
| 45 | 45 | |
| 46 | 46 | PRIMARY KEY (fa_id), |
| 47 | 47 | INDEX (fa_name, fa_timestamp), -- pick out by image name |
| Index: trunk/phase3/maintenance/archives/patch-page_restrictions.sql |
| — | — | @@ -1,17 +1,17 @@ |
| 2 | 2 | --- Used for storing page restrictions (i.e. protection levels) |
| 3 | 3 | CREATE TABLE /*$wgDBprefix*/page_restrictions ( |
| 4 | 4 | -- Page to apply restrictions to (Foreign Key to page). |
| 5 | | - pr_page int(8) NOT NULL, |
| | 5 | + pr_page int NOT NULL, |
| 6 | 6 | -- The protection type (edit, move, etc) |
| 7 | | - pr_type varchar(255) NOT NULL, |
| | 7 | + pr_type varbinary(60) NOT NULL, |
| 8 | 8 | -- The protection level (Sysop, autoconfirmed, etc) |
| 9 | | - pr_level varchar(255) NOT NULL, |
| | 9 | + pr_level varbinary(60) NOT NULL, |
| 10 | 10 | -- Whether or not to cascade the protection down to pages transcluded. |
| 11 | | - pr_cascade tinyint(4) NOT NULL, |
| | 11 | + pr_cascade tinyint NOT NULL, |
| 12 | 12 | -- Field for future support of per-user restriction. |
| 13 | | - pr_user int(8) NULL, |
| | 13 | + pr_user int NULL, |
| 14 | 14 | -- Field for time-limited protection. |
| 15 | | - pr_expiry char(14) binary NULL, |
| | 15 | + pr_expiry varbinary(14) NULL, |
| 16 | 16 | |
| 17 | 17 | PRIMARY KEY pr_pagetype (pr_page,pr_type), |
| 18 | 18 | |
| — | — | @@ -19,4 +19,4 @@ |
| 20 | 20 | KEY pr_typelevel (pr_type,pr_level), |
| 21 | 21 | KEY pr_level (pr_level), |
| 22 | 22 | KEY pr_cascade (pr_cascade) |
| 23 | | -) /*$wgDBTableOptions*/; |
| \ No newline at end of file |
| | 23 | +) /*$wgDBTableOptions*/; |
| Index: trunk/phase3/maintenance/archives/patch-restructure.sql |
| — | — | @@ -10,17 +10,17 @@ |
| 11 | 11 | -- discarded when done. |
| 12 | 12 | |
| 13 | 13 | CREATE TABLE /*$wgDBprefix*/page ( |
| 14 | | - page_id int(8) unsigned NOT NULL auto_increment, |
| | 14 | + page_id int unsigned NOT NULL auto_increment, |
| 15 | 15 | page_namespace tinyint NOT NULL, |
| 16 | 16 | page_title varchar(255) binary NOT NULL, |
| 17 | 17 | page_restrictions tinyblob NOT NULL, |
| 18 | | - page_counter bigint(20) unsigned NOT NULL default '0', |
| 19 | | - page_is_redirect tinyint(1) unsigned NOT NULL default '0', |
| 20 | | - page_is_new tinyint(1) unsigned NOT NULL default '0', |
| | 18 | + page_counter bigint unsigned NOT NULL default '0', |
| | 19 | + page_is_redirect tinyint unsigned NOT NULL default '0', |
| | 20 | + page_is_new tinyint unsigned NOT NULL default '0', |
| 21 | 21 | page_random real unsigned NOT NULL, |
| 22 | | - page_touched char(14) binary NOT NULL default '', |
| 23 | | - page_latest int(8) unsigned NOT NULL, |
| 24 | | - page_len int(8) unsigned NOT NULL, |
| | 22 | + page_touched binary(14) NOT NULL default '', |
| | 23 | + page_latest int unsigned NOT NULL, |
| | 24 | + page_len int unsigned NOT NULL, |
| 25 | 25 | |
| 26 | 26 | PRIMARY KEY page_id (page_id), |
| 27 | 27 | UNIQUE INDEX name_title (page_namespace,page_title), |
| — | — | @@ -29,14 +29,14 @@ |
| 30 | 30 | ); |
| 31 | 31 | |
| 32 | 32 | CREATE TABLE /*$wgDBprefix*/revision ( |
| 33 | | - rev_id int(8) unsigned NOT NULL auto_increment, |
| 34 | | - rev_page int(8) unsigned NOT NULL, |
| | 33 | + rev_id int unsigned NOT NULL auto_increment, |
| | 34 | + rev_page int unsigned NOT NULL, |
| 35 | 35 | rev_comment tinyblob NOT NULL, |
| 36 | | - rev_user int(5) unsigned NOT NULL default '0', |
| | 36 | + rev_user int unsigned NOT NULL default '0', |
| 37 | 37 | rev_user_text varchar(255) binary NOT NULL default '', |
| 38 | | - rev_timestamp char(14) binary NOT NULL default '', |
| 39 | | - rev_minor_edit tinyint(1) unsigned NOT NULL default '0', |
| 40 | | - rev_deleted tinyint(1) unsigned NOT NULL default '0', |
| | 38 | + rev_timestamp binary(14) NOT NULL default '', |
| | 39 | + rev_minor_edit tinyint unsigned NOT NULL default '0', |
| | 40 | + rev_deleted tinyint unsigned NOT NULL default '0', |
| 41 | 41 | |
| 42 | 42 | |
| 43 | 43 | PRIMARY KEY rev_page_id (rev_page, rev_id), |
| Index: trunk/phase3/maintenance/archives/patch-math.sql |
| — | — | @@ -8,14 +8,14 @@ |
| 9 | 9 | DROP TABLE IF EXISTS /*$wgDBprefix*/math; |
| 10 | 10 | CREATE TABLE /*$wgDBprefix*/math ( |
| 11 | 11 | -- Binary MD5 hash of the latex fragment, used as an identifier key. |
| 12 | | - math_inputhash varchar(16) NOT NULL, |
| | 12 | + math_inputhash varbinary(16) NOT NULL, |
| 13 | 13 | |
| 14 | 14 | -- Not sure what this is, exactly... |
| 15 | | - math_outputhash varchar(16) NOT NULL, |
| | 15 | + math_outputhash varbinary(16) NOT NULL, |
| 16 | 16 | |
| 17 | 17 | -- texvc reports how well it thinks the HTML conversion worked; |
| 18 | 18 | -- if it's a low level the PNG rendering may be preferred. |
| 19 | | - math_html_conservativeness tinyint(1) NOT NULL, |
| | 19 | + math_html_conservativeness tinyint NOT NULL, |
| 20 | 20 | |
| 21 | 21 | -- HTML output from texvc, if any |
| 22 | 22 | math_html text, |
| Index: trunk/phase3/maintenance/archives/patch-userlevels.sql |
| — | — | @@ -1,22 +1,8 @@ |
| 2 | 2 | |
| 3 | | -CREATE TABLE /*$wgDBprefix*/groups ( |
| 4 | | - gr_id int(5) unsigned NOT NULL auto_increment, |
| 5 | | - gr_name varchar(50) NOT NULL default '', |
| 6 | | - gr_description varchar(255) NOT NULL default '', |
| 7 | | - gr_rights tinyblob, |
| 8 | | - PRIMARY KEY (gr_id) |
| 9 | | - |
| 10 | | -) /*$wgDBTableOptions*/; |
| 11 | | - |
| 12 | 3 | -- Relation table between user and groups |
| 13 | 4 | CREATE TABLE /*$wgDBprefix*/user_groups ( |
| 14 | | - ug_user int(5) unsigned NOT NULL default '0', |
| 15 | | - ug_group int(5) unsigned NOT NULL default '0', |
| | 5 | + ug_user int unsigned NOT NULL default '0', |
| | 6 | + ug_group varbinary(16) NOT NULL default '0', |
| 16 | 7 | PRIMARY KEY (ug_user,ug_group) |
| 17 | | - |
| | 8 | + KEY (ug_group) |
| 18 | 9 | ) /*$wgDBTableOptions*/; |
| Index: trunk/phase3/maintenance/archives/patch-rc_ip.sql |
| — | — | @@ -1,7 +1,7 @@ |
| 2 | 2 | -- Adding the rc_ip field for logging of IP addresses in recentchanges |
| 3 | 3 | |
| 4 | 4 | ALTER TABLE /*$wgDBprefix*/recentchanges |
| 5 | | - ADD rc_ip char(15) NOT NULL default '', |
| | 5 | + ADD rc_ip varbinary(40) NOT NULL default '', |
| 6 | 6 | ADD INDEX rc_ip (rc_ip); |
| 7 | 7 | |
| 8 | 8 | |
| Index: trunk/phase3/maintenance/archives/patch-user_newpass_time.sql |
| — | — | @@ -1,4 +1,4 @@ |
| 2 | 2 | -- Timestamp of the last time when a new password was |
| 3 | 3 | -- sent, for throttling purposes |
| 4 | | -ALTER TABLE /*$wgDBprefix*/user ADD user_newpass_time char(14) binary; |
| | 4 | +ALTER TABLE /*$wgDBprefix*/user ADD user_newpass_time binary(14); |
| 5 | 5 | |
| Index: trunk/phase3/maintenance/archives/patch-ar_len.sql |
| — | — | @@ -1,3 +1,3 @@ |
| 2 | 2 | ALTER TABLE /*$wgDBprefix*/archive |
| 3 | | - ADD ar_len INT(8) UNSIGNED; |
| | 3 | + ADD ar_len INT UNSIGNED; |
| 4 | 4 | |
| Index: trunk/phase3/maintenance/archives/patch-ipb_emailban.sql |
| — | — | @@ -1,4 +1,4 @@ |
| 2 | 2 | -- Add row for email blocks -- |
| 3 | 3 | |
| 4 | 4 | ALTER TABLE /*$wgDBprefix*/ipblocks |
| 5 | | - ADD ipb_block_email tinyint(1) NOT NULL default '0'; |
| | 5 | + ADD ipb_block_email tinyint NOT NULL default '0'; |
| Index: trunk/phase3/maintenance/archives/patch-cache.sql |
| — | — | @@ -15,7 +15,7 @@ |
| 16 | 16 | -- cur_touched is later, the page must be regenerated. |
| 17 | 17 | |
| 18 | 18 | ALTER TABLE /*$wgDBprefix*/cur |
| 19 | | - ADD COLUMN cur_touched char(14) binary NOT NULL default ''; |
| | 19 | + ADD COLUMN cur_touched binary(14) NOT NULL default ''; |
| 20 | 20 | |
| 21 | 21 | -- Existing pages should be initialized to the current |
| 22 | 22 | -- time so they don't needlessly rerender until they are |
| — | — | @@ -36,6 +36,6 @@ |
| 37 | 37 | -- sent again. |
| 38 | 38 | |
| 39 | 39 | ALTER TABLE /*$wgDBprefix*/user |
| 40 | | - ADD COLUMN user_touched char(14) binary NOT NULL default ''; |
| | 40 | + ADD COLUMN user_touched binary(14) NOT NULL default ''; |
| 41 | 41 | UPDATE /*$wgDBprefix*/user |
| 42 | 42 | SET user_touched=NOW()+0; |
| Index: trunk/phase3/maintenance/archives/patch-rc_type.sql |
| — | — | @@ -1,8 +1,8 @@ |
| 2 | 2 | -- recentchanges improvements -- |
| 3 | 3 | |
| 4 | 4 | ALTER TABLE /*$wgDBprefix*/recentchanges |
| 5 | | - ADD rc_type tinyint(3) unsigned NOT NULL default '0', |
| 6 | | - ADD rc_moved_to_ns tinyint(3) unsigned NOT NULL default '0', |
| | 5 | + ADD rc_type tinyint unsigned NOT NULL default '0', |
| | 6 | + ADD rc_moved_to_ns tinyint unsigned NOT NULL default '0', |
| 7 | 7 | ADD rc_moved_to_title varchar(255) binary NOT NULL default ''; |
| 8 | 8 | |
| 9 | 9 | UPDATE /*$wgDBprefix*/recentchanges SET rc_type=1 WHERE rc_new; |
| Index: trunk/phase3/maintenance/archives/patch-log_deleted.sql |
| — | — | @@ -1,3 +1,3 @@ |
| 2 | 2 | -- Adding ar_deleted field for revisiondelete |
| 3 | 3 | ALTER TABLE /*$wgDBprefix*/logging |
| 4 | | - ADD log_deleted tinyint(1) unsigned NOT NULL default '0'; |
| \ No newline at end of file |
| | 4 | + ADD log_deleted tinyint unsigned NOT NULL default '0'; |
| Index: trunk/phase3/maintenance/archives/patch-job.sql |
| — | — | @@ -1,10 +1,10 @@ |
| 2 | 2 | |
| 3 | 3 | -- Jobs performed by parallel apache threads or a command-line daemon |
| 4 | 4 | CREATE TABLE /*$wgDBprefix*/job ( |
| 5 | | - job_id int(9) unsigned NOT NULL auto_increment, |
| | 5 | + job_id int unsigned NOT NULL auto_increment, |
| 6 | 6 | |
| 7 | 7 | -- Command name, currently only refreshLinks is defined |
| 8 | | - job_cmd varchar(255) NOT NULL default '', |
| | 8 | + job_cmd varbinary(60) NOT NULL default '', |
| 9 | 9 | |
| 10 | 10 | -- Namespace and title to act on |
| 11 | 11 | -- Should be 0 and '' if the command does not operate on a title |
| Index: trunk/phase3/maintenance/archives/patch-img_width.sql |
| — | — | @@ -4,15 +4,15 @@ |
| 5 | 5 | -- column is no longer used and has therefore be removed from this patch |
| 6 | 6 | |
| 7 | 7 | ALTER TABLE /*$wgDBprefix*/image ADD ( |
| 8 | | - img_width int(5) NOT NULL default 0, |
| 9 | | - img_height int(5) NOT NULL default 0, |
| 10 | | - img_bits int(5) NOT NULL default 0 |
| | 8 | + img_width int NOT NULL default 0, |
| | 9 | + img_height int NOT NULL default 0, |
| | 10 | + img_bits int NOT NULL default 0 |
| 11 | 11 | ); |
| 12 | 12 | |
| 13 | 13 | ALTER TABLE /*$wgDBprefix*/oldimage ADD ( |
| 14 | | - oi_width int(5) NOT NULL default 0, |
| 15 | | - oi_height int(5) NOT NULL default 0, |
| 16 | | - oi_bits int(3) NOT NULL default 0 |
| | 14 | + oi_width int NOT NULL default 0, |
| | 15 | + oi_height int NOT NULL default 0, |
| | 16 | + oi_bits int NOT NULL default 0 |
| 17 | 17 | ); |
| 18 | 18 | |
| 19 | 19 | |
| Index: trunk/phase3/maintenance/archives/patch-user_groups.sql |
| — | — | @@ -8,7 +8,7 @@ |
| 9 | 9 | -- |
| 10 | 10 | CREATE TABLE /*$wgDBprefix*/user_groups ( |
| 11 | 11 | -- Key to user_id |
| 12 | | - ug_user int(5) unsigned NOT NULL default '0', |
| | 12 | + ug_user int unsigned NOT NULL default '0', |
| 13 | 13 | |
| 14 | 14 | -- Group names are short symbolic string keys. |
| 15 | 15 | -- The set of group names is open-ended, though in practice |
| — | — | @@ -18,7 +18,7 @@ |
| 19 | 19 | -- with particular permissions. A user will have the combined |
| 20 | 20 | -- permissions of any group they're explicitly in, plus |
| 21 | 21 | -- the implicit '*' and 'user' groups. |
| 22 | | - ug_group char(16) NOT NULL default '', |
| | 22 | + ug_group varbinary(16) NOT NULL default '', |
| 23 | 23 | |
| 24 | 24 | PRIMARY KEY (ug_user,ug_group), |
| 25 | 25 | KEY (ug_group) |
| Index: trunk/phase3/maintenance/archives/patch-bot.sql |
| — | — | @@ -7,5 +7,5 @@ |
| 8 | 8 | -- column also added to buildTables.inc |
| 9 | 9 | |
| 10 | 10 | ALTER TABLE /*$wgDBprefix*/recentchanges |
| 11 | | - ADD COLUMN rc_bot tinyint(3) unsigned NOT NULL default '0' |
| | 11 | + ADD COLUMN rc_bot tinyint unsigned NOT NULL default '0' |
| 12 | 12 | AFTER rc_minor; |
| Index: trunk/phase3/maintenance/archives/patch-ipb_anon_only.sql |
| — | — | @@ -10,16 +10,16 @@ |
| 11 | 11 | DROP TABLE IF EXISTS /*$wgDBprefix*/ipblocks_newunique; |
| 12 | 12 | |
| 13 | 13 | CREATE TABLE /*$wgDBprefix*/ipblocks_newunique ( |
| 14 | | - ipb_id int(8) NOT NULL auto_increment, |
| | 14 | + ipb_id int NOT NULL auto_increment, |
| 15 | 15 | ipb_address tinyblob NOT NULL, |
| 16 | | - ipb_user int(8) unsigned NOT NULL default '0', |
| 17 | | - ipb_by int(8) unsigned NOT NULL default '0', |
| | 16 | + ipb_user int unsigned NOT NULL default '0', |
| | 17 | + ipb_by int unsigned NOT NULL default '0', |
| 18 | 18 | ipb_reason tinyblob NOT NULL, |
| 19 | | - ipb_timestamp char(14) binary NOT NULL default '', |
| | 19 | + ipb_timestamp binary(14) NOT NULL default '', |
| 20 | 20 | ipb_auto bool NOT NULL default 0, |
| 21 | 21 | ipb_anon_only bool NOT NULL default 0, |
| 22 | 22 | ipb_create_account bool NOT NULL default 1, |
| 23 | | - ipb_expiry char(14) binary NOT NULL default '', |
| | 23 | + ipb_expiry varbinary(14) NOT NULL default '', |
| 24 | 24 | ipb_range_start tinyblob NOT NULL, |
| 25 | 25 | ipb_range_end tinyblob NOT NULL, |
| 26 | 26 | |
| Index: trunk/phase3/maintenance/archives/patch-archive-rev_id.sql |
| — | — | @@ -3,4 +3,4 @@ |
| 4 | 4 | |
| 5 | 5 | ALTER TABLE /*$wgDBprefix*/archive |
| 6 | 6 | ADD |
| 7 | | - ar_rev_id int(8) unsigned; |
| | 7 | + ar_rev_id int unsigned; |
| Index: trunk/phase3/maintenance/archives/patch-ar_deleted.sql |
| — | — | @@ -1,3 +1,3 @@ |
| 2 | 2 | -- Adding ar_deleted field for revisiondelete |
| 3 | 3 | ALTER TABLE /*$wgDBprefix*/archive |
| 4 | | - ADD ar_deleted tinyint(1) unsigned NOT NULL default '0'; |
| | 4 | + ADD ar_deleted tinyint unsigned NOT NULL default '0'; |
| Index: trunk/phase3/maintenance/archives/patch-querycache.sql |
| — | — | @@ -2,14 +2,14 @@ |
| 3 | 3 | |
| 4 | 4 | CREATE TABLE /*$wgDBprefix*/querycache ( |
| 5 | 5 | -- A key name, generally the base name of of the special page. |
| 6 | | - qc_type char(32) NOT NULL, |
| | 6 | + qc_type varbinary(32) NOT NULL, |
| 7 | 7 | |
| 8 | 8 | -- Some sort of stored value. Sizes, counts... |
| 9 | | - qc_value int(5) unsigned NOT NULL default '0', |
| | 9 | + qc_value int unsigned NOT NULL default '0', |
| 10 | 10 | |
| 11 | 11 | -- Target namespace+title |
| 12 | 12 | qc_namespace int NOT NULL default '0', |
| 13 | | - qc_title char(255) binary NOT NULL default '', |
| | 13 | + qc_title varchar(255) binary NOT NULL default '', |
| 14 | 14 | |
| 15 | 15 | KEY (qc_type,qc_value) |
| 16 | 16 | |
| Index: trunk/phase3/maintenance/archives/patch-objectcache.sql |
| — | — | @@ -1,6 +1,6 @@ |
| 2 | 2 | -- For a few generic cache operations if not using Memcached |
| 3 | 3 | CREATE TABLE /*$wgDBprefix*/objectcache ( |
| 4 | | - keyname char(255) binary not null default '', |
| | 4 | + keyname varbinary(255) binary not null default '', |
| 5 | 5 | value mediumblob, |
| 6 | 6 | exptime datetime, |
| 7 | 7 | unique key (keyname), |
| Index: trunk/phase3/maintenance/archives/patch-interwiki-trans.sql |
| — | — | @@ -1,2 +1,2 @@ |
| 2 | 2 | ALTER TABLE /*$wgDBprefix*/interwiki |
| 3 | | - ADD COLUMN iw_trans TINYINT(1) NOT NULL DEFAULT 0; |
| | 3 | + ADD COLUMN iw_trans TINYINT NOT NULL DEFAULT 0; |
| Index: trunk/phase3/maintenance/archives/patch-user_rights.sql |
| — | — | @@ -7,7 +7,7 @@ |
| 8 | 8 | |
| 9 | 9 | CREATE TABLE /*$wgDBprefix*/user_rights ( |
| 10 | 10 | -- Key to user_id |
| 11 | | - ur_user int(5) unsigned NOT NULL, |
| | 11 | + ur_user int unsigned NOT NULL, |
| 12 | 12 | |
| 13 | 13 | -- Comma-separated list of permission keys |
| 14 | 14 | ur_rights tinyblob NOT NULL, |
| Index: trunk/phase3/maintenance/archives/patch-watchlist.sql |
| — | — | @@ -10,11 +10,11 @@ |
| 11 | 11 | |
| 12 | 12 | DROP TABLE IF EXISTS watchlist2; |
| 13 | 13 | CREATE TABLE watchlist2 ( |
| 14 | | - wl_user int(5) unsigned NOT NULL, |
| 15 | | - wl_namespace tinyint(2) unsigned NOT NULL default '0', |
| | 14 | + wl_user int unsigned NOT NULL, |
| | 15 | + wl_namespace int unsigned NOT NULL default '0', |
| 16 | 16 | wl_title varchar(255) binary NOT NULL default '', |
| 17 | 17 | UNIQUE KEY (wl_user, wl_namespace, wl_title) |
| 18 | | -) TYPE=MyISAM PACK_KEYS=1; |
| | 18 | +) /*$wgDBTableOptions*/; |
| 19 | 19 | |
| 20 | 20 | INSERT INTO watchlist2 (wl_user,wl_namespace,wl_title) |
| 21 | 21 | SELECT DISTINCT wl_user,(cur_namespace | 1) - 1,cur_title |
| Index: trunk/phase3/maintenance/archives/patch-rc_len.sql |
| — | — | @@ -5,5 +5,5 @@ |
| 6 | 6 | -- |
| 7 | 7 | |
| 8 | 8 | ALTER TABLE /*$wgDBprefix*/recentchanges |
| 9 | | - ADD COLUMN rc_old_len int(10), ADD COLUMN rc_new_len int(10); |
| | 9 | + ADD COLUMN rc_old_len int, ADD COLUMN rc_new_len int; |
| 10 | 10 | |
| Index: trunk/phase3/maintenance/archives/patch-oi_metadata.sql |
| — | — | @@ -12,5 +12,5 @@ |
| 13 | 13 | ADD oi_metadata mediumblob NOT NULL, |
| 14 | 14 | ADD oi_media_type ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL, |
| 15 | 15 | ADD oi_major_mime ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart") NOT NULL default "unknown", |
| 16 | | - ADD oi_minor_mime varchar(32) NOT NULL default "unknown", |
| 17 | | - ADD oi_deleted tinyint(1) unsigned NOT NULL default '0'; |
| | 16 | + ADD oi_minor_mime varbinary(32) NOT NULL default "unknown", |
| | 17 | + ADD oi_deleted tinyint unsigned NOT NULL default '0'; |
| Index: trunk/phase3/maintenance/archives/patch-user_registration.sql |
| — | — | @@ -6,4 +6,4 @@ |
| 7 | 7 | ALTER TABLE /*$wgDBprefix*/user |
| 8 | 8 | -- Timestamp of account registration. |
| 9 | 9 | -- Accounts predating this schema addition may contain NULL. |
| 10 | | - ADD user_registration CHAR(14) BINARY; |
| | 10 | + ADD user_registration binary(14); |
| Index: trunk/phase3/maintenance/archives/patch-watchlist-null.sql |
| — | — | @@ -2,7 +2,7 @@ |
| 3 | 3 | -- 2005-08-17 |
| 4 | 4 | |
| 5 | 5 | ALTER TABLE /*$wgDBprefix*/watchlist |
| 6 | | - CHANGE wl_notificationtimestamp wl_notificationtimestamp varchar(14) binary; |
| | 6 | + CHANGE wl_notificationtimestamp wl_notificationtimestamp varbinary(14); |
| 7 | 7 | |
| 8 | 8 | UPDATE /*$wgDBprefix*/watchlist |
| 9 | 9 | SET wl_notificationtimestamp=NULL |
| Index: trunk/phase3/maintenance/archives/patch-ipb_expiry.sql |
| — | — | @@ -1,6 +1,6 @@ |
| 2 | 2 | -- Adds the ipb_expiry field to ipblocks |
| 3 | 3 | |
| 4 | | -ALTER TABLE /*$wgDBprefix*/ipblocks ADD ipb_expiry char(14) binary NOT NULL default ''; |
| | 4 | +ALTER TABLE /*$wgDBprefix*/ipblocks ADD ipb_expiry varbinary(14) NOT NULL default ''; |
| 5 | 5 | |
| 6 | 6 | -- All IP blocks have one day expiry |
| 7 | 7 | UPDATE /*$wgDBprefix*/ipblocks SET ipb_expiry = date_format(date_add(ipb_timestamp,INTERVAL 1 DAY),"%Y%m%d%H%i%s") WHERE ipb_user = 0; |
| Index: trunk/phase3/maintenance/archives/patch-transcache.sql |
| — | — | @@ -1,5 +1,5 @@ |
| 2 | 2 | CREATE TABLE /*$wgDBprefix*/transcache ( |
| 3 | | - tc_url VARCHAR(255) NOT NULL, |
| | 3 | + tc_url varbinary(255) NOT NULL, |
| 4 | 4 | tc_contents TEXT, |
| 5 | 5 | tc_time INT NOT NULL, |
| 6 | 6 | UNIQUE INDEX tc_url_idx(tc_url) |
| Index: trunk/phase3/maintenance/archives/patch-email-notification.sql |
| — | — | @@ -8,4 +8,4 @@ |
| 9 | 9 | -- ("notification flags") at once by clicking the new button on his/her watchlist page. |
| 10 | 10 | -- T. Gries/M. Arndt 11.09.2004 - December 2004 |
| 11 | 11 | |
| 12 | | -ALTER TABLE /*$wgDBprefix*/watchlist ADD (wl_notificationtimestamp varchar(14) binary); |
| | 12 | +ALTER TABLE /*$wgDBprefix*/watchlist ADD (wl_notificationtimestamp varbinary(14)); |
| Index: trunk/phase3/maintenance/archives/patch-img_media_type.sql |
| — | — | @@ -13,5 +13,5 @@ |
| 14 | 14 | -- the minor parts are not required to adher to any standard |
| 15 | 15 | -- but should be consistent throughout the database |
| 16 | 16 | -- see http://www.iana.org/assignments/media-types/ |
| 17 | | - img_minor_mime varchar(32) NOT NULL default "unknown" |
| | 17 | + img_minor_mime varbinary(32) NOT NULL default "unknown" |
| 18 | 18 | ); |
| Index: trunk/phase3/maintenance/archives/patch-fa_deleted.sql |
| — | — | @@ -1,3 +1,3 @@ |
| 2 | 2 | -- Adding fa_deleted field for additional content suppression |
| 3 | 3 | ALTER TABLE /*$wgDBprefix*/filearchive |
| 4 | | - ADD fa_deleted tinyint(1) unsigned NOT NULL default '0'; |
| | 4 | + ADD fa_deleted tinyint unsigned NOT NULL default '0'; |
| Index: trunk/phase3/maintenance/archives/patch-pagelinks.sql |
| — | — | @@ -18,7 +18,7 @@ |
| 19 | 19 | -- |
| 20 | 20 | CREATE TABLE /*$wgDBprefix*/pagelinks ( |
| 21 | 21 | -- Key to the page_id of the page containing the link. |
| 22 | | - pl_from int(8) unsigned NOT NULL default '0', |
| | 22 | + pl_from int unsigned NOT NULL default '0', |
| 23 | 23 | |
| 24 | 24 | -- Key to page_namespace/page_title of the target page. |
| 25 | 25 | -- The target page may or may not exist, and due to renames |
| Index: trunk/phase3/maintenance/archives/patch-langlinks.sql |
| — | — | @@ -1,9 +1,9 @@ |
| 2 | 2 | CREATE TABLE /*$wgDBprefix*/langlinks ( |
| 3 | 3 | -- page_id of the referring page |
| 4 | | - ll_from int(8) unsigned NOT NULL default '0', |
| | 4 | + ll_from int unsigned NOT NULL default '0', |
| 5 | 5 | |
| 6 | 6 | -- Language code of the target |
| 7 | | - ll_lang varchar(10) binary NOT NULL default '', |
| | 7 | + ll_lang varbinary(20) NOT NULL default '', |
| 8 | 8 | |
| 9 | 9 | -- Title of the target, including namespace |
| 10 | 10 | ll_title varchar(255) binary NOT NULL default '', |
| Index: trunk/phase3/maintenance/archives/patch-linktables.sql |
| — | — | @@ -5,13 +5,13 @@ |
| 6 | 6 | DROP TABLE IF EXISTS /*$wgDBprefix*/links; |
| 7 | 7 | CREATE TABLE /*$wgDBprefix*/links ( |
| 8 | 8 | -- Key to the page_id of the page containing the link. |
| 9 | | - l_from int(8) unsigned NOT NULL default '0', |
| | 9 | + l_from int unsigned NOT NULL default '0', |
| 10 | 10 | |
| 11 | 11 | -- Key to the page_id of the link target. |
| 12 | 12 | -- An unfortunate consequence of this is that rename |
| 13 | 13 | -- operations require changing the links entries for |
| 14 | 14 | -- all links to the moved page. |
| 15 | | - l_to int(8) unsigned NOT NULL default '0', |
| | 15 | + l_to int unsigned NOT NULL default '0', |
| 16 | 16 | |
| 17 | 17 | UNIQUE KEY l_from(l_from,l_to), |
| 18 | 18 | KEY (l_to) |
| — | — | @@ -26,7 +26,7 @@ |
| 27 | 27 | DROP TABLE IF EXISTS /*$wgDBprefix*/brokenlinks; |
| 28 | 28 | CREATE TABLE /*$wgDBprefix*/brokenlinks ( |
| 29 | 29 | -- Key to the page_id of the page containing the link. |
| 30 | | - bl_from int(8) unsigned NOT NULL default '0', |
| | 30 | + bl_from int unsigned NOT NULL default '0', |
| 31 | 31 | |
| 32 | 32 | -- Text of the target page title ("namesapce:title"). |
| 33 | 33 | -- Unfortunately this doesn't split the namespace index |
| — | — | @@ -45,7 +45,7 @@ |
| 46 | 46 | DROP TABLE IF EXISTS /*$wgDBprefix*/imagelinks; |
| 47 | 47 | CREATE TABLE /*$wgDBprefix*/imagelinks ( |
| 48 | 48 | -- Key to page_id of the page containing the image / media link. |
| 49 | | - il_from int(8) unsigned NOT NULL default '0', |
| | 49 | + il_from int unsigned NOT NULL default '0', |
| 50 | 50 | |
| 51 | 51 | -- Filename of target image. |
| 52 | 52 | -- This is also the page_title of the file's description page; |
| Index: trunk/phase3/maintenance/archives/patch-rc_deleted.sql |
| — | — | @@ -1,8 +1,8 @@ |
| 2 | 2 | -- Adding rc_deleted field for revisiondelete |
| 3 | 3 | -- Add rc_logid to match log_id |
| 4 | 4 | ALTER TABLE /*$wgDBprefix*/recentchanges |
| 5 | | - ADD rc_deleted tinyint(1) unsigned NOT NULL default '0', |
| 6 | | - ADD rc_logid int(10) unsigned NOT NULL default '0', |
| 7 | | - ADD rc_log_type varchar(255) binary NULL default NULL, |
| 8 | | - ADD rc_log_action varchar(255) binary NULL default NULL, |
| | 5 | + ADD rc_deleted tinyint unsigned NOT NULL default '0', |
| | 6 | + ADD rc_logid int unsigned NOT NULL default '0', |
| | 7 | + ADD rc_log_type varbinary(255) NULL default NULL, |
| | 8 | + ADD rc_log_action varbinary(255) NULL default NULL, |
| 9 | 9 | ADD rc_params BLOB NULL; |
| Index: trunk/phase3/maintenance/archives/patch-rev_len.sql |
| — | — | @@ -1,3 +1,3 @@ |
| 2 | 2 | ALTER TABLE /*$wgDBprefix*/revision |
| 3 | | - ADD rev_len INT(8) UNSIGNED; |
| | 3 | + ADD rev_len INT UNSIGNED; |
| 4 | 4 | |
| Index: trunk/phase3/maintenance/archives/patch-searchindex.sql |
| — | — | @@ -9,7 +9,7 @@ |
| 10 | 10 | DROP TABLE IF EXISTS /*$wgDBprefix*/searchindex; |
| 11 | 11 | CREATE TABLE /*$wgDBprefix*/searchindex ( |
| 12 | 12 | -- Key to page_id |
| 13 | | - si_page int(8) unsigned NOT NULL, |
| | 13 | + si_page int unsigned NOT NULL, |
| 14 | 14 | |
| 15 | 15 | -- Munged version of title |
| 16 | 16 | si_title varchar(255) NOT NULL default '', |
| Index: trunk/phase3/maintenance/archives/patch-trackbacks.sql |
| — | — | @@ -2,7 +2,7 @@ |
| 3 | 3 | tb_id INTEGER AUTO_INCREMENT PRIMARY KEY, |
| 4 | 4 | tb_page INTEGER REFERENCES page(page_id) ON DELETE CASCADE, |
| 5 | 5 | tb_title VARCHAR(255) NOT NULL, |
| 6 | | - tb_url VARCHAR(255) NOT NULL, |
| | 6 | + tb_url BLOB NOT NULL, |
| 7 | 7 | tb_ex TEXT, |
| 8 | 8 | tb_name VARCHAR(255), |
| 9 | 9 | |
| Index: trunk/phase3/maintenance/archives/patch-page_len.sql |
| — | — | @@ -6,7 +6,7 @@ |
| 7 | 7 | -- Added 2005-03-12 |
| 8 | 8 | |
| 9 | 9 | ALTER TABLE /*$wgDBprefix*/page |
| 10 | | - ADD page_len int(8) unsigned NOT NULL, |
| | 10 | + ADD page_len int unsigned NOT NULL, |
| 11 | 11 | ADD INDEX (page_len); |
| 12 | 12 | |
| 13 | 13 | -- Not accurate if upgrading from intermediate |
| Index: trunk/phase3/maintenance/archives/patch-rev_text_id.sql |
| — | — | @@ -11,7 +11,7 @@ |
| 12 | 12 | -- |
| 13 | 13 | |
| 14 | 14 | ALTER TABLE /*$wgDBprefix*/revision |
| 15 | | - ADD rev_text_id int(8) unsigned NOT NULL; |
| | 15 | + ADD rev_text_id int unsigned NOT NULL; |
| 16 | 16 | |
| 17 | 17 | UPDATE /*$wgDBprefix*/revision |
| 18 | 18 | SET rev_text_id=rev_id; |
| Index: trunk/phase3/maintenance/archives/patch-templatelinks.sql |
| — | — | @@ -3,7 +3,7 @@ |
| 4 | 4 | -- |
| 5 | 5 | CREATE TABLE /*$wgDBprefix*/templatelinks ( |
| 6 | 6 | -- Key to the page_id of the page containing the link. |
| 7 | | - tl_from int(8) unsigned NOT NULL default '0', |
| | 7 | + tl_from int unsigned NOT NULL default '0', |
| 8 | 8 | |
| 9 | 9 | -- Key to page_namespace/page_title of the target page. |
| 10 | 10 | -- The target page may or may not exist, and due to renames |
| Index: trunk/phase3/maintenance/archives/patch-user_token.sql |
| — | — | @@ -1,7 +1,7 @@ |
| 2 | 2 | -- user_token patch |
| 3 | 3 | -- 2004-09-23 |
| 4 | 4 | |
| 5 | | -ALTER TABLE /*$wgDBprefix*/user ADD user_token char(32) binary NOT NULL default ''; |
| | 5 | +ALTER TABLE /*$wgDBprefix*/user ADD user_token binary(32) NOT NULL default ''; |
| 6 | 6 | |
| 7 | 7 | UPDATE /*$wgDBprefix*/user SET user_token = concat( |
| 8 | 8 | substring(rand(),3,4), |
| Index: trunk/phase3/maintenance/archives/patch-ss_total_articles.sql |
| — | — | @@ -1,6 +1,6 @@ |
| 2 | 2 | -- Faster statistics, as of 1.4.3 |
| 3 | 3 | |
| 4 | 4 | ALTER TABLE /*$wgDBprefix*/site_stats |
| 5 | | - ADD ss_total_pages bigint(20) default -1, |
| 6 | | - ADD ss_users bigint(20) default -1, |
| 7 | | - ADD ss_admins int(10) default -1; |
| | 5 | + ADD ss_total_pages bigint default -1, |
| | 6 | + ADD ss_users bigint default -1, |
| | 7 | + ADD ss_admins int default -1; |
| Index: trunk/phase3/maintenance/archives/patch-archive-text_id.sql |
| — | — | @@ -11,4 +11,4 @@ |
| 12 | 12 | |
| 13 | 13 | ALTER TABLE /*$wgDBprefix*/archive |
| 14 | 14 | ADD |
| 15 | | - ar_text_id int(8) unsigned; |
| | 15 | + ar_text_id int unsigned; |
| Index: trunk/phase3/maintenance/archives/patch-rev_deleted.sql |
| — | — | @@ -8,4 +8,4 @@ |
| 9 | 9 | -- |
| 10 | 10 | |
| 11 | 11 | ALTER TABLE /*$wgDBprefix*/revision |
| 12 | | - ADD rev_deleted tinyint(1) unsigned NOT NULL default '0'; |
| | 12 | + ADD rev_deleted tinyint unsigned NOT NULL default '0'; |
| Index: trunk/phase3/maintenance/archives/patch-querycachetwo.sql |
| — | — | @@ -2,18 +2,18 @@ |
| 3 | 3 | |
| 4 | 4 | CREATE TABLE /*$wgDBprefix*/querycachetwo ( |
| 5 | 5 | -- A key name, generally the base name of of the special page. |
| 6 | | - qcc_type char(32) NOT NULL, |
| | 6 | + qcc_type varbinary(32) NOT NULL, |
| 7 | 7 | |
| 8 | 8 | -- Some sort of stored value. Sizes, counts... |
| 9 | | - qcc_value int(5) unsigned NOT NULL default '0', |
| | 9 | + qcc_value int unsigned NOT NULL default '0', |
| 10 | 10 | |
| 11 | 11 | -- Target namespace+title |
| 12 | 12 | qcc_namespace int NOT NULL default '0', |
| 13 | | - qcc_title char(255) binary NOT NULL default '', |
| | 13 | + qcc_title varchar(255) binary NOT NULL default '', |
| 14 | 14 | |
| 15 | 15 | -- Target namespace+title2 |
| 16 | 16 | qcc_namespacetwo int NOT NULL default '0', |
| 17 | | - qcc_titletwo char(255) binary NOT NULL default '', |
| | 17 | + qcc_titletwo varchar(255) binary NOT NULL default '', |
| 18 | 18 | |
| 19 | 19 | KEY qcc_type (qcc_type,qcc_value), |
| 20 | 20 | KEY qcc_title (qcc_type,qcc_namespace,qcc_title), |
| Index: trunk/phase3/maintenance/archives/patch-user_email_token.sql |
| — | — | @@ -6,7 +6,7 @@ |
| 7 | 7 | -- |
| 8 | 8 | |
| 9 | 9 | ALTER TABLE /*$wgDBprefix*/user |
| 10 | | - ADD COLUMN user_email_authenticated CHAR(14) BINARY, |
| 11 | | - ADD COLUMN user_email_token CHAR(32) BINARY, |
| 12 | | - ADD COLUMN user_email_token_expires CHAR(14) BINARY, |
| | 10 | + ADD COLUMN user_email_authenticated binary(14), |
| | 11 | + ADD COLUMN user_email_token binary(32), |
| | 12 | + ADD COLUMN user_email_token_expires binary(14), |
| 13 | 13 | ADD INDEX (user_email_token); |
| Index: trunk/phase3/maintenance/archives/patch-logging.sql |
| — | — | @@ -5,11 +5,11 @@ |
| 6 | 6 | -- Symbolic keys for the general log type and the action type |
| 7 | 7 | -- within the log. The output format will be controlled by the |
| 8 | 8 | -- action field, but only the type controls categorization. |
| 9 | | - log_type char(10) NOT NULL default '', |
| 10 | | - log_action char(10) NOT NULL default '', |
| | 9 | + log_type varbinary(10) NOT NULL default '', |
| | 10 | + log_action varbinary(10) NOT NULL default '', |
| 11 | 11 | |
| 12 | 12 | -- Timestamp. Duh. |
| 13 | | - log_timestamp char(14) NOT NULL default '19700101000000', |
| | 13 | + log_timestamp binary(14) NOT NULL default '19700101000000', |
| 14 | 14 | |
| 15 | 15 | -- The user who performed this action; key to user_id |
| 16 | 16 | log_user int unsigned NOT NULL default 0, |
| Index: trunk/phase3/maintenance/archives/patch-redirect.sql |
| — | — | @@ -4,7 +4,7 @@ |
| 5 | 5 | -- |
| 6 | 6 | CREATE TABLE /*$wgDBprefix*/redirect ( |
| 7 | 7 | -- Key to the page_id of the redirect page |
| 8 | | - rd_from int(8) unsigned NOT NULL default '0', |
| | 8 | + rd_from int unsigned NOT NULL default '0', |
| 9 | 9 | |
| 10 | 10 | -- Key to page_namespace/page_title of the target page. |
| 11 | 11 | -- The target page may or may not exist, and due to renames |
| Index: trunk/phase3/maintenance/archives/patch-rename-user_groups-and_rights.sql |
| — | — | @@ -1,9 +1,9 @@ |
| 2 | 2 | |
| 3 | 3 | ALTER TABLE /*$wgDBprefix*/user_groups |
| 4 | | - CHANGE user_id ug_user INT(5) UNSIGNED NOT NULL DEFAULT '0', |
| 5 | | - CHANGE group_id ug_group INT(5) UNSIGNED NOT NULL DEFAULT '0'; |
| | 4 | + CHANGE user_id ug_user INT UNSIGNED NOT NULL DEFAULT '0', |
| | 5 | + CHANGE group_id ug_group INT UNSIGNED NOT NULL DEFAULT '0'; |
| 6 | 6 | |
| 7 | 7 | ALTER TABLE /*$wgDBprefix*/user_rights |
| 8 | | - CHANGE user_id ur_user INT(5) UNSIGNED NOT NULL, |
| | 8 | + CHANGE user_id ur_user INT UNSIGNED NOT NULL, |
| 9 | 9 | CHANGE user_rights ur_rights TINYBLOB NOT NULL; |
| 10 | 10 | |
| Index: trunk/phase3/maintenance/archives/patch-ipb_range_start.sql |
| — | — | @@ -1,7 +1,7 @@ |
| 2 | 2 | -- Add the range handling fields |
| 3 | 3 | ALTER TABLE /*$wgDBprefix*/ipblocks |
| 4 | | - ADD ipb_range_start varchar(32) NOT NULL default '', |
| 5 | | - ADD ipb_range_end varchar(32) NOT NULL default '', |
| | 4 | + ADD ipb_range_start tinyblob NOT NULL default '', |
| | 5 | + ADD ipb_range_end tinyblob NOT NULL default '', |
| 6 | 6 | ADD INDEX ipb_range (ipb_range_start(8), ipb_range_end(8)); |
| 7 | 7 | |
| 8 | 8 | |
| Index: trunk/phase3/maintenance/archives/patch-usernewtalk.sql |
| — | — | @@ -5,11 +5,11 @@ |
| 6 | 6 | --- required and therefore dropped. |
| 7 | 7 | |
| 8 | 8 | CREATE TABLE /*$wgDBprefix*/user_newtalk ( |
| 9 | | - user_id int(5) NOT NULL default '0', |
| 10 | | - user_ip varchar(40) NOT NULL default '', |
| | 9 | + user_id int NOT NULL default '0', |
| | 10 | + user_ip varbinary(40) NOT NULL default '', |
| 11 | 11 | KEY user_id (user_id), |
| 12 | 12 | KEY user_ip (user_ip) |
| 13 | | -) TYPE=MyISAM; |
| | 13 | +) /*$wgDBTableOptions*/; |
| 14 | 14 | |
| 15 | 15 | INSERT INTO |
| 16 | 16 | /*$wgDBprefix*/user_newtalk (user_id, user_ip) |
| Index: trunk/phase3/maintenance/archives/patch-interwiki.sql |
| — | — | @@ -4,12 +4,12 @@ |
| 5 | 5 | |
| 6 | 6 | CREATE TABLE /*$wgDBprefix*/interwiki ( |
| 7 | 7 | -- The interwiki prefix, (e.g. "Meatball", or the language prefix "de") |
| 8 | | - iw_prefix char(32) NOT NULL, |
| | 8 | + iw_prefix varchar(32) NOT NULL, |
| 9 | 9 | |
| 10 | 10 | -- The URL of the wiki, with "$1" as a placeholder for an article name. |
| 11 | 11 | -- Any spaces in the name will be transformed to underscores before |
| 12 | 12 | -- insertion. |
| 13 | | - iw_url char(127) NOT NULL, |
| | 13 | + iw_url blob NOT NULL, |
| 14 | 14 | |
| 15 | 15 | -- A boolean value indicating whether the wiki is in this project |
| 16 | 16 | -- (used, for example, to detect redirect loops) |
| Index: trunk/phase3/maintenance/archives/patch-querycacheinfo.sql |
| — | — | @@ -2,10 +2,10 @@ |
| 3 | 3 | |
| 4 | 4 | -- Special page name |
| 5 | 5 | -- Corresponds to a qc_type value |
| 6 | | - qci_type varchar(32) NOT NULL default '', |
| | 6 | + qci_type varbinary(32) NOT NULL default '', |
| 7 | 7 | |
| 8 | 8 | -- Timestamp of last update |
| 9 | | - qci_timestamp char(14) NOT NULL default '19700101000000', |
| | 9 | + qci_timestamp binary(14) NOT NULL default '19700101000000', |
| 10 | 10 | |
| 11 | 11 | UNIQUE KEY ( qci_type ) |
| 12 | 12 | |
| Index: trunk/phase3/maintenance/archives/patch-ipblocks.sql |
| — | — | @@ -1,6 +1,6 @@ |
| 2 | 2 | -- For auto-expiring blocks -- |
| 3 | 3 | |
| 4 | 4 | ALTER TABLE /*$wgDBprefix*/ipblocks |
| 5 | | - ADD ipb_auto tinyint(1) NOT NULL default '0', |
| 6 | | - ADD ipb_id int(8) NOT NULL auto_increment, |
| | 5 | + ADD ipb_auto tinyint NOT NULL default '0', |
| | 6 | + ADD ipb_id int NOT NULL auto_increment, |
| 7 | 7 | ADD PRIMARY KEY (ipb_id); |