1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
CREATE TABLE /*_*/categorylinks_tmp (
cl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL,
cl_to BLOB DEFAULT '' NOT NULL,
cl_sortkey BLOB DEFAULT '' NOT NULL,
cl_sortkey_prefix BLOB DEFAULT '' NOT NULL,
cl_timestamp DATETIME NOT NULL,
cl_collation BLOB DEFAULT '' NOT NULL,
cl_type TEXT DEFAULT 'page' NOT NULL,
PRIMARY KEY(cl_from, cl_to)
);
INSERT INTO /*_*/categorylinks_tmp (cl_from, cl_to, cl_sortkey, cl_sortkey_prefix, cl_timestamp, cl_collation, cl_type)
SELECT cl_from, cl_to, cl_sortkey, cl_sortkey_prefix, cl_timestamp, cl_collation, cl_type
FROM /*_*/categorylinks;
DROP TABLE /*_*/categorylinks;
ALTER TABLE /*_*/categorylinks_tmp RENAME TO /*_*/categorylinks;
CREATE INDEX cl_sortkey ON /*_*/categorylinks (
cl_to, cl_type, cl_sortkey, cl_from
);
CREATE INDEX cl_timestamp ON /*_*/categorylinks (cl_to, cl_timestamp);
CREATE INDEX cl_collation_ext ON /*_*/categorylinks (
cl_collation, cl_to, cl_type, cl_from
);
|
