Mercurial > hg > rc2

comparison SQL/sqlite/2015111100.sql @ 8:bf99236cc5cd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
try to recover from upgrade fail
author Charlie Root
date Sat, 29 Dec 2018 07:07:34 -0500
parents
children
comparison
equal deleted inserted replaced
7:65fd7d441cf1 8:bf99236cc5cd
1 CREATE 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(5),
10 preferences text NOT NULL default ''
11 );
12
13 INSERT INTO tmp_users (user_id, username, mail_host, created, last_login, language, preferences)
14 SELECT user_id, username, mail_host, created, last_login, language, preferences FROM users;
15
16 DROP TABLE users;
17
18 CREATE 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(5),
27 preferences text NOT NULL default ''
28 );
29
30 INSERT INTO users (user_id, username, mail_host, created, last_login, language, preferences)
31 SELECT user_id, username, mail_host, created, last_login, language, preferences FROM tmp_users;
32
33 CREATE UNIQUE INDEX ix_users_username ON users(username, mail_host);
34
35 DROP TABLE tmp_users;