You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
55 lines
1.5 KiB
SQL
55 lines
1.5 KiB
SQL
-- Updates from version 0.6
|
|
|
|
CREATE TABLE dictionary (
|
|
user_id integer DEFAULT NULL,
|
|
"language" varchar(5) NOT NULL,
|
|
data text NOT NULL
|
|
);
|
|
|
|
CREATE UNIQUE INDEX ix_dictionary_user_language ON dictionary (user_id, "language");
|
|
|
|
CREATE TABLE searches (
|
|
search_id integer NOT NULL PRIMARY KEY,
|
|
user_id integer NOT NULL DEFAULT '0',
|
|
"type" smallint NOT NULL DEFAULT '0',
|
|
name varchar(128) NOT NULL,
|
|
data text NOT NULL
|
|
);
|
|
|
|
CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);
|
|
|
|
DROP TABLE messages;
|
|
|
|
CREATE TABLE cache_index (
|
|
user_id integer NOT NULL,
|
|
mailbox varchar(255) NOT NULL,
|
|
changed datetime NOT NULL default '0000-00-00 00:00:00',
|
|
valid smallint NOT NULL DEFAULT '0',
|
|
data text NOT NULL,
|
|
PRIMARY KEY (user_id, mailbox)
|
|
);
|
|
|
|
CREATE INDEX ix_cache_index_changed ON cache_index (changed);
|
|
|
|
CREATE TABLE cache_thread (
|
|
user_id integer NOT NULL,
|
|
mailbox varchar(255) NOT NULL,
|
|
changed datetime NOT NULL default '0000-00-00 00:00:00',
|
|
data text NOT NULL,
|
|
PRIMARY KEY (user_id, mailbox)
|
|
);
|
|
|
|
CREATE INDEX ix_cache_thread_changed ON cache_thread (changed);
|
|
|
|
CREATE TABLE cache_messages (
|
|
user_id integer NOT NULL,
|
|
mailbox varchar(255) NOT NULL,
|
|
uid integer NOT NULL,
|
|
changed datetime NOT NULL default '0000-00-00 00:00:00',
|
|
data text NOT NULL,
|
|
flags integer NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (user_id, mailbox, uid)
|
|
);
|
|
|
|
CREATE INDEX ix_cache_messages_changed ON cache_messages (changed);
|