summaryrefslogtreecommitdiff
path: root/SQL/sqlite
diff options
context:
space:
mode:
authorThomas Bruederli <thomas@roundcube.net>2013-03-28 17:42:09 +0100
committerThomas Bruederli <thomas@roundcube.net>2013-03-28 17:42:09 +0100
commitbcfdac6660b2c3d1527d1e993f63f345992d0afa (patch)
tree932051fb81ed3d249b0cd822ab7a906f816ae7b8 /SQL/sqlite
parent589083a94c2e5d50914fba99c80c18d730af697a (diff)
Add 'if not exists' to system table creation. Just in case some previous db update routine was aborted or failed
Diffstat (limited to 'SQL/sqlite')
-rw-r--r--SQL/sqlite/2013011000.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/SQL/sqlite/2013011000.sql b/SQL/sqlite/2013011000.sql
index 2c66ef95e..ec261a635 100644
--- a/SQL/sqlite/2013011000.sql
+++ b/SQL/sqlite/2013011000.sql
@@ -1,6 +1,6 @@
-- Updates from version 0.9-beta
-CREATE TABLE system (
+CREATE TABLE IF NOT EXISTS system (
name varchar(64) NOT NULL PRIMARY KEY,
value text NOT NULL
);