From 18da24b4384a0b74b9fd55cc8c810c548c7288cc Mon Sep 17 00:00:00 2001 From: yllar <yllar.pajus@gmail.com> Date: Tue, 15 May 2007 02:41:32 -0400 Subject: [PATCH] Updated Brazilian, Swedish, German, Latvian, Bulgarian, Slovenian, Lithuanian translations --- SQL/sqlite.initial.sql | 11 +++++++---- 1 files changed, 7 insertions(+), 4 deletions(-) diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql index 147df72..5be6978 100644 --- a/SQL/sqlite.initial.sql +++ b/SQL/sqlite.initial.sql @@ -1,5 +1,5 @@ -- RoundCube Webmail initial database structure --- Version 0.1a +-- Version 0.1-beta2 -- -- -------------------------------------------------------- @@ -31,7 +31,7 @@ CREATE TABLE contacts ( contact_id integer NOT NULL PRIMARY KEY, user_id integer NOT NULL default '0', - created datetime NOT NULL default '0000-00-00 00:00:00', + changed datetime NOT NULL default '0000-00-00 00:00:00', del tinyint NOT NULL default '0', name varchar(128) NOT NULL default '', email varchar(128) NOT NULL default '', @@ -58,7 +58,8 @@ email varchar(128) NOT NULL default '', "reply-to" varchar(128) NOT NULL default '', bcc varchar(128) NOT NULL default '', - signature text NOT NULL default '' + signature text NOT NULL default '', + html_signature tinyint NOT NULL default '0' ); CREATE INDEX ix_identities_user_id ON identities(user_id); @@ -118,8 +119,10 @@ date datetime NOT NULL default '0000-00-00 00:00:00', size integer NOT NULL default '0', headers text NOT NULL, - body text + structure text ); CREATE INDEX ix_messages_user_id ON messages(user_id); CREATE INDEX ix_messages_cache_key ON messages(cache_key); +CREATE INDEX ix_messages_idx ON messages(idx); +CREATE INDEX ix_messages_uid ON messages(uid); -- Gitblit v1.9.1