diff options
| author | alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2008-11-22 18:06:13 +0000 |
|---|---|---|
| committer | alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2008-11-22 18:06:13 +0000 |
| commit | daed092b293e227909e29f5b7aad7c9aa38d47ac (patch) | |
| tree | 9d351ce7073c892b0b2ac6704d2091b7a668c1f4 /roundcubemail/SQL/mysql5.initial.sql | |
| parent | e00d46500c4740745ef34e70f5db783fae0a291c (diff) | |
- fix r2076: removed cache.session_id column, removed DELETEs from cache in session_gc
- trust DB server's time when "touching" cache and messages tables
git-svn-id: https://svn.roundcube.net/trunk@2077 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/SQL/mysql5.initial.sql')
| -rw-r--r-- | roundcubemail/SQL/mysql5.initial.sql | 5 |
1 files changed, 0 insertions, 5 deletions
diff --git a/roundcubemail/SQL/mysql5.initial.sql b/roundcubemail/SQL/mysql5.initial.sql index 7d11288e3..b162e4ddf 100644 --- a/roundcubemail/SQL/mysql5.initial.sql +++ b/roundcubemail/SQL/mysql5.initial.sql @@ -68,7 +68,6 @@ CREATE TABLE `messages` ( CREATE TABLE `cache` ( `cache_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, - `session_id` varchar(40) CHARACTER SET ascii COLLATE ascii_general_ci, `cache_key` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `data` longtext NOT NULL, @@ -78,10 +77,6 @@ CREATE TABLE `cache` ( CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) REFERENCES `users`(`user_id`) ON DELETE CASCADE - ON UPDATE CASCADE, - CONSTRAINT `session_id_fk_cache` FOREIGN KEY (`session_id`) - REFERENCES `session`(`sess_id`) - ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=INNODB CHARACTER SET utf8 COLLATE utf8_general_ci; |