open-init-db/dbschema/sharix_open_synced_testdata.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 12.7
-- Dumped by pg_dump version 12.7

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;

--
-- Data for Name: client; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.client (id, user_id, requirements, status, ticket_status, id_metaservice, is_global, is_visible) FROM stdin;
1	1	требования для получения клиентск	A	1	1	t	f
2	2	требования для получения клиентск	A	2	2	t	f
3	3	требования для получения клиентск	A	3	3	t	f
\.


--
-- Data for Name: company; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.company (id, legal_name, repr_id, kpp, ogrn, bank_name, bik, ks, rs, address, id_metaservice, is_global, is_visible, requirements, status, ticket_status) FROM stdin;
1768457325	Юрий Александрович Смолин	1	876753121	7845637495863	HtGdtesgG	983744234	3	5	JhduYdyd	1	t	f	code	A	1
1739503233	Анна Юрьевна Соловьева	2	876753121	7845637495863	HtGdtesgG	983744234	1	2	JhduYdyd	1	t	f	code	A	1
1739523233	Некрасов Олег Алексеевич	3	876753121	7845637495863	HtGdtesgG	983744234	3	3	JhduYdyd	3	t	f	code	A	1
\.


--
-- Data for Name: provider; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.provider (id, type, id_company, user_id, requirements, status, ticket_status, id_metaservice, is_global, is_visible, location_type, default_location) FROM stdin;
1	1	1	1	код для активного ресурса	A	1	1	t	f	статическая	default location
2	2	2	2	код для активного ресурса	A	2	2	t	f	динамическая	default location
3	3	3	3	код для активного ресурса	A	3	3	t	f	динамическая	default location
\.


--
-- Data for Name: resource; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.resource (id, type_id, user_id, requirements, status, ticket_status, id_metaservice, is_global, is_visible) FROM stdin;
1	1	1	код активного ресурса	A	1	1	t	f
2	2	2	код активного ресурса	A	2	2	t	f
3	3	3	код активного ресурса	A	3	3	t	f
\.


--
-- Data for Name: servicetype; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.servicetype (id, caption, description, pricetype, id_metaservice, is_global, is_visible, requirements, status, ticket_status) FROM stdin;
1	Наименование услуги	описание услуги	1	1	t	f	fsdkjh	A	1
2	Наименование услуги	описание услуги	2	2	t	f	fsdkjh	A	1
3	Наименование услуги	описание услуги	3	3	t	f	fsdkjh	A	1
\.


--
-- Data for Name: service; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.service (id, servicetype_id, id_provider, resourse_id, price_alg, price_km, price_min, price_amount, id_metaservice, is_global, is_visible, requirements, status, ticket_status) FROM stdin;
1	1	1	1	sdf87675312-sdfsdf=sfer	212,00 ₽	13,00 ₽	1 415,00 ₽	1	t	f	fsdkjh	A	1
2	2	2	2	sdf87675312-sdfsdf=sfer	212,00 ₽	13,00 ₽	1 415,00 ₽	1	t	f	fsdkjh	A	1
3	3	3	3	sdf87675312-sdfsdf=sfer	212,00 ₽	13,00 ₽	1 415,00 ₽	1	t	f	fsdkjh	A	1
\.


--
-- Data for Name: current_orders; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.current_orders (id, service_id, service_type_id, state, id_metaservice, time_created, time_placed, time_start, time_finish_predicted, time_finish_real, provider_id, receiver_id, client_id, predicted_price, real_price, is_global, is_visible) FROM stdin;
1	1	1	1	1	2022-04-17 01:02:03+03	2022-04-17 01:02:03+03	2022-04-17 01:02:03+03	2022-04-17 01:02:03+03	2022-04-17 01:02:03+03	1	1	1	435,66 ₽	546 987,88 ₽	t	f
2	2	2	2	2	2022-04-17 01:02:03+03	2022-04-17 01:02:03+03	2022-04-17 01:02:03+03	2022-04-17 01:02:03+03	2022-04-17 01:02:03+03	2	2	2	435,66 ₽	546 987,88 ₽	t	f
3	3	3	3	3	2022-04-17 01:02:03+03	2022-04-17 01:02:03+03	2022-04-17 01:02:03+03	2022-04-17 01:02:03+03	2022-04-17 01:02:03+03	3	3	3	435,66 ₽	546 987,88 ₽	t	f
\.


--
-- Data for Name: documents; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.documents (id, id_metaservice, doctype, expire_date, datalink, user_id, company_id, is_global, is_visible, check_level, check_by, check_date, status, ticket_status) FROM stdin;
5	1	99	2022-04-17	C:\\Folder	1	1768457325	t	f	C	1	2022-04-17 01:02:03+03	A	2
6	2	99	2022-04-17	C:\\Folder	2	1768457325	t	f	C	2	2022-04-17 01:02:03+03	A	2
7	3	99	2022-04-17	C:\\Folder	3	1768457325	t	f	C	2	2022-04-17 01:02:03+03	A	2
\.


--
-- Data for Name: permissions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.permissions (id, id_metaservice, id_permission, user_id, is_global, is_visible, check_level, check_by, check_date, status, ticket_status) FROM stdin;
1	1	1	1	t	f	C	1	2022-04-17 01:02:03+03	A	1
2	2	2	2	t	f	C	2	2022-04-17 01:02:03+03	A	2
3	3	3	3	t	f	C	3	2022-04-17 01:02:03+03	A	2
\.


--
-- Data for Name: relationship; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.relationship (id, user_id_who, user_id_whom, neg_type, id_metaservice, is_global, is_visible, requirements, status, ticket_status) FROM stdin;
1	1	1	1	1	t	f	код	A	1
2	2	2	2	2	t	f	код	A	2
3	3	3	3	3	t	f	код	A	3
\.


--
-- Name: client_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.client_id_seq', 3, true);


--
-- Name: company_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.company_id_seq', 1, false);


--
-- Name: current_orders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.current_orders_id_seq', 3, true);


--
-- Name: documents_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.documents_id_seq', 7, true);


--
-- Name: permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.permissions_id_seq', 3, true);


--
-- Name: provider_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.provider_id_seq', 3, true);


--
-- Name: relationship_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.relationship_id_seq', 3, true);


--
-- Name: resource_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.resource_id_seq', 3, true);


--
-- Name: service_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.service_id_seq', 3, true);


--
-- Name: servicetype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.servicetype_id_seq', 3, true);


--
-- PostgreSQL database dump complete
--