From 66e3a458b3de1bc3e8c4511d6c0cebbb6a346d23 Mon Sep 17 00:00:00 2001 From: Andreas Baumann Date: Fri, 31 Jul 2015 15:35:04 +0200 Subject: print name can be reused between logins --- sql/sqlite3.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/sqlite3.sql b/sql/sqlite3.sql index 46a9d83..c32d626 100644 --- a/sql/sqlite3.sql +++ b/sql/sqlite3.sql @@ -17,7 +17,7 @@ insert into userstatus values( 'D', 'User disabled' ); create table user( id integer primary key autoincrement not null, username varchar(32) unique not null, - printname varchar(32) unique not null, + printname varchar(32), password varchar(32) not null, email varchar(32), status char(1) references userstatus(status) default 'U', -- cgit v1.2.3-54-g00ecf