maintenance/sqlite/archives/patch-recentchanges-drop-rc_user.sql

   1 --
   2 -- patch-recentchanges-drop-rc_user.sql
   3 --
   4 -- T188327. Drop old xx_user and xx_user_text fields, and defaults from xx_actor fields.
   5
   6 BEGIN;
   7
   8 DROP TABLE IF EXISTS /*_*/recentchanges_tmp;
   9 CREATE TABLE /*_*/recentchanges_tmp (
  10   rc_id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
  11   rc_timestamp varbinary(14) NOT NULL default '',
  12   rc_actor bigint unsigned NOT NULL DEFAULT 0,
  13   rc_namespace int NOT NULL default 0,
  14   rc_title varchar(255) binary NOT NULL default '',
  15   rc_comment_id bigint unsigned NOT NULL,
  16   rc_minor tinyint unsigned NOT NULL default 0,
  17   rc_bot tinyint unsigned NOT NULL default 0,
  18   rc_new tinyint unsigned NOT NULL default 0,
  19   rc_cur_id int unsigned NOT NULL default 0,
  20   rc_this_oldid int unsigned NOT NULL default 0,
  21   rc_last_oldid int unsigned NOT NULL default 0,
  22   rc_type tinyint unsigned NOT NULL default 0,
  23   rc_source varchar(16) binary not null default '',
  24   rc_patrolled tinyint unsigned NOT NULL default 0,
  25   rc_ip varbinary(40) NOT NULL default '',
  26   rc_old_len int,
  27   rc_new_len int,
  28   rc_deleted tinyint unsigned NOT NULL default 0,
  29   rc_logid int unsigned NOT NULL default 0,
  30   rc_log_type varbinary(255) NULL default NULL,
  31   rc_log_action varbinary(255) NULL default NULL,
  32   rc_params blob NULL
  33 ) /*$wgDBTableOptions*/;
  34
  35 INSERT OR IGNORE INTO /*_*/recentchanges_tmp (
  36         rc_id, rc_timestamp, rc_actor, rc_namespace, rc_title,
  37         rc_comment_id, rc_minor, rc_bot, rc_new, rc_cur_id, rc_this_oldid, rc_last_oldid,
  38         rc_type, rc_source, rc_patrolled, rc_ip, rc_old_len, rc_new_len, rc_deleted,
  39         rc_logid, rc_log_type, rc_log_action, rc_params
  40   ) SELECT
  41         rc_id, rc_timestamp, rc_actor, rc_namespace, rc_title,
  42         rc_comment_id, rc_minor, rc_bot, rc_new, rc_cur_id, rc_this_oldid, rc_last_oldid,
  43         rc_type, rc_source, rc_patrolled, rc_ip, rc_old_len, rc_new_len, rc_deleted,
  44         rc_logid, rc_log_type, rc_log_action, rc_params
  45   FROM /*_*/recentchanges;
  46
  47 DROP TABLE /*_*/recentchanges;
  48 ALTER TABLE /*_*/recentchanges_tmp RENAME TO /*_*/recentchanges;
  49 CREATE INDEX /*i*/rc_timestamp ON /*_*/recentchanges (rc_timestamp);
  50 CREATE INDEX /*i*/rc_namespace_title_timestamp ON /*_*/recentchanges (rc_namespace, rc_title, rc_timestamp);
  51 CREATE INDEX /*i*/rc_cur_id ON /*_*/recentchanges (rc_cur_id);
  52 CREATE INDEX /*i*/new_name_timestamp ON /*_*/recentchanges (rc_new,rc_namespace,rc_timestamp);
  53 CREATE INDEX /*i*/rc_ip ON /*_*/recentchanges (rc_ip);
  54 CREATE INDEX /*i*/rc_ns_actor ON /*_*/recentchanges (rc_namespace, rc_actor);
  55 CREATE INDEX /*i*/rc_actor ON /*_*/recentchanges (rc_actor, rc_timestamp);
  56 CREATE INDEX /*i*/rc_name_type_patrolled_timestamp ON /*_*/recentchanges (rc_namespace, rc_type, rc_patrolled, rc_timestamp);
  57 CREATE INDEX /*i*/rc_this_oldid ON /*_*/recentchanges (rc_this_oldid);
  58
  59 COMMIT;