maintenance/sqlite/archives/patch-tag_summary-ts_id.sql

   1 DROP TABLE IF EXISTS /*_*/tag_summary_tmp;
   2
   3 CREATE TABLE /*$wgDBprefix*/tag_summary_tmp (
   4   ts_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
   5   ts_rc_id int NULL,
   6   ts_log_id int NULL,
   7   ts_rev_id int NULL,
   8   ts_tags blob NOT NULL
   9 );
  10
  11 INSERT OR IGNORE INTO /*_*/tag_summary_tmp (
  12     ts_rc_id, ts_log_id, ts_rev_id, ts_tags )
  13     SELECT
  14     ts_rc_id, ts_log_id, ts_rev_id, ts_tags
  15     FROM /*_*/tag_summary;
  16
  17 DROP TABLE /*_*/tag_summary;
  18
  19 ALTER TABLE /*_*/tag_summary_tmp RENAME TO /*_*/tag_summary;
  20
  21 CREATE UNIQUE INDEX /*i*/tag_summary_rc_id ON /*_*/tag_summary (ts_rc_id);
  22 CREATE UNIQUE INDEX /*i*/tag_summary_log_id ON /*_*/tag_summary (ts_log_id);
  23 CREATE UNIQUE INDEX /*i*/tag_summary_rev_id ON /*_*/tag_summary (ts_rev_id);