| Index: branches/wmf/1.17wmf1/maintenance/schema-changes-1.17wmf1-final.sql |
| — | — | @@ -0,0 +1,16 @@ |
| | 2 | +-- patch-rd_interwiki.sql |
| | 3 | +ALTER TABLE /*$wgDBprefix*/redirect |
| | 4 | + ADD rd_interwiki varchar(32) default NULL, |
| | 5 | + ADD rd_fragment varchar(255) binary default NULL; |
| | 6 | + |
| | 7 | +-- patch-categorylinks-better-collation.sql |
| | 8 | +ALTER TABLE /*$wgDBprefix*/categorylinks |
| | 9 | + CHANGE COLUMN cl_sortkey cl_sortkey varbinary(230) NOT NULL default '', |
| | 10 | + ADD COLUMN cl_sortkey_prefix varchar(255) binary NOT NULL default '', |
| | 11 | + ADD COLUMN cl_collation varbinary(32) NOT NULL default '', |
| | 12 | + ADD COLUMN cl_type ENUM('page', 'subcat', 'file') NOT NULL default 'page', |
| | 13 | + ADD INDEX (cl_collation), |
| | 14 | + DROP INDEX cl_sortkey, |
| | 15 | + ADD INDEX cl_sortkey (cl_to, cl_type, cl_sortkey, cl_from); |
| | 16 | +INSERT IGNORE INTO /*$wgDBprefix*/updatelog (ul_key) VALUES ('cl_fields_update'); |
| | 17 | + |
| Property changes on: branches/wmf/1.17wmf1/maintenance/schema-changes-1.17wmf1-final.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 18 | + native |