Merge "mw.page.gallery: Prevent jumpiness due to viewport height changes"

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

diff --git a/maintenance/sqlite/archives/patch-categorylinks-better-collation.sql b/maintenance/sqlite/archives/patch-categorylinks-better-collation.sql
index 0c51750..f32af13 100644 (file)
--- a/maintenance/sqlite/archives/patch-categorylinks-better-collation.sql
+++ b/maintenance/sqlite/archives/patch-categorylinks-better-collation.sql
@@ -1,7 +1,7 @@
-ALTER TABLE /*_*/categorylinks ADD COLUMN cl_sortkey_prefix TEXT binary NOT NULL default '';
+ALTER TABLE /*_*/categorylinks ADD COLUMN cl_sortkey_prefix TEXT NOT NULL default '';
 ALTER TABLE /*_*/categorylinks ADD COLUMN cl_collation BLOB NOT NULL default '';
-ALTER TABLE /*_*/categorylinks ADD COLUMN cl_type ENUM('page', 'subcat', 'file') NOT NULL default 'page';
+ALTER TABLE /*_*/categorylinks ADD COLUMN cl_type TEXT NOT NULL default 'page';
 CREATE INDEX cl_collation ON /*_*/categorylinks (cl_collation);
 DROP INDEX cl_sortkey;
 CREATE INDEX cl_sortkey ON /*_*/categorylinks (cl_to, cl_type, cl_sortkey, cl_from);
-INSERT IGNORE INTO /*_*/updatelog (ul_key) VALUES ('cl_fields_update');
+INSERT OR IGNORE INTO /*_*/updatelog (ul_key) VALUES ('cl_fields_update');