From c8fb75d8b8c4b52b2460e71b91146cbcb579410a Mon Sep 17 00:00:00 2001
From: alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c>
Date: Fri, 21 Nov 2008 14:33:58 +0000
Subject: - Fix 'cache' table cleanup on session destroy (#1485516)

git-svn-id: https://svn.roundcube.net/trunk@2075 208e9e7b-5314-0410-a742-e7e81cd9613c
---
 roundcubemail/SQL/mysql.update.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

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

diff --git a/roundcubemail/SQL/mysql.update.sql b/roundcubemail/SQL/mysql.update.sql
index ae6fb7533..f88a6c4db 100644
--- a/roundcubemail/SQL/mysql.update.sql
+++ b/roundcubemail/SQL/mysql.update.sql
@@ -30,3 +30,11 @@ ALTER TABLE `identities`
 
 ALTER TABLE `messages`
     ADD INDEX `created_index` (`created`);
+
+-- 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;
-- 
cgit v1.2.3

