ad41f087ec867889a7b5e02cd920c6a209fc44a1
2 -- patch-categorylinks-better-collation.sql
4 -- Bugs 164, 1211, 23682.
5 ALTER TABLE categorylinks
6 ADD COLUMN cl_sortkey_prefix
varchar(255) binary NOT NULL default '',
7 ADD COLUMN cl_collation tinyint
NOT NULL default 0,
8 ADD COLUMN cl_type
ENUM('page', 'subcat', 'file') NOT NULL default 'page',
9 ADD INDEX (cl_collation
),
10 DROP INDEX cl_sortkey
,
11 ADD INDEX cl_sortkey (cl_to
, cl_type
, cl_sortkey
, cl_from
);