maintenance/sqlite/archives/patch-change_tag-ct_id.sql

   1 DROP TABLE IF EXISTS /*_*/change_tag_tmp;
   2
   3 CREATE TABLE /*$wgDBprefix*/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 NULL,
   7   ct_rev_id int NULL,
   8   ct_tag varchar(255) NOT NULL,
   9   ct_params blob NULL
  10 );
  11
  12 INSERT OR IGNORE INTO /*_*/change_tag_tmp (
  13     ct_rc_id, ct_log_id, ct_rev_id, ct_tag, ct_params )
  14     SELECT
  15     ct_rc_id, ct_log_id, ct_rev_id, ct_tag, ct_params
  16     FROM /*_*/change_tag;
  17
  18 DROP TABLE /*_*/change_tag;
  19
  20 ALTER TABLE /*_*/change_tag_tmp RENAME TO /*_*/change_tag;
  21
  22 CREATE UNIQUE INDEX /*i*/change_tag_rc_tag ON /*_*/change_tag (ct_rc_id,ct_tag);
  23 CREATE UNIQUE INDEX /*i*/change_tag_log_tag ON /*_*/change_tag (ct_log_id,ct_tag);
  24 CREATE UNIQUE INDEX /*i*/change_tag_rev_tag ON /*_*/change_tag (ct_rev_id,ct_tag);
  25 CREATE INDEX /*i*/change_tag_tag_id ON /*_*/change_tag (ct_tag,ct_rc_id,ct_rev_id,ct_log_id);