server/db/auth_db.sql - master - Jackmas/isr

server/db/auth_db.sql
90 строк2 KB
jackmas
20102025_5
20 окт 2025, 11:26
20 окт 2025, 11:26b270612
--
-- PostgreSQL database dump
--

-- Dumped from database version 16.3 (Ubuntu 16.3-1.pgdg22.04+1)
-- Dumped by pg_dump version 16.3 (Ubuntu 16.3-1.pgdg22.04+1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: auth_logger; Type: TABLE; Schema: public; Owner: dbmaster
--

CREATE TABLE public.auth_logger (
    dt timestamp without time zone,
    method text,
    url text,
    client text,
    headers text,
    status text,
    proc_time text,
    body text,
    response text
);


ALTER TABLE public.auth_logger OWNER TO dbmaster;

--
-- Name: auth_task; Type: TABLE; Schema: public; Owner: dbmaster
--

CREATE TABLE public.auth_task (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    "НачалоЗадачи" timestamp without time zone,
    "ОкончаниеЗадачи" timestamp without time zone,
    "СтатусЗадачи" text,
    "ОписаниеЗадачи" text,
    "ШагЗадачи" integer NOT NULL,
    doc_id uuid NOT NULL
);


ALTER TABLE public.auth_task OWNER TO dbmaster;

--
-- Name: auth_tbl; Type: TABLE; Schema: public; Owner: dbmaster
--

CREATE TABLE public.auth_tbl (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    "DeletionMark" boolean,
    token text,
    dbparam text,
    record_date timestamp without time zone
);


ALTER TABLE public.auth_tbl OWNER TO dbmaster;

--
-- Name: task_log; Type: TABLE; Schema: public; Owner: dbmaster
--

CREATE TABLE public.task_log (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    "ДатаЗаписи" timestamp without time zone,
    "Журнал" jsonb,
    task_id uuid NOT NULL
);


ALTER TABLE public.task_log OWNER TO dbmaster;

--
-- PostgreSQL database dump complete
--