summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoralecpl <alec@alec.pl>2009-12-17 07:53:52 +0000
committeralecpl <alec@alec.pl>2009-12-17 07:53:52 +0000
commit9273c8379098172fb0e3c70ca457cedf71c479b5 (patch)
treef5b5cc9d60aa9f8d7f55265f3c239fb12a031353
parent9e63e28a80dab8b1a249a108c5512ec85f7332d1 (diff)
- don't use TRUNCATE on sqlite (#1486374)
-rw-r--r--SQL/sqlite.update.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/SQL/sqlite.update.sql b/SQL/sqlite.update.sql
index a3d587326..329e1911c 100644
--- a/SQL/sqlite.update.sql
+++ b/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);