\c "account_applications";

--
-- PostgreSQL database dump
--

-- Dumped from database version 15.4
-- Dumped by pg_dump version 15.2

-- Started on 2024-11-27 13:25:53

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;

--
-- TOC entry 7 (class 2615 OID 2446848)
-- Name: security; Type: SCHEMA; Schema: -; Owner: ervu_account_applications
--

CREATE SCHEMA security;


ALTER SCHEMA security OWNER TO ervu_account_applications;

--
-- TOC entry 2 (class 3079 OID 2447121)
-- Name: uuid-ossp; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public;


--
-- TOC entry 4243 (class 0 OID 0)
-- Dependencies: 2
-- Name: EXTENSION "uuid-ossp"; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION "uuid-ossp" IS 'generate universally unique identifiers (UUIDs)';


SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- TOC entry 233 (class 1259 OID 2447109)
-- Name: databasechangelog; Type: TABLE; Schema: public; Owner: ervu_account_applications
--

CREATE TABLE public.databasechangelog (
    id character varying(255) NOT NULL,
    author character varying(255) NOT NULL,
    filename character varying(255) NOT NULL,
    dateexecuted timestamp without time zone NOT NULL,
    orderexecuted integer NOT NULL,
    exectype character varying(10) NOT NULL,
    md5sum character varying(35),
    description character varying(255),
    comments character varying(255),
    tag character varying(255),
    liquibase character varying(20),
    contexts character varying(255),
    labels character varying(255),
    deployment_id character varying(10)
);


ALTER TABLE public.databasechangelog OWNER TO ervu_account_applications;

--
-- TOC entry 234 (class 1259 OID 2447114)
-- Name: databasechangeloglock; Type: TABLE; Schema: public; Owner: ervu_account_applications
--

CREATE TABLE public.databasechangeloglock (
    id integer NOT NULL,
    locked boolean NOT NULL,
    lockgranted timestamp without time zone,
    lockedby character varying(255)
);


ALTER TABLE public.databasechangeloglock OWNER TO ervu_account_applications;

--
-- TOC entry 236 (class 1259 OID 2447133)
-- Name: job_position; Type: TABLE; Schema: public; Owner: ervu_account_applications
--

CREATE TABLE public.job_position (
    job_position_id bigint NOT NULL,
    name character varying(100) NOT NULL,
    code character varying(100) NOT NULL,
    start_date timestamp without time zone DEFAULT now() NOT NULL,
    close_date timestamp without time zone
);


ALTER TABLE public.job_position OWNER TO ervu_account_applications;

--
-- TOC entry 235 (class 1259 OID 2447132)
-- Name: job_position_job_position_id_seq; Type: SEQUENCE; Schema: public; Owner: ervu_account_applications
--

CREATE SEQUENCE public.job_position_job_position_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.job_position_job_position_id_seq OWNER TO ervu_account_applications;

--
-- TOC entry 4244 (class 0 OID 0)
-- Dependencies: 235
-- Name: job_position_job_position_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ervu_account_applications
--

ALTER SEQUENCE public.job_position_job_position_id_seq OWNED BY public.job_position.job_position_id;


--
-- TOC entry 243 (class 1259 OID 2447162)
-- Name: link_user_application_user_group; Type: TABLE; Schema: public; Owner: ervu_account_applications
--

CREATE TABLE public.link_user_application_user_group (
    link_user_application_user_group_id bigint NOT NULL,
    user_application_list_id bigint NOT NULL,
    user_group_id character(36) NOT NULL,
    created timestamp without time zone DEFAULT now()
);


ALTER TABLE public.link_user_application_user_group OWNER TO ervu_account_applications;

--
-- TOC entry 242 (class 1259 OID 2447161)
-- Name: link_user_application_user_gr_link_user_application_user_gr_seq; Type: SEQUENCE; Schema: public; Owner: ervu_account_applications
--

CREATE SEQUENCE public.link_user_application_user_gr_link_user_application_user_gr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.link_user_application_user_gr_link_user_application_user_gr_seq OWNER TO ervu_account_applications;

--
-- TOC entry 4245 (class 0 OID 0)
-- Dependencies: 242
-- Name: link_user_application_user_gr_link_user_application_user_gr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ervu_account_applications
--

ALTER SEQUENCE public.link_user_application_user_gr_link_user_application_user_gr_seq OWNED BY public.link_user_application_user_group.link_user_application_user_group_id;


--
-- TOC entry 244 (class 1259 OID 2447183)
-- Name: recruitment; Type: TABLE; Schema: public; Owner: ervu_account_applications
--

