From be7d3b6918ff90757d10804ac914edb5a65f4828 Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
Date: Fri, 21 Nov 2008 14:33:58 +0000
Subject: - Fix 'cache' table cleanup on session destroy (#1485516)

---
 SQL/mysql.update.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

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

diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
index ae6fb7533..f88a6c4db 100644
--- a/SQL/mysql.update.sql
+++ b/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

