diff options
| author | alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2008-11-21 14:33:58 +0000 |
|---|---|---|
| committer | alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2008-11-21 14:33:58 +0000 |
| commit | c8fb75d8b8c4b52b2460e71b91146cbcb579410a (patch) | |
| tree | 01fd7db910d680634656b5691e9796538f1b1ceb /roundcubemail/SQL/mysql.update.sql | |
| parent | 685b4ae56fe7da703f3dd8e7de692ec08b34ff7c (diff) | |
- Fix 'cache' table cleanup on session destroy (#1485516)
git-svn-id: https://svn.roundcube.net/trunk@2075 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/SQL/mysql.update.sql')
| -rw-r--r-- | roundcubemail/SQL/mysql.update.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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; |