Установка.

    
После входа в postgres: <br/>
sudo -u postgres psql<br/>
Создать пользователя logdoc:<br/>
CREATE USER logdoc_demo with PASSWORD 'your_password';<br/>
CREATE DATABASE logdoc;<br/>
GRANT ALL PRIVILEGES ON DATABASE logdoc TO logdoc_demo;<br/>
---======== Структура ========---<br/>
CREATE TABLE IF NOT EXISTS access_groups<br/>
(<br/>
id serial NOT NULL<br/>
CONSTRAINT access_groups_pk<br/>
PRIMARY KEY,<br/>
name text NOT NULL,<br/>
parent_id integer,<br/>
options integer DEFAULT 0 NOT NULL,<br/>
permissions text<br/>
);<br/>
CREATE TABLE IF NOT EXISTS log_selectors<br/>
(<br/>
token text NOT NULL<br/>
CONSTRAINT log_selectors_pk<br/>
PRIMARY KEY,<br/>
md5 text NOT NULL,<br/>
selector text NOT NULL<br/>
);<br/>

CREATE TABLE IF NOT EXISTS users<br/>
(<br/>
id serial NOT NULL<br/>
CONSTRAINT users_pk<br/>
PRIMARY KEY,<br/>
login text NOT NULL,<br/>
password_hash text NOT NULL,<br/>
salt text NOT NULL,<br/>
options integer DEFAULT 0 NOT NULL<br/>
);<br/>

CREATE TABLE IF NOT EXISTS users_favorites<br/>
(<br/>
id serial NOT NULL<br/>
CONSTRAINT users_favorites_pk<br/>
PRIMARY KEY,<br/>
name text NOT NULL,<br/>
date timestamp DEFAULT NOW() NOT NULL,<br/>
token text NOT NULL,<br/>
user_id integer NOT NULL<br/>
);<br/>
CREATE TABLE IF NOT EXISTS users_groups<br/>
(<br/>
user_id integer NOT NULL,<br/>
group_id integer NOT NULL,<br/>
CONSTRAINT users_groups_pk<br/>
PRIMARY KEY (user_id, group_id)<br/>
);<br/>

CREATE TABLE IF NOT EXISTS runports<br/>
(<br/>
port integer NOT NULL,<br/>
id text NOT NULL<br/>
CONSTRAINT runports_pk<br/>
PRIMARY KEY,<br/>
type text NOT NULL<br/>
);<br/>
CREATE TABLE IF NOT EXISTS http_gates<br/>
(<br/>
name text NOT NULL,<br/>
comments text,<br/>
user_id integer NOT NULL,<br/>
id uuid NOT NULL<br/>
CONSTRAINT http_gates_pk<br/>
PRIMARY KEY,<br/>
def_source text NOT NULL,<br/>
def_level text NOT NULL,<br/>
headers_to_map text,<br/>
map_headers boolean DEFAULT FALSE NOT NULL<br/>
);<br/>

CREATE TABLE IF NOT EXISTS user_watchers<br/>
(<br/>
id bigserial<br/>
CONSTRAINT user_watchers_pk<br/>
PRIMARY KEY,<br/>
user_id bigint NOT NULL,<br/>
selector_id text NOT NULL,<br/>
watcher_id text NOT NULL,<br/>
name text,<br/>
started_at text,<br/>
shut boolean DEFAULT FALSE NOT NULL<br/>
);<br/>

CREATE INDEX IF NOT EXISTS user_watchers_shut_index<br/>
ON user_watchers (shut);<br/>
CREATE INDEX IF NOT EXISTS user_watchers_user_id_index<br/>
ON user_watchers (user_id);<br/>
--- ===== Создание пользователя admin/!admin#<br/>
insert into users (login, password_hash, salt, options)<br/>
values ('admin',
'777f256c6684071a335aa8f120b9bd826d335d7cd4a6a0ca5933b875c88a5734',
'sjlstlg79qh5iteo1d6o6mmtut', 22);<br/>
---======== ========---<br/>