setup/postgres/psql_create_tables.sql@bd1a76c91d5b
setup/postgres/psql_create_tables.sql
Sat, 31 Mar 2018 19:35:04 +0200
- author
- Mike Becker <universe@uap-core.de>
- date
- Sat, 31 Mar 2018 19:35:04 +0200
- changeset 20
- bd1a76c91d5b
- parent 16
- setup/postgres/psql_create_database.sql@4e0998805276
- child 31
- 58f78f0142e8
- permissions
- -rw-r--r--
module synchronization with database
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 );
10 create table lpitcore_user (
11 userid serial primary key,
12 username varchar(50) not null unique,
13 lastname varchar(50),
14 givenname varchar(50)
15 );
17 create table lpitcore_authorization (
18 modid integer not null references lpitcore_modules(modid) on delete cascade,
19 userid integer not null references lpitcore_user(userid) on delete cascade,
20 power integer not null check(power >= 0)
21 );
23 create table lpitcore_menu (
24 modid integer not null references lpitcore_modules(modid) on delete cascade,
25 userid integer not null references lpitcore_user(userid) on delete cascade,
26 seq integer not null
27 );
