summaryrefslogtreecommitdiff
path: root/roundcubemail/SQL/sqlite.update.sql
diff options
context:
space:
mode:
authoralec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c>2009-09-13 08:12:58 +0000
committeralec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c>2009-09-13 08:12:58 +0000
commit3f927eabd6c126c9385834726726e4609d818b82 (patch)
tree69b7808924fbbd0469e08052bbad3ed56807507a /roundcubemail/SQL/sqlite.update.sql
parentbf7160c636a33b07a95f87e8e218456844c8d44b (diff)
- "TRUNCATE messages" is required to remove buggy cache entries
git-svn-id: https://svn.roundcube.net/trunk@2952 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/SQL/sqlite.update.sql')
-rw-r--r--roundcubemail/SQL/sqlite.update.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/roundcubemail/SQL/sqlite.update.sql b/roundcubemail/SQL/sqlite.update.sql
index 5c68cbb36..4b1b10b7f 100644
--- a/roundcubemail/SQL/sqlite.update.sql
+++ b/roundcubemail/SQL/sqlite.update.sql
@@ -40,3 +40,4 @@ CREATE INDEX ix_cache_created ON cache (created);
DROP INDEX ix_messages_user_cache_uid;
CREATE UNIQUE INDEX ix_messages_user_cache_uid ON messages (user_id,cache_key,uid);
CREATE INDEX ix_messages_index ON messages (user_id,cache_key,idx);
+TRUNCATE messages;