3 CREATE TABLE /*_*/change_tag_tmp (
4 ct_id
int unsigned
NOT NULL PRIMARY KEY AUTO_INCREMENT
,
6 ct_log_id
int unsigned
NULL,
7 ct_rev_id
int unsigned
NULL,
9 ct_tag_id
int unsigned
NOT NULL
10 ) /*$wgDBTableOptions*/;
12 INSERT INTO /*_*/change_tag_tmp
13 SELECT ct_id
, ct_rc_id
, ct_log_id
, ct_rev_id
, ct_params
, ct_tag_id
16 DROP TABLE /*_*/change_tag
;
18 ALTER TABLE /*_*/change_tag_tmp
RENAME TO /*_*/change_tag
;
20 CREATE UNIQUE INDEX /*i*/change_tag_rc_tag_id
ON /*_*/change_tag (ct_rc_id
,ct_tag_id
);
21 CREATE UNIQUE INDEX /*i*/change_tag_log_tag_id
ON /*_*/change_tag (ct_log_id
,ct_tag_id
);
22 CREATE UNIQUE INDEX /*i*/change_tag_rev_tag_id
ON /*_*/change_tag (ct_rev_id
,ct_tag_id
);
23 CREATE INDEX /*i*/change_tag_tag_id_id
ON /*_*/change_tag (ct_tag_id
,ct_rc_id
,ct_rev_id
,ct_log_id
);