|
0
|
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);
|
