Reconcept cl_raw_sortkey as cl_sortkey_prefix

[lhc/web/wiklou.git] / maintenance / archives / patch-categorylinks-better-collation.sql

diff --git a/maintenance/archives/patch-categorylinks-better-collation.sql b/maintenance/archives/patch-categorylinks-better-collation.sql
index f73dd52..5722a33 100644 (file)
--- 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);