summaryrefslogtreecommitdiff
path: root/roundcubemail/SQL/mysql.update.sql
diff options
context:
space:
mode:
authoralec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c>2008-11-21 18:19:30 +0000
committeralec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c>2008-11-21 18:19:30 +0000
commite00d46500c4740745ef34e70f5db783fae0a291c (patch)
tree32490e1b94aae3024dc621817c95f0b35423506b /roundcubemail/SQL/mysql.update.sql
parentc8fb75d8b8c4b52b2460e71b91146cbcb579410a (diff)
- Increase speed of session destroy and garbage clean up
- Fix session timeout when DB server got clock skew (#1485490) git-svn-id: https://svn.roundcube.net/trunk@2076 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/SQL/mysql.update.sql')
-rw-r--r--roundcubemail/SQL/mysql.update.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/roundcubemail/SQL/mysql.update.sql b/roundcubemail/SQL/mysql.update.sql
index f88a6c4db..a45ace1fd 100644
--- a/roundcubemail/SQL/mysql.update.sql
+++ b/roundcubemail/SQL/mysql.update.sql
@@ -38,3 +38,6 @@ ALTER TABLE `cache`
REFERENCES `session`(`sess_id`)
ON DELETE CASCADE
ON UPDATE CASCADE;
+
+ALTER TABLE `session`
+ ADD INDEX `changed_index` (`changed`);