maintenance/archives/patch-change_tag-change_tag_rc_tag_id.sql

   1 -- T193874: Add new indexes to change_tag table using ct_tag_id instead of ct_tag
   2
   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);
   6
   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);
  10
  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;
  14
  15 ALTER TABLE /*_*/change_tag
  16   ALTER COLUMN ct_tag SET DEFAULT '';