more robust sql scripts adding IF EXISTS to DROP TABLE statementes

[brisk.git] / sql / sql.d / 001-struct.sql

diff --git a/sql/sql.d/001-struct.sql b/sql/sql.d/001-struct.sql
index 3639258..fa1dc86 100644 (file)
--- a/sql/sql.d/001-struct.sql
+++ b/sql/sql.d/001-struct.sql
@@ -2,18 +2,18 @@
 --   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,
        pass   text,
        email  text UNIQUE,
        type   integer,
-       tsusp  timestamp DEFAULT to_timestamp(0) -- disable timeout
-       mtime  timestamp DEFAULT to_timestamp(0) -- last access
+       tsusp  timestamp DEFAULT to_timestamp(0), -- disable timeout
+       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