1 DROP TABLE IF EXISTS /*_*/change_tag_tmp
;
3 CREATE TABLE /*$wgDBprefix*/change_tag_tmp (
4 ct_id
int unsigned
NOT NULL PRIMARY KEY AUTO_INCREMENT
,
8 ct_tag
varchar(255) NOT NULL,
12 INSERT OR IGNORE INTO /*_*/change_tag_tmp (
13 ct_rc_id
, ct_log_id
, ct_rev_id
, ct_tag
, ct_params
)
15 ct_rc_id
, ct_log_id
, ct_rev_id
, ct_tag
, ct_params
18 DROP TABLE /*_*/change_tag
;
20 ALTER TABLE /*_*/change_tag_tmp
RENAME TO /*_*/change_tag
;
22 CREATE UNIQUE INDEX /*i*/change_tag_rc_tag
ON /*_*/change_tag (ct_rc_id
,ct_tag
);
23 CREATE UNIQUE INDEX /*i*/change_tag_log_tag
ON /*_*/change_tag (ct_log_id
,ct_tag
);
24 CREATE UNIQUE INDEX /*i*/change_tag_rev_tag
ON /*_*/change_tag (ct_rev_id
,ct_tag
);
25 CREATE INDEX /*i*/change_tag_tag_id
ON /*_*/change_tag (ct_tag
,ct_rc_id
,ct_rev_id
,ct_log_id
);