Mercurial > hg > rc2

comparison SQL/sqlite/2011092800.sql @ 0:4681f974d28b

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:52:31 -0500
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:4681f974d28b
1 -- Updates from version 0.6
2
3 CREATE TABLE dictionary (
4 user_id integer DEFAULT NULL,
5 "language" varchar(5) NOT NULL,
6 data text NOT NULL
7 );
8
9 CREATE UNIQUE INDEX ix_dictionary_user_language ON dictionary (user_id, "language");
10
11 CREATE TABLE searches (
12 search_id integer NOT NULL PRIMARY KEY,
13 user_id integer NOT NULL DEFAULT '0',
14 "type" smallint NOT NULL DEFAULT '0',
15 name varchar(128) NOT NULL,
16 data text NOT NULL
17 );
18
19 CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);
20
21 DROP TABLE messages;
22
23 CREATE TABLE cache_index (
24 user_id integer NOT NULL,
25 mailbox varchar(255) NOT NULL,
26 changed datetime NOT NULL default '0000-00-00 00:00:00',
27 valid smallint NOT NULL DEFAULT '0',
28 data text NOT NULL,
29 PRIMARY KEY (user_id, mailbox)
30 );
31
32 CREATE INDEX ix_cache_index_changed ON cache_index (changed);
33
34 CREATE TABLE cache_thread (
35 user_id integer NOT NULL,
36 mailbox varchar(255) NOT NULL,
37 changed datetime NOT NULL default '0000-00-00 00:00:00',
38 data text NOT NULL,
39 PRIMARY KEY (user_id, mailbox)
40 );
41
42 CREATE INDEX ix_cache_thread_changed ON cache_thread (changed);
43
44 CREATE TABLE cache_messages (
45 user_id integer NOT NULL,
46 mailbox varchar(255) NOT NULL,
47 uid integer NOT NULL,
48 changed datetime NOT NULL default '0000-00-00 00:00:00',
49 data text NOT NULL,
50 flags integer NOT NULL DEFAULT '0',
51 PRIMARY KEY (user_id, mailbox, uid)
52 );
53
54 CREATE INDEX ix_cache_messages_changed ON cache_messages (changed);