maintenance/oracle/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 define mw_prefix='{$wgDBprefix}';
   4
   5 CREATE UNIQUE INDEX &mw_prefix.change_tag_u04 ON &mw_prefix.change_tag (ct_rc_id,ct_tag_id);
   6 CREATE UNIQUE INDEX &mw_prefix.change_tag_u05 ON &mw_prefix.change_tag (ct_log_id,ct_tag_id);
   7 CREATE UNIQUE INDEX &mw_prefix.change_tag_u06 ON &mw_prefix.change_tag (ct_rev_id,ct_tag_id);
   8
   9 CREATE INDEX &mw_prefix.change_tag_i03 ON &mw_prefix.change_tag (ct_rc_id,ct_tag);
  10 CREATE INDEX &mw_prefix.change_tag_i04 ON &mw_prefix.change_tag (ct_log_id,ct_tag);
  11 CREATE INDEX &mw_prefix.change_tag_i05 ON &mw_prefix.change_tag (ct_rev_id,ct_tag);
  12
  13 DROP INDEX &mw_prefix.change_tag_u01;
  14 DROP INDEX &mw_prefix.change_tag_u02;
  15 DROP INDEX &mw_prefix.change_tag_u03;
  16
  17 ALTER TABLE &mw_prefix.change_tag
  18         MODIFY ct_tag DEFAULT '///invalid///';