http://www.mediawiki.org/wiki/Special:Code/MediaWiki/72878
Revision: 72878 Author: maxsem Date: 2010-09-12 17:48:56 +0000 (Sun, 12 Sep 2010) Log Message: ----------- Follow-up r72870: fixed patch file so that it actually works, switched it to native SQLite types Modified Paths: -------------- trunk/phase3/maintenance/sqlite/archives/patch-categorylinks-better-collation.sql Modified: trunk/phase3/maintenance/sqlite/archives/patch-categorylinks-better-collation.sql =================================================================== --- trunk/phase3/maintenance/sqlite/archives/patch-categorylinks-better-collation.sql 2010-09-12 17:36:26 UTC (rev 72877) +++ trunk/phase3/maintenance/sqlite/archives/patch-categorylinks-better-collation.sql 2010-09-12 17:48:56 UTC (rev 72878) @@ -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'); _______________________________________________ MediaWiki-CVS mailing list MediaWiki-CVS@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs