setup/postgres/psql_create_tables.sql@58f78f0142e8
setup/postgres/psql_create_tables.sql
Sat, 09 May 2020 14:58:20 +0200
- author
- Mike Becker <universe@uap-core.de>
- date
- Sat, 09 May 2020 14:58:20 +0200
- changeset 31
- 58f78f0142e8
- parent 20
- bd1a76c91d5b
- child 36
- 0f4f8f255c32
- permissions
- -rw-r--r--
adds module priorities
1 -- This script creates the module management tables
2 --
4 create table lpitcore_module (
5 modid serial primary key,
6 classname varchar(100) not null unique,
7 visible boolean not null default(true),
8 priority integer not null default(1000)
9 );
11 create table lpitcore_user (
12 userid serial primary key,
13 username varchar(50) not null unique,
14 lastname varchar(50),
15 givenname varchar(50)
16 );
18 create table lpitcore_authorization (
19 modid integer not null references lpitcore_modules(modid) on delete cascade,
20 userid integer not null references lpitcore_user(userid) on delete cascade,
21 power integer not null check(power >= 0)
22 );
24 create table lpitcore_menu (
25 modid integer not null references lpitcore_modules(modid) on delete cascade,
26 userid integer not null references lpitcore_user(userid) on delete cascade,
27 seq integer not null
28 );
