| Index: trunk/phase3/maintenance/sqlite/archives/patch-categorylinks-better-collation.sql |
| — | — | @@ -1,7 +1,7 @@ |
| 2 | | -ALTER TABLE /*_*/categorylinks ADD COLUMN cl_sortkey_prefix TEXT binary NOT NULL default ''; |
| | 2 | +ALTER TABLE /*_*/categorylinks ADD COLUMN cl_sortkey_prefix TEXT NOT NULL default ''; |
| 3 | 3 | ALTER TABLE /*_*/categorylinks ADD COLUMN cl_collation BLOB NOT NULL default ''; |
| 4 | | -ALTER TABLE /*_*/categorylinks ADD COLUMN cl_type ENUM('page', 'subcat', 'file') NOT NULL default 'page'; |
| | 4 | +ALTER TABLE /*_*/categorylinks ADD COLUMN cl_type TEXT NOT NULL default 'page'; |
| 5 | 5 | CREATE INDEX cl_collation ON /*_*/categorylinks (cl_collation); |
| 6 | 6 | DROP INDEX cl_sortkey; |
| 7 | 7 | CREATE INDEX cl_sortkey ON /*_*/categorylinks (cl_to, cl_type, cl_sortkey, cl_from); |
| 8 | | -INSERT IGNORE INTO /*_*/updatelog (ul_key) VALUES ('cl_fields_update'); |
| | 8 | +INSERT OR IGNORE INTO /*_*/updatelog (ul_key) VALUES ('cl_fields_update'); |