summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoralec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c>2009-12-17 07:53:52 +0000
committeralec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c>2009-12-17 07:53:52 +0000
commit1786227b66523848ff98cf2c500ced33f89af977 (patch)
treeb65f790309b87b2be7c2a38d280adb1e7fedb66c
parentaa194190b035df8d7fc72fa48379110b68058c68 (diff)
- don't use TRUNCATE on sqlite (#1486374)
git-svn-id: https://svn.roundcube.net/trunk@3184 208e9e7b-5314-0410-a742-e7e81cd9613c
-rw-r--r--roundcubemail/SQL/sqlite.update.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/roundcubemail/SQL/sqlite.update.sql b/roundcubemail/SQL/sqlite.update.sql
index a3d587326..329e1911c 100644
--- a/roundcubemail/SQL/sqlite.update.sql
+++ b/roundcubemail/SQL/sqlite.update.sql
@@ -37,7 +37,7 @@ CREATE INDEX ix_cache_created ON cache (created);
-- Updates from version 0.3-stable
-TRUNCATE messages;
+DELETE FROM messages;
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);