setup/postgres/psql_create_tables.sql

-- This script creates the module management tables
--

create table lpitcore_module (
    modid       serial          primary key,
    classname   varchar(100)    not null unique,
    visible     boolean         not null default(true)
);

create table lpitcore_user (
    userid          serial          primary key,
    username        varchar(50)     not null unique,
    lastname        varchar(50),
    givenname       varchar(50)
);

create table lpitcore_authorization (
    modid           integer         not null references lpitcore_modules(modid) on delete cascade,
    userid          integer         not null references lpitcore_user(userid) on delete cascade,
    power           integer         not null check(power >= 0)
);

create table lpitcore_menu (
    modid           integer         not null references lpitcore_modules(modid) on delete cascade,
    userid          integer         not null references lpitcore_user(userid) on delete cascade,
    seq             integer         not null
);