-- -- 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: cars_log; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.cars_log (id, resource_id, time_log_created, operation, user_id) FROM stdin; 1 1 2022-04-17 22:59:55+03 O 23 \. -- -- Data for Name: metauser; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.metauser (id, email, name, surname, phone, password) FROM stdin; \. -- -- Data for Name: metaservice; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.metaservice (id, metaservicename, legalname, representative) FROM stdin; \. -- -- Data for Name: tickets; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.tickets (id, id_reporter, id_asignee, time_created, time_assigned, time_changed, time_closed, status, description) FROM stdin; \. -- -- 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; \. -- -- 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; \. -- -- Data for Name: current_cars; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.current_cars (id, resource_id, user_id, order_status, order_id, current_token, doors_output, engine_input, central_lock_input, ignition_input, doors_input, input4, controller_status, signal_gsm, operator_gsm, signal_gps, location, speed, direction, address, battery_level, board_voltage) FROM stdin; 1 1 1 \N \N ghjkdgfshkl C O C O C \N n 100 Мегафон 123 -22.951916, -43.2104872 90 N Тверская область, город Щёлково, ш 45 12.6 \. -- -- 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; \. -- -- 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; \. -- -- 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; \. -- -- 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; \. -- -- 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; \. -- -- Data for Name: current_resources; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.current_resources (id, resource_id, operation, user_id, current_token, state) FROM stdin; \. -- -- Data for Name: current_timetable; Type: TABLE DATA; Schema: public; Owner: postgres -- 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: document; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.document (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; \. -- -- Data for Name: order_list_log; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.order_list_log (id, payment_transaction_id, service_id, service_type_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: postgres -- COPY public.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; \. -- -- 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; \. -- -- 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; \. -- -- Data for Name: resource_log; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.resource_log (id, resource_id, operation, user_id) FROM stdin; \. -- -- Data for Name: user_to_metaservice; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.user_to_metaservice (id, user_id, id_metaservice, is_active, status) FROM stdin; \. -- -- Name: cars_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.cars_log_id_seq', 1, true); -- -- Name: client_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.client_id_seq', 1, false); -- -- Name: company_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.company_id_seq', 1, false); -- -- Name: current_cars_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.current_cars_id_seq', 1, true); -- -- Name: current_orders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.current_orders_id_seq', 1, false); -- -- Name: current_resources_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.current_resources_id_seq', 1, false); -- -- Name: current_timetable_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.current_timetable_id_seq', 1, false); -- -- Name: document_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.document_id_seq', 1, false); -- -- Name: metaservice_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.metaservice_id_seq', 1, false); -- -- Name: metauser_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.metauser_id_seq', 1, false); -- -- Name: order_list_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.order_list_log_id_seq', 1, false); -- -- Name: orders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.orders_id_seq', 1, false); -- -- Name: permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.permissions_id_seq', 1, false); -- -- Name: provider_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.provider_id_seq', 1, false); -- -- Name: relationship_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.relationship_id_seq', 1, false); -- -- Name: resource_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.resource_id_seq', 1, false); -- -- Name: resource_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.resource_log_id_seq', 1, false); -- -- Name: service_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.service_id_seq', 1, false); -- -- Name: servicetype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.servicetype_id_seq', 1, false); -- -- Name: tickets_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tickets_id_seq', 1, false); -- -- Name: user_to_metaservice_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.user_to_metaservice_id_seq', 1, false); -- -- PostgreSQL database dump complete --