maintenance/sqlite/archives/patch-drop-ct_tag.sql

   1 -- T185355
   2
   3 CREATE TABLE /*_*/change_tag_tmp (
   4   ct_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
   5   ct_rc_id int NULL,
   6   ct_log_id int unsigned NULL,
   7   ct_rev_id int unsigned NULL,
   8   ct_params blob NULL,
   9   ct_tag_id int unsigned NOT NULL
  10 ) /*$wgDBTableOptions*/;
  11
  12 INSERT INTO /*_*/change_tag_tmp
  13         SELECT ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id
  14                 FROM /*_*/change_tag;
  15
  16 DROP TABLE /*_*/change_tag;
  17
  18 ALTER TABLE /*_*/change_tag_tmp RENAME TO /*_*/change_tag;
  19
  20 CREATE UNIQUE INDEX /*i*/change_tag_rc_tag_id ON /*_*/change_tag (ct_rc_id,ct_tag_id);
  21 CREATE UNIQUE INDEX /*i*/change_tag_log_tag_id ON /*_*/change_tag (ct_log_id,ct_tag_id);
  22 CREATE UNIQUE INDEX /*i*/change_tag_rev_tag_id ON /*_*/change_tag (ct_rev_id,ct_tag_id);
  23 CREATE INDEX /*i*/change_tag_tag_id_id ON /*_*/change_tag (ct_tag_id,ct_rc_id,ct_rev_id,ct_log_id);