From 740196fc9900bb163eed6797118e14885ba73f08 Mon Sep 17 00:00:00 2001 From: "Matteo Nastasi (mop)" Date: Wed, 2 Feb 2011 08:23:35 +0100 Subject: [PATCH] UNIQUE constraint added to login and email fields --- sql/sql.d/001-struct.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) 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 ); -- 2.17.1