From bcfdac6660b2c3d1527d1e993f63f345992d0afa Mon Sep 17 00:00:00 2001 From: Thomas Bruederli 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') 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