setup/postgres/psql_create_tables.sql

Sat, 07 Apr 2018 23:01:58 +0200

author
Mike Becker <universe@uap-core.de>
date
Sat, 07 Apr 2018 23:01:58 +0200
changeset 23
a7d3e5921cce
parent 20
bd1a76c91d5b
child 31
58f78f0142e8
permissions
-rw-r--r--

global table style

-- 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