From: Matteo Nastasi (mop) <nastasi@alternativeoutput.it>
Date: Thu, 10 Feb 2011 17:56:01 +0000 (+0100)
Subject: tsusp and mtime field added to users table (disable timeout and last access), rename... 
X-Git-Tag: 3.1.0~14
X-Git-Url: https://mop.ddnsfree.com/gitweb/?p=brisk.git;a=commitdiff_plain;h=9fba6a242795ed609150c23ab6ea886a3b78e718

tsusp and mtime field added to users table (disable timeout and last access), rename field gname in name in groups table
---

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