From 62ff2b39401a1de57e7a3682ff47d32ac85aced5 Mon Sep 17 00:00:00 2001 From: Aryeh Gregor Date: Fri, 23 Jul 2010 20:58:24 +0000 Subject: [PATCH] Commit forgotten file from r69810 --- .../patch-categorylinks-better-collation.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 maintenance/archives/patch-categorylinks-better-collation.sql diff --git a/maintenance/archives/patch-categorylinks-better-collation.sql b/maintenance/archives/patch-categorylinks-better-collation.sql new file mode 100644 index 0000000000..f73dd524b8 --- /dev/null +++ b/maintenance/archives/patch-categorylinks-better-collation.sql @@ -0,0 +1,16 @@ +-- +-- patch-categorylinks-better-collation.sql +-- +-- Bugs 164, 1211, 23682. This is currently experimental and subject to +-- change. You need to set $wgExperimentalCategorySort = true; to use this. +-- You also need to manually apply any changes that are made to this file, +-- since they will not be automatically applied. This patch is only intended +-- to work for MySQL for now, without table prefixes, possibly other random +-- limitations. +ALTER TABLE categorylinks + ADD COLUMN cl_raw_sortkey varchar(255) binary NULL default NULL, + ADD COLUMN cl_collation tinyint NOT NULL default 0, + ADD COLUMN cl_type ENUM('page', 'subcat', 'file') NOT NULL, + ADD INDEX (cl_collation), + DROP INDEX cl_sortkey, + ADD INDEX cl_sortkey (cl_to, cl_type, cl_sortkey, cl_from); -- 2.20.1