diff options
Diffstat (limited to 'SQL/mysql.update.sql')
-rw-r--r-- | SQL/mysql.update.sql | 7 |
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`); |