From dcf780a6bd5065ffb0dcc76233b1e5f601e258d2 Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
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

---
 SQL/mysql.update.sql | 7 ++-----
 1 file changed, 2 insertions(+), 5 deletions(-)

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

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

