summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-categorylinks-better-collation2.sql
blob: e9574693b3f8726ca8eeba4c816ecfe7e7adba39 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
--
-- patch-categorylinks-better-collation2.sql
--
-- Bugs 164, 1211, 23682.  This patch exists for trunk users who already
-- applied the first patch in its original version.  The first patch was
-- updated to incorporate the changes as well, so as not to do two alters on a
-- large table unnecessarily for people upgrading from 1.16, so this will be
-- skipped if unneeded.
ALTER TABLE /*$wgDBprefix*/categorylinks
	CHANGE COLUMN cl_sortkey cl_sortkey varbinary(230) NOT NULL default '',
	CHANGE COLUMN cl_collation cl_collation varbinary(32) NOT NULL default '';
INSERT IGNORE INTO /*$wgDBprefix*/updatelog (ul_key) VALUES ('cl_fields_update');