123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269 |
- --
- -- 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;
- SET default_tablespace = '';
- SET default_table_access_method = heap;
- --
- -- Name: current_cars; Type: TABLE; Schema: public; Owner: postgres
- --
- CREATE TABLE public.current_cars (
- id integer NOT NULL,
- resource_id integer NOT NULL,
- user_id integer NOT NULL,
- order_status character(1),
- order_id character(1),
- current_token name NOT NULL,
- doors_output character(1) NOT NULL,
- engine_input character(1) NOT NULL,
- central_lock_input character(1) NOT NULL,
- ignition_input character(1) NOT NULL,
- doors_input character(1) NOT NULL,
- input4 name,
- controller_status character(1) NOT NULL,
- signal_gsm integer NOT NULL,
- operator_gsm name NOT NULL,
- signal_gps integer NOT NULL,
- location character varying(30),
- speed real NOT NULL,
- direction character(1) NOT NULL,
- address name NOT NULL,
- battery_level integer NOT NULL,
- board_voltage real NOT NULL
- );
- ALTER TABLE public.current_cars OWNER TO postgres;
- --
- -- Name: current_cars_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
- --
- CREATE SEQUENCE public.current_cars_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.current_cars_id_seq OWNER TO postgres;
- --
- -- Name: current_cars_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
- --
- ALTER SEQUENCE public.current_cars_id_seq OWNED BY public.current_cars.id;
- --
- -- Name: current_timetable; Type: TABLE; Schema: public; Owner: postgres
- --
- CREATE TABLE public.current_timetable (
- id integer NOT NULL,
- order_id integer NOT NULL,
- service_type_id integer NOT NULL,
- provider_id integer,
- resource_id integer NOT NULL,
- time_start_predicted timestamp with time zone,
- time_finished_predicted timestamp with time zone,
- gap integer
- );
- ALTER TABLE public.current_timetable OWNER TO postgres;
- --
- -- Name: current_timetable_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
- --
- CREATE SEQUENCE public.current_timetable_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.current_timetable_id_seq OWNER TO postgres;
- --
- -- Name: current_timetable_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
- --
- ALTER SEQUENCE public.current_timetable_id_seq OWNED BY public.current_timetable.id;
- --
- -- Name: order_list_log; Type: TABLE; Schema: public; Owner: postgres
- --
- CREATE TABLE public.order_list_log (
- id integer NOT NULL,
- payment_transaction_id integer NOT NULL,
- service_id integer NOT NULL,
- service_type_id integer NOT NULL,
- time_placed timestamp with time zone NOT NULL,
- time_start timestamp with time zone NOT NULL,
- time_finish_predicted timestamp with time zone,
- time_finish_real timestamp with time zone NOT NULL,
- order_place_start character varying(255) NOT NULL,
- order_place_predicted character varying(255) NOT NULL,
- order_place_real character varying(255) NOT NULL,
- price money NOT NULL,
- provider integer NOT NULL,
- receiver integer NOT NULL,
- client integer NOT NULL
- );
- ALTER TABLE public.order_list_log OWNER TO postgres;
- --
- -- Name: order_list_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
- --
- CREATE SEQUENCE public.order_list_log_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.order_list_log_id_seq OWNER TO postgres;
- --
- -- Name: order_list_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
- --
- ALTER SEQUENCE public.order_list_log_id_seq OWNED BY public.order_list_log.id;
- --
- -- Name: tickets; Type: TABLE; Schema: public; Owner: postgres
- --
- CREATE TABLE public.tickets (
- id integer NOT NULL,
- type character(1) NOT NULL,
- id_reporter integer NOT NULL,
- id_asignee integer,
- time_created timestamp with time zone NOT NULL,
- time_assigned timestamp with time zone,
- time_changed timestamp with time zone,
- time_closed timestamp with time zone,
- status character(1) NOT NULL,
- description text
- );
- ALTER TABLE public.tickets OWNER TO postgres;
- --
- -- Name: tickets_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
- --
- CREATE SEQUENCE public.tickets_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.tickets_id_seq OWNER TO postgres;
- --
- -- Name: tickets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
- --
- ALTER SEQUENCE public.tickets_id_seq OWNED BY public.tickets.id;
- --
- -- Name: current_cars id; Type: DEFAULT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY public.current_cars ALTER COLUMN id SET DEFAULT nextval('public.current_cars_id_seq'::regclass);
- --
- -- Name: current_timetable id; Type: DEFAULT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY public.current_timetable ALTER COLUMN id SET DEFAULT nextval('public.current_timetable_id_seq'::regclass);
- --
- -- Name: order_list_log id; Type: DEFAULT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY public.order_list_log ALTER COLUMN id SET DEFAULT nextval('public.order_list_log_id_seq'::regclass);
- --
- -- Name: tickets id; Type: DEFAULT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY public.tickets ALTER COLUMN id SET DEFAULT nextval('public.tickets_id_seq'::regclass);
- --
- -- Name: current_cars current_cars_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY public.current_cars
- ADD CONSTRAINT current_cars_pkey PRIMARY KEY (id);
- --
- -- Name: current_timetable current_timetable_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY public.current_timetable
- ADD CONSTRAINT current_timetable_pkey PRIMARY KEY (id);
- --
- -- Name: order_list_log order_list_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY public.order_list_log
- ADD CONSTRAINT order_list_log_pkey PRIMARY KEY (id);
- --
- -- Name: tickets tickets_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY public.tickets
- ADD CONSTRAINT tickets_pkey PRIMARY KEY (id);
- --
- -- PostgreSQL database dump complete
- --
|