diff -r 4fa33bfa8fb9 -r 0f4f8f255c32 setup/postgres/psql_create_tables.sql --- a/setup/postgres/psql_create_tables.sql Sun May 10 10:11:10 2020 +0200 +++ b/setup/postgres/psql_create_tables.sql Sun May 10 10:11:37 2020 +0200 @@ -1,28 +1,9 @@ -- 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 -);