1 ALTER TABLE /*_*/categorylinks
ADD COLUMN cl_sortkey_prefix
TEXT NOT NULL default '';
2 ALTER TABLE /*_*/categorylinks
ADD COLUMN cl_collation
BLOB NOT NULL default '';
3 ALTER TABLE /*_*/categorylinks
ADD COLUMN cl_type
TEXT NOT NULL default 'page';
4 CREATE INDEX cl_collation
ON /*_*/categorylinks (cl_collation
);
6 CREATE INDEX cl_sortkey
ON /*_*/categorylinks (cl_to
, cl_type
, cl_sortkey
, cl_from
);
7 INSERT OR IGNORE INTO /*_*/updatelog (ul_key
) VALUES ('cl_fields_update');