diff options
| author | alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2009-12-17 07:53:52 +0000 |
|---|---|---|
| committer | alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2009-12-17 07:53:52 +0000 |
| commit | 1786227b66523848ff98cf2c500ced33f89af977 (patch) | |
| tree | b65f790309b87b2be7c2a38d280adb1e7fedb66c /roundcubemail/SQL/sqlite.update.sql | |
| parent | aa194190b035df8d7fc72fa48379110b68058c68 (diff) | |
- don't use TRUNCATE on sqlite (#1486374)
git-svn-id: https://svn.roundcube.net/trunk@3184 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/SQL/sqlite.update.sql')
| -rw-r--r-- | roundcubemail/SQL/sqlite.update.sql | 2 |
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); |