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
