kivitendo/sql/auth_db.sql @ 4cb374f9
| 8c7e4493 | Moritz Bunkus | CREATE SCHEMA auth;
|
|
CREATE SEQUENCE auth.user_id_seq;
|
|||
CREATE SEQUENCE auth.group_id_seq;
|
|||
CREATE TABLE auth."user" (
|
|||
id integer NOT NULL DEFAULT nextval('auth.user_id_seq'),
|
|||
login text UNIQUE NOT NULL,
|
|||
password text,
|
|||
PRIMARY KEY (id)
|
|||
);
|
|||
CREATE TABLE auth."group" (
|
|||
id integer NOT NULL DEFAULT nextval('auth.group_id_seq'),
|
|||
name text UNIQUE NOT NULL,
|
|||
description text,
|
|||
PRIMARY KEY (id)
|
|||
);
|
|||
CREATE TABLE auth.user_group (
|
|||
user_id integer NOT NULL,
|
|||
group_id integer NOT NULL,
|
|||
FOREIGN KEY (user_id) REFERENCES auth."user" (id),
|
|||
FOREIGN KEY (group_id) REFERENCES auth."group" (id)
|
|||
);
|
|||
CREATE TABLE auth.group_rights (
|
|||
group_id integer NOT NULL,
|
|||
"right" text NOT NULL,
|
|||
granted boolean NOT NULL,
|
|||
FOREIGN KEY (group_id) REFERENCES auth."group" (id)
|
|||
);
|
|||
CREATE TABLE auth.user_config (
|
|||
user_id integer NOT NULL,
|
|||
cfg_key text NOT NULL,
|
|||
cfg_value text,
|
|||
FOREIGN KEY (user_id) REFERENCES auth."user" (id)
|
|||
);
|
|||
CREATE TABLE auth.schema_info (
|
|||
tag text,
|
|||
login text,
|
|||
itime timestamp DEFAULT now(),
|
|||
PRIMARY KEY (tag)
|
|||
);
|
|||
CREATE TABLE auth.session (
|
|||
id text,
|
|||
ip_address inet,
|
|||
mtime timestamp,
|
|||
PRIMARY KEY (id)
|
|||
);
|
|||
CREATE TABLE auth.session_content (
|
|||
session_id text,
|
|||
sess_key text,
|
|||
sess_value text,
|
|||
FOREIGN KEY (session_id) REFERENCES auth.session (id)
|
|||
);
|