- 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

1 files changed, 2 insertions, 5 deletions

diff --git a/roundcubemail/SQL/mysql.update.sql b/roundcubemail/SQL/mysql.update.sql
index a45ace1fd..1e8979d87 100644
--- a/roundcubemail/SQL/mysql.update.sql
+++ b/roundcubemail/SQL/mysql.update.sql
@@ -34,10 +34,7 @@ ALTER TABLE `messages`
 -- Updates from version 0.2-beta (InnoDB only)
 
 ALTER TABLE `cache`
-    ADD CONSTRAINT `session_id_fk_cache` FOREIGN KEY (`session_id`)
-    REFERENCES `session`(`sess_id`)
-    ON DELETE CASCADE
-    ON UPDATE CASCADE;
-
+    DROP `session_id`;
+    
 ALTER TABLE `session`
     ADD INDEX `changed_index` (`changed`);