[Summary view] [Print] [Text view]

   1  -- rc_cur_time is no longer used, delete the field
   2  CREATE TABLE /*_*/recentchanges_tmp (
   3    rc_id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
   4    rc_timestamp varbinary(14) NOT NULL default '',
   5    rc_user int unsigned NOT NULL default 0,
   6    rc_user_text varchar(255) binary NOT NULL,
   7    rc_namespace int NOT NULL default 0,
   8    rc_title varchar(255) binary NOT NULL default '',
   9    rc_comment varchar(255) binary NOT NULL default '',
  10    rc_minor tinyint unsigned NOT NULL default 0,
  11    rc_bot tinyint unsigned NOT NULL default 0,
  12    rc_new tinyint unsigned NOT NULL default 0,
  13    rc_cur_id int unsigned NOT NULL default 0,
  14    rc_this_oldid int unsigned NOT NULL default 0,
  15    rc_last_oldid int unsigned NOT NULL default 0,
  16    rc_type tinyint unsigned NOT NULL default 0,
  17    rc_source varchar(16) binary not null default '',
  18    rc_patrolled tinyint unsigned NOT NULL default 0,
  19    rc_ip varbinary(40) NOT NULL default '',
  20    rc_old_len int,
  21    rc_new_len int,
  22    rc_deleted tinyint unsigned NOT NULL default 0,
  23    rc_logid int unsigned NOT NULL default 0,
  24    rc_log_type varbinary(255) NULL default NULL,
  25    rc_log_action varbinary(255) NULL default NULL,
  26    rc_params blob NULL
  27  ) /*$wgDBTableOptions*/;
  28  
  29  INSERT INTO /*_*/recentchanges_tmp
  30      SELECT rc_id, rc_timestamp, rc_user, rc_user_text, rc_namespace, rc_title, rc_comment, rc_minor,
  31          rc_bot, rc_new, rc_cur_id, rc_this_oldid, rc_last_oldid, rc_type, rc_source, rc_patrolled,
  32          rc_ip, rc_old_len, rc_new_len, rc_deleted, rc_logid, rc_log_type, rc_log_action, rc_params
  33          FROM /*_*/recentchanges;
  34  
  35  DROP TABLE /*_*/recentchanges;
  36  
  37  ALTER TABLE /*_*/recentchanges_tmp RENAME TO /*_*/recentchanges;
  38  
  39  CREATE INDEX /*i*/rc_timestamp ON /*_*/recentchanges (rc_timestamp);
  40  CREATE INDEX /*i*/rc_namespace_title ON /*_*/recentchanges (rc_namespace, rc_title);
  41  CREATE INDEX /*i*/rc_cur_id ON /*_*/recentchanges (rc_cur_id);
  42  CREATE INDEX /*i*/new_name_timestamp ON /*_*/recentchanges (rc_new,rc_namespace,rc_timestamp);
  43  CREATE INDEX /*i*/rc_ip ON /*_*/recentchanges (rc_ip);
  44  CREATE INDEX /*i*/rc_ns_usertext ON /*_*/recentchanges (rc_namespace, rc_user_text);
  45  CREATE INDEX /*i*/rc_user_text ON /*_*/recentchanges (rc_user_text, rc_timestamp);