1 -- Remove user_options field from user table
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),
18 ) /*$wgDBTableOptions*/;
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
27 ALTER TABLE /*_*/user_tmp
RENAME TO /*_*/user;
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));