From daed092b293e227909e29f5b7aad7c9aa38d47ac Mon Sep 17 00:00:00 2001
From: alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c>
Date: Sat, 22 Nov 2008 18:06:13 +0000
Subject: - 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
---
 roundcubemail/SQL/mysql.update.sql | 7 ++-----
 1 file changed, 2 insertions(+), 5 deletions(-)

(limited to 'roundcubemail/SQL/mysql.update.sql')

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`);
-- 
cgit v1.2.3