From 8b2bf0516a417e517189fa7ea9bd1f45c834a707 Mon Sep 17 00:00:00 2001 From: Andreas Baumann Date: Thu, 30 Apr 2015 12:01:30 +0200 Subject: introduced an user status for registration and active status --- sql/sqlite3.sql | 22 +++++++++++++++++++--- 1 file changed, 19 insertions(+), 3 deletions(-) diff --git a/sql/sqlite3.sql b/sql/sqlite3.sql index beefe6e..ee9abc6 100644 --- a/sql/sqlite3.sql +++ b/sql/sqlite3.sql @@ -1,16 +1,32 @@ +PRAGMA foreign_keys = ON; + drop table if exists login; drop table if exists user; +drop table if exists userstatus; + +create table userstatus( + status char(1) primary key not null, + description varchar(32) not null +); + +insert into userstatus values( 'U', 'User unknown' ); +insert into userstatus values( 'R', 'Currently in registration' ); +insert into userstatus values( 'A', 'Registration ok, user active' ); +insert into userstatus values( 'D', 'User disabled' ); create table user( id integer primary key autoincrement not null, username varchar(32) unique not null, - password varchar(32) not null + password varchar(32) not null, + status char(1) references userstatus(status) default 'U', + registration_start timestamp, + code varchar(32) ); -insert into user(username, password) values('admin','admin'); +insert into user(username, password, status) values('admin','admin', 'A'); create table login( id integer primary key autoincrement not null, user_id integer references user(id), - last_login TIMESTAMP + last_login timestamp ); -- cgit v1.2.3-54-g00ecf