| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -947,7 +947,7 @@ |
| 948 | 948 | -- The URL of the wiki, with "$1" as a placeholder for an article name. |
| 949 | 949 | -- Any spaces in the name will be transformed to underscores before |
| 950 | 950 | -- insertion. |
| 951 | | - iw_url char(127) NOT NULL, |
| | 951 | + iw_url varchar(127) NOT NULL, |
| 952 | 952 | |
| 953 | 953 | -- A boolean value indicating whether the wiki is in this project |
| 954 | 954 | -- (used, for example, to detect redirect loops) |
| — | — | @@ -965,14 +965,14 @@ |
| 966 | 966 | -- |
| 967 | 967 | CREATE TABLE /*$wgDBprefix*/querycache ( |
| 968 | 968 | -- A key name, generally the base name of of the special page. |
| 969 | | - qc_type char(32) NOT NULL, |
| | 969 | + qc_type varchar(32) binary NOT NULL, |
| 970 | 970 | |
| 971 | 971 | -- Some sort of stored value. Sizes, counts... |
| 972 | 972 | qc_value int(5) unsigned NOT NULL default '0', |
| 973 | 973 | |
| 974 | 974 | -- Target namespace+title |
| 975 | 975 | qc_namespace int NOT NULL default '0', |
| 976 | | - qc_title char(255) binary NOT NULL default '', |
| | 976 | + qc_title varchar(255) binary NOT NULL default '', |
| 977 | 977 | |
| 978 | 978 | KEY (qc_type,qc_value) |
| 979 | 979 | |
| — | — | @@ -982,7 +982,7 @@ |
| 983 | 983 | -- For a few generic cache operations if not using Memcached |
| 984 | 984 | -- |
| 985 | 985 | CREATE TABLE /*$wgDBprefix*/objectcache ( |
| 986 | | - keyname char(255) binary NOT NULL default '', |
| | 986 | + keyname varchar(255) binary NOT NULL default '', |
| 987 | 987 | value mediumblob, |
| 988 | 988 | exptime datetime, |
| 989 | 989 | UNIQUE KEY (keyname), |
| — | — | @@ -1105,18 +1105,18 @@ |
| 1106 | 1106 | -- Used for caching expensive grouped queries that need two links (for example double-redirects) |
| 1107 | 1107 | CREATE TABLE /*$wgDBprefix*/querycachetwo ( |
| 1108 | 1108 | -- A key name, generally the base name of of the special page. |
| 1109 | | - qcc_type char(32) NOT NULL, |
| | 1109 | + qcc_type varchar(32) NOT NULL, |
| 1110 | 1110 | |
| 1111 | 1111 | -- Some sort of stored value. Sizes, counts... |
| 1112 | 1112 | qcc_value int(5) unsigned NOT NULL default '0', |
| 1113 | 1113 | |
| 1114 | 1114 | -- Target namespace+title |
| 1115 | 1115 | qcc_namespace int NOT NULL default '0', |
| 1116 | | - qcc_title char(255) binary NOT NULL default '', |
| | 1116 | + qcc_title varchar(255) binary NOT NULL default '', |
| 1117 | 1117 | |
| 1118 | 1118 | -- Target namespace+title2 |
| 1119 | 1119 | qcc_namespacetwo int NOT NULL default '0', |
| 1120 | | - qcc_titletwo char(255) binary NOT NULL default '', |
| | 1120 | + qcc_titletwo varchar(255) binary NOT NULL default '', |
| 1121 | 1121 | |
| 1122 | 1122 | KEY qcc_type (qcc_type,qcc_value), |
| 1123 | 1123 | KEY qcc_title (qcc_type,qcc_namespace,qcc_title), |