summaryrefslogtreecommitdiff
path: root/SQL/mysql.update.sql
diff options
context:
space:
mode:
Diffstat (limited to 'SQL/mysql.update.sql')
-rw-r--r--SQL/mysql.update.sql7
1 files changed, 2 insertions, 5 deletions
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`);