1 -- T193874: Add new indexes to change_tag table using ct_tag_id instead of ct_tag
3 CREATE UNIQUE INDEX /*i*/change_tag_rc_tag_id
ON /*_*/change_tag (ct_rc_id
,ct_tag_id
);
4 CREATE UNIQUE INDEX /*i*/change_tag_log_tag_id
ON /*_*/change_tag (ct_log_id
,ct_tag_id
);
5 CREATE UNIQUE INDEX /*i*/change_tag_rev_tag_id
ON /*_*/change_tag (ct_rev_id
,ct_tag_id
);
7 CREATE INDEX /*i*/change_tag_rc_tag_nonuniq
ON /*_*/change_tag (ct_rc_id
,ct_tag
);
8 CREATE INDEX /*i*/change_tag_log_tag_nonuniq
ON /*_*/change_tag (ct_log_id
,ct_tag
);
9 CREATE INDEX /*i*/change_tag_rev_tag_nonuniq
ON /*_*/change_tag (ct_rev_id
,ct_tag
);
11 DROP INDEX /*i*/change_tag_rc_tag
ON /*_*/change_tag
;
12 DROP INDEX /*i*/change_tag_log_tag
ON /*_*/change_tag
;
13 DROP INDEX /*i*/change_tag_rev_tag
ON /*_*/change_tag
;
15 ALTER TABLE /*_*/change_tag
16 ALTER COLUMN ct_tag
SET DEFAULT '';