1-- Remove user_options field from user table 2 3CREATE 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 20INSERT 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 25DROP TABLE /*_*/user; 26 27ALTER TABLE /*_*/user_tmp RENAME TO /*_*/user; 28 29CREATE UNIQUE INDEX /*i*/user_name ON /*_*/user (user_name); 30CREATE INDEX /*i*/user_email_token ON /*_*/user (user_email_token); 31CREATE INDEX /*i*/user_email ON /*_*/user (user_email(50)); 32