From bcfdac6660b2c3d1527d1e993f63f345992d0afa Mon Sep 17 00:00:00 2001
From: Thomas Bruederli <thomas@roundcube.net>
Date: Thu, 28 Mar 2013 12:42:09 -0400
Subject: [PATCH] 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 +-
 SQL/mysql/2013011000.sql  |    2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/SQL/mysql/2013011000.sql b/SQL/mysql/2013011000.sql
index f0b5e6a..d1ea001 100644
--- a/SQL/mysql/2013011000.sql
+++ b/SQL/mysql/2013011000.sql
@@ -1,6 +1,6 @@
 -- Upgrade from 0.9-beta
 
-CREATE TABLE `system` (
+CREATE TABLE IF NOT EXISTS `system` (
  `name` varchar(64) NOT NULL,
  `value` mediumtext,
  PRIMARY KEY(`name`)
diff --git a/SQL/sqlite/2013011000.sql b/SQL/sqlite/2013011000.sql
index 2c66ef9..ec261a6 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
 );

--
Gitblit v1.9.1