2 -- patch-categorylinks-better-collation.sql
4 -- Bugs 164, 1211, 23682. This is the second version of this patch; the
5 -- changes are also incorporated into patch-categorylinks-better-collation2.sql,
6 -- for the benefit of trunk users who applied the original.
7 ALTER TABLE /*$wgDBprefix*/categorylinks
8 CHANGE
COLUMN cl_sortkey cl_sortkey
varbinary(230) NOT NULL default '',
9 ADD COLUMN cl_sortkey_prefix
varchar(255) binary NOT NULL default '',
10 ADD COLUMN cl_collation
varbinary(32) NOT NULL default '',
11 ADD COLUMN cl_type
ENUM('page', 'subcat', 'file') NOT NULL default 'page',
12 ADD INDEX (cl_collation
),
13 DROP INDEX cl_sortkey
,
14 ADD INDEX cl_sortkey (cl_to
, cl_type
, cl_sortkey
, cl_from
);
15 INSERT IGNORE INTO /*$wgDBprefix*/updatelog (ul_key
) VALUES ('cl_fields_update');