| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -768,7 +768,7 @@ |
| 769 | 769 | fa_bits int default '0', |
| 770 | 770 | fa_media_type ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL, |
| 771 | 771 | fa_major_mime ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart") default "unknown", |
| 772 | | - fa_minor_mime varchar(32) default "unknown", |
| | 772 | + fa_minor_mime varbinary(32) default "unknown", |
| 773 | 773 | fa_description tinyblob, |
| 774 | 774 | fa_user int unsigned default '0', |
| 775 | 775 | fa_user_text varchar(255) binary, |
| — | — | @@ -851,9 +851,9 @@ |
| 852 | 852 | -- Value corresonding to log_id, specific log entries |
| 853 | 853 | rc_logid int unsigned NOT NULL default '0', |
| 854 | 854 | -- Store log type info here, or null |
| 855 | | - rc_log_type varchar(255) binary NULL default NULL, |
| | 855 | + rc_log_type varbinary(255) NULL default NULL, |
| 856 | 856 | -- Store log action or null |
| 857 | | - rc_log_action varchar(255) binary NULL default NULL, |
| | 857 | + rc_log_action varbinary(255) NULL default NULL, |
| 858 | 858 | -- Log params |
| 859 | 859 | rc_params blob NOT NULL default '', |
| 860 | 860 | |
| — | — | @@ -994,7 +994,7 @@ |
| 995 | 995 | -- Cache of interwiki transclusion |
| 996 | 996 | -- |
| 997 | 997 | CREATE TABLE /*$wgDBprefix*/transcache ( |
| 998 | | - tc_url varchar(255) NOT NULL, |
| | 998 | + tc_url varbinary(255) NOT NULL, |
| 999 | 999 | tc_contents text, |
| 1000 | 1000 | tc_time int NOT NULL, |
| 1001 | 1001 | UNIQUE INDEX tc_url_idx (tc_url) |
| — | — | @@ -1004,8 +1004,8 @@ |
| 1005 | 1005 | -- Symbolic keys for the general log type and the action type |
| 1006 | 1006 | -- within the log. The output format will be controlled by the |
| 1007 | 1007 | -- action field, but only the type controls categorization. |
| 1008 | | - log_type varbinary(20) NOT NULL default '', |
| 1009 | | - log_action varbinary(20) NOT NULL default '', |
| | 1008 | + log_type varbinary(10) NOT NULL default '', |
| | 1009 | + log_action varbinary(10) NOT NULL default '', |
| 1010 | 1010 | |
| 1011 | 1011 | -- Timestamp. Duh. |
| 1012 | 1012 | log_timestamp binary(14) NOT NULL default '19700101000000', |
| — | — | @@ -1078,7 +1078,7 @@ |
| 1079 | 1079 | |
| 1080 | 1080 | -- Special page name |
| 1081 | 1081 | -- Corresponds to a qc_type value |
| 1082 | | - qci_type varchar(32) NOT NULL default '', |
| | 1082 | + qci_type varbinary(32) NOT NULL default '', |
| 1083 | 1083 | |
| 1084 | 1084 | -- Timestamp of last update |
| 1085 | 1085 | qci_timestamp binary(14) NOT NULL default '19700101000000', |