| Index: trunk/phase3/maintenance/archives/patch-rc_type.sql |
| — | — | @@ -3,7 +3,7 @@ |
| 4 | 4 | ALTER TABLE /*$wgDBprefix*/recentchanges |
| 5 | 5 | ADD rc_type tinyint unsigned NOT NULL default '0', |
| 6 | 6 | ADD rc_moved_to_ns tinyint unsigned NOT NULL default '0', |
| 7 | | - ADD rc_moved_to_title varchar(255) binary NOT NULL default ''; |
| | 7 | + ADD rc_moved_to_title varbinary(255) NOT NULL default ''; |
| 8 | 8 | |
| 9 | 9 | UPDATE /*$wgDBprefix*/recentchanges SET rc_type=1 WHERE rc_new; |
| 10 | 10 | UPDATE /*$wgDBprefix*/recentchanges SET rc_type=3 WHERE rc_namespace=4 AND (rc_title='Deletion_log' OR rc_title='Upload_log'); |
| Index: trunk/phase3/maintenance/archives/patch-job.sql |
| — | — | @@ -9,7 +9,7 @@ |
| 10 | 10 | -- Namespace and title to act on |
| 11 | 11 | -- Should be 0 and '' if the command does not operate on a title |
| 12 | 12 | job_namespace int NOT NULL, |
| 13 | | - job_title varchar(255) binary NOT NULL, |
| | 13 | + job_title varbinary(255) NOT NULL, |
| 14 | 14 | |
| 15 | 15 | -- Any other parameters to the command |
| 16 | 16 | -- Stored as a PHP serialized array, or an empty string if there are no parameters |
| Index: trunk/phase3/maintenance/archives/patch-interwiki.sql |
| — | — | @@ -4,7 +4,7 @@ |
| 5 | 5 | |
| 6 | 6 | CREATE TABLE /*$wgDBprefix*/interwiki ( |
| 7 | 7 | -- The interwiki prefix, (e.g. "Meatball", or the language prefix "de") |
| 8 | | - iw_prefix varchar(32) NOT NULL, |
| | 8 | + iw_prefix varbinary(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 |
| Index: trunk/phase3/maintenance/archives/patch-logging-title.sql |
| — | — | @@ -3,4 +3,4 @@ |
| 4 | 4 | |
| 5 | 5 | ALTER TABLE /*$wgDBprefix*/logging |
| 6 | 6 | CHANGE COLUMN log_title |
| 7 | | - log_title varchar(255) binary NOT NULL default ''; |
| | 7 | + log_title varbinary(255) NOT NULL default ''; |
| Index: trunk/phase3/maintenance/archives/patch-categorylinks.sql |
| — | — | @@ -10,7 +10,7 @@ |
| 11 | 11 | -- Name of the category. |
| 12 | 12 | -- This is also the page_title of the category's description page; |
| 13 | 13 | -- all such pages are in namespace 14 (NS_CATEGORY). |
| 14 | | - cl_to varchar(255) binary NOT NULL default '', |
| | 14 | + cl_to varbinary(255) NOT NULL default '', |
| 15 | 15 | |
| 16 | 16 | -- The title of the linking page, or an optional override |
| 17 | 17 | -- to determine sort order. Sorting is by binary order, which |
| — | — | @@ -19,7 +19,7 @@ |
| 20 | 20 | -- |
| 21 | 21 | -- Truncate so that the cl_sortkey key fits in 1000 bytes |
| 22 | 22 | -- (MyISAM 5 with server_character_set=utf8) |
| 23 | | - cl_sortkey varchar(70) binary NOT NULL default '', |
| | 23 | + cl_sortkey varbinary(70) NOT NULL default '', |
| 24 | 24 | |
| 25 | 25 | -- This isn't really used at present. Provided for an optional |
| 26 | 26 | -- sorting method by approximate addition time. |
| Index: trunk/phase3/maintenance/archives/patch-change_tag.sql |
| — | — | @@ -4,7 +4,7 @@ |
| 5 | 5 | ct_rc_id int NULL, |
| 6 | 6 | ct_log_id int NULL, |
| 7 | 7 | ct_rev_id int NULL, |
| 8 | | - ct_tag varchar(255) NOT NULL, |
| | 8 | + ct_tag varbinary(255) NOT NULL, |
| 9 | 9 | ct_params BLOB NULL |
| 10 | 10 | ) /*$wgDBTableOptions*/; |
| 11 | 11 | |
| — | — | @@ -28,5 +28,5 @@ |
| 29 | 29 | |
| 30 | 30 | |
| 31 | 31 | CREATE TABLE /*_*/valid_tag ( |
| 32 | | - vt_tag varchar(255) NOT NULL PRIMARY KEY |
| | 32 | + vt_tag varbinary(255) NOT NULL PRIMARY KEY |
| 33 | 33 | ) /*$wgDBTableOptions*/; |
| Index: trunk/phase3/maintenance/archives/patch-profiling.sql |
| — | — | @@ -5,7 +5,7 @@ |
| 6 | 6 | pf_count int NOT NULL default 0, |
| 7 | 7 | pf_time float NOT NULL default 0, |
| 8 | 8 | pf_memory float NOT NULL default 0, |
| 9 | | - pf_name varchar(255) NOT NULL default '', |
| 10 | | - pf_server varchar(30) NOT NULL default '', |
| | 9 | + pf_name varbinary(255) NOT NULL default '', |
| | 10 | + pf_server varbinary(30) NOT NULL default '', |
| 11 | 11 | UNIQUE KEY pf_name_server (pf_name, pf_server) |
| 12 | 12 | ) ENGINE=HEAP; |
| Index: trunk/phase3/maintenance/archives/patch-searchindex.sql |
| — | — | @@ -12,7 +12,7 @@ |
| 13 | 13 | si_page int unsigned NOT NULL, |
| 14 | 14 | |
| 15 | 15 | -- Munged version of title |
| 16 | | - si_title varchar(255) NOT NULL default '', |
| | 16 | + si_title varbinary(255) NOT NULL default '', |
| 17 | 17 | |
| 18 | 18 | -- Munged version of body text |
| 19 | 19 | si_text mediumtext NOT NULL, |
| Index: trunk/phase3/maintenance/archives/patch-user-realname.sql |
| — | — | @@ -2,4 +2,4 @@ |
| 3 | 3 | -- used for author attribution or other places that real names matter. |
| 4 | 4 | |
| 5 | 5 | ALTER TABLE user |
| 6 | | - ADD (user_real_name varchar(255) binary NOT NULL default ''); |
| | 6 | + ADD (user_real_name varbinary(255) NOT NULL default ''); |
| Index: trunk/phase3/maintenance/archives/patch-redirect.sql |
| — | — | @@ -11,7 +11,7 @@ |
| 12 | 12 | -- and deletions may refer to different page records as time |
| 13 | 13 | -- goes by. |
| 14 | 14 | rd_namespace int NOT NULL default '0', |
| 15 | | - rd_title varchar(255) binary NOT NULL default '', |
| | 15 | + rd_title varbinary(255) NOT NULL default '', |
| 16 | 16 | |
| 17 | 17 | PRIMARY KEY rd_from (rd_from), |
| 18 | 18 | KEY rd_ns_title (rd_namespace,rd_title,rd_from) |
| Index: trunk/phase3/maintenance/archives/patch-testrun.sql |
| — | — | @@ -13,7 +13,7 @@ |
| 14 | 14 | create table /*$wgDBprefix*/testrun ( |
| 15 | 15 | tr_id int not null auto_increment, |
| 16 | 16 | |
| 17 | | - tr_date char(14) binary, |
| | 17 | + tr_date binary(14), |
| 18 | 18 | tr_mw_version blob, |
| 19 | 19 | tr_php_version blob, |
| 20 | 20 | tr_db_version blob, |
| — | — | @@ -24,7 +24,7 @@ |
| 25 | 25 | |
| 26 | 26 | create table /*$wgDBprefix*/testitem ( |
| 27 | 27 | ti_run int not null, |
| 28 | | - ti_name varchar(255), |
| | 28 | + ti_name varbinary(255), |
| 29 | 29 | ti_success bool, |
| 30 | 30 | |
| 31 | 31 | unique key (ti_run, ti_name), |
| Index: trunk/phase3/maintenance/archives/patch-iwlinks.sql |
| — | — | @@ -9,7 +9,7 @@ |
| 10 | 10 | iwl_prefix varbinary(20) NOT NULL default '', |
| 11 | 11 | |
| 12 | 12 | -- Title of the target, including namespace |
| 13 | | - iwl_title varchar(255) binary NOT NULL default '' |
| | 13 | + iwl_title varbinary(255) NOT NULL default '' |
| 14 | 14 | ) /*$wgDBTableOptions*/; |
| 15 | 15 | |
| 16 | 16 | CREATE UNIQUE INDEX /*i*/iwl_from ON /*_*/iwlinks (iwl_from, iwl_prefix, iwl_title); |
| Index: trunk/phase3/maintenance/archives/patch-updatelog.sql |
| — | — | @@ -1,4 +1,4 @@ |
| 2 | 2 | CREATE TABLE /*$wgDBprefix*/updatelog ( |
| 3 | | - ul_key varchar(255) NOT NULL, |
| | 3 | + ul_key varbinary(255) NOT NULL, |
| 4 | 4 | PRIMARY KEY (ul_key) |
| 5 | 5 | ) /*$wgDBTableOptions*/; |
| Index: trunk/phase3/maintenance/archives/patch-logging.sql |
| — | — | @@ -17,10 +17,10 @@ |
| 18 | 18 | -- Key to the page affected. Where a user is the target, |
| 19 | 19 | -- this will point to the user page. |
| 20 | 20 | log_namespace int NOT NULL default 0, |
| 21 | | - log_title varchar(255) binary NOT NULL default '', |
| | 21 | + log_title varbinary(255) NOT NULL default '', |
| 22 | 22 | |
| 23 | 23 | -- Freeform text. Interpreted as edit history comments. |
| 24 | | - log_comment varchar(255) NOT NULL default '', |
| | 24 | + log_comment varbinary(255) NOT NULL default '', |
| 25 | 25 | |
| 26 | 26 | -- LF separated list of miscellaneous parameters |
| 27 | 27 | log_params blob NOT NULL, |
| Index: trunk/phase3/maintenance/archives/patch-linktables.sql |
| — | — | @@ -31,7 +31,7 @@ |
| 32 | 32 | -- Text of the target page title ("namesapce:title"). |
| 33 | 33 | -- Unfortunately this doesn't split the namespace index |
| 34 | 34 | -- key and therefore can't easily be joined to anything. |
| 35 | | - bl_to varchar(255) binary NOT NULL default '', |
| | 35 | + bl_to varbinary(255) NOT NULL default '', |
| 36 | 36 | UNIQUE KEY bl_from(bl_from,bl_to), |
| 37 | 37 | KEY (bl_to) |
| 38 | 38 | |
| — | — | @@ -50,7 +50,7 @@ |
| 51 | 51 | -- Filename of target image. |
| 52 | 52 | -- This is also the page_title of the file's description page; |
| 53 | 53 | -- all such pages are in namespace 6 (NS_FILE). |
| 54 | | - il_to varchar(255) binary NOT NULL default '', |
| | 54 | + il_to varbinary(255) NOT NULL default '', |
| 55 | 55 | |
| 56 | 56 | UNIQUE KEY il_from(il_from,il_to), |
| 57 | 57 | KEY (il_to) |
| Index: trunk/phase3/maintenance/archives/patch-rd_interwiki.sql |
| — | — | @@ -1,6 +1,6 @@ |
| 2 | 2 | -- Add interwiki and fragment columns to redirect table |
| 3 | 3 | |
| 4 | 4 | ALTER TABLE /*$wgDBprefix*/redirect |
| 5 | | - ADD rd_interwiki varchar(32) default NULL, |
| 6 | | - ADD rd_fragment varchar(255) binary default NULL; |
| | 5 | + ADD rd_interwiki varbinary(32) default NULL, |
| | 6 | + ADD rd_fragment varbinary(255) default NULL; |
| 7 | 7 | |
| Index: trunk/phase3/maintenance/archives/patch-log_search.sql |
| — | — | @@ -2,7 +2,7 @@ |
| 3 | 3 | -- The type of ID (rev ID, log ID, rev timestamp, username) |
| 4 | 4 | ls_field varbinary(32) NOT NULL, |
| 5 | 5 | -- The value of the ID |
| 6 | | - ls_value varchar(255) NOT NULL, |
| | 6 | + ls_value varbinary(255) NOT NULL, |
| 7 | 7 | -- Key to log_id |
| 8 | 8 | ls_log_id int unsigned NOT NULL default 0 |
| 9 | 9 | ) /*$wgDBTableOptions*/; |
| Index: trunk/phase3/maintenance/archives/patch-val_ip.sql |
| — | — | @@ -1,4 +1,4 @@ |
| 2 | 2 | -- Column added 2005-05-24 |
| 3 | 3 | |
| 4 | 4 | ALTER TABLE /*$wgDBprefix*/validate |
| 5 | | - ADD COLUMN val_ip varchar(20) NOT NULL default ''; |
| | 5 | + ADD COLUMN val_ip varbinary(20) NOT NULL default ''; |
| Index: trunk/phase3/maintenance/archives/patch-category.sql |
| — | — | @@ -1,7 +1,7 @@ |
| 2 | 2 | CREATE TABLE /*$wgDBprefix*/category ( |
| 3 | 3 | cat_id int unsigned NOT NULL auto_increment, |
| 4 | 4 | |
| 5 | | - cat_title varchar(255) binary NOT NULL, |
| | 5 | + cat_title varbinary(255) NOT NULL, |
| 6 | 6 | |
| 7 | 7 | cat_pages int signed NOT NULL default 0, |
| 8 | 8 | cat_subcats int signed NOT NULL default 0, |
| Index: trunk/phase3/maintenance/archives/patch-restructure.sql |
| — | — | @@ -12,7 +12,7 @@ |
| 13 | 13 | CREATE TABLE /*$wgDBprefix*/page ( |
| 14 | 14 | page_id int unsigned NOT NULL auto_increment, |
| 15 | 15 | page_namespace tinyint NOT NULL, |
| 16 | | - page_title varchar(255) binary NOT NULL, |
| | 16 | + page_title varbinary(255) NOT NULL, |
| 17 | 17 | page_restrictions tinyblob NOT NULL, |
| 18 | 18 | page_counter bigint unsigned NOT NULL default '0', |
| 19 | 19 | page_is_redirect tinyint unsigned NOT NULL default '0', |
| — | — | @@ -33,7 +33,7 @@ |
| 34 | 34 | rev_page int unsigned NOT NULL, |
| 35 | 35 | rev_comment tinyblob NOT NULL, |
| 36 | 36 | rev_user int unsigned NOT NULL default '0', |
| 37 | | - rev_user_text varchar(255) binary NOT NULL default '', |
| | 37 | + rev_user_text varbinary(255) NOT NULL default '', |
| 38 | 38 | rev_timestamp binary(14) NOT NULL default '', |
| 39 | 39 | rev_minor_edit tinyint unsigned NOT NULL default '0', |
| 40 | 40 | rev_deleted tinyint unsigned NOT NULL default '0', |
| Index: trunk/phase3/maintenance/archives/patch-iw_api_and_wikiid.sql |
| — | — | @@ -5,5 +5,5 @@ |
| 6 | 6 | ALTER TABLE /*_*/interwiki |
| 7 | 7 | ADD iw_api BLOB NOT NULL; |
| 8 | 8 | ALTER TABLE /*_*/interwiki |
| 9 | | - ADD iw_wikiid varchar(64) NOT NULL; |
| | 9 | + ADD iw_wikiid varbinary(64) NOT NULL; |
| 10 | 10 | |
| Index: trunk/phase3/maintenance/archives/patch-templatelinks.sql |
| — | — | @@ -10,7 +10,7 @@ |
| 11 | 11 | -- and deletions may refer to different page records as time |
| 12 | 12 | -- goes by. |
| 13 | 13 | tl_namespace int NOT NULL default '0', |
| 14 | | - tl_title varchar(255) binary NOT NULL default '', |
| | 14 | + tl_title varbinary(255) NOT NULL default '', |
| 15 | 15 | |
| 16 | 16 | UNIQUE KEY tl_from(tl_from,tl_namespace,tl_title), |
| 17 | 17 | KEY (tl_namespace,tl_title) |
| Index: trunk/phase3/maintenance/archives/patch-external_user.sql |
| — | — | @@ -3,7 +3,7 @@ |
| 4 | 4 | eu_local_id int unsigned NOT NULL PRIMARY KEY, |
| 5 | 5 | |
| 6 | 6 | -- Some opaque identifier provided by the external database |
| 7 | | - eu_external_id varchar(255) binary NOT NULL |
| | 7 | + eu_external_id varbinary(255) NOT NULL |
| 8 | 8 | ) /*$wgDBTableOptions*/; |
| 9 | 9 | |
| 10 | 10 | CREATE UNIQUE INDEX /*i*/eu_external_id ON /*_*/external_user (eu_external_id); |
| Index: trunk/phase3/maintenance/archives/patch-categorylinks-better-collation.sql |
| — | — | @@ -10,7 +10,7 @@ |
| 11 | 11 | -- sure to also change the check in LinksUpdate.php. |
| 12 | 12 | ALTER TABLE /*$wgDBprefix*/categorylinks |
| 13 | 13 | CHANGE COLUMN cl_sortkey cl_sortkey varbinary(230) NOT NULL default '', |
| 14 | | - ADD COLUMN cl_sortkey_prefix varchar(255) binary NOT NULL default '', |
| | 14 | + ADD COLUMN cl_sortkey_prefix varbinary(255) NOT NULL default '', |
| 15 | 15 | ADD COLUMN cl_collation varbinary(32) NOT NULL default '', |
| 16 | 16 | ADD COLUMN cl_type ENUM('page', 'subcat', 'file') NOT NULL default 'page', |
| 17 | 17 | ADD INDEX (cl_collation), |
| Index: trunk/phase3/maintenance/archives/patch-querycachetwo.sql |
| — | — | @@ -9,11 +9,11 @@ |
| 10 | 10 | |
| 11 | 11 | -- Target namespace+title |
| 12 | 12 | qcc_namespace int NOT NULL default '0', |
| 13 | | - qcc_title varchar(255) binary NOT NULL default '', |
| | 13 | + qcc_title varbinary(255) NOT NULL default '', |
| 14 | 14 | |
| 15 | 15 | -- Target namespace+title2 |
| 16 | 16 | qcc_namespacetwo int NOT NULL default '0', |
| 17 | | - qcc_titletwo varchar(255) binary NOT NULL default '', |
| | 17 | + qcc_titletwo varbinary(255) 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-validate.sql |
| — | — | @@ -7,7 +7,7 @@ |
| 8 | 8 | `val_revision` int(11) unsigned NOT NULL default '0', |
| 9 | 9 | `val_type` int(11) unsigned NOT NULL default '0', |
| 10 | 10 | `val_value` int(11) default '0', |
| 11 | | - `val_comment` varchar(255) NOT NULL default '', |
| 12 | | - `val_ip` varchar(20) NOT NULL default '', |
| | 11 | + `val_comment` varbinary(255) NOT NULL default '', |
| | 12 | + `val_ip` varbinary(20) NOT NULL default '', |
| 13 | 13 | KEY `val_user` (`val_user`,`val_revision`) |
| 14 | 14 | ) /*$wgDBTableOptions*/; |
| Index: trunk/phase3/maintenance/archives/patch-pt_title-encoding.sql |
| — | — | @@ -2,4 +2,4 @@ |
| 3 | 3 | -- This might cause failures with JOINs, and could protect the wrong pages |
| 4 | 4 | -- with different case variants or unrelated UTF-8 chars. |
| 5 | 5 | ALTER TABLE /*$wgDBprefix*/protected_titles |
| 6 | | - CHANGE COLUMN pt_title pt_title varchar(255) binary NOT NULL; |
| | 6 | + CHANGE COLUMN pt_title pt_title varbinary(255) NOT NULL; |
| Index: trunk/phase3/maintenance/archives/patch-fix-il_from.sql |
| — | — | @@ -3,7 +3,7 @@ |
| 4 | 4 | RENAME TABLE /*_*/imagelinks TO /*_*/imagelinks_old; |
| 5 | 5 | CREATE TABLE /*_*/imagelinks ( |
| 6 | 6 | il_from int unsigned NOT NULL default 0, |
| 7 | | - il_to varchar(255) binary NOT NULL default '' |
| | 7 | + il_to varbinary(255) NOT NULL default '' |
| 8 | 8 | ) /*$wgDBTableOptions*/; |
| 9 | 9 | |
| 10 | 10 | CREATE UNIQUE INDEX /*i*/il_from ON /*_*/imagelinks (il_from,il_to); |
| Index: trunk/phase3/maintenance/archives/patch-protected_titles.sql |
| — | — | @@ -1,7 +1,7 @@ |
| 2 | 2 | -- Protected titles - nonexistent pages that have been protected |
| 3 | 3 | CREATE TABLE /*$wgDBprefix*/protected_titles ( |
| 4 | 4 | pt_namespace int NOT NULL, |
| 5 | | - pt_title varchar(255) binary NOT NULL, |
| | 5 | + pt_title varbinary(255) NOT NULL, |
| 6 | 6 | pt_user int unsigned NOT NULL, |
| 7 | 7 | pt_reason tinyblob, |
| 8 | 8 | pt_timestamp binary(14) NOT NULL, |
| Index: trunk/phase3/maintenance/archives/patch-querycache.sql |
| — | — | @@ -9,7 +9,7 @@ |
| 10 | 10 | |
| 11 | 11 | -- Target namespace+title |
| 12 | 12 | qc_namespace int NOT NULL default '0', |
| 13 | | - qc_title varchar(255) binary NOT NULL default '', |
| | 13 | + qc_title varbinary(255) NOT NULL default '', |
| 14 | 14 | |
| 15 | 15 | KEY (qc_type,qc_value) |
| 16 | 16 | |
| Index: trunk/phase3/maintenance/archives/patch-ipb_by_text.sql |
| — | — | @@ -2,7 +2,7 @@ |
| 3 | 3 | -- Required for crosswiki blocks. |
| 4 | 4 | |
| 5 | 5 | ALTER TABLE /*$wgDBprefix*/ipblocks |
| 6 | | - ADD ipb_by_text varchar(255) binary NOT NULL default ''; |
| | 6 | + ADD ipb_by_text varbinary(255) NOT NULL default ''; |
| 7 | 7 | |
| 8 | 8 | UPDATE /*$wgDBprefix*/ipblocks |
| 9 | 9 | JOIN /*$wgDBprefix*/user ON ipb_by = user_id |
| Index: trunk/phase3/maintenance/archives/patch-log_user_text.sql |
| — | — | @@ -1,5 +1,5 @@ |
| 2 | 2 | ALTER TABLE /*$wgDBprefix*/logging |
| 3 | | - ADD log_user_text varchar(255) binary NOT NULL default '', |
| | 3 | + ADD log_user_text varbinary(255) NOT NULL default '', |
| 4 | 4 | ADD log_page int unsigned NULL, |
| 5 | 5 | CHANGE log_type log_type varbinary(32) NOT NULL, |
| 6 | 6 | CHANGE log_action log_action varbinary(32) NOT NULL; |
| Index: trunk/phase3/maintenance/archives/patch-l10n_cache.sql |
| — | — | @@ -1,7 +1,7 @@ |
| 2 | 2 | -- Table for storing localisation data |
| 3 | 3 | CREATE TABLE /*_*/l10n_cache ( |
| 4 | 4 | lc_lang varbinary(32) NOT NULL, |
| 5 | | - lc_key varchar(255) NOT NULL, |
| | 5 | + lc_key varbinary(255) NOT NULL, |
| 6 | 6 | lc_value mediumblob NOT NULL |
| 7 | 7 | ) /*$wgDBTableOptions*/; |
| 8 | 8 | CREATE INDEX /*i*/lc_lang_key ON /*_*/l10n_cache (lc_lang, lc_key); |
| Index: trunk/phase3/maintenance/archives/patch-watchlist.sql |
| — | — | @@ -12,7 +12,7 @@ |
| 13 | 13 | CREATE TABLE watchlist2 ( |
| 14 | 14 | wl_user int unsigned NOT NULL, |
| 15 | 15 | wl_namespace int unsigned NOT NULL default '0', |
| 16 | | - wl_title varchar(255) binary NOT NULL default '', |
| | 16 | + wl_title varbinary(255) NOT NULL default '', |
| 17 | 17 | UNIQUE KEY (wl_user, wl_namespace, wl_title) |
| 18 | 18 | ) /*$wgDBTableOptions*/; |
| 19 | 19 | |
| Index: trunk/phase3/maintenance/archives/patch-pagelinks.sql |
| — | — | @@ -25,7 +25,7 @@ |
| 26 | 26 | -- and deletions may refer to different page records as time |
| 27 | 27 | -- goes by. |
| 28 | 28 | pl_namespace int NOT NULL default '0', |
| 29 | | - pl_title varchar(255) binary NOT NULL default '', |
| | 29 | + pl_title varbinary(255) NOT NULL default '', |
| 30 | 30 | |
| 31 | 31 | UNIQUE KEY pl_from(pl_from,pl_namespace,pl_title), |
| 32 | 32 | KEY (pl_namespace,pl_title) |
| Index: trunk/phase3/maintenance/archives/patch-filearchive.sql |
| — | — | @@ -6,10 +6,10 @@ |
| 7 | 7 | fa_id int not null auto_increment, |
| 8 | 8 | |
| 9 | 9 | -- Original base filename; key to image.img_name, page.page_title, etc |
| 10 | | - fa_name varchar(255) binary NOT NULL default '', |
| | 10 | + fa_name varbinary(255) NOT NULL default '', |
| 11 | 11 | |
| 12 | 12 | -- Filename of archived file, if an old revision |
| 13 | | - fa_archive_name varchar(255) binary default '', |
| | 13 | + fa_archive_name varbinary(255) default '', |
| 14 | 14 | |
| 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; |
| — | — | @@ -39,7 +39,7 @@ |
| 40 | 40 | fa_minor_mime varbinary(32) default "unknown", |
| 41 | 41 | fa_description tinyblob, |
| 42 | 42 | fa_user int unsigned default '0', |
| 43 | | - fa_user_text varchar(255) binary default '', |
| | 43 | + fa_user_text varbinary(255) default '', |
| 44 | 44 | fa_timestamp binary(14) default '', |
| 45 | 45 | |
| 46 | 46 | PRIMARY KEY (fa_id), |
| Index: trunk/phase3/maintenance/archives/patch-langlinks.sql |
| — | — | @@ -6,7 +6,7 @@ |
| 7 | 7 | ll_lang varbinary(20) NOT NULL default '', |
| 8 | 8 | |
| 9 | 9 | -- Title of the target, including namespace |
| 10 | | - ll_title varchar(255) binary NOT NULL default '', |
| | 10 | + ll_title varbinary(255) NOT NULL default '', |
| 11 | 11 | |
| 12 | 12 | UNIQUE KEY (ll_from, ll_lang), |
| 13 | 13 | KEY (ll_lang, ll_title) |
| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -58,10 +58,10 @@ |
| 59 | 59 | -- conflicts. Spaces are allowed, and are _not_ converted |
| 60 | 60 | -- to underscores like titles. See the User::newFromName() for |
| 61 | 61 | -- the specific tests that usernames have to pass. |
| 62 | | - user_name varchar(255) binary NOT NULL default '', |
| | 62 | + user_name varbinary(255) NOT NULL default '', |
| 63 | 63 | |
| 64 | 64 | -- Optional 'real name' to be displayed in credit listings |
| 65 | | - user_real_name varchar(255) binary NOT NULL default '', |
| | 65 | + user_real_name varbinary(255) NOT NULL default '', |
| 66 | 66 | |
| 67 | 67 | -- Password hashes, see User::crypt() and User::comparePasswords() |
| 68 | 68 | -- in User.php for the algorithm |
| — | — | @@ -223,7 +223,7 @@ |
| 224 | 224 | |
| 225 | 225 | -- The rest of the title, as text. |
| 226 | 226 | -- Spaces are transformed into underscores in title storage. |
| 227 | | - page_title varchar(255) binary NOT NULL, |
| | 227 | + page_title varbinary(255) NOT NULL, |
| 228 | 228 | |
| 229 | 229 | -- Comma-separated set of permission keys indicating who |
| 230 | 230 | -- can move or edit the page. |
| — | — | @@ -290,7 +290,7 @@ |
| 291 | 291 | rev_user int unsigned NOT NULL default 0, |
| 292 | 292 | |
| 293 | 293 | -- Text username or IP address of the editor. |
| 294 | | - rev_user_text varchar(255) binary NOT NULL default '', |
| | 294 | + rev_user_text varbinary(255) NOT NULL default '', |
| 295 | 295 | |
| 296 | 296 | -- Timestamp |
| 297 | 297 | rev_timestamp binary(14) NOT NULL default '', |
| — | — | @@ -360,7 +360,7 @@ |
| 361 | 361 | -- |
| 362 | 362 | CREATE TABLE /*_*/archive ( |
| 363 | 363 | ar_namespace int NOT NULL default 0, |
| 364 | | - ar_title varchar(255) binary NOT NULL default '', |
| | 364 | + ar_title varbinary(255) NOT NULL default '', |
| 365 | 365 | |
| 366 | 366 | -- Newly deleted pages will not store text in this table, |
| 367 | 367 | -- but will reference the separately existing text rows. |
| — | — | @@ -373,7 +373,7 @@ |
| 374 | 374 | -- Basic revision stuff... |
| 375 | 375 | ar_comment tinyblob NOT NULL, |
| 376 | 376 | ar_user int unsigned NOT NULL default 0, |
| 377 | | - ar_user_text varchar(255) binary NOT NULL, |
| | 377 | + ar_user_text varbinary(255) NOT NULL, |
| 378 | 378 | ar_timestamp binary(14) NOT NULL default '', |
| 379 | 379 | ar_minor_edit tinyint NOT NULL default 0, |
| 380 | 380 | |
| — | — | @@ -434,7 +434,7 @@ |
| 435 | 435 | -- and deletions may refer to different page records as time |
| 436 | 436 | -- goes by. |
| 437 | 437 | pl_namespace int NOT NULL default 0, |
| 438 | | - pl_title varchar(255) binary NOT NULL default '' |
| | 438 | + pl_title varbinary(255) NOT NULL default '' |
| 439 | 439 | ) /*$wgDBTableOptions*/; |
| 440 | 440 | |
| 441 | 441 | CREATE UNIQUE INDEX /*i*/pl_from ON /*_*/pagelinks (pl_from,pl_namespace,pl_title); |
| — | — | @@ -453,7 +453,7 @@ |
| 454 | 454 | -- and deletions may refer to different page records as time |
| 455 | 455 | -- goes by. |
| 456 | 456 | tl_namespace int NOT NULL default 0, |
| 457 | | - tl_title varchar(255) binary NOT NULL default '' |
| | 457 | + tl_title varbinary(255) NOT NULL default '' |
| 458 | 458 | ) /*$wgDBTableOptions*/; |
| 459 | 459 | |
| 460 | 460 | CREATE UNIQUE INDEX /*i*/tl_from ON /*_*/templatelinks (tl_from,tl_namespace,tl_title); |
| — | — | @@ -472,7 +472,7 @@ |
| 473 | 473 | -- Filename of target image. |
| 474 | 474 | -- This is also the page_title of the file's description page; |
| 475 | 475 | -- all such pages are in namespace 6 (NS_FILE). |
| 476 | | - il_to varchar(255) binary NOT NULL default '' |
| | 476 | + il_to varbinary(255) NOT NULL default '' |
| 477 | 477 | ) /*$wgDBTableOptions*/; |
| 478 | 478 | |
| 479 | 479 | CREATE UNIQUE INDEX /*i*/il_from ON /*_*/imagelinks (il_from,il_to); |
| — | — | @@ -490,7 +490,7 @@ |
| 491 | 491 | -- Name of the category. |
| 492 | 492 | -- This is also the page_title of the category's description page; |
| 493 | 493 | -- all such pages are in namespace 14 (NS_CATEGORY). |
| 494 | | - cl_to varchar(255) binary NOT NULL default '', |
| | 494 | + cl_to varbinary(255) NOT NULL default '', |
| 495 | 495 | |
| 496 | 496 | -- A binary string obtained by applying a sortkey generation algorithm |
| 497 | 497 | -- (Collation::getSortKey()) to page_title, or cl_sortkey_prefix . "\n" |
| — | — | @@ -504,7 +504,7 @@ |
| 505 | 505 | -- collations without reparsing all pages. |
| 506 | 506 | -- Note: If you change the length of this field, you also need to change |
| 507 | 507 | -- code in LinksUpdate.php. See bug 25254. |
| 508 | | - cl_sortkey_prefix varchar(255) binary NOT NULL default '', |
| | 508 | + cl_sortkey_prefix varbinary(255) NOT NULL default '', |
| 509 | 509 | |
| 510 | 510 | -- This isn't really used at present. Provided for an optional |
| 511 | 511 | -- sorting method by approximate addition time. |
| — | — | @@ -549,7 +549,7 @@ |
| 550 | 550 | -- Name of the category, in the same form as page_title (with underscores). |
| 551 | 551 | -- If there is a category page corresponding to this category, by definition, |
| 552 | 552 | -- it has this name (in the Category namespace). |
| 553 | | - cat_title varchar(255) binary NOT NULL, |
| | 553 | + cat_title varbinary(255) NOT NULL, |
| 554 | 554 | |
| 555 | 555 | -- The numbers of member pages (including categories and media), subcatego- |
| 556 | 556 | -- ries, and Image: namespace members, respectively. These are signed to |
| — | — | @@ -607,7 +607,7 @@ |
| 608 | 608 | eu_local_id int unsigned NOT NULL PRIMARY KEY, |
| 609 | 609 | |
| 610 | 610 | -- Some opaque identifier provided by the external database |
| 611 | | - eu_external_id varchar(255) binary NOT NULL |
| | 611 | + eu_external_id varbinary(255) NOT NULL |
| 612 | 612 | ) /*$wgDBTableOptions*/; |
| 613 | 613 | |
| 614 | 614 | CREATE UNIQUE INDEX /*i*/eu_external_id ON /*_*/external_user (eu_external_id); |
| — | — | @@ -624,7 +624,7 @@ |
| 625 | 625 | ll_lang varbinary(20) NOT NULL default '', |
| 626 | 626 | |
| 627 | 627 | -- Title of the target, including namespace |
| 628 | | - ll_title varchar(255) binary NOT NULL default '' |
| | 628 | + ll_title varbinary(255) NOT NULL default '' |
| 629 | 629 | ) /*$wgDBTableOptions*/; |
| 630 | 630 | |
| 631 | 631 | CREATE UNIQUE INDEX /*i*/ll_from ON /*_*/langlinks (ll_from, ll_lang); |
| — | — | @@ -642,7 +642,7 @@ |
| 643 | 643 | iwl_prefix varbinary(20) NOT NULL default '', |
| 644 | 644 | |
| 645 | 645 | -- Title of the target, including namespace |
| 646 | | - iwl_title varchar(255) binary NOT NULL default '' |
| | 646 | + iwl_title varbinary(255) NOT NULL default '' |
| 647 | 647 | ) /*$wgDBTableOptions*/; |
| 648 | 648 | |
| 649 | 649 | CREATE UNIQUE INDEX /*i*/iwl_from ON /*_*/iwlinks (iwl_from, iwl_prefix, iwl_title); |
| — | — | @@ -720,7 +720,7 @@ |
| 721 | 721 | ipb_by int unsigned NOT NULL default 0, |
| 722 | 722 | |
| 723 | 723 | -- User name of blocker |
| 724 | | - ipb_by_text varchar(255) binary NOT NULL default '', |
| | 724 | + ipb_by_text varbinary(255) NOT NULL default '', |
| 725 | 725 | |
| 726 | 726 | -- Text comment made by blocker. |
| 727 | 727 | ipb_reason tinyblob NOT NULL, |
| — | — | @@ -780,7 +780,7 @@ |
| 781 | 781 | -- Filename. |
| 782 | 782 | -- This is also the title of the associated description page, |
| 783 | 783 | -- which will be in namespace 6 (NS_FILE). |
| 784 | | - img_name varchar(255) binary NOT NULL default '' PRIMARY KEY, |
| | 784 | + img_name varbinary(255) NOT NULL default '' PRIMARY KEY, |
| 785 | 785 | |
| 786 | 786 | -- File size in bytes. |
| 787 | 787 | img_size int unsigned NOT NULL default 0, |
| — | — | @@ -814,7 +814,7 @@ |
| 815 | 815 | |
| 816 | 816 | -- user_id and user_name of uploader. |
| 817 | 817 | img_user int unsigned NOT NULL default 0, |
| 818 | | - img_user_text varchar(255) binary NOT NULL, |
| | 818 | + img_user_text varbinary(255) NOT NULL, |
| 819 | 819 | |
| 820 | 820 | -- Time of the upload. |
| 821 | 821 | img_timestamp varbinary(14) NOT NULL default '', |
| — | — | @@ -839,11 +839,11 @@ |
| 840 | 840 | -- |
| 841 | 841 | CREATE TABLE /*_*/oldimage ( |
| 842 | 842 | -- Base filename: key to image.img_name |
| 843 | | - oi_name varchar(255) binary NOT NULL default '', |
| | 843 | + oi_name varbinary(255) NOT NULL default '', |
| 844 | 844 | |
| 845 | 845 | -- Filename of the archived file. |
| 846 | 846 | -- This is generally a timestamp and '!' prepended to the base name. |
| 847 | | - oi_archive_name varchar(255) binary NOT NULL default '', |
| | 847 | + oi_archive_name varbinary(255) NOT NULL default '', |
| 848 | 848 | |
| 849 | 849 | -- Other fields as in image... |
| 850 | 850 | oi_size int unsigned NOT NULL default 0, |
| — | — | @@ -852,7 +852,7 @@ |
| 853 | 853 | oi_bits int NOT NULL default 0, |
| 854 | 854 | oi_description tinyblob NOT NULL, |
| 855 | 855 | oi_user int unsigned NOT NULL default 0, |
| 856 | | - oi_user_text varchar(255) binary NOT NULL, |
| | 856 | + oi_user_text varbinary(255) NOT NULL, |
| 857 | 857 | oi_timestamp binary(14) NOT NULL default '', |
| 858 | 858 | |
| 859 | 859 | oi_metadata mediumblob NOT NULL, |
| — | — | @@ -878,10 +878,10 @@ |
| 879 | 879 | fa_id int NOT NULL PRIMARY KEY AUTO_INCREMENT, |
| 880 | 880 | |
| 881 | 881 | -- Original base filename; key to image.img_name, page.page_title, etc |
| 882 | | - fa_name varchar(255) binary NOT NULL default '', |
| | 882 | + fa_name varbinary(255) NOT NULL default '', |
| 883 | 883 | |
| 884 | 884 | -- Filename of archived file, if an old revision |
| 885 | | - fa_archive_name varchar(255) binary default '', |
| | 885 | + fa_archive_name varbinary(255) default '', |
| 886 | 886 | |
| 887 | 887 | -- Which storage bin (directory tree or object store) the file data |
| 888 | 888 | -- is stored in. Should be 'deleted' for files that have been deleted; |
| — | — | @@ -911,7 +911,7 @@ |
| 912 | 912 | fa_minor_mime varbinary(100) default "unknown", |
| 913 | 913 | fa_description tinyblob, |
| 914 | 914 | fa_user int unsigned default 0, |
| 915 | | - fa_user_text varchar(255) binary, |
| | 915 | + fa_user_text varbinary(255), |
| 916 | 916 | fa_timestamp binary(14) default '', |
| 917 | 917 | |
| 918 | 918 | -- Visibility of deleted revisions, bitfield |
| — | — | @@ -940,14 +940,14 @@ |
| 941 | 941 | |
| 942 | 942 | -- As in revision |
| 943 | 943 | rc_user int unsigned NOT NULL default 0, |
| 944 | | - rc_user_text varchar(255) binary NOT NULL, |
| | 944 | + rc_user_text varbinary(255) NOT NULL, |
| 945 | 945 | |
| 946 | 946 | -- When pages are renamed, their RC entries do _not_ change. |
| 947 | 947 | rc_namespace int NOT NULL default 0, |
| 948 | | - rc_title varchar(255) binary NOT NULL default '', |
| | 948 | + rc_title varbinary(255) NOT NULL default '', |
| 949 | 949 | |
| 950 | 950 | -- as in revision... |
| 951 | | - rc_comment varchar(255) binary NOT NULL default '', |
| | 951 | + rc_comment varbinary(255) NOT NULL default '', |
| 952 | 952 | rc_minor tinyint unsigned NOT NULL default 0, |
| 953 | 953 | |
| 954 | 954 | -- Edits by user accounts with the 'bot' rights key are |
| — | — | @@ -971,7 +971,7 @@ |
| 972 | 972 | -- These may no longer be used, with the new move log. |
| 973 | 973 | rc_type tinyint unsigned NOT NULL default 0, |
| 974 | 974 | rc_moved_to_ns tinyint unsigned NOT NULL default 0, |
| 975 | | - rc_moved_to_title varchar(255) binary NOT NULL default '', |
| | 975 | + rc_moved_to_title varbinary(255) NOT NULL default '', |
| 976 | 976 | |
| 977 | 977 | -- If the Recent Changes Patrol option is enabled, |
| 978 | 978 | -- users may mark edits as having been reviewed to |
| — | — | @@ -1018,7 +1018,7 @@ |
| 1019 | 1019 | -- Note that users may watch pages which do not exist yet, |
| 1020 | 1020 | -- or existed in the past but have been deleted. |
| 1021 | 1021 | wl_namespace int NOT NULL default 0, |
| 1022 | | - wl_title varchar(255) binary NOT NULL default '', |
| | 1022 | + wl_title varbinary(255) NOT NULL default '', |
| 1023 | 1023 | |
| 1024 | 1024 | -- Timestamp when user was last sent a notification e-mail; |
| 1025 | 1025 | -- cleared when the user visits the page. |
| — | — | @@ -1068,7 +1068,7 @@ |
| 1069 | 1069 | si_page int unsigned NOT NULL, |
| 1070 | 1070 | |
| 1071 | 1071 | -- Munged version of title |
| 1072 | | - si_title varchar(255) NOT NULL default '', |
| | 1072 | + si_title varbinary(255) NOT NULL default '', |
| 1073 | 1073 | |
| 1074 | 1074 | -- Munged version of body text |
| 1075 | 1075 | si_text mediumtext NOT NULL |
| — | — | @@ -1084,7 +1084,7 @@ |
| 1085 | 1085 | -- |
| 1086 | 1086 | CREATE TABLE /*_*/interwiki ( |
| 1087 | 1087 | -- The interwiki prefix, (e.g. "Meatball", or the language prefix "de") |
| 1088 | | - iw_prefix varchar(32) NOT NULL, |
| | 1088 | + iw_prefix varbinary(32) NOT NULL, |
| 1089 | 1089 | |
| 1090 | 1090 | -- The URL of the wiki, with "$1" as a placeholder for an article name. |
| 1091 | 1091 | -- Any spaces in the name will be transformed to underscores before |
| — | — | @@ -1095,7 +1095,7 @@ |
| 1096 | 1096 | iw_api blob NOT NULL, |
| 1097 | 1097 | |
| 1098 | 1098 | -- The name of the database (for a connection to be established with wfGetLB( 'wikiid' )) |
| 1099 | | - iw_wikiid varchar(64) NOT NULL, |
| | 1099 | + iw_wikiid varbinary(64) NOT NULL, |
| 1100 | 1100 | |
| 1101 | 1101 | -- A boolean value indicating whether the wiki is in this project |
| 1102 | 1102 | -- (used, for example, to detect redirect loops) |
| — | — | @@ -1120,7 +1120,7 @@ |
| 1121 | 1121 | |
| 1122 | 1122 | -- Target namespace+title |
| 1123 | 1123 | qc_namespace int NOT NULL default 0, |
| 1124 | | - qc_title varchar(255) binary NOT NULL default '' |
| | 1124 | + qc_title varbinary(255) NOT NULL default '' |
| 1125 | 1125 | ) /*$wgDBTableOptions*/; |
| 1126 | 1126 | |
| 1127 | 1127 | CREATE INDEX /*i*/qc_type ON /*_*/querycache (qc_type,qc_value); |
| — | — | @@ -1166,16 +1166,16 @@ |
| 1167 | 1167 | log_user int unsigned NOT NULL default 0, |
| 1168 | 1168 | |
| 1169 | 1169 | -- Name of the user who performed this action |
| 1170 | | - log_user_text varchar(255) binary NOT NULL default '', |
| | 1170 | + log_user_text varbinary(255) NOT NULL default '', |
| 1171 | 1171 | |
| 1172 | 1172 | -- Key to the page affected. Where a user is the target, |
| 1173 | 1173 | -- this will point to the user page. |
| 1174 | 1174 | log_namespace int NOT NULL default 0, |
| 1175 | | - log_title varchar(255) binary NOT NULL default '', |
| | 1175 | + log_title varbinary(255) NOT NULL default '', |
| 1176 | 1176 | log_page int unsigned NULL, |
| 1177 | 1177 | |
| 1178 | 1178 | -- Freeform text. Interpreted as edit history comments. |
| 1179 | | - log_comment varchar(255) NOT NULL default '', |
| | 1179 | + log_comment varbinary(255) NOT NULL default '', |
| 1180 | 1180 | |
| 1181 | 1181 | -- LF separated list of miscellaneous parameters |
| 1182 | 1182 | log_params blob NOT NULL, |
| — | — | @@ -1196,7 +1196,7 @@ |
| 1197 | 1197 | -- The type of ID (rev ID, log ID, rev timestamp, username) |
| 1198 | 1198 | ls_field varbinary(32) NOT NULL, |
| 1199 | 1199 | -- The value of the ID |
| 1200 | | - ls_value varchar(255) NOT NULL, |
| | 1200 | + ls_value varbinary(255) NOT NULL, |
| 1201 | 1201 | -- Key to log_id |
| 1202 | 1202 | ls_log_id int unsigned NOT NULL default 0 |
| 1203 | 1203 | ) /*$wgDBTableOptions*/; |
| — | — | @@ -1207,10 +1207,10 @@ |
| 1208 | 1208 | CREATE TABLE /*_*/trackbacks ( |
| 1209 | 1209 | tb_id int PRIMARY KEY AUTO_INCREMENT, |
| 1210 | 1210 | tb_page int REFERENCES /*_*/page(page_id) ON DELETE CASCADE, |
| 1211 | | - tb_title varchar(255) NOT NULL, |
| | 1211 | + tb_title varbinary(255) NOT NULL, |
| 1212 | 1212 | tb_url blob NOT NULL, |
| 1213 | 1213 | tb_ex text, |
| 1214 | | - tb_name varchar(255) |
| | 1214 | + tb_name varbinary(255) |
| 1215 | 1215 | ) /*$wgDBTableOptions*/; |
| 1216 | 1216 | CREATE INDEX /*i*/tb_page ON /*_*/trackbacks (tb_page); |
| 1217 | 1217 | |
| — | — | @@ -1226,7 +1226,7 @@ |
| 1227 | 1227 | -- Namespace and title to act on |
| 1228 | 1228 | -- Should be 0 and '' if the command does not operate on a title |
| 1229 | 1229 | job_namespace int NOT NULL, |
| 1230 | | - job_title varchar(255) binary NOT NULL, |
| | 1230 | + job_title varbinary(255) NOT NULL, |
| 1231 | 1231 | |
| 1232 | 1232 | -- Any other parameters to the command |
| 1233 | 1233 | -- Stored as a PHP serialized array, or an empty string if there are no parameters |
| — | — | @@ -1259,9 +1259,9 @@ |
| 1260 | 1260 | -- and deletions may refer to different page records as time |
| 1261 | 1261 | -- goes by. |
| 1262 | 1262 | rd_namespace int NOT NULL default 0, |
| 1263 | | - rd_title varchar(255) binary NOT NULL default '', |
| 1264 | | - rd_interwiki varchar(32) default NULL, |
| 1265 | | - rd_fragment varchar(255) binary default NULL |
| | 1263 | + rd_title varbinary(255) NOT NULL default '', |
| | 1264 | + rd_interwiki varbinary(32) default NULL, |
| | 1265 | + rd_fragment varbinary(255) default NULL |
| 1266 | 1266 | ) /*$wgDBTableOptions*/; |
| 1267 | 1267 | |
| 1268 | 1268 | CREATE INDEX /*i*/rd_ns_title ON /*_*/redirect (rd_namespace,rd_title,rd_from); |
| — | — | @@ -1277,11 +1277,11 @@ |
| 1278 | 1278 | |
| 1279 | 1279 | -- Target namespace+title |
| 1280 | 1280 | qcc_namespace int NOT NULL default 0, |
| 1281 | | - qcc_title varchar(255) binary NOT NULL default '', |
| | 1281 | + qcc_title varbinary(255) NOT NULL default '', |
| 1282 | 1282 | |
| 1283 | 1283 | -- Target namespace+title2 |
| 1284 | 1284 | qcc_namespacetwo int NOT NULL default 0, |
| 1285 | | - qcc_titletwo varchar(255) binary NOT NULL default '' |
| | 1285 | + qcc_titletwo varbinary(255) NOT NULL default '' |
| 1286 | 1286 | ) /*$wgDBTableOptions*/; |
| 1287 | 1287 | |
| 1288 | 1288 | CREATE INDEX /*i*/qcc_type ON /*_*/querycachetwo (qcc_type,qcc_value); |
| — | — | @@ -1316,7 +1316,7 @@ |
| 1317 | 1317 | -- Protected titles - nonexistent pages that have been protected |
| 1318 | 1318 | CREATE TABLE /*_*/protected_titles ( |
| 1319 | 1319 | pt_namespace int NOT NULL, |
| 1320 | | - pt_title varchar(255) binary NOT NULL, |
| | 1320 | + pt_title varbinary(255) NOT NULL, |
| 1321 | 1321 | pt_user int unsigned NOT NULL, |
| 1322 | 1322 | pt_reason tinyblob, |
| 1323 | 1323 | pt_timestamp binary(14) NOT NULL, |
| — | — | @@ -1340,7 +1340,7 @@ |
| 1341 | 1341 | |
| 1342 | 1342 | -- A table to log updates, one text key row per update. |
| 1343 | 1343 | CREATE TABLE /*_*/updatelog ( |
| 1344 | | - ul_key varchar(255) NOT NULL PRIMARY KEY, |
| | 1344 | + ul_key varbinary(255) NOT NULL PRIMARY KEY, |
| 1345 | 1345 | ul_value blob |
| 1346 | 1346 | ) /*$wgDBTableOptions*/; |
| 1347 | 1347 | |
| — | — | @@ -1354,7 +1354,7 @@ |
| 1355 | 1355 | -- REVID for the change |
| 1356 | 1356 | ct_rev_id int NULL, |
| 1357 | 1357 | -- Tag applied |
| 1358 | | - ct_tag varchar(255) NOT NULL, |
| | 1358 | + ct_tag varbinary(255) NOT NULL, |
| 1359 | 1359 | -- Parameters for the tag, presently unused |
| 1360 | 1360 | ct_params blob NULL |
| 1361 | 1361 | ) /*$wgDBTableOptions*/; |
| — | — | @@ -1385,7 +1385,7 @@ |
| 1386 | 1386 | |
| 1387 | 1387 | |
| 1388 | 1388 | CREATE TABLE /*_*/valid_tag ( |
| 1389 | | - vt_tag varchar(255) NOT NULL PRIMARY KEY |
| | 1389 | + vt_tag varbinary(255) NOT NULL PRIMARY KEY |
| 1390 | 1390 | ) /*$wgDBTableOptions*/; |
| 1391 | 1391 | |
| 1392 | 1392 | -- Table for storing localisation data |
| — | — | @@ -1393,7 +1393,7 @@ |
| 1394 | 1394 | -- Language code |
| 1395 | 1395 | lc_lang varbinary(32) NOT NULL, |
| 1396 | 1396 | -- Cache key |
| 1397 | | - lc_key varchar(255) NOT NULL, |
| | 1397 | + lc_key varbinary(255) NOT NULL, |
| 1398 | 1398 | -- Value |
| 1399 | 1399 | lc_value mediumblob NOT NULL |
| 1400 | 1400 | ) /*$wgDBTableOptions*/; |