Mercurial > hg > rc1

comparison SQL/sqlite/2015111100.sql @ 0:1e000243b222

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
vanilla 1.3.3 distro, I hope
author Charlie Root
date Thu, 04 Jan 2018 15:50:29 -0500
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:1e000243b222
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;