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

diff --git a/sql/sql.d/001-struct.sql b/sql/sql.d/001-struct.sql
index 024d58f..fa1dc86 100644
--- a/sql/sql.d/001-struct.sql
+++ b/sql/sql.d/001-struct.sql
@@ -2,17 +2,21 @@
 --   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
-                        );
+       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
+       );
 
-DROP TABLE #PFX#groups;
+DROP TABLE IF EXISTS #PFX#groups;
 CREATE TABLE #PFX#groups (
-                        code  SERIAL PRIMARY KEY,
-                        gname text
-                        );
+       code   SERIAL PRIMARY KEY,
+       name   text
+       );
+
+