1CREATE TABLE tmp_users ( 2 user_id integer NOT NULL PRIMARY KEY, 3 username varchar(128) NOT NULL default '', 4 mail_host varchar(128) NOT NULL default '', 5 created datetime NOT NULL default '0000-00-00 00:00:00', 6 last_login datetime DEFAULT NULL, 7 failed_login datetime DEFAULT NULL, 8 failed_login_counter integer DEFAULT NULL, 9 language varchar(16), 10 preferences text DEFAULT NULL 11); 12 13INSERT INTO tmp_users (user_id, username, mail_host, created, last_login, failed_login, failed_login_counter, language, preferences) 14 SELECT user_id, username, mail_host, created, last_login, failed_login, failed_login_counter, language, preferences FROM users; 15 16DROP TABLE users; 17 18CREATE TABLE users ( 19 user_id integer NOT NULL PRIMARY KEY, 20 username varchar(128) NOT NULL default '', 21 mail_host varchar(128) NOT NULL default '', 22 created datetime NOT NULL default '0000-00-00 00:00:00', 23 last_login datetime DEFAULT NULL, 24 failed_login datetime DEFAULT NULL, 25 failed_login_counter integer DEFAULT NULL, 26 language varchar(16), 27 preferences text DEFAULT NULL 28); 29 30INSERT INTO users (user_id, username, mail_host, created, last_login, failed_login, failed_login_counter, language, preferences) 31 SELECT user_id, username, mail_host, created, last_login, failed_login, failed_login_counter, language, preferences FROM tmp_users; 32 33CREATE UNIQUE INDEX ix_users_username ON users(username, mail_host); 34 35DROP TABLE tmp_users; 36