From 219717307e9c63feb14f87d03c049d041ef5c920 Mon Sep 17 00:00:00 2001 From: Max Semenik Date: Sun, 12 Sep 2010 17:48:56 +0000 Subject: [PATCH] Follow-up r72870: fixed patch file so that it actually works, switched it to native SQLite types --- .../archives/patch-categorylinks-better-collation.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/maintenance/sqlite/archives/patch-categorylinks-better-collation.sql b/maintenance/sqlite/archives/patch-categorylinks-better-collation.sql index 0c517507c4..f32af13492 100644 --- 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'); -- 2.20.1