· 7 years ago · Feb 27, 2019, 07:58 AM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.4.20
6-- Dumped by pg_dump version 9.6.11
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET idle_in_transaction_session_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SELECT pg_catalog.set_config('search_path', '', false);
14SET check_function_bodies = false;
15SET client_min_messages = warning;
16SET row_security = off;
17
18--
19-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
20--
21
22CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
23
24
25--
26-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
27--
28
29COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
30
31
32SET default_tablespace = '';
33
34SET default_with_oids = false;
35
36--
37-- Name: adonis_schema; Type: TABLE; Schema: public; Owner: root
38--
39
40CREATE TABLE public.adonis_schema (
41 id integer NOT NULL,
42 name character varying(255),
43 batch integer,
44 migration_time timestamp with time zone DEFAULT now()
45);
46
47
48ALTER TABLE public.adonis_schema OWNER TO root;
49
50--
51-- Name: adonis_schema_id_seq; Type: SEQUENCE; Schema: public; Owner: root
52--
53
54CREATE SEQUENCE public.adonis_schema_id_seq
55 START WITH 1
56 INCREMENT BY 1
57 NO MINVALUE
58 NO MAXVALUE
59 CACHE 1;
60
61
62ALTER TABLE public.adonis_schema_id_seq OWNER TO root;
63
64--
65-- Name: adonis_schema_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
66--
67
68ALTER SEQUENCE public.adonis_schema_id_seq OWNED BY public.adonis_schema.id;
69
70
71--
72-- Name: billing_history; Type: TABLE; Schema: public; Owner: root
73--
74
75CREATE TABLE public.billing_history (
76 id integer NOT NULL,
77 user_id integer,
78 payload json,
79 created_at timestamp with time zone,
80 updated_at timestamp with time zone
81);
82
83
84ALTER TABLE public.billing_history OWNER TO root;
85
86--
87-- Name: billing_history_id_seq; Type: SEQUENCE; Schema: public; Owner: root
88--
89
90CREATE SEQUENCE public.billing_history_id_seq
91 START WITH 1
92 INCREMENT BY 1
93 NO MINVALUE
94 NO MAXVALUE
95 CACHE 1;
96
97
98ALTER TABLE public.billing_history_id_seq OWNER TO root;
99
100--
101-- Name: billing_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
102--
103
104ALTER SEQUENCE public.billing_history_id_seq OWNED BY public.billing_history.id;
105
106
107--
108-- Name: countries; Type: TABLE; Schema: public; Owner: root
109--
110
111CREATE TABLE public.countries (
112 id integer NOT NULL,
113 title character varying(255),
114 price character varying(255),
115 currency character varying(255),
116 lnt character varying(255),
117 lng character varying(255),
118 info json,
119 created_at timestamp with time zone,
120 updated_at timestamp with time zone
121);
122
123
124ALTER TABLE public.countries OWNER TO root;
125
126--
127-- Name: countries_id_seq; Type: SEQUENCE; Schema: public; Owner: root
128--
129
130CREATE SEQUENCE public.countries_id_seq
131 START WITH 1
132 INCREMENT BY 1
133 NO MINVALUE
134 NO MAXVALUE
135 CACHE 1;
136
137
138ALTER TABLE public.countries_id_seq OWNER TO root;
139
140--
141-- Name: countries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
142--
143
144ALTER SEQUENCE public.countries_id_seq OWNED BY public.countries.id;
145
146
147--
148-- Name: devices; Type: TABLE; Schema: public; Owner: root
149--
150
151CREATE TABLE public.devices (
152 id integer NOT NULL,
153 shape_id integer,
154 uuid character varying(255),
155 iot_id character varying(255),
156 driver character varying(255),
157 status character varying(255),
158 locked integer,
159 charged integer,
160 info json,
161 created_at timestamp with time zone,
162 updated_at timestamp with time zone
163);
164
165
166ALTER TABLE public.devices OWNER TO root;
167
168--
169-- Name: devices_histories; Type: TABLE; Schema: public; Owner: root
170--
171
172CREATE TABLE public.devices_histories (
173 id integer NOT NULL,
174 device_id integer,
175 data json,
176 created_at timestamp with time zone,
177 updated_at timestamp with time zone
178);
179
180
181ALTER TABLE public.devices_histories OWNER TO root;
182
183--
184-- Name: devices_histories_id_seq; Type: SEQUENCE; Schema: public; Owner: root
185--
186
187CREATE SEQUENCE public.devices_histories_id_seq
188 START WITH 1
189 INCREMENT BY 1
190 NO MINVALUE
191 NO MAXVALUE
192 CACHE 1;
193
194
195ALTER TABLE public.devices_histories_id_seq OWNER TO root;
196
197--
198-- Name: devices_histories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
199--
200
201ALTER SEQUENCE public.devices_histories_id_seq OWNED BY public.devices_histories.id;
202
203
204--
205-- Name: devices_id_seq; Type: SEQUENCE; Schema: public; Owner: root
206--
207
208CREATE SEQUENCE public.devices_id_seq
209 START WITH 1
210 INCREMENT BY 1
211 NO MINVALUE
212 NO MAXVALUE
213 CACHE 1;
214
215
216ALTER TABLE public.devices_id_seq OWNER TO root;
217
218--
219-- Name: devices_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
220--
221
222ALTER SEQUENCE public.devices_id_seq OWNED BY public.devices.id;
223
224
225--
226-- Name: fcm_tokens; Type: TABLE; Schema: public; Owner: root
227--
228
229CREATE TABLE public.fcm_tokens (
230 id integer NOT NULL,
231 user_id integer,
232 token text,
233 os character varying(255),
234 device character varying(255),
235 created_at timestamp with time zone,
236 updated_at timestamp with time zone
237);
238
239
240ALTER TABLE public.fcm_tokens OWNER TO root;
241
242--
243-- Name: fcm_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: root
244--
245
246CREATE SEQUENCE public.fcm_tokens_id_seq
247 START WITH 1
248 INCREMENT BY 1
249 NO MINVALUE
250 NO MAXVALUE
251 CACHE 1;
252
253
254ALTER TABLE public.fcm_tokens_id_seq OWNER TO root;
255
256--
257-- Name: fcm_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
258--
259
260ALTER SEQUENCE public.fcm_tokens_id_seq OWNED BY public.fcm_tokens.id;
261
262
263--
264-- Name: logs; Type: TABLE; Schema: public; Owner: root
265--
266
267CREATE TABLE public.logs (
268 id integer NOT NULL,
269 entity_id integer,
270 entity_type character varying(255),
271 error_type character varying(255),
272 data json,
273 created_at timestamp with time zone,
274 updated_at timestamp with time zone
275);
276
277
278ALTER TABLE public.logs OWNER TO root;
279
280--
281-- Name: logs_id_seq; Type: SEQUENCE; Schema: public; Owner: root
282--
283
284CREATE SEQUENCE public.logs_id_seq
285 START WITH 1
286 INCREMENT BY 1
287 NO MINVALUE
288 NO MAXVALUE
289 CACHE 1;
290
291
292ALTER TABLE public.logs_id_seq OWNER TO root;
293
294--
295-- Name: logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
296--
297
298ALTER SEQUENCE public.logs_id_seq OWNED BY public.logs.id;
299
300
301--
302-- Name: manager_permission; Type: TABLE; Schema: public; Owner: root
303--
304
305CREATE TABLE public.manager_permission (
306 id integer NOT NULL,
307 permission_id integer,
308 manager_id integer
309);
310
311
312ALTER TABLE public.manager_permission OWNER TO root;
313
314--
315-- Name: manager_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: root
316--
317
318CREATE SEQUENCE public.manager_permission_id_seq
319 START WITH 1
320 INCREMENT BY 1
321 NO MINVALUE
322 NO MAXVALUE
323 CACHE 1;
324
325
326ALTER TABLE public.manager_permission_id_seq OWNER TO root;
327
328--
329-- Name: manager_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
330--
331
332ALTER SEQUENCE public.manager_permission_id_seq OWNED BY public.manager_permission.id;
333
334
335--
336-- Name: manager_role; Type: TABLE; Schema: public; Owner: root
337--
338
339CREATE TABLE public.manager_role (
340 id integer NOT NULL,
341 role_id integer,
342 manager_id integer
343);
344
345
346ALTER TABLE public.manager_role OWNER TO root;
347
348--
349-- Name: manager_role_id_seq; Type: SEQUENCE; Schema: public; Owner: root
350--
351
352CREATE SEQUENCE public.manager_role_id_seq
353 START WITH 1
354 INCREMENT BY 1
355 NO MINVALUE
356 NO MAXVALUE
357 CACHE 1;
358
359
360ALTER TABLE public.manager_role_id_seq OWNER TO root;
361
362--
363-- Name: manager_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
364--
365
366ALTER SEQUENCE public.manager_role_id_seq OWNED BY public.manager_role.id;
367
368
369--
370-- Name: managers; Type: TABLE; Schema: public; Owner: root
371--
372
373CREATE TABLE public.managers (
374 id integer NOT NULL,
375 login character varying(32) NOT NULL,
376 email character varying(254) NOT NULL,
377 password character varying(60) NOT NULL,
378 remember_token character varying(100),
379 last_name character varying(128),
380 first_name character varying(128),
381 created_at integer,
382 updated_at integer,
383 deleted_at integer
384);
385
386
387ALTER TABLE public.managers OWNER TO root;
388
389--
390-- Name: managers_id_seq; Type: SEQUENCE; Schema: public; Owner: root
391--
392
393CREATE SEQUENCE public.managers_id_seq
394 START WITH 1
395 INCREMENT BY 1
396 NO MINVALUE
397 NO MAXVALUE
398 CACHE 1;
399
400
401ALTER TABLE public.managers_id_seq OWNER TO root;
402
403--
404-- Name: managers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
405--
406
407ALTER SEQUENCE public.managers_id_seq OWNED BY public.managers.id;
408
409
410--
411-- Name: orders; Type: TABLE; Schema: public; Owner: root
412--
413
414CREATE TABLE public.orders (
415 id integer NOT NULL,
416 user_id integer,
417 coast character varying(255),
418 type character varying(255),
419 time_start character varying(255),
420 time_end character varying(255),
421 timezone integer,
422 created_at timestamp with time zone,
423 updated_at timestamp with time zone
424);
425
426
427ALTER TABLE public.orders OWNER TO root;
428
429--
430-- Name: orders_id_seq; Type: SEQUENCE; Schema: public; Owner: root
431--
432
433CREATE SEQUENCE public.orders_id_seq
434 START WITH 1
435 INCREMENT BY 1
436 NO MINVALUE
437 NO MAXVALUE
438 CACHE 1;
439
440
441ALTER TABLE public.orders_id_seq OWNER TO root;
442
443--
444-- Name: orders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
445--
446
447ALTER SEQUENCE public.orders_id_seq OWNED BY public.orders.id;
448
449
450--
451-- Name: pages; Type: TABLE; Schema: public; Owner: root
452--
453
454CREATE TABLE public.pages (
455 id integer NOT NULL,
456 title json,
457 description json,
458 meta_info json,
459 created_at timestamp with time zone,
460 updated_at timestamp with time zone
461);
462
463
464ALTER TABLE public.pages OWNER TO root;
465
466--
467-- Name: pages_id_seq; Type: SEQUENCE; Schema: public; Owner: root
468--
469
470CREATE SEQUENCE public.pages_id_seq
471 START WITH 1
472 INCREMENT BY 1
473 NO MINVALUE
474 NO MAXVALUE
475 CACHE 1;
476
477
478ALTER TABLE public.pages_id_seq OWNER TO root;
479
480--
481-- Name: pages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
482--
483
484ALTER SEQUENCE public.pages_id_seq OWNED BY public.pages.id;
485
486
487--
488-- Name: permission_role; Type: TABLE; Schema: public; Owner: root
489--
490
491CREATE TABLE public.permission_role (
492 id integer NOT NULL,
493 permission_id integer,
494 role_id integer
495);
496
497
498ALTER TABLE public.permission_role OWNER TO root;
499
500--
501-- Name: permission_role_id_seq; Type: SEQUENCE; Schema: public; Owner: root
502--
503
504CREATE SEQUENCE public.permission_role_id_seq
505 START WITH 1
506 INCREMENT BY 1
507 NO MINVALUE
508 NO MAXVALUE
509 CACHE 1;
510
511
512ALTER TABLE public.permission_role_id_seq OWNER TO root;
513
514--
515-- Name: permission_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
516--
517
518ALTER SEQUENCE public.permission_role_id_seq OWNED BY public.permission_role.id;
519
520
521--
522-- Name: permissions; Type: TABLE; Schema: public; Owner: root
523--
524
525CREATE TABLE public.permissions (
526 id integer NOT NULL,
527 slug character varying(255) NOT NULL,
528 name character varying(255) NOT NULL,
529 description text,
530 created_at integer,
531 updated_at integer
532);
533
534
535ALTER TABLE public.permissions OWNER TO root;
536
537--
538-- Name: permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: root
539--
540
541CREATE SEQUENCE public.permissions_id_seq
542 START WITH 1
543 INCREMENT BY 1
544 NO MINVALUE
545 NO MAXVALUE
546 CACHE 1;
547
548
549ALTER TABLE public.permissions_id_seq OWNER TO root;
550
551--
552-- Name: permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
553--
554
555ALTER SEQUENCE public.permissions_id_seq OWNED BY public.permissions.id;
556
557
558--
559-- Name: phones_confirmations; Type: TABLE; Schema: public; Owner: root
560--
561
562CREATE TABLE public.phones_confirmations (
563 id integer NOT NULL,
564 phone character varying(255),
565 code character varying(255),
566 life_time timestamp with time zone,
567 created_at timestamp with time zone,
568 updated_at timestamp with time zone
569);
570
571
572ALTER TABLE public.phones_confirmations OWNER TO root;
573
574--
575-- Name: phones_confirmations_id_seq; Type: SEQUENCE; Schema: public; Owner: root
576--
577
578CREATE SEQUENCE public.phones_confirmations_id_seq
579 START WITH 1
580 INCREMENT BY 1
581 NO MINVALUE
582 NO MAXVALUE
583 CACHE 1;
584
585
586ALTER TABLE public.phones_confirmations_id_seq OWNER TO root;
587
588--
589-- Name: phones_confirmations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
590--
591
592ALTER SEQUENCE public.phones_confirmations_id_seq OWNED BY public.phones_confirmations.id;
593
594
595--
596-- Name: rides_histories; Type: TABLE; Schema: public; Owner: root
597--
598
599CREATE TABLE public.rides_histories (
600 id integer NOT NULL,
601 device_id integer,
602 order_id integer,
603 lnt numeric(8,2),
604 lng numeric(8,2),
605 created_at timestamp with time zone,
606 updated_at timestamp with time zone
607);
608
609
610ALTER TABLE public.rides_histories OWNER TO root;
611
612--
613-- Name: rides_histories_id_seq; Type: SEQUENCE; Schema: public; Owner: root
614--
615
616CREATE SEQUENCE public.rides_histories_id_seq
617 START WITH 1
618 INCREMENT BY 1
619 NO MINVALUE
620 NO MAXVALUE
621 CACHE 1;
622
623
624ALTER TABLE public.rides_histories_id_seq OWNER TO root;
625
626--
627-- Name: rides_histories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
628--
629
630ALTER SEQUENCE public.rides_histories_id_seq OWNED BY public.rides_histories.id;
631
632
633--
634-- Name: roles; Type: TABLE; Schema: public; Owner: root
635--
636
637CREATE TABLE public.roles (
638 id integer NOT NULL,
639 slug character varying(255) NOT NULL,
640 name character varying(255) NOT NULL,
641 description text,
642 created_at integer,
643 updated_at integer
644);
645
646
647ALTER TABLE public.roles OWNER TO root;
648
649--
650-- Name: roles_id_seq; Type: SEQUENCE; Schema: public; Owner: root
651--
652
653CREATE SEQUENCE public.roles_id_seq
654 START WITH 1
655 INCREMENT BY 1
656 NO MINVALUE
657 NO MAXVALUE
658 CACHE 1;
659
660
661ALTER TABLE public.roles_id_seq OWNER TO root;
662
663--
664-- Name: roles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
665--
666
667ALTER SEQUENCE public.roles_id_seq OWNED BY public.roles.id;
668
669
670--
671-- Name: settings; Type: TABLE; Schema: public; Owner: root
672--
673
674CREATE TABLE public.settings (
675 id integer NOT NULL,
676 name character varying(255),
677 value text
678);
679
680
681ALTER TABLE public.settings OWNER TO root;
682
683--
684-- Name: settings_id_seq; Type: SEQUENCE; Schema: public; Owner: root
685--
686
687CREATE SEQUENCE public.settings_id_seq
688 START WITH 1
689 INCREMENT BY 1
690 NO MINVALUE
691 NO MAXVALUE
692 CACHE 1;
693
694
695ALTER TABLE public.settings_id_seq OWNER TO root;
696
697--
698-- Name: settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
699--
700
701ALTER SEQUENCE public.settings_id_seq OWNED BY public.settings.id;
702
703
704--
705-- Name: shapes; Type: TABLE; Schema: public; Owner: root
706--
707
708CREATE TABLE public.shapes (
709 id integer NOT NULL,
710 title character varying(255),
711 city character varying(255),
712 data json,
713 created_at timestamp with time zone,
714 updated_at timestamp with time zone,
715 country_id integer
716);
717
718
719ALTER TABLE public.shapes OWNER TO root;
720
721--
722-- Name: shapes_id_seq; Type: SEQUENCE; Schema: public; Owner: root
723--
724
725CREATE SEQUENCE public.shapes_id_seq
726 START WITH 1
727 INCREMENT BY 1
728 NO MINVALUE
729 NO MAXVALUE
730 CACHE 1;
731
732
733ALTER TABLE public.shapes_id_seq OWNER TO root;
734
735--
736-- Name: shapes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
737--
738
739ALTER SEQUENCE public.shapes_id_seq OWNED BY public.shapes.id;
740
741
742--
743-- Name: tokens; Type: TABLE; Schema: public; Owner: root
744--
745
746CREATE TABLE public.tokens (
747 id integer NOT NULL,
748 manager_id integer,
749 token character varying(255) NOT NULL,
750 type character varying(80) NOT NULL,
751 is_revoked boolean DEFAULT false,
752 created_at timestamp with time zone,
753 updated_at timestamp with time zone
754);
755
756
757ALTER TABLE public.tokens OWNER TO root;
758
759--
760-- Name: tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: root
761--
762
763CREATE SEQUENCE public.tokens_id_seq
764 START WITH 1
765 INCREMENT BY 1
766 NO MINVALUE
767 NO MAXVALUE
768 CACHE 1;
769
770
771ALTER TABLE public.tokens_id_seq OWNER TO root;
772
773--
774-- Name: tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
775--
776
777ALTER SEQUENCE public.tokens_id_seq OWNED BY public.tokens.id;
778
779
780--
781-- Name: users; Type: TABLE; Schema: public; Owner: root
782--
783
784CREATE TABLE public.users (
785 id integer NOT NULL,
786 username character varying(255),
787 email character varying(255),
788 password character varying(60),
789 avatar character varying(255),
790 timezone integer,
791 is_blocked integer,
792 created_at timestamp with time zone,
793 updated_at timestamp with time zone,
794 phone character varying(255)
795);
796
797
798ALTER TABLE public.users OWNER TO root;
799
800--
801-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: root
802--
803
804CREATE SEQUENCE public.users_id_seq
805 START WITH 1
806 INCREMENT BY 1
807 NO MINVALUE
808 NO MAXVALUE
809 CACHE 1;
810
811
812ALTER TABLE public.users_id_seq OWNER TO root;
813
814--
815-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
816--
817
818ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
819
820
821--
822-- Name: adonis_schema id; Type: DEFAULT; Schema: public; Owner: root
823--
824
825ALTER TABLE ONLY public.adonis_schema ALTER COLUMN id SET DEFAULT nextval('public.adonis_schema_id_seq'::regclass);
826
827
828--
829-- Name: billing_history id; Type: DEFAULT; Schema: public; Owner: root
830--
831
832ALTER TABLE ONLY public.billing_history ALTER COLUMN id SET DEFAULT nextval('public.billing_history_id_seq'::regclass);
833
834
835--
836-- Name: countries id; Type: DEFAULT; Schema: public; Owner: root
837--
838
839ALTER TABLE ONLY public.countries ALTER COLUMN id SET DEFAULT nextval('public.countries_id_seq'::regclass);
840
841
842--
843-- Name: devices id; Type: DEFAULT; Schema: public; Owner: root
844--
845
846ALTER TABLE ONLY public.devices ALTER COLUMN id SET DEFAULT nextval('public.devices_id_seq'::regclass);
847
848
849--
850-- Name: devices_histories id; Type: DEFAULT; Schema: public; Owner: root
851--
852
853ALTER TABLE ONLY public.devices_histories ALTER COLUMN id SET DEFAULT nextval('public.devices_histories_id_seq'::regclass);
854
855
856--
857-- Name: fcm_tokens id; Type: DEFAULT; Schema: public; Owner: root
858--
859
860ALTER TABLE ONLY public.fcm_tokens ALTER COLUMN id SET DEFAULT nextval('public.fcm_tokens_id_seq'::regclass);
861
862
863--
864-- Name: logs id; Type: DEFAULT; Schema: public; Owner: root
865--
866
867ALTER TABLE ONLY public.logs ALTER COLUMN id SET DEFAULT nextval('public.logs_id_seq'::regclass);
868
869
870--
871-- Name: manager_permission id; Type: DEFAULT; Schema: public; Owner: root
872--
873
874ALTER TABLE ONLY public.manager_permission ALTER COLUMN id SET DEFAULT nextval('public.manager_permission_id_seq'::regclass);
875
876
877--
878-- Name: manager_role id; Type: DEFAULT; Schema: public; Owner: root
879--
880
881ALTER TABLE ONLY public.manager_role ALTER COLUMN id SET DEFAULT nextval('public.manager_role_id_seq'::regclass);
882
883
884--
885-- Name: managers id; Type: DEFAULT; Schema: public; Owner: root
886--
887
888ALTER TABLE ONLY public.managers ALTER COLUMN id SET DEFAULT nextval('public.managers_id_seq'::regclass);
889
890
891--
892-- Name: orders id; Type: DEFAULT; Schema: public; Owner: root
893--
894
895ALTER TABLE ONLY public.orders ALTER COLUMN id SET DEFAULT nextval('public.orders_id_seq'::regclass);
896
897
898--
899-- Name: pages id; Type: DEFAULT; Schema: public; Owner: root
900--
901
902ALTER TABLE ONLY public.pages ALTER COLUMN id SET DEFAULT nextval('public.pages_id_seq'::regclass);
903
904
905--
906-- Name: permission_role id; Type: DEFAULT; Schema: public; Owner: root
907--
908
909ALTER TABLE ONLY public.permission_role ALTER COLUMN id SET DEFAULT nextval('public.permission_role_id_seq'::regclass);
910
911
912--
913-- Name: permissions id; Type: DEFAULT; Schema: public; Owner: root
914--
915
916ALTER TABLE ONLY public.permissions ALTER COLUMN id SET DEFAULT nextval('public.permissions_id_seq'::regclass);
917
918
919--
920-- Name: phones_confirmations id; Type: DEFAULT; Schema: public; Owner: root
921--
922
923ALTER TABLE ONLY public.phones_confirmations ALTER COLUMN id SET DEFAULT nextval('public.phones_confirmations_id_seq'::regclass);
924
925
926--
927-- Name: rides_histories id; Type: DEFAULT; Schema: public; Owner: root
928--
929
930ALTER TABLE ONLY public.rides_histories ALTER COLUMN id SET DEFAULT nextval('public.rides_histories_id_seq'::regclass);
931
932
933--
934-- Name: roles id; Type: DEFAULT; Schema: public; Owner: root
935--
936
937ALTER TABLE ONLY public.roles ALTER COLUMN id SET DEFAULT nextval('public.roles_id_seq'::regclass);
938
939
940--
941-- Name: settings id; Type: DEFAULT; Schema: public; Owner: root
942--
943
944ALTER TABLE ONLY public.settings ALTER COLUMN id SET DEFAULT nextval('public.settings_id_seq'::regclass);
945
946
947--
948-- Name: shapes id; Type: DEFAULT; Schema: public; Owner: root
949--
950
951ALTER TABLE ONLY public.shapes ALTER COLUMN id SET DEFAULT nextval('public.shapes_id_seq'::regclass);
952
953
954--
955-- Name: tokens id; Type: DEFAULT; Schema: public; Owner: root
956--
957
958ALTER TABLE ONLY public.tokens ALTER COLUMN id SET DEFAULT nextval('public.tokens_id_seq'::regclass);
959
960
961--
962-- Name: users id; Type: DEFAULT; Schema: public; Owner: root
963--
964
965ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);
966
967
968--
969-- Data for Name: adonis_schema; Type: TABLE DATA; Schema: public; Owner: root
970--
971
972COPY public.adonis_schema (id, name, batch, migration_time) FROM stdin;
97319 1545315703006_managers_schema 1 2019-02-24 11:21:57.944679+00
97420 1545315703007_manager_token 1 2019-02-24 11:21:58.271057+00
97521 1546617438208_create_permissions_table 1 2019-02-24 11:21:58.462062+00
97622 1546617438226_create_roles_table 1 2019-02-24 11:21:58.665853+00
97723 1546617438229_create_permission_role_table 1 2019-02-24 11:21:58.826318+00
97824 1546617438230_create_manager_permission_table 1 2019-02-24 11:21:59.06757+00
97925 1546617438232_create_manager_role_table 1 2019-02-24 11:21:59.395416+00
98026 1547040838156_create_users_schema 1 2019-02-24 11:21:59.496079+00
98127 1547117215133_create_billing_history_schema 1 2019-02-24 11:21:59.628349+00
98228 1547117482004_create_fcm_tokens_schema 1 2019-02-24 11:21:59.742675+00
98329 1547117553166_create_logs_schema 1 2019-02-24 11:21:59.884937+00
98430 1547117661601_create_settings_schema 1 2019-02-24 11:22:00.000873+00
98531 1550584127982_create_devices_schema 1 2019-02-24 11:22:00.118584+00
98632 1550584559020_create_shapes_schema 1 2019-02-24 11:22:00.247669+00
98733 1550584577283_create_rides_history_schema 1 2019-02-24 11:22:00.315056+00
98834 1550584641014_create_orders_schema 1 2019-02-24 11:22:00.429105+00
98935 1550584655645_create_devices_history_schema 1 2019-02-24 11:22:00.54259+00
99036 1550584668489_create_pages_schema 1 2019-02-24 11:22:00.65636+00
99137 1551128842312_create_countries_schema 2 2019-02-25 21:12:36.479687+00
99238 1551187658646_create_phones_confirmations_schema 3 2019-02-26 17:37:48.291974+00
993\.
994
995
996--
997-- Name: adonis_schema_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
998--
999
1000SELECT pg_catalog.setval('public.adonis_schema_id_seq', 38, true);
1001
1002
1003--
1004-- Data for Name: billing_history; Type: TABLE DATA; Schema: public; Owner: root
1005--
1006
1007COPY public.billing_history (id, user_id, payload, created_at, updated_at) FROM stdin;
1008\.
1009
1010
1011--
1012-- Name: billing_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1013--
1014
1015SELECT pg_catalog.setval('public.billing_history_id_seq', 1, false);
1016
1017
1018--
1019-- Data for Name: countries; Type: TABLE DATA; Schema: public; Owner: root
1020--
1021
1022COPY public.countries (id, title, price, currency, lnt, lng, info, created_at, updated_at) FROM stdin;
1023\.
1024
1025
1026--
1027-- Name: countries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1028--
1029
1030SELECT pg_catalog.setval('public.countries_id_seq', 1, false);
1031
1032
1033--
1034-- Data for Name: devices; Type: TABLE DATA; Schema: public; Owner: root
1035--
1036
1037COPY public.devices (id, shape_id, uuid, iot_id, driver, status, locked, charged, info, created_at, updated_at) FROM stdin;
10385 1 dfhs534wt4322f2 dfhs534wt4322f2 Samsung active 0 90 \N 2019-02-24 11:32:01+00 2019-02-24 11:32:01+00
10397 4 sfgw4t24t45gd42t sfgw4t24t45gd42t Xiaomi active 1 99 \N 2019-02-24 11:32:44+00 2019-02-24 11:32:44+00
10402 1 fwefw2432fewf234 fwefw2432fewf234 Simens active 1 43 \N 2019-02-24 11:31:02+00 2019-02-24 11:31:02+00
10411 2 2343242fegg3rt3242 2343242fegg3rt3242 Samsung active 1 56 \N 2019-02-24 11:30:31+00 2019-02-24 11:30:31+00
10426 1 sghshsh43gwg2f4f sghshsh43gwg2f4f Xiaomi active 0 10 \N 2019-02-24 11:32:26+00 2019-02-24 11:32:26+00
10433 3 vdsvs43322greg43 vdsvs43322greg43 Xiaomi active 1 67 \N 2019-02-24 11:31:24+00 2019-02-24 11:31:24+00
10444 4 dsvsd23432fwfeg32 dsvsd23432fwfeg32 Simens active 1 80 \N 2019-02-24 11:31:43+00 2019-02-24 11:31:43+00
1045\.
1046
1047
1048--
1049-- Data for Name: devices_histories; Type: TABLE DATA; Schema: public; Owner: root
1050--
1051
1052COPY public.devices_histories (id, device_id, data, created_at, updated_at) FROM stdin;
1053\.
1054
1055
1056--
1057-- Name: devices_histories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1058--
1059
1060SELECT pg_catalog.setval('public.devices_histories_id_seq', 1, false);
1061
1062
1063--
1064-- Name: devices_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1065--
1066
1067SELECT pg_catalog.setval('public.devices_id_seq', 7, true);
1068
1069
1070--
1071-- Data for Name: fcm_tokens; Type: TABLE DATA; Schema: public; Owner: root
1072--
1073
1074COPY public.fcm_tokens (id, user_id, token, os, device, created_at, updated_at) FROM stdin;
10751 5 xedxedxedxedde iOS 2.2.3 \N \N
1076\.
1077
1078
1079--
1080-- Name: fcm_tokens_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1081--
1082
1083SELECT pg_catalog.setval('public.fcm_tokens_id_seq', 1, true);
1084
1085
1086--
1087-- Data for Name: logs; Type: TABLE DATA; Schema: public; Owner: root
1088--
1089
1090COPY public.logs (id, entity_id, entity_type, error_type, data, created_at, updated_at) FROM stdin;
1091\.
1092
1093
1094--
1095-- Name: logs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1096--
1097
1098SELECT pg_catalog.setval('public.logs_id_seq', 1, false);
1099
1100
1101--
1102-- Data for Name: manager_permission; Type: TABLE DATA; Schema: public; Owner: root
1103--
1104
1105COPY public.manager_permission (id, permission_id, manager_id) FROM stdin;
1106\.
1107
1108
1109--
1110-- Name: manager_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1111--
1112
1113SELECT pg_catalog.setval('public.manager_permission_id_seq', 1, false);
1114
1115
1116--
1117-- Data for Name: manager_role; Type: TABLE DATA; Schema: public; Owner: root
1118--
1119
1120COPY public.manager_role (id, role_id, manager_id) FROM stdin;
1121\.
1122
1123
1124--
1125-- Name: manager_role_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1126--
1127
1128SELECT pg_catalog.setval('public.manager_role_id_seq', 1, false);
1129
1130
1131--
1132-- Data for Name: managers; Type: TABLE DATA; Schema: public; Owner: root
1133--
1134
1135COPY public.managers (id, login, email, password, remember_token, last_name, first_name, created_at, updated_at, deleted_at) FROM stdin;
11361 manager admin@admin.com $2a$10$L6OH1GxOC6sPuNkjlLr2xO0jEZ4SWxWYd/ZHzK6WO4B.97kY7yit2 \N Admin Admin 1551007338 1551007338 \N
1137\.
1138
1139
1140--
1141-- Name: managers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1142--
1143
1144SELECT pg_catalog.setval('public.managers_id_seq', 2, true);
1145
1146
1147--
1148-- Data for Name: orders; Type: TABLE DATA; Schema: public; Owner: root
1149--
1150
1151COPY public.orders (id, user_id, coast, type, time_start, time_end, timezone, created_at, updated_at) FROM stdin;
1152\.
1153
1154
1155--
1156-- Name: orders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1157--
1158
1159SELECT pg_catalog.setval('public.orders_id_seq', 1, false);
1160
1161
1162--
1163-- Data for Name: pages; Type: TABLE DATA; Schema: public; Owner: root
1164--
1165
1166COPY public.pages (id, title, description, meta_info, created_at, updated_at) FROM stdin;
1167\.
1168
1169
1170--
1171-- Name: pages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1172--
1173
1174SELECT pg_catalog.setval('public.pages_id_seq', 1, false);
1175
1176
1177--
1178-- Data for Name: permission_role; Type: TABLE DATA; Schema: public; Owner: root
1179--
1180
1181COPY public.permission_role (id, permission_id, role_id) FROM stdin;
11821 1 1
11832 2 1
11843 3 1
11854 4 1
11865 5 2
11876 6 2
11887 7 2
11898 8 2
1190\.
1191
1192
1193--
1194-- Name: permission_role_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1195--
1196
1197SELECT pg_catalog.setval('public.permission_role_id_seq', 8, true);
1198
1199
1200--
1201-- Data for Name: permissions; Type: TABLE DATA; Schema: public; Owner: root
1202--
1203
1204COPY public.permissions (id, slug, name, description, created_at, updated_at) FROM stdin;
12051 managers-view Managers View Administrators view 1551007338 1551007338
12062 managers-create Managers Create Administrators create 1551007338 1551007338
12073 managers-edit Managers Edit Administrators edit 1551007338 1551007338
12084 managers-delete Managers Delete Administrators delete 1551007338 1551007338
12095 managers-groups-view Managers Groups View Administrators group view 1551007338 1551007338
12106 managers-groups-create Managers Groups Create Administrators group create 1551007338 1551007338
12117 managers-groups-edit Managers Groups Edit Administrators group edit 1551007339 1551007339
12128 managers-groups-delete Managers Groups Delete Administrators group delete 1551007339 1551007339
1213\.
1214
1215
1216--
1217-- Name: permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1218--
1219
1220SELECT pg_catalog.setval('public.permissions_id_seq', 8, true);
1221
1222
1223--
1224-- Data for Name: phones_confirmations; Type: TABLE DATA; Schema: public; Owner: root
1225--
1226
1227COPY public.phones_confirmations (id, phone, code, life_time, created_at, updated_at) FROM stdin;
1228\.
1229
1230
1231--
1232-- Name: phones_confirmations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1233--
1234
1235SELECT pg_catalog.setval('public.phones_confirmations_id_seq', 2, true);
1236
1237
1238--
1239-- Data for Name: rides_histories; Type: TABLE DATA; Schema: public; Owner: root
1240--
1241
1242COPY public.rides_histories (id, device_id, order_id, lnt, lng, created_at, updated_at) FROM stdin;
1243\.
1244
1245
1246--
1247-- Name: rides_histories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1248--
1249
1250SELECT pg_catalog.setval('public.rides_histories_id_seq', 1, false);
1251
1252
1253--
1254-- Data for Name: roles; Type: TABLE DATA; Schema: public; Owner: root
1255--
1256
1257COPY public.roles (id, slug, name, description, created_at, updated_at) FROM stdin;
12581 administrator Administrator \N 1551007338 1551007338
12592 group-manager Group manager \N 1551007338 1551007338
1260\.
1261
1262
1263--
1264-- Name: roles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1265--
1266
1267SELECT pg_catalog.setval('public.roles_id_seq', 2, true);
1268
1269
1270--
1271-- Data for Name: settings; Type: TABLE DATA; Schema: public; Owner: root
1272--
1273
1274COPY public.settings (id, name, value) FROM stdin;
1275\.
1276
1277
1278--
1279-- Name: settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1280--
1281
1282SELECT pg_catalog.setval('public.settings_id_seq', 1, false);
1283
1284
1285--
1286-- Data for Name: shapes; Type: TABLE DATA; Schema: public; Owner: root
1287--
1288
1289COPY public.shapes (id, title, city, data, created_at, updated_at, country_id) FROM stdin;
12902 Kiev Kiev, Україна [{"color":"#20a306","coordinates":[{"lat":50.48943585096277,"lng":30.484600953189556},{"lat":50.48375635649192,"lng":30.469151429263775},{"lat":50.48200868239642,"lng":30.461941651431744},{"lat":50.480479414546345,"lng":30.45232861432237},{"lat":50.47217681135456,"lng":30.445462159244244},{"lat":50.459064468738475,"lng":30.446148804752056},{"lat":50.44922782568044,"lng":30.443402222720806},{"lat":50.44179433886399,"lng":30.442715577212994},{"lat":50.43676514153952,"lng":30.45507519635362},{"lat":50.44070108055349,"lng":30.459881714908306},{"lat":50.44091973423582,"lng":30.47155468854112},{"lat":50.4387331519569,"lng":30.4760178843419},{"lat":50.441357038570146,"lng":30.480824402896587},{"lat":50.43567176706369,"lng":30.49146740826768},{"lat":50.43982645572295,"lng":30.497647217837994},{"lat":50.43742115410324,"lng":30.5144700327794},{"lat":50.442231635117416,"lng":30.5199631968419},{"lat":50.43698381340424,"lng":30.527516297427837},{"lat":50.42823615088655,"lng":30.537815980045025},{"lat":50.419049365669615,"lng":30.549488953677837},{"lat":50.42386171351107,"lng":30.560475281802837},{"lat":50.42736129573837,"lng":30.583821229068462},{"lat":50.42998581269321,"lng":30.59412091168565},{"lat":50.445729859689884,"lng":30.590687684146587},{"lat":50.44879059407263,"lng":30.593777588931744},{"lat":50.45250693395707,"lng":30.6023606577794},{"lat":50.4544742898384,"lng":30.609913758365337},{"lat":50.46125011166462,"lng":30.600987366763775},{"lat":50.478294660351814,"lng":30.595494202701275},{"lat":50.48681463064617,"lng":30.59240429791612},{"lat":50.495769866413966,"lng":30.58862774762315},{"lat":50.49555146622469,"lng":30.559101990787212},{"lat":50.49052798317857,"lng":30.53197949322862},{"lat":50.48812525898082,"lng":30.526143006412212},{"lat":50.488780559515874,"lng":30.51550000104112},{"lat":50.488780559515874,"lng":30.503140381900494},{"lat":50.48812525898082,"lng":30.48803418072862}]}] 2019-02-24 11:26:05+00 2019-02-24 11:26:05+00 \N
12913 Lviv Lviv, ЛьвівÑька облаÑÑ‚ÑŒ, Україна [{"color":"#20a306","coordinates":[{"lat":49.91887930957394,"lng":23.910302147136917},{"lat":49.90207614527527,"lng":23.893822654949417},{"lat":49.875532913150906,"lng":23.88901613639473},{"lat":49.87199271262103,"lng":23.899315819011917},{"lat":49.84499014922057,"lng":23.896569236980667},{"lat":49.79625885608361,"lng":23.92746828483223},{"lat":49.778526215812676,"lng":23.974846824871292},{"lat":49.76877049659321,"lng":24.01535890983223},{"lat":49.76699651847134,"lng":24.11148928092598},{"lat":49.77364860167976,"lng":24.117669090496292},{"lat":49.77453547712982,"lng":24.124535545574417},{"lat":49.778526215812676,"lng":24.125908836590042},{"lat":49.783403339006085,"lng":24.136895164715042},{"lat":49.811326496671974,"lng":24.157494529949417},{"lat":49.8281612514951,"lng":24.16092775748848},{"lat":49.85118879310896,"lng":24.171227440105667},{"lat":49.875532913150906,"lng":24.16367433951973},{"lat":49.88836396459661,"lng":24.151314720379105},{"lat":49.89632635033798,"lng":24.137581810222855},{"lat":49.891460604043026,"lng":24.119042381511917},{"lat":49.89101823914324,"lng":24.095696434246292},{"lat":49.88526712646968,"lng":24.076470360027542},{"lat":49.87243525187999,"lng":24.060677513347855},{"lat":49.86358369621894,"lng":24.052437767254105},{"lat":49.86092791321071,"lng":24.025658592449417},{"lat":49.86137055385041,"lng":23.994072899090042},{"lat":49.85650128376627,"lng":23.983773216472855},{"lat":49.86358369621894,"lng":23.96866701530098},{"lat":49.87199271262103,"lng":23.962487205730667},{"lat":49.875532913150906,"lng":23.948754295574417},{"lat":49.8817276396092,"lng":23.946007713543167},{"lat":49.88703677258491,"lng":23.952874168621292},{"lat":49.9060563711557,"lng":23.937081321941605},{"lat":49.90826746585599,"lng":23.929528221355667},{"lat":49.9157844297066,"lng":23.92197512076973}]}] 2019-02-24 11:28:23+00 2019-02-24 11:28:23+00 \N
12925 Deny shape 1 Deny shape 1 [{"color":"#960503","coordinates":[{"lat":42.07345200030537,"lng":-74.52735303906252},{"lat":41.84470131726237,"lng":-74.75257276562502},{"lat":41.742315433182505,"lng":-74.86243604687502},{"lat":41.67670265038447,"lng":-74.64820264843752},{"lat":41.4465307345353,"lng":-74.71961378125002},{"lat":41.41770161136502,"lng":-74.48340772656252},{"lat":41.34351079870835,"lng":-74.26917432812502},{"lat":41.50003656422389,"lng":-74.25818800000002},{"lat":41.46299877066085,"lng":-73.88465284375002},{"lat":41.569939077146365,"lng":-74.23072217968752},{"lat":41.70131529155166,"lng":-74.16480421093752},{"lat":41.84060902222161,"lng":-73.56604932812502},{"lat":41.938751857507526,"lng":-73.29139112500002},{"lat":42.07752937032428,"lng":-73.42322706250002},{"lat":42.03674388273558,"lng":-73.68140577343752},{"lat":41.94692362047949,"lng":-73.87915967968752},{"lat":41.88969928764625,"lng":-74.20325635937502}]}] 2019-02-26 19:39:37+00 2019-02-26 19:39:37+00 \N
12934 Khmel'nyts'kyi Khmel'nyts'kyi, Хмельницька облаÑÑ‚ÑŒ, Україна [{"color":"#20a306","coordinates":[{"lat":49.43955111247379,"lng":27.002957501099672},{"lat":49.42838756209158,"lng":26.991971172974672},{"lat":49.41856153594984,"lng":26.98579136340436},{"lat":49.41588136913126,"lng":26.97755161731061},{"lat":49.40739320859806,"lng":26.967251934693422},{"lat":49.40024414550031,"lng":26.960385479615297},{"lat":49.38996554367799,"lng":26.95557896106061},{"lat":49.38013182479817,"lng":26.954205670044985},{"lat":49.36895475520266,"lng":26.959698834107485},{"lat":49.359564052531155,"lng":26.96381870715436},{"lat":49.36314167454695,"lng":26.98304478137311},{"lat":49.36224729344418,"lng":27.000897564576235},{"lat":49.36045848243635,"lng":27.01600376574811},{"lat":49.36224729344418,"lng":27.03248325793561},{"lat":49.3537498616203,"lng":27.09290806262311},{"lat":49.367613336052656,"lng":27.101834454224672},{"lat":49.37297879305169,"lng":27.104581036255922},{"lat":49.384154947676386,"lng":27.100461163209047},{"lat":49.39309404150197,"lng":27.101834454224672},{"lat":49.402925166140335,"lng":27.116940655396547},{"lat":49.42258151174942,"lng":27.066815533326235},{"lat":49.42794096722716,"lng":27.05445591418561},{"lat":49.42615454711527,"lng":27.037289776490297}]}] 2019-02-24 11:29:56+00 2019-02-24 17:03:08+00 \N
12946 Deny shape 2 Deny shape 2 [{"color":"#960503","coordinates":[{"lat":41.98776672482539,"lng":-75.78528760937502},{"lat":41.87334005388595,"lng":-75.70289014843752},{"lat":41.803766589703976,"lng":-75.89515089062502},{"lat":41.672599628053824,"lng":-75.84021925000002},{"lat":41.55760882917736,"lng":-75.92810987500002},{"lat":41.36825047357329,"lng":-75.85120557812502},{"lat":41.12043073512767,"lng":-75.89515089062502},{"lat":40.89658984939715,"lng":-75.97754835156252},{"lat":40.81349290758641,"lng":-75.92810987500002},{"lat":40.66365584009626,"lng":-75.91163038281252},{"lat":39.603116211134136,"lng":-75.71936964062502},{"lat":39.62004360256499,"lng":-75.63147901562502},{"lat":40.87777081250049,"lng":-75.89515089062502},{"lat":41.43198756600043,"lng":-75.80726026562502},{"lat":41.55542359966043,"lng":-75.88416456250002},{"lat":41.67862435204565,"lng":-75.78528760937502},{"lat":41.789303764364504,"lng":-75.84021925000002},{"lat":41.86298406681593,"lng":-75.63697217968752},{"lat":42.038654795993196,"lng":-75.73035596875002}]}] 2019-02-26 19:40:25+00 2019-02-26 19:40:25+00 \N
12957 Deny shape 3 Deny shape 3 [{"color":"#960503","coordinates":[{"lat":41.697213838618985,"lng":-72.80799268750002},{"lat":41.63155502016217,"lng":-75.70838331250002},{"lat":40.559403815539184,"lng":-75.73584913281252},{"lat":40.38807853135681,"lng":-71.99500440625002},{"lat":41.60691570280579,"lng":-72.12684034375002}]}] 2019-02-26 19:40:58+00 2019-02-26 19:41:09+00 \N
12961 Batumi Batumi, Ð“Ñ€ÑƒÐ·Ñ–Ñ [{"color":"#20a306","coordinates":[{"lat":41.63241358071723,"lng":41.61187043771861},{"lat":41.63100222617776,"lng":41.611698776341655},{"lat":41.629590840737606,"lng":41.6115271149647},{"lat":41.627666174430054,"lng":41.6115271149647},{"lat":41.62663966223828,"lng":41.61135545358775},{"lat":41.62548481648646,"lng":41.61187043771861},{"lat":41.62458658882316,"lng":41.61238542184947},{"lat":41.621378530734795,"lng":41.61633363351939},{"lat":41.60982820010629,"lng":41.62611833200572},{"lat":41.60661940785459,"lng":41.62903657541392},{"lat":41.60469405589794,"lng":41.6305815278065},{"lat":41.60187010243434,"lng":41.63212648019908},{"lat":41.599302764767266,"lng":41.63555970773814},{"lat":41.59596507310463,"lng":41.6415678559315},{"lat":41.591600138945154,"lng":41.64603105173228},{"lat":41.587234909617614,"lng":41.65032258615611},{"lat":41.582098967813366,"lng":41.65478578195689},{"lat":41.584281792996826,"lng":41.658905655003764},{"lat":41.58492378636073,"lng":41.660107284642436},{"lat":41.586336149292364,"lng":41.6635405121815},{"lat":41.585565773341386,"lng":41.66594377145884},{"lat":41.58877561249603,"lng":41.67590013132212}]},{"color":"#960503","coordinates":[{"lat":41.629590840737606,"lng":41.65530076608775},{"lat":41.62176350613256,"lng":41.65118089304087},{"lat":41.61470525866817,"lng":41.66302552805064},{"lat":41.61983860616072,"lng":41.67092195139048},{"lat":41.622405126688136,"lng":41.663883834935405},{"lat":41.62728123427342,"lng":41.68740144357798},{"lat":41.63164375479908,"lng":41.671093612767436},{"lat":41.6280511122883,"lng":41.67143693552134},{"lat":41.630488998683894,"lng":41.666630416966655},{"lat":41.63536449490095,"lng":41.66800370798228},{"lat":41.63639086816714,"lng":41.67572846994517},{"lat":41.639085020226524,"lng":41.6719519196522},{"lat":41.63946988989828,"lng":41.6664587555897},{"lat":41.64100934560055,"lng":41.66405549631236},{"lat":41.63934160026308,"lng":41.654614120579936}]}] 2019-02-24 11:24:57+00 2019-02-26 20:02:02+00 \N
12978 Big test shape Ukraine [{"color":"#20a306","coordinates":[{"lat":51.26711138339426,"lng":30.501913776815513},{"lat":51.50023485808771,"lng":30.238241901815513},{"lat":51.48655457577204,"lng":29.579062214315513},{"lat":51.43179238535791,"lng":29.315390339315513},{"lat":51.65044711960303,"lng":29.139609089315513},{"lat":51.459181693696735,"lng":28.722128620565513},{"lat":51.636811969577295,"lng":28.304648151815513},{"lat":51.50023485808771,"lng":27.755331745565513},{"lat":51.636811969577295,"lng":27.337851276815513},{"lat":51.800163259569004,"lng":27.140097370565513},{"lat":51.78657318606718,"lng":26.766562214315513},{"lat":51.922289699789985,"lng":25.997519245565513},{"lat":51.93583884390534,"lng":25.382284870565513},{"lat":51.8951791386718,"lng":24.547323933065513},{"lat":51.568574700555395,"lng":23.976034870565513},{"lat":51.66407816944279,"lng":23.580527058065513},{"lat":51.322070817667814,"lng":23.690390339315513},{"lat":50.880551262484694,"lng":23.998007526815513},{"lat":50.46279098064488,"lng":24.129843464315513},{"lat":50.224408182713105,"lng":23.426718464315513},{"lat":49.78662623425676,"lng":22.921347370565513},{"lat":49.4592409206815,"lng":22.591757526815513},{"lat":49.1440295028505,"lng":22.811484089315513},{"lat":49.000084713202625,"lng":22.921347370565513},{"lat":49.043311944651016,"lng":22.591757526815513},{"lat":48.725439934041944,"lng":22.328085651815513},{"lat":48.434710867343355,"lng":22.130331745565513},{"lat":48.068946404122975,"lng":22.789511433065513},{"lat":48.01018122144344,"lng":23.053183308065513},{"lat":48.09830386023546,"lng":23.250937214315513},{"lat":47.95134899931541,"lng":23.888144245565513},{"lat":47.93663046717875,"lng":24.503378620565513},{"lat":47.70056381729233,"lng":24.832968464315513},{"lat":47.77444995379394,"lng":25.228476276815513},{"lat":47.87771442555203,"lng":25.316366901815513},{"lat":48.01018122144344,"lng":26.195273151815513},{"lat":48.332560511850296,"lng":26.678671589315513},{"lat":48.434710867343355,"lng":27.293905964315513},{"lat":48.47842684166191,"lng":27.843222370565513},{"lat":48.2155661599876,"lng":28.216757526815513},{"lat":48.112976305293884,"lng":28.546347370565513},{"lat":48.14230863058244,"lng":28.788046589315513},{"lat":47.93663046717875,"lng":29.007773151815513},{"lat":47.99547945142593,"lng":29.161581745565513},{"lat":47.4634233817262,"lng":29.205527058065513},{"lat":47.3444502404752,"lng":29.513144245565513},{"lat":46.97092664377951,"lng":29.535116901815513},{"lat":46.82078177891005,"lng":29.908652058065513},{"lat":46.343180513761794,"lng":30.078940144003013},{"lat":46.422618333834976,"lng":29.723346809677423},{"lat":46.35951328064917,"lng":29.620267055271142},{"lat":46.53884410087802,"lng":29.176395704688957},{"lat":46.46459400492244,"lng":29.018601361137485},{"lat":46.31456119258896,"lng":28.98205642668495},{"lat":46.13165957085942,"lng":29.007799440035797},{"lat":45.9100839603729,"lng":28.78595465933222},{"lat":45.519218706266315,"lng":28.467273469241718},{"lat":45.45054311661179,"lng":28.238730183065513},{"lat":45.24280920599142,"lng":28.610174348797727},{"lat":45.35272343504752,"lng":28.8339398914228},{"lat":45.40807588898332,"lng":29.091366338484363},{"lat":45.48102615506195,"lng":29.431746641616428},{"lat":45.74913689348315,"lng":29.763050781646484},{"lat":45.8932869749699,"lng":30.22267468136124},{"lat":46.09768010240798,"lng":30.409671615396746},{"lat":46.32623818422178,"lng":30.107531167363504},{"lat":46.38239339517573,"lng":30.174977355097553},{"lat":46.39057942460786,"lng":30.242554212075447},{"lat":46.31535374672726,"lng":30.282599249940745},{"lat":46.28995960084137,"lng":30.368085280253695},{"lat":46.18313018216425,"lng":30.443149485907043},{"lat":46.15250226973918,"lng":30.480585032005138},{"lat":46.140885352416184,"lng":30.53721581065679},{"lat":46.21550811141017,"lng":30.59424149197821},{"lat":46.26916730864386,"lng":30.632131225773946},{"lat":46.29683286449162,"lng":30.651182347014355},{"lat":46.33213180771262,"lng":30.67666844092105},{"lat":46.393783774164355,"lng":30.746208540459293},{"lat":46.4336589304043,"lng":30.75953789394339},{"lat":46.4697505668635,"lng":30.75637911989702},{"lat":46.542941710886694,"lng":30.75062492302436},{"lat":46.563208454025116,"lng":30.810851775683204},{"lat":46.61335842242433,"lng":31.076354591758218},{"lat":46.62331410642442,"lng":31.333983933202717},{"lat":46.67758483356772,"lng":31.455431658676616},{"lat":46.626193972046046,"lng":31.527446053472204},{"lat":46.659549954926305,"lng":31.68746110325003},{"lat":46.63581895079015,"lng":31.726864116049796},{"lat":46.62339500912054,"lng":31.80741079432073},{"lat":46.638405991169925,"lng":31.869656543136102},{"lat":46.662834008335146,"lng":31.89897198368385},{"lat":46.69471192931065,"lng":31.899924030721763},{"lat":46.490111744123425,"lng":32.468661023871505},{"lat":46.463849254121044,"lng":32.372791796841966},{"lat":46.48639738349992,"lng":32.068253582205784},{"lat":46.49799346036317,"lng":31.957678260671173},{"lat":46.524585153745484,"lng":31.825044857912644},{"lat":46.54356040299085,"lng":31.7500815854861},{"lat":46.54344909370223,"lng":31.52675107602181},{"lat":46.46443082694289,"lng":31.669588739047185},{"lat":46.48584401467423,"lng":31.753327957105853},{"lat":46.46557099512203,"lng":31.853548593805044},{"lat":46.448022967350056,"lng":32.005850245727856},{"lat":46.41522697146619,"lng":32.07565182521705},{"lat":46.35687278486959,"lng":32.00528038965331},{"lat":46.31360361970982,"lng":31.88564720235513},{"lat":46.17658894768695,"lng":32.24469748124875},{"lat":46.134633838435285,"lng":32.26761796419987},{"lat":46.11166776357391,"lng":32.38384019278055},{"lat":46.09037414895203,"lng":32.544832942339326},{"lat":46.12424391747391,"lng":32.756576480299145},{"lat":46.11241447264784,"lng":33.006772166696464},{"lat":46.15170643285068,"lng":33.03161976575461},{"lat":46.1256744938793,"lng":33.13742735434607},{"lat":46.184315267763864,"lng":33.19928963043765},{"lat":46.15520715204525,"lng":33.20828020242766},{"lat":46.10704450409104,"lng":33.20765773730818},{"lat":46.138668044588556,"lng":33.265180343684506},{"lat":46.11508614233729,"lng":33.32682282310782},{"lat":46.04025402582455,"lng":33.41989537961058},{"lat":46.031572152028524,"lng":33.504416957459966},{"lat":46.15257203086112,"lng":33.59102748818009},{"lat":46.02213274414842,"lng":33.617213214212825},{"lat":45.84357246760436,"lng":33.683224379698686},{"lat":45.894300362421404,"lng":33.60092011549705},{"lat":45.77670996336725,"lng":33.323701723812405},{"lat":45.76339509858918,"lng":33.241490656346514},{"lat":45.68487678991434,"lng":33.02401042384167},{"lat":45.59663995451462,"lng":32.84498233977422},{"lat":45.502970643926815,"lng":32.64535489047239},{"lat":45.455114138104584,"lng":32.54004800175903},{"lat":45.38793094800306,"lng":32.478686425545675},{"lat":45.347023074352215,"lng":32.504278702806346},{"lat":45.31767477447831,"lng":32.66170691756702},{"lat":45.361692259348,"lng":32.79441589404655},{"lat":45.35165655878596,"lng":32.94360436271347},{"lat":45.20825700376223,"lng":33.13261827083363},{"lat":45.15559945828688,"lng":33.25571421020368},{"lat":45.17341572359503,"lng":33.49042191086653},{"lat":45.03208896071533,"lng":33.587176395963525},{"lat":44.88739619798275,"lng":33.592981617027704},{"lat":44.74624009918494,"lng":33.53286886934188},{"lat":44.637288114042384,"lng":33.53686367937962},{"lat":44.567279115082016,"lng":33.403529387854974},{"lat":44.50208328678819,"lng":33.491981595353764},{"lat":44.49997741680473,"lng":33.517871197521345},{"lat":44.48807528607743,"lng":33.556120418829664},{"lat":44.49365935047452,"lng":33.60240645910244},{"lat":44.46666497176731,"lng":33.63804949400412},{"lat":44.42816043176117,"lng":33.64763126536127},{"lat":44.42102537495522,"lng":33.66682607382779},{"lat":44.41928440119329,"lng":33.704216988251346},{"lat":44.38761873996237,"lng":33.73954796615135},{"lat":44.3973827588769,"lng":33.821882895584395},{"lat":44.41052375307145,"lng":33.88877222070175},{"lat":44.39423093020336,"lng":33.96664787394411},{"lat":44.426396095587755,"lng":34.10317310621019},{"lat":44.49284037501209,"lng":34.17652695175741},{"lat":44.512325665039135,"lng":34.25852247804664},{"lat":44.54751767702804,"lng":34.2830407490037},{"lat":44.559209039222786,"lng":34.32403851214838},{"lat":44.705385735780226,"lng":34.46113316613355},{"lat":44.78885128246305,"lng":34.65590604277486},{"lat":44.815234366221986,"lng":34.775834559064606},{"lat":44.8318671201848,"lng":34.9369618058231},{"lat":44.83726031881413,"lng":35.01546549267891},{"lat":44.8048902705097,"lng":35.058837209153694},{"lat":44.79589518254057,"lng":35.088476015472224},{"lat":44.825385253567944,"lng":35.12772785890013},{"lat":44.88989630640639,"lng":35.153246792171785},{"lat":44.915710009713045,"lng":35.22900389699646},{"lat":44.96195849996893,"lng":35.351335672563664},{"lat":45.084057436463404,"lng":35.41250156034721},{"lat":45.12843790071665,"lng":35.512119596568255},{"lat":45.11175897338362,"lng":35.67490901950805},{"lat":45.06851189057137,"lng":35.77827638722795},{"lat":45.0019320661527,"lng":35.848684770572845},{"lat":45.056842645373706,"lng":36.075386663327436},{"lat":45.044024198463305,"lng":36.15852520736098},{"lat":45.05352081707429,"lng":36.249903497488276},{"lat":45.05913574812749,"lng":36.37973393605307},{"lat":45.10062758112304,"lng":36.44639298789923},{"lat":45.1233001742664,"lng":36.42410422768944},{"lat":45.19824343153184,"lng":36.4100552135734},{"lat":45.285064679217996,"lng":36.419036042763196},{"lat":45.30718098039487,"lng":36.47571151595184},{"lat":45.35824524593083,"lng":36.48432180359373},{"lat":45.35023249557157,"lng":36.546648492824716},{"lat":45.35380037895932,"lng":36.600735435962065},{"lat":45.381195307981244,"lng":36.652604390596025},{"lat":45.43302423386677,"lng":36.582835563108574},{"lat":45.45013370621562,"lng":36.46912142312112},{"lat":45.44411855509531,"lng":36.419265315360235},{"lat":45.47085599102829,"lng":36.33919680525571},{"lat":45.46965861065883,"lng":36.24196215745587},{"lat":45.466534989098214,"lng":36.15708712879655},{"lat":45.4460713299521,"lng":36.09006488334035},{"lat":45.39824190163712,"lng":36.064793506705996},{"lat":45.383475888211294,"lng":36.04185813577169},{"lat":45.37063557295789,"lng":35.98596378046227},{"lat":45.39355047145578,"lng":35.92237476254513},{"lat":45.44440457092512,"lng":35.82994663329987},{"lat":45.39416288119432,"lng":35.76175991242724},{"lat":45.3419460166991,"lng":35.718292429835856},{"lat":45.26250494664008,"lng":35.41437748418434},{"lat":45.33362980866059,"lng":35.2136681803039},{"lat":45.35836581800395,"lng":35.095356337360954},{"lat":45.430939725177026,"lng":35.050993393662566},{"lat":45.48730279495124,"lng":35.14628850235965},{"lat":45.64596146157761,"lng":35.0072888760036},{"lat":45.75820081498559,"lng":34.81335760902266},{"lat":45.905583116645175,"lng":34.64139899829172},{"lat":46.033510650766395,"lng":34.60127632506078},{"lat":46.167027794045815,"lng":34.61400465600991},{"lat":46.17093383857965,"lng":34.80095659003916},{"lat":46.24421508175636,"lng":34.89315144399029},{"lat":46.26121418209606,"lng":35.051753544083454},{"lat":46.36830404019099,"lng":35.193876151989116},{"lat":46.34849595174101,"lng":35.31506583106511},{"lat":46.37038933079265,"lng":35.36759095935986},{"lat":46.515741278188884,"lng":35.30407299683429},{"lat":46.687089413862445,"lng":35.30372642102759},{"lat":46.457543704950425,"lng":35.44894869287714},{"lat":46.48672180295886,"lng":35.58593121863282},{"lat":46.61393782621696,"lng":35.75003298889419},{"lat":46.66390072057433,"lng":36.00141022386117},{"lat":46.66766781241958,"lng":36.030265579966226},{"lat":46.66884513775009,"lng":36.053615588426055},{"lat":46.65965558275688,"lng":36.10305812618276},{"lat":46.66766520491973,"lng":36.14975814310242},{"lat":46.670019830051004,"lng":36.17860537681895},{"lat":46.67166859325589,"lng":36.19714683612699},{"lat":46.66483599905615,"lng":36.211568422388154},{"lat":46.6455118459852,"lng":36.24315817694185},{"lat":46.62971735344041,"lng":36.256380164161556},{"lat":46.60967310504405,"lng":36.2668555693499},{"lat":46.64456710308444,"lng":36.28351078410856},{"lat":46.67425633249436,"lng":36.313898909023465},{"lat":46.70957496275944,"lng":36.375557832903496},{"lat":46.72581356863214,"lng":36.414455379560195},{"lat":46.739223930380255,"lng":36.45609950824826},{"lat":46.75968471539195,"lng":36.53904444287036},{"lat":46.7616812467743,"lng":36.56558237038655},{"lat":46.76526644183465,"lng":36.58056794791423},{"lat":46.78060794609194,"lng":36.62095940923086},{"lat":46.78134210461321,"lng":36.651755029132346},{"lat":46.78019542924651,"lng":36.680490712510505},{"lat":46.78166374752808,"lng":36.70637638590722},{"lat":46.775431056823706,"lng":36.73926498123592},{"lat":46.76108201956839,"lng":36.78032293361207},{"lat":46.706010663978745,"lng":36.83222643602073},{"lat":46.79351124630539,"lng":36.881383356398146},{"lat":46.80760369108158,"lng":36.894834710369196},{"lat":46.829679329522605,"lng":36.9223622972504},{"lat":46.8479890618093,"lng":36.95538304819411},{"lat":46.8770804564363,"lng":37.03653075125351},{"lat":46.91645832774519,"lng":37.157627426903446},{"lat":46.95674463150687,"lng":37.251258282241},{"lat":46.89430616307122,"lng":37.336896457759735},{"lat":46.98311455458567,"lng":37.428467376573735},{"lat":47.04227216313256,"lng":37.48328912239049},{"lat":47.0864052838026,"lng":37.549097196332355},{"lat":47.09141383322608,"lng":37.590076137184724},{"lat":47.08989653430542,"lng":37.69286867716039},{"lat":47.09220222097975,"lng":37.79487897154149},{"lat":47.11133378588145,"lng":37.89688926592248},{"lat":47.10562118224297,"lng":37.9232780698793},{"lat":47.10212182996573,"lng":37.93269692214085},{"lat":47.089506756757196,"lng":37.972499713915795},{"lat":47.08677682155666,"lng":37.984252910503756},{"lat":47.08942292568759,"lng":37.98639305904885},{"lat":47.09074622611959,"lng":37.98132668986591},{"lat":47.09257646842683,"lng":37.97776335929507},{"lat":47.09440651311165,"lng":37.97179644194193},{"lat":47.09705265662609,"lng":37.9755673832351},{"lat":47.09758684428915,"lng":37.97726175757907},{"lat":47.099403606751444,"lng":37.9931172695475},{"lat":47.09794647184856,"lng":38.00691294512444},{"lat":47.092388541253,"lng":38.026640922545994},{"lat":47.09323142063435,"lng":38.03770594317814},{"lat":47.10108570695458,"lng":38.04121905375723},{"lat":47.10697899306955,"lng":38.04893227827324},{"lat":47.11245083348154,"lng":38.063669328548485},{"lat":47.10857157171656,"lng":38.08939218397984},{"lat":47.09937748450341,"lng":38.10761672999547},{"lat":47.053948058939504,"lng":38.13992256946449},{"lat":47.10149038540584,"lng":38.19422837898992},{"lat":47.12080299543297,"lng":38.22869452913312},{"lat":47.229958268404715,"lng":38.23346497610714},{"lat":47.245532917535854,"lng":38.282547718436945},{"lat":47.26108659539613,"lng":38.331659312117495},{"lat":47.29964499076637,"lng":38.34203448511448},{"lat":47.30510026868904,"lng":38.218711955102776},{"lat":47.3282007875506,"lng":38.2148303858678},{"lat":47.405600007991445,"lng":38.29701035001267},{"lat":47.49693792356346,"lng":38.28440624390589},{"lat":47.54179267612611,"lng":38.29062686389773},{"lat":47.54846116976319,"lng":38.30473057866698},{"lat":47.571811868409014,"lng":38.31334763788277},{"lat":47.57867183692096,"lng":38.35394343297037},{"lat":47.615167617406,"lng":38.35885251213392},{"lat":47.62086158708542,"lng":38.45723170610381},{"lat":47.64598060550618,"lng":38.464998093990516},{"lat":47.65071355833064,"lng":38.61425370842858},{"lat":47.67572415650062,"lng":38.648205066498576},{"lat":47.73037660190885,"lng":38.7903190405043},{"lat":47.80750257476183,"lng":38.802442679329374},{"lat":47.86616358090882,"lng":38.87785208919399},{"lat":47.856477523945,"lng":39.19401534089525},{"lat":47.87347875970499,"lng":39.33575866653052},{"lat":47.8608501329996,"lng":39.45554036427029},{"lat":47.84295733387752,"lng":39.67232782899487},{"lat":47.872619323942516,"lng":39.78347486821508},{"lat":47.96114323291165,"lng":39.817885032994354},{"lat":48.13439786087319,"lng":39.89552409004227},{"lat":48.151593488502634,"lng":39.904146617794595},{"lat":48.18046370566708,"lng":39.90831564457244},{"lat":48.18186713532587,"lng":39.94001109765145},{"lat":48.22804250476876,"lng":39.939006960084384},{"lat":48.228825757025945,"lng":40.000998615818276},{"lat":48.26252455625851,"lng":40.01632443984329},{"lat":48.3141164883793,"lng":39.98282498267929},{"lat":48.29539068745729,"lng":39.94987476100755},{"lat":48.27025867983354,"lng":39.92107093333641},{"lat":48.300394782690134,"lng":39.89091290881413},{"lat":48.31410076983095,"lng":39.836041793352024},{"lat":48.33323154361685,"lng":39.84713761102216},{"lat":48.337412023877995,"lng":39.87775363222863},{"lat":48.34911350882054,"lng":39.94339123772056},{"lat":48.35398643998636,"lng":39.94725259982465},{"lat":48.36022823671745,"lng":39.941500718614066},{"lat":48.37134280476096,"lng":39.93480180684378},{"lat":48.38536127288301,"lng":39.94337850913246},{"lat":48.38694142025685,"lng":39.94027922434452},{"lat":48.37615956476439,"lng":39.927569650550936},{"lat":48.37746258310863,"lng":39.92001179096087},{"lat":48.385834669871386,"lng":39.91399658373666},{"lat":48.39147031609447,"lng":39.90729298079896},{"lat":48.397337555217696,"lng":39.918910805528526},{"lat":48.4030035224092,"lng":39.906482906637166},{"lat":48.408669151249825,"lng":39.906413234773595},{"lat":48.419089617857914,"lng":39.91073760237623},{"lat":48.42853630063921,"lng":39.89432026878478},{"lat":48.43909704634283,"lng":39.889789600646736},{"lat":48.44624142586908,"lng":39.89658792149737},{"lat":48.45392538976607,"lng":39.88099946196621},{"lat":48.47202257296252,"lng":39.84499823441547},{"lat":48.48317653494337,"lng":39.84440116874259},{"lat":48.56878526864001,"lng":39.85027605543519},{"lat":48.58266389175039,"lng":39.81800936018931},{"lat":48.58598728453414,"lng":39.714536272847454},{"lat":48.59881514391275,"lng":39.6585408349124},{"lat":48.665174804823565,"lng":39.69457229707109},{"lat":48.72886271666213,"lng":39.706180409013996},{"lat":48.77804267067742,"lng":39.77280794258422},{"lat":48.84521895137732,"lng":39.798589097559216},{"lat":48.796549770321874,"lng":39.96445440608704},{"lat":48.849222623274315,"lng":40.06010034788369},{"lat":48.87927162796674,"lng":40.06487656123056},{"lat":48.90931993816116,"lng":40.04217618637472},{"lat":48.86645527786567,"lng":39.985781817207794},{"lat":48.88678068630625,"lng":39.92112159054409},{"lat":48.88899483597876,"lng":39.83445461381052},{"lat":48.952055443951274,"lng":39.76778815622515},{"lat":49.01339281108994,"lng":39.67039703876935},{"lat":49.05686031099428,"lng":39.75882944077421},{"lat":49.06055195608989,"lng":39.95176534047209},{"lat":49.16660262940332,"lng":40.01726616584335},{"lat":49.25639069172908,"lng":40.19858020330503},{"lat":49.32893006730492,"lng":40.18686955294038},{"lat":49.43901801402153,"lng":40.07059780666782},{"lat":49.46605284904672,"lng":40.03602871889052},{"lat":49.510935215211624,"lng":40.05088363410084},{"lat":49.570074386093296,"lng":40.16189250292723},{"lat":49.62563131531578,"lng":40.14667112471557},{"lat":49.56404735192254,"lng":39.835572257548165},{"lat":49.591154965403256,"lng":39.749833446320395},{"lat":49.627820842582366,"lng":39.64914366263713},{"lat":49.72786495200524,"lng":39.58769447615941},{"lat":49.76036262311854,"lng":39.48757282556414},{"lat":49.74517764938636,"lng":39.316039150205825},{"lat":49.88229884415118,"lng":39.17707318608723},{"lat":49.824061428269786,"lng":39.08548338884873},{"lat":49.804692962154064,"lng":38.955619191119695},{"lat":49.854365691206326,"lng":38.86951938405264},{"lat":49.882714067652635,"lng":38.77228530931109},{"lat":49.95871340965857,"lng":38.61253116428031},{"lat":49.95330690059611,"lng":38.48278729121398},{"lat":49.99911494972167,"lng":38.36103037780833},{"lat":50.0801627445826,"lng":38.310457106434114},{"lat":50.07126200272595,"lng":38.19114744445426},{"lat":50.00945263904027,"lng":38.21468712511137},{"lat":49.96693821423158,"lng":38.22880013439908},{"lat":49.919434538209394,"lng":38.04022303490365},{"lat":50.026197367740714,"lng":37.926543967521184},{"lat":50.05034487686221,"lng":37.859948322395894},{"lat":50.058596402156645,"lng":37.79331115749221},{"lat":50.117598629125425,"lng":37.71188694922421},{"lat":50.30312185309258,"lng":37.61068032246726},{"lat":50.32351864193002,"lng":37.52355001931551},{"lat":50.41753263761216,"lng":37.375804005650366},{"lat":50.33971425956478,"lng":37.040154148045076},{"lat":50.346739172129006,"lng":37.00878101606679},{"lat":50.346743026436556,"lng":36.971909670277},{"lat":50.34717641746869,"lng":36.935036548233484},{"lat":50.338834308773535,"lng":36.89816956559355},{"lat":50.29770105484306,"lng":36.77624785638545},{"lat":50.27009120633088,"lng":36.72087764362436},{"lat":50.26450607939054,"lng":36.69571688008182},{"lat":50.25540734038945,"lng":36.68978698314845},{"lat":50.21789810676263,"lng":36.66419244798249},{"lat":50.250705883775964,"lng":36.5589232549645},{"lat":50.26346453436823,"lng":36.57716725207024},{"lat":50.273902917409714,"lng":36.574445526441195},{"lat":50.27859650296016,"lng":36.58955806622566},{"lat":50.28555072429597,"lng":36.583038462075365},{"lat":50.284606443239475,"lng":36.56965114610307},{"lat":50.28337614298107,"lng":36.56141695918768},{"lat":50.2806102422717,"lng":36.5545566405541},{"lat":50.28966774211323,"lng":36.51791230575918},{"lat":50.31162978802482,"lng":36.48517386489368},{"lat":50.31187485145294,"lng":36.45379359990909},{"lat":50.31135578282152,"lng":36.43959212542768},{"lat":50.32048673532034,"lng":36.43629974103851},{"lat":50.33005591520233,"lng":36.43300676567196},{"lat":50.30863917194052,"lng":36.40547957503577},{"lat":50.299834735476175,"lng":36.376442351966375},{"lat":50.292856036845656,"lng":36.3781471923553},{"lat":50.29016208468316,"lng":36.37148888123431},{"lat":50.288787567387324,"lng":36.36811695206325},{"lat":50.287084089444086,"lng":36.36234174867354},{"lat":50.295955550611026,"lng":36.281035326208666},{"lat":50.338972904457236,"lng":36.276654882553885},{"lat":50.368841229630746,"lng":36.224206775242806},{"lat":50.410082437456225,"lng":36.19782851176683},{"lat":50.40404473203962,"lng":36.16593545551734},{"lat":50.43125827633296,"lng":36.160799544009706},{"lat":50.43746754583931,"lng":36.10895163250825},{"lat":50.449348454632236,"lng":36.06877252161871},{"lat":50.44372477187916,"lng":36.02858809862448},{"lat":50.43159677539938,"lng":35.934487591532616},{"lat":50.42202039562151,"lng":35.84453701617679},{"lat":50.42161336923304,"lng":35.813659472673294},{"lat":50.39670109312769,"lng":35.80751105984916},{"lat":50.38626391220815,"lng":35.791099583407004},{"lat":50.35597418352824,"lng":35.69768178255117},{"lat":50.36503162948131,"lng":35.61800231917687},{"lat":50.565651643336686,"lng":35.36346843130809},{"lat":50.68313342442787,"lng":35.40482986603524},{"lat":50.766120583040475,"lng":35.4339605225133},{"lat":50.911406136695,"lng":35.35294735420314},{"lat":51.048966587802475,"lng":35.378124830943875},{"lat":51.060687757394085,"lng":35.29170621701621},{"lat":51.03088948908983,"lng":35.18335294411759},{"lat":51.2114066717547,"lng":35.118776597395936},{"lat":51.18545091742142,"lng":34.670568583313866},{"lat":51.24699342637995,"lng":34.619560124394184},{"lat":51.222510129576534,"lng":34.502575545260356},{"lat":51.259635715525896,"lng":34.25163208183142},{"lat":51.36207975856902,"lng":34.30803229779974},{"lat":51.4096202749055,"lng":34.18854807390073},{"lat":51.52108633121337,"lng":34.280753039436036},{"lat":51.677550629318816,"lng":34.09592686213591},{"lat":51.67763266196566,"lng":34.09613041487705},{"lat":51.71174489102482,"lng":34.26109751097306},{"lat":51.726187861167496,"lng":34.334012880391356},{"lat":51.72146902702675,"lng":34.38560159374367},{"lat":51.75416070308921,"lng":34.41524279489761},{"lat":51.79841437730077,"lng":34.41577883129139},{"lat":51.840912208018786,"lng":34.377533107306135},{"lat":51.879093476213086,"lng":34.300669989538164},{"lat":51.92900312197904,"lng":34.21004585863841},{"lat":51.962967329773114,"lng":34.17165524818415},{"lat":52.000214912067364,"lng":34.12216291477182},{"lat":52.05453781589672,"lng":34.06309703229772},{"lat":52.10116959174251,"lng":34.085378749151914},{"lat":52.1400816717747,"lng":34.10991451899133},{"lat":52.154547789428534,"lng":34.07127045175912},{"lat":52.227109017173014,"lng":33.99551922162436},{"lat":52.29300907111514,"lng":33.915314058139984},{"lat":52.35587665812956,"lng":33.80184355871188},{"lat":52.35129287499147,"lng":33.70940536482374},{"lat":52.32652616922022,"lng":33.64997655820616},{"lat":52.32052194103016,"lng":33.517250411501436},{"lat":52.36179193817057,"lng":33.251464887483394},{"lat":52.281498365055235,"lng":32.43624136445419},{"lat":52.01782194467968,"lng":32.01866445586711},{"lat":52.102031912348075,"lng":31.559513355960235},{"lat":52.036519779740914,"lng":31.286976871663},{"lat":52.05790430762959,"lng":30.938242236702422},{"lat":51.848618669282125,"lng":30.711562398674914}]}] 2019-02-26 21:00:00+00 2019-02-26 21:16:46+00 \N
1298\.
1299
1300
1301--
1302-- Name: shapes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1303--
1304
1305SELECT pg_catalog.setval('public.shapes_id_seq', 8, true);
1306
1307
1308--
1309-- Data for Name: tokens; Type: TABLE DATA; Schema: public; Owner: root
1310--
1311
1312COPY public.tokens (id, manager_id, token, type, is_revoked, created_at, updated_at) FROM stdin;
13131 1 a660b7ba-cf19-428f-b859-654b7b30cd7f remember_token f 2019-02-24 16:41:27+00 2019-02-24 16:41:27+00
13142 1 13f739a1-4a92-4c86-8b09-fd3f39e97505 remember_token f 2019-02-24 16:51:02+00 2019-02-24 16:51:02+00
13153 1 7ca426ae-6042-4980-936a-4121515d4299 remember_token f 2019-02-24 17:18:18+00 2019-02-24 17:18:18+00
13164 1 347f501d-1e41-4ac3-ac25-2b09f3ac8890 remember_token f 2019-02-24 17:18:50+00 2019-02-24 17:18:50+00
1317\.
1318
1319
1320--
1321-- Name: tokens_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1322--
1323
1324SELECT pg_catalog.setval('public.tokens_id_seq', 4, true);
1325
1326
1327--
1328-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: root
1329--
1330
1331COPY public.users (id, username, email, password, avatar, timezone, is_blocked, created_at, updated_at, phone) FROM stdin;
13325 \N \N \N \N \N \N 2019-02-26 18:53:59+00 2019-02-26 18:53:59+00 380679669455
1333\.
1334
1335
1336--
1337-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1338--
1339
1340SELECT pg_catalog.setval('public.users_id_seq', 5, true);
1341
1342
1343--
1344-- Name: adonis_schema adonis_schema_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1345--
1346
1347ALTER TABLE ONLY public.adonis_schema
1348 ADD CONSTRAINT adonis_schema_pkey PRIMARY KEY (id);
1349
1350
1351--
1352-- Name: billing_history billing_history_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1353--
1354
1355ALTER TABLE ONLY public.billing_history
1356 ADD CONSTRAINT billing_history_pkey PRIMARY KEY (id);
1357
1358
1359--
1360-- Name: countries countries_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1361--
1362
1363ALTER TABLE ONLY public.countries
1364 ADD CONSTRAINT countries_pkey PRIMARY KEY (id);
1365
1366
1367--
1368-- Name: devices_histories devices_histories_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1369--
1370
1371ALTER TABLE ONLY public.devices_histories
1372 ADD CONSTRAINT devices_histories_pkey PRIMARY KEY (id);
1373
1374
1375--
1376-- Name: devices devices_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1377--
1378
1379ALTER TABLE ONLY public.devices
1380 ADD CONSTRAINT devices_pkey PRIMARY KEY (id);
1381
1382
1383--
1384-- Name: fcm_tokens fcm_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1385--
1386
1387ALTER TABLE ONLY public.fcm_tokens
1388 ADD CONSTRAINT fcm_tokens_pkey PRIMARY KEY (id);
1389
1390
1391--
1392-- Name: logs logs_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1393--
1394
1395ALTER TABLE ONLY public.logs
1396 ADD CONSTRAINT logs_pkey PRIMARY KEY (id);
1397
1398
1399--
1400-- Name: manager_permission manager_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1401--
1402
1403ALTER TABLE ONLY public.manager_permission
1404 ADD CONSTRAINT manager_permission_pkey PRIMARY KEY (id);
1405
1406
1407--
1408-- Name: manager_role manager_role_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1409--
1410
1411ALTER TABLE ONLY public.manager_role
1412 ADD CONSTRAINT manager_role_pkey PRIMARY KEY (id);
1413
1414
1415--
1416-- Name: managers managers_email_unique; Type: CONSTRAINT; Schema: public; Owner: root
1417--
1418
1419ALTER TABLE ONLY public.managers
1420 ADD CONSTRAINT managers_email_unique UNIQUE (email);
1421
1422
1423--
1424-- Name: managers managers_login_unique; Type: CONSTRAINT; Schema: public; Owner: root
1425--
1426
1427ALTER TABLE ONLY public.managers
1428 ADD CONSTRAINT managers_login_unique UNIQUE (login);
1429
1430
1431--
1432-- Name: managers managers_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1433--
1434
1435ALTER TABLE ONLY public.managers
1436 ADD CONSTRAINT managers_pkey PRIMARY KEY (id);
1437
1438
1439--
1440-- Name: orders orders_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1441--
1442
1443ALTER TABLE ONLY public.orders
1444 ADD CONSTRAINT orders_pkey PRIMARY KEY (id);
1445
1446
1447--
1448-- Name: pages pages_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1449--
1450
1451ALTER TABLE ONLY public.pages
1452 ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
1453
1454
1455--
1456-- Name: permission_role permission_role_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1457--
1458
1459ALTER TABLE ONLY public.permission_role
1460 ADD CONSTRAINT permission_role_pkey PRIMARY KEY (id);
1461
1462
1463--
1464-- Name: permissions permissions_name_unique; Type: CONSTRAINT; Schema: public; Owner: root
1465--
1466
1467ALTER TABLE ONLY public.permissions
1468 ADD CONSTRAINT permissions_name_unique UNIQUE (name);
1469
1470
1471--
1472-- Name: permissions permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1473--
1474
1475ALTER TABLE ONLY public.permissions
1476 ADD CONSTRAINT permissions_pkey PRIMARY KEY (id);
1477
1478
1479--
1480-- Name: permissions permissions_slug_unique; Type: CONSTRAINT; Schema: public; Owner: root
1481--
1482
1483ALTER TABLE ONLY public.permissions
1484 ADD CONSTRAINT permissions_slug_unique UNIQUE (slug);
1485
1486
1487--
1488-- Name: phones_confirmations phones_confirmations_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1489--
1490
1491ALTER TABLE ONLY public.phones_confirmations
1492 ADD CONSTRAINT phones_confirmations_pkey PRIMARY KEY (id);
1493
1494
1495--
1496-- Name: rides_histories rides_histories_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1497--
1498
1499ALTER TABLE ONLY public.rides_histories
1500 ADD CONSTRAINT rides_histories_pkey PRIMARY KEY (id);
1501
1502
1503--
1504-- Name: roles roles_name_unique; Type: CONSTRAINT; Schema: public; Owner: root
1505--
1506
1507ALTER TABLE ONLY public.roles
1508 ADD CONSTRAINT roles_name_unique UNIQUE (name);
1509
1510
1511--
1512-- Name: roles roles_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1513--
1514
1515ALTER TABLE ONLY public.roles
1516 ADD CONSTRAINT roles_pkey PRIMARY KEY (id);
1517
1518
1519--
1520-- Name: roles roles_slug_unique; Type: CONSTRAINT; Schema: public; Owner: root
1521--
1522
1523ALTER TABLE ONLY public.roles
1524 ADD CONSTRAINT roles_slug_unique UNIQUE (slug);
1525
1526
1527--
1528-- Name: settings settings_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1529--
1530
1531ALTER TABLE ONLY public.settings
1532 ADD CONSTRAINT settings_pkey PRIMARY KEY (id);
1533
1534
1535--
1536-- Name: shapes shapes_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1537--
1538
1539ALTER TABLE ONLY public.shapes
1540 ADD CONSTRAINT shapes_pkey PRIMARY KEY (id);
1541
1542
1543--
1544-- Name: tokens tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1545--
1546
1547ALTER TABLE ONLY public.tokens
1548 ADD CONSTRAINT tokens_pkey PRIMARY KEY (id);
1549
1550
1551--
1552-- Name: tokens tokens_token_unique; Type: CONSTRAINT; Schema: public; Owner: root
1553--
1554
1555ALTER TABLE ONLY public.tokens
1556 ADD CONSTRAINT tokens_token_unique UNIQUE (token);
1557
1558
1559--
1560-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: root
1561--
1562
1563ALTER TABLE ONLY public.users
1564 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
1565
1566
1567--
1568-- Name: manager_permission_manager_id_index; Type: INDEX; Schema: public; Owner: root
1569--
1570
1571CREATE INDEX manager_permission_manager_id_index ON public.manager_permission USING btree (manager_id);
1572
1573
1574--
1575-- Name: manager_permission_permission_id_index; Type: INDEX; Schema: public; Owner: root
1576--
1577
1578CREATE INDEX manager_permission_permission_id_index ON public.manager_permission USING btree (permission_id);
1579
1580
1581--
1582-- Name: manager_role_manager_id_index; Type: INDEX; Schema: public; Owner: root
1583--
1584
1585CREATE INDEX manager_role_manager_id_index ON public.manager_role USING btree (manager_id);
1586
1587
1588--
1589-- Name: manager_role_role_id_index; Type: INDEX; Schema: public; Owner: root
1590--
1591
1592CREATE INDEX manager_role_role_id_index ON public.manager_role USING btree (role_id);
1593
1594
1595--
1596-- Name: permission_role_permission_id_index; Type: INDEX; Schema: public; Owner: root
1597--
1598
1599CREATE INDEX permission_role_permission_id_index ON public.permission_role USING btree (permission_id);
1600
1601
1602--
1603-- Name: permission_role_role_id_index; Type: INDEX; Schema: public; Owner: root
1604--
1605
1606CREATE INDEX permission_role_role_id_index ON public.permission_role USING btree (role_id);
1607
1608
1609--
1610-- Name: tokens_token_index; Type: INDEX; Schema: public; Owner: root
1611--
1612
1613CREATE INDEX tokens_token_index ON public.tokens USING btree (token);
1614
1615
1616--
1617-- Name: manager_permission manager_permission_manager_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: root
1618--
1619
1620ALTER TABLE ONLY public.manager_permission
1621 ADD CONSTRAINT manager_permission_manager_id_foreign FOREIGN KEY (manager_id) REFERENCES public.managers(id) ON DELETE CASCADE;
1622
1623
1624--
1625-- Name: manager_permission manager_permission_permission_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: root
1626--
1627
1628ALTER TABLE ONLY public.manager_permission
1629 ADD CONSTRAINT manager_permission_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.permissions(id) ON DELETE CASCADE;
1630
1631
1632--
1633-- Name: manager_role manager_role_manager_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: root
1634--
1635
1636ALTER TABLE ONLY public.manager_role
1637 ADD CONSTRAINT manager_role_manager_id_foreign FOREIGN KEY (manager_id) REFERENCES public.managers(id) ON DELETE CASCADE;
1638
1639
1640--
1641-- Name: manager_role manager_role_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: root
1642--
1643
1644ALTER TABLE ONLY public.manager_role
1645 ADD CONSTRAINT manager_role_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;
1646
1647
1648--
1649-- Name: permission_role permission_role_permission_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: root
1650--
1651
1652ALTER TABLE ONLY public.permission_role
1653 ADD CONSTRAINT permission_role_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.permissions(id) ON DELETE CASCADE;
1654
1655
1656--
1657-- Name: permission_role permission_role_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: root
1658--
1659
1660ALTER TABLE ONLY public.permission_role
1661 ADD CONSTRAINT permission_role_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;
1662
1663
1664--
1665-- Name: tokens tokens_manager_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: root
1666--
1667
1668ALTER TABLE ONLY public.tokens
1669 ADD CONSTRAINT tokens_manager_id_foreign FOREIGN KEY (manager_id) REFERENCES public.managers(id);
1670
1671
1672--
1673-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: root
1674--
1675
1676REVOKE ALL ON SCHEMA public FROM PUBLIC;
1677REVOKE ALL ON SCHEMA public FROM root;
1678GRANT ALL ON SCHEMA public TO root;
1679GRANT ALL ON SCHEMA public TO PUBLIC;
1680
1681
1682--
1683-- PostgreSQL database dump complete
1684--