maintenance/archives/patch-categorylinks-better-collation.sql

   1 --
   2 -- patch-categorylinks-better-collation.sql
   3 --
   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');