From bcfdac6660b2c3d1527d1e993f63f345992d0afa Mon Sep 17 00:00:00 2001
From: Thomas Bruederli <thomas@roundcube.net>
Date: Thu, 28 Mar 2013 17:42:09 +0100
Subject: Add 'if not exists' to system table creation. Just in case some
 previous db update routine was aborted or failed

---
 SQL/sqlite/2013011000.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'SQL/sqlite/2013011000.sql')

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
 );
-- 
cgit v1.2.3

