summaryrefslogtreecommitdiff
path: root/SQL
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:54 +0100
commit64808edbc84b427824e968a10e4a7e24a35f1c02 (patch)
treed8f0bdab4a4cbd0197adbc38c6ba383e166e07a2 /SQL
parent357485e7e154f6fef66cb26438644e574c02c6a3 (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')
-rw-r--r--SQL/mysql/2013011000.sql2
-rw-r--r--SQL/sqlite/2013011000.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/SQL/mysql/2013011000.sql b/SQL/mysql/2013011000.sql
index f0b5e6a03..d1ea001db 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 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
);