~azzar1/unity/add-show-desktop-key

users.sql: constrain the rolenm to be from a given set of roles.
add a state field which shows whether the clickthrough is done.

added added

removed removed

CREATE TABLE login (

loginid SERIAL PRIMARY KEY NOT NULL,

passhash VARCHAR,

state VARCHAR NOT NULL CHECK (state in ('no_agreement', 'enabled', 'disabled')),

unixid INT UNIQUE NOT NULL, -- unix user id

passhash VARCHAR,

nick VARCHAR,

fullname VARCHAR,

rolenm VARCHAR,

nick VARCHAR NOT NULL,

fullname VARCHAR NOT NULL,

rolenm VARCHAR NOT NULL CHECK (rolenm in ('anyone', 'student', 'tutor', 'lecturer', 'admin')),

studentid VARCHAR -- may be null

);