2 -- Rename indexes on change_tag from implicit to explicit names
5 DROP INDEX ct_rc_id
ON /*_*/change_tag
;
6 DROP INDEX ct_log_id
ON /*_*/change_tag
;
7 DROP INDEX ct_rev_id
ON /*_*/change_tag
;
8 DROP INDEX ct_tag
ON /*_*/change_tag
;
10 DROP INDEX ts_rc_id
ON /*_*/tag_summary
;
11 DROP INDEX ts_log_id
ON /*_*/tag_summary
;
12 DROP INDEX ts_rev_id
ON /*_*/tag_summary
;
14 CREATE UNIQUE INDEX /*i*/change_tag_rc_tag
ON /*_*/change_tag (ct_rc_id
,ct_tag
);
15 CREATE UNIQUE INDEX /*i*/change_tag_log_tag
ON /*_*/change_tag (ct_log_id
,ct_tag
);
16 CREATE UNIQUE INDEX /*i*/change_tag_rev_tag
ON /*_*/change_tag (ct_rev_id
,ct_tag
);
17 CREATE INDEX /*i*/change_tag_tag_id
ON /*_*/change_tag (ct_tag
,ct_rc_id
,ct_rev_id
,ct_log_id
);
19 CREATE UNIQUE INDEX /*i*/tag_summary_rc_id
ON /*_*/tag_summary (ts_rc_id
);
20 CREATE UNIQUE INDEX /*i*/tag_summary_log_id
ON /*_*/tag_summary (ts_log_id
);
21 CREATE UNIQUE INDEX /*i*/tag_summary_rev_id
ON /*_*/tag_summary (ts_rev_id
);