1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/setup/postgres/psql_create_tables.sql Sat Mar 31 19:35:04 2018 +0200
1.3 @@ -0,0 +1,27 @@
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 +);
1.12 +
1.13 +create table lpitcore_user (
1.14 + userid serial primary key,
1.15 + username varchar(50) not null unique,
1.16 + lastname varchar(50),
1.17 + givenname varchar(50)
1.18 +);
1.19 +
1.20 +create table lpitcore_authorization (
1.21 + modid integer not null references lpitcore_modules(modid) on delete cascade,
1.22 + userid integer not null references lpitcore_user(userid) on delete cascade,
1.23 + power integer not null check(power >= 0)
1.24 +);
1.25 +
1.26 +create table lpitcore_menu (
1.27 + modid integer not null references lpitcore_modules(modid) on delete cascade,
1.28 + userid integer not null references lpitcore_user(userid) on delete cascade,
1.29 + seq integer not null
1.30 +);
