sharix_open_local_testdata.sql 2.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
  1. --
  2. -- PostgreSQL database dump
  3. --
  4. -- Dumped from database version 12.7
  5. -- Dumped by pg_dump version 12.7
  6. SET statement_timeout = 0;
  7. SET lock_timeout = 0;
  8. SET idle_in_transaction_session_timeout = 0;
  9. SET client_encoding = 'UTF8';
  10. SET standard_conforming_strings = on;
  11. SELECT pg_catalog.set_config('search_path', '', false);
  12. SET check_function_bodies = false;
  13. SET xmloption = content;
  14. SET client_min_messages = warning;
  15. SET row_security = off;
  16. --
  17. -- Data for Name: current_cars; Type: TABLE DATA; Schema: public; Owner: postgres
  18. --
  19. 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;
  20. \.
  21. --
  22. -- Data for Name: current_timetable; Type: TABLE DATA; Schema: public; Owner: postgres
  23. --
  24. COPY public.current_timetable (id, order_id, service_type_id, provider_id, resource_id, time_start_predicted, time_finished_predicted, gap) FROM stdin;
  25. \.
  26. --
  27. -- Data for Name: order_list_log; Type: TABLE DATA; Schema: public; Owner: postgres
  28. --
  29. 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;
  30. \.
  31. --
  32. -- Data for Name: tickets; Type: TABLE DATA; Schema: public; Owner: postgres
  33. --
  34. COPY public.tickets (id, type, id_reporter, id_asignee, time_created, time_assigned, time_changed, time_closed, status, description) FROM stdin;
  35. \.
  36. --
  37. -- Name: current_cars_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
  38. --
  39. SELECT pg_catalog.setval('public.current_cars_id_seq', 1, false);
  40. --
  41. -- Name: current_timetable_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
  42. --
  43. SELECT pg_catalog.setval('public.current_timetable_id_seq', 1, false);
  44. --
  45. -- Name: order_list_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
  46. --
  47. SELECT pg_catalog.setval('public.order_list_log_id_seq', 1, false);
  48. --
  49. -- Name: tickets_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
  50. --
  51. SELECT pg_catalog.setval('public.tickets_id_seq', 1, false);
  52. --
  53. -- PostgreSQL database dump complete
  54. --