setup/postgres/psql_create_tables.sql

Sun, 08 Apr 2018 16:41:02 +0200

author
Mike Becker <universe@uap-core.de>
date
Sun, 08 Apr 2018 16:41:02 +0200
changeset 27
1f2a96efa69f
parent 20
bd1a76c91d5b
child 31
58f78f0142e8
permissions
-rw-r--r--

removes caching of main menu

-- This script creates the module management tables
--

create table lpitcore_module (
    modid       serial          primary key,
    classname   varchar(100)    not null unique,
    visible     boolean         not null default(true)
);

create table lpitcore_user (
    userid          serial          primary key,
    username        varchar(50)     not null unique,
    lastname        varchar(50),
    givenname       varchar(50)
);

create table lpitcore_authorization (
    modid           integer         not null references lpitcore_modules(modid) on delete cascade,
    userid          integer         not null references lpitcore_user(userid) on delete cascade,
    power           integer         not null check(power >= 0)
);

create table lpitcore_menu (
    modid           integer         not null references lpitcore_modules(modid) on delete cascade,
    userid          integer         not null references lpitcore_user(userid) on delete cascade,
    seq             integer         not null
);

mercurial