diff options
author | thomascube <thomas@roundcube.net> | 2008-04-05 12:49:21 +0000 |
---|---|---|
committer | thomascube <thomas@roundcube.net> | 2008-04-05 12:49:21 +0000 |
commit | e70d6ea64e711096af36b1234f8545b870ea5f45 (patch) | |
tree | 98e784b95d08418d85a17af767037e8a6e0f3f41 /SQL/mysql.initial.sql | |
parent | cb1330b7b10ce46e466850b27300a06ed122501e (diff) |
Apply changes from trunk to 0.1-stable
Diffstat (limited to 'SQL/mysql.initial.sql')
-rw-r--r-- | SQL/mysql.initial.sql | 11 |
1 files changed, 3 insertions, 8 deletions
diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index 926a83eab..ae195e438 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -1,5 +1,5 @@ -- RoundCube Webmail initial database structure --- Version 0.1-rc1 +-- Version 0.1 -- -- -------------------------------------------------------- @@ -16,9 +16,7 @@ CREATE TABLE `cache` ( `created` datetime NOT NULL default '0000-00-00 00:00:00', `data` longtext NOT NULL, PRIMARY KEY (`cache_id`), - KEY `user_id` (`user_id`), - KEY `cache_key` (`cache_key`), - KEY `session_id` (`session_id`) + INDEX `user_cache_index` (`user_id`,`cache_key`) ); -- -------------------------------------------------------- @@ -118,10 +116,7 @@ CREATE TABLE `messages` ( `size` int(11) unsigned NOT NULL default '0', `headers` text NOT NULL, `structure` text, - PRIMARY KEY (`message_id`), - KEY `user_id` (`user_id`), - KEY `idx` (`idx`), - KEY `uid` (`uid`), + PRIMARY KEY (`message_id`), UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`) ); |