[Summary view] [Print] [Text view]

   1  -- Remove user_options field from user table
   2  
   3  CREATE TABLE /*_*/user_tmp (
   4    user_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
   5    user_name varchar(255) binary NOT NULL default '',
   6    user_real_name varchar(255) binary NOT NULL default '',
   7    user_password tinyblob NOT NULL,
   8    user_newpassword tinyblob NOT NULL,
   9    user_newpass_time binary(14),
  10    user_email tinytext NOT NULL,
  11    user_touched binary(14) NOT NULL default '',
  12    user_token binary(32) NOT NULL default '',
  13    user_email_authenticated binary(14),
  14    user_email_token binary(32),
  15    user_email_token_expires binary(14),
  16    user_registration binary(14),
  17    user_editcount int
  18  ) /*$wgDBTableOptions*/;
  19  
  20  INSERT INTO /*_*/user_tmp
  21      SELECT user_id, user_name, user_real_name, user_password, user_newpassword, user_newpass_time, user_email, user_touched,
  22          user_token, user_email_authenticated, user_email_token, user_email_token_expires, user_registration, user_editcount
  23          FROM /*_*/user;
  24  
  25  DROP TABLE /*_*/user;
  26  
  27  ALTER TABLE /*_*/user_tmp RENAME TO /*_*/user;
  28  
  29  CREATE UNIQUE INDEX /*i*/user_name ON /*_*/user (user_name);
  30  CREATE INDEX /*i*/user_email_token ON /*_*/user (user_email_token);
  31  CREATE INDEX /*i*/user_email ON /*_*/user (user_email(50));