Sun, 08 Apr 2018 15:34:11 +0200
Module names and descriptions + some more styling
universe@20 | 1 | -- This script creates the module management tables |
universe@20 | 2 | -- |
universe@2 | 3 | |
universe@20 | 4 | create table lpitcore_module ( |
universe@20 | 5 | modid serial primary key, |
universe@20 | 6 | classname varchar(100) not null unique, |
universe@20 | 7 | visible boolean not null default(true) |
universe@20 | 8 | ); |
universe@2 | 9 | |
universe@20 | 10 | create table lpitcore_user ( |
universe@20 | 11 | userid serial primary key, |
universe@20 | 12 | username varchar(50) not null unique, |
universe@20 | 13 | lastname varchar(50), |
universe@20 | 14 | givenname varchar(50) |
universe@20 | 15 | ); |
universe@2 | 16 | |
universe@20 | 17 | create table lpitcore_authorization ( |
universe@20 | 18 | modid integer not null references lpitcore_modules(modid) on delete cascade, |
universe@20 | 19 | userid integer not null references lpitcore_user(userid) on delete cascade, |
universe@20 | 20 | power integer not null check(power >= 0) |
universe@20 | 21 | ); |
universe@5 | 22 | |
universe@20 | 23 | create table lpitcore_menu ( |
universe@20 | 24 | modid integer not null references lpitcore_modules(modid) on delete cascade, |
universe@20 | 25 | userid integer not null references lpitcore_user(userid) on delete cascade, |
universe@20 | 26 | seq integer not null |
universe@20 | 27 | ); |