[Summary view] [Print] [Text view]

   1  --
   2  -- Rename indexes on change_tag from implicit to explicit names
   3  --
   4  
   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;
   9  
  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;
  13  
  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);
  18  
  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);