LightPIT: setup/postgres/psql_create_tables.sql@58f78f0142e8 (annotated)

setup/postgres/psql_create_tables.sql@58f78f0142e8 (annotated)

Sat, 09 May 2020 14:58:20 +0200

adds module priorities

 -- 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),
     priority    integer         not null default(1000)
 );
 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
 );