open-init-db/sharix_open_testdata

--
-- 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: sharix
--

COPY public.client (id, userid, requirements, status, ticket_status, id_metaservice, is_visible, is_global) FROM stdin;
\.


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

COPY public.company (id, legalname, representative, inn, kpp, ogrn, bank_name, bik, ks, rs, address, requirements, status, ticket_status, id_metaservice, is_visible, is_global) FROM stdin;
\.


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

COPY public.current_orders (id, service_id, service_type_id, state, id_metaservice, time_placed, time_start, time_finish_predicted, time_finish_real, provider, receiver, client, predicted_price, real_price, is_visible, is_global) FROM stdin;
\.


--
-- Data for Name: current_timetable; Type: TABLE DATA; Schema: public; Owner: sharix
--

COPY public.current_timetable (id, order_id, service_type_id, provider_id, resource_id, time_start_predicted, time_finished_predicted, gap) FROM stdin;
\.


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

COPY public.documents (id, id_metaservice, doctype, datalink, userid, company_id, is_visible, is_global, check_level, checked_by, check_date, status, ticket_status) FROM stdin;
\.


--
-- Data for Name: order_list_log; Type: TABLE DATA; Schema: public; Owner: sharix
--

COPY public.order_list_log (id, payment_transaction_id, service_id, time_placed, time_start, time_finish_predicted, time_finish_real, order_place_start, order_place_predicted, order_place_real, price, provider, receiver, client) FROM stdin;
\.


--
-- Data for Name: orders; Type: TABLE DATA; Schema: public; Owner: drive
--

COPY public.orders (id, car, model, color, rate, customer, organization, start, final, adress) FROM stdin;
\.


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

COPY public.permissions (id, id_metaservice, id_permission, user_id, is_visible, is_global, check_level, checked_by, check_date, status, ticket_status) FROM stdin;
\.


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

COPY public.provider (id, type, company, userid, id_metaservice, requirements, status, ticket_status, is_visible, is_global, location_type, default_location) FROM stdin;
\.


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

COPY public.relationship (id, user_id_who, user_id_whom, neg_type, id_metaservice, is_visible, requirements, status, ticket_status, is_global) FROM stdin;
\.


--
-- Data for Name: resources; Type: TABLE DATA; Schema: public; Owner: sharix
--

COPY public.resources (id, type_id, user_id, requirements, status, ticket_status, id_metaservice, is_visible, is_global) FROM stdin;
\.


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

COPY public.service (id, servicetype_id, id_provider, resource_id, requirements, id_metaservice, price_alg, price_km, price_min, price_amount, service_status, status, ticket_status, is_visible, is_global) FROM stdin;
\.


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

COPY public.servicetype (id, codename, caption, description, requirements, pricetype, status, ticket_status, id_metaservice, is_visible, is_global) FROM stdin;
\.


--
-- Data for Name: tickets; Type: TABLE DATA; Schema: public; Owner: sharix
--

COPY public.tickets (id, id_reporter, id_asignee, time_created, time_assigned, time_changed, time_closed, status, description) FROM stdin;
\.


--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: drive
--

COPY public.users (id, name, access, login, password) FROM stdin;
\.


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

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


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

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


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

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


--
-- Name: current_timetable_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sharix
--

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


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

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


--
-- Name: order_list_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sharix
--

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


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

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


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

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


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

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


--
-- Name: resources_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sharix
--

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


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

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


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

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


--
-- Name: tickets_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sharix
--

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


--
-- PostgreSQL database dump complete
--