1.1 --- a/setup/postgres/psql_create_tables.sql Sun May 10 10:11:10 2020 +0200
1.2 +++ b/setup/postgres/psql_create_tables.sql Sun May 10 10:11:37 2020 +0200
1.3 @@ -1,28 +1,9 @@
1.4 -- This script creates the module management tables
1.5 --
1.6
1.7 -create table lpitcore_module (
1.8 - modid serial primary key,
1.9 - classname varchar(100) not null unique,
1.10 - visible boolean not null default(true),
1.11 - priority integer not null default(1000)
1.12 -);
1.13 -
1.14 create table lpitcore_user (
1.15 userid serial primary key,
1.16 username varchar(50) not null unique,
1.17 lastname varchar(50),
1.18 givenname varchar(50)
1.19 );
1.20 -
1.21 -create table lpitcore_authorization (
1.22 - modid integer not null references lpitcore_modules(modid) on delete cascade,
1.23 - userid integer not null references lpitcore_user(userid) on delete cascade,
1.24 - power integer not null check(power >= 0)
1.25 -);
1.26 -
1.27 -create table lpitcore_menu (
1.28 - modid integer not null references lpitcore_modules(modid) on delete cascade,
1.29 - userid integer not null references lpitcore_user(userid) on delete cascade,
1.30 - seq integer not null
1.31 -);
