| commit | author | age | ||
| b7e7c8 | 1 | -- Updates from version 0.6 |
| AM | 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); | |
