· 10 years ago · Aug 26, 2016, 08:32 AM
1--
2-- PostgreSQL database dump
3--
4
5SET statement_timeout = 0;
6SET client_encoding = 'UTF8';
7SET standard_conforming_strings = on;
8SET check_function_bodies = false;
9SET client_min_messages = warning;
10
11--
12-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
13--
14
15CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
16
17
18--
19-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
20--
21
22COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
23
24
25--
26-- Name: hstore; Type: EXTENSION; Schema: -; Owner: -
27--
28
29CREATE EXTENSION IF NOT EXISTS hstore WITH SCHEMA public;
30
31
32--
33-- Name: EXTENSION hstore; Type: COMMENT; Schema: -; Owner: -
34--
35
36COMMENT ON EXTENSION hstore IS 'data type for storing sets of (key, value) pairs';
37
38
39SET search_path = public, pg_catalog;
40
41SET default_tablespace = '';
42
43SET default_with_oids = false;
44
45--
46-- Name: announcements; Type: TABLE; Schema: public; Owner: -; Tablespace:
47--
48
49CREATE TABLE announcements (
50 id integer NOT NULL,
51 content text,
52 block_app boolean,
53 visible boolean,
54 deadline timestamp without time zone,
55 created_at timestamp without time zone,
56 updated_at timestamp without time zone,
57 sex integer[] DEFAULT '{}'::integer[],
58 city character varying(255)[] DEFAULT '{}'::character varying[],
59 accepted_reports_count_min integer,
60 accepted_reports_count_max integer,
61 ltd double precision,
62 lgt double precision,
63 radius integer,
64 platform_ios boolean DEFAULT false,
65 platform_android boolean DEFAULT false,
66 less_than_major_version integer,
67 less_than_minor_version integer,
68 less_than_patch_version integer,
69 activate_at timestamp without time zone,
70 deactivate_at timestamp without time zone
71);
72
73
74--
75-- Name: announcements_id_seq; Type: SEQUENCE; Schema: public; Owner: -
76--
77
78CREATE SEQUENCE announcements_id_seq
79 START WITH 1
80 INCREMENT BY 1
81 NO MINVALUE
82 NO MAXVALUE
83 CACHE 1;
84
85
86--
87-- Name: announcements_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
88--
89
90ALTER SEQUENCE announcements_id_seq OWNED BY announcements.id;
91
92
93--
94-- Name: answer_files; Type: TABLE; Schema: public; Owner: -; Tablespace:
95--
96
97CREATE TABLE answer_files (
98 id integer NOT NULL,
99 answer_id integer,
100 file character varying(255),
101 created_at timestamp without time zone,
102 updated_at timestamp without time zone,
103 type character varying(255),
104 "position" integer
105);
106
107
108--
109-- Name: answer_files_id_seq; Type: SEQUENCE; Schema: public; Owner: -
110--
111
112CREATE SEQUENCE answer_files_id_seq
113 START WITH 1
114 INCREMENT BY 1
115 NO MINVALUE
116 NO MAXVALUE
117 CACHE 1;
118
119
120--
121-- Name: answer_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
122--
123
124ALTER SEQUENCE answer_files_id_seq OWNED BY answer_files.id;
125
126
127--
128-- Name: answer_options; Type: TABLE; Schema: public; Owner: -; Tablespace:
129--
130
131CREATE TABLE answer_options (
132 id integer NOT NULL,
133 answer_id integer,
134 key character varying(255),
135 name character varying(255),
136 value character varying(255),
137 created_at timestamp without time zone,
138 updated_at timestamp without time zone
139);
140
141
142--
143-- Name: answer_options_id_seq; Type: SEQUENCE; Schema: public; Owner: -
144--
145
146CREATE SEQUENCE answer_options_id_seq
147 START WITH 1
148 INCREMENT BY 1
149 NO MINVALUE
150 NO MAXVALUE
151 CACHE 1;
152
153
154--
155-- Name: answer_options_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
156--
157
158ALTER SEQUENCE answer_options_id_seq OWNED BY answer_options.id;
159
160
161--
162-- Name: answers; Type: TABLE; Schema: public; Owner: -; Tablespace:
163--
164
165CREATE TABLE answers (
166 id integer NOT NULL,
167 report_id integer,
168 step_id character varying(255),
169 key character varying(255),
170 question text,
171 type character varying(255),
172 value text,
173 ltd double precision,
174 lgt double precision,
175 accuracy character varying(255),
176 "position" integer,
177 performed_at timestamp without time zone,
178 trouble boolean DEFAULT false,
179 barcodes text[] DEFAULT '{}'::text[],
180 geo_object_id integer
181);
182
183
184--
185-- Name: answers_id_seq; Type: SEQUENCE; Schema: public; Owner: -
186--
187
188CREATE SEQUENCE answers_id_seq
189 START WITH 1
190 INCREMENT BY 1
191 NO MINVALUE
192 NO MAXVALUE
193 CACHE 1;
194
195
196--
197-- Name: answers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
198--
199
200ALTER SEQUENCE answers_id_seq OWNED BY answers.id;
201
202
203--
204-- Name: background_jobs; Type: TABLE; Schema: public; Owner: -; Tablespace:
205--
206
207CREATE TABLE background_jobs (
208 id integer NOT NULL,
209 user_id integer,
210 type character varying(255),
211 jid character varying(255),
212 state character varying(255) NOT NULL,
213 params text,
214 results text,
215 failures text,
216 files_expiration_date date,
217 files_expired_at timestamp without time zone,
218 created_at timestamp without time zone,
219 updated_at timestamp without time zone,
220 input_files json,
221 output_files json
222);
223
224
225--
226-- Name: background_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
227--
228
229CREATE SEQUENCE background_jobs_id_seq
230 START WITH 1
231 INCREMENT BY 1
232 NO MINVALUE
233 NO MAXVALUE
234 CACHE 1;
235
236
237--
238-- Name: background_jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
239--
240
241ALTER SEQUENCE background_jobs_id_seq OWNED BY background_jobs.id;
242
243
244--
245-- Name: devices; Type: TABLE; Schema: public; Owner: -; Tablespace:
246--
247
248CREATE TABLE devices (
249 id integer NOT NULL,
250 user_id integer,
251 uuid character varying(255),
252 push_token character varying(255),
253 authentication_token character varying(255),
254 platform character varying(255),
255 specs hstore,
256 last_sign_in_at timestamp without time zone,
257 last_action_at timestamp without time zone,
258 created_at timestamp without time zone,
259 updated_at timestamp without time zone
260);
261
262
263--
264-- Name: devices_id_seq; Type: SEQUENCE; Schema: public; Owner: -
265--
266
267CREATE SEQUENCE devices_id_seq
268 START WITH 1
269 INCREMENT BY 1
270 NO MINVALUE
271 NO MAXVALUE
272 CACHE 1;
273
274
275--
276-- Name: devices_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
277--
278
279ALTER SEQUENCE devices_id_seq OWNED BY devices.id;
280
281
282--
283-- Name: devices_logs; Type: TABLE; Schema: public; Owner: -; Tablespace:
284--
285
286CREATE TABLE devices_logs (
287 id integer NOT NULL,
288 user_id integer,
289 device text,
290 content text,
291 created_at timestamp without time zone,
292 updated_at timestamp without time zone
293);
294
295
296--
297-- Name: devices_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
298--
299
300CREATE SEQUENCE devices_logs_id_seq
301 START WITH 1
302 INCREMENT BY 1
303 NO MINVALUE
304 NO MAXVALUE
305 CACHE 1;
306
307
308--
309-- Name: devices_logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
310--
311
312ALTER SEQUENCE devices_logs_id_seq OWNED BY devices_logs.id;
313
314
315--
316-- Name: export_templates; Type: TABLE; Schema: public; Owner: -; Tablespace:
317--
318
319CREATE TABLE export_templates (
320 id integer NOT NULL,
321 type character varying(255),
322 file character varying(255),
323 content text,
324 created_at timestamp without time zone,
325 updated_at timestamp without time zone,
326 title character varying(255)
327);
328
329
330--
331-- Name: export_templates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
332--
333
334CREATE SEQUENCE export_templates_id_seq
335 START WITH 1
336 INCREMENT BY 1
337 NO MINVALUE
338 NO MAXVALUE
339 CACHE 1;
340
341
342--
343-- Name: export_templates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
344--
345
346ALTER SEQUENCE export_templates_id_seq OWNED BY export_templates.id;
347
348
349--
350-- Name: geo_objects; Type: TABLE; Schema: public; Owner: -; Tablespace:
351--
352
353CREATE TABLE geo_objects (
354 id integer NOT NULL,
355 ltd double precision,
356 lgt double precision,
357 accuracy integer DEFAULT 0,
358 country character varying(255),
359 region character varying(255),
360 city character varying(255),
361 street character varying(255),
362 house character varying(255),
363 comment text,
364 created_at timestamp without time zone,
365 updated_at timestamp without time zone,
366 title character varying(255),
367 territory character varying(255)
368);
369
370
371--
372-- Name: geo_objects_id_seq; Type: SEQUENCE; Schema: public; Owner: -
373--
374
375CREATE SEQUENCE geo_objects_id_seq
376 START WITH 1
377 INCREMENT BY 1
378 NO MINVALUE
379 NO MAXVALUE
380 CACHE 1;
381
382
383--
384-- Name: geo_objects_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
385--
386
387ALTER SEQUENCE geo_objects_id_seq OWNED BY geo_objects.id;
388
389
390--
391-- Name: geo_sectors; Type: TABLE; Schema: public; Owner: -; Tablespace:
392--
393
394CREATE TABLE geo_sectors (
395 id integer NOT NULL,
396 title character varying(255),
397 description text,
398 ltd double precision,
399 lgt double precision,
400 polygon text,
401 country character varying(255),
402 region character varying(255),
403 city character varying(255),
404 comment text,
405 created_at timestamp without time zone,
406 updated_at timestamp without time zone
407);
408
409
410--
411-- Name: geo_sectors_id_seq; Type: SEQUENCE; Schema: public; Owner: -
412--
413
414CREATE SEQUENCE geo_sectors_id_seq
415 START WITH 1
416 INCREMENT BY 1
417 NO MINVALUE
418 NO MAXVALUE
419 CACHE 1;
420
421
422--
423-- Name: geo_sectors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
424--
425
426ALTER SEQUENCE geo_sectors_id_seq OWNED BY geo_sectors.id;
427
428
429--
430-- Name: groups; Type: TABLE; Schema: public; Owner: -; Tablespace:
431--
432
433CREATE TABLE groups (
434 id integer NOT NULL,
435 title character varying(255),
436 created_at timestamp without time zone,
437 updated_at timestamp without time zone
438);
439
440
441--
442-- Name: groups_id_seq; Type: SEQUENCE; Schema: public; Owner: -
443--
444
445CREATE SEQUENCE groups_id_seq
446 START WITH 1
447 INCREMENT BY 1
448 NO MINVALUE
449 NO MAXVALUE
450 CACHE 1;
451
452
453--
454-- Name: groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
455--
456
457ALTER SEQUENCE groups_id_seq OWNED BY groups.id;
458
459
460--
461-- Name: groups_members; Type: TABLE; Schema: public; Owner: -; Tablespace:
462--
463
464CREATE TABLE groups_members (
465 group_id integer,
466 member_id integer,
467 member_type character varying(255),
468 id integer NOT NULL
469);
470
471
472--
473-- Name: groups_members_id_seq; Type: SEQUENCE; Schema: public; Owner: -
474--
475
476CREATE SEQUENCE groups_members_id_seq
477 START WITH 1
478 INCREMENT BY 1
479 NO MINVALUE
480 NO MAXVALUE
481 CACHE 1;
482
483
484--
485-- Name: groups_members_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
486--
487
488ALTER SEQUENCE groups_members_id_seq OWNED BY groups_members.id;
489
490
491--
492-- Name: notifications; Type: TABLE; Schema: public; Owner: -; Tablespace:
493--
494
495CREATE TABLE notifications (
496 id integer NOT NULL,
497 addressee_id integer,
498 addresser_id integer,
499 type character varying(255),
500 destination character varying(255),
501 content text,
502 state character varying(255),
503 retry_count integer DEFAULT 0,
504 delivered_at timestamp without time zone,
505 log text,
506 created_at timestamp without time zone,
507 updated_at timestamp without time zone,
508 options json
509);
510
511
512--
513-- Name: notifications_id_seq; Type: SEQUENCE; Schema: public; Owner: -
514--
515
516CREATE SEQUENCE notifications_id_seq
517 START WITH 1
518 INCREMENT BY 1
519 NO MINVALUE
520 NO MAXVALUE
521 CACHE 1;
522
523
524--
525-- Name: notifications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
526--
527
528ALTER SEQUENCE notifications_id_seq OWNED BY notifications.id;
529
530
531--
532-- Name: preferences; Type: TABLE; Schema: public; Owner: -; Tablespace:
533--
534
535CREATE TABLE preferences (
536 id integer NOT NULL,
537 key character varying(255),
538 value text,
539 file character varying(255)
540);
541
542
543--
544-- Name: preferences_id_seq; Type: SEQUENCE; Schema: public; Owner: -
545--
546
547CREATE SEQUENCE preferences_id_seq
548 START WITH 1
549 INCREMENT BY 1
550 NO MINVALUE
551 NO MAXVALUE
552 CACHE 1;
553
554
555--
556-- Name: preferences_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
557--
558
559ALTER SEQUENCE preferences_id_seq OWNED BY preferences.id;
560
561
562--
563-- Name: projects; Type: TABLE; Schema: public; Owner: -; Tablespace:
564--
565
566CREATE TABLE projects (
567 id integer NOT NULL,
568 worker_title character varying(255),
569 worker_description text,
570 state character varying(255) DEFAULT 'active'::character varying,
571 time_for_execution integer,
572 staff_title character varying(255),
573 staff_description text,
574 staff_start_date date,
575 staff_end_date date,
576 moderated boolean DEFAULT false,
577 required_reports_count integer DEFAULT 0,
578 created_at timestamp without time zone,
579 updated_at timestamp without time zone,
580 report_title_pattern character varying(255),
581 notification_emails text[] DEFAULT '{}'::text[],
582 js_content character varying(255),
583 content_type character varying(255) DEFAULT 'json'::character varying,
584 default_report_template_id integer
585);
586
587
588--
589-- Name: projects_id_seq; Type: SEQUENCE; Schema: public; Owner: -
590--
591
592CREATE SEQUENCE projects_id_seq
593 START WITH 1
594 INCREMENT BY 1
595 NO MINVALUE
596 NO MAXVALUE
597 CACHE 1;
598
599
600--
601-- Name: projects_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
602--
603
604ALTER SEQUENCE projects_id_seq OWNED BY projects.id;
605
606
607--
608-- Name: reasons; Type: TABLE; Schema: public; Owner: -; Tablespace:
609--
610
611CREATE TABLE reasons (
612 id integer NOT NULL,
613 project_id integer,
614 name character varying(255),
615 created_at timestamp without time zone,
616 updated_at timestamp without time zone
617);
618
619
620--
621-- Name: reasons_id_seq; Type: SEQUENCE; Schema: public; Owner: -
622--
623
624CREATE SEQUENCE reasons_id_seq
625 START WITH 1
626 INCREMENT BY 1
627 NO MINVALUE
628 NO MAXVALUE
629 CACHE 1;
630
631
632--
633-- Name: reasons_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
634--
635
636ALTER SEQUENCE reasons_id_seq OWNED BY reasons.id;
637
638
639--
640-- Name: reports; Type: TABLE; Schema: public; Owner: -; Tablespace:
641--
642
643CREATE TABLE reports (
644 id integer NOT NULL,
645 task_id integer,
646 user_id integer,
647 title character varying(255),
648 state character varying(255),
649 moderator_id integer,
650 moderator_comment text,
651 moderated_at timestamp without time zone,
652 worker_comment text,
653 client_visible boolean DEFAULT false,
654 ltd double precision,
655 lgt double precision,
656 uuid character varying(255),
657 created_at timestamp without time zone,
658 updated_at timestamp without time zone,
659 source character varying(255),
660 performed_at timestamp without time zone,
661 device text,
662 public_uuid character varying(255)
663);
664
665
666--
667-- Name: reports_id_seq; Type: SEQUENCE; Schema: public; Owner: -
668--
669
670CREATE SEQUENCE reports_id_seq
671 START WITH 1
672 INCREMENT BY 1
673 NO MINVALUE
674 NO MAXVALUE
675 CACHE 1;
676
677
678--
679-- Name: reports_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
680--
681
682ALTER SEQUENCE reports_id_seq OWNED BY reports.id;
683
684
685--
686-- Name: reservations; Type: TABLE; Schema: public; Owner: -; Tablespace:
687--
688
689CREATE TABLE reservations (
690 id integer NOT NULL,
691 user_id integer,
692 task_id integer,
693 reports_count integer DEFAULT 0,
694 max_reports_count integer,
695 completed boolean DEFAULT false,
696 created_at timestamp without time zone,
697 updated_at timestamp without time zone,
698 start_date timestamp without time zone,
699 stop_date timestamp without time zone,
700 allow_start_before_start_date boolean DEFAULT false,
701 allow_start_after_stop_date boolean DEFAULT false
702);
703
704
705--
706-- Name: reservations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
707--
708
709CREATE SEQUENCE reservations_id_seq
710 START WITH 1
711 INCREMENT BY 1
712 NO MINVALUE
713 NO MAXVALUE
714 CACHE 1;
715
716
717--
718-- Name: reservations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
719--
720
721ALTER SEQUENCE reservations_id_seq OWNED BY reservations.id;
722
723
724--
725-- Name: scenario_elements; Type: TABLE; Schema: public; Owner: -; Tablespace:
726--
727
728CREATE TABLE scenario_elements (
729 id integer NOT NULL,
730 template_id integer,
731 step_id integer,
732 sku_id integer,
733 key character varying(255),
734 type character varying(255),
735 "position" integer,
736 title text,
737 placeholder text,
738 multiple_values text,
739 min integer,
740 max integer,
741 required boolean DEFAULT false,
742 value text,
743 goto integer,
744 eql_type character varying(255),
745 human_name text,
746 image_name character varying(255),
747 media_name_key character varying(255),
748 format character varying(255),
749 from_gallery boolean DEFAULT false,
750 created_at timestamp without time zone,
751 updated_at timestamp without time zone,
752 options json
753);
754
755
756--
757-- Name: scenario_elements_id_seq; Type: SEQUENCE; Schema: public; Owner: -
758--
759
760CREATE SEQUENCE scenario_elements_id_seq
761 START WITH 1
762 INCREMENT BY 1
763 NO MINVALUE
764 NO MAXVALUE
765 CACHE 1;
766
767
768--
769-- Name: scenario_elements_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
770--
771
772ALTER SEQUENCE scenario_elements_id_seq OWNED BY scenario_elements.id;
773
774
775--
776-- Name: scenario_hints; Type: TABLE; Schema: public; Owner: -; Tablespace:
777--
778
779CREATE TABLE scenario_hints (
780 id integer NOT NULL,
781 scenario_id integer,
782 title character varying(255),
783 content text,
784 name character varying(255),
785 "default" boolean DEFAULT false,
786 created_at timestamp without time zone,
787 updated_at timestamp without time zone
788);
789
790
791--
792-- Name: scenario_hints_id_seq; Type: SEQUENCE; Schema: public; Owner: -
793--
794
795CREATE SEQUENCE scenario_hints_id_seq
796 START WITH 1
797 INCREMENT BY 1
798 NO MINVALUE
799 NO MAXVALUE
800 CACHE 1;
801
802
803--
804-- Name: scenario_hints_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
805--
806
807ALTER SEQUENCE scenario_hints_id_seq OWNED BY scenario_hints.id;
808
809
810--
811-- Name: scenario_images; Type: TABLE; Schema: public; Owner: -; Tablespace:
812--
813
814CREATE TABLE scenario_images (
815 id integer NOT NULL,
816 scenario_id integer,
817 name character varying(255),
818 created_at timestamp without time zone,
819 updated_at timestamp without time zone,
820 file character varying(255)
821);
822
823
824--
825-- Name: scenario_images_id_seq; Type: SEQUENCE; Schema: public; Owner: -
826--
827
828CREATE SEQUENCE scenario_images_id_seq
829 START WITH 1
830 INCREMENT BY 1
831 NO MINVALUE
832 NO MAXVALUE
833 CACHE 1;
834
835
836--
837-- Name: scenario_images_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
838--
839
840ALTER SEQUENCE scenario_images_id_seq OWNED BY scenario_images.id;
841
842
843--
844-- Name: scenario_skus; Type: TABLE; Schema: public; Owner: -; Tablespace:
845--
846
847CREATE TABLE scenario_skus (
848 id integer NOT NULL,
849 scenario_id integer,
850 title character varying(255),
851 created_at timestamp without time zone,
852 updated_at timestamp without time zone
853);
854
855
856--
857-- Name: scenario_skus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
858--
859
860CREATE SEQUENCE scenario_skus_id_seq
861 START WITH 1
862 INCREMENT BY 1
863 NO MINVALUE
864 NO MAXVALUE
865 CACHE 1;
866
867
868--
869-- Name: scenario_skus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
870--
871
872ALTER SEQUENCE scenario_skus_id_seq OWNED BY scenario_skus.id;
873
874
875--
876-- Name: scenario_steps; Type: TABLE; Schema: public; Owner: -; Tablespace:
877--
878
879CREATE TABLE scenario_steps (
880 id integer NOT NULL,
881 scenario_id integer,
882 sku_id integer,
883 template_id integer,
884 type character varying(255),
885 "position" integer,
886 allowed_radius integer,
887 hint_name character varying(255),
888 trouble_name character varying(255),
889 created_at timestamp without time zone,
890 updated_at timestamp without time zone,
891 after_conditions json,
892 before_conditions json
893);
894
895
896--
897-- Name: scenario_steps_id_seq; Type: SEQUENCE; Schema: public; Owner: -
898--
899
900CREATE SEQUENCE scenario_steps_id_seq
901 START WITH 1
902 INCREMENT BY 1
903 NO MINVALUE
904 NO MAXVALUE
905 CACHE 1;
906
907
908--
909-- Name: scenario_steps_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
910--
911
912ALTER SEQUENCE scenario_steps_id_seq OWNED BY scenario_steps.id;
913
914
915--
916-- Name: scenario_templates; Type: TABLE; Schema: public; Owner: -; Tablespace:
917--
918
919CREATE TABLE scenario_templates (
920 id integer NOT NULL,
921 project_id integer,
922 name character varying(255),
923 title character varying(255),
924 content text,
925 type character varying(255),
926 created_at timestamp without time zone,
927 updated_at timestamp without time zone
928);
929
930
931--
932-- Name: scenario_templates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
933--
934
935CREATE SEQUENCE scenario_templates_id_seq
936 START WITH 1
937 INCREMENT BY 1
938 NO MINVALUE
939 NO MAXVALUE
940 CACHE 1;
941
942
943--
944-- Name: scenario_templates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
945--
946
947ALTER SEQUENCE scenario_templates_id_seq OWNED BY scenario_templates.id;
948
949
950--
951-- Name: scenario_troubles; Type: TABLE; Schema: public; Owner: -; Tablespace:
952--
953
954CREATE TABLE scenario_troubles (
955 id integer NOT NULL,
956 scenario_id integer,
957 title character varying(255),
958 content text,
959 name character varying(255),
960 "default" boolean DEFAULT false,
961 created_at timestamp without time zone,
962 updated_at timestamp without time zone
963);
964
965
966--
967-- Name: scenario_troubles_id_seq; Type: SEQUENCE; Schema: public; Owner: -
968--
969
970CREATE SEQUENCE scenario_troubles_id_seq
971 START WITH 1
972 INCREMENT BY 1
973 NO MINVALUE
974 NO MAXVALUE
975 CACHE 1;
976
977
978--
979-- Name: scenario_troubles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
980--
981
982ALTER SEQUENCE scenario_troubles_id_seq OWNED BY scenario_troubles.id;
983
984
985--
986-- Name: scenarios; Type: TABLE; Schema: public; Owner: -; Tablespace:
987--
988
989CREATE TABLE scenarios (
990 id integer NOT NULL,
991 project_id integer,
992 creator_id integer,
993 type character varying(255),
994 key character varying(255),
995 created_at timestamp without time zone,
996 updated_at timestamp without time zone
997);
998
999
1000--
1001-- Name: scenarios_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1002--
1003
1004CREATE SEQUENCE scenarios_id_seq
1005 START WITH 1
1006 INCREMENT BY 1
1007 NO MINVALUE
1008 NO MAXVALUE
1009 CACHE 1;
1010
1011
1012--
1013-- Name: scenarios_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1014--
1015
1016ALTER SEQUENCE scenarios_id_seq OWNED BY scenarios.id;
1017
1018
1019--
1020-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -; Tablespace:
1021--
1022
1023CREATE TABLE schema_migrations (
1024 version character varying(255) NOT NULL
1025);
1026
1027
1028--
1029-- Name: sku_images; Type: TABLE; Schema: public; Owner: -; Tablespace:
1030--
1031
1032CREATE TABLE sku_images (
1033 id integer NOT NULL,
1034 sku_id integer,
1035 file character varying(255),
1036 "position" integer,
1037 created_at timestamp without time zone,
1038 updated_at timestamp without time zone
1039);
1040
1041
1042--
1043-- Name: sku_images_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1044--
1045
1046CREATE SEQUENCE sku_images_id_seq
1047 START WITH 1
1048 INCREMENT BY 1
1049 NO MINVALUE
1050 NO MAXVALUE
1051 CACHE 1;
1052
1053
1054--
1055-- Name: sku_images_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1056--
1057
1058ALTER SEQUENCE sku_images_id_seq OWNED BY sku_images.id;
1059
1060
1061--
1062-- Name: skus; Type: TABLE; Schema: public; Owner: -; Tablespace:
1063--
1064
1065CREATE TABLE skus (
1066 id integer NOT NULL,
1067 barcode character varying(255),
1068 title text,
1069 manufacturer text,
1070 moderated boolean DEFAULT false,
1071 created_at timestamp without time zone,
1072 updated_at timestamp without time zone,
1073 level2 text,
1074 level3 text,
1075 level4 text,
1076 level5 text,
1077 own_brand boolean DEFAULT false,
1078 dixy_code text DEFAULT ''::text,
1079 ma_code character varying(255)
1080);
1081
1082
1083--
1084-- Name: skus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1085--
1086
1087CREATE SEQUENCE skus_id_seq
1088 START WITH 1
1089 INCREMENT BY 1
1090 NO MINVALUE
1091 NO MAXVALUE
1092 CACHE 1;
1093
1094
1095--
1096-- Name: skus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1097--
1098
1099ALTER SEQUENCE skus_id_seq OWNED BY skus.id;
1100
1101
1102--
1103-- Name: tasks; Type: TABLE; Schema: public; Owner: -; Tablespace:
1104--
1105
1106CREATE TABLE tasks (
1107 id integer NOT NULL,
1108 project_id integer,
1109 title character varying(255),
1110 description text,
1111 reports_per_worker integer DEFAULT 1,
1112 state character varying(255) DEFAULT 'active'::character varying,
1113 ltd double precision,
1114 lgt double precision,
1115 variables text,
1116 priority integer DEFAULT 0,
1117 created_at timestamp without time zone,
1118 updated_at timestamp without time zone,
1119 geo_sector_id integer,
1120 geo_object_id integer,
1121 max_workers_count integer DEFAULT 0,
1122 reservable_by_worker boolean DEFAULT false,
1123 rejectable_by_worker boolean DEFAULT false,
1124 bundle character varying(255),
1125 code character varying(255),
1126 amount_of_work integer DEFAULT 0,
1127 start_date timestamp without time zone,
1128 stop_date timestamp without time zone,
1129 wave character varying(255)
1130);
1131
1132
1133--
1134-- Name: tasks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1135--
1136
1137CREATE SEQUENCE tasks_id_seq
1138 START WITH 1
1139 INCREMENT BY 1
1140 NO MINVALUE
1141 NO MAXVALUE
1142 CACHE 1;
1143
1144
1145--
1146-- Name: tasks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1147--
1148
1149ALTER SEQUENCE tasks_id_seq OWNED BY tasks.id;
1150
1151
1152--
1153-- Name: tasks_users_blacklist; Type: TABLE; Schema: public; Owner: -; Tablespace:
1154--
1155
1156CREATE TABLE tasks_users_blacklist (
1157 id integer NOT NULL,
1158 user_id integer,
1159 task_id integer
1160);
1161
1162
1163--
1164-- Name: tasks_users_blacklist_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1165--
1166
1167CREATE SEQUENCE tasks_users_blacklist_id_seq
1168 START WITH 1
1169 INCREMENT BY 1
1170 NO MINVALUE
1171 NO MAXVALUE
1172 CACHE 1;
1173
1174
1175--
1176-- Name: tasks_users_blacklist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1177--
1178
1179ALTER SEQUENCE tasks_users_blacklist_id_seq OWNED BY tasks_users_blacklist.id;
1180
1181
1182--
1183-- Name: ticket_comments; Type: TABLE; Schema: public; Owner: -; Tablespace:
1184--
1185
1186CREATE TABLE ticket_comments (
1187 id integer NOT NULL,
1188 ticket_id integer,
1189 value text,
1190 user_id integer,
1191 specs text,
1192 created_at timestamp without time zone,
1193 updated_at timestamp without time zone,
1194 scope character varying(255)
1195);
1196
1197
1198--
1199-- Name: ticket_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1200--
1201
1202CREATE SEQUENCE ticket_comments_id_seq
1203 START WITH 1
1204 INCREMENT BY 1
1205 NO MINVALUE
1206 NO MAXVALUE
1207 CACHE 1;
1208
1209
1210--
1211-- Name: ticket_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1212--
1213
1214ALTER SEQUENCE ticket_comments_id_seq OWNED BY ticket_comments.id;
1215
1216
1217--
1218-- Name: ticket_files; Type: TABLE; Schema: public; Owner: -; Tablespace:
1219--
1220
1221CREATE TABLE ticket_files (
1222 id integer NOT NULL,
1223 comment_id integer,
1224 file character varying(255),
1225 "position" integer,
1226 created_at timestamp without time zone,
1227 updated_at timestamp without time zone
1228);
1229
1230
1231--
1232-- Name: ticket_files_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1233--
1234
1235CREATE SEQUENCE ticket_files_id_seq
1236 START WITH 1
1237 INCREMENT BY 1
1238 NO MINVALUE
1239 NO MAXVALUE
1240 CACHE 1;
1241
1242
1243--
1244-- Name: ticket_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1245--
1246
1247ALTER SEQUENCE ticket_files_id_seq OWNED BY ticket_files.id;
1248
1249
1250--
1251-- Name: tickets; Type: TABLE; Schema: public; Owner: -; Tablespace:
1252--
1253
1254CREATE TABLE tickets (
1255 id integer NOT NULL,
1256 initiator_id integer,
1257 performer_id integer,
1258 state character varying(255),
1259 comment text,
1260 created_at timestamp without time zone,
1261 updated_at timestamp without time zone
1262);
1263
1264
1265--
1266-- Name: tickets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1267--
1268
1269CREATE SEQUENCE tickets_id_seq
1270 START WITH 1
1271 INCREMENT BY 1
1272 NO MINVALUE
1273 NO MAXVALUE
1274 CACHE 1;
1275
1276
1277--
1278-- Name: tickets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1279--
1280
1281ALTER SEQUENCE tickets_id_seq OWNED BY tickets.id;
1282
1283
1284--
1285-- Name: unread_tickets; Type: TABLE; Schema: public; Owner: -; Tablespace:
1286--
1287
1288CREATE TABLE unread_tickets (
1289 id integer NOT NULL,
1290 ticket_id integer,
1291 user_id integer,
1292 created_at timestamp without time zone,
1293 updated_at timestamp without time zone
1294);
1295
1296
1297--
1298-- Name: unread_tickets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1299--
1300
1301CREATE SEQUENCE unread_tickets_id_seq
1302 START WITH 1
1303 INCREMENT BY 1
1304 NO MINVALUE
1305 NO MAXVALUE
1306 CACHE 1;
1307
1308
1309--
1310-- Name: unread_tickets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1311--
1312
1313ALTER SEQUENCE unread_tickets_id_seq OWNED BY unread_tickets.id;
1314
1315
1316--
1317-- Name: users; Type: TABLE; Schema: public; Owner: -; Tablespace:
1318--
1319
1320CREATE TABLE users (
1321 id integer NOT NULL,
1322 phone character varying(255),
1323 email character varying(255),
1324 first_name character varying(255),
1325 last_name character varying(255),
1326 sex integer DEFAULT 0,
1327 birthday date,
1328 password_digest character varying(255),
1329 reset_password_token character varying(255),
1330 reset_password_token_expires_at timestamp without time zone,
1331 radius integer DEFAULT 100,
1332 comment text,
1333 roles character varying(255)[] DEFAULT '{}'::character varying[],
1334 ltd double precision,
1335 lgt double precision,
1336 country character varying(255),
1337 region character varying(255),
1338 city character varying(255),
1339 street character varying(255),
1340 house character varying(255),
1341 blocked boolean DEFAULT false NOT NULL,
1342 created_at timestamp without time zone,
1343 updated_at timestamp without time zone,
1344 tracking_enabled boolean DEFAULT false,
1345 hot_tracking_time integer DEFAULT 36000,
1346 medium_tracking_time integer DEFAULT 864000,
1347 hot_tracking_min_distance integer DEFAULT 100,
1348 hot_tracking_interval integer DEFAULT 300,
1349 medium_tracking_min_distance integer DEFAULT 100,
1350 medium_tracking_interval integer DEFAULT 14400,
1351 worker_task_filters_groups_sorts json,
1352 can_edit_filters_and_screens boolean DEFAULT false,
1353 mobile_task_cell_format json
1354);
1355
1356
1357--
1358-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1359--
1360
1361CREATE SEQUENCE users_id_seq
1362 START WITH 1
1363 INCREMENT BY 1
1364 NO MINVALUE
1365 NO MAXVALUE
1366 CACHE 1;
1367
1368
1369--
1370-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1371--
1372
1373ALTER SEQUENCE users_id_seq OWNED BY users.id;
1374
1375
1376--
1377-- Name: versions; Type: TABLE; Schema: public; Owner: -; Tablespace:
1378--
1379
1380CREATE TABLE versions (
1381 id integer NOT NULL,
1382 item_type character varying(255) NOT NULL,
1383 item_id integer NOT NULL,
1384 event character varying(255) NOT NULL,
1385 whodunnit character varying(255),
1386 object text,
1387 object_changes text,
1388 created_at timestamp without time zone,
1389 parent_id integer
1390);
1391
1392
1393--
1394-- Name: versions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1395--
1396
1397CREATE SEQUENCE versions_id_seq
1398 START WITH 1
1399 INCREMENT BY 1
1400 NO MINVALUE
1401 NO MAXVALUE
1402 CACHE 1;
1403
1404
1405--
1406-- Name: versions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1407--
1408
1409ALTER SEQUENCE versions_id_seq OWNED BY versions.id;
1410
1411
1412--
1413-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1414--
1415
1416ALTER TABLE ONLY announcements ALTER COLUMN id SET DEFAULT nextval('announcements_id_seq'::regclass);
1417
1418
1419--
1420-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1421--
1422
1423ALTER TABLE ONLY answer_files ALTER COLUMN id SET DEFAULT nextval('answer_files_id_seq'::regclass);
1424
1425
1426--
1427-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1428--
1429
1430ALTER TABLE ONLY answer_options ALTER COLUMN id SET DEFAULT nextval('answer_options_id_seq'::regclass);
1431
1432
1433--
1434-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1435--
1436
1437ALTER TABLE ONLY answers ALTER COLUMN id SET DEFAULT nextval('answers_id_seq'::regclass);
1438
1439
1440--
1441-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1442--
1443
1444ALTER TABLE ONLY background_jobs ALTER COLUMN id SET DEFAULT nextval('background_jobs_id_seq'::regclass);
1445
1446
1447--
1448-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1449--
1450
1451ALTER TABLE ONLY devices ALTER COLUMN id SET DEFAULT nextval('devices_id_seq'::regclass);
1452
1453
1454--
1455-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1456--
1457
1458ALTER TABLE ONLY devices_logs ALTER COLUMN id SET DEFAULT nextval('devices_logs_id_seq'::regclass);
1459
1460
1461--
1462-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1463--
1464
1465ALTER TABLE ONLY export_templates ALTER COLUMN id SET DEFAULT nextval('export_templates_id_seq'::regclass);
1466
1467
1468--
1469-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1470--
1471
1472ALTER TABLE ONLY geo_objects ALTER COLUMN id SET DEFAULT nextval('geo_objects_id_seq'::regclass);
1473
1474
1475--
1476-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1477--
1478
1479ALTER TABLE ONLY geo_sectors ALTER COLUMN id SET DEFAULT nextval('geo_sectors_id_seq'::regclass);
1480
1481
1482--
1483-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1484--
1485
1486ALTER TABLE ONLY groups ALTER COLUMN id SET DEFAULT nextval('groups_id_seq'::regclass);
1487
1488
1489--
1490-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1491--
1492
1493ALTER TABLE ONLY groups_members ALTER COLUMN id SET DEFAULT nextval('groups_members_id_seq'::regclass);
1494
1495
1496--
1497-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1498--
1499
1500ALTER TABLE ONLY notifications ALTER COLUMN id SET DEFAULT nextval('notifications_id_seq'::regclass);
1501
1502
1503--
1504-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1505--
1506
1507ALTER TABLE ONLY preferences ALTER COLUMN id SET DEFAULT nextval('preferences_id_seq'::regclass);
1508
1509
1510--
1511-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1512--
1513
1514ALTER TABLE ONLY projects ALTER COLUMN id SET DEFAULT nextval('projects_id_seq'::regclass);
1515
1516
1517--
1518-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1519--
1520
1521ALTER TABLE ONLY reasons ALTER COLUMN id SET DEFAULT nextval('reasons_id_seq'::regclass);
1522
1523
1524--
1525-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1526--
1527
1528ALTER TABLE ONLY reports ALTER COLUMN id SET DEFAULT nextval('reports_id_seq'::regclass);
1529
1530
1531--
1532-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1533--
1534
1535ALTER TABLE ONLY reservations ALTER COLUMN id SET DEFAULT nextval('reservations_id_seq'::regclass);
1536
1537
1538--
1539-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1540--
1541
1542ALTER TABLE ONLY scenario_elements ALTER COLUMN id SET DEFAULT nextval('scenario_elements_id_seq'::regclass);
1543
1544
1545--
1546-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1547--
1548
1549ALTER TABLE ONLY scenario_hints ALTER COLUMN id SET DEFAULT nextval('scenario_hints_id_seq'::regclass);
1550
1551
1552--
1553-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1554--
1555
1556ALTER TABLE ONLY scenario_images ALTER COLUMN id SET DEFAULT nextval('scenario_images_id_seq'::regclass);
1557
1558
1559--
1560-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1561--
1562
1563ALTER TABLE ONLY scenario_skus ALTER COLUMN id SET DEFAULT nextval('scenario_skus_id_seq'::regclass);
1564
1565
1566--
1567-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1568--
1569
1570ALTER TABLE ONLY scenario_steps ALTER COLUMN id SET DEFAULT nextval('scenario_steps_id_seq'::regclass);
1571
1572
1573--
1574-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1575--
1576
1577ALTER TABLE ONLY scenario_templates ALTER COLUMN id SET DEFAULT nextval('scenario_templates_id_seq'::regclass);
1578
1579
1580--
1581-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1582--
1583
1584ALTER TABLE ONLY scenario_troubles ALTER COLUMN id SET DEFAULT nextval('scenario_troubles_id_seq'::regclass);
1585
1586
1587--
1588-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1589--
1590
1591ALTER TABLE ONLY scenarios ALTER COLUMN id SET DEFAULT nextval('scenarios_id_seq'::regclass);
1592
1593
1594--
1595-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1596--
1597
1598ALTER TABLE ONLY sku_images ALTER COLUMN id SET DEFAULT nextval('sku_images_id_seq'::regclass);
1599
1600
1601--
1602-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1603--
1604
1605ALTER TABLE ONLY skus ALTER COLUMN id SET DEFAULT nextval('skus_id_seq'::regclass);
1606
1607
1608--
1609-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1610--
1611
1612ALTER TABLE ONLY tasks ALTER COLUMN id SET DEFAULT nextval('tasks_id_seq'::regclass);
1613
1614
1615--
1616-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1617--
1618
1619ALTER TABLE ONLY tasks_users_blacklist ALTER COLUMN id SET DEFAULT nextval('tasks_users_blacklist_id_seq'::regclass);
1620
1621
1622--
1623-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1624--
1625
1626ALTER TABLE ONLY ticket_comments ALTER COLUMN id SET DEFAULT nextval('ticket_comments_id_seq'::regclass);
1627
1628
1629--
1630-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1631--
1632
1633ALTER TABLE ONLY ticket_files ALTER COLUMN id SET DEFAULT nextval('ticket_files_id_seq'::regclass);
1634
1635
1636--
1637-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1638--
1639
1640ALTER TABLE ONLY tickets ALTER COLUMN id SET DEFAULT nextval('tickets_id_seq'::regclass);
1641
1642
1643--
1644-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1645--
1646
1647ALTER TABLE ONLY unread_tickets ALTER COLUMN id SET DEFAULT nextval('unread_tickets_id_seq'::regclass);
1648
1649
1650--
1651-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1652--
1653
1654ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
1655
1656
1657--
1658-- Name: id; Type: DEFAULT; Schema: public; Owner: -
1659--
1660
1661ALTER TABLE ONLY versions ALTER COLUMN id SET DEFAULT nextval('versions_id_seq'::regclass);
1662
1663
1664--
1665-- Name: announcements_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1666--
1667
1668ALTER TABLE ONLY announcements
1669 ADD CONSTRAINT announcements_pkey PRIMARY KEY (id);
1670
1671
1672--
1673-- Name: answer_options_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1674--
1675
1676ALTER TABLE ONLY answer_options
1677 ADD CONSTRAINT answer_options_pkey PRIMARY KEY (id);
1678
1679
1680--
1681-- Name: answers_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1682--
1683
1684ALTER TABLE ONLY answers
1685 ADD CONSTRAINT answers_pkey PRIMARY KEY (id);
1686
1687
1688--
1689-- Name: background_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1690--
1691
1692ALTER TABLE ONLY background_jobs
1693 ADD CONSTRAINT background_jobs_pkey PRIMARY KEY (id);
1694
1695
1696--
1697-- Name: devices_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1698--
1699
1700ALTER TABLE ONLY devices_logs
1701 ADD CONSTRAINT devices_logs_pkey PRIMARY KEY (id);
1702
1703
1704--
1705-- Name: devices_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1706--
1707
1708ALTER TABLE ONLY devices
1709 ADD CONSTRAINT devices_pkey PRIMARY KEY (id);
1710
1711
1712--
1713-- Name: export_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1714--
1715
1716ALTER TABLE ONLY export_templates
1717 ADD CONSTRAINT export_templates_pkey PRIMARY KEY (id);
1718
1719
1720--
1721-- Name: geo_objects_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1722--
1723
1724ALTER TABLE ONLY geo_objects
1725 ADD CONSTRAINT geo_objects_pkey PRIMARY KEY (id);
1726
1727
1728--
1729-- Name: geo_sectors_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1730--
1731
1732ALTER TABLE ONLY geo_sectors
1733 ADD CONSTRAINT geo_sectors_pkey PRIMARY KEY (id);
1734
1735
1736--
1737-- Name: groups_members_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1738--
1739
1740ALTER TABLE ONLY groups_members
1741 ADD CONSTRAINT groups_members_pkey PRIMARY KEY (id);
1742
1743
1744--
1745-- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1746--
1747
1748ALTER TABLE ONLY groups
1749 ADD CONSTRAINT groups_pkey PRIMARY KEY (id);
1750
1751
1752--
1753-- Name: media_files_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1754--
1755
1756ALTER TABLE ONLY answer_files
1757 ADD CONSTRAINT media_files_pkey PRIMARY KEY (id);
1758
1759
1760--
1761-- Name: notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1762--
1763
1764ALTER TABLE ONLY notifications
1765 ADD CONSTRAINT notifications_pkey PRIMARY KEY (id);
1766
1767
1768--
1769-- Name: preferences_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1770--
1771
1772ALTER TABLE ONLY preferences
1773 ADD CONSTRAINT preferences_pkey PRIMARY KEY (id);
1774
1775
1776--
1777-- Name: projects_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1778--
1779
1780ALTER TABLE ONLY projects
1781 ADD CONSTRAINT projects_pkey PRIMARY KEY (id);
1782
1783
1784--
1785-- Name: reasons_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1786--
1787
1788ALTER TABLE ONLY reasons
1789 ADD CONSTRAINT reasons_pkey PRIMARY KEY (id);
1790
1791
1792--
1793-- Name: reports_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1794--
1795
1796ALTER TABLE ONLY reports
1797 ADD CONSTRAINT reports_pkey PRIMARY KEY (id);
1798
1799
1800--
1801-- Name: reservations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1802--
1803
1804ALTER TABLE ONLY reservations
1805 ADD CONSTRAINT reservations_pkey PRIMARY KEY (id);
1806
1807
1808--
1809-- Name: scenario_elements_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1810--
1811
1812ALTER TABLE ONLY scenario_elements
1813 ADD CONSTRAINT scenario_elements_pkey PRIMARY KEY (id);
1814
1815
1816--
1817-- Name: scenario_hints_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1818--
1819
1820ALTER TABLE ONLY scenario_hints
1821 ADD CONSTRAINT scenario_hints_pkey PRIMARY KEY (id);
1822
1823
1824--
1825-- Name: scenario_images_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1826--
1827
1828ALTER TABLE ONLY scenario_images
1829 ADD CONSTRAINT scenario_images_pkey PRIMARY KEY (id);
1830
1831
1832--
1833-- Name: scenario_skus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1834--
1835
1836ALTER TABLE ONLY scenario_skus
1837 ADD CONSTRAINT scenario_skus_pkey PRIMARY KEY (id);
1838
1839
1840--
1841-- Name: scenario_steps_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1842--
1843
1844ALTER TABLE ONLY scenario_steps
1845 ADD CONSTRAINT scenario_steps_pkey PRIMARY KEY (id);
1846
1847
1848--
1849-- Name: scenario_troubles_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1850--
1851
1852ALTER TABLE ONLY scenario_troubles
1853 ADD CONSTRAINT scenario_troubles_pkey PRIMARY KEY (id);
1854
1855
1856--
1857-- Name: scenarios_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1858--
1859
1860ALTER TABLE ONLY scenarios
1861 ADD CONSTRAINT scenarios_pkey PRIMARY KEY (id);
1862
1863
1864--
1865-- Name: scenarios_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1866--
1867
1868ALTER TABLE ONLY scenario_templates
1869 ADD CONSTRAINT scenarios_templates_pkey PRIMARY KEY (id);
1870
1871
1872--
1873-- Name: sku_images_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1874--
1875
1876ALTER TABLE ONLY sku_images
1877 ADD CONSTRAINT sku_images_pkey PRIMARY KEY (id);
1878
1879
1880--
1881-- Name: skus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1882--
1883
1884ALTER TABLE ONLY skus
1885 ADD CONSTRAINT skus_pkey PRIMARY KEY (id);
1886
1887
1888--
1889-- Name: tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1890--
1891
1892ALTER TABLE ONLY tasks
1893 ADD CONSTRAINT tasks_pkey PRIMARY KEY (id);
1894
1895
1896--
1897-- Name: tasks_users_blacklist_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1898--
1899
1900ALTER TABLE ONLY tasks_users_blacklist
1901 ADD CONSTRAINT tasks_users_blacklist_pkey PRIMARY KEY (id);
1902
1903
1904--
1905-- Name: ticket_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1906--
1907
1908ALTER TABLE ONLY ticket_comments
1909 ADD CONSTRAINT ticket_comments_pkey PRIMARY KEY (id);
1910
1911
1912--
1913-- Name: ticket_files_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1914--
1915
1916ALTER TABLE ONLY ticket_files
1917 ADD CONSTRAINT ticket_files_pkey PRIMARY KEY (id);
1918
1919
1920--
1921-- Name: tickets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1922--
1923
1924ALTER TABLE ONLY tickets
1925 ADD CONSTRAINT tickets_pkey PRIMARY KEY (id);
1926
1927
1928--
1929-- Name: unread_tickets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1930--
1931
1932ALTER TABLE ONLY unread_tickets
1933 ADD CONSTRAINT unread_tickets_pkey PRIMARY KEY (id);
1934
1935
1936--
1937-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1938--
1939
1940ALTER TABLE ONLY users
1941 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
1942
1943
1944--
1945-- Name: versions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1946--
1947
1948ALTER TABLE ONLY versions
1949 ADD CONSTRAINT versions_pkey PRIMARY KEY (id);
1950
1951
1952--
1953-- Name: index_answer_files_on_answer_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
1954--
1955
1956CREATE INDEX index_answer_files_on_answer_id ON answer_files USING btree (answer_id);
1957
1958
1959--
1960-- Name: index_answer_options_on_answer_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
1961--
1962
1963CREATE INDEX index_answer_options_on_answer_id ON answer_options USING btree (answer_id);
1964
1965
1966--
1967-- Name: index_answers_on_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
1968--
1969
1970CREATE INDEX index_answers_on_key ON answers USING btree (key);
1971
1972
1973--
1974-- Name: index_answers_on_report_id_and_position; Type: INDEX; Schema: public; Owner: -; Tablespace:
1975--
1976
1977CREATE INDEX index_answers_on_report_id_and_position ON answers USING btree (report_id, "position");
1978
1979
1980--
1981-- Name: index_background_jobs_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
1982--
1983
1984CREATE INDEX index_background_jobs_on_user_id ON background_jobs USING btree (user_id);
1985
1986
1987--
1988-- Name: index_devices_logs_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
1989--
1990
1991CREATE INDEX index_devices_logs_on_user_id ON devices_logs USING btree (user_id);
1992
1993
1994--
1995-- Name: index_devices_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
1996--
1997
1998CREATE INDEX index_devices_on_user_id ON devices USING btree (user_id);
1999
2000
2001--
2002-- Name: index_groups_members_on_group_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2003--
2004
2005CREATE INDEX index_groups_members_on_group_id ON groups_members USING btree (group_id);
2006
2007
2008--
2009-- Name: index_groups_members_on_member_type_and_member_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2010--
2011
2012CREATE INDEX index_groups_members_on_member_type_and_member_id ON groups_members USING btree (member_type, member_id);
2013
2014
2015--
2016-- Name: index_notifications_on_addressee_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2017--
2018
2019CREATE INDEX index_notifications_on_addressee_id ON notifications USING btree (addressee_id);
2020
2021
2022--
2023-- Name: index_notifications_on_addresser_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2024--
2025
2026CREATE INDEX index_notifications_on_addresser_id ON notifications USING btree (addresser_id);
2027
2028
2029--
2030-- Name: index_notifications_on_state; Type: INDEX; Schema: public; Owner: -; Tablespace:
2031--
2032
2033CREATE INDEX index_notifications_on_state ON notifications USING btree (state);
2034
2035
2036--
2037-- Name: index_notifications_on_type; Type: INDEX; Schema: public; Owner: -; Tablespace:
2038--
2039
2040CREATE INDEX index_notifications_on_type ON notifications USING btree (type);
2041
2042
2043--
2044-- Name: index_reasons_on_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2045--
2046
2047CREATE INDEX index_reasons_on_project_id ON reasons USING btree (project_id);
2048
2049
2050--
2051-- Name: index_reports_on_client_visible; Type: INDEX; Schema: public; Owner: -; Tablespace:
2052--
2053
2054CREATE INDEX index_reports_on_client_visible ON reports USING btree (client_visible);
2055
2056
2057--
2058-- Name: index_reports_on_task_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2059--
2060
2061CREATE INDEX index_reports_on_task_id ON reports USING btree (task_id);
2062
2063
2064--
2065-- Name: index_reports_on_task_id_and_user_id_and_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
2066--
2067
2068CREATE UNIQUE INDEX index_reports_on_task_id_and_user_id_and_uuid ON reports USING btree (task_id, user_id, uuid);
2069
2070
2071--
2072-- Name: index_reports_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2073--
2074
2075CREATE INDEX index_reports_on_user_id ON reports USING btree (user_id);
2076
2077
2078--
2079-- Name: index_reservations_on_task_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2080--
2081
2082CREATE INDEX index_reservations_on_task_id ON reservations USING btree (task_id);
2083
2084
2085--
2086-- Name: index_reservations_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2087--
2088
2089CREATE INDEX index_reservations_on_user_id ON reservations USING btree (user_id);
2090
2091
2092--
2093-- Name: index_scenario_elements_on_sku_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2094--
2095
2096CREATE INDEX index_scenario_elements_on_sku_id ON scenario_elements USING btree (sku_id);
2097
2098
2099--
2100-- Name: index_scenario_elements_on_step_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2101--
2102
2103CREATE INDEX index_scenario_elements_on_step_id ON scenario_elements USING btree (step_id);
2104
2105
2106--
2107-- Name: index_scenario_elements_on_template_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2108--
2109
2110CREATE INDEX index_scenario_elements_on_template_id ON scenario_elements USING btree (template_id);
2111
2112
2113--
2114-- Name: index_scenario_hints_on_scenario_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2115--
2116
2117CREATE INDEX index_scenario_hints_on_scenario_id ON scenario_hints USING btree (scenario_id);
2118
2119
2120--
2121-- Name: index_scenario_images_on_scenario_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2122--
2123
2124CREATE INDEX index_scenario_images_on_scenario_id ON scenario_images USING btree (scenario_id);
2125
2126
2127--
2128-- Name: index_scenario_skus_on_scenario_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2129--
2130
2131CREATE INDEX index_scenario_skus_on_scenario_id ON scenario_skus USING btree (scenario_id);
2132
2133
2134--
2135-- Name: index_scenario_steps_on_scenario_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2136--
2137
2138CREATE INDEX index_scenario_steps_on_scenario_id ON scenario_steps USING btree (scenario_id);
2139
2140
2141--
2142-- Name: index_scenario_steps_on_sku_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2143--
2144
2145CREATE INDEX index_scenario_steps_on_sku_id ON scenario_steps USING btree (sku_id);
2146
2147
2148--
2149-- Name: index_scenario_steps_on_template_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2150--
2151
2152CREATE INDEX index_scenario_steps_on_template_id ON scenario_steps USING btree (template_id);
2153
2154
2155--
2156-- Name: index_scenario_templates_on_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2157--
2158
2159CREATE INDEX index_scenario_templates_on_project_id ON scenario_templates USING btree (project_id);
2160
2161
2162--
2163-- Name: index_scenario_troubles_on_scenario_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2164--
2165
2166CREATE INDEX index_scenario_troubles_on_scenario_id ON scenario_troubles USING btree (scenario_id);
2167
2168
2169--
2170-- Name: index_scenarios_on_creator_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2171--
2172
2173CREATE INDEX index_scenarios_on_creator_id ON scenarios USING btree (creator_id);
2174
2175
2176--
2177-- Name: index_scenarios_on_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2178--
2179
2180CREATE INDEX index_scenarios_on_project_id ON scenarios USING btree (project_id);
2181
2182
2183--
2184-- Name: index_tasks_on_geo_object_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2185--
2186
2187CREATE INDEX index_tasks_on_geo_object_id ON tasks USING btree (geo_object_id);
2188
2189
2190--
2191-- Name: index_tasks_on_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2192--
2193
2194CREATE INDEX index_tasks_on_project_id ON tasks USING btree (project_id);
2195
2196
2197--
2198-- Name: index_tasks_users_blacklist_on_user_id_and_task_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2199--
2200
2201CREATE INDEX index_tasks_users_blacklist_on_user_id_and_task_id ON tasks_users_blacklist USING btree (user_id, task_id);
2202
2203
2204--
2205-- Name: index_users_on_blocked; Type: INDEX; Schema: public; Owner: -; Tablespace:
2206--
2207
2208CREATE INDEX index_users_on_blocked ON users USING btree (blocked);
2209
2210
2211--
2212-- Name: index_versions_on_item_type_and_item_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2213--
2214
2215CREATE INDEX index_versions_on_item_type_and_item_id ON versions USING btree (item_type, item_id);
2216
2217
2218--
2219-- Name: index_versions_on_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
2220--
2221
2222CREATE INDEX index_versions_on_parent_id ON versions USING btree (parent_id);
2223
2224
2225--
2226-- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: -; Tablespace:
2227--
2228
2229CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);
2230
2231
2232--
2233-- PostgreSQL database dump complete
2234--
2235
2236SET search_path TO "$user",public;
2237
2238INSERT INTO schema_migrations (version) VALUES ('20141215094815');
2239
2240INSERT INTO schema_migrations (version) VALUES ('20141216083610');
2241
2242INSERT INTO schema_migrations (version) VALUES ('20141216095506');
2243
2244INSERT INTO schema_migrations (version) VALUES ('20141223154413');
2245
2246INSERT INTO schema_migrations (version) VALUES ('20141223160654');
2247
2248INSERT INTO schema_migrations (version) VALUES ('20141224110032');
2249
2250INSERT INTO schema_migrations (version) VALUES ('20141224111747');
2251
2252INSERT INTO schema_migrations (version) VALUES ('20141224111748');
2253
2254INSERT INTO schema_migrations (version) VALUES ('20141224111749');
2255
2256INSERT INTO schema_migrations (version) VALUES ('20141224111750');
2257
2258INSERT INTO schema_migrations (version) VALUES ('20141224111751');
2259
2260INSERT INTO schema_migrations (version) VALUES ('20141224111752');
2261
2262INSERT INTO schema_migrations (version) VALUES ('20141229122257');
2263
2264INSERT INTO schema_migrations (version) VALUES ('20141229131241');
2265
2266INSERT INTO schema_migrations (version) VALUES ('20141229214059');
2267
2268INSERT INTO schema_migrations (version) VALUES ('20141230194152');
2269
2270INSERT INTO schema_migrations (version) VALUES ('20150108202704');
2271
2272INSERT INTO schema_migrations (version) VALUES ('20150112112701');
2273
2274INSERT INTO schema_migrations (version) VALUES ('20150114123648');
2275
2276INSERT INTO schema_migrations (version) VALUES ('20150116085239');
2277
2278INSERT INTO schema_migrations (version) VALUES ('20150118151457');
2279
2280INSERT INTO schema_migrations (version) VALUES ('20150119090946');
2281
2282INSERT INTO schema_migrations (version) VALUES ('20150119150456');
2283
2284INSERT INTO schema_migrations (version) VALUES ('20150119155238');
2285
2286INSERT INTO schema_migrations (version) VALUES ('20150120093921');
2287
2288INSERT INTO schema_migrations (version) VALUES ('20150123075744');
2289
2290INSERT INTO schema_migrations (version) VALUES ('20150126193907');
2291
2292INSERT INTO schema_migrations (version) VALUES ('20150127141749');
2293
2294INSERT INTO schema_migrations (version) VALUES ('20150201120141');
2295
2296INSERT INTO schema_migrations (version) VALUES ('20150201204914');
2297
2298INSERT INTO schema_migrations (version) VALUES ('20150201213632');
2299
2300INSERT INTO schema_migrations (version) VALUES ('20150202123344');
2301
2302INSERT INTO schema_migrations (version) VALUES ('20150203131031');
2303
2304INSERT INTO schema_migrations (version) VALUES ('20150205103623');
2305
2306INSERT INTO schema_migrations (version) VALUES ('20150206091444');
2307
2308INSERT INTO schema_migrations (version) VALUES ('20150207205057');
2309
2310INSERT INTO schema_migrations (version) VALUES ('20150209091108');
2311
2312INSERT INTO schema_migrations (version) VALUES ('20150209091400');
2313
2314INSERT INTO schema_migrations (version) VALUES ('20150209091401');
2315
2316INSERT INTO schema_migrations (version) VALUES ('20150211152111');
2317
2318INSERT INTO schema_migrations (version) VALUES ('20150216112419');
2319
2320INSERT INTO schema_migrations (version) VALUES ('20150216120956');
2321
2322INSERT INTO schema_migrations (version) VALUES ('20150217132651');
2323
2324INSERT INTO schema_migrations (version) VALUES ('20150217140355');
2325
2326INSERT INTO schema_migrations (version) VALUES ('20150218090823');
2327
2328INSERT INTO schema_migrations (version) VALUES ('20150218143912');
2329
2330INSERT INTO schema_migrations (version) VALUES ('20150226125341');
2331
2332INSERT INTO schema_migrations (version) VALUES ('20150303075015');
2333
2334INSERT INTO schema_migrations (version) VALUES ('20150313104033');
2335
2336INSERT INTO schema_migrations (version) VALUES ('20150313110942');
2337
2338INSERT INTO schema_migrations (version) VALUES ('20150313115823');
2339
2340INSERT INTO schema_migrations (version) VALUES ('20150313120924');
2341
2342INSERT INTO schema_migrations (version) VALUES ('20150316125608');
2343
2344INSERT INTO schema_migrations (version) VALUES ('20150316131518');
2345
2346INSERT INTO schema_migrations (version) VALUES ('20150316134549');
2347
2348INSERT INTO schema_migrations (version) VALUES ('20150320112758');
2349
2350INSERT INTO schema_migrations (version) VALUES ('20150330090627');
2351
2352INSERT INTO schema_migrations (version) VALUES ('20150330105301');
2353
2354INSERT INTO schema_migrations (version) VALUES ('20150331131202');
2355
2356INSERT INTO schema_migrations (version) VALUES ('20150402081713');
2357
2358INSERT INTO schema_migrations (version) VALUES ('20150402084004');
2359
2360INSERT INTO schema_migrations (version) VALUES ('20150403130042');
2361
2362INSERT INTO schema_migrations (version) VALUES ('20150406114224');
2363
2364INSERT INTO schema_migrations (version) VALUES ('20150407090443');
2365
2366INSERT INTO schema_migrations (version) VALUES ('20150409114828');
2367
2368INSERT INTO schema_migrations (version) VALUES ('20150410141225');
2369
2370INSERT INTO schema_migrations (version) VALUES ('20150424113713');
2371
2372INSERT INTO schema_migrations (version) VALUES ('20150429131933');
2373
2374INSERT INTO schema_migrations (version) VALUES ('20150518145715');
2375
2376INSERT INTO schema_migrations (version) VALUES ('20150519142133');
2377
2378INSERT INTO schema_migrations (version) VALUES ('20150520112733');
2379
2380INSERT INTO schema_migrations (version) VALUES ('20150521111109');
2381
2382INSERT INTO schema_migrations (version) VALUES ('20150522113609');
2383
2384INSERT INTO schema_migrations (version) VALUES ('20150522121608');
2385
2386INSERT INTO schema_migrations (version) VALUES ('20150525112742');
2387
2388INSERT INTO schema_migrations (version) VALUES ('20150602152901');
2389
2390INSERT INTO schema_migrations (version) VALUES ('20150610111014');
2391
2392INSERT INTO schema_migrations (version) VALUES ('20150610111458');
2393
2394INSERT INTO schema_migrations (version) VALUES ('20150610120726');
2395
2396INSERT INTO schema_migrations (version) VALUES ('20150616083912');
2397
2398INSERT INTO schema_migrations (version) VALUES ('20150616113630');
2399
2400INSERT INTO schema_migrations (version) VALUES ('20150626073256');
2401
2402INSERT INTO schema_migrations (version) VALUES ('20150626092601');
2403
2404INSERT INTO schema_migrations (version) VALUES ('20150702121120');
2405
2406INSERT INTO schema_migrations (version) VALUES ('20150707091017');
2407
2408INSERT INTO schema_migrations (version) VALUES ('20150708145811');
2409
2410INSERT INTO schema_migrations (version) VALUES ('20150724093855');
2411
2412INSERT INTO schema_migrations (version) VALUES ('20150826152258');
2413
2414INSERT INTO schema_migrations (version) VALUES ('20150905060741');
2415
2416INSERT INTO schema_migrations (version) VALUES ('20150907074024');
2417
2418INSERT INTO schema_migrations (version) VALUES ('20150907074119');
2419
2420INSERT INTO schema_migrations (version) VALUES ('20150914133550');
2421
2422INSERT INTO schema_migrations (version) VALUES ('20150924143920');
2423
2424INSERT INTO schema_migrations (version) VALUES ('20151027073646');
2425
2426INSERT INTO schema_migrations (version) VALUES ('20151103125815');