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

setup/postgres/psql_create_tables.sql@bd1a76c91d5b (annotated)

Sat, 31 Mar 2018 19:35:04 +0200

module synchronization with database

 -- 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
 );