X-Git-Url: http://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Farchives%2Fpatch-categorylinks-better-collation.sql;h=5722a33c956dddcd0afd63da27c9160657b5a341;hb=022b7ba1406a4f402ff24c355288cb6ffd6eb82d;hp=f73dd524b883dbb3effb0d109412990e540b5000;hpb=f3a89bb4d0048756e9f7fb5765cf0d5c39db2943;p=lhc%2Fweb%2Fwiklou.git

diff --git a/maintenance/archives/patch-categorylinks-better-collation.sql b/maintenance/archives/patch-categorylinks-better-collation.sql
index f73dd524b8..5722a33c95 100644
--- a/maintenance/archives/patch-categorylinks-better-collation.sql
+++ b/maintenance/archives/patch-categorylinks-better-collation.sql
@@ -8,9 +8,9 @@
 -- 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_sortkey_prefix varchar(255) binary NOT NULL default '',
 	ADD COLUMN cl_collation tinyint NOT NULL default 0,
-	ADD COLUMN cl_type ENUM('page', 'subcat', 'file') NOT NULL,
+	ADD COLUMN cl_type ENUM('page', 'subcat', 'file') NOT NULL default 'page',
 	ADD INDEX (cl_collation),
 	DROP INDEX cl_sortkey,
 	ADD INDEX cl_sortkey (cl_to, cl_type, cl_sortkey, cl_from);