Imported Upstream version 0.1.1

[roundcube.git] / SQL / sqlite.initial.sql

diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql
index 4ae752983652d479290231d57fb0743f9fe0e58c..041696b1d878b4d365e2af38e4f49b86f3b21378 100644 (file)
--- a/SQL/sqlite.initial.sql
+++ b/SQL/sqlite.initial.sql
@@ -1,5 +1,5 @@
 -- RoundCube Webmail initial database structure
 -- RoundCube Webmail initial database structure

--- Version 0.1-rc1
+-- Version 0.1

 -- 
 
 -- --------------------------------------------------------
 -- 
 
 -- --------------------------------------------------------


@@ -17,9 +17,7 @@ CREATE TABLE cache (
   data longtext NOT NULL
 );
 
   data longtext NOT NULL
 );
 

-CREATE INDEX ix_cache_user_id ON cache(user_id);
-CREATE INDEX ix_cache_cache_key ON cache(cache_key);
-CREATE INDEX ix_cache_session_id ON cache(session_id);
+CREATE INDEX ix_cache_user_cache_key ON cache(user_id, cache_key);

 
 
 -- --------------------------------------------------------
 
 
 -- --------------------------------------------------------


@@ -82,7 +80,6 @@ CREATE TABLE users (
   preferences text NOT NULL default ''
 );
 
   preferences text NOT NULL default ''
 );
 

-

 -- --------------------------------------------------------
 
 -- 
 -- --------------------------------------------------------
 
 -- 


@@ -115,14 +112,11 @@ CREATE TABLE messages (
   subject varchar(255) NOT NULL default '',
   "from" varchar(255) NOT NULL default '',
   "to" varchar(255) NOT NULL default '',
   subject varchar(255) NOT NULL default '',
   "from" varchar(255) NOT NULL default '',
   "to" varchar(255) NOT NULL default '',

-  cc varchar(255) NOT NULL default '',
-  date datetime NOT NULL default '0000-00-00 00:00:00',
+  "cc" varchar(255) NOT NULL default '',
+  "date" datetime NOT NULL default '0000-00-00 00:00:00',

   size integer NOT NULL default '0',
   headers text NOT NULL,
   structure text
 );
 
   size integer NOT NULL default '0',
   headers text NOT NULL,
   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);
+CREATE INDEX ix_messages_user_cache_uid ON messages(user_id,cache_key,uid);