1 -- Updates from version 0.6
3 CREATE TABLE dictionary (
4 user_id integer DEFAULT NULL,
5 "language" varchar(5) NOT NULL,
9 CREATE UNIQUE INDEX ix_dictionary_user_language ON dictionary (user_id, "language");
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,
19 CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);
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',
29 PRIMARY KEY (user_id, mailbox)
32 CREATE INDEX ix_cache_index_changed ON cache_index (changed);
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',
39 PRIMARY KEY (user_id, mailbox)
42 CREATE INDEX ix_cache_thread_changed ON cache_thread (changed);
44 CREATE TABLE cache_messages (
45 user_id integer NOT NULL,
46 mailbox varchar(255) NOT NULL,
48 changed datetime NOT NULL default '0000-00-00 00:00:00',
50 flags integer NOT NULL DEFAULT '0',
51 PRIMARY KEY (user_id, mailbox, uid)
54 CREATE INDEX ix_cache_messages_changed ON cache_messages (changed);
56 -- Updates from version 0.7-beta
59 CREATE TABLE session (
60 sess_id varchar(128) NOT NULL PRIMARY KEY,
61 created datetime NOT NULL default '0000-00-00 00:00:00',
62 changed datetime NOT NULL default '0000-00-00 00:00:00',
63 ip varchar(40) NOT NULL default '',
67 CREATE INDEX ix_session_changed ON session (changed);