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

diff --git a/sql/sql.d/001-struct.sql b/sql/sql.d/001-struct.sql
index a95af6b..024d58f 100644
--- a/sql/sql.d/001-struct.sql
+++ b/sql/sql.d/001-struct.sql
@@ -4,15 +4,15 @@
 
 DROP TABLE #PFX#users;
 CREATE TABLE #PFX#users (
-                        code  integer PRIMARY KEY,
-                        login text,
+                        code  SERIAL PRIMARY KEY,
+                        login text UNIQUE,
                         pass  text,
-                        email text,
+                        email text UNIQUE,
                         type  integer
                         );
 
 DROP TABLE #PFX#groups;
 CREATE TABLE #PFX#groups (
-                        code  integer PRIMARY KEY,
+                        code  SERIAL PRIMARY KEY,
                         gname text
                         );