CREATE TABLE public.recruitment (
    id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    idm_id character varying(256),
    parent_id character varying,
    version integer,
    created_at timestamp without time zone DEFAULT now() NOT NULL,
    updated_at timestamp without time zone DEFAULT now() NOT NULL,
    schema character varying(64) NOT NULL,
    military_code character varying(16),
    shortname character varying NOT NULL,
    fullname character varying NOT NULL,
    dns character varying(64),
    email character varying(255),
    phone character varying(24),
    address character varying,
    address_id character varying,
    postal_address character varying,
    postal_address_id character varying,
    nsi_department_id character varying,
    nsi_organization_id character varying,
    oktmo character varying,
    org_ogrn character varying,
    dep_ogrn character varying,
    epgu_id character varying,
    kpp character varying(64),
    inn character varying(64),
    okato character varying(64),
    division_type character varying(64),
    tns_department_id character varying,
    enabled boolean DEFAULT true NOT NULL,
    timezone character varying(64),
    reports_enabled boolean,
    region_id character varying,
    subpoena_series_code character varying(64),
    hidden boolean DEFAULT false NOT NULL,
    region_code text,
    ts timestamp without time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.recruitment OWNER TO ervu_account_applications;

--
-- TOC entry 4246 (class 0 OID 0)
-- Dependencies: 244
-- Name: TABLE recruitment; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON TABLE public.recruitment IS 'Военный комиссариат';


--
-- TOC entry 4247 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.id; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.id IS 'Идентификатор ВК';


--
-- TOC entry 4248 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.idm_id; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.idm_id IS 'Идентификатор организации';


--
-- TOC entry 4249 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.parent_id; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.parent_id IS 'Идентификатор вышестоящей организации';


--
-- TOC entry 4250 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.version; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.version IS 'Версия записи';


--
-- TOC entry 4251 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.created_at; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.created_at IS 'Дата создания';


--
-- TOC entry 4252 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.updated_at; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.updated_at IS 'Дата обновления';


--
-- TOC entry 4253 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.schema; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.schema IS 'Схема';


--
-- TOC entry 4254 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.military_code; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.military_code IS 'Код организации';


--
-- TOC entry 4255 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.shortname; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.shortname IS 'Укороченное наименование организации';


--
-- TOC entry 4256 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.fullname; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.fullname IS 'Полное наименование организации';


--
-- TOC entry 4257 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.dns; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.dns IS 'ДНС организации';


--
-- TOC entry 4258 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.email; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.email IS 'Е-mail организации';


--
-- TOC entry 4259 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.phone; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.phone IS 'Телефон организации';


--
-- TOC entry 4260 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.address; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.address IS 'Адрес организации';


--
-- TOC entry 4261 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.address_id; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.address_id IS 'Идентификатор адреса организации';


--
-- TOC entry 4262 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.postal_address; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.postal_address IS 'Почтовый адрес организации';


--
-- TOC entry 4263 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.postal_address_id; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.postal_address_id IS 'Идентификатор почтового адреса организации';


--
-- TOC entry 4264 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.nsi_department_id; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.nsi_department_id IS 'Идентификатор департамента из НСИ';


--
-- TOC entry 4265 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.nsi_organization_id; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.nsi_organization_id IS 'Идентификатор организации из НСИ';


--
-- TOC entry 4266 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.oktmo; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.oktmo IS 'ОКТМО';


--
-- TOC entry 4267 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.org_ogrn; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.org_ogrn IS 'ОГРН организации';


--
-- TOC entry 4268 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.dep_ogrn; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.dep_ogrn IS 'ОГРН департамента';


--
-- TOC entry 4269 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.epgu_id; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.epgu_id IS 'Идентификатор ЕПГУ';


--
-- TOC entry 4270 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.kpp; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.kpp IS 'КПП';


--
-- TOC entry 4271 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.inn; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.inn IS 'ИНН';


--
-- TOC entry 4272 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.okato; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.okato IS 'ОКАТО';


--
-- TOC entry 4273 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.division_type; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.division_type IS 'Тип дивизиона';


--
-- TOC entry 4274 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.tns_department_id; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.tns_department_id IS 'Идентификатор департамента из ТНС';


--
-- TOC entry 4275 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.enabled; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.enabled IS 'Признак актуальности';


--
-- TOC entry 4276 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.timezone; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.timezone IS 'Часовой пояс';


--
-- TOC entry 4277 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.reports_enabled; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.reports_enabled IS 'Признак актуальности для отчета';


--
-- TOC entry 4278 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.region_id; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.region_id IS 'Идентификатор региона';


--
-- TOC entry 4279 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.subpoena_series_code; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.subpoena_series_code IS 'Серия';


--
-- TOC entry 4280 (class 0 OID 0)
-- Dependencies: 244
-- Name: COLUMN recruitment.hidden; Type: COMMENT; Schema: public; Owner: ervu_account_applications
--

COMMENT ON COLUMN public.recruitment.hidden IS 'Признак скрытого';


--
-- TOC entry 238 (class 1259 OID 2447141)
-- Name: user_application_document; Type: TABLE; Schema: public; Owner: ervu_account_applications
--

CREATE TABLE public.user_application_document (
    user_application_document_id bigint NOT NULL,
    file_name character varying(100),
    file bytea,
    user_application_list_id bigint NOT NULL
);


ALTER TABLE public.user_application_document OWNER TO ervu_account_applications;

--
-- TOC entry 237 (class 1259 OID 2447140)
-- Name: user_application_document_user_application_document_id_seq; Type: SEQUENCE; Schema: public; Owner: ervu_account_applications
--

CREATE SEQUENCE public.user_application_document_user_application_document_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_application_document_user_application_document_id_seq OWNER TO ervu_account_applications;

--
-- TOC entry 4281 (class 0 OID 0)
-- Dependencies: 237
-- Name: user_application_document_user_application_document_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ervu_account_applications
--

ALTER SEQUENCE public.user_application_document_user_application_document_id_seq OWNED BY public.user_application_document.user_application_document_id;


--
-- TOC entry 241 (class 1259 OID 2447151)
-- Name: user_application_list; Type: TABLE; Schema: public; Owner: ervu_account_applications
--

CREATE TABLE public.user_application_list (
    user_application_list_id bigint NOT NULL,
    application_kind character varying(100) NOT NULL,
    user_login character varying(100) NOT NULL,
    user_password character varying(100),
    secondname character varying(1000) NOT NULL,
    firstname character varying(1000) NOT NULL,
    middlename character varying(1000),
    phone character varying(20),
    ip_address character varying(1000),
    start_date timestamp without time zone DEFAULT now() NOT NULL,
    close_date timestamp without time zone,
    user_status character varying(50),
    application_status character varying(100) NOT NULL,
    comment character varying,
    job_position_id bigint,
    user_role_id bigint,
    recruitment_id uuid,
    user_account_id character varying,
    sex character varying,
    birth_date date,
    snils character varying,
    job_position character varying,
    ip_address_additional character varying,
    number_app bigint NOT NULL,
    edit_comment character varying
);


ALTER TABLE public.user_application_list OWNER TO ervu_account_applications;

--
-- TOC entry 240 (class 1259 OID 2447150)
-- Name: user_application_list_number_app_seq; Type: SEQUENCE; Schema: public; Owner: ervu_account_applications
--

CREATE SEQUENCE public.user_application_list_number_app_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_application_list_number_app_seq OWNER TO ervu_account_applications;

--
-- TOC entry 4282 (class 0 OID 0)
-- Dependencies: 240
-- Name: user_application_list_number_app_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ervu_account_applications
--

ALTER SEQUENCE public.user_application_list_number_app_seq OWNED BY public.user_application_list.number_app;


--
-- TOC entry 239 (class 1259 OID 2447149)
-- Name: user_application_list_user_application_list_id_seq; Type: SEQUENCE; Schema: public; Owner: ervu_account_applications
--

CREATE SEQUENCE public.user_application_list_user_application_list_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_application_list_user_application_list_id_seq OWNER TO ervu_account_applications;

--
-- TOC entry 4283 (class 0 OID 0)
-- Dependencies: 239
-- Name: user_application_list_user_application_list_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ervu_account_applications
--

ALTER SEQUENCE public.user_application_list_user_application_list_id_seq OWNED BY public.user_application_list.user_application_list_id;


--
-- TOC entry 230 (class 1259 OID 2447035)
-- Name: access_level; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.access_level (
    access_level_id character(36) NOT NULL,
    level smallint NOT NULL,
    description character varying(256) NOT NULL
);


ALTER TABLE security.access_level OWNER TO ervu_account_applications;

--
-- TOC entry 225 (class 1259 OID 2446967)
-- Name: authority; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.authority (
    authority_id character(36) NOT NULL,
    name character varying(255) NOT NULL,
    created timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE security.authority OWNER TO ervu_account_applications;

--
-- TOC entry 218 (class 1259 OID 2446849)
-- Name: databasechangelog; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.databasechangelog (
    id character varying(255) NOT NULL,
    author character varying(255) NOT NULL,
    filename character varying(255) NOT NULL,
    dateexecuted timestamp without time zone NOT NULL,
    orderexecuted integer NOT NULL,
    exectype character varying(10) NOT NULL,
    md5sum character varying(35),
    description character varying(255),
    comments character varying(255),
    tag character varying(255),
    liquibase character varying(20),
    contexts character varying(255),
    labels character varying(255),
    deployment_id character varying(10)
);


ALTER TABLE security.databasechangelog OWNER TO ervu_account_applications;

--
-- TOC entry 219 (class 1259 OID 2446854)
-- Name: databasechangeloglock; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.databasechangeloglock (
    id integer NOT NULL,
    locked boolean NOT NULL,
    lockgranted timestamp without time zone,
    lockedby character varying(255)
);


ALTER TABLE security.databasechangeloglock OWNER TO ervu_account_applications;

--
-- TOC entry 228 (class 1259 OID 2447005)
-- Name: esia_user; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.esia_user (
    esia_user_id character varying(36) NOT NULL,
    user_account_id character varying(36) NOT NULL,
    person_contact_id bigint NOT NULL
);


ALTER TABLE security.esia_user OWNER TO ervu_account_applications;

--
-- TOC entry 224 (class 1259 OID 2446948)
-- Name: link_user_account_user_group; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.link_user_account_user_group (
    link_user_account_user_group_id character(36) NOT NULL,
    user_account_id character varying(150) NOT NULL,
    user_group_id character(36) NOT NULL,
    created timestamp without time zone DEFAULT now()
);


ALTER TABLE security.link_user_account_user_group OWNER TO ervu_account_applications;

--
-- TOC entry 223 (class 1259 OID 2446929)
-- Name: link_user_group_user_role; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.link_user_group_user_role (
    link_user_group_user_role_id character(36) NOT NULL,
    user_group_id character(36) NOT NULL,
    user_role_id character(36) NOT NULL,
    created timestamp without time zone DEFAULT now()
);


ALTER TABLE security.link_user_group_user_role OWNER TO ervu_account_applications;

--
-- TOC entry 226 (class 1259 OID 2446975)
-- Name: link_user_role_authority; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.link_user_role_authority (
    user_role_authority_id character(36) NOT NULL,
    user_role_id character(36) NOT NULL,
    authority_id character(36) NOT NULL,
    created timestamp without time zone DEFAULT now()
);


ALTER TABLE security.link_user_role_authority OWNER TO ervu_account_applications;

--
-- TOC entry 229 (class 1259 OID 2447020)
-- Name: org_unit; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.org_unit (
    id character(36) NOT NULL,
    name character varying(1000) NOT NULL,
    code character varying(50) NOT NULL,
    parent_id character(36),
    removed boolean DEFAULT false NOT NULL
);


ALTER TABLE security.org_unit OWNER TO ervu_account_applications;

--
-- TOC entry 245 (class 1259 OID 2447202)
-- Name: org_unit_additional_info; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.org_unit_additional_info (
    id character(36) NOT NULL,
    schema character varying(1000) NOT NULL
);


ALTER TABLE security.org_unit_additional_info OWNER TO ervu_account_applications;

--
-- TOC entry 227 (class 1259 OID 2446994)
-- Name: simple_credentials; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.simple_credentials (
    user_account_id character(36) NOT NULL,
    password character varying(128) NOT NULL,
    password_expires timestamp without time zone,
    password_updated timestamp without time zone DEFAULT now() NOT NULL
);


ALTER TABLE security.simple_credentials OWNER TO ervu_account_applications;

--
-- TOC entry 220 (class 1259 OID 2446859)
-- Name: user_account; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.user_account (
    user_account_id character(36) NOT NULL,
    email character varying(150) NOT NULL,
    first_name character varying(100) NOT NULL,
    last_name character varying(100) NOT NULL,
    middle_name character varying(100),
    created timestamp with time zone DEFAULT now() NOT NULL,
    updated timestamp with time zone DEFAULT now() NOT NULL,
    locked boolean DEFAULT false NOT NULL,
    org_unit_id character(36) NOT NULL,
    username character varying(150) NOT NULL,
    phone character varying(16),
    email_confirmed boolean DEFAULT true NOT NULL,
    user_source character varying(20) DEFAULT 'LOCAL'::character varying NOT NULL,
    source_name character varying(20)
);


ALTER TABLE security.user_account OWNER TO ervu_account_applications;

--
-- TOC entry 231 (class 1259 OID 2447064)
-- Name: user_account_refresh_token; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.user_account_refresh_token (
    user_account_refresh_token_id character(36) NOT NULL,
    user_account_id character(36),
    refresh_token text,
    access_token text,
    expiration_time timestamp without time zone
);


ALTER TABLE security.user_account_refresh_token OWNER TO ervu_account_applications;

--
-- TOC entry 232 (class 1259 OID 2447094)
-- Name: user_account_verification; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.user_account_verification (
    user_account_id character(36) NOT NULL,
    token character(36) NOT NULL,
    created timestamp without time zone DEFAULT now() NOT NULL
);


ALTER TABLE security.user_account_verification OWNER TO ervu_account_applications;

--
-- TOC entry 222 (class 1259 OID 2446920)
-- Name: user_group; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.user_group (
    user_group_id character(36) NOT NULL,
    name character varying(255) NOT NULL,
    created timestamp with time zone DEFAULT now() NOT NULL,
    updated timestamp with time zone DEFAULT now() NOT NULL,
    access_level_id character(36) NOT NULL
);


ALTER TABLE security.user_group OWNER TO ervu_account_applications;

--
-- TOC entry 221 (class 1259 OID 2446887)
-- Name: user_role; Type: TABLE; Schema: security; Owner: ervu_account_applications
--

CREATE TABLE security.user_role (
    user_role_id character(36) NOT NULL,
    name character varying(255) NOT NULL,
    created timestamp with time zone DEFAULT now() NOT NULL,
    updated timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE security.user_role OWNER TO ervu_account_applications;

--
-- TOC entry 3966 (class 2604 OID 2447136)
-- Name: job_position job_position_id; Type: DEFAULT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.job_position ALTER COLUMN job_position_id SET DEFAULT nextval('public.job_position_job_position_id_seq'::regclass);


--
-- TOC entry 3972 (class 2604 OID 2447165)
-- Name: link_user_application_user_group link_user_application_user_group_id; Type: DEFAULT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.link_user_application_user_group ALTER COLUMN link_user_application_user_group_id SET DEFAULT nextval('public.link_user_application_user_gr_link_user_application_user_gr_seq'::regclass);


--
-- TOC entry 3968 (class 2604 OID 2447144)
-- Name: user_application_document user_application_document_id; Type: DEFAULT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.user_application_document ALTER COLUMN user_application_document_id SET DEFAULT nextval('public.user_application_document_user_application_document_id_seq'::regclass);


--
-- TOC entry 3969 (class 2604 OID 2447154)
-- Name: user_application_list user_application_list_id; Type: DEFAULT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.user_application_list ALTER COLUMN user_application_list_id SET DEFAULT nextval('public.user_application_list_user_application_list_id_seq'::regclass);


--
-- TOC entry 3971 (class 2604 OID 2447156)
-- Name: user_application_list number_app; Type: DEFAULT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.user_application_list ALTER COLUMN number_app SET DEFAULT nextval('public.user_application_list_number_app_seq'::regclass);


--
-- TOC entry 4225 (class 0 OID 2447109)
-- Dependencies: 233
-- Data for Name: databasechangelog; Type: TABLE DATA; Schema: public; Owner: ervu_account_applications
--

COPY public.databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) FROM stdin;
0001	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:10.239209	1	EXECUTED	9:81c537de32df5800f4a00e09afcd6cc7	sql	create EXTENSION uuid-ossp	\N	4.26.0	\N	\N	2642208732
0002	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:10.776408	2	EXECUTED	9:dfa1aa55c4ee9f1934b60fdf04f17360	sql	add table job_position and insert values	\N	4.26.0	\N	\N	2642208732
0003	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:10.914155	3	EXECUTED	9:749cced30aca016ffb298835871cd227	sql	add table user_application_document	\N	4.26.0	\N	\N	2642208732
0004	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:11.305684	4	EXECUTED	9:21451008918de239817063a14f269f19	sql	add table user_application_list	\N	4.26.0	\N	\N	2642208732
0005	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:11.475288	5	EXECUTED	9:b28c1d6cf7b3969a092007805dcb5126	sql	add table link_user_application_user_group	\N	4.26.0	\N	\N	2642208732
0006	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:14.648987	6	EXECUTED	9:8ca0742d3cdccff8efbd3ae9a8bdac4f	sql	add table recruitment and insert values	\N	4.26.0	\N	\N	2642208732
0007	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:15.224432	7	EXECUTED	9:d049db99a8c0276b389f9fc6a5d92b21	sql	insert values into "security".org_unit	\N	4.26.0	\N	\N	2642208732
0008	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:15.444911	8	EXECUTED	9:c452554778adbead5acb7b601218327b	sql	insert values into "security".org_unit_additional_info	\N	4.26.0	\N	\N	2642208732
0009	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:15.964143	9	EXECUTED	9:3452706d6ab301f0080a3cb440a80c00	sql	insert values into "security".org_unit_additional_info	\N	4.26.0	\N	\N	2642208732
0010	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:16.167173	10	EXECUTED	9:a610f35fece554a66469d80bbe0236b1	sql	insert values into "security".user_role	\N	4.26.0	\N	\N	2642208732
0011	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:16.557665	11	EXECUTED	9:85956e93a2690f14a67a2f9ee799e246	sql	insert values into "security".user_group	\N	4.26.0	\N	\N	2642208732
0012	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:16.917083	12	EXECUTED	9:e886afb953f97a34f46aa0449fb148a0	sql	insert values into link_user_group_user_role	\N	4.26.0	\N	\N	2642208732
0013	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:17.035918	13	EXECUTED	9:dd4ec7493842d4d9ea21b291c2ac03db	sql	insert values into "security".user_account	\N	4.26.0	\N	\N	2642208732
0014	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:17.154636	14	EXECUTED	9:8029f9d89bbeeddc613096b51b8dc60a	sql	insert values into "security".simple_credentials	\N	4.26.0	\N	\N	2642208732
0015	hairullin	config/v_1.0/20241120-SUPPORT-8722_create_db.xml	2024-11-26 20:30:17.284745	15	EXECUTED	9:9623fcb47b13ee903c99f04ad912dacf	sql	insert values into "security".link_user_account_user_group	\N	4.26.0	\N	\N	2642208732
\.


--
-- TOC entry 4226 (class 0 OID 2447114)
-- Dependencies: 234
-- Data for Name: databasechangeloglock; Type: TABLE DATA; Schema: public; Owner: ervu_account_applications
--

COPY public.databasechangeloglock (id, locked, lockgranted, lockedby) FROM stdin;
1	f	\N	\N
\.


--
-- TOC entry 4228 (class 0 OID 2447133)
-- Dependencies: 236
-- Data for Name: job_position; Type: TABLE DATA; Schema: public; Owner: ervu_account_applications
--

COPY public.job_position (job_position_id, name, code, start_date, close_date) FROM stdin;
1	Руководитель	MANAGER	2024-10-07 15:39:26.69628	\N
2	Специалист	USER	2024-10-07 15:39:26.69628	\N
\.


--
-- TOC entry 4235 (class 0 OID 2447162)
-- Dependencies: 243
-- Data for Name: link_user_application_user_group; Type: TABLE DATA; Schema: public; Owner: ervu_account_applications
--

COPY public.link_user_application_user_group (link_user_application_user_group_id, user_application_list_id, user_group_id, created) FROM stdin;
1	1	6428cb6d-2949-4570-85b5-4b81e33b19ff	2024-11-27 09:46:17.340085
2	2	6428cb6d-2949-4570-85b5-4b81e33b19ff	2024-11-27 10:31:12.616808
3	3	0c61996f-c1db-483e-8456-5a5a9dc6dcdd	2024-11-27 10:54:19.888099
4	4	6428cb6d-2949-4570-85b5-4b81e33b19ff	2024-11-27 11:17:44.04653
5	5	6428cb6d-2949-4570-85b5-4b81e33b19ff	2024-11-27 11:31:33.019927
6	6	6428cb6d-2949-4570-85b5-4b81e33b19ff	2024-11-27 11:36:41.623836
\.


--
-- TOC entry 4236 (class 0 OID 2447183)
-- Dependencies: 244
-- Data for Name: recruitment; Type: TABLE DATA; Schema: public; Owner: ervu_account_applications
--

COPY public.recruitment (id, idm_id, parent_id, version, created_at, updated_at, schema, military_code, shortname, fullname, dns, email, phone, address, address_id, postal_address, postal_address_id, nsi_department_id, nsi_organization_id, oktmo, org_ogrn, dep_ogrn, epgu_id, kpp, inn, okato, division_type, tns_department_id, enabled, timezone, reports_enabled, region_id, subpoena_series_code, hidden, region_code, ts) FROM stdin;
20f455d2-2908-4a86-8ab5-2e500f2f5544	f03fc8c0-2ce7-4121-a306-f82d65ea029d	\N	0	2024-09-29 09:49:42.385098	2024-09-29 09:49:42.385098	Ministry	\N	Министерство обороны	Министерство обороны	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	f	\N	t	\N	\N	f	\N	2024-09-29 09:49:42.379375
e00feef8-7b8a-47c2-9a16-f0f7dc877f56	b23f384f-b114-4003-9277-2eaa2d9ae180	f03fc8c0-2ce7-4121-a306-f82d65ea029d	0	2024-09-29 09:49:42.453244	2024-09-29 09:49:42.453244	Region	\N	Восточный военный округ	Восточный военный округ	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	t	\N	t	\N	\N	f	\N	2024-09-29 09:49:42.452193
72cd6795-0303-4894-82ad-911bc259d87e	30a01af9-a871-411a-90e3-d81592bb074f	f03fc8c0-2ce7-4121-a306-f82d65ea029d	0	2024-09-29 09:49:42.458533	2024-09-29 09:49:42.458533	Region	\N	Московский военный округ	Московский военный округ	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	t	\N	t	\N	\N	f	\N	2024-09-29 09:49:42.457675
d29346a7-dc0f-452d-859f-9bd3a83c219c	25633423-52e6-45bb-9d54-7f85b74a3f7d	f03fc8c0-2ce7-4121-a306-f82d65ea029d	0	2024-09-29 09:49:42.463413	2024-09-29 09:49:42.463413	Region	\N	Ленинградский военный округ	Ленинградский военный округ	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	t	\N	t	\N	\N	f	\N	2024-09-29 09:49:42.462639
826c2187-7761-48ff-9399-25d1cc2a9297	58ef9cdc-8a9d-429e-89a5-1c49e2684a98	f03fc8c0-2ce7-4121-a306-f82d65ea029d	0	2024-09-29 09:49:42.467537	2024-09-29 09:49:42.467537	Region	\N	Центральный военный округ	Центральный военный округ	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	t	\N	t	\N	\N	f	\N	2024-09-29 09:49:42.467016
a7b1f5f2-e43f-44da-92c6-6f394f53ec95	b00de68d-2e09-4776-9b48-1566a7222dca	f03fc8c0-2ce7-4121-a306-f82d65ea029d	0	2024-09-29 09:49:42.472603	2024-09-29 09:49:42.472603	Region	\N	Южный военный округ	Южный военный округ	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	t	\N	t	\N	\N	f	\N	2024-09-29 09:49:42.471977
fb2a5e9b-5c86-4c6f-bea0-c4501d466549	83779471-c29f-c2eb-0e70-7846af31d10e	b00de68d-2e09-4776-9b48-1566a7222dca	2	2024-09-29 09:49:42.476827	2024-09-29 09:49:42.476827	Organization	34556777	Тестовый комиссариат 2	Тестовый комиссариат 2		11@11.ru	1111111111	г. Москва	0c5b2444-70a0-4932-980c-b4dc0d3f02b5	г. Москва	0c5b2444-70a0-4932-980c-b4dc0d3f02b5	\N	\N	11	\N	\N	\N	111111111	1111111111	\N	\N		t	+01:30	t	b00de68d-2e09-4776-9b48-1566a7222dca	МО	f	36	2024-09-29 09:49:42.476294
521ce853-5cec-4d2c-8aa5-8f73e5ac3376	31b88ed6-263e-225d-0787-74f7ef25f5f6	b23f384f-b114-4003-9277-2eaa2d9ae180	2	2024-09-29 09:49:42.481225	2024-09-29 09:49:42.481225	Organization	34123421	FDfsafd	FDfsafd					\N	обл. Свердловская, г. Ивдель, ул. 50 лет Октября, гск. Москвич	721c162c-197a-4281-8ad9-8ae3efe2d655	\N	\N		\N	\N	\N		3241121234	\N	\N		t	+01:35	t	b23f384f-b114-4003-9277-2eaa2d9ae180	ВА	f	50	2024-09-29 09:49:42.480738
30de0a5c-a8df-4591-9bdc-52bfe5abb31d	5055a985-c97c-f5dc-2158-ff5862bfe4cf	b00de68d-2e09-4776-9b48-1566a7222dca	3	2024-09-29 09:49:42.484508	2024-09-29 09:49:42.484508	Organization	96199408	ВК Вятска	Военный комиссариат Вятска Тест					\N	Респ. Удмуртская, р-н. Каракулинский, с/п. Вятское	71e8456a-acf1-432d-80ee-def9d7123fab	\N	\N		\N	\N	\N		3333333333	\N	\N		t	+01:30	f	b00de68d-2e09-4776-9b48-1566a7222dca	ВЯ	f	18	2024-09-29 09:49:42.48405
f8010c28-ec1b-415f-9546-f1b58e36279e	8edec280-3143-4d45-b702-ad5e91ef0e52	\N	1	2024-09-29 09:49:42.489398	2024-09-29 09:49:42.489398	Department	34623446	Тестовая организация Тест Второй	Тестовая организация Тест Второй					3fa85f64-5717-4562-b3fc-2c963f66afa6	Респ. Татарстан, г. Казань, ул. Мазита Гафури, д. 71, корп. 1, кв. 1	65c4e0b5-bf23-42be-9f33-a2f0b155c964	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+00:00	t	\N	AA	f	36	2024-09-29 09:49:42.488945
ba28c023-72f4-4ef5-b209-631f72f9488e	ce08e909-5a14-480f-b931-bff172872ac6	84bc45ab-c032-410e-9dc5-07e92719ede4	1	2024-09-29 09:49:42.550316	2024-09-29 09:49:42.550316	Department	08444073	ВК городских округов Курильский и Северо-Курильский Сахалинской области	Военный комиссариат городских округов Курильский и Северо-Курильский Сахалинской области		\N	\N		\N	обл. Сахалинская, р-н. Курильский, г. Курильск, ул. Ленинского Комсомола, д. 24	8ef658b0-ea6a-451a-ae2c-2aa4ba6707a6	\N	\N	64720000	1026500540659	1026500540659	\N	650101001	6501027156	64000000000	\N	cf60f9bc-a17c-4147-917e-5d1abf2218b4	t	+11:00	t	\N	СК	f	65	2024-09-29 09:49:42.492719
4d3daef5-a63d-417c-8235-97c2b772a182	6da64c78-6705-4567-9f5f-5ade5822d92f	84bc45ab-c032-410e-9dc5-07e92719ede4	1	2024-09-29 09:49:42.556103	2024-09-29 09:49:42.556103	Department	08444601	ВК городского округа Южно-Курильский Сахалинской области	Военный комиссариат городского округа Южно-Курильский Сахалинской области		\N	\N		\N	обл. Сахалинская, р-н. Южно-Курильский, пгт. Южно-Курильск, ул. Океанская, д. 2А	2974bf77-5633-46a0-aac1-4c86528419f4	\N	\N	64756000	1026500540659	1026500540659	\N	650101001	6501027156	64000000000	\N	0f1b4bce-a63f-481c-b79c-a4d10490ba1f	t	+11:00	t	\N	СЮ	f	65	2024-09-29 09:49:42.55548
a3188467-3169-4b4e-847c-ffcca71c4440	110686b2-4a01-4976-885b-d26a2980f53a	84bc45ab-c032-410e-9dc5-07e92719ede4	1	2024-09-29 09:49:42.561031	2024-09-29 09:49:42.561031	Department	08443932	ВК города Долинск и Долинского района Сахалинской области	Военный комиссариат города Долинск и Долинского района Сахалинской области		\N	\N		\N	обл. Сахалинская, р-н. Долинский, г. Долинск, ул. Советская, д. 22	86be9abd-cf3b-411a-8df8-aae2ec25b8c9	\N	\N	64712000	1026500540659	1026500540659	\N	650101001	6501027156	64000000000	\N	67240765-f4f2-444d-9a90-8a0a34f3d8f2	t	+11:00	t	\N	СД	f	65	2024-09-29 09:49:42.560229
a67c6e12-b1fe-406b-b080-6b518324d6ea	98d428b3-502e-42b6-a29e-a469f894ac16	84bc45ab-c032-410e-9dc5-07e92719ede4	1	2024-09-29 09:49:42.566017	2024-09-29 09:49:42.566017	Department	08444110	ВК города Невельск и Невельского района Сахалинской области	Военный комиссариат города Невельск и Невельского района Сахалинской области		\N	\N		\N	обл. Сахалинская, р-н. Невельский, г. Невельск, ул. Советская	cf5026c0-6670-4c52-ab56-267bda136292	\N	\N	64728000	1026500540659	1026500540659	\N	650101001	6501027156	64000000000	\N	fbd24b2c-74a2-4d10-9cc5-06733702ff53	t	+11:00	t	\N	СН	f	65	2024-09-29 09:49:42.565394
bb80fa73-9e50-491c-98c1-1869d752bba7	8127c345-3fc1-4864-9d6e-cf34e69c494c	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.570281	2024-09-29 09:49:42.570281	Department	08471265	ВК Краснинского района Липецкой области	Военный комиссариат Краснинского района Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Краснинский, с. Красное, ул. Комбата Сапрыкина, д. 16	df04b8fc-4614-4191-b22d-4e8567ca8fad	\N	\N	42630420	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	233ae31f-1728-4a2f-87a0-6de83a422c65	t	+03:00	t	\N	ЛК	f	48	2024-09-29 09:49:42.569832
e6c40dc8-0065-42c2-8c50-87714b3a0f7c	b2238b19-8598-4dfa-bb49-0de95136e344	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.57463	2024-09-29 09:49:42.57463	Department	08471331	ВК Лебедянского района Липецкой области	Военный комиссариат Лебедянского района Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Лебедянский, г. Лебедянь, ул. Свердлова, д. 7	1865b804-bdc4-42d6-83c2-e982b2742f82	\N	\N	42633101	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	0d8a4f7b-d385-4798-ba5b-5b7247e4eaf7	t	+03:00	t	\N	ЛЛ	f	48	2024-09-29 09:49:42.573995
cef595ce-c5af-44bb-9711-b0b7fd5b2df4	54a95ecd-1530-424c-8da1-882622b2df83	e8f52736-3997-4e3a-c9e4-5bfca6eddc89	1	2024-09-29 09:49:42.878997	2024-09-29 09:49:42.878997	Department	13131251	Тестовый муниципальный комиссариат 2	Тестовый муниципальный комиссариат 2					\N	г. Москва	0c5b2444-70a0-4932-980c-b4dc0d3f02b5	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+01:30	t	96f9779f-4028-4ef7-b841-9d1058a5062a	МО	f	10	2024-09-29 09:49:42.878708
3a36fc6d-e2d4-414b-a995-e6c8bff78b77	67dacb06-d1f7-4c0e-9891-32863353cae9	84bc45ab-c032-410e-9dc5-07e92719ede4	1	2024-09-29 09:49:42.588219	2024-09-29 09:49:42.588219	Department	08444593	ВК города Холмск и Холмского района Сахалинской области	Военный комиссариат города Холмск и Холмского района Сахалинской области		\N	\N		\N	обл. Сахалинская, р-н. Холмский, г. Холмск, ул. Чехова, д. 68	e7b5e4aa-4ae9-40a8-bda8-ce05fe38de23	\N	\N	64754000	1026500540659	1026500540659	\N	650101001	6501027156	64000000000	\N	b88cfaa0-fbdb-4baa-bebc-2da990bdbe82	t	+11:00	t	\N	СХ	f	65	2024-09-29 09:49:42.587669
659ed98b-9868-4168-adff-35e9e1bd9b0b	24b7ba55-9757-45d9-9c5e-5ca3e8c9c2d0	84bc45ab-c032-410e-9dc5-07e92719ede4	1	2024-09-29 09:49:42.59247	2024-09-29 09:49:42.59247	Department	08444239	ВК города Поронайск, Макаровского, Поронайского и Смирныховского районов Сахалинской области	Военный комиссариат города Поронайск, Макаровского, Поронайского и Смирныховского районов Сахалинской области		\N	\N		\N	обл. Сахалинская, р-н. Поронайский, г. Поронайск, ул. Гагарина, д. 1	18d602a4-5c5b-4533-8757-81e22e3c9ab4	\N	\N	64740000	1026500540659	1026500540659	\N	650101001	6501027156	64000000000	\N	0ca0f417-c622-4cb2-a96b-337b0f85f173	t	+11:00	t	\N	СП	f	65	2024-09-29 09:49:42.592016
8a1f8307-76c9-4923-a0fe-88bc6a563fcb	20d82cbf-d520-48ce-a02a-540ce3838087	4c062d4a-3f77-c850-6388-dde909e3946b	1	2024-09-29 09:49:42.651893	2024-09-29 09:49:42.651893	Department	43242323	АУВафцыва	АУВафцыва					\N	г. Москва, вн.тер.г.. муниципальный округ Москворечье-Сабурово	9bccb3a5-c52c-4229-96b3-e992defeab1a	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+01:32	t	\N	ФА	f	35	2024-09-29 09:49:42.651065
6fabcb61-584f-401d-85f6-79a49e3d8f61	52e97a4c-f68c-489a-a923-fabb9ef574dd	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.656905	2024-09-29 09:49:42.656905	Department	08471259	ВК Измалковского района Липецкой области	Военный комиссариат Измалковского района Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Измалковский, с. Измалково	81a3eb57-1a08-48ce-a0fd-ca7fd99933d0	\N	\N	42627416	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	3f5688d3-ce36-4d2a-bbb0-adb1418bc6c3	t	+03:00	t	\N	ЛИ	f	48	2024-09-29 09:49:42.656238
08f29c2e-0682-4179-a8f1-21a278c22d26	94a9f485-eab9-4158-a1bf-330d23e29ae2	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.661953	2024-09-29 09:49:42.661953	Department	08471087	ВК Долгоруковского района Липецкой области	Военный комиссариат Долгоруковского района Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Долгоруковский, с. Долгоруково, ул. Советская	e62da677-9e0f-4c4a-82b5-6b9505cba06b	\N	\N	42618428	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	6a5b8e2e-6d5e-42fb-82d6-a2aaae2c9e6a	t	+03:00	t	\N	ЛД	f	48	2024-09-29 09:49:42.661241
c93d2dc2-7741-4ca7-9690-14c764a77bf0	f4e38f22-d974-412b-8a34-b1933ca865a9	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.667079	2024-09-29 09:49:42.667079	Department	08471176	ВК Задонского района Липецкой области	Военный комиссариат Задонского района Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Задонский, г. Задонск, ул. К.Маркса, д. 131	5fe812f4-f595-42a9-a168-af6fe314bad5	\N	\N	42624101	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	8057f1bd-b997-445d-ae31-3e596685100c	t	+03:00	t	\N	ЛЗ	f	48	2024-09-29 09:49:42.666515
d01db5cc-086b-4609-9aad-2c6397c4dd96	2545944e-5252-4a6f-bcb2-8a4adf720e9b	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.670984	2024-09-29 09:49:42.670984	Department	08470946	ВК города Данков, Данковского и Лев-Толстовского района Липецкой области	Военный комиссариат города Данков, Данковского и Лев-Толстовского района Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Данковский, г. Данков, ул. Карла Маркса, д. 42	e9ac01e1-8f73-4648-8769-b1d0bcc04f90	\N	\N	42609101	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	be8f133b-a194-4f6e-a589-a3e566c6a7fe	t	+03:00	t	\N	ЛД	f	48	2024-09-29 09:49:42.670388
939dd496-542a-45f4-91e0-90c331d85f5f	3a56b060-20ee-4b62-9d96-4c6bf4928039	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.675536	2024-09-29 09:49:42.675536	Department	08471621	ВК Хлевенского района Липецкой области	Военный комиссариат Хлевенского района Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Хлевенский, с. Хлевное	960296ba-28e8-4ad2-9a43-9ee15b2ec816	\N	\N	42652453	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	50e11407-c71f-4593-b533-f9c0df53351d	t	+03:00	t	\N	ЛХ	f	48	2024-09-29 09:49:42.675074
fd142737-1a6a-466f-a318-b1412b184b3d	79f6c236-3ee8-40ff-bc10-40077420e82e	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:42.678802	2024-09-29 09:49:42.678802	Department	08477233	ВК Шиловского и Путятинского районов Рязанской области	Военный комиссариат Шиловского и Путятинского районов Рязанской области			\N		\N	обл. Рязанская, р-н. Шиловский, рп. Шилово, ул. Спасская, зд. 19	46c6e7b2-2ee9-4674-aeeb-b1db153df9e5	\N	\N	61658151	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	310f0061-c7bd-4dea-9f16-c7e99ab58aba	t	+03:00	t	\N	РК	f	62	2024-09-29 09:49:42.678278
50439548-a88f-4e49-93a1-ce29c1eb9b9a	86fc6ed6-1d82-4536-8066-c9ff2ca68639	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:42.682197	2024-09-29 09:49:42.682197	Department	08477167	ВК Ухоловского, Сапожковского и Сараевского районов Рязанской области	Военный комиссариат Ухоловского, Сапожковского и Сараевского районов Рязанской области			\N		\N	обл. Рязанская, р-н. Ухоловский, рп. Ухолово, пер. Чапаева, д. 21	c2431759-122c-4493-bce7-7ffc1a7c247b	\N	\N	61650151	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	704fd9ff-58eb-42a2-b443-d588cd1c437d	t	+03:00	t	\N	РУ	f	62	2024-09-29 09:49:42.681778
908c5c7a-2942-4083-acbf-3a03c739b860	e22cfafc-b8b1-47fd-b9f4-b9015734d578	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:42.685424	2024-09-29 09:49:42.685424	Department	08477210	ВК города Шацк, Шацкого и Чучковского районов Рязанской области	Военный комиссариат города Шацк, Шацкого и Чучковского районов Рязанской области		\N	\N		\N	обл. Рязанская, р-н. Шацкий, г. Шацк, ул. Цюрупы, зд. 19	3ac3cbdc-bb39-44b0-8d7e-b38708e16f22	\N	\N	61656101	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	e7298341-ea5e-4a98-a497-5d706d883477	t	+03:00	t	\N	РШ	f	62	2024-09-29 09:49:42.685014
928411d1-b6c2-40ea-a3df-4cad7aec98a5	2ca66dd6-6688-45c9-bb7e-988c7e92d34a	092d6963-287c-454e-8d73-8e09ebee972e	0	2024-09-29 09:49:42.688337	2024-09-29 09:49:42.688337	Department	\N	ВК Московского и Железнодорожного районов города Рязань Рязанской области	Военный комиссариат Московского и Железнодорожного районов города Рязань Рязанской области	1026201271337	\N	\N	390044, г.Рязань, ул. Московское шоссе, д. 14	\N		\N	\N	\N	61701000	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	f33f5e16-8544-4b8d-be78-24447ab42a4e	t	\N	t	\N	\N	f	\N	2024-09-29 09:49:42.687983
da5a8694-eae5-4da1-81b9-54ac3ac178f2	55727f17-6ab4-4d51-ad32-ba8e916acf49	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:42.691283	2024-09-29 09:49:42.691283	Department	08476481	ВК Клепиковского района Рязанской области	Военный комиссариат Клепиковского района Рязанской области		\N	\N		\N	обл. Рязанская, р-н. Клепиковский, г. Спас-Клепики, ул. Советская, зд. 1	5727d5e1-78e8-4835-8b6b-657924607535	\N	\N	61610101	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	36ce7278-0a25-416a-8136-c63a160f0f3c	t	+03:00	t	\N	ПК	f	62	2024-09-29 09:49:42.69097
9b83cc97-0439-458e-bc45-08315eb4d9b8	6562ddb0-3f0c-4e43-bf0c-a834421cd4db	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:42.694081	2024-09-29 09:49:42.694081	Department	22222222	ВК Рязанского и Спасского районов Рязанской области	Военный комиссариат Рязанского и Спасского районов Рязанской области		\N	\N		\N	обл. Рязанская, г. Рязань, ул. Загородная, д. 22	bc2888de-9acf-4630-9285-422acec90728	\N	\N	61701000	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	6a994538-9783-45d6-ae70-ab0102125f47	t	+03:00	t	\N	РК	f	62	2024-09-29 09:49:42.693768
cbc0917a-3052-41ea-a97e-f482b2c81b2d	f59afe6d-c166-4196-a489-6d17f02fc05e	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:42.696673	2024-09-29 09:49:42.696673	Department	08477115	ВК города Скопин, Скопинского и Милославского районов Рязанской области	Военный комиссариат города Скопин, Скопинского и Милославского районов Рязанской области		\N	\N		\N	обл. Рязанская, р-н. Скопинский	a03c70ca-6855-4258-af6e-c56e804bfae7	\N	\N	61715000	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	2d917cdd-f689-4dc4-b5ba-21a910d3a85e	t	+03:00	t	\N	РС	f	62	2024-09-29 09:49:42.696289
b2e6bca2-d7eb-4654-8aef-d5c529e1c899	84bc45ab-c032-410e-9dc5-07e92719ede4	b23f384f-b114-4003-9277-2eaa2d9ae180	1	2024-09-29 09:49:42.700551	2024-09-29 09:49:42.700551	Organization	\N	Военный комиссариат Сахалинской области	Военный комиссариат Сахалинской области	1026500540659	vk_sahalin_2@mil.ru	8 (424)-275-39-82	693007, Сахалинская область, г. Южно-Сахалинск, ул. Комсомольская, 194	\N		\N	\N	\N		\N	\N	\N	650101001	6501027156	64000000000	\N	1026500540659	t	\N	t	b23f384f-b114-4003-9277-2eaa2d9ae180	\N	f	\N	2024-09-29 09:49:42.699001
3cab3b8a-15f2-4c69-a3be-e7485717baa2	e8f52736-3997-4e3a-c9e4-5bfca6eddc89	b00de68d-2e09-4776-9b48-1566a7222dca	16	2024-09-29 09:49:42.703187	2024-09-29 09:49:42.703187	Organization	12332111	Тестовый комиссариат 1	Тестовый комиссариат 1		test@test.ru	3333333333	г. Москва	0c5b2444-70a0-4932-980c-b4dc0d3f02b5	г. Москва	0c5b2444-70a0-4932-980c-b4dc0d3f02b5	\N	\N	20	\N	\N	\N	111111111	1111111111	\N	\N		t	+03:00	t	b00de68d-2e09-4776-9b48-1566a7222dca	МО	f	35	2024-09-29 09:49:42.702888
67db7b5b-0892-4908-bd20-864f932e80f9	5d8e4e2b-37d7-44a8-accb-45e87b62aa2d	30a01af9-a871-411a-90e3-d81592bb074f	0	2024-09-29 09:49:42.706976	2024-09-29 09:49:42.706976	Organization	\N	Главное организационно-мобилизационное управление	Главное организационно-мобилизационное управление	1137746638402	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	7704201034	\N	\N	\N	t	\N	t	30a01af9-a871-411a-90e3-d81592bb074f	\N	f	\N	2024-09-29 09:49:42.70584
6e1017e2-1e38-481f-85c2-e828247f2b79	553b9449-6460-48c4-88d4-f18283abc4a7	30a01af9-a871-411a-90e3-d81592bb074f	0	2024-09-29 09:49:42.755346	2024-09-29 09:49:42.755346	Organization	\N	Восьмое управление	Восьмое управление ГШ ВС РФ					\N		\N	\N	\N		\N	\N	\N		1111111111	\N	\N		t	\N	t	30a01af9-a871-411a-90e3-d81592bb074f	\N	f	\N	2024-09-29 09:49:42.753426
69865d28-3f69-4047-8d4d-9469a6c33d5f	6139de3b-2378-496f-9fca-7df7dab90832	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:42.759037	2024-09-29 09:49:42.759037	Department	34555667	ВК Октябрьского и Советского районов города Рязань Рязанской области	Военный комиссариат Октябрьского и Советского районов города Рязань Рязанской области		\N	\N	обл. Рязанская, г. Рязань	86e5bae4-ef58-4031-b34f-5e9ff914cd55	обл. Рязанская, г. Рязань	86e5bae4-ef58-4031-b34f-5e9ff914cd55	\N	\N	61701000	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	311d4b94-4a2e-49b0-b19d-962f101609c5	t	+01:30	t	\N	МО	f	62	2024-09-29 09:49:42.758605
77df47ff-f9d1-47f6-89c5-dc214b91a2a2	2137685f-0683-4131-82d8-983222114184	30a01af9-a871-411a-90e3-d81592bb074f	1	2024-09-29 09:49:42.762636	2024-09-29 09:49:42.762636	Organization	\N	Военный комиссариат Липецкой области	Военный комиссариат Липецкой области	1024800835311	voenkomlipetsk@mil.ru	84742273406	398000, г.Липецк, ул. Интернациональная, д. 10	\N		\N	\N	\N		\N	\N	\N	482501001	4825011699	42000000000	\N	1024800835311	t	\N	t	30a01af9-a871-411a-90e3-d81592bb074f	\N	f	\N	2024-09-29 09:49:42.761536
38392eea-e14b-48b5-a0a1-2cff65bcb396	092d6963-287c-454e-8d73-8e09ebee972e	30a01af9-a871-411a-90e3-d81592bb074f	0	2024-09-29 09:49:42.766038	2024-09-29 09:49:42.766038	Organization	\N	Военный комиссариат Рязанской области	Военный комиссариат Рязанской области	1026201271337	voenkomryazan@mil.ru	 8 (4912)-25-29-15	390046, Рязанская область, г.Рязань, ул. Фрунзе, д. 27	\N		\N	\N	\N		\N	\N	\N	623101001	6231026092	61000000000	\N	1026201271337	t	\N	t	30a01af9-a871-411a-90e3-d81592bb074f	\N	f	\N	2024-09-29 09:49:42.764978
1cb021ac-4335-40d4-987c-7c7648d104be	5eadc746-674d-4ba0-95d6-414d3469c82b	84bc45ab-c032-410e-9dc5-07e92719ede4	2	2024-09-29 09:49:42.769437	2024-09-29 09:49:42.769437	Department	08444156	ВК города Оха и Охинского района Сахалинской области	Военный комиссариат города Оха и Охинского района Сахалинской области		\N	\N		\N	обл. Сахалинская, р-н. Охинский, г. Оха, ул. Комсомольская, д. 6а	6449285b-f48b-4c37-8e36-25d19499fe55	\N	\N	64736000	1026500540659	1026500540659	\N	650101001	6501027156	64000000000	\N	004305d3-a108-4e1c-be65-2f7082c784c7	t	+11:00	t	\N	СО	f	65	2024-09-29 09:49:42.768998
2330352b-59ff-4b3f-b534-196fb5b20f9a	3b71b6ff-3eec-4cca-fed0-055bb0c163cc	b00de68d-2e09-4776-9b48-1566a7222dca	3	2024-09-29 09:49:42.772815	2024-09-29 09:49:42.772815	Organization	08474128	ВК Одинцовского городского округа городских округов Краснознаменск и Власиха Московской области	ВК Одинцовского городского округа городских округов Краснознаменск и Власиха Московской области					\N	обл. Московская, г. Домодедово, п. Востряково, ул. Одинцовская	a891ec3f-428f-4063-a99b-8f7c099b4552	\N	\N		\N	\N	\N		7793269459	\N	\N		t		t	b00de68d-2e09-4776-9b48-1566a7222dca		f	\N	2024-09-29 09:49:42.771786
4b2365ea-b799-48d4-ab00-b6f6dac5b952	bce5663e-5fe1-94a7-40f9-71d0490459da	b00de68d-2e09-4776-9b48-1566a7222dca	6	2024-09-29 09:49:42.775694	2024-09-29 09:49:42.775694	Organization	12312312	тест	тест					\N		\N	\N	\N		\N	\N	\N		1212121212	\N	\N		t		t	b00de68d-2e09-4776-9b48-1566a7222dca		f	10	2024-09-29 09:49:42.775313
4e36849b-6652-483d-aecf-a3d9e18e42b9	0fe2bdf0-afbb-402d-93da-67e511799afa	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:42.778595	2024-09-29 09:49:42.778595	Department	08476334	ВК Кораблинского района Рязанской области	Военный комиссариат Кораблинского района Рязанской области		\N	\N	обл. Рязанская, р-н. Кораблинский, г. Кораблино, ул. Садовая	0a6a7dfd-2294-4c73-a2a8-b3bc11eb7de1	обл. Рязанская, р-н. Кораблинский, г. Кораблино, ул. Садовая	0a6a7dfd-2294-4c73-a2a8-b3bc11eb7de1	\N	\N	61612101	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	39d359d3-4965-4306-801d-ad501b9f5b22	t	+03:00	t	\N	РК	f	62	2024-09-29 09:49:42.778267
8bd65d2b-630c-4513-964b-d70b48726bc5	9703f108-761a-467a-aad3-89617e5539ed	2137685f-0683-4131-82d8-983222114184	2	2024-09-29 09:49:42.781673	2024-09-29 09:49:42.781673	Department	08117687	ВК города Липецк Липецкой области	Военный комиссариат города Липецк Липецкой области		test@vk.ru	0000000000	обл. Липецкая, р-н. Липецкий, с. Маховище, ул. Московская, д. 16а	346606b1-642a-4600-8ef5-99077a801a5b	обл. Липецкая, р-н. Липецкий, с. Маховище, ул. Московская, д. 16а	346606b1-642a-4600-8ef5-99077a801a5b	\N	\N	42701000	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	a9866d5e-1db7-4d77-9897-97a863a93a9f	t	+03:00	t	\N	ЛП	f	48	2024-09-29 09:49:42.781225
2caa5eae-b6c8-4943-8b8b-428dc9c6cb4d	b5209c2c-67f6-4b6d-9617-8370aa9907a8	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.784994	2024-09-29 09:49:42.784994	Department	08470871	ВК города Грязи и Грязинского района Липецкой области	Военный комиссариат города Грязи и Грязинского района Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Грязинский, г. Грязи, ул. Красная Площадь	4aebc0b1-7001-41e1-94bf-d6901f86187a	\N	\N	42606101	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	d61f100f-bd42-4433-9bbe-87f68a20eb3b	t	+03:00	t	\N	ЛГ	f	48	2024-09-29 09:49:42.784566
b00a1841-f444-4fb4-827a-a4e1075eac01	121d7da8-5f40-4e79-900a-ddba5a62f8aa	84bc45ab-c032-410e-9dc5-07e92719ede4	1	2024-09-29 09:49:42.788118	2024-09-29 09:49:42.788118	Department	08444570	ВК города Углегорск, Томаринского и Углегорского районов Сахалинской области	Военный комиссариат города Углегорск, Томаринского и Углегорского районов Сахалинской области		\N	\N		\N	обл. Сахалинская, р-н. Углегорский, г.. Углегорск, ул. Заводская, д. 2б	ae88cdce-b361-4a4f-b8de-9926d13ca043	\N	\N	64752000	1026500540659	1026500540659	\N	650101001	6501027156	64000000000	\N	d14b34ca-9d0d-4b1d-b52c-53c0e713d9eb	t	+11:00	t	\N	СУ	f	65	2024-09-29 09:49:42.78764
0b6eaee2-e52c-4d79-ab97-921a98007539	731b87ec-91e7-cf82-afcc-b2967439f7ae	b00de68d-2e09-4776-9b48-1566a7222dca	9	2024-09-29 09:49:42.791537	2024-09-29 09:49:42.791537	Organization	11111111	НЕ трогать оргу Андреева	НЕ трогать оргу Андреева				обл. Самарская, р-н. Волжский, с. Черноречье, снт. СТ Самараоблагромпром	ed96e764-0277-41a5-b80b-b398e0e80823	обл. Самарская, р-н. Волжский, с. Черноречье, снт. СТ Самараоблагропром	333d230f-9e8c-47ae-9eb5-68be26d65cdc	\N	\N		\N	\N	\N		1111111111	\N	\N		t		t	b00de68d-2e09-4776-9b48-1566a7222dca		f	\N	2024-09-29 09:49:42.790506
fb0ec464-70e8-421b-bb20-8a12bf5780c4	4b0309d6-f28a-49db-8950-5ffebd917e1e	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.850437	2024-09-29 09:49:42.850437	Department	08471704	ВК Чаплыгинского района Липецкой области	Военный комиссариат Чаплыгинского района Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Чаплыгинский, г. Чаплыгин, ул. Советская, д. 72	6112591a-b610-4b2c-bb0e-6fda1560433f	\N	\N	42656101	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	4dd91a25-c26b-4b67-849c-aa3c4ca8c619	t	+03:00	t	\N	ЛЧ	f	48	2024-09-29 09:49:42.793669
610d1eee-a270-4f35-b8aa-df017e102b5c	10b67909-b154-45e3-8eef-7f0fac9abb5d	092d6963-287c-454e-8d73-8e09ebee972e	2	2024-09-29 09:49:42.855212	2024-09-29 09:49:42.855212	Department	08496868	МВК Вятска	Муниципального Военный Комиссариат Вятска					\N	обл. Кировская, р-н. Вятскополянский, г. Вятские Поляны, ул. Ленина, д. 56	434c7f9f-5deb-4874-b871-8bbb6d4dd418	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	f	\N	ВА	f	18	2024-09-29 09:49:42.85465
f7fadde2-de94-4386-926a-48f539b14564	b042e073-e4ff-4873-b33e-4d44d17ec72d	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.859199	2024-09-29 09:49:42.859199	Department	08471153	ВК города Елец и Елецкого района Липецкой области	Военный комиссариат города Елец и Елецкого района Липецкой области		\N	\N		\N	обл. Липецкая, г. Елец, ул. Пушкина, д. 150	3e025e0c-a4cb-4344-929c-72f2e662ba77	\N	\N	42715000	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	936477a7-f986-4ed8-b67e-aa4c5ad0dc23	t	+03:00	t	\N	ЛЕ	f	48	2024-09-29 09:49:42.85867
1c213331-711b-4263-8275-a0e099e0f78d	cff66da8-2be0-4839-bd8e-332b1a150031	84bc45ab-c032-410e-9dc5-07e92719ede4	1	2024-09-29 09:49:42.865673	2024-09-29 09:49:42.865673	Department	08443912	ВК Анивского района Сахалинской области	Военный комиссариат Анивского района Сахалинской области		\N	\N		\N	обл. Сахалинская, р-н. Анивский, г. Анива, ул. Дьяконова, д. 24	55717011-38db-432a-aa16-d3d00414ef50	\N	\N	64708000	1026500540659	1026500540659	\N	650101001	6501027156	64000000000	\N	7ddb5992-36c7-4d80-832b-e8581da98730	t	+11:00	t	\N	СА	f	65	2024-09-29 09:49:42.865224
7e17cb21-4dfb-4f66-8996-1f87e78f8533	2966d239-5241-4acb-9b4f-707ba75f44d5	84bc45ab-c032-410e-9dc5-07e92719ede4	1	2024-09-29 09:49:42.868949	2024-09-29 09:49:42.868949	Department	08443808	ВК города Южно-Сахалинск Сахалинской области	Военный комиссариат города Южно-Сахалинск Сахалинской области		\N	\N		\N	обл. Сахалинская, г. Южно-Сахалинск, ул. Комсомольская, д. 194	308fb438-b9ec-421b-8422-d8eb27f29e16	\N	\N	64701000	1026500540659	1026500540659	\N	650101001	6501027156	64000000000	\N	af7f7a68-6d13-4518-9b9b-83b678819ce9	t	+11:00	t	\N	СЮ	f	65	2024-09-29 09:49:42.868559
dde8fd00-3648-49ed-a40e-c7caa58cab8d	eba7fd7d-e3da-49a7-8e65-8fc85e47190e	84bc45ab-c032-410e-9dc5-07e92719ede4	1	2024-09-29 09:49:42.871706	2024-09-29 09:49:42.871706	Department	08444127	ВК Ногликского района Сахалинской области	Военный комиссариат Ногликского района Сахалинской области		\N	\N		\N	обл. Сахалинская, р-н. Ногликский, пгт. Ноглики, ул. Пограничная, влд. 12	7dbffd02-6b0e-4dfb-a25b-3e371dd375b1	\N	\N	64732000	1026500540659	1026500540659	\N	650101001	6501027156	64000000000	\N	837c27db-0d16-42cb-9ec0-72eefe4a1aa6	t	+11:00	t	\N	СН	f	65	2024-09-29 09:49:42.871363
1eabf1d8-3202-4359-b6be-dd045afbfa40	70a19cf0-203a-4d04-a1c5-62c811c5ae66	2137685f-0683-4131-82d8-983222114184	4	2024-09-29 09:49:42.874264	2024-09-29 09:49:42.874264	Department	08471398	ВК Липецкого района Липецкой области	Военный комиссариат Липецкого района Липецкой области		lip@lip.lip	1111111111	обл. Липецкая, г. Липецк	eacb5f15-1a2e-432e-904a-ca56bd635f1b	обл. Липецкая, г. Липецк, пер. Бестужева, соор. 10	59d79c5c-5822-4eee-935a-5cbb63fca245	\N	\N	42640440	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	69264791-e45b-45d1-b2b2-a0c9e6cc5053	t	+03:00	t	\N	ЛЛ	f	48	2024-09-29 09:49:42.873937
e4671f49-8155-447a-a35c-67cb6468803a	70b872b5-79de-4ef6-b5f3-11ecc68906bc	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.876548	2024-09-29 09:49:42.876548	Department	08471561	ВК Усманского района Липецкой области	Военный комиссариат Усманского района Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Усманский, г. Усмань, ул. Советская, д. 22	8d0f4d5e-b55f-4fa2-8c6a-cf9dc85e3db3	\N	\N	42648101	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	5c39a9d5-da00-4876-b992-a7e55baf64ed	t	+03:00	t	\N	ЛУ	f	48	2024-09-29 09:49:42.876305
618c4e20-c2b1-4783-bd35-3d5f897e5b83	00148448-3ad9-4e0d-b9d2-c5e81a05bcf6	e8f52736-3997-4e3a-c9e4-5bfca6eddc89	4	2024-09-29 09:49:42.883059	2024-09-29 09:49:42.883059	Department	12221313	Тестовый муниципальный комиссариат 1	Тестовый муниципальный комиссариат 1					\N	г. Москва	0c5b2444-70a0-4932-980c-b4dc0d3f02b5	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+01:30	t	96f9779f-4028-4ef7-b841-9d1058a5062a	МО	f	77	2024-09-29 09:49:42.882485
0b713936-42c9-4e40-bde3-e941220b81de	34c8685e-f08a-4877-afb1-a0589800a21c	bb7aa36f-446e-4262-a609-28694ca2e398	1	2024-09-29 09:49:42.887103	2024-09-29 09:49:42.887103	Department	08486019	ВК Звениговского района Республики Марий Эл	Военный комиссариат Звениговского района Республики Марий Эл				Респ. Марий Эл, р-н. Звениговский, г. Звенигово, ул. Ростовщикова, д. 11	abbea836-207b-4ca3-8308-6552309c5282	Респ. Марий Эл, р-н. Звениговский, г. Звенигово, ул. Ростовщикова, д. 11	abbea836-207b-4ca3-8308-6552309c5282	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	t	\N	МЗ	f	\N	2024-09-29 09:49:42.886614
dbe21bb3-0416-4682-844a-07132e896a4b	fa005a7c-f833-0727-1924-990584ca6fee	25633423-52e6-45bb-9d54-7f85b74a3f7d	6	2024-09-29 09:49:42.89097	2024-09-29 09:49:42.89097	Organization	34512334	Тестовая организация	Тестовая организация					\N	Респ. Татарстан, г. Казань, ул. Юлиуса Фучика, д. 64, корп. 1	4fde76a4-9ede-47a5-ac5f-f6abff9cbe59	\N	\N		\N	\N	\N		2342342112	\N	\N		t	+00:00	t	25633423-52e6-45bb-9d54-7f85b74a3f7d	АА	f	4	2024-09-29 09:49:42.890601
674eb255-c2a6-45e7-8395-46118f95cb9f	786b4e73-42dd-4c36-968e-8cce5d9debc6	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.893707	2024-09-29 09:49:42.893707	Department	08471414	ВК Становлянского района Липецкой области	Военный комиссариат Становлянского района Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Становлянский, с. Становое, ул. Советская, д. 27	966cdb9f-0342-4243-b10b-1822a6893d20	\N	\N	42642452	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	e6587c76-9fab-44c1-b1c9-5ab6a4fc2e4d	t	+03:00	t	\N	ЛС	f	48	2024-09-29 09:49:42.893331
78a69506-f876-4549-add0-dd9b95e4cde9	5584b973-f5c0-4aee-ae5a-0b0d0444ad1b	e8f52736-3997-4e3a-c9e4-5bfca6eddc89	1	2024-09-29 09:49:42.896277	2024-09-29 09:49:42.896277	Department	12345555	Тестовый муниципальный комиссариат 3	Тестовый муниципальный комиссариат 3					\N	обл. Свердловская, г. Ивдель, ул. 50 лет Октября, гск. Москвич	721c162c-197a-4281-8ad9-8ae3efe2d655	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+01:30	t	96f9779f-4028-4ef7-b841-9d1058a5062a	МО	f	10	2024-09-29 09:49:42.895925
7aaab069-b993-469c-9cdc-d05b48e01da2	d49f28d4-0eca-4fd7-b68c-a0a693223de0	e8f52736-3997-4e3a-c9e4-5bfca6eddc89	1	2024-09-29 09:49:42.898589	2024-09-29 09:49:42.898589	Department	12345556	Тестовый муниципальный комиссариат 4	Тестовый муниципальный комиссариат 4					\N	г. Москва	0c5b2444-70a0-4932-980c-b4dc0d3f02b5	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+01:30	t	b99510d0-4677-44e6-ad1d-1de6920c85c8	МО	f	77	2024-09-29 09:49:42.898284
58e31fcf-567c-4b4c-8bc7-eb5fb9676f08	6daa4999-df84-4469-bcc7-0f875affd41a	bce5663e-5fe1-94a7-40f9-71d0490459da	1	2024-09-29 09:49:42.900957	2024-09-29 09:49:42.900957	Department	12323421	тестт	тестт					\N	обл. Омская, м.р-н. Москаленский	8b25be01-3310-4189-84aa-d57170d3f467	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+02:20	t	\N	ЖД	f	40	2024-09-29 09:49:42.900689
e2683ce5-7de8-43b8-9ff3-2a2dc23a4e7c	bb7aa36f-446e-4262-a609-28694ca2e398	58ef9cdc-8a9d-429e-89a5-1c49e2684a98	2	2024-09-29 09:49:42.950441	2024-09-29 09:49:42.950441	Organization	08091166	ВК республики Мари Эл	Военный комиссариат республики Мари Эл		test@test.ru	1111111111	Респ. Марий Эл, г. Йошкар-Ола, пр-кт. Гагарина, д. 16	341779b1-f7c3-48c6-8d21-4bd7f79d07bf	Респ. Марий Эл, г. Йошкар-Ола, пр-кт. Гагарина, д. 16	341779b1-f7c3-48c6-8d21-4bd7f79d07bf	\N	\N		\N	\N	\N		1200001356	\N	\N		t	+03:00	t	58ef9cdc-8a9d-429e-89a5-1c49e2684a98		f	\N	2024-09-29 09:49:42.902854
0068b57d-1272-467d-8cfd-fb3edb9ce430	6f60bde2-33f8-4b33-be9f-cd57a6e041c4	bb7aa36f-446e-4262-a609-28694ca2e398	1	2024-09-29 09:49:42.954233	2024-09-29 09:49:42.954233	Department	08486367	ВК Республики Марий Эл	Военный комиссариат Сернурского района Республики Марий Эл				Респ. Марий Эл, р-н. Сернурский, пгт. Сернур, ул. Коммунистическая, д. 63	0f4f0b9b-80af-4942-b01d-a001b15122a2	Респ. Марий Эл, р-н. Сернурский, пгт. Сернур, ул. Коммунистическая, д. 63	0f4f0b9b-80af-4942-b01d-a001b15122a2	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	t	\N	МС	f	\N	2024-09-29 09:49:42.953784
1ac66d8e-29ad-4cab-93fc-cced8d8b94b6	55eae374-9bb5-4295-9e3a-5fbcdaba870d	bb7aa36f-446e-4262-a609-28694ca2e398	1	2024-09-29 09:49:42.957764	2024-09-29 09:49:42.957764	Department	07871577	ВК г. Йошкар-Ола Республики Марий Эл	Военный комиссариат города Йошкар-Ола Республики Марий Эл				Респ. Марий Эл, г. Йошкар-Ола, пр-кт. Гагарина, д. 16	341779b1-f7c3-48c6-8d21-4bd7f79d07bf	Респ. Марий Эл, г. Йошкар-Ола, пр-кт. Гагарина, д. 16	341779b1-f7c3-48c6-8d21-4bd7f79d07bf	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	t	\N	МЙ	f	\N	2024-09-29 09:49:42.957306
efdbd421-c2b7-4d4a-a2b0-9a377595b060	30ce4b57-17ca-4b01-b685-1303ce22e3f2	bb7aa36f-446e-4262-a609-28694ca2e398	1	2024-09-29 09:49:42.960476	2024-09-29 09:49:42.960476	Department	08486114	ВК Мари-Турекского и Параньгинского районов Республики Марий Эл	Военный комиссариат Мари-Турекского и Параньгинского районов Республики Марий Эл			1111111111	Респ. Марий Эл, р-н. Мари-Турекский, пгт. Мари-Турек, ул. Красноармейская, д. 19	a5efc9b1-afd5-4bd0-b9fb-ae72d4e62baf	Респ. Марий Эл, р-н. Мари-Турекский, пгт. Мари-Турек, ул. Красноармейская, д. 19	a5efc9b1-afd5-4bd0-b9fb-ae72d4e62baf	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	t	\N	ММ	f	\N	2024-09-29 09:49:42.960087
44cbc7da-0243-4ec1-a3e0-604599501502	d5dd717e-d2f4-4e93-860a-1bb1a97beb46	bb7aa36f-446e-4262-a609-28694ca2e398	1	2024-09-29 09:49:42.96562	2024-09-29 09:49:42.96562	Department	08486054	ВК Куженерского района Республики Марий Эл	Военный комиссариат Куженерского района Республики Марий Эл				Респ. Марий Эл, р-н. Куженерский, пгт. Куженер, ул. Советская, д. 10	9b329561-1d97-42ca-aac2-b383e3aed5e9	Респ. Марий Эл, р-н. Куженерский, пгт. Куженер, ул. Советская, д. 10	9b329561-1d97-42ca-aac2-b383e3aed5e9	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	t	\N	МК	f	\N	2024-09-29 09:49:42.965182
10653db1-856c-4f9b-b624-55bd2345380b	2befcbb4-7eb3-4a77-a3cb-f7f0eb0fab2e	bb7aa36f-446e-4262-a609-28694ca2e398	1	2024-09-29 09:49:42.968291	2024-09-29 09:49:42.968291	Department	08485959	ВК города Волжск и Волжского района Республики Марий Эл	Военный комиссариат города Волжск и Волжского района Республики Марий Эл				Респ. Марий Эл, г. Волжск, ул. Авиации, д. 51	da0941a3-25b7-48b0-99c7-9624ada1a986	Респ. Марий Эл, г. Волжск, ул. Авиации, д. 51	da0941a3-25b7-48b0-99c7-9624ada1a986	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	t	\N	МВ	f	\N	2024-09-29 09:49:42.96793
9e0d94ef-2c1f-4335-9279-497357dfe550	0ce35443-78f6-473a-97f2-e1f2d5ba7a4e	bb7aa36f-446e-4262-a609-28694ca2e398	4	2024-09-29 09:49:42.970858	2024-09-29 09:49:42.970858	Department	08486404	ВК Советского района Республики Марий Эл	Военный комиссариат Советского района Республики Марий Эл				Респ. Марий Эл, р-н. Советский, пгт. Советский, ул. Садовая, д. 6б	a9d465bd-16d2-4a8e-ab03-2f157fd31846	Респ. Марий Эл, р-н. Советский, пгт. Советский, ул. Садовая, д. 6б	a9d465bd-16d2-4a8e-ab03-2f157fd31846	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	t	\N	МС	f	12	2024-09-29 09:49:42.970535
51f57f8b-b2ef-4409-89cd-55b544c1dfcd	ac702380-5836-4bed-b846-a8c15b241a84	bb7aa36f-446e-4262-a609-28694ca2e398	1	2024-09-29 09:49:42.973581	2024-09-29 09:49:42.973581	Department	08486278	ВК Оршанского района Республики Марий Эл	Военный комиссариат Оршанского района Республики Марий Эл				Респ. Марий Эл, р-н. Оршанский, пгт. Оршанка, ул. Советская, д. 47	53407427-08ac-47bb-86da-3821e376c4ae	Респ. Марий Эл, р-н. Оршанский, пгт. Оршанка, ул. Советская, д. 47	53407427-08ac-47bb-86da-3821e376c4ae	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	t	\N	МО	f	\N	2024-09-29 09:49:42.973194
b08c1d90-915a-4bb4-a6c4-f44e2af9e63d	6ed8b34f-d049-4b7f-8d1b-b99a1852236b	bb7aa36f-446e-4262-a609-28694ca2e398	1	2024-09-29 09:49:42.976162	2024-09-29 09:49:42.976162	Department	08486120	ВК Медедевского и Килемарского района Республики Марий Эл	Военный комиссариат Медедевского и Килемарского района Республики Марий Эл				Респ. Марий Эл, р-н. Медведевский, пгт. Медведево, ул. Шумелева, д. 14	0f872398-5f7f-4d42-a17e-1dda2faf974c	Респ. Марий Эл, р-н. Медведевский, пгт. Медведево, ул. Шумелева, д. 14	0f872398-5f7f-4d42-a17e-1dda2faf974c	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	t	\N	ММ	f	\N	2024-09-29 09:49:42.975837
8667f0ec-4ca3-4668-8846-8b665cebda8d	fc10523f-af31-4f6b-b0e2-00799758f634	bb7aa36f-446e-4262-a609-28694ca2e398	1	2024-09-29 09:49:42.978625	2024-09-29 09:49:42.978625	Department	08485971	ВК города Козьмодемьянск, Горномарийского и Юринского районов Республики Марий Эл	Военный комиссариат города Козьмодемьянск, Горномарийского и Юринского районов Республики Марий Эл				Респ. Марий Эл, г. Козьмодемьянск, ул. Гагарина, д. 54	dbc24888-8544-4ad2-85a3-03b2d490cdd6	Респ. Марий Эл, г. Козьмодемьянск, ул. Гагарина, д. 54	dbc24888-8544-4ad2-85a3-03b2d490cdd6	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	t	\N		f	\N	2024-09-29 09:49:42.978311
a933e951-88c0-421d-a291-33fa4cea36fc	1ff99d4f-7418-46bc-9c60-61a0e4ec77bd	bb7aa36f-446e-4262-a609-28694ca2e398	2	2024-09-29 09:49:42.981338	2024-09-29 09:49:42.981338	Department	08486166	ВК Моркинского района Республики Марий Эл	Военный комиссариат Моркинского района Республики Марий Эл				Респ. Марий Эл, р-н. Моркинский, пгт. Морки, ул. Пушкина, д. 16	199b74ce-00a6-4fbd-a681-f60db2754db7	Респ. Марий Эл, р-н. Моркинский, пгт. Морки, ул. Пушкина, д. 16	199b74ce-00a6-4fbd-a681-f60db2754db7	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	t	\N	ММ	f	12	2024-09-29 09:49:42.98099
58684643-1498-446e-bd62-8883d17f72bd	9a4640f6-143a-7642-51bd-d2b5ac5e9d1e	b00de68d-2e09-4776-9b48-1566a7222dca	3	2024-09-29 09:49:42.983939	2024-09-29 09:49:42.983939	Organization	96199409	ВК Вятска	Военный комиссариат Вятска Тест					\N	Респ. Удмуртская, р-н. Каракулинский, с/п. Вятское	71e8456a-acf1-432d-80ee-def9d7123fab	\N	\N		\N	\N	\N		3333333333	\N	\N		t	+01:30	f	b00de68d-2e09-4776-9b48-1566a7222dca	ВЯ	f	18	2024-09-29 09:49:42.983526
6693233b-7893-43b5-80f5-08b282c35156	1cf09194-0f3b-4f2c-a14f-03604d68ff8f	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.986828	2024-09-29 09:49:42.986828	Department	08470969	ВК Добринского района Липецкой области	Военный комиссариат Добринского района Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Добринский, п. Добринка, ул. Корнева, д. 9	635c92bc-ab19-4617-9e53-0deae43b850a	\N	\N	42612422	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	4c04ea3a-577f-4cbb-998c-c3a57137461b	t	+03:00	t	\N	ЛД	f	48	2024-09-29 09:49:42.986397
b9c6bc65-f4be-4b7e-842b-1c4d90f0c07f	52b4ee14-5af8-c029-26c2-80faba9e967d	b00de68d-2e09-4776-9b48-1566a7222dca	3	2024-09-29 09:49:42.989945	2024-09-29 09:49:42.989945	Organization	23422332	Вторая организация	Вторая организация					\N	Респ. Татарстан, г. Казань, ул. Юлиуса Фучика, д. 64, корп. 2, кв. 1	f81f8017-27b8-4994-9f17-e61d1684a55b	\N	\N		\N	\N	\N		3423445434	\N	\N		t	+00:00	t	b00de68d-2e09-4776-9b48-1566a7222dca	АА	f	50	2024-09-29 09:49:42.989499
46c0431c-6d5e-469c-9b89-2f0ed33c2cef	9c459101-fa10-4468-acbb-ce34df064aa1	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.992844	2024-09-29 09:49:42.992844	Department	08471041	ВК Добровского района Липецкой области	Военный комиссариат Добровского района Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Добровский, с. Доброе, ул. Советской Армии, д. 2	1de813ab-7a54-4791-8163-bdb3812f4368	\N	\N	42615416	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	726dd93c-9e9d-40d4-91e3-3b9dd03c1cbe	t	+03:00	t	\N	ЛД	f	48	2024-09-29 09:49:42.992492
4e4c712e-f3bb-4f2f-8cf1-6e1c9bda2677	5ea50fa7-0b85-4a27-8293-dbd36162cb9a	52b4ee14-5af8-c029-26c2-80faba9e967d	2	2024-09-29 09:49:42.995541	2024-09-29 09:49:42.995541	Department	34523323	Второе подразделение	Второе подразделение					\N	Респ. Татарстан, г. Казань, ул. Юлиуса Фучика, д. 64, корп. 2, кв. 1	f81f8017-27b8-4994-9f17-e61d1684a55b	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+01:00	t	\N	АА	f	31	2024-09-29 09:49:42.995194
4da4fafb-f3ba-4f18-8140-54fffd552d59	a2d517d4-a6c3-4cb8-8d9b-3c8d15a7007c	2137685f-0683-4131-82d8-983222114184	1	2024-09-29 09:49:42.998227	2024-09-29 09:49:42.998227	Department	08471503	ВК Тербунского и Воловского районов Липецкой области	Военный комиссариат Тербунского и Воловского районов Липецкой области		\N	\N		\N	обл. Липецкая, р-н. Тербунский, с. Тербуны, ул. Ленина, д. 59	2bcf7e99-6f01-4920-851c-0a3b2ce4e637	\N	\N	42645458	1024800835311	1024800835311	\N	482501001	4825011699	42000000000	\N	73679f37-b808-4937-ba57-6703ed798d11	t	+03:00	t	\N	ЛТ	f	48	2024-09-29 09:49:42.997899
d740fa3c-bb0a-42d7-9ba6-347fc7b57e4a	4c062d4a-3f77-c850-6388-dde909e3946b	58ef9cdc-8a9d-429e-89a5-1c49e2684a98	2	2024-09-29 09:49:43.050417	2024-09-29 09:49:43.050417	Organization	54645334	АВвыфафв	АВфвафв					\N	обл. Свердловская, г. Ивдель, ул. 50 лет Октября, снт. Москвич	dd070b86-ee86-4fd7-bea9-178d8f0ab4cc	\N	\N	24214321412	\N	\N	\N	213412321	5234543223	\N	\N		t	+01:34	t	58ef9cdc-8a9d-429e-89a5-1c49e2684a98	ВА	f	36	2024-09-29 09:49:43.000637
dfe9ce08-7f82-4d59-a21d-65c1a9f1ed3b	bacac23b-477f-4c26-8973-d83f0ca387fb	84bc45ab-c032-410e-9dc5-07e92719ede4	1	2024-09-29 09:49:43.055669	2024-09-29 09:49:43.055669	Department	08444050	ВК города Корсаков и Корсаковского района Сахалинской области	Военный комиссариат города Корсаков и Корсаковского района Сахалинской области		\N	\N		\N	обл. Сахалинская, р-н. Корсаковский, г. Корсаков, ул. Окружная, зд. 58	ec66984a-c184-4dae-a2ca-8daac8c925f5	\N	\N	64716000	1026500540659	1026500540659	\N	650101001	6501027156	64000000000	\N	3a9683ce-e82c-4154-ab52-3cd9e0caaa36	t	+11:00	t	\N	СК	f	65	2024-09-29 09:49:43.054909
9c09e210-6dd9-4bc3-a8ad-f3dd4d1cc70a	82518cee-d3ce-40fd-a5b4-3e12647afc45	84bc45ab-c032-410e-9dc5-07e92719ede4	1	2024-09-29 09:49:43.060245	2024-09-29 09:49:43.060245	Department	08444392	ВК города Александровск-Сахалинский, Александровск-Сахалинского и Тымовского районов Сахалинской области	Военный комиссариат города Александровск-Сахалинский, Александровск-Сахалинского и Тымовского районов Сахалинской области		\N	\N		\N	обл. Сахалинская, р-н. Тымовский, пгт. Тымовское, ул. Харитонова, д. 19	72156f5a-44b1-4c06-84e4-4fe5b7616e59	\N	\N	64750000	1026500540659	1026500540659	\N	650101001	6501027156	64000000000	\N	d1a06c53-0dad-41b1-ac02-258eb45fa28b	t	+11:00	t	\N	СА	f	65	2024-09-29 09:49:43.059666
4dcebf08-40b2-4ba0-8fe8-700d67cdc5b2	22c64b79-f8e4-41e7-a2f3-1aa9df424fd9	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:43.064228	2024-09-29 09:49:43.064228	Department	08476819	ВК Рыбновского района Рязанской области	Военный комиссариат Рыбновского района Рязанской области		\N	\N		\N	обл. Рязанская, р-н. Рыбновский, г. Рыбное, ул. Советской Армии	06d6380c-4f90-4c89-93d1-979a98e9ace7	\N	\N	61627101	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	57761889-e0ba-4def-94ed-15b134a87ca1	t	+03:00	t	\N	РР	f	62	2024-09-29 09:49:43.063521
3e77b04b-168d-4f27-a4b4-dce4ac71f394	27f7b3c0-a222-45e0-896f-58bdf4341a41	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:43.069449	2024-09-29 09:49:43.069449	Department	08476529	ВК города Михайлов, Михайловского и Захаровского районов Рязанской области	Военный комиссариат города Михайлов, Михайловского и Захаровского районов Рязанской области		\N	\N		\N	обл. Рязанская, р-н. Михайловский, г. Михайлов, пл. Ленина	e37d3b48-a980-42ce-869a-e3abbf438798	\N	\N	61617101	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	2c66c5ea-4d7a-464e-9279-f9af1cf4258d	t	+03:00	t	\N	РМ	f	62	2024-09-29 09:49:43.068624
e7eaf26b-e0b6-4b1f-8a8b-c7f4ec26fb90	370bc761-ae40-46f1-b4d8-974317b5ceb6	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:43.07467	2024-09-29 09:49:43.07467	Department	08476438	ВК города Касимов и Касимовского района Рязанской области	Военный комиссариат города Касимов и Касимовского района Рязанской области		\N	\N		\N	обл. Рязанская, г. Касимов, ул. Карла Маркса, д. 7	78996d8c-9f40-4798-9f40-63e74e80a8b0	\N	\N	61705000	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	954a9df0-531f-47f7-aaa0-e0ddfd64c880	t	+03:00	t	\N	РК	f	62	2024-09-29 09:49:43.074076
d05d4f2f-168f-48c8-8817-f6403654a614	d1efbe15-744e-8521-5b8e-7ac604e4379b	b00de68d-2e09-4776-9b48-1566a7222dca	3	2024-09-29 09:49:43.07826	2024-09-29 09:49:43.07826	Organization	23344455	Тестовая Организация	Тестовая Организация					\N	г. Москва	0c5b2444-70a0-4932-980c-b4dc0d3f02b5	\N	\N		\N	\N	\N		2222222222	\N	\N		t	+01:30	t	b00de68d-2e09-4776-9b48-1566a7222dca	МО	f	46	2024-09-29 09:49:43.077776
2386a304-73a2-40ce-b3ec-f02d688f3b20	37c187fe-4f37-45e6-9246-07148112367c	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:43.082578	2024-09-29 09:49:43.082578	Department	08476794	ВК Пронского и Старожиловского районов Рязанской области	Военный комиссариат Пронского и Старожиловского районов Рязанской области		\N	\N		\N	обл. Рязанская, р-н. Пронский, рп. Пронск, ул. Первомайская, д. 25	ae784d87-e52a-416a-9d30-8ff52396a3de	\N	\N	61625151	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	0bab4262-c2f1-4140-9ffd-4e326d17f900	t	+03:00	t	\N	РП	f	62	2024-09-29 09:49:43.081734
4ac5c009-5dc4-4ed3-a2ae-ec3a583d8ec0	dad6c101-34be-45c3-8173-57190cb69dfb	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:43.086295	2024-09-29 09:49:43.086295	Department	08476860	ВК Ряжского и Александро-Невского районов Рязанской области	Военный комиссариат Ряжского и Александро-Невского районов Рязанской области		\N	\N		\N	обл. Рязанская, р-н. Ряжский, г. Ряжск, ул. Высотная, д. 1А	ee4e1a93-68b0-4d52-98ff-ce41870c762d	\N	\N	61630101	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	95431672-0829-4532-b888-7dfd37f89be5	t	+03:00	t	\N	РР	f	62	2024-09-29 09:49:43.085829
aa6f0546-fc5d-4c51-a22d-27a8ce0041f3	f6a7fb8b-379f-4802-bf00-73f9c493825f	092d6963-287c-454e-8d73-8e09ebee972e	1	2024-09-29 09:49:43.089197	2024-09-29 09:49:43.089197	Department	08476920	ВК города Сасово, Ермишинского, Кадомского, Сасовского и Пителинского районов Рязанской области	Военный комиссариат города Сасово, Ермишинского, Кадомского, Сасовского и Пителинского районов Рязанской области		\N	\N		\N	обл. Рязанская, г. Сасово, ул. Ленина, д. 67	e472eeb4-9784-458e-a8b0-4c186ab48cc9	\N	\N	61710000	1026201271337	1026201271337	\N	602701001	6231026092	61000000000	\N	881b2f73-b939-4796-98f6-8dd16fa937ad	t	+03:00	t	\N	РС	f	62	2024-09-29 09:49:43.08885
8000b421-4a1a-4db4-97f7-e01daaa93f42	0e10678c-f272-41c3-94dd-c15830321f9a	bb7aa36f-446e-4262-a609-28694ca2e398	3	2024-09-29 09:49:43.092122	2024-09-29 09:49:43.092122	Department	08486189	ВК Новоторъяльского района Республики Марий Эл	Военный комиссариат Новоторъяльского района Республики Марий Эл				Респ. Марий Эл, р-н. Новоторъяльский, пгт. Новый Торъял, ул. Советская, д. 11	e709b7cf-5e4b-4034-84f0-c59408137b61	Респ. Марий Эл, р-н. Новоторъяльский, пгт. Новый Торъял, ул. Советская, д. 11	e709b7cf-5e4b-4034-84f0-c59408137b61	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	t	\N	МН	f	12	2024-09-29 09:49:43.091659
ce800cef-2d23-43e3-974f-6b79de3270ae	fe655d90-893a-31f7-ff8b-9ccef8af0f83	30a01af9-a871-411a-90e3-d81592bb074f	2	2024-09-29 09:49:43.150363	2024-09-29 09:49:43.150363	Organization	00000001	Администрация городского округа Щёлково Московской области	Администрация городского округа Щёлково Московской области			1111111111	обл. Московская, г. Щёлково, гск. Центральный	ca9ef592-d8d5-4cea-88f5-7d1823ba3fc9	обл. Московская, г. Щёлково, гск. Центральный	ca9ef592-d8d5-4cea-88f5-7d1823ba3fc9	\N	\N		\N	\N	\N		2376709786	\N	\N		t	+03:00	t	30a01af9-a871-411a-90e3-d81592bb074f	МЩ	f	50	2024-09-29 09:49:43.094485
3b767267-c2ef-468c-9e67-114ec4105832	e079ea79-50f1-4af4-beea-1b7648e86ce9	fe655d90-893a-31f7-ff8b-9ccef8af0f83	1	2024-09-29 09:49:43.1562	2024-09-29 09:49:43.1562	Department	08474818	ВК городских округов Щелково Фрязино Звездный городок и Лосино-Петровского городского округа Московской области	ВК городских округов Щелково Фрязино Звездный городок и Лосино-Петровского городского округа Московской области				обл. Московская, г. Щёлково, ул. Центральная	a94b46de-09e5-4292-80e1-db2e49797b00	обл. Московская, г. Щёлково, ул. Центральная	a94b46de-09e5-4292-80e1-db2e49797b00	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N		t	+03:00	t	\N	МЩ	f	50	2024-09-29 09:49:43.155505
\.


--
-- TOC entry 4230 (class 0 OID 2447141)
-- Dependencies: 238
-- Data for Name: user_application_document; Type: TABLE DATA; Schema: public; Owner: ervu_account_applications
--

COPY public.user_application_document (user_application_document_id, file_name, file, user_application_list_id) FROM stdin;
2	dev_test (1).csv	\\x7375726e616d653b66697273746e616d653b6d6964646c656e616d653b7365783b6269727468646174653b736e696c733b706f736974696f6e3b757365726e616d653b6970416464726573730d0ad2e5f1f2e8ea3bcfe5f2f0e8ea3bc8eaeee2e8f73b4d414c453b30322e30322e323030323b3138372d3837382d313633203533203bd1eef2f0f3e4ede8ea20c2ca3b7465737450657472696b3b0d0acaf0e0ea3bcae0f0eb3bc8eaeee2e8f73b4d414c453b30322e30322e323030323b3138372d3837382d313633203533203bd1eef2f0f3e4ede8ea20c2ca3b7465737450657472696b72616b3b0d0a	1
4	ffkdklfk.txt	\\x2f636f6e76657273696f6e732020202d202020d0bad0bed0bdd0b2d0b5d180d182d0b0d186d0b8d18f0d0a0d0a2f696e697469616c5f726567697374726174696f6e2009202d09d09fd0b5d180d0b2d0bed0bdd0b0d187d0b0d0bbd18cd0bdd0b0d18f20d0bfd0bed181d182d0b0d0bdd0bed0b2d0bad0b020d0bdd0b020d183d187d0b5d182090d0a0d0a2f7570646174696e67202020202d20202020d090d0bad182d183d0b0d0bbd0b8d0b7d0b0d186d0b8d18f0d0a0d0a2f72656769737465725f737562706f656e61732020202d20202020d0a0d0b5d0b5d181d182d18020d0bfd0bed0b2d0b5d181d182d0bed0ba0d0a0d0a2f72656769737465725f737562706f656e61735f73756273797374656d202020202d20202020d0a0d0b5d0b5d181d182d18020d0bfd0bed0b2d0b5d181d182d0bed0ba28d0bfd0bed0b4d181d0b8d181d182d0b5d0bcd0b0290d0a0d0a2f72656d6f76616c5f6d696c69746172795f726567697374726174696f6e2020202d20202020d0a1d0bdd18fd182d0b8d0b520d18120d0b2d0bed0b8d0bdd181d0bad0bed0b3d0be20d183d187d0b5d182d0b0090d0a0d0a0d0a0d0a0d0a2f6d696c69746172795f726567697374726174696f6e5f6368616e67696e675f61646472657373092020202d2020202020d09fd0bed181d182d0b0d0bdd0bed0b2d0bad0b020d0bdd0b020d0b2d0bed0b8d0bdd181d0bad0b8d0b920d183d187d0b5d18220d0bfd180d0b820d181d0bcd0b5d0bdd0b520d0b0d0b4d180d0b5d181d0b00d0a0d0a2f696e636964656e74732020202d20202020d0b8d0bdd186d0b8d0b4d0b5d0bdd182d18b0d0a0d0a2f6c6f6767696e67202020202d20202020d0b6d183d180d0bdd0b0d0bbd0b8d180d0bed0b2d0b0d0bdd0b80d0a0d0a2f61646d696e697374726174696f6e09202020202d20202020d0b0d0b4d0bcd0b8d0bdd0b8d181d182d180d0b8d180d0bed0b2d0b0d0bdd0b8d0b50d0a0d0a2f6163636f756e74696e675f6372696d696e616c5f61646d696e6973747261746976655f6c696162696c697479092d202020d0a3d187d0b5d18220d183d0b3d0bed0bbd0bed0b2d0bdd0bed0b92c20d0b0d0b4d0bcd0b8d0bdd0b8d181d182d180d0b0d182d0b8d0b2d0bdd0bed0b920d0bed182d0b2d0b5d182d181d182d0b2d0b5d0bdd0bdd0bed181d182d0b80d0a0d0a2f61707065616c732020202d20202020d0bed0b1d0b6d0b0d0bbd0bed0b2d0b0d0bdd0b8d18f0d0a0d0a0d0a0d0a73746174696320726f757465206e610d0a0d0a70616e656c2d62746e0d0a0d0a2d32307078203070782030707820307078	2
6	Карточка.pdf	\\[encoded data, 79319 characters]	3
8	Карточка.pdf	\\[encoded data, 79319 characters]	4
9	\N	\N	5
10	\N	\N	6
\.


--
-- TOC entry 4233 (class 0 OID 2447151)
-- Dependencies: 241
-- Data for Name: user_application_list; Type: TABLE DATA; Schema: public; Owner: ervu_account_applications
--

COPY public.user_application_list (user_application_list_id, application_kind, user_login, user_password, secondname, firstname, middlename, phone, ip_address, start_date, close_date, user_status, application_status, comment, job_position_id, user_role_id, recruitment_id, user_account_id, sex, birth_date, snils, job_position, ip_address_additional, number_app, edit_comment) FROM stdin;
1	CREATE_USER	роорhjhvjhvjhvYGV45	\N	Ромашкин	Игорь	Петрович	\N	\N	2024-11-27 09:46:17.340085	\N	\N	CANCEL_BY_CREATOR	\N	\N	\N	0068b57d-1272-467d-8cfd-fb3edb9ce430	\N	MALE	\N	984-465-651 65	\N	\N	1	\N
2	CREATE_USER	ориjhjdwfe5522H	длтgcgfcgcgcg	Лопаткин	Юрий	\N	\N	\N	2024-11-27 10:31:12.616808	\N	\N	LOGIN_PASSWORD_ISSUED	\N	\N	\N	0068b57d-1272-467d-8cfd-fb3edb9ce430	\N	\N	\N	656-132-132 12	\N	\N	2	\N
3	CREATE_USER	mnnmk5985JJHJh	\N	Еремеев	Константин	\N	\N	\N	2024-11-27 10:54:19.888099	\N	\N	REJECT_BY_AGREEER	jnrkjytyj	\N	\N	0068b57d-1272-467d-8cfd-fb3edb9ce430	\N	\N	\N	984-646-565 46	\N	\N	3	\N
4	CREATE_USER	hghHHHB41	орлолоgfgfcgfc5464	Улюкаев	Адель	\N	\N	\N	2024-11-27 11:17:44.04653	\N	\N	LOGIN_PASSWORD_ISSUED	\N	\N	\N	0068b57d-1272-467d-8cfd-fb3edb9ce430	\N	\N	\N	654-646-546 51	\N	\N	4	\N
5	BLOCK_USER	sdfsfdNNBN55	\N	Орлов	Марк	\N	\N	\N	2024-11-27 11:31:33.019927	\N	\N	ACCEPTED	\N	\N	\N	0068b57d-1272-467d-8cfd-fb3edb9ce430	\N	\N	\N	651-651-116 51	\N	\N	5	\N
6	EDIT_USER	vfNNN5444645	\N	Лукошкина	Екатерина	\N	\N	\N	2024-11-27 11:36:41.623836	\N	\N	ACCEPTED	\N	\N	\N	0068b57d-1272-467d-8cfd-fb3edb9ce430	\N	\N	\N	656-513-213 21	\N	\N	6	смена фамилии Правдина
\.


--
-- TOC entry 4222 (class 0 OID 2447035)
-- Dependencies: 230
-- Data for Name: access_level; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.access_level (access_level_id, level, description) FROM stdin;
a6bf4b31-6648-4095-b269-2a950b548a10	0	user access level
a3b84288-1c96-448b-ba33-7a454f311757	100	admin access level
2b6038cb-15bf-4bb0-87df-88a1557b93d7	999	superadmin access level
\.


--
-- TOC entry 4217 (class 0 OID 2446967)
-- Dependencies: 225
-- Data for Name: authority; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.authority (authority_id, name, created) FROM stdin;
ac44a379-95b8-4222-99ab-8e70bd24a717	BPMN.ADMIN.PROCESS_INSTANCE.ABORT	2024-11-26 20:29:45.221619+03
378fdfa7-6039-42ac-8586-073165e2eab8	BPMN.ADMIN.PROCESS_INSTANCE.LIST	2024-11-26 20:29:45.221619+03
02d1eeb1-54cc-4002-b5ef-f5b5f40ab895	BPMN.ADMIN.PROCESS_INSTANCE.VARIABLE_READ	2024-11-26 20:29:45.221619+03
53da7292-c97a-491a-a4f2-ca348dd3add5	BPMN.ADMIN.PROCESS_INSTANCE.READ	2024-11-26 20:29:45.221619+03
97ff4363-d78c-4e39-8620-fdbca6bd6b89	BPMN.ADMIN.PROCESS_INSTANCE.HISTORY	2024-11-26 20:29:45.221619+03
4406c5fa-e6bb-468c-a2f8-d76aa788fbd5	BPMN.USER.TASK_LIST	2024-11-26 20:29:45.221619+03
f8ea4d65-54b4-49e3-8cf7-b209af7bd558	BPMN.USER.START_PROCESS	2024-11-26 20:29:45.221619+03
8bbacf0c-ef2e-459c-b14f-6bf7b6236b72	BPMN.USER.START_TASK	2024-11-26 20:29:45.221619+03
a5f72fd8-998b-4c25-a8d7-f789b5c8a731	USER_MANAGEMENT.ROLE.LIST	2024-11-26 20:29:45.221619+03
d438673b-a9a6-43c7-b692-b37d06789fb5	USER_MANAGEMENT.ROLE.READ	2024-11-26 20:29:45.221619+03
4eb6c3b9-98a8-41df-a5b4-431d726b181a	USER_MANAGEMENT.ROLE.WRITE	2024-11-26 20:29:45.221619+03
03876f9b-3656-4f3e-8e1d-ac203a236fcf	USER_MANAGEMENT.ROLE.DELETE	2024-11-26 20:29:45.221619+03
1752fcbc-65ae-49c0-9e74-15a65b094b55	USER_MANAGEMENT.GROUP.LIST	2024-11-26 20:29:45.221619+03
9e263628-a3e0-4e90-9942-9fe9e42a22ed	USER_MANAGEMENT.GROUP.READ	2024-11-26 20:29:45.221619+03
94839999-0711-41ca-8641-88b99263c587	USER_MANAGEMENT.GROUP.WRITE	2024-11-26 20:29:45.221619+03
56e9a141-10f1-468c-bce5-cb6a23edb353	USER_MANAGEMENT.GROUP.DELETE	2024-11-26 20:29:45.221619+03
d61d3172-aa6c-40e6-b7b0-d733b97655a5	USER_MANAGEMENT.GROUP.BOUND_ROLE.LIST	2024-11-26 20:29:45.221619+03
df29eb01-e1d7-41df-b5e7-bb5229a101c1	USER_MANAGEMENT.GROUP.BOUND_ROLE.BIND	2024-11-26 20:29:45.221619+03
e02c12e9-681a-4b6c-877b-0c119294a64d	USER_MANAGEMENT.GROUP.BOUND_ROLE.UNBIND	2024-11-26 20:29:45.221619+03
77a067f4-d188-4a51-a342-8e48dc6e1907	USER_MANAGEMENT.USER.LIST	2024-11-26 20:29:45.221619+03
d0890070-7ffe-4821-89b9-31e7209da04f	USER_MANAGEMENT.USER.READ	2024-11-26 20:29:45.221619+03
374f22fe-8bbf-4605-8f44-ed567993367d	USER_MANAGEMENT.USER.WRITE	2024-11-26 20:29:45.221619+03
c495c9df-9369-464c-ab58-6ff7ad0276b0	USER_MANAGEMENT.USER.DELETE	2024-11-26 20:29:45.221619+03
1d55cccc-783b-46b4-a048-5baed2e67b3d	USER_MANAGEMENT.USER.BOUND_GROUPS.LIST	2024-11-26 20:29:45.221619+03
8007e647-423a-47d5-bf1c-92d40f30155e	USER_MANAGEMENT.USER.BOUND_GROUPS.BIND	2024-11-26 20:29:45.221619+03
850e70f3-3372-43ab-8f34-eaa5a87e2266	USER_MANAGEMENT.USER.BOUND_GROUPS.UNBIND	2024-11-26 20:29:45.221619+03
4b770635-0130-42ba-9bc6-c08f30a0cd01	USER_MANAGEMENT.AUTHORITY.LIST	2024-11-26 20:29:45.221619+03
a3afd667-7759-4eda-b4e2-4cd06bb600c5	USER_MANAGEMENT.AUTHORITY.BOUND_ROLE.LIST	2024-11-26 20:29:45.221619+03
73b066cc-b7c5-4c9a-aaf6-f5a857ddf18b	USER_MANAGEMENT.AUTHORITY.BOUND_ROLE.BIND	2024-11-26 20:29:45.221619+03
7dc7224b-d8fd-4c9c-b323-7fcb9093df8d	USER_MANAGEMENT.AUTHORITY.BOUND_ROLE.UNBIND	2024-11-26 20:29:45.221619+03
74cd9a25-8e03-4b2f-b311-49534e371576	BPMN.USER.START_ANY_PROCESS	2024-11-26 20:29:49.734534+03
e4ea4cd3-e0bd-4508-b0a4-a3c749cb6647	USER_MANAGEMENT.ORG_UNIT.LIST	2024-11-26 20:29:53.85443+03
0d3560bc-d3bd-4a9b-af08-05afd68df8d9	USER_MANAGEMENT.ORG_UNIT.WRITE	2024-11-26 20:29:54.013261+03
5934a0fd-cff0-4e42-ad9d-e0ff058e37f6	USER_MANAGEMENT.ORG_UNIT.READ	2024-11-26 20:29:54.172509+03
afd95fac-fc49-4435-b133-55eada76138f	USER_MANAGEMENT.ORG_UNIT.DELETE	2024-11-26 20:29:54.32951+03
57fba951-f936-4f0c-ba26-bc52e2ee36b1	USER_MANAGEMENT.SECURITY_CACHE.CLEAR	2024-11-26 20:30:01.033774+03
\.


--
-- TOC entry 4210 (class 0 OID 2446849)
-- Dependencies: 218
-- Data for Name: databasechangelog; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) FROM stdin;
000	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-05-12--01-init-db.xml	2024-11-26 20:29:42.187312	1	EXECUTED	9:2e339d4cd079a06bd273687f5d318af5	sql	create security schema	\N	4.26.0	\N	\N	2642180561
001	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-05-12--01-init-db.xml	2024-11-26 20:29:43.110919	2	EXECUTED	9:6baa10325244cdfbb19e5fc2784de834	createTable tableName=user; addUniqueConstraint constraintName=uni_user_username, tableName=user	create table user	\N	4.26.0	\N	\N	2642180561
002	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-05-12--01-init-db.xml	2024-11-26 20:29:43.303948	3	EXECUTED	9:1f8666e069c3ea439d75388c80f115c9	createTable tableName=group; addForeignKeyConstraint baseTableName=group, constraintName=fk_parent_group, referencedTableName=group; sql	create table group	\N	4.26.0	\N	\N	2642180561
003	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-05-12--01-init-db.xml	2024-11-26 20:29:43.448822	4	EXECUTED	9:f4081161095d0a21ac4083851a3373cb	createTable tableName=role; addUniqueConstraint constraintName=uni_role_name, tableName=role	create table role	\N	4.26.0	\N	\N	2642180561
004	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-05-12--01-init-db.xml	2024-11-26 20:29:43.667507	5	EXECUTED	9:c8c2aa4b8693a079becaccd047853cbf	createTable tableName=user_membership; addUniqueConstraint constraintName=uni_user_membership, tableName=user_membership; addForeignKeyConstraint baseTableName=user_membership, constraintName=fk_user_membership_user, referencedTableName=user; addF...	create table user_membership	\N	4.26.0	\N	\N	2642180561
001	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-05-18--01-groups-as-set-of-roles.xml	2024-11-26 20:29:43.819806	6	EXECUTED	9:24885ae3a51bcd33c9460012aad7797e	dropTable tableName=user_membership; dropTable tableName=group	Drop organization structure tables	\N	4.26.0	\N	\N	2642180561
002	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-05-18--01-groups-as-set-of-roles.xml	2024-11-26 20:29:43.965841	7	EXECUTED	9:52e8903bd3da20ecabf31c44b1a94423	createTable tableName=group; addUniqueConstraint constraintName=uni_group_name, tableName=group	Add new groups	\N	4.26.0	\N	\N	2642180561
003	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-05-18--01-groups-as-set-of-roles.xml	2024-11-26 20:29:44.161919	8	EXECUTED	9:0dd63ff1fa49a401db20ebf9e10d34cf	createTable tableName=group_role; addUniqueConstraint constraintName=uni_group_role, tableName=group_role; addForeignKeyConstraint baseTableName=group_role, constraintName=fk_group_role_group, referencedTableName=group; addForeignKeyConstraint bas...	Add group roles	\N	4.26.0	\N	\N	2642180561
004	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-05-18--01-groups-as-set-of-roles.xml	2024-11-26 20:29:44.34969	9	EXECUTED	9:dd4a05dc55c4dd49ad73158092302768	createTable tableName=user_group; addUniqueConstraint constraintName=uni_user_group, tableName=user_group; addForeignKeyConstraint baseTableName=user_group, constraintName=fk_user_group_user, referencedTableName=user; addForeignKeyConstraint baseT...	Add user groups	\N	4.26.0	\N	\N	2642180561
001	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-05-25--01-add-demo-user.xml	2024-11-26 20:29:44.463495	10	EXECUTED	9:847df2711ae00701a5302ae79ab7a417	insert tableName=user	add demo user	\N	4.26.0	\N	\N	2642180561
001	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--01-add-administrator-user.xml	2024-11-26 20:29:44.589223	11	EXECUTED	9:3fce414856c19b0c869109d866da9b5b	insert tableName=user	add Administrator user (required by jbpm)	\N	4.26.0	\N	\N	2642180561
001	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--02-add-authorities.xml	2024-11-26 20:29:44.974026	12	EXECUTED	9:cd69dab004e63ab3a9d4adaa973ee5ad	createTable tableName=authority; addUniqueConstraint constraintName=uni_authority_name, tableName=authority	create table authority	\N	4.26.0	\N	\N	2642180561
002	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--02-add-authorities.xml	2024-11-26 20:29:45.168967	13	EXECUTED	9:bef9ac8b4eeb30c8194dc454a52adaaf	createTable tableName=role_authority; addUniqueConstraint constraintName=uni_role_authority, tableName=role_authority; addForeignKeyConstraint baseTableName=role_authority, constraintName=fk_role_authority_role, referencedTableName=role; addForeig...	create table role_authority	\N	4.26.0	\N	\N	2642180561
001	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--03-add-default-roles.xml	2024-11-26 20:29:46.264441	14	EXECUTED	9:a37b7b7e07f56a9e935b23511f66a429	insert tableName=authority; insert tableName=authority; insert tableName=authority; insert tableName=authority; insert tableName=authority; insert tableName=authority; insert tableName=authority; insert tableName=authority; insert tableName=author...	add system authorities	\N	4.26.0	\N	\N	2642180561
002	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--03-add-default-roles.xml	2024-11-26 20:29:46.766266	15	EXECUTED	9:4789be4e1bfd00ee4eb67484221dca56	insert tableName=role; insert tableName=role; insert tableName=role; insert tableName=role; insert tableName=role; insert tableName=role	add default roles	\N	4.26.0	\N	\N	2642180561
003	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--03-add-default-roles.xml	2024-11-26 20:29:46.93627	16	EXECUTED	9:831d1772c4c7224c5d5a9388616809f4	sql; sql; sql	bind authorities to BPMN User	\N	4.26.0	\N	\N	2642180561
004	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--03-add-default-roles.xml	2024-11-26 20:29:47.164815	17	EXECUTED	9:06104aba4af6fb4c2f5466b713a29b7e	sql; sql; sql; sql; sql	bind authorities to BPMN Admin	\N	4.26.0	\N	\N	2642180561
005	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--03-add-default-roles.xml	2024-11-26 20:29:47.354235	18	EXECUTED	9:a5b56c61c4a82faa05f79a8ba579012a	sql; sql; sql; sql	bind authorities to Security - Role Admin	\N	4.26.0	\N	\N	2642180561
006	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--03-add-default-roles.xml	2024-11-26 20:29:47.633889	19	EXECUTED	9:1ca01e16cf9e3fbf416fda36a0f5d5f6	sql; sql; sql; sql; sql; sql; sql	bind authorities to Security - Group Admin	\N	4.26.0	\N	\N	2642180561
007	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--03-add-default-roles.xml	2024-11-26 20:29:47.905031	20	EXECUTED	9:74508da97c61c21603a683fc50b50ddf	sql; sql; sql; sql; sql; sql; sql	bind authorities to Security - User Admin	\N	4.26.0	\N	\N	2642180561
008	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--03-add-default-roles.xml	2024-11-26 20:29:48.100024	21	EXECUTED	9:f9f2256afa99e017c96f05b327d8aa53	sql; sql; sql; sql	bind authorities to Security - Authority Admin	\N	4.26.0	\N	\N	2642180561
009	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--03-add-default-roles.xml	2024-11-26 20:29:48.313022	22	EXECUTED	9:822ced6ff41f561d6c412f50ad9bd732	insert tableName=group; insert tableName=group; insert tableName=group	add default groups	\N	4.26.0	\N	\N	2642180561
010	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--03-add-default-roles.xml	2024-11-26 20:29:48.560071	23	EXECUTED	9:2e6d45fac7f042f6b13dbb6572362228	sql; sql; sql; sql; sql; sql	bind roles to default groups	\N	4.26.0	\N	\N	2642180561
002	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-02--04-bind-groups-to-default-users.xml	2024-11-26 20:29:48.730355	24	EXECUTED	9:6f4e8566b81c89bd1447fed51d59b52b	sql; sql; sql	bind groups to demo user	\N	4.26.0	\N	\N	2642180561
001	demin	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-07--05-rename-tables.xml	2024-11-26 20:29:48.869009	25	EXECUTED	9:b3a111cd6cb7a79e3a528a54ee126171	renameTable newTableName=user_account, oldTableName=user; renameColumn newColumnName=user_account_id, oldColumnName=user_id, tableName=user_account	rename table user to user_account	\N	4.26.0	\N	\N	2642180561
002	demin	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-07--05-rename-tables.xml	2024-11-26 20:29:49.04907	26	EXECUTED	9:50a2816028afa1d91a0f34e02c013186	renameTable newTableName=link_user_account_user_group, oldTableName=user_group; renameColumn newColumnName=link_user_account_user_group_id, oldColumnName=user_group_id, tableName=link_user_account_user_group; renameColumn newColumnName=user_accoun...	rename table user_group to link_user_account_user_group	\N	4.26.0	\N	\N	2642180561
003	demin	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-07--05-rename-tables.xml	2024-11-26 20:29:49.18341	27	EXECUTED	9:b7ad37b5c39882ef94287b11f619af1c	renameTable newTableName=user_group, oldTableName=group; renameColumn newColumnName=user_group_id, oldColumnName=group_id, tableName=user_group	rename table group to user_group	\N	4.26.0	\N	\N	2642180561
004	demin	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-07--05-rename-tables.xml	2024-11-26 20:29:49.322695	28	EXECUTED	9:0971b96b5654dbffa5d1b48ac1652ce7	renameTable newTableName=user_role, oldTableName=role; renameColumn newColumnName=user_role_id, oldColumnName=role_id, tableName=user_role	rename table role to user_role	\N	4.26.0	\N	\N	2642180561
005	demin	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-07--05-rename-tables.xml	2024-11-26 20:29:49.529224	29	EXECUTED	9:261ae7a69690f51ecec8c57d7833888d	renameTable newTableName=link_user_group_user_role, oldTableName=group_role; renameColumn newColumnName=link_user_group_user_role_id, oldColumnName=group_role_id, tableName=link_user_group_user_role; renameColumn newColumnName=user_group_id, oldCo...	rename table group_role to link_user_group_user_role	\N	4.26.0	\N	\N	2642180561
006	demin	ru/cg/webbpm/modules/security/api/changelog/v_1.47/2016-06-07--05-rename-tables.xml	2024-11-26 20:29:49.687776	30	EXECUTED	9:4c01dc6591ba878efafaefa19d85c094	renameTable newTableName=link_user_role_authority, oldTableName=role_authority; renameColumn newColumnName=user_role_authority_id, oldColumnName=role_authority_id, tableName=link_user_role_authority; renameColumn newColumnName=user_role_id, oldCol...	rename table role_authority to link_user_role_authority	\N	4.26.0	\N	\N	2642180561
001	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.49/2016-06-20--01-add-authority-to-start-any-process.xml	2024-11-26 20:29:49.803268	31	EXECUTED	9:117a85e196ef25bfb8086a8eeb4d2225	insert tableName=authority	add authority to start any process	\N	4.26.0	\N	\N	2642180561
002	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.49/2016-06-20--01-add-authority-to-start-any-process.xml	2024-11-26 20:29:50.016628	32	EXECUTED	9:82e15269c4baf6a4a9e631bc5f42c6f8	insert tableName=USER_ROLE; sql; sql; sql; sql	add BPMN Superuser USER_ROLE	\N	4.26.0	\N	\N	2642180561
003	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.49/2016-06-20--01-add-authority-to-start-any-process.xml	2024-11-26 20:29:50.282932	33	EXECUTED	9:6c9713e5b70776560452af194f99860e	insert tableName=USER_GROUP; sql; sql; sql; sql; sql; sql	add Demo group	\N	4.26.0	\N	\N	2642180561
004	urmancheev	ru/cg/webbpm/modules/security/api/changelog/v_1.49/2016-06-20--01-add-authority-to-start-any-process.xml	2024-11-26 20:29:50.466655	34	EXECUTED	9:d7337118515dfbb1a701855094fba94e	sql; sql	Move demo user to Demo group	\N	4.26.0	\N	\N	2642180561
001	bikmetov	ru/cg/webbpm/modules/security/api/changelog/v_1.71/2016-11-21--01-split-user_account-table.xml	2024-11-26 20:29:50.58821	35	EXECUTED	9:114623f42eb44aec806deff1d17685fc	createTable tableName=domestic_user	create domestic_user table	\N	4.26.0	\N	\N	2642180561
002	bikmetov	ru/cg/webbpm/modules/security/api/changelog/v_1.71/2016-11-21--01-split-user_account-table.xml	2024-11-26 20:29:50.706936	36	EXECUTED	9:a55edcac3c0b70de7cf491f6826a7abe	sql	migrate authentication data from user_account to domestic_user table	\N	4.26.0	\N	\N	2642180561
003	bikmetov	ru/cg/webbpm/modules/security/api/changelog/v_1.71/2016-11-21--01-split-user_account-table.xml	2024-11-26 20:29:50.887984	37	EXECUTED	9:35a8aca61fd31c38cec799079116128e	dropColumn columnName=password, tableName=user_account; dropColumn columnName=blocked, tableName=user_account; dropColumn columnName=password_expires, tableName=user_account; dropColumn columnName=password_updated, tableName=user_account	drop deprecated columns	\N	4.26.0	\N	\N	2642180561
001	bikmetov	ru/cg/webbpm/modules/security/api/changelog/v_1.71/2016-11-22--01-create-esia_user-table.xml	2024-11-26 20:29:51.007696	38	EXECUTED	9:dac5c2e543f5808235331da4af681a8e	createTable tableName=esia_user	Create esia user table	\N	4.26.0	\N	\N	2642180561
002	bikmetov	ru/cg/webbpm/modules/security/api/changelog/v_1.71/2016-11-22--01-create-esia_user-table.xml	2024-11-26 20:29:51.136469	39	EXECUTED	9:b7c928cb74062a3a2292f893cb96ba5c	addForeignKeyConstraint baseTableName=esia_user, constraintName=fk_esia_user1, referencedTableName=user_account	Add link to user_account table	\N	4.26.0	\N	\N	2642180561
001	kochetkov	ru/cg/webbpm/modules/security/api/changelog/v_2.10/2017-08-24--01-add-user-removed-flag.xml	2024-11-26 20:29:51.25777	40	EXECUTED	9:2734e124f6517cf878e4fad30ba16ea9	addColumn tableName=user_account	add user removed flag	\N	4.26.0	\N	\N	2642180561
001	krylov	ru/cg/webbpm/modules/security/api/changelog/v_2.14/2017-10-12--01-orgunits.xml	2024-11-26 20:29:51.37599	41	EXECUTED	9:ffc37e0d4fb3cced842a3c93df907110	createTable tableName=org_unit	add org_unit table	\N	4.26.0	\N	\N	2642180561
002	krylov	ru/cg/webbpm/modules/security/api/changelog/v_2.14/2017-10-12--01-orgunits.xml	2024-11-26 20:29:51.488433	42	EXECUTED	9:0a2d5759d46697f7e7193a9ac27ac708	addColumn tableName=user_account	add org_unit id to users	\N	4.26.0	\N	\N	2642180561
003	krylov	ru/cg/webbpm/modules/security/api/changelog/v_2.14/2017-10-12--01-orgunits.xml	2024-11-26 20:29:51.603694	43	EXECUTED	9:777d24a2eb0a3b9743c7b0741dea1ed9	addForeignKeyConstraint baseTableName=org_unit, constraintName=fk_org_unit_parent_id, referencedTableName=org_unit	add self reference	\N	4.26.0	\N	\N	2642180561
004	krylov	ru/cg/webbpm/modules/security/api/changelog/v_2.14/2017-10-12--01-orgunits.xml	2024-11-26 20:29:51.717988	44	EXECUTED	9:eb65786e6009abd549a207e4e0660fdb	addForeignKeyConstraint baseTableName=user_account, constraintName=fk_user_org_unit_id, referencedTableName=org_unit	add org_unit id fk to users	\N	4.26.0	\N	\N	2642180561
001	krylov	ru/cg/webbpm/modules/security/api/changelog/v_2.14/2017-10-20--01-orgunit-notnull.xml	2024-11-26 20:29:51.835979	45	EXECUTED	9:67a2ed8126625e50e25f3751935d0b64	insert tableName=org_unit	add default organization	\N	4.26.0	\N	\N	2642180561
002	krylov	ru/cg/webbpm/modules/security/api/changelog/v_2.14/2017-10-20--01-orgunit-notnull.xml	2024-11-26 20:29:51.954675	46	EXECUTED	9:b91cdc312baee2fdcb89e4935fb9c5b4	update tableName=user_account	link all users to default organization	\N	4.26.0	\N	\N	2642180561
003	krylov	ru/cg/webbpm/modules/security/api/changelog/v_2.14/2017-10-20--01-orgunit-notnull.xml	2024-11-26 20:29:52.068078	47	EXECUTED	9:00771bd5d31472dc9283312def21c569	addNotNullConstraint columnName=org_unit_id, tableName=user_account	make org_unit_id not null	\N	4.26.0	\N	\N	2642180561
001	kochetkov	ru/cg/webbpm/modules/security/api/changelog/v_2.14/2017-10-18--01-add-access-level-for-groups.xml	2024-11-26 20:29:52.324181	48	EXECUTED	9:d76f00132494ac2f3f078883892de964	createTable tableName=access_level; insert tableName=access_level; insert tableName=access_level; addColumn tableName=user_group; update tableName=user_group; update tableName=user_group; addForeignKeyConstraint baseTableName=user_group, constrain...	add access level for groups	\N	4.26.0	\N	\N	2642180561
0001	krylov	ru/cg/webbpm/modules/security/api/changelog/v_2.16/2017-11-15--01-orgunit-code-notnull.xml	2024-11-26 20:29:52.448458	49	EXECUTED	9:6e30e1e2f4ee4c26050f20f30e022c40	update tableName=org_unit	Set code for default org	\N	4.26.0	\N	\N	2642180561
0002	krylov	ru/cg/webbpm/modules/security/api/changelog/v_2.16/2017-11-15--01-orgunit-code-notnull.xml	2024-11-26 20:29:52.570276	50	EXECUTED	9:eca5ea325488ff476bfa77e994f14329	addNotNullConstraint columnName=code, tableName=org_unit	Add NOT NULL to org_unit.code	\N	4.26.0	\N	\N	2642180561
001	krylov	ru/cg/webbpm/modules/security/api/changelog/v_2.23/2017-12-15--01-orgunit-removed.xml	2024-11-26 20:29:52.68312	51	EXECUTED	9:fada6015aab2c8b550db30b18ad174d5	addColumn tableName=org_unit		\N	4.26.0	\N	\N	2642180561
001	krylov	ru/cg/webbpm/modules/security/api/changelog/v_2.23/2017-12-21--01-orgunit-unique.xml	2024-11-26 20:29:52.796217	52	EXECUTED	9:56ac4e5499fc3f4f615ba0f44737297b	addUniqueConstraint tableName=org_unit		\N	4.26.0	\N	\N	2642180561
001	krylov	ru/cg/webbpm/modules/security/api/changelog/v_2.28/2018-01-26--01-orgunit-name-long.xml	2024-11-26 20:29:52.911377	53	EXECUTED	9:86ba1733f691a0b9afc171010fb7a4d4	modifyDataType columnName=name, tableName=org_unit		\N	4.26.0	\N	\N	2642180561
001	obuhov	ru/cg/webbpm/modules/security/api/changelog/v_2.36/2018-04-03--01-add-bpmn-superuser-group.xml	2024-11-26 20:29:53.097504	54	EXECUTED	9:5938c4173219c7c56dbbbf3678f01bb0	insert tableName=user_group; sql	add BPMN Superuser group	\N	4.26.0	\N	\N	2642180561
001	obuhov	ru/cg/webbpm/modules/security/api/changelog/v_2.36/2018-04-03--02-map-demo-user-groups.xml	2024-11-26 20:29:53.270621	55	EXECUTED	9:4ee9796493cd60011443827c0aec5a9d	sql	Move demo user from Demo group	\N	4.26.0	\N	\N	2642180561
002	obuhov	ru/cg/webbpm/modules/security/api/changelog/v_2.36/2018-04-03--02-map-demo-user-groups.xml	2024-11-26 20:29:53.433427	56	EXECUTED	9:293ffbe0ed7d61f2ee4890eec12a1c83	sql	Assign 'BPMN Admin' group to 'demo@example.com' user	\N	4.26.0	\N	\N	2642180561
003	obuhov	ru/cg/webbpm/modules/security/api/changelog/v_2.36/2018-04-03--02-map-demo-user-groups.xml	2024-11-26 20:29:53.594731	57	EXECUTED	9:ec3f98ef4547b285082cb97520bb7769	sql	Assign 'Security Admin' group to 'demo@example.com' user	\N	4.26.0	\N	\N	2642180561
004	obuhov	ru/cg/webbpm/modules/security/api/changelog/v_2.36/2018-04-03--02-map-demo-user-groups.xml	2024-11-26 20:29:53.760557	58	EXECUTED	9:b0903c151a91cf469b8efbcd35589255	sql	Assign 'BPMN Superuser' group to 'demo@example.com' user	\N	4.26.0	\N	\N	2642180561
001	r.gilfanov	ru/cg/webbpm/modules/security/api/changelog/v_2.507/2018-11-13--01-org-unit-authorities.xml	2024-11-26 20:29:53.923998	59	EXECUTED	9:856cdfc715038682e66dcf3874527905	insert tableName=authority	Add 'USER_MANAGEMENT.ORG_UNIT.LIST' authority	\N	4.26.0	\N	\N	2642180561
002	r.gilfanov	ru/cg/webbpm/modules/security/api/changelog/v_2.507/2018-11-13--01-org-unit-authorities.xml	2024-11-26 20:29:54.081631	60	EXECUTED	9:4c7e421d0cbe6ce04d9a807e44fa6f61	insert tableName=authority	Add 'USER_MANAGEMENT.ORG_UNIT.WRITE' authority	\N	4.26.0	\N	\N	2642180561
003	r.gilfanov	ru/cg/webbpm/modules/security/api/changelog/v_2.507/2018-11-13--01-org-unit-authorities.xml	2024-11-26 20:29:54.242068	61	EXECUTED	9:dfbe0dc297f0531c0e4eafb520136dbc	insert tableName=authority	Add 'USER_MANAGEMENT.ORG_UNIT.READ' authority	\N	4.26.0	\N	\N	2642180561
004	r.gilfanov	ru/cg/webbpm/modules/security/api/changelog/v_2.507/2018-11-13--01-org-unit-authorities.xml	2024-11-26 20:29:54.396223	62	EXECUTED	9:d4f274735a098ebaef655831794ad1d2	insert tableName=authority	Add 'USER_MANAGEMENT.ORG_UNIT.DELETE' authority	\N	4.26.0	\N	\N	2642180561
001	r.gilfanov	ru/cg/webbpm/modules/security/api/changelog/v_2.507/2018-11-13--02-add-org-unit-admin-role.xml	2024-11-26 20:29:54.556816	63	EXECUTED	9:5f8adb37020f0c274cbe8e01e1b435af	insert tableName=user_role	Add 'Security - Org Unit Admin' role	\N	4.26.0	\N	\N	2642180561
002	r.gilfanov	ru/cg/webbpm/modules/security/api/changelog/v_2.507/2018-11-13--02-add-org-unit-admin-role.xml	2024-11-26 20:29:55.036581	64	EXECUTED	9:785b92397bd66f7afe23330dc8ea1347	sql	Link 'Security - Org Unit Admin' role with org_unit's authorities	\N	4.26.0	\N	\N	2642180561
001	r.gilfanov	ru/cg/webbpm/modules/security/api/changelog/v_2.507/2018-11-13--03-link-org-unit-role-with-group.xml	2024-11-26 20:29:55.200516	65	EXECUTED	9:2f32e7296908a837b9c6003ec748d5f0	sql	Link 'Security - Org Unit Admin' role with 'Security Admin' group	\N	4.26.0	\N	\N	2642180561
001	r.gilfanov	ru/cg/webbpm/modules/security/api/changelog/v_2.507/2018-11-13--04-link-security-admin-group-with-demo-user.xml	2024-11-26 20:29:55.367192	66	MARK_RAN	9:d68de67b3afb347392e8b114399da60e	sql	Link 'Security Admin' group with demo user	\N	4.26.0	\N	\N	2642180561
001	e. umutbaev	ru/cg/webbpm/modules/security/api/changelog/v_2.66/2018-11-30--01-add-access-level-999.xml	2024-11-26 20:29:55.815807	67	EXECUTED	9:e9436888263118a008282ea09af912a0	insert tableName=access_level	add access level '999'	\N	4.26.0	\N	\N	2642180561
001	e. umutbaev	ru/cg/webbpm/modules/security/api/changelog/v_2.66/2018-11-30--02-add-superadmin-group.xml	2024-11-26 20:29:56.639218	68	EXECUTED	9:8b4cc35fa7853f72227c00251e3423f1	insert tableName=user_group	add 'Super Admin' group	\N	4.26.0	\N	\N	2642180561
001	e. umutbaev	ru/cg/webbpm/modules/security/api/changelog/v_2.66/2018-11-30--03-map-demo-superadmin-group.xml	2024-11-26 20:29:56.800801	69	EXECUTED	9:a696763c22e2cb0e70e7a719b376f500	insert tableName=link_user_account_user_group	Assign 'Super Admin' group to 'demo@example.com' user	\N	4.26.0	\N	\N	2642180561
001	e. umutbaev	ru/cg/webbpm/modules/security/api/changelog/v_2.66/2018-11-30--04-access-level-id-notnull.xml	2024-11-26 20:29:56.93402	70	EXECUTED	9:8557b65258fa5b3a9b8b5fdbac63c3ab	addNotNullConstraint columnName=access_level_id, tableName=user_group	make access_level_id not null. if null - set default_access_level	\N	4.26.0	\N	\N	2642180561
001	ermolaev	ru/cg/webbpm/modules/security/api/changelog/v_2.72/2019-02-01--01-create-table-for-refresh-token.xml	2024-11-26 20:29:57.082208	71	EXECUTED	9:508074b20a7b4d7fe008772d8f9790c3	createTable tableName=user_account_refresh_token; addForeignKeyConstraint baseTableName=user_account_refresh_token, constraintName=fk_user_account_refresh_token, referencedTableName=user_account	add user account refresh tokens	\N	4.26.0	\N	\N	2642180561
002	ermolaev	ru/cg/webbpm/modules/security/api/changelog/v_2.72/2019-02-01--01-create-table-for-refresh-token.xml	2024-11-26 20:29:57.198695	72	EXECUTED	9:530a886925d17805a94411bbe7ff592d	modifyDataType columnName=refresh_tokens, tableName=user_account_refresh_token		\N	4.26.0	\N	\N	2642180561
001	obuhov	ru/cg/webbpm/modules/security/api/changelog/v_2.86/2019-04-17--01-rename_user_removed_to_locked.xml	2024-11-26 20:29:57.364598	73	EXECUTED	9:f25127bf5a046775275615a0d432dd94	renameColumn newColumnName=locked, oldColumnName=removed, tableName=user_account	rename column removed to locked	\N	4.26.0	\N	\N	2642180561
001	ermolaev.a	ru/cg/webbpm/modules/security/api/changelog/v_2.87/2019-05-07--01-SUPPORT-3108-drop-locked-from-domestic.xml	2024-11-26 20:29:57.532015	74	EXECUTED	9:488a6250ebafe046464a98c3cc3a721a	dropColumn columnName=locked, tableName=domestic_user	drop column locked in domestic_user	\N	4.26.0	\N	\N	2642180561
001	ermolaev.a	ru/cg/webbpm/modules/security/api/changelog/v_2.88/2019-05-07--01-SUPPORT-3158_modify_user_refresh_token.xml	2024-11-26 20:29:57.715298	75	EXECUTED	9:c27504c8960a82dbaa7f3d51c2fa7f05	dropTable tableName=user_account_refresh_token	drop table user_account_refresh_token	\N	4.26.0	\N	\N	2642180561
002	ermolaev.a	ru/cg/webbpm/modules/security/api/changelog/v_2.88/2019-05-07--01-SUPPORT-3158_modify_user_refresh_token.xml	2024-11-26 20:29:58.084571	76	EXECUTED	9:7c542a1bf11770c3dcf79a607113c49a	createTable tableName=user_account_refresh_token; addForeignKeyConstraint baseTableName=user_account_refresh_token, constraintName=fk_user_account_refresh_token, referencedTableName=user_account	create table user_account_refresh_token	\N	4.26.0	\N	\N	2642180561
001	ermolaev.a	ru/cg/webbpm/modules/security/api/changelog/v_3.6/2019-08-22--01-WEBBPMNEXT-6418_create_index_for_refresh_token.xml	2024-11-26 20:29:58.263316	77	EXECUTED	9:ff529c266cfad603e4c34f6b4221fe23	createIndex indexName=idx_refresh_token_user_account_id, tableName=user_account_refresh_token	add index for refresh token	\N	4.26.0	\N	\N	2642180561
001	zamaliev	ru/cg/webbpm/modules/security/api/changelog/v_3.34/2020-02-27--01-WEBBPMNEXT-6862_credentials_tables.xml	2024-11-26 20:29:58.378105	78	EXECUTED	9:396f0e01442b4448ec8a0a420ce3818b	renameTable newTableName=simple_credentials, oldTableName=domestic_user	rename table domestic_user to simple_credentials	\N	4.26.0	\N	\N	2642180561
002	zamaliev	ru/cg/webbpm/modules/security/api/changelog/v_3.34/2020-02-27--01-WEBBPMNEXT-6862_credentials_tables.xml	2024-11-26 20:29:58.501174	79	EXECUTED	9:5a45dd8de2ce212d32aaada382728080	createTable tableName=login_credentials		\N	4.26.0	\N	\N	2642180561
001	zamaliev	ru/cg/webbpm/modules/security/api/changelog/v_3.34/2020-02-27--02-WEBBPMNEXT-6862_move_column.xml	2024-11-26 20:29:58.642347	80	EXECUTED	9:74aec95f2ebd64bb29bfca789e2c1686	addColumn tableName=simple_credentials	add column username to table simple_credentials	\N	4.26.0	\N	\N	2642180561
002	zamaliev	ru/cg/webbpm/modules/security/api/changelog/v_3.34/2020-02-27--02-WEBBPMNEXT-6862_move_column.xml	2024-11-26 20:29:58.762915	81	EXECUTED	9:06ec1f95efaabfc049ba1631de7c7495	sql	move data of column username from user_account to simple_credentials	\N	4.26.0	\N	\N	2642180561
004	zamaliev	ru/cg/webbpm/modules/security/api/changelog/v_3.34/2020-02-27--02-WEBBPMNEXT-6862_move_column.xml	2024-11-26 20:29:58.878289	82	EXECUTED	9:3fff8711b04f1f18c600ae9cbf256010	sql	move data of column username from user_account to login_credentials	\N	4.26.0	\N	\N	2642180561
005	zamaliev	ru/cg/webbpm/modules/security/api/changelog/v_3.34/2020-02-27--02-WEBBPMNEXT-6862_move_column.xml	2024-11-26 20:29:58.998474	83	EXECUTED	9:c27eaaf77cb37556306c9bd8ad472644	dropColumn columnName=username, tableName=user_account	drop column username from user_account	\N	4.26.0	\N	\N	2642180561
006	zamaliev	ru/cg/webbpm/modules/security/api/changelog/v_3.34/2020-02-27--02-WEBBPMNEXT-6862_move_column.xml	2024-11-26 20:29:59.114178	84	EXECUTED	9:57b83151de4c5726658bba4534b875e7	addNotNullConstraint columnName=username, tableName=simple_credentials	add not null constraint	\N	4.26.0	\N	\N	2642180561
001	zamaliev	ru/cg/webbpm/modules/security/api/changelog/v_3.34/2020-02-27--03-WEBBPMNEXT-6862_grant_select.xml	2024-11-26 20:29:59.249503	85	EXECUTED	9:61ab7a17d19422c55a51103ebc309cd5	sql	grant select on security tables	\N	4.26.0	\N	\N	2642180561
002	zamaliev	ru/cg/webbpm/modules/security/api/changelog/v_3.34/2020-02-27--03-WEBBPMNEXT-6862_grant_select.xml	2024-11-26 20:29:59.374458	86	EXECUTED	9:e30ab22c1531e0108286330bf2b8e871	sql	remove $user from search_path	\N	4.26.0	\N	\N	2642180561
003	zamaliev	ru/cg/webbpm/modules/security/api/changelog/v_3.34/2020-02-27--03-WEBBPMNEXT-6862_grant_select.xml	2024-11-26 20:29:59.492464	87	EXECUTED	9:7bb9262518dab14725afbc18952afb90	sql	grant select and references on security tables	\N	4.26.0	\N	\N	2642180561
001	borisov	ru/cg/webbpm/modules/security/api/changelog/v_3.74/2020-12-30--01-WEBBPMNEXT-7590_create_constraint.xml	2024-11-26 20:29:59.748235	88	EXECUTED	9:eccaa9ec0ccf74c681f58030762c0b32	addUniqueConstraint constraintName=login_credentials_username, tableName=login_credentials	add unique constraint for login_credentials username	\N	4.26.0	\N	\N	2642180561
001	m.popov	ru/cg/webbpm/modules/security/api/changelog/v_3.92/2021-06-03--01-WEBBPMNEXT-7127_create_column_username_user_account.xml	2024-11-26 20:29:59.870564	89	EXECUTED	9:fc781b19f2ea627c49ffa32ce32d3081	addColumn tableName=user_account	add column username to table user_account	\N	4.26.0	\N	\N	2642180561
002	m.popov	ru/cg/webbpm/modules/security/api/changelog/v_3.92/2021-06-03--01-WEBBPMNEXT-7127_create_column_username_user_account.xml	2024-11-26 20:30:00.211523	90	EXECUTED	9:9409683b6e4e54a75e5ce8fee511ae06	sql	move data of column username from simple_credentials to user_account	\N	4.26.0	\N	\N	2642180561
004	m.popov	ru/cg/webbpm/modules/security/api/changelog/v_3.92/2021-06-03--01-WEBBPMNEXT-7127_create_column_username_user_account.xml	2024-11-26 20:30:00.333467	91	EXECUTED	9:2936b49880262fb4c6bc3baa27a87698	sql	move data of column username from login_credentials to user_account	\N	4.26.0	\N	\N	2642180561
006	m.popov	ru/cg/webbpm/modules/security/api/changelog/v_3.92/2021-06-03--01-WEBBPMNEXT-7127_create_column_username_user_account.xml	2024-11-26 20:30:00.539986	92	EXECUTED	9:7421358099bf32fb52945541e649d3cc	addNotNullConstraint columnName=username, tableName=user_account	add not null constraint for user_account username	\N	4.26.0	\N	\N	2642180561
007	m.popov	ru/cg/webbpm/modules/security/api/changelog/v_3.92/2021-06-03--01-WEBBPMNEXT-7127_create_column_username_user_account.xml	2024-11-26 20:30:00.757068	93	EXECUTED	9:dea6eddc29fff6faa771bc7d8c9189e1	addUniqueConstraint constraintName=user_account_username_unique, tableName=user_account	add unique constraint for user_account username	\N	4.26.0	\N	\N	2642180561
001	m.popov	ru/cg/webbpm/modules/security/api/changelog/v_3.92/2021-06-03--02-WEBBPMNEXT-7127_drop_column_username_simple_credential.xml	2024-11-26 20:30:00.87849	94	EXECUTED	9:b63771b1dfeca98512be4444aa00f17e	dropColumn columnName=username, tableName=simple_credentials	drop column username from simple_credentials	\N	4.26.0	\N	\N	2642180561
001	m.popov	ru/cg/webbpm/modules/security/api/changelog/v_3.92/2021-06-03--03-WEBBPMNEXT-7127_drop_table_login_credential.xml	2024-11-26 20:30:00.990701	95	EXECUTED	9:323e9b2660bc25e97ca6d761d0f394ad	dropTable tableName=login_credentials	drop table login_credentials	\N	4.26.0	\N	\N	2642180561
001	kochetkov	ru/cg/webbpm/modules/security/api/changelog/v_3.109/2022-01-24--01-SUPPORT-6410_add_security_cache.xml	2024-11-26 20:30:01.126512	96	EXECUTED	9:9a7f8fb935736b526fa21708720b2e68	insert tableName=authority; sql	add clear security cache authority	\N	4.26.0	\N	\N	2642180561
001	gulnaz	ru/cg/webbpm/modules/security/api/changelog/v_3.121/2022-06-24--01-MR-140_add_phone_and_email_confirmed_columns_into_user_account.xml	2024-11-26 20:30:01.24308	97	EXECUTED	9:d29ce378f7b2550e481f157d52474a99	addColumn tableName=user_account	add phone column into user_account table	\N	4.26.0	\N	\N	2642180561
002	gulnaz	ru/cg/webbpm/modules/security/api/changelog/v_3.121/2022-06-24--01-MR-140_add_phone_and_email_confirmed_columns_into_user_account.xml	2024-11-26 20:30:01.362171	98	EXECUTED	9:4f8a72f8b30b8384ce06ba4f5912af19	addColumn tableName=user_account	add email_confirmed column into user_account table	\N	4.26.0	\N	\N	2642180561
001	gulnaz	ru/cg/webbpm/modules/security/api/changelog/v_3.121/2022-06-24--02-MR-140_add_user_account_verification_table.xml	2024-11-26 20:30:01.497787	99	EXECUTED	9:7d4a7ce77dae5b6201c3a1ec98ec2862	createTable tableName=user_account_verification; addForeignKeyConstraint baseTableName=user_account_verification, constraintName=fk_user_account_user_account_verification, referencedTableName=user_account	add user_account_verification table	\N	4.26.0	\N	\N	2642180561
001	Alex Save	ru/cg/webbpm/modules/security/api/changelog/v_3.128/2022-10-11--01-WEBBPMNEXT-8298_add_source_column_into_user_account.xml	2024-11-26 20:30:01.631886	100	EXECUTED	9:567a726828b20cfb5c9566a11b6a370c	addColumn tableName=user_account; sql	add source column into user_account table	\N	4.26.0	\N	\N	2642180561
001	Alex Save	ru/cg/webbpm/modules/security/api/changelog/v_3.131/2022-08-02--01-SUPPORT-7533_multidomen_ldap_auth.xml	2024-11-26 20:30:01.784458	101	EXECUTED	9:1801afc8cd8223f9313b596e34533aa5	addColumn tableName=user_account	add source column into user_account table	\N	4.26.0	\N	\N	2642180561
001	Khabibullin	ru/cg/webbpm/modules/security/api/changelog/v_3.142.3/2023-05-03--01-WEBBPMNEXT-8635_add_created_column_to_link_user_account_user_group.xml	2024-11-26 20:30:02.013082	102	EXECUTED	9:1d920456b4dbeb7725dbe9e593f847fe	addColumn tableName=link_user_account_user_group; addDefaultValue columnName=created, tableName=link_user_account_user_group; addColumn tableName=link_user_group_user_role; addDefaultValue columnName=created, tableName=link_user_group_user_role; a...	add created column into link_user_account_user_group, link_user_group_user_role,\n      link_user_role_authority tables	\N	4.26.0	\N	\N	2642180561
\.


--
-- TOC entry 4211 (class 0 OID 2446854)
-- Dependencies: 219
-- Data for Name: databasechangeloglock; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.databasechangeloglock (id, locked, lockgranted, lockedby) FROM stdin;
1	f	\N	\N
\.


--
-- TOC entry 4220 (class 0 OID 2447005)
-- Dependencies: 228
-- Data for Name: esia_user; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.esia_user (esia_user_id, user_account_id, person_contact_id) FROM stdin;
\.


--
-- TOC entry 4216 (class 0 OID 2446948)
-- Dependencies: 224
-- Data for Name: link_user_account_user_group; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.link_user_account_user_group (link_user_account_user_group_id, user_account_id, user_group_id, created) FROM stdin;
89c28e0e-42c0-4590-bf87-12bd34fef4f8	008af907-0fa2-4c14-b163-6e96f2d386ef	ddfdc772-7aee-492f-be7d-7e95ea2f45b3	\N
019008aa-379c-4d4d-8ca4-596a20b14283	008af907-0fa2-4c14-b163-6e96f2d386ef	84c5c1e2-081e-45e1-a874-d6bb232e57ad	\N
523dd190-d11c-4192-9fbf-f2c86ab8f032	008af907-0fa2-4c14-b163-6e96f2d386ef	273d8bbd-0e82-4064-a548-850e9aa61756	\N
824f1c63-7948-4ed8-85d1-c58159621bf8	008af907-0fa2-4c14-b163-6e96f2d386ef	eaf300bc-a4cf-47c1-b5cb-d2b8abef02e5	\N
05b7e162-4e0f-4aeb-95dd-331d18416f67	4caa6156-3cfb-4ea5-aa42-d3ff6f10ff8c	acf292b2-9b46-4bf2-9254-39696d26f02b	2024-10-17 10:50:04.067612
d471f557-2816-4cab-874e-ff00fc93a3ed	4caa6156-3cfb-4ea5-aa42-d3ff6f10ff8c	0c61996f-c1db-483e-8456-5a5a9dc6dcdd	2024-10-17 10:50:04.067612
7357e22b-078c-473f-8aae-17c6b8fb8991	67ed8a30-2596-4dad-a782-756c7dfc4c72	6428cb6d-2949-4570-85b5-4b81e33b19ff	2024-10-17 10:51:05.996629
bb585230-93f9-4af5-8b7a-19a41303bce8	67ed8a30-2596-4dad-a782-756c7dfc4c72	25d720ff-fa5e-41f2-bbe9-0db90187b0f4	2024-10-17 12:42:38.639522
d5db495e-a051-4ed2-ba9e-1a6e7bba79d2	408ff49a-4004-43b5-b040-3ca4ae363d03	0c61996f-c1db-483e-8456-5a5a9dc6dcdd	2024-10-17 12:49:45.512511
092dea94-44a9-4872-9ee0-350c74fa449b	408ff49a-4004-43b5-b040-3ca4ae363d03	00fe3742-dbb3-4639-aabd-3a10050ecd9e	2024-10-17 12:50:58.22643
7c81cde4-6f72-42e0-be92-c4bb79cdd4e9	62a03ff4-4b62-435c-a2ff-f7dbe7df2a6d	6428cb6d-2949-4570-85b5-4b81e33b19ff	2024-10-18 16:18:20.872589
f3d7f57e-58ea-4509-8d58-fb0fd4600ecc	62a03ff4-4b62-435c-a2ff-f7dbe7df2a6d	25d720ff-fa5e-41f2-bbe9-0db90187b0f4	2024-10-18 16:18:20.872589
\.


--
-- TOC entry 4215 (class 0 OID 2446929)
-- Dependencies: 223
-- Data for Name: link_user_group_user_role; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.link_user_group_user_role (link_user_group_user_role_id, user_group_id, user_role_id, created) FROM stdin;
7e530a80-5034-4171-9dd1-2585e564d26c	62cd890b-99f7-47a8-be60-e330186b17a0	767ae8cf-af01-44d4-86ef-fcb143373407	\N
e7acbe14-bb8c-45a8-904d-3897b0c78e41	ddfdc772-7aee-492f-be7d-7e95ea2f45b3	aa14ba1d-0b61-4e33-8474-7c2d98944b12	\N
7b916cb1-d331-4b3f-ab9b-0ce10d9a34fa	84c5c1e2-081e-45e1-a874-d6bb232e57ad	72eb6a8e-af55-4f16-b69a-49f7b8a74f8d	\N
4f912e82-b325-45b2-a611-e16f699d7366	84c5c1e2-081e-45e1-a874-d6bb232e57ad	1408a814-0729-41ae-b645-6150fa79071f	\N
ddaaca35-0a87-4ea5-97e7-056a858c4efe	84c5c1e2-081e-45e1-a874-d6bb232e57ad	6d2a6110-0d6b-4ae6-a143-c73fde6d65a2	\N
e80cddbe-7650-4415-8765-e13ea1f43f04	84c5c1e2-081e-45e1-a874-d6bb232e57ad	b896f8c9-29cb-4384-992e-44c7ad0ec1d5	\N
f888304f-2e17-4b33-bebf-116deec9a0ef	22ee608b-dd9d-4633-906d-7c4efca231a0	2569ba58-1f8f-43ea-8b2c-0d373cf501fe	\N
d26c5536-efe4-41a5-9ee6-2baf33ec870a	22ee608b-dd9d-4633-906d-7c4efca231a0	aa14ba1d-0b61-4e33-8474-7c2d98944b12	\N
314c26d6-28a2-4e29-bcb9-4e92c9e26d0e	22ee608b-dd9d-4633-906d-7c4efca231a0	72eb6a8e-af55-4f16-b69a-49f7b8a74f8d	\N
206e5862-4a42-4295-be72-9abcfbac4fcb	22ee608b-dd9d-4633-906d-7c4efca231a0	1408a814-0729-41ae-b645-6150fa79071f	\N
015398e4-b320-42ff-9b9d-ffed9aa79d27	22ee608b-dd9d-4633-906d-7c4efca231a0	6d2a6110-0d6b-4ae6-a143-c73fde6d65a2	\N
3f5c2d1d-a2df-4852-8b85-4ef7bfe934fb	22ee608b-dd9d-4633-906d-7c4efca231a0	b896f8c9-29cb-4384-992e-44c7ad0ec1d5	\N
b2140940-0cf2-48d1-9212-d4dda9ef9dbe	273d8bbd-0e82-4064-a548-850e9aa61756	2569ba58-1f8f-43ea-8b2c-0d373cf501fe	\N
2f86a80e-b9a3-4f9b-8bb9-4bff24ebf111	84c5c1e2-081e-45e1-a874-d6bb232e57ad	32f9413b-619a-4e4b-85f9-4c4699267b37	\N
bac491b1-ac1a-45eb-b2ae-e30b3db3ba65	22ee608b-dd9d-4633-906d-7c4efca231a0	68a81927-259d-4e2a-84d7-c565a9d0f943	2024-10-09 19:54:18.511239
e53640e7-4a56-4d68-8061-b4e3d4ec33c2	22ee608b-dd9d-4633-906d-7c4efca231a0	17c97647-f53c-400f-a700-ad349eeee0c3	2024-10-09 19:54:18.511239
69639956-38ff-4fc7-aee5-a6785fee3eae	22ee608b-dd9d-4633-906d-7c4efca231a0	726dc966-6832-4f5c-b867-2797259d5104	2024-10-09 19:54:18.511239
6b5dfc30-7a04-4d89-874d-02a549f51182	22ee608b-dd9d-4633-906d-7c4efca231a0	cc1ac346-71bf-4fa7-9300-78730a1bed08	2024-10-09 19:54:18.511239
91e65fc5-1691-4df3-99a7-2e7f93d779f8	22ee608b-dd9d-4633-906d-7c4efca231a0	65b50a78-4f68-4bd9-9836-4fb3e2fb2c6a	2024-10-09 19:54:18.511239
94d28392-6914-45ce-a090-690daa404f9d	22ee608b-dd9d-4633-906d-7c4efca231a0	767ae8cf-af01-44d4-86ef-fcb143373407	2024-10-09 19:54:18.511239
74611b2a-3641-4baf-899c-f69b46e56978	22ee608b-dd9d-4633-906d-7c4efca231a0	32f9413b-619a-4e4b-85f9-4c4699267b37	2024-10-09 19:54:18.511239
2f23c82b-3017-44ee-9e7f-b7b3efc88779	25d720ff-fa5e-41f2-bbe9-0db90187b0f4	17c97647-f53c-400f-a700-ad349eeee0c3	2024-10-09 20:47:31.439075
bc02b290-064c-4a86-9dd9-5611b0295045	25d720ff-fa5e-41f2-bbe9-0db90187b0f4	767ae8cf-af01-44d4-86ef-fcb143373407	2024-10-09 20:47:31.439075
10059011-1f42-4580-b92b-5d78c61d9f61	acf292b2-9b46-4bf2-9254-39696d26f02b	726dc966-6832-4f5c-b867-2797259d5104	2024-10-09 20:49:38.630003
c3374413-f190-48dc-b194-e6a1ae4355ae	acf292b2-9b46-4bf2-9254-39696d26f02b	767ae8cf-af01-44d4-86ef-fcb143373407	2024-10-09 20:49:38.630003
189018bf-9301-4818-8821-545328de6012	00fe3742-dbb3-4639-aabd-3a10050ecd9e	68a81927-259d-4e2a-84d7-c565a9d0f943	2024-10-09 20:51:03.650021
ce69bef0-5324-4c16-b151-cfc7b473ad7c	00fe3742-dbb3-4639-aabd-3a10050ecd9e	767ae8cf-af01-44d4-86ef-fcb143373407	2024-10-09 20:51:03.650021
aedec67b-7bac-4b96-8682-a6e2a1865b62	0c61996f-c1db-483e-8456-5a5a9dc6dcdd	30c92f56-439c-463d-829c-93bcbf6b64d1	2024-10-17 09:15:30.396222
a155dcc0-1c7a-440e-ae69-384da3628824	6428cb6d-2949-4570-85b5-4b81e33b19ff	720d8a2b-1b30-4002-9a44-8e531c86460c	2024-10-17 09:15:41.72115
\.


--
-- TOC entry 4218 (class 0 OID 2446975)
-- Dependencies: 226
-- Data for Name: link_user_role_authority; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.link_user_role_authority (user_role_authority_id, user_role_id, authority_id, created) FROM stdin;
0d508a53-d429-4fc1-a929-d6dff3476e21	767ae8cf-af01-44d4-86ef-fcb143373407	4406c5fa-e6bb-468c-a2f8-d76aa788fbd5	\N
9a676713-b0e3-4623-8c77-f021b21043af	767ae8cf-af01-44d4-86ef-fcb143373407	f8ea4d65-54b4-49e3-8cf7-b209af7bd558	\N
fbeeb034-eaaa-40a4-bb23-23fbdc52e005	767ae8cf-af01-44d4-86ef-fcb143373407	8bbacf0c-ef2e-459c-b14f-6bf7b6236b72	\N
c5d715bf-8ab4-42eb-9fd8-331f4207ab0d	aa14ba1d-0b61-4e33-8474-7c2d98944b12	ac44a379-95b8-4222-99ab-8e70bd24a717	\N
2d52a93e-3724-4a24-bf7e-9de4a21d1435	aa14ba1d-0b61-4e33-8474-7c2d98944b12	378fdfa7-6039-42ac-8586-073165e2eab8	\N
1ed75cb4-22ae-4eb1-9f48-1d921e2b57bc	aa14ba1d-0b61-4e33-8474-7c2d98944b12	02d1eeb1-54cc-4002-b5ef-f5b5f40ab895	\N
f22f3a7d-0e89-42dc-a18e-a3be51c89914	aa14ba1d-0b61-4e33-8474-7c2d98944b12	53da7292-c97a-491a-a4f2-ca348dd3add5	\N
2916413f-97db-4a8a-9bfb-a5e186919a96	aa14ba1d-0b61-4e33-8474-7c2d98944b12	97ff4363-d78c-4e39-8620-fdbca6bd6b89	\N
ef84367e-81b0-43ce-b048-27b12790a900	72eb6a8e-af55-4f16-b69a-49f7b8a74f8d	a5f72fd8-998b-4c25-a8d7-f789b5c8a731	\N
12fae2d0-5590-42f2-b769-490c7cd9479a	72eb6a8e-af55-4f16-b69a-49f7b8a74f8d	d438673b-a9a6-43c7-b692-b37d06789fb5	\N
7e21c1fd-eff3-4278-877d-e1100192d8bd	72eb6a8e-af55-4f16-b69a-49f7b8a74f8d	4eb6c3b9-98a8-41df-a5b4-431d726b181a	\N
063e1b62-5cd9-4c4e-b108-fbcafe8b50ed	72eb6a8e-af55-4f16-b69a-49f7b8a74f8d	03876f9b-3656-4f3e-8e1d-ac203a236fcf	\N
d37c30de-403e-40f3-ad67-26ce88af9ca3	1408a814-0729-41ae-b645-6150fa79071f	1752fcbc-65ae-49c0-9e74-15a65b094b55	\N
bd9f668c-ffb9-48d2-a974-dd744223b9dd	1408a814-0729-41ae-b645-6150fa79071f	9e263628-a3e0-4e90-9942-9fe9e42a22ed	\N
dbddc5f9-5d7f-4921-beec-d0ef29a7c8ac	1408a814-0729-41ae-b645-6150fa79071f	94839999-0711-41ca-8641-88b99263c587	\N
40913a30-1b60-4f5b-8925-b7b523ca3451	1408a814-0729-41ae-b645-6150fa79071f	56e9a141-10f1-468c-bce5-cb6a23edb353	\N
31bd5d5d-c681-40a1-9f69-cf21ca4ade16	1408a814-0729-41ae-b645-6150fa79071f	d61d3172-aa6c-40e6-b7b0-d733b97655a5	\N
a70c6eea-4566-48fd-a030-7adc03970fe0	1408a814-0729-41ae-b645-6150fa79071f	df29eb01-e1d7-41df-b5e7-bb5229a101c1	\N
50923c99-f94b-461e-a17b-1da3234929bb	1408a814-0729-41ae-b645-6150fa79071f	e02c12e9-681a-4b6c-877b-0c119294a64d	\N
754e5e95-7fdd-418c-aa61-6bb314b99b7e	6d2a6110-0d6b-4ae6-a143-c73fde6d65a2	77a067f4-d188-4a51-a342-8e48dc6e1907	\N
90cc3463-1d19-4fc2-af97-716912d62e55	6d2a6110-0d6b-4ae6-a143-c73fde6d65a2	d0890070-7ffe-4821-89b9-31e7209da04f	\N
3f84af5c-dc6d-47b0-a378-6199f613d506	6d2a6110-0d6b-4ae6-a143-c73fde6d65a2	374f22fe-8bbf-4605-8f44-ed567993367d	\N
e89c189f-3145-493a-9650-0b23c8214582	6d2a6110-0d6b-4ae6-a143-c73fde6d65a2	c495c9df-9369-464c-ab58-6ff7ad0276b0	\N
6b207e41-cd3b-4b9c-8c66-c9886e2a718c	6d2a6110-0d6b-4ae6-a143-c73fde6d65a2	1d55cccc-783b-46b4-a048-5baed2e67b3d	\N
76fb319a-843e-4fc7-9c32-a603e9aeb037	6d2a6110-0d6b-4ae6-a143-c73fde6d65a2	8007e647-423a-47d5-bf1c-92d40f30155e	\N
4cfe3429-f729-456c-a300-2cbb2303c8ea	6d2a6110-0d6b-4ae6-a143-c73fde6d65a2	850e70f3-3372-43ab-8f34-eaa5a87e2266	\N
0230db94-d2fa-4d53-9036-7e233ac16755	b896f8c9-29cb-4384-992e-44c7ad0ec1d5	4b770635-0130-42ba-9bc6-c08f30a0cd01	\N
971cfb32-f02b-4f90-ba93-ec91a8aac5ff	b896f8c9-29cb-4384-992e-44c7ad0ec1d5	a3afd667-7759-4eda-b4e2-4cd06bb600c5	\N
16b6d4b9-5544-43d6-8948-595640667de8	b896f8c9-29cb-4384-992e-44c7ad0ec1d5	73b066cc-b7c5-4c9a-aaf6-f5a857ddf18b	\N
18689092-d65b-47cc-b5ff-d87c4a85569d	b896f8c9-29cb-4384-992e-44c7ad0ec1d5	7dc7224b-d8fd-4c9c-b323-7fcb9093df8d	\N
42927079-b82c-4d0f-aacb-402022260969	2569ba58-1f8f-43ea-8b2c-0d373cf501fe	74cd9a25-8e03-4b2f-b311-49534e371576	\N
e0d2ea60-3799-4505-b7c1-50b7e9522ff2	2569ba58-1f8f-43ea-8b2c-0d373cf501fe	4406c5fa-e6bb-468c-a2f8-d76aa788fbd5	\N
efa3fd60-a2d8-48a1-81ac-d42c8f91027d	2569ba58-1f8f-43ea-8b2c-0d373cf501fe	f8ea4d65-54b4-49e3-8cf7-b209af7bd558	\N
00d1cf98-1df3-4c54-a0c1-4b19902ac33e	2569ba58-1f8f-43ea-8b2c-0d373cf501fe	8bbacf0c-ef2e-459c-b14f-6bf7b6236b72	\N
3dacd5dc-21f3-4495-9b37-79271ef9c210	32f9413b-619a-4e4b-85f9-4c4699267b37	0d3560bc-d3bd-4a9b-af08-05afd68df8d9	\N
68bddc13-d44b-4b86-9936-cd21601a34f6	32f9413b-619a-4e4b-85f9-4c4699267b37	e4ea4cd3-e0bd-4508-b0a4-a3c749cb6647	\N
84816bd6-62ef-4a7b-b9de-df362b9f9ba7	32f9413b-619a-4e4b-85f9-4c4699267b37	5934a0fd-cff0-4e42-ad9d-e0ff058e37f6	\N
ca66fd7c-5132-4404-8053-529ad6b6b335	32f9413b-619a-4e4b-85f9-4c4699267b37	afd95fac-fc49-4435-b133-55eada76138f	\N
162503e7-9e43-44bc-8fd0-9cea4ea16328	6d2a6110-0d6b-4ae6-a143-c73fde6d65a2	57fba951-f936-4f0c-ba26-bc52e2ee36b1	\N
\.


--
-- TOC entry 4221 (class 0 OID 2447020)
-- Dependencies: 229
-- Data for Name: org_unit; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.org_unit (id, name, code, parent_id, removed) FROM stdin;
3516544f-64c5-4883-9047-28bcce74d1be	Default Organization	DEFAULT	\N	f
20f455d2-2908-4a86-8ab5-2e500f2f5544	Министерство обороны	f03fc8c0-2ce7-4121-a306-f82d65ea029d	\N	f
e00feef8-7b8a-47c2-9a16-f0f7dc877f56	Восточный военный округ	b23f384f-b114-4003-9277-2eaa2d9ae180	\N	f
72cd6795-0303-4894-82ad-911bc259d87e	Московский военный округ	30a01af9-a871-411a-90e3-d81592bb074f	\N	f
d29346a7-dc0f-452d-859f-9bd3a83c219c	Ленинградский военный округ	25633423-52e6-45bb-9d54-7f85b74a3f7d	\N	f
826c2187-7761-48ff-9399-25d1cc2a9297	Центральный военный округ	58ef9cdc-8a9d-429e-89a5-1c49e2684a98	\N	f
a7b1f5f2-e43f-44da-92c6-6f394f53ec95	Южный военный округ	b00de68d-2e09-4776-9b48-1566a7222dca	\N	f
fb2a5e9b-5c86-4c6f-bea0-c4501d466549	Тестовый комиссариат 2	83779471-c29f-c2eb-0e70-7846af31d10e	\N	f
521ce853-5cec-4d2c-8aa5-8f73e5ac3376	FDfsafd	31b88ed6-263e-225d-0787-74f7ef25f5f6	\N	f
30de0a5c-a8df-4591-9bdc-52bfe5abb31d	Военный комиссариат Вятска Тест	5055a985-c97c-f5dc-2158-ff5862bfe4cf	\N	f
f8010c28-ec1b-415f-9546-f1b58e36279e	Тестовая организация Тест Второй	8edec280-3143-4d45-b702-ad5e91ef0e52	\N	f
ba28c023-72f4-4ef5-b209-631f72f9488e	Военный комиссариат городских округов Курильский и Северо-Курильский Сахалинской области	ce08e909-5a14-480f-b931-bff172872ac6	\N	f
4d3daef5-a63d-417c-8235-97c2b772a182	Военный комиссариат городского округа Южно-Курильский Сахалинской области	6da64c78-6705-4567-9f5f-5ade5822d92f	\N	f
a3188467-3169-4b4e-847c-ffcca71c4440	Военный комиссариат города Долинск и Долинского района Сахалинской области	110686b2-4a01-4976-885b-d26a2980f53a	\N	f
a67c6e12-b1fe-406b-b080-6b518324d6ea	Военный комиссариат города Невельск и Невельского района Сахалинской области	98d428b3-502e-42b6-a29e-a469f894ac16	\N	f
bb80fa73-9e50-491c-98c1-1869d752bba7	Военный комиссариат Краснинского района Липецкой области	8127c345-3fc1-4864-9d6e-cf34e69c494c	\N	f
e6c40dc8-0065-42c2-8c50-87714b3a0f7c	Военный комиссариат Лебедянского района Липецкой области	b2238b19-8598-4dfa-bb49-0de95136e344	\N	f
cef595ce-c5af-44bb-9711-b0b7fd5b2df4	Тестовый муниципальный комиссариат 2	54a95ecd-1530-424c-8da1-882622b2df83	\N	f
3a36fc6d-e2d4-414b-a995-e6c8bff78b77	Военный комиссариат города Холмск и Холмского района Сахалинской области	67dacb06-d1f7-4c0e-9891-32863353cae9	\N	f
659ed98b-9868-4168-adff-35e9e1bd9b0b	Военный комиссариат города Поронайск, Макаровского, Поронайского и Смирныховского районов Сахалинской области	24b7ba55-9757-45d9-9c5e-5ca3e8c9c2d0	\N	f
8a1f8307-76c9-4923-a0fe-88bc6a563fcb	АУВафцыва	20d82cbf-d520-48ce-a02a-540ce3838087	\N	f
6fabcb61-584f-401d-85f6-79a49e3d8f61	Военный комиссариат Измалковского района Липецкой области	52e97a4c-f68c-489a-a923-fabb9ef574dd	\N	f
08f29c2e-0682-4179-a8f1-21a278c22d26	Военный комиссариат Долгоруковского района Липецкой области	94a9f485-eab9-4158-a1bf-330d23e29ae2	\N	f
c93d2dc2-7741-4ca7-9690-14c764a77bf0	Военный комиссариат Задонского района Липецкой области	f4e38f22-d974-412b-8a34-b1933ca865a9	\N	f
d01db5cc-086b-4609-9aad-2c6397c4dd96	Военный комиссариат города Данков, Данковского и Лев-Толстовского района Липецкой области	2545944e-5252-4a6f-bcb2-8a4adf720e9b	\N	f
939dd496-542a-45f4-91e0-90c331d85f5f	Военный комиссариат Хлевенского района Липецкой области	3a56b060-20ee-4b62-9d96-4c6bf4928039	\N	f
fd142737-1a6a-466f-a318-b1412b184b3d	Военный комиссариат Шиловского и Путятинского районов Рязанской области	79f6c236-3ee8-40ff-bc10-40077420e82e	\N	f
50439548-a88f-4e49-93a1-ce29c1eb9b9a	Военный комиссариат Ухоловского, Сапожковского и Сараевского районов Рязанской области	86fc6ed6-1d82-4536-8066-c9ff2ca68639	\N	f
908c5c7a-2942-4083-acbf-3a03c739b860	Военный комиссариат города Шацк, Шацкого и Чучковского районов Рязанской области	e22cfafc-b8b1-47fd-b9f4-b9015734d578	\N	f
928411d1-b6c2-40ea-a3df-4cad7aec98a5	Военный комиссариат Московского и Железнодорожного районов города Рязань Рязанской области	2ca66dd6-6688-45c9-bb7e-988c7e92d34a	\N	f
da5a8694-eae5-4da1-81b9-54ac3ac178f2	Военный комиссариат Клепиковского района Рязанской области	55727f17-6ab4-4d51-ad32-ba8e916acf49	\N	f
9b83cc97-0439-458e-bc45-08315eb4d9b8	Военный комиссариат Рязанского и Спасского районов Рязанской области	6562ddb0-3f0c-4e43-bf0c-a834421cd4db	\N	f
cbc0917a-3052-41ea-a97e-f482b2c81b2d	Военный комиссариат города Скопин, Скопинского и Милославского районов Рязанской области	f59afe6d-c166-4196-a489-6d17f02fc05e	\N	f
b2e6bca2-d7eb-4654-8aef-d5c529e1c899	Военный комиссариат Сахалинской области	84bc45ab-c032-410e-9dc5-07e92719ede4	\N	f
3cab3b8a-15f2-4c69-a3be-e7485717baa2	Тестовый комиссариат 1	e8f52736-3997-4e3a-c9e4-5bfca6eddc89	\N	f
67db7b5b-0892-4908-bd20-864f932e80f9	Главное организационно-мобилизационное управление	5d8e4e2b-37d7-44a8-accb-45e87b62aa2d	\N	f
6e1017e2-1e38-481f-85c2-e828247f2b79	Восьмое управление ГШ ВС РФ	553b9449-6460-48c4-88d4-f18283abc4a7	\N	f
69865d28-3f69-4047-8d4d-9469a6c33d5f	Военный комиссариат Октябрьского и Советского районов города Рязань Рязанской области	6139de3b-2378-496f-9fca-7df7dab90832	\N	f
77df47ff-f9d1-47f6-89c5-dc214b91a2a2	Военный комиссариат Липецкой области	2137685f-0683-4131-82d8-983222114184	\N	f
38392eea-e14b-48b5-a0a1-2cff65bcb396	Военный комиссариат Рязанской области	092d6963-287c-454e-8d73-8e09ebee972e	\N	f
1cb021ac-4335-40d4-987c-7c7648d104be	Военный комиссариат города Оха и Охинского района Сахалинской области	5eadc746-674d-4ba0-95d6-414d3469c82b	\N	f
2330352b-59ff-4b3f-b534-196fb5b20f9a	ВК Одинцовского городского округа городских округов Краснознаменск и Власиха Московской области	3b71b6ff-3eec-4cca-fed0-055bb0c163cc	\N	f
4b2365ea-b799-48d4-ab00-b6f6dac5b952	тест	bce5663e-5fe1-94a7-40f9-71d0490459da	\N	f
4e36849b-6652-483d-aecf-a3d9e18e42b9	Военный комиссариат Кораблинского района Рязанской области	0fe2bdf0-afbb-402d-93da-67e511799afa	\N	f
8bd65d2b-630c-4513-964b-d70b48726bc5	Военный комиссариат города Липецк Липецкой области	9703f108-761a-467a-aad3-89617e5539ed	\N	f
2caa5eae-b6c8-4943-8b8b-428dc9c6cb4d	Военный комиссариат города Грязи и Грязинского района Липецкой области	b5209c2c-67f6-4b6d-9617-8370aa9907a8	\N	f
b00a1841-f444-4fb4-827a-a4e1075eac01	Военный комиссариат города Углегорск, Томаринского и Углегорского районов Сахалинской области	121d7da8-5f40-4e79-900a-ddba5a62f8aa	\N	f
0b6eaee2-e52c-4d79-ab97-921a98007539	НЕ трогать оргу Андреева	731b87ec-91e7-cf82-afcc-b2967439f7ae	\N	f
fb0ec464-70e8-421b-bb20-8a12bf5780c4	Военный комиссариат Чаплыгинского района Липецкой области	4b0309d6-f28a-49db-8950-5ffebd917e1e	\N	f
610d1eee-a270-4f35-b8aa-df017e102b5c	Муниципального Военный Комиссариат Вятска	10b67909-b154-45e3-8eef-7f0fac9abb5d	\N	f
f7fadde2-de94-4386-926a-48f539b14564	Военный комиссариат города Елец и Елецкого района Липецкой области	b042e073-e4ff-4873-b33e-4d44d17ec72d	\N	f
1c213331-711b-4263-8275-a0e099e0f78d	Военный комиссариат Анивского района Сахалинской области	cff66da8-2be0-4839-bd8e-332b1a150031	\N	f
7e17cb21-4dfb-4f66-8996-1f87e78f8533	Военный комиссариат города Южно-Сахалинск Сахалинской области	2966d239-5241-4acb-9b4f-707ba75f44d5	\N	f
dde8fd00-3648-49ed-a40e-c7caa58cab8d	Военный комиссариат Ногликского района Сахалинской области	eba7fd7d-e3da-49a7-8e65-8fc85e47190e	\N	f
1eabf1d8-3202-4359-b6be-dd045afbfa40	Военный комиссариат Липецкого района Липецкой области	70a19cf0-203a-4d04-a1c5-62c811c5ae66	\N	f
e4671f49-8155-447a-a35c-67cb6468803a	Военный комиссариат Усманского района Липецкой области	70b872b5-79de-4ef6-b5f3-11ecc68906bc	\N	f
618c4e20-c2b1-4783-bd35-3d5f897e5b83	Тестовый муниципальный комиссариат 1	00148448-3ad9-4e0d-b9d2-c5e81a05bcf6	\N	f
0b713936-42c9-4e40-bde3-e941220b81de	Военный комиссариат Звениговского района Республики Марий Эл	34c8685e-f08a-4877-afb1-a0589800a21c	\N	f
dbe21bb3-0416-4682-844a-07132e896a4b	Тестовая организация	fa005a7c-f833-0727-1924-990584ca6fee	\N	f
674eb255-c2a6-45e7-8395-46118f95cb9f	Военный комиссариат Становлянского района Липецкой области	786b4e73-42dd-4c36-968e-8cce5d9debc6	\N	f
78a69506-f876-4549-add0-dd9b95e4cde9	Тестовый муниципальный комиссариат 3	5584b973-f5c0-4aee-ae5a-0b0d0444ad1b	\N	f
7aaab069-b993-469c-9cdc-d05b48e01da2	Тестовый муниципальный комиссариат 4	d49f28d4-0eca-4fd7-b68c-a0a693223de0	\N	f
58e31fcf-567c-4b4c-8bc7-eb5fb9676f08	тестт	6daa4999-df84-4469-bcc7-0f875affd41a	\N	f
e2683ce5-7de8-43b8-9ff3-2a2dc23a4e7c	Военный комиссариат республики Мари Эл	bb7aa36f-446e-4262-a609-28694ca2e398	\N	f
0068b57d-1272-467d-8cfd-fb3edb9ce430	Военный комиссариат Сернурского района Республики Марий Эл	6f60bde2-33f8-4b33-be9f-cd57a6e041c4	\N	f
1ac66d8e-29ad-4cab-93fc-cced8d8b94b6	Военный комиссариат города Йошкар-Ола Республики Марий Эл	55eae374-9bb5-4295-9e3a-5fbcdaba870d	\N	f
efdbd421-c2b7-4d4a-a2b0-9a377595b060	Военный комиссариат Мари-Турекского и Параньгинского районов Республики Марий Эл	30ce4b57-17ca-4b01-b685-1303ce22e3f2	\N	f
44cbc7da-0243-4ec1-a3e0-604599501502	Военный комиссариат Куженерского района Республики Марий Эл	d5dd717e-d2f4-4e93-860a-1bb1a97beb46	\N	f
10653db1-856c-4f9b-b624-55bd2345380b	Военный комиссариат города Волжск и Волжского района Республики Марий Эл	2befcbb4-7eb3-4a77-a3cb-f7f0eb0fab2e	\N	f
9e0d94ef-2c1f-4335-9279-497357dfe550	Военный комиссариат Советского района Республики Марий Эл	0ce35443-78f6-473a-97f2-e1f2d5ba7a4e	\N	f
51f57f8b-b2ef-4409-89cd-55b544c1dfcd	Военный комиссариат Оршанского района Республики Марий Эл	ac702380-5836-4bed-b846-a8c15b241a84	\N	f
b08c1d90-915a-4bb4-a6c4-f44e2af9e63d	Военный комиссариат Медедевского и Килемарского района Республики Марий Эл	6ed8b34f-d049-4b7f-8d1b-b99a1852236b	\N	f
8667f0ec-4ca3-4668-8846-8b665cebda8d	Военный комиссариат города Козьмодемьянск, Горномарийского и Юринского районов Республики Марий Эл	fc10523f-af31-4f6b-b0e2-00799758f634	\N	f
a933e951-88c0-421d-a291-33fa4cea36fc	Военный комиссариат Моркинского района Республики Марий Эл	1ff99d4f-7418-46bc-9c60-61a0e4ec77bd	\N	f
58684643-1498-446e-bd62-8883d17f72bd	Военный комиссариат Вятска Тест	9a4640f6-143a-7642-51bd-d2b5ac5e9d1e	\N	f
6693233b-7893-43b5-80f5-08b282c35156	Военный комиссариат Добринского района Липецкой области	1cf09194-0f3b-4f2c-a14f-03604d68ff8f	\N	f
b9c6bc65-f4be-4b7e-842b-1c4d90f0c07f	Вторая организация	52b4ee14-5af8-c029-26c2-80faba9e967d	\N	f
46c0431c-6d5e-469c-9b89-2f0ed33c2cef	Военный комиссариат Добровского района Липецкой области	9c459101-fa10-4468-acbb-ce34df064aa1	\N	f
4e4c712e-f3bb-4f2f-8cf1-6e1c9bda2677	Второе подразделение	5ea50fa7-0b85-4a27-8293-dbd36162cb9a	\N	f
4da4fafb-f3ba-4f18-8140-54fffd552d59	Военный комиссариат Тербунского и Воловского районов Липецкой области	a2d517d4-a6c3-4cb8-8d9b-3c8d15a7007c	\N	f
d740fa3c-bb0a-42d7-9ba6-347fc7b57e4a	АВфвафв	4c062d4a-3f77-c850-6388-dde909e3946b	\N	f
dfe9ce08-7f82-4d59-a21d-65c1a9f1ed3b	Военный комиссариат города Корсаков и Корсаковского района Сахалинской области	bacac23b-477f-4c26-8973-d83f0ca387fb	\N	f
9c09e210-6dd9-4bc3-a8ad-f3dd4d1cc70a	Военный комиссариат города Александровск-Сахалинский, Александровск-Сахалинского и Тымовского районов Сахалинской области	82518cee-d3ce-40fd-a5b4-3e12647afc45	\N	f
4dcebf08-40b2-4ba0-8fe8-700d67cdc5b2	Военный комиссариат Рыбновского района Рязанской области	22c64b79-f8e4-41e7-a2f3-1aa9df424fd9	\N	f
3e77b04b-168d-4f27-a4b4-dce4ac71f394	Военный комиссариат города Михайлов, Михайловского и Захаровского районов Рязанской области	27f7b3c0-a222-45e0-896f-58bdf4341a41	\N	f
e7eaf26b-e0b6-4b1f-8a8b-c7f4ec26fb90	Военный комиссариат города Касимов и Касимовского района Рязанской области	370bc761-ae40-46f1-b4d8-974317b5ceb6	\N	f
d05d4f2f-168f-48c8-8817-f6403654a614	Тестовая Организация	d1efbe15-744e-8521-5b8e-7ac604e4379b	\N	f
2386a304-73a2-40ce-b3ec-f02d688f3b20	Военный комиссариат Пронского и Старожиловского районов Рязанской области	37c187fe-4f37-45e6-9246-07148112367c	\N	f
4ac5c009-5dc4-4ed3-a2ae-ec3a583d8ec0	Военный комиссариат Ряжского и Александро-Невского районов Рязанской области	dad6c101-34be-45c3-8173-57190cb69dfb	\N	f
aa6f0546-fc5d-4c51-a22d-27a8ce0041f3	Военный комиссариат города Сасово, Ермишинского, Кадомского, Сасовского и Пителинского районов Рязанской области	f6a7fb8b-379f-4802-bf00-73f9c493825f	\N	f
8000b421-4a1a-4db4-97f7-e01daaa93f42	Военный комиссариат Новоторъяльского района Республики Марий Эл	0e10678c-f272-41c3-94dd-c15830321f9a	\N	f
ce800cef-2d23-43e3-974f-6b79de3270ae	Администрация городского округа Щёлково Московской области	fe655d90-893a-31f7-ff8b-9ccef8af0f83	\N	f
3b767267-c2ef-468c-9e67-114ec4105832	ВК городских округов Щелково Фрязино Звездный городок и Лосино-Петровского городского округа Московской области	e079ea79-50f1-4af4-beea-1b7648e86ce9	\N	f
\.


--
-- TOC entry 4237 (class 0 OID 2447202)
-- Dependencies: 245
-- Data for Name: org_unit_additional_info; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.org_unit_additional_info (id, schema) FROM stdin;
20f455d2-2908-4a86-8ab5-2e500f2f5544	Ministry
e00feef8-7b8a-47c2-9a16-f0f7dc877f56	Region
72cd6795-0303-4894-82ad-911bc259d87e	Region
d29346a7-dc0f-452d-859f-9bd3a83c219c	Region
826c2187-7761-48ff-9399-25d1cc2a9297	Region
a7b1f5f2-e43f-44da-92c6-6f394f53ec95	Region
fb2a5e9b-5c86-4c6f-bea0-c4501d466549	Organization
521ce853-5cec-4d2c-8aa5-8f73e5ac3376	Organization
30de0a5c-a8df-4591-9bdc-52bfe5abb31d	Organization
f8010c28-ec1b-415f-9546-f1b58e36279e	Department
ba28c023-72f4-4ef5-b209-631f72f9488e	Department
4d3daef5-a63d-417c-8235-97c2b772a182	Department
a3188467-3169-4b4e-847c-ffcca71c4440	Department
a67c6e12-b1fe-406b-b080-6b518324d6ea	Department
bb80fa73-9e50-491c-98c1-1869d752bba7	Department
e6c40dc8-0065-42c2-8c50-87714b3a0f7c	Department
cef595ce-c5af-44bb-9711-b0b7fd5b2df4	Department
3a36fc6d-e2d4-414b-a995-e6c8bff78b77	Department
659ed98b-9868-4168-adff-35e9e1bd9b0b	Department
8a1f8307-76c9-4923-a0fe-88bc6a563fcb	Department
6fabcb61-584f-401d-85f6-79a49e3d8f61	Department
08f29c2e-0682-4179-a8f1-21a278c22d26	Department
c93d2dc2-7741-4ca7-9690-14c764a77bf0	Department
d01db5cc-086b-4609-9aad-2c6397c4dd96	Department
939dd496-542a-45f4-91e0-90c331d85f5f	Department
fd142737-1a6a-466f-a318-b1412b184b3d	Department
50439548-a88f-4e49-93a1-ce29c1eb9b9a	Department
908c5c7a-2942-4083-acbf-3a03c739b860	Department
928411d1-b6c2-40ea-a3df-4cad7aec98a5	Department
da5a8694-eae5-4da1-81b9-54ac3ac178f2	Department
9b83cc97-0439-458e-bc45-08315eb4d9b8	Department
cbc0917a-3052-41ea-a97e-f482b2c81b2d	Department
b2e6bca2-d7eb-4654-8aef-d5c529e1c899	Organization
3cab3b8a-15f2-4c69-a3be-e7485717baa2	Organization
67db7b5b-0892-4908-bd20-864f932e80f9	Organization
6e1017e2-1e38-481f-85c2-e828247f2b79	Organization
69865d28-3f69-4047-8d4d-9469a6c33d5f	Department
77df47ff-f9d1-47f6-89c5-dc214b91a2a2	Organization
38392eea-e14b-48b5-a0a1-2cff65bcb396	Organization
1cb021ac-4335-40d4-987c-7c7648d104be	Department
2330352b-59ff-4b3f-b534-196fb5b20f9a	Organization
4b2365ea-b799-48d4-ab00-b6f6dac5b952	Organization
4e36849b-6652-483d-aecf-a3d9e18e42b9	Department
8bd65d2b-630c-4513-964b-d70b48726bc5	Department
2caa5eae-b6c8-4943-8b8b-428dc9c6cb4d	Department
b00a1841-f444-4fb4-827a-a4e1075eac01	Department
0b6eaee2-e52c-4d79-ab97-921a98007539	Organization
fb0ec464-70e8-421b-bb20-8a12bf5780c4	Department
610d1eee-a270-4f35-b8aa-df017e102b5c	Department
f7fadde2-de94-4386-926a-48f539b14564	Department
1c213331-711b-4263-8275-a0e099e0f78d	Department
7e17cb21-4dfb-4f66-8996-1f87e78f8533	Department
dde8fd00-3648-49ed-a40e-c7caa58cab8d	Department
1eabf1d8-3202-4359-b6be-dd045afbfa40	Department
e4671f49-8155-447a-a35c-67cb6468803a	Department
618c4e20-c2b1-4783-bd35-3d5f897e5b83	Department
0b713936-42c9-4e40-bde3-e941220b81de	Department
dbe21bb3-0416-4682-844a-07132e896a4b	Organization
674eb255-c2a6-45e7-8395-46118f95cb9f	Department
78a69506-f876-4549-add0-dd9b95e4cde9	Department
7aaab069-b993-469c-9cdc-d05b48e01da2	Department
58e31fcf-567c-4b4c-8bc7-eb5fb9676f08	Department
e2683ce5-7de8-43b8-9ff3-2a2dc23a4e7c	Organization
0068b57d-1272-467d-8cfd-fb3edb9ce430	Department
1ac66d8e-29ad-4cab-93fc-cced8d8b94b6	Department
efdbd421-c2b7-4d4a-a2b0-9a377595b060	Department
44cbc7da-0243-4ec1-a3e0-604599501502	Department
10653db1-856c-4f9b-b624-55bd2345380b	Department
9e0d94ef-2c1f-4335-9279-497357dfe550	Department
51f57f8b-b2ef-4409-89cd-55b544c1dfcd	Department
b08c1d90-915a-4bb4-a6c4-f44e2af9e63d	Department
8667f0ec-4ca3-4668-8846-8b665cebda8d	Department
a933e951-88c0-421d-a291-33fa4cea36fc	Department
58684643-1498-446e-bd62-8883d17f72bd	Organization
6693233b-7893-43b5-80f5-08b282c35156	Department
b9c6bc65-f4be-4b7e-842b-1c4d90f0c07f	Organization
46c0431c-6d5e-469c-9b89-2f0ed33c2cef	Department
4e4c712e-f3bb-4f2f-8cf1-6e1c9bda2677	Department
4da4fafb-f3ba-4f18-8140-54fffd552d59	Department
d740fa3c-bb0a-42d7-9ba6-347fc7b57e4a	Organization
dfe9ce08-7f82-4d59-a21d-65c1a9f1ed3b	Department
9c09e210-6dd9-4bc3-a8ad-f3dd4d1cc70a	Department
4dcebf08-40b2-4ba0-8fe8-700d67cdc5b2	Department
3e77b04b-168d-4f27-a4b4-dce4ac71f394	Department
e7eaf26b-e0b6-4b1f-8a8b-c7f4ec26fb90	Department
d05d4f2f-168f-48c8-8817-f6403654a614	Organization
2386a304-73a2-40ce-b3ec-f02d688f3b20	Department
4ac5c009-5dc4-4ed3-a2ae-ec3a583d8ec0	Department
aa6f0546-fc5d-4c51-a22d-27a8ce0041f3	Department
8000b421-4a1a-4db4-97f7-e01daaa93f42	Department
ce800cef-2d23-43e3-974f-6b79de3270ae	Organization
3b767267-c2ef-468c-9e67-114ec4105832	Department
\.


--
-- TOC entry 4219 (class 0 OID 2446994)
-- Dependencies: 227
-- Data for Name: simple_credentials; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.simple_credentials (user_account_id, password, password_expires, password_updated) FROM stdin;
008af907-0fa2-4c14-b163-6e96f2d386ef	$2a$11$.ZfN0Jopplbqw8eeyo8VMOlgOr032hJ0XxnnJc30IRT6EHFmDvB2W	\N	2024-11-26 20:29:44.39242
7c8009d5-fd52-42ba-99f0-4474c0dc7302	$2a$11$sjiBXVZzCDJ0NIQoC7i4TuGv/NQu4S/zn5A7ygeTw.JvfJdMXA0sm	\N	2024-11-26 20:29:44.517554
67ed8a30-2596-4dad-a782-756c7dfc4c72	$2a$11$bNNQ/5bLA5HMpJkjCt.4J.M37RR59tSjs/JJVwq6PVBFfGpF6MweO	\N	2024-10-17 10:51:05.996629
4caa6156-3cfb-4ea5-aa42-d3ff6f10ff8c	$2a$11$Fv1Pvx74a5lfVwtRVzoX2enm8fmXjN3ykUL6qMcSpC96C22X9qU/2	\N	2024-10-17 10:50:04.067612
408ff49a-4004-43b5-b040-3ca4ae363d03	$2a$11$xWAtGkq2VVcdd8c9GNFxn.JNyfts4./Q7QNgG1M75NTYj3OOufWhO	\N	2024-10-17 12:49:45.512511
62a03ff4-4b62-435c-a2ff-f7dbe7df2a6d	$2a$11$j/zVSO0ntFJe6q01798zl.xssDsJw4/w9mLpx72fQKHZ0hhxMeQD2	\N	2024-10-18 16:18:20.872589
\.


--
-- TOC entry 4212 (class 0 OID 2446859)
-- Dependencies: 220
-- Data for Name: user_account; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.user_account (user_account_id, email, first_name, last_name, middle_name, created, updated, locked, org_unit_id, username, phone, email_confirmed, user_source, source_name) FROM stdin;
008af907-0fa2-4c14-b163-6e96f2d386ef	demo@example.com	Demo	Demo	\N	2024-11-26 20:29:44.39242+03	2024-11-26 20:29:44.39242+03	f	3516544f-64c5-4883-9047-28bcce74d1be	demo@example.com	\N	t	LOCAL	\N
7c8009d5-fd52-42ba-99f0-4474c0dc7302	jbpm.administrator@example.com	JBPM	Administrator	\N	2024-11-26 20:29:44.517554+03	2024-11-26 20:29:44.517554+03	f	3516544f-64c5-4883-9047-28bcce74d1be	Administrator	\N	t	LOCAL	\N
67ed8a30-2596-4dad-a782-756c7dfc4c72	petrova@mail.ru	Анна	Петрова	Сергеевна	2024-10-17 13:51:05.996629+03	2024-10-17 15:42:39+03	f	0068b57d-1272-467d-8cfd-fb3edb9ce430	petrova	9788554411	t	LOCAL	\N
408ff49a-4004-43b5-b040-3ca4ae363d03	sidorov@mail.ru	Сидор	Сидоров	Сидорович	2024-10-17 15:49:45.512511+03	2024-10-17 15:50:58+03	f	20f455d2-2908-4a86-8ab5-2e500f2f5544	sidorov	\N	t	LOCAL	\N
62a03ff4-4b62-435c-a2ff-f7dbe7df2a6d	semenov@mail.ru	Семен	Семенов	Семенович	2024-10-18 19:18:20.872589+03	2024-10-18 19:18:20.872589+03	f	0068b57d-1272-467d-8cfd-fb3edb9ce430	semenov	\N	t	LOCAL	\N
4caa6156-3cfb-4ea5-aa42-d3ff6f10ff8c	ivanov@mail.ru	Иван	Иванов	Иванович	2024-10-17 13:50:04.067612+03	2024-10-17 15:46:34+03	f	0068b57d-1272-467d-8cfd-fb3edb9ce430	ivanov	9172010203	t	LOCAL	\N
\.


--
-- TOC entry 4223 (class 0 OID 2447064)
-- Dependencies: 231
-- Data for Name: user_account_refresh_token; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.user_account_refresh_token (user_account_refresh_token_id, user_account_id, refresh_token, access_token, expiration_time) FROM stdin;
43e10b50-7fc4-4315-95c2-5397ee360396	67ed8a30-2596-4dad-a782-756c7dfc4c72	eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiI2N2VkOGEzMC0yNTk2LTRkYWQtYTc4Mi03NTZjN2RmYzRjNzIiLCJzaW1wbGVDcmVkZW50aWFscyI6dHJ1ZSwiaXNzIjoicnUubWljb3JkLmVydnUuYWNjb3VudC1hcHBsaWNhdGlvbnMiLCJqdGkiOiJjMGVjNGViYi0wZWRjLTRmM2QtYmZlOS1iMDRkN2QxYzdjYWIiLCJpYXQiOjE3MzI2NDIyNDgsImV4cCI6MTczNTIzNDI0OH0.j7kU7sTHFYONx2OfumebifJlrccoQWMNmpkMcvXhkTU	eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiI2N2VkOGEzMC0yNTk2LTRkYWQtYTc4Mi03NTZjN2RmYzRjNzIiLCJzaW1wbGVDcmVkZW50aWFscyI6dHJ1ZSwiaXNzIjoicnUubWljb3JkLmVydnUuYWNjb3VudC1hcHBsaWNhdGlvbnMiLCJpYXQiOjE3MzI2NDIyNDgsImV4cCI6MTczMjY0NTg0OH0.Uf9Y-B3e7mK_Pbdcve7pt9_J7n6h-dCNWjJgO-KfYrE	2024-12-26 20:30:49
46b52ccb-7680-47ea-a5c2-13f7afc045c9	408ff49a-4004-43b5-b040-3ca4ae363d03	eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiI0MDhmZjQ5YS00MDA0LTQzYjUtYjA0MC0zY2E0YWUzNjNkMDMiLCJzaW1wbGVDcmVkZW50aWFscyI6dHJ1ZSwiaXNzIjoicnUubWljb3JkLmVydnUuYWNjb3VudC1hcHBsaWNhdGlvbnMiLCJqdGkiOiI0YWU1ZjllNS00NzI2LTQ3NTEtYTNkMS0zMGY5NmI4N2E3MzMiLCJpYXQiOjE3MzI2OTI4MjIsImV4cCI6MTczNTI4NDgyMn0.AciiJalRXZWhFbJeoYJY2RtfJprOiycw5G4Bld5C3W4	eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiI0MDhmZjQ5YS00MDA0LTQzYjUtYjA0MC0zY2E0YWUzNjNkMDMiLCJzaW1wbGVDcmVkZW50aWFscyI6dHJ1ZSwiaXNzIjoicnUubWljb3JkLmVydnUuYWNjb3VudC1hcHBsaWNhdGlvbnMiLCJpYXQiOjE3MzI2OTI4MjIsImV4cCI6MTczMjY5NjQyMn0.OQdoIZU3g4Ad4ssqWxsEB0JVTvvfJZW3ADGzDDFPuRU	2024-12-27 10:33:43
5c0beb5d-d105-44ed-beaa-29ea7a9dc76c	67ed8a30-2596-4dad-a782-756c7dfc4c72	eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiI2N2VkOGEzMC0yNTk2LTRkYWQtYTc4Mi03NTZjN2RmYzRjNzIiLCJzaW1wbGVDcmVkZW50aWFscyI6dHJ1ZSwiaXNzIjoicnUubWljb3JkLmVydnUuYWNjb3VudC1hcHBsaWNhdGlvbnMiLCJqdGkiOiIwOWNlNGUwMy04Mzk5LTQxOGEtYmZiZi1jODY5OGVlMmM1OTYiLCJpYXQiOjE3MzI2OTM1MzcsImV4cCI6MTczNTI4NTUzN30.DIbHc88KZI0cUn7mHW1OWYMaHkOz7wAWIrE3fHtQbqg	eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiI2N2VkOGEzMC0yNTk2LTRkYWQtYTc4Mi03NTZjN2RmYzRjNzIiLCJzaW1wbGVDcmVkZW50aWFscyI6dHJ1ZSwiaXNzIjoicnUubWljb3JkLmVydnUuYWNjb3VudC1hcHBsaWNhdGlvbnMiLCJpYXQiOjE3MzI2OTM1MzcsImV4cCI6MTczMjY5NzEzN30.0qNC74YSeKoXW8a6MKafP4WhzeEFI_cXzEN1PXrFrBk	2024-12-27 10:45:37
2a9586c2-a296-4f6b-a4bf-3eeb707bdbb3	67ed8a30-2596-4dad-a782-756c7dfc4c72	eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiI2N2VkOGEzMC0yNTk2LTRkYWQtYTc4Mi03NTZjN2RmYzRjNzIiLCJzaW1wbGVDcmVkZW50aWFscyI6dHJ1ZSwiaXNzIjoicnUubWljb3JkLmVydnUuYWNjb3VudC1hcHBsaWNhdGlvbnMiLCJqdGkiOiI0YzljMWM3Mi0zMzJkLTQyY2YtODFlNS03MTQxNDAzZWMyMDgiLCJpYXQiOjE3MzI2OTQ5MTksImV4cCI6MTczNTI4NjkxOX0.GBGWr_vcuRguUxMuGXrdQqD-zrI6Rd5yDzpfogkccY4	eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiI2N2VkOGEzMC0yNTk2LTRkYWQtYTc4Mi03NTZjN2RmYzRjNzIiLCJzaW1wbGVDcmVkZW50aWFscyI6dHJ1ZSwiaXNzIjoicnUubWljb3JkLmVydnUuYWNjb3VudC1hcHBsaWNhdGlvbnMiLCJpYXQiOjE3MzI2OTQ5MTksImV4cCI6MTczMjY5ODUxOX0.ZPB8PbiE162BxvYvyVREXlAPsmbn-UYVPNvqaUAuuzw	2024-12-27 11:08:40
dc3a7823-b283-463a-8dac-c0c1d72d7ebd	67ed8a30-2596-4dad-a782-756c7dfc4c72	eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiI2N2VkOGEzMC0yNTk2LTRkYWQtYTc4Mi03NTZjN2RmYzRjNzIiLCJzaW1wbGVDcmVkZW50aWFscyI6dHJ1ZSwiaXNzIjoicnUubWljb3JkLmVydnUuYWNjb3VudC1hcHBsaWNhdGlvbnMiLCJqdGkiOiJiMGVjMDU1YS1lNmU3LTRhMzUtODBjYS03MWY2OWY0ZjJmNDciLCJpYXQiOjE3MzI2OTY5MjgsImV4cCI6MTczNTI4ODkyOH0.g0-Q4tK6Z9_VfuPZPhBU6-GnUhSqKJtFepSphZh8ADA	eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiI2N2VkOGEzMC0yNTk2LTRkYWQtYTc4Mi03NTZjN2RmYzRjNzIiLCJzaW1wbGVDcmVkZW50aWFscyI6dHJ1ZSwiaXNzIjoicnUubWljb3JkLmVydnUuYWNjb3VudC1hcHBsaWNhdGlvbnMiLCJpYXQiOjE3MzI2OTY5MjgsImV4cCI6MTczMjcwMDUyOH0.SEDDB4ZuLsM07bdbufSqn6ZYtGloUwqre8dwvgg4ViU	2024-12-27 11:42:08
\.


--
-- TOC entry 4224 (class 0 OID 2447094)
-- Dependencies: 232
-- Data for Name: user_account_verification; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.user_account_verification (user_account_id, token, created) FROM stdin;
\.


--
-- TOC entry 4214 (class 0 OID 2446920)
-- Dependencies: 222
-- Data for Name: user_group; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.user_group (user_group_id, name, created, updated, access_level_id) FROM stdin;
62cd890b-99f7-47a8-be60-e330186b17a0	BPMN User	2024-11-26 20:29:48.194248+03	2024-11-26 20:29:48.194248+03	a6bf4b31-6648-4095-b269-2a950b548a10
ddfdc772-7aee-492f-be7d-7e95ea2f45b3	BPMN Admin	2024-11-26 20:29:48.194248+03	2024-11-26 20:29:48.194248+03	a6bf4b31-6648-4095-b269-2a950b548a10
22ee608b-dd9d-4633-906d-7c4efca231a0	Demo	2024-11-26 20:29:50.063443+03	2024-11-26 20:29:50.063443+03	a6bf4b31-6648-4095-b269-2a950b548a10
84c5c1e2-081e-45e1-a874-d6bb232e57ad	Security Admin	2024-11-26 20:29:48.194248+03	2024-11-26 20:29:48.194248+03	a3b84288-1c96-448b-ba33-7a454f311757
eaf300bc-a4cf-47c1-b5cb-d2b8abef02e5	Super Admin	2024-11-26 20:29:56.570516+03	2024-11-26 20:29:56.570516+03	2b6038cb-15bf-4bb0-87df-88a1557b93d7
273d8bbd-0e82-4064-a548-850e9aa61756	BPMN Superuser	2024-11-26 20:29:53.002794+03	2024-11-26 20:29:53.002794+03	a6bf4b31-6648-4095-b269-2a950b548a10
25d720ff-fa5e-41f2-bbe9-0db90187b0f4	Ответственный за ЗИ	2024-10-09 20:47:31+03	2024-10-09 20:47:31+03	a6bf4b31-6648-4095-b269-2a950b548a10
acf292b2-9b46-4bf2-9254-39696d26f02b	Ответственный за ЗИ СВК	2024-10-09 20:49:39+03	2024-10-09 20:49:39+03	a6bf4b31-6648-4095-b269-2a950b548a10
00fe3742-dbb3-4639-aabd-3a10050ecd9e	Администратор ПОИБ	2024-10-09 20:51:04+03	2024-10-09 20:51:04+03	a6bf4b31-6648-4095-b269-2a950b548a10
6428cb6d-2949-4570-85b5-4b81e33b19ff	Сотрудник ВК	2024-10-17 12:15:42+03	2024-10-17 12:15:42+03	a6bf4b31-6648-4095-b269-2a950b548a10
0c61996f-c1db-483e-8456-5a5a9dc6dcdd	Военный комиссар	2024-10-17 12:15:30+03	2024-10-18 18:08:04+03	a6bf4b31-6648-4095-b269-2a950b548a10
\.


--
-- TOC entry 4213 (class 0 OID 2446887)
-- Dependencies: 221
-- Data for Name: user_role; Type: TABLE DATA; Schema: security; Owner: ervu_account_applications
--

COPY security.user_role (user_role_id, name, created, updated) FROM stdin;
767ae8cf-af01-44d4-86ef-fcb143373407	BPMN User	2024-11-26 20:29:46.315091+03	2024-11-26 20:29:46.315091+03
aa14ba1d-0b61-4e33-8474-7c2d98944b12	BPMN Admin	2024-11-26 20:29:46.315091+03	2024-11-26 20:29:46.315091+03
72eb6a8e-af55-4f16-b69a-49f7b8a74f8d	Security - Role Admin	2024-11-26 20:29:46.315091+03	2024-11-26 20:29:46.315091+03
1408a814-0729-41ae-b645-6150fa79071f	Security - Group Admin	2024-11-26 20:29:46.315091+03	2024-11-26 20:29:46.315091+03
6d2a6110-0d6b-4ae6-a143-c73fde6d65a2	Security - User Admin	2024-11-26 20:29:46.315091+03	2024-11-26 20:29:46.315091+03
b896f8c9-29cb-4384-992e-44c7ad0ec1d5	Security - Authority Admin	2024-11-26 20:29:46.315091+03	2024-11-26 20:29:46.315091+03
2569ba58-1f8f-43ea-8b2c-0d373cf501fe	BPMN Superuser	2024-11-26 20:29:49.847837+03	2024-11-26 20:29:49.847837+03
32f9413b-619a-4e4b-85f9-4c4699267b37	Security - Org Unit Admin	2024-11-26 20:29:54.489704+03	2024-11-26 20:29:54.489704+03
17c97647-f53c-400f-a700-ad349eeee0c3	Ответственный за ЗИ	2024-10-09 16:39:06+03	2024-10-09 16:39:06+03
68a81927-259d-4e2a-84d7-c565a9d0f943	Администратор ПОИБ	2024-10-09 16:39:06+03	2024-10-09 16:39:06+03
726dc966-6832-4f5c-b867-2797259d5104	Ответственный за ЗИ СВК	2024-10-09 16:39:06+03	2024-10-09 16:39:06+03
65b50a78-4f68-4bd9-9836-4fb3e2fb2c6a	Управления параметрами информационной безопасности	2024-10-09 16:39:06+03	2024-10-09 16:39:06+03
cc1ac346-71bf-4fa7-9300-78730a1bed08	Список пользователей	2024-10-09 16:39:06+03	2024-10-09 16:39:06+03
720d8a2b-1b30-4002-9a44-8e531c86460c	Сотрудник ВК	2024-10-17 12:11:00+03	2024-10-17 12:11:00+03
30c92f56-439c-463d-829c-93bcbf6b64d1	Военный комиссар	2024-10-17 12:11:00+03	2024-10-18 18:07:50+03
422e6caf-4f53-4e0f-83f9-af4897cf75ef	Военком	2024-10-18 20:27:23+03	2024-10-18 20:27:23+03
\.


--
-- TOC entry 4284 (class 0 OID 0)
-- Dependencies: 235
-- Name: job_position_job_position_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ervu_account_applications
--

SELECT pg_catalog.setval('public.job_position_job_position_id_seq', 2, true);


--
-- TOC entry 4285 (class 0 OID 0)
-- Dependencies: 242
-- Name: link_user_application_user_gr_link_user_application_user_gr_seq; Type: SEQUENCE SET; Schema: public; Owner: ervu_account_applications
--

SELECT pg_catalog.setval('public.link_user_application_user_gr_link_user_application_user_gr_seq', 6, true);


--
-- TOC entry 4286 (class 0 OID 0)
-- Dependencies: 237
-- Name: user_application_document_user_application_document_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ervu_account_applications
--

SELECT pg_catalog.setval('public.user_application_document_user_application_document_id_seq', 10, true);


--
-- TOC entry 4287 (class 0 OID 0)
-- Dependencies: 240
-- Name: user_application_list_number_app_seq; Type: SEQUENCE SET; Schema: public; Owner: ervu_account_applications
--

SELECT pg_catalog.setval('public.user_application_list_number_app_seq', 6, true);


--
-- TOC entry 4288 (class 0 OID 0)
-- Dependencies: 239
-- Name: user_application_list_user_application_list_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ervu_account_applications
--

SELECT pg_catalog.setval('public.user_application_list_user_application_list_id_seq', 6, true);


--
-- TOC entry 4032 (class 2606 OID 2447118)
-- Name: databasechangeloglock databasechangeloglock_pkey; Type: CONSTRAINT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.databasechangeloglock
    ADD CONSTRAINT databasechangeloglock_pkey PRIMARY KEY (id);


--
-- TOC entry 4034 (class 2606 OID 2447139)
-- Name: job_position pk_job_position; Type: CONSTRAINT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.job_position
    ADD CONSTRAINT pk_job_position PRIMARY KEY (job_position_id);


--
-- TOC entry 4040 (class 2606 OID 2447168)
-- Name: link_user_application_user_group pk_link_user_application_user_group; Type: CONSTRAINT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.link_user_application_user_group
    ADD CONSTRAINT pk_link_user_application_user_group PRIMARY KEY (link_user_application_user_group_id);


--
-- TOC entry 4036 (class 2606 OID 2447148)
-- Name: user_application_document pk_user_application_document; Type: CONSTRAINT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.user_application_document
    ADD CONSTRAINT pk_user_application_document PRIMARY KEY (user_application_document_id);


--
-- TOC entry 4038 (class 2606 OID 2447160)
-- Name: user_application_list pk_user_application_list; Type: CONSTRAINT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.user_application_list
    ADD CONSTRAINT pk_user_application_list PRIMARY KEY (user_application_list_id);


--
-- TOC entry 4044 (class 2606 OID 2447197)
-- Name: recruitment recruitment_idm_id_key; Type: CONSTRAINT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.recruitment
    ADD CONSTRAINT recruitment_idm_id_key UNIQUE (idm_id);


--
-- TOC entry 4049 (class 2606 OID 2447195)
-- Name: recruitment recruitment_pkey; Type: CONSTRAINT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.recruitment
    ADD CONSTRAINT recruitment_pkey PRIMARY KEY (id);


--
-- TOC entry 4042 (class 2606 OID 2447172)
-- Name: link_user_application_user_group uni_user_group; Type: CONSTRAINT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.link_user_application_user_group
    ADD CONSTRAINT uni_user_group UNIQUE (user_application_list_id, user_group_id);


--
-- TOC entry 3981 (class 2606 OID 2446858)
-- Name: databasechangeloglock databasechangeloglock_pkey; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.databasechangeloglock
    ADD CONSTRAINT databasechangeloglock_pkey PRIMARY KEY (id);


--
-- TOC entry 4019 (class 2606 OID 2447049)
-- Name: org_unit org_unit_code_key; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.org_unit
    ADD CONSTRAINT org_unit_code_key UNIQUE (code);


--
-- TOC entry 4023 (class 2606 OID 2447039)
-- Name: access_level pk_access_level; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.access_level
    ADD CONSTRAINT pk_access_level PRIMARY KEY (access_level_id);


--
-- TOC entry 4003 (class 2606 OID 2446972)
-- Name: authority pk_authority; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.authority
    ADD CONSTRAINT pk_authority PRIMARY KEY (authority_id);


--
-- TOC entry 4011 (class 2606 OID 2446999)
-- Name: simple_credentials pk_domestic_user; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.simple_credentials
    ADD CONSTRAINT pk_domestic_user PRIMARY KEY (user_account_id);


--
-- TOC entry 4013 (class 2606 OID 2447009)
-- Name: esia_user pk_esia_user; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.esia_user
    ADD CONSTRAINT pk_esia_user PRIMARY KEY (esia_user_id);


--
-- TOC entry 3991 (class 2606 OID 2446926)
-- Name: user_group pk_group; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.user_group
    ADD CONSTRAINT pk_group PRIMARY KEY (user_group_id);


--
-- TOC entry 3995 (class 2606 OID 2446933)
-- Name: link_user_group_user_role pk_group_role; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.link_user_group_user_role
    ADD CONSTRAINT pk_group_role PRIMARY KEY (link_user_group_user_role_id);


--
-- TOC entry 4021 (class 2606 OID 2447024)
-- Name: org_unit pk_org_unit; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.org_unit
    ADD CONSTRAINT pk_org_unit PRIMARY KEY (id);


--
-- TOC entry 4052 (class 2606 OID 2447208)
-- Name: org_unit_additional_info pk_org_unit_additional_info; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.org_unit_additional_info
    ADD CONSTRAINT pk_org_unit_additional_info PRIMARY KEY (id);


--
-- TOC entry 3987 (class 2606 OID 2446893)
-- Name: user_role pk_role; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.user_role
    ADD CONSTRAINT pk_role PRIMARY KEY (user_role_id);


--
-- TOC entry 4007 (class 2606 OID 2446979)
-- Name: link_user_role_authority pk_role_authority; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.link_user_role_authority
    ADD CONSTRAINT pk_role_authority PRIMARY KEY (user_role_authority_id);


--
-- TOC entry 3983 (class 2606 OID 2446868)
-- Name: user_account pk_user; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.user_account
    ADD CONSTRAINT pk_user PRIMARY KEY (user_account_id);


--
-- TOC entry 4028 (class 2606 OID 2447070)
-- Name: user_account_refresh_token pk_user_account_refresh_token; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.user_account_refresh_token
    ADD CONSTRAINT pk_user_account_refresh_token PRIMARY KEY (user_account_refresh_token_id);


--
-- TOC entry 4030 (class 2606 OID 2447099)
-- Name: user_account_verification pk_user_account_verification; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.user_account_verification
    ADD CONSTRAINT pk_user_account_verification PRIMARY KEY (user_account_id);


--
-- TOC entry 3999 (class 2606 OID 2446952)
-- Name: link_user_account_user_group pk_user_group; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.link_user_account_user_group
    ADD CONSTRAINT pk_user_group PRIMARY KEY (link_user_account_user_group_id);


--
-- TOC entry 4025 (class 2606 OID 2447041)
-- Name: access_level uni_access_level; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.access_level
    ADD CONSTRAINT uni_access_level UNIQUE (level);


--
-- TOC entry 4005 (class 2606 OID 2446974)
-- Name: authority uni_authority_name; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.authority
    ADD CONSTRAINT uni_authority_name UNIQUE (name);


--
-- TOC entry 4015 (class 2606 OID 2447011)
-- Name: esia_user uni_esia_user1; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.esia_user
    ADD CONSTRAINT uni_esia_user1 UNIQUE (user_account_id);


--
-- TOC entry 4017 (class 2606 OID 2447013)
-- Name: esia_user uni_esia_user2; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.esia_user
    ADD CONSTRAINT uni_esia_user2 UNIQUE (person_contact_id);


--
-- TOC entry 3993 (class 2606 OID 2446928)
-- Name: user_group uni_group_name; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.user_group
    ADD CONSTRAINT uni_group_name UNIQUE (name);


--
-- TOC entry 3997 (class 2606 OID 2446937)
-- Name: link_user_group_user_role uni_group_role; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.link_user_group_user_role
    ADD CONSTRAINT uni_group_role UNIQUE (user_group_id, user_role_id);


--
-- TOC entry 4009 (class 2606 OID 2446983)
-- Name: link_user_role_authority uni_role_authority; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.link_user_role_authority
    ADD CONSTRAINT uni_role_authority UNIQUE (user_role_id, authority_id);


--
-- TOC entry 3989 (class 2606 OID 2446895)
-- Name: user_role uni_role_name; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.user_role
    ADD CONSTRAINT uni_role_name UNIQUE (name);


--
-- TOC entry 4001 (class 2606 OID 2446956)
-- Name: link_user_account_user_group uni_user_group; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.link_user_account_user_group
    ADD CONSTRAINT uni_user_group UNIQUE (user_account_id, user_group_id);


--
-- TOC entry 3985 (class 2606 OID 2447092)
-- Name: user_account user_account_username_unique; Type: CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.user_account
    ADD CONSTRAINT user_account_username_unique UNIQUE (username);


--
-- TOC entry 4045 (class 1259 OID 2447198)
-- Name: recruitment_idm_idx; Type: INDEX; Schema: public; Owner: ervu_account_applications
--

CREATE INDEX recruitment_idm_idx ON public.recruitment USING btree (idm_id);


--
-- TOC entry 4046 (class 1259 OID 2447199)
-- Name: recruitment_military_code_idx; Type: INDEX; Schema: public; Owner: ervu_account_applications
--

CREATE INDEX recruitment_military_code_idx ON public.recruitment USING btree (military_code);


--
-- TOC entry 4047 (class 1259 OID 2447200)
-- Name: recruitment_parent_idx; Type: INDEX; Schema: public; Owner: ervu_account_applications
--

CREATE INDEX recruitment_parent_idx ON public.recruitment USING btree (parent_id);


--
-- TOC entry 4050 (class 1259 OID 2447201)
-- Name: recruitment_region_idx; Type: INDEX; Schema: public; Owner: ervu_account_applications
--

CREATE INDEX recruitment_region_idx ON public.recruitment USING btree (region_id);


--
-- TOC entry 4026 (class 1259 OID 2447076)
-- Name: idx_refresh_token_user_account_id; Type: INDEX; Schema: security; Owner: ervu_account_applications
--

CREATE INDEX idx_refresh_token_user_account_id ON security.user_account_refresh_token USING btree (user_account_id);


--
-- TOC entry 4066 (class 2606 OID 2447173)
-- Name: link_user_application_user_group fk_user_application_list; Type: FK CONSTRAINT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.link_user_application_user_group
    ADD CONSTRAINT fk_user_application_list FOREIGN KEY (user_application_list_id) REFERENCES public.user_application_list(user_application_list_id) ON DELETE CASCADE;


--
-- TOC entry 4067 (class 2606 OID 2447178)
-- Name: link_user_application_user_group fk_user_group; Type: FK CONSTRAINT; Schema: public; Owner: ervu_account_applications
--

ALTER TABLE ONLY public.link_user_application_user_group
    ADD CONSTRAINT fk_user_group FOREIGN KEY (user_group_id) REFERENCES security.user_group(user_group_id);


--
-- TOC entry 4061 (class 2606 OID 2447000)
-- Name: simple_credentials fk_domestic_user1; Type: FK CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.simple_credentials
    ADD CONSTRAINT fk_domestic_user1 FOREIGN KEY (user_account_id) REFERENCES security.user_account(user_account_id) ON DELETE CASCADE;


--
-- TOC entry 4062 (class 2606 OID 2447014)
-- Name: esia_user fk_esia_user1; Type: FK CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.esia_user
    ADD CONSTRAINT fk_esia_user1 FOREIGN KEY (user_account_id) REFERENCES security.user_account(user_account_id);


--
-- TOC entry 4055 (class 2606 OID 2446938)
-- Name: link_user_group_user_role fk_group_role_group; Type: FK CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.link_user_group_user_role
    ADD CONSTRAINT fk_group_role_group FOREIGN KEY (user_group_id) REFERENCES security.user_group(user_group_id) ON DELETE CASCADE;


--
-- TOC entry 4056 (class 2606 OID 2446943)
-- Name: link_user_group_user_role fk_group_role_role; Type: FK CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.link_user_group_user_role
    ADD CONSTRAINT fk_group_role_role FOREIGN KEY (user_role_id) REFERENCES security.user_role(user_role_id);


--
-- TOC entry 4063 (class 2606 OID 2447025)
-- Name: org_unit fk_org_unit_parent_id; Type: FK CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.org_unit
    ADD CONSTRAINT fk_org_unit_parent_id FOREIGN KEY (parent_id) REFERENCES security.org_unit(id) ON DELETE SET NULL;


--
-- TOC entry 4059 (class 2606 OID 2446989)
-- Name: link_user_role_authority fk_role_authority_authority; Type: FK CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.link_user_role_authority
    ADD CONSTRAINT fk_role_authority_authority FOREIGN KEY (authority_id) REFERENCES security.authority(authority_id);


--
-- TOC entry 4060 (class 2606 OID 2446984)
-- Name: link_user_role_authority fk_role_authority_role; Type: FK CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.link_user_role_authority
    ADD CONSTRAINT fk_role_authority_role FOREIGN KEY (user_role_id) REFERENCES security.user_role(user_role_id) ON DELETE CASCADE;


--
-- TOC entry 4064 (class 2606 OID 2447071)
-- Name: user_account_refresh_token fk_user_account_refresh_token; Type: FK CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.user_account_refresh_token
    ADD CONSTRAINT fk_user_account_refresh_token FOREIGN KEY (user_account_id) REFERENCES security.user_account(user_account_id) ON DELETE CASCADE;


--
-- TOC entry 4065 (class 2606 OID 2447100)
-- Name: user_account_verification fk_user_account_user_account_verification; Type: FK CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.user_account_verification
    ADD CONSTRAINT fk_user_account_user_account_verification FOREIGN KEY (user_account_id) REFERENCES security.user_account(user_account_id) ON DELETE CASCADE;


--
-- TOC entry 4054 (class 2606 OID 2447042)
-- Name: user_group fk_user_group_access_level; Type: FK CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.user_group
    ADD CONSTRAINT fk_user_group_access_level FOREIGN KEY (access_level_id) REFERENCES security.access_level(access_level_id);


--
-- TOC entry 4057 (class 2606 OID 2446962)
-- Name: link_user_account_user_group fk_user_group_group; Type: FK CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.link_user_account_user_group
    ADD CONSTRAINT fk_user_group_group FOREIGN KEY (user_group_id) REFERENCES security.user_group(user_group_id);


--
-- TOC entry 4058 (class 2606 OID 2446957)
-- Name: link_user_account_user_group fk_user_group_user; Type: FK CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.link_user_account_user_group
    ADD CONSTRAINT fk_user_group_user FOREIGN KEY (user_account_id) REFERENCES security.user_account(user_account_id) ON DELETE CASCADE;


--
-- TOC entry 4053 (class 2606 OID 2447030)
-- Name: user_account fk_user_org_unit_id; Type: FK CONSTRAINT; Schema: security; Owner: ervu_account_applications
--

ALTER TABLE ONLY security.user_account
    ADD CONSTRAINT fk_user_org_unit_id FOREIGN KEY (org_unit_id) REFERENCES security.org_unit(id);


-- Completed on 2024-11-27 13:25:53

--
-- PostgreSQL database dump complete
--

