| Index: trunk/phase3/maintenance/archives/patch-categorylinks-better-collation.sql |
| — | — | @@ -0,0 +1,16 @@ |
| | 2 | +-- |
| | 3 | +-- patch-categorylinks-better-collation.sql |
| | 4 | +-- |
| | 5 | +-- Bugs 164, 1211, 23682. This is currently experimental and subject to |
| | 6 | +-- change. You need to set $wgExperimentalCategorySort = true; to use this. |
| | 7 | +-- You also need to manually apply any changes that are made to this file, |
| | 8 | +-- since they will not be automatically applied. This patch is only intended |
| | 9 | +-- to work for MySQL for now, without table prefixes, possibly other random |
| | 10 | +-- limitations. |
| | 11 | +ALTER TABLE categorylinks |
| | 12 | + ADD COLUMN cl_raw_sortkey varchar(255) binary NULL default NULL, |
| | 13 | + ADD COLUMN cl_collation tinyint NOT NULL default 0, |
| | 14 | + ADD COLUMN cl_type ENUM('page', 'subcat', 'file') NOT NULL, |
| | 15 | + ADD INDEX (cl_collation), |
| | 16 | + DROP INDEX cl_sortkey, |
| | 17 | + ADD INDEX cl_sortkey (cl_to, cl_type, cl_sortkey, cl_from); |
| Property changes on: trunk/phase3/maintenance/archives/patch-categorylinks-better-collation.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 18 | + native |