X-Git-Url: http://mop.ddnsfree.com/gitweb/?p=brisk.git;a=blobdiff_plain;f=sql%2Fsql.d%2F001-struct.sql;h=fa1dc8689a688b219980bf8d61796ac95cc0266c;hp=302804e76290635de4788232530b3ad0aebd3d4e;hb=484a365c1e66ba4b878117275423a1594c209960;hpb=31bfc5e122ec3db5c70e2587a23fabd0dae5ee33

diff --git a/sql/sql.d/001-struct.sql b/sql/sql.d/001-struct.sql
index 302804e..fa1dc86 100644
--- a/sql/sql.d/001-struct.sql
+++ b/sql/sql.d/001-struct.sql
@@ -2,7 +2,7 @@
 --   DONE - CASCADE ON DELETE of orders related tables
 --   DONE - STATUS on orders
 
-DROP TABLE #PFX#users;
+DROP TABLE IF EXISTS #PFX#users;
 CREATE TABLE #PFX#users (
        code   SERIAL PRIMARY KEY,
        login  text UNIQUE,
@@ -13,7 +13,7 @@ CREATE TABLE #PFX#users (
        mtime  timestamp DEFAULT to_timestamp(0)  -- last access
        );
 
-DROP TABLE #PFX#groups;
+DROP TABLE IF EXISTS #PFX#groups;
 CREATE TABLE #PFX#groups (
        code   SERIAL PRIMARY KEY,
        name   text