VV8e8MHi

1--
2-- PostgreSQL database dump
3--
4
5SET statement_timeout = 0;
6SET lock_timeout = 0;
7SET client_encoding = 'UTF8';
8SET standard_conforming_strings = on;
9SET check_function_bodies = false;
10SET client_min_messages = warning;
11
12--
13-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
14--
15
16CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
17
18
19--
20-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
21--
22
23COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
24
25
26--
27-- Name: pg_stat_statements; Type: EXTENSION; Schema: -; Owner: -
28--
29
30CREATE EXTENSION IF NOT EXISTS pg_stat_statements WITH SCHEMA public;
31
32
33--
34-- Name: EXTENSION pg_stat_statements; Type: COMMENT; Schema: -; Owner: -
35--
36
37COMMENT ON EXTENSION pg_stat_statements IS 'track execution statistics of all SQL statements executed';
38
39
40--
41-- Name: uuid-ossp; Type: EXTENSION; Schema: -; Owner: -
42--
43
44CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public;
45
46
47--
48-- Name: EXTENSION "uuid-ossp"; Type: COMMENT; Schema: -; Owner: -
49--
50
51COMMENT ON EXTENSION "uuid-ossp" IS 'generate universally unique identifiers (UUIDs)';
52
53
54SET search_path = public, pg_catalog;
55
56SET default_tablespace = '';
57
58SET default_with_oids = false;
59
60--
61-- Name: accepted_container_types; Type: TABLE; Schema: public; Owner: -; Tablespace: 
62--
63
64CREATE TABLE accepted_container_types (
65    id integer NOT NULL,
66    location_size_id integer NOT NULL,
67    container_type_id integer NOT NULL,
68    created_at timestamp without time zone NOT NULL,
69    updated_at timestamp without time zone NOT NULL
70);
71
72
73--
74-- Name: accepted_container_types_id_seq; Type: SEQUENCE; Schema: public; Owner: -
75--
76
77CREATE SEQUENCE accepted_container_types_id_seq
78    START WITH 1
79    INCREMENT BY 1
80    NO MINVALUE
81    NO MAXVALUE
82    CACHE 1;
83
84
85--
86-- Name: accepted_container_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
87--
88
89ALTER SEQUENCE accepted_container_types_id_seq OWNED BY accepted_container_types.id;
90
91
92--
93-- Name: accepted_inventory_types; Type: TABLE; Schema: public; Owner: -; Tablespace: 
94--
95
96CREATE TABLE accepted_inventory_types (
97    id integer NOT NULL,
98    location_id integer NOT NULL,
99    inventory_type_id integer NOT NULL,
100    created_at timestamp without time zone NOT NULL,
101    updated_at timestamp without time zone NOT NULL
102);
103
104
105--
106-- Name: accepted_inventory_types_id_seq; Type: SEQUENCE; Schema: public; Owner: -
107--
108
109CREATE SEQUENCE accepted_inventory_types_id_seq
110    START WITH 1
111    INCREMENT BY 1
112    NO MINVALUE
113    NO MAXVALUE
114    CACHE 1;
115
116
117--
118-- Name: accepted_inventory_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
119--
120
121ALTER SEQUENCE accepted_inventory_types_id_seq OWNED BY accepted_inventory_types.id;
122
123
124--
125-- Name: area_types; Type: TABLE; Schema: public; Owner: -; Tablespace: 
126--
127
128CREATE TABLE area_types (
129    id integer NOT NULL,
130    name character varying,
131    code character varying,
132    manual_movement_rule character varying,
133    default_used_for character varying
134);
135
136
137--
138-- Name: area_types_id_seq; Type: SEQUENCE; Schema: public; Owner: -
139--
140
141CREATE SEQUENCE area_types_id_seq
142    START WITH 1
143    INCREMENT BY 1
144    NO MINVALUE
145    NO MAXVALUE
146    CACHE 1;
147
148
149--
150-- Name: area_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
151--
152
153ALTER SEQUENCE area_types_id_seq OWNED BY area_types.id;
154
155
156--
157-- Name: areas; Type: TABLE; Schema: public; Owner: -; Tablespace: 
158--
159
160CREATE TABLE areas (
161    id integer NOT NULL,
162    created_at timestamp without time zone,
163    updated_at timestamp without time zone,
164    facility_id integer NOT NULL,
165    area_type_id integer
166);
167
168
169--
170-- Name: areas_id_seq; Type: SEQUENCE; Schema: public; Owner: -
171--
172
173CREATE SEQUENCE areas_id_seq
174    START WITH 1
175    INCREMENT BY 1
176    NO MINVALUE
177    NO MAXVALUE
178    CACHE 1;
179
180
181--
182-- Name: areas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
183--
184
185ALTER SEQUENCE areas_id_seq OWNED BY areas.id;
186
187
188--
189-- Name: code_sequence; Type: SEQUENCE; Schema: public; Owner: -
190--
191
192CREATE SEQUENCE code_sequence
193    START WITH 1
194    INCREMENT BY 1
195    NO MINVALUE
196    NO MAXVALUE
197    CACHE 1;
198
199
200--
201-- Name: container_parent_change_logs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
202--
203
204CREATE TABLE container_parent_change_logs (
205    id integer NOT NULL,
206    container_id integer NOT NULL,
207    old_parent_container_id integer,
208    new_parent_container_id integer,
209    created_at timestamp without time zone,
210    updated_at timestamp without time zone
211);
212
213
214--
215-- Name: container_parent_change_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
216--
217
218CREATE SEQUENCE container_parent_change_logs_id_seq
219    START WITH 1
220    INCREMENT BY 1
221    NO MINVALUE
222    NO MAXVALUE
223    CACHE 1;
224
225
226--
227-- Name: container_parent_change_logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
228--
229
230ALTER SEQUENCE container_parent_change_logs_id_seq OWNED BY container_parent_change_logs.id;
231
232
233--
234-- Name: container_snapshots; Type: TABLE; Schema: public; Owner: -; Tablespace: 
235--
236
237CREATE TABLE container_snapshots (
238    id integer NOT NULL,
239    cycle_count_request_id integer NOT NULL,
240    employee_id integer NOT NULL,
241    container_id integer NOT NULL,
242    content_id integer,
243    inventory_activity_id integer,
244    status character varying NOT NULL,
245    snapshot_at timestamp without time zone,
246    location_id integer
247);
248
249
250--
251-- Name: container_snapshots_id_seq; Type: SEQUENCE; Schema: public; Owner: -
252--
253
254CREATE SEQUENCE container_snapshots_id_seq
255    START WITH 1
256    INCREMENT BY 1
257    NO MINVALUE
258    NO MAXVALUE
259    CACHE 1;
260
261
262--
263-- Name: container_snapshots_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
264--
265
266ALTER SEQUENCE container_snapshots_id_seq OWNED BY container_snapshots.id;
267
268
269--
270-- Name: container_types; Type: TABLE; Schema: public; Owner: -; Tablespace: 
271--
272
273CREATE TABLE container_types (
274    id integer NOT NULL,
275    name character varying NOT NULL,
276    prefix character varying
277);
278
279
280--
281-- Name: container_types_id_seq; Type: SEQUENCE; Schema: public; Owner: -
282--
283
284CREATE SEQUENCE container_types_id_seq
285    START WITH 1
286    INCREMENT BY 1
287    NO MINVALUE
288    NO MAXVALUE
289    CACHE 1;
290
291
292--
293-- Name: container_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
294--
295
296ALTER SEQUENCE container_types_id_seq OWNED BY container_types.id;
297
298
299--
300-- Name: containers; Type: TABLE; Schema: public; Owner: -; Tablespace: 
301--
302
303CREATE TABLE containers (
304    id integer NOT NULL,
305    created_at timestamp without time zone,
306    updated_at timestamp without time zone,
307    container_type_id integer,
308    retired_at timestamp without time zone,
309    code character varying,
310    facility_id integer,
311    type character varying,
312    parent_id integer,
313    parent_id_updated_at timestamp without time zone
314);
315
316
317--
318-- Name: containers_id_seq; Type: SEQUENCE; Schema: public; Owner: -
319--
320
321CREATE SEQUENCE containers_id_seq
322    START WITH 1
323    INCREMENT BY 1
324    NO MINVALUE
325    NO MAXVALUE
326    CACHE 1;
327
328
329--
330-- Name: containers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
331--
332
333ALTER SEQUENCE containers_id_seq OWNED BY containers.id;
334
335
336--
337-- Name: contents; Type: TABLE; Schema: public; Owner: -; Tablespace: 
338--
339
340CREATE TABLE contents (
341    id integer NOT NULL,
342    item_id integer NOT NULL,
343    item_amount double precision,
344    ship_date date,
345    created_at timestamp without time zone,
346    updated_at timestamp without time zone,
347    subcontainer_type_id integer,
348    subcontainer_count numeric(12,5),
349    subcontainer_item_amount double precision,
350    prep_date date,
351    expires_on date,
352    subcontainer_measure_unit character varying,
353    type character varying,
354    recipe_detail_id integer
355);
356
357
358--
359-- Name: contents_id_seq; Type: SEQUENCE; Schema: public; Owner: -
360--
361
362CREATE SEQUENCE contents_id_seq
363    START WITH 1
364    INCREMENT BY 1
365    NO MINVALUE
366    NO MAXVALUE
367    CACHE 1;
368
369
370--
371-- Name: contents_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
372--
373
374ALTER SEQUENCE contents_id_seq OWNED BY contents.id;
375
376
377--
378-- Name: cycle_count_requests; Type: TABLE; Schema: public; Owner: -; Tablespace: 
379--
380
381CREATE TABLE cycle_count_requests (
382    id integer NOT NULL,
383    facility_id integer NOT NULL,
384    requested_by_employee_id integer NOT NULL,
385    requested_at timestamp without time zone NOT NULL,
386    finished_at timestamp without time zone,
387    canceled_at timestamp without time zone,
388    item_id integer,
389    status character varying NOT NULL,
390    container_id integer
391);
392
393
394--
395-- Name: cycle_count_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: -
396--
397
398CREATE SEQUENCE cycle_count_requests_id_seq
399    START WITH 1
400    INCREMENT BY 1
401    NO MINVALUE
402    NO MAXVALUE
403    CACHE 1;
404
405
406--
407-- Name: cycle_count_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
408--
409
410ALTER SEQUENCE cycle_count_requests_id_seq OWNED BY cycle_count_requests.id;
411
412
413--
414-- Name: cycle_recipe_order_counts; Type: TABLE; Schema: public; Owner: -; Tablespace: 
415--
416
417CREATE TABLE cycle_recipe_order_counts (
418    id integer NOT NULL,
419    facility_id integer NOT NULL,
420    recipe_detail_id integer NOT NULL,
421    ship_date date NOT NULL,
422    order_count integer NOT NULL,
423    created_at timestamp without time zone NOT NULL,
424    updated_at timestamp without time zone NOT NULL,
425    cutoff_count integer,
426    unscanned_count integer
427);
428
429
430--
431-- Name: cycle_recipe_order_counts_id_seq; Type: SEQUENCE; Schema: public; Owner: -
432--
433
434CREATE SEQUENCE cycle_recipe_order_counts_id_seq
435    START WITH 1
436    INCREMENT BY 1
437    NO MINVALUE
438    NO MAXVALUE
439    CACHE 1;
440
441
442--
443-- Name: cycle_recipe_order_counts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
444--
445
446ALTER SEQUENCE cycle_recipe_order_counts_id_seq OWNED BY cycle_recipe_order_counts.id;
447
448
449--
450-- Name: data_migrations; Type: TABLE; Schema: public; Owner: -; Tablespace: 
451--
452
453CREATE TABLE data_migrations (
454    version character varying NOT NULL
455);
456
457
458--
459-- Name: default_planogram_slots; Type: TABLE; Schema: public; Owner: -; Tablespace: 
460--
461
462CREATE TABLE default_planogram_slots (
463    id integer NOT NULL,
464    facility_id integer,
465    item_id integer,
466    slot_number integer,
467    transit_days integer,
468    instructions character varying,
469    created_at timestamp without time zone NOT NULL,
470    updated_at timestamp without time zone NOT NULL,
471    plan_type integer DEFAULT 0 NOT NULL,
472    is_sortable boolean DEFAULT false NOT NULL
473);
474
475
476--
477-- Name: default_planogram_slots_id_seq; Type: SEQUENCE; Schema: public; Owner: -
478--
479
480CREATE SEQUENCE default_planogram_slots_id_seq
481    START WITH 1
482    INCREMENT BY 1
483    NO MINVALUE
484    NO MAXVALUE
485    CACHE 1;
486
487
488--
489-- Name: default_planogram_slots_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
490--
491
492ALTER SEQUENCE default_planogram_slots_id_seq OWNED BY default_planogram_slots.id;
493
494
495--
496-- Name: employees; Type: TABLE; Schema: public; Owner: -; Tablespace: 
497--
498
499CREATE TABLE employees (
500    id integer NOT NULL,
501    employee_number character varying,
502    first_name character varying,
503    last_name character varying,
504    facility_id integer,
505    created_at timestamp without time zone,
506    updated_at timestamp without time zone,
507    is_archived boolean DEFAULT false,
508    archived_at timestamp without time zone,
509    encrypted_pin character varying,
510    email character varying,
511    encrypted_password character varying DEFAULT ''::character varying NOT NULL,
512    reset_password_token character varying,
513    reset_password_sent_at timestamp without time zone,
514    remember_created_at timestamp without time zone,
515    sign_in_count integer DEFAULT 0 NOT NULL,
516    current_sign_in_at timestamp without time zone,
517    last_sign_in_at timestamp without time zone,
518    current_sign_in_ip character varying,
519    last_sign_in_ip character varying,
520    failed_attempts integer DEFAULT 0 NOT NULL,
521    unlock_token character varying,
522    locked_at timestamp without time zone,
523    hmac_private_key character varying,
524    role_id integer,
525    archived_email character varying,
526    container_id integer
527);
528
529
530--
531-- Name: employees_id_seq; Type: SEQUENCE; Schema: public; Owner: -
532--
533
534CREATE SEQUENCE employees_id_seq
535    START WITH 1
536    INCREMENT BY 1
537    NO MINVALUE
538    NO MAXVALUE
539    CACHE 1;
540
541
542--
543-- Name: employees_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
544--
545
546ALTER SEQUENCE employees_id_seq OWNED BY employees.id;
547
548
549--
550-- Name: employees_ppm_ingredients; Type: TABLE; Schema: public; Owner: -; Tablespace: 
551--
552
553CREATE TABLE employees_ppm_ingredients (
554    id integer NOT NULL,
555    ppm_ingredient_id integer NOT NULL,
556    employee_id integer NOT NULL,
557    created_at timestamp without time zone NOT NULL,
558    updated_at timestamp without time zone NOT NULL
559);
560
561
562--
563-- Name: employees_ppm_ingredients_id_seq; Type: SEQUENCE; Schema: public; Owner: -
564--
565
566CREATE SEQUENCE employees_ppm_ingredients_id_seq
567    START WITH 1
568    INCREMENT BY 1
569    NO MINVALUE
570    NO MAXVALUE
571    CACHE 1;
572
573
574--
575-- Name: employees_ppm_ingredients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
576--
577
578ALTER SEQUENCE employees_ppm_ingredients_id_seq OWNED BY employees_ppm_ingredients.id;
579
580
581--
582-- Name: facilities; Type: TABLE; Schema: public; Owner: -; Tablespace: 
583--
584
585CREATE TABLE facilities (
586    id integer NOT NULL,
587    name character varying(255),
588    created_at timestamp without time zone,
589    updated_at timestamp without time zone,
590    is_archived boolean DEFAULT false NOT NULL,
591    archived_at timestamp without time zone,
592    street character varying(255),
593    city character varying(255),
594    state character varying(255),
595    zip_code character varying(255),
596    timezone character varying(255),
597    code character varying,
598    transit_configs integer[] DEFAULT '{}'::integer[],
599    always_perform_quality_checks boolean DEFAULT false NOT NULL
600);
601
602
603--
604-- Name: facilities_id_seq; Type: SEQUENCE; Schema: public; Owner: -
605--
606
607CREATE SEQUENCE facilities_id_seq
608    START WITH 1
609    INCREMENT BY 1
610    NO MINVALUE
611    NO MAXVALUE
612    CACHE 1;
613
614
615--
616-- Name: facilities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
617--
618
619ALTER SEQUENCE facilities_id_seq OWNED BY facilities.id;
620
621
622--
623-- Name: inventories; Type: TABLE; Schema: public; Owner: -; Tablespace: 
624--
625
626CREATE TABLE inventories (
627    id integer NOT NULL,
628    location_id integer,
629    content_id integer NOT NULL,
630    created_at timestamp without time zone,
631    updated_at timestamp without time zone,
632    arrived_at timestamp without time zone,
633    container_id integer
634);
635
636
637--
638-- Name: inventories_id_seq; Type: SEQUENCE; Schema: public; Owner: -
639--
640
641CREATE SEQUENCE inventories_id_seq
642    START WITH 1
643    INCREMENT BY 1
644    NO MINVALUE
645    NO MAXVALUE
646    CACHE 1;
647
648
649--
650-- Name: inventories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
651--
652
653ALTER SEQUENCE inventories_id_seq OWNED BY inventories.id;
654
655
656--
657-- Name: inventory_activities; Type: TABLE; Schema: public; Owner: -; Tablespace: 
658--
659
660CREATE TABLE inventory_activities (
661    id integer NOT NULL,
662    employee_id integer,
663    content_id integer,
664    source_location_id integer,
665    destination_location_id integer,
666    started_at timestamp without time zone,
667    ended_at timestamp without time zone,
668    created_at timestamp without time zone,
669    updated_at timestamp without time zone,
670    source_inventory_id integer,
671    destination_inventory_id integer,
672    activity_type character varying,
673    inventory_id integer,
674    container_id integer,
675    source_content_before_activity_id integer,
676    destination_content_after_activity_id integer,
677    canceled_at timestamp without time zone,
678    is_manually_destined boolean DEFAULT false,
679    status character varying DEFAULT 'unstarted'::character varying,
680    reason character varying,
681    assign_destination_on_pickup boolean DEFAULT false NOT NULL
682);
683
684
685--
686-- Name: inventory_activities_id_seq; Type: SEQUENCE; Schema: public; Owner: -
687--
688
689CREATE SEQUENCE inventory_activities_id_seq
690    START WITH 1
691    INCREMENT BY 1
692    NO MINVALUE
693    NO MAXVALUE
694    CACHE 1;
695
696
697--
698-- Name: inventory_activities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
699--
700
701ALTER SEQUENCE inventory_activities_id_seq OWNED BY inventory_activities.id;
702
703
704--
705-- Name: inventory_activity_taggings; Type: TABLE; Schema: public; Owner: -; Tablespace: 
706--
707
708CREATE TABLE inventory_activity_taggings (
709    inventory_activity_tag_id integer NOT NULL,
710    inventory_activity_id integer NOT NULL
711);
712
713
714--
715-- Name: inventory_activity_tags; Type: TABLE; Schema: public; Owner: -; Tablespace: 
716--
717
718CREATE TABLE inventory_activity_tags (
719    id integer NOT NULL,
720    name character varying NOT NULL,
721    created_at timestamp without time zone,
722    updated_at timestamp without time zone
723);
724
725
726--
727-- Name: inventory_activity_tags_id_seq; Type: SEQUENCE; Schema: public; Owner: -
728--
729
730CREATE SEQUENCE inventory_activity_tags_id_seq
731    START WITH 1
732    INCREMENT BY 1
733    NO MINVALUE
734    NO MAXVALUE
735    CACHE 1;
736
737
738--
739-- Name: inventory_activity_tags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
740--
741
742ALTER SEQUENCE inventory_activity_tags_id_seq OWNED BY inventory_activity_tags.id;
743
744
745--
746-- Name: inventory_types; Type: TABLE; Schema: public; Owner: -; Tablespace: 
747--
748
749CREATE TABLE inventory_types (
750    id integer NOT NULL,
751    name character varying NOT NULL,
752    code character varying NOT NULL,
753    created_at timestamp without time zone NOT NULL,
754    updated_at timestamp without time zone NOT NULL
755);
756
757
758--
759-- Name: inventory_types_id_seq; Type: SEQUENCE; Schema: public; Owner: -
760--
761
762CREATE SEQUENCE inventory_types_id_seq
763    START WITH 1
764    INCREMENT BY 1
765    NO MINVALUE
766    NO MAXVALUE
767    CACHE 1;
768
769
770--
771-- Name: inventory_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
772--
773
774ALTER SEQUENCE inventory_types_id_seq OWNED BY inventory_types.id;
775
776
777--
778-- Name: item_code_sequence; Type: SEQUENCE; Schema: public; Owner: -
779--
780
781CREATE SEQUENCE item_code_sequence
782    START WITH 2200
783    INCREMENT BY 1
784    MINVALUE 2200
785    NO MAXVALUE
786    CACHE 1;
787
788
789--
790-- Name: item_components; Type: TABLE; Schema: public; Owner: -; Tablespace: 
791--
792
793CREATE TABLE item_components (
794    id integer NOT NULL,
795    parent_item_id integer NOT NULL,
796    child_item_id integer NOT NULL,
797    measure_method character varying NOT NULL,
798    measure_unit character varying,
799    amount double precision NOT NULL,
800    created_at timestamp without time zone,
801    updated_at timestamp without time zone
802);
803
804
805--
806-- Name: item_components_id_seq; Type: SEQUENCE; Schema: public; Owner: -
807--
808
809CREATE SEQUENCE item_components_id_seq
810    START WITH 1
811    INCREMENT BY 1
812    NO MINVALUE
813    NO MAXVALUE
814    CACHE 1;
815
816
817--
818-- Name: item_components_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
819--
820
821ALTER SEQUENCE item_components_id_seq OWNED BY item_components.id;
822
823
824--
825-- Name: item_groups; Type: TABLE; Schema: public; Owner: -; Tablespace: 
826--
827
828CREATE TABLE item_groups (
829    id integer NOT NULL,
830    name character varying NOT NULL,
831    created_at timestamp without time zone NOT NULL,
832    updated_at timestamp without time zone NOT NULL
833);
834
835
836--
837-- Name: item_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: -
838--
839
840CREATE SEQUENCE item_groups_id_seq
841    START WITH 1
842    INCREMENT BY 1
843    NO MINVALUE
844    NO MAXVALUE
845    CACHE 1;
846
847
848--
849-- Name: item_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
850--
851
852ALTER SEQUENCE item_groups_id_seq OWNED BY item_groups.id;
853
854
855--
856-- Name: item_taggings; Type: TABLE; Schema: public; Owner: -; Tablespace: 
857--
858
859CREATE TABLE item_taggings (
860    item_tag_id integer NOT NULL,
861    item_id integer NOT NULL,
862    created_at timestamp without time zone,
863    updated_at timestamp without time zone
864);
865
866
867--
868-- Name: item_tags; Type: TABLE; Schema: public; Owner: -; Tablespace: 
869--
870
871CREATE TABLE item_tags (
872    id integer NOT NULL,
873    name character varying,
874    created_at timestamp without time zone,
875    updated_at timestamp without time zone
876);
877
878
879--
880-- Name: item_tags_id_seq; Type: SEQUENCE; Schema: public; Owner: -
881--
882
883CREATE SEQUENCE item_tags_id_seq
884    START WITH 1
885    INCREMENT BY 1
886    NO MINVALUE
887    NO MAXVALUE
888    CACHE 1;
889
890
891--
892-- Name: item_tags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
893--
894
895ALTER SEQUENCE item_tags_id_seq OWNED BY item_tags.id;
896
897
898--
899-- Name: items; Type: TABLE; Schema: public; Owner: -; Tablespace: 
900--
901
902CREATE TABLE items (
903    id integer NOT NULL,
904    description character varying,
905    reference_type character varying,
906    reference_id integer,
907    created_at timestamp without time zone,
908    updated_at timestamp without time zone,
909    has_expiration_label boolean DEFAULT false,
910    minimum_temperature integer,
911    maximum_temperature integer,
912    target_temperature integer,
913    code character varying,
914    item_group_id integer,
915    archived_at timestamp without time zone,
916    is_archived boolean DEFAULT false,
917    type character varying,
918    itemizable_id integer,
919    itemizable_type character varying
920);
921
922
923--
924-- Name: items_id_seq; Type: SEQUENCE; Schema: public; Owner: -
925--
926
927CREATE SEQUENCE items_id_seq
928    START WITH 1
929    INCREMENT BY 1
930    NO MINVALUE
931    NO MAXVALUE
932    CACHE 1;
933
934
935--
936-- Name: items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
937--
938
939ALTER SEQUENCE items_id_seq OWNED BY items.id;
940
941
942--
943-- Name: kitchen_tables; Type: TABLE; Schema: public; Owner: -; Tablespace: 
944--
945
946CREATE TABLE kitchen_tables (
947    id integer NOT NULL,
948    name character varying,
949    location_id integer,
950    device_uuid character varying,
951    created_at timestamp without time zone NOT NULL,
952    updated_at timestamp without time zone NOT NULL,
953    is_automated boolean DEFAULT false NOT NULL,
954    is_archived boolean DEFAULT false NOT NULL,
955    archived_at timestamp without time zone,
956    machine_type character varying
957);
958
959
960--
961-- Name: kitchen_tables_id_seq; Type: SEQUENCE; Schema: public; Owner: -
962--
963
964CREATE SEQUENCE kitchen_tables_id_seq
965    START WITH 1
966    INCREMENT BY 1
967    NO MINVALUE
968    NO MAXVALUE
969    CACHE 1;
970
971
972--
973-- Name: kitchen_tables_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
974--
975
976ALTER SEQUENCE kitchen_tables_id_seq OWNED BY kitchen_tables.id;
977
978
979--
980-- Name: location_sizes; Type: TABLE; Schema: public; Owner: -; Tablespace: 
981--
982
983CREATE TABLE location_sizes (
984    id integer NOT NULL,
985    name character varying,
986    depth integer,
987    width integer,
988    height integer,
989    max_container_count integer,
990    rack_type_id integer
991);
992
993
994--
995-- Name: location_sizes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
996--
997
998CREATE SEQUENCE location_sizes_id_seq
999    START WITH 1
1000    INCREMENT BY 1
1001    NO MINVALUE
1002    NO MAXVALUE
1003    CACHE 1;
1004
1005
1006--
1007-- Name: location_sizes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1008--
1009
1010ALTER SEQUENCE location_sizes_id_seq OWNED BY location_sizes.id;
1011
1012
1013--
1014-- Name: locations; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1015--
1016
1017CREATE TABLE locations (
1018    id integer NOT NULL,
1019    created_at timestamp without time zone,
1020    updated_at timestamp without time zone,
1021    area_id integer,
1022    real_estate_value integer,
1023    location_size_id integer,
1024    recipe_type_id integer,
1025    code character varying NOT NULL,
1026    is_locked boolean DEFAULT false,
1027    type character varying NOT NULL,
1028    reservation_count integer DEFAULT 0 NOT NULL,
1029    temperature integer,
1030    packaging_method character varying,
1031    used_for character varying,
1032    packaging_type character varying,
1033    item_group_id integer,
1034    is_archived boolean DEFAULT false NOT NULL,
1035    archived_at timestamp without time zone,
1036    "row" character varying,
1037    bay integer,
1038    level character varying,
1039    container_id integer
1040);
1041
1042
1043--
1044-- Name: locations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1045--
1046
1047CREATE SEQUENCE locations_id_seq
1048    START WITH 1
1049    INCREMENT BY 1
1050    NO MINVALUE
1051    NO MAXVALUE
1052    CACHE 1;
1053
1054
1055--
1056-- Name: locations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1057--
1058
1059ALTER SEQUENCE locations_id_seq OWNED BY locations.id;
1060
1061
1062--
1063-- Name: looker_views; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1064--
1065
1066CREATE TABLE looker_views (
1067    id integer NOT NULL,
1068    name character varying NOT NULL,
1069    explore_url character varying NOT NULL,
1070    required_params character varying,
1071    created_at timestamp without time zone NOT NULL,
1072    updated_at timestamp without time zone NOT NULL
1073);
1074
1075
1076--
1077-- Name: looker_views_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1078--
1079
1080CREATE SEQUENCE looker_views_id_seq
1081    START WITH 1
1082    INCREMENT BY 1
1083    NO MINVALUE
1084    NO MAXVALUE
1085    CACHE 1;
1086
1087
1088--
1089-- Name: looker_views_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1090--
1091
1092ALTER SEQUENCE looker_views_id_seq OWNED BY looker_views.id;
1093
1094
1095--
1096-- Name: meal_configurations; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1097--
1098
1099CREATE TABLE meal_configurations (
1100    id uuid DEFAULT uuid_generate_v4() NOT NULL,
1101    short_code character varying NOT NULL,
1102    rank integer,
1103    pack_order integer,
1104    is_active boolean DEFAULT true,
1105    created_at timestamp without time zone,
1106    updated_at timestamp without time zone,
1107    plan_type integer DEFAULT 0 NOT NULL
1108);
1109
1110
1111--
1112-- Name: pack_line_configurations; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1113--
1114
1115CREATE TABLE pack_line_configurations (
1116    id integer NOT NULL,
1117    pack_line_id integer NOT NULL,
1118    planogram_line_id integer NOT NULL,
1119    started_at timestamp without time zone NOT NULL,
1120    ended_at timestamp without time zone,
1121    created_at timestamp without time zone,
1122    updated_at timestamp without time zone,
1123    assigned_at timestamp without time zone,
1124    lead_employee_id integer,
1125    assigning_employee_id integer,
1126    is_started boolean DEFAULT true,
1127    shipping_method_id integer
1128);
1129
1130
1131--
1132-- Name: pack_line_configurations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1133--
1134
1135CREATE SEQUENCE pack_line_configurations_id_seq
1136    START WITH 1
1137    INCREMENT BY 1
1138    NO MINVALUE
1139    NO MAXVALUE
1140    CACHE 1;
1141
1142
1143--
1144-- Name: pack_line_configurations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1145--
1146
1147ALTER SEQUENCE pack_line_configurations_id_seq OWNED BY pack_line_configurations.id;
1148
1149
1150--
1151-- Name: pack_line_scan_device_assignments; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1152--
1153
1154CREATE TABLE pack_line_scan_device_assignments (
1155    id integer NOT NULL,
1156    pack_line_id integer NOT NULL,
1157    scan_device_id integer NOT NULL,
1158    started_at timestamp without time zone NOT NULL,
1159    ended_at timestamp without time zone,
1160    created_at timestamp without time zone,
1161    updated_at timestamp without time zone,
1162    assigning_employee_id character varying,
1163    scanner_id character varying,
1164    is_started boolean DEFAULT true,
1165    pack_line_configuration_id integer
1166);
1167
1168
1169--
1170-- Name: pack_line_scan_device_assignments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1171--
1172
1173CREATE SEQUENCE pack_line_scan_device_assignments_id_seq
1174    START WITH 1
1175    INCREMENT BY 1
1176    NO MINVALUE
1177    NO MAXVALUE
1178    CACHE 1;
1179
1180
1181--
1182-- Name: pack_line_scan_device_assignments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1183--
1184
1185ALTER SEQUENCE pack_line_scan_device_assignments_id_seq OWNED BY pack_line_scan_device_assignments.id;
1186
1187
1188--
1189-- Name: pack_line_slot_assignments; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1190--
1191
1192CREATE TABLE pack_line_slot_assignments (
1193    id integer NOT NULL,
1194    pack_line_slot_id integer NOT NULL,
1195    started_at timestamp without time zone NOT NULL,
1196    ended_at timestamp without time zone,
1197    created_at timestamp without time zone,
1198    updated_at timestamp without time zone,
1199    employee_id integer,
1200    scanner_id character varying,
1201    assigning_employee_id integer,
1202    is_started boolean DEFAULT true,
1203    pack_line_slot_configuration_id integer
1204);
1205
1206
1207--
1208-- Name: pack_line_slot_assignments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1209--
1210
1211CREATE SEQUENCE pack_line_slot_assignments_id_seq
1212    START WITH 1
1213    INCREMENT BY 1
1214    NO MINVALUE
1215    NO MAXVALUE
1216    CACHE 1;
1217
1218
1219--
1220-- Name: pack_line_slot_assignments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1221--
1222
1223ALTER SEQUENCE pack_line_slot_assignments_id_seq OWNED BY pack_line_slot_assignments.id;
1224
1225
1226--
1227-- Name: pack_line_slot_configurations; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1228--
1229
1230CREATE TABLE pack_line_slot_configurations (
1231    id integer NOT NULL,
1232    pack_line_slot_id integer NOT NULL,
1233    planogram_slot_id integer NOT NULL,
1234    started_at timestamp without time zone,
1235    ended_at timestamp without time zone,
1236    created_at timestamp without time zone,
1237    updated_at timestamp without time zone,
1238    verified_at timestamp without time zone,
1239    verifier_id integer,
1240    is_started boolean DEFAULT true,
1241    confirmed_at timestamp without time zone,
1242    confirming_employee_id integer,
1243    pack_line_configuration_id integer
1244);
1245
1246
1247--
1248-- Name: pack_line_slot_configurations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1249--
1250
1251CREATE SEQUENCE pack_line_slot_configurations_id_seq
1252    START WITH 1
1253    INCREMENT BY 1
1254    NO MINVALUE
1255    NO MAXVALUE
1256    CACHE 1;
1257
1258
1259--
1260-- Name: pack_line_slot_configurations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1261--
1262
1263ALTER SEQUENCE pack_line_slot_configurations_id_seq OWNED BY pack_line_slot_configurations.id;
1264
1265
1266--
1267-- Name: pack_line_slot_locks; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1268--
1269
1270CREATE TABLE pack_line_slot_locks (
1271    id integer NOT NULL,
1272    pack_line_slot_id integer,
1273    unlocker_id integer,
1274    unlocked_at timestamp without time zone,
1275    created_at timestamp without time zone,
1276    updated_at timestamp without time zone,
1277    locker_id integer,
1278    is_active boolean DEFAULT true
1279);
1280
1281
1282--
1283-- Name: pack_line_slot_locks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1284--
1285
1286CREATE SEQUENCE pack_line_slot_locks_id_seq
1287    START WITH 1
1288    INCREMENT BY 1
1289    NO MINVALUE
1290    NO MAXVALUE
1291    CACHE 1;
1292
1293
1294--
1295-- Name: pack_line_slot_locks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1296--
1297
1298ALTER SEQUENCE pack_line_slot_locks_id_seq OWNED BY pack_line_slot_locks.id;
1299
1300
1301--
1302-- Name: pack_line_slot_verification_attempts; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1303--
1304
1305CREATE TABLE pack_line_slot_verification_attempts (
1306    id integer NOT NULL,
1307    pack_line_slot_configuration_id integer,
1308    expires_at date,
1309    temperature double precision,
1310    is_successful boolean,
1311    created_at timestamp without time zone NOT NULL,
1312    updated_at timestamp without time zone NOT NULL
1313);
1314
1315
1316--
1317-- Name: pack_line_slot_verification_attempts_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1318--
1319
1320CREATE SEQUENCE pack_line_slot_verification_attempts_id_seq
1321    START WITH 1
1322    INCREMENT BY 1
1323    NO MINVALUE
1324    NO MAXVALUE
1325    CACHE 1;
1326
1327
1328--
1329-- Name: pack_line_slot_verification_attempts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1330--
1331
1332ALTER SEQUENCE pack_line_slot_verification_attempts_id_seq OWNED BY pack_line_slot_verification_attempts.id;
1333
1334
1335--
1336-- Name: pack_line_slots; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1337--
1338
1339CREATE TABLE pack_line_slots (
1340    id integer NOT NULL,
1341    pack_line_id integer,
1342    location_id integer,
1343    slot_number integer,
1344    created_at timestamp without time zone,
1345    updated_at timestamp without time zone
1346);
1347
1348
1349--
1350-- Name: pack_line_slots_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1351--
1352
1353CREATE SEQUENCE pack_line_slots_id_seq
1354    START WITH 1
1355    INCREMENT BY 1
1356    NO MINVALUE
1357    NO MAXVALUE
1358    CACHE 1;
1359
1360
1361--
1362-- Name: pack_line_slots_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1363--
1364
1365ALTER SEQUENCE pack_line_slots_id_seq OWNED BY pack_line_slots.id;
1366
1367
1368--
1369-- Name: pack_lines; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1370--
1371
1372CREATE TABLE pack_lines (
1373    id integer NOT NULL,
1374    facility_id integer NOT NULL,
1375    description character varying(255) NOT NULL,
1376    created_at timestamp without time zone,
1377    updated_at timestamp without time zone,
1378    sort_order integer
1379);
1380
1381
1382--
1383-- Name: pack_lines_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1384--
1385
1386CREATE SEQUENCE pack_lines_id_seq
1387    START WITH 1
1388    INCREMENT BY 1
1389    NO MINVALUE
1390    NO MAXVALUE
1391    CACHE 1;
1392
1393
1394--
1395-- Name: pack_lines_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1396--
1397
1398ALTER SEQUENCE pack_lines_id_seq OWNED BY pack_lines.id;
1399
1400
1401--
1402-- Name: packaging_notes; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1403--
1404
1405CREATE TABLE packaging_notes (
1406    id uuid DEFAULT uuid_generate_v4() NOT NULL,
1407    facility_id integer,
1408    instructions character varying,
1409    item_id integer,
1410    week_starts_on date,
1411    created_at timestamp without time zone NOT NULL,
1412    updated_at timestamp without time zone NOT NULL
1413);
1414
1415
1416--
1417-- Name: packaging_notes_planogram_slots; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1418--
1419
1420CREATE TABLE packaging_notes_planogram_slots (
1421    packaging_note_id uuid,
1422    planogram_slot_id integer
1423);
1424
1425
1426--
1427-- Name: packagings; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1428--
1429
1430CREATE TABLE packagings (
1431    id integer NOT NULL,
1432    name character varying NOT NULL,
1433    sub_type character varying,
1434    category character varying,
1435    archived_at timestamp without time zone,
1436    created_at timestamp without time zone NOT NULL,
1437    updated_at timestamp without time zone NOT NULL
1438);
1439
1440
1441--
1442-- Name: packagings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1443--
1444
1445CREATE SEQUENCE packagings_id_seq
1446    START WITH 1
1447    INCREMENT BY 1
1448    NO MINVALUE
1449    NO MAXVALUE
1450    CACHE 1;
1451
1452
1453--
1454-- Name: packagings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1455--
1456
1457ALTER SEQUENCE packagings_id_seq OWNED BY packagings.id;
1458
1459
1460--
1461-- Name: planogram_lines; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1462--
1463
1464CREATE TABLE planogram_lines (
1465    id integer NOT NULL,
1466    planogram_id integer NOT NULL,
1467    meal_configuration_id uuid,
1468    created_at timestamp without time zone,
1469    updated_at timestamp without time zone,
1470    transit_days integer,
1471    is_published boolean DEFAULT false,
1472    type character varying,
1473    recipe_type_id integer,
1474    is_hidden boolean DEFAULT true,
1475    published_at timestamp without time zone,
1476    unpublished_at timestamp without time zone
1477);
1478
1479
1480--
1481-- Name: planogram_lines_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1482--
1483
1484CREATE SEQUENCE planogram_lines_id_seq
1485    START WITH 1
1486    INCREMENT BY 1
1487    NO MINVALUE
1488    NO MAXVALUE
1489    CACHE 1;
1490
1491
1492--
1493-- Name: planogram_lines_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1494--
1495
1496ALTER SEQUENCE planogram_lines_id_seq OWNED BY planogram_lines.id;
1497
1498
1499--
1500-- Name: planogram_slots; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1501--
1502
1503CREATE TABLE planogram_slots (
1504    id integer NOT NULL,
1505    planogram_line_id integer,
1506    item_id integer,
1507    slot_number integer NOT NULL,
1508    item_packaging character varying,
1509    item_quantity integer,
1510    recipe_type character varying,
1511    max_temperature double precision,
1512    is_sortable boolean DEFAULT true,
1513    recipe_type_id integer,
1514    created_at timestamp without time zone,
1515    updated_at timestamp without time zone
1516);
1517
1518
1519--
1520-- Name: planogram_slots_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1521--
1522
1523CREATE SEQUENCE planogram_slots_id_seq
1524    START WITH 1
1525    INCREMENT BY 1
1526    NO MINVALUE
1527    NO MAXVALUE
1528    CACHE 1;
1529
1530
1531--
1532-- Name: planogram_slots_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1533--
1534
1535ALTER SEQUENCE planogram_slots_id_seq OWNED BY planogram_slots.id;
1536
1537
1538--
1539-- Name: planogram_slots_quality_checks; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1540--
1541
1542CREATE TABLE planogram_slots_quality_checks (
1543    planogram_slot_id integer NOT NULL,
1544    quality_check_id integer NOT NULL
1545);
1546
1547
1548--
1549-- Name: planograms; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1550--
1551
1552CREATE TABLE planograms (
1553    id integer NOT NULL,
1554    facility_id integer NOT NULL,
1555    week_starts_on date NOT NULL,
1556    started_at timestamp without time zone NOT NULL,
1557    ended_at timestamp without time zone,
1558    created_at timestamp without time zone,
1559    updated_at timestamp without time zone,
1560    is_started boolean DEFAULT true
1561);
1562
1563
1564--
1565-- Name: planograms_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1566--
1567
1568CREATE SEQUENCE planograms_id_seq
1569    START WITH 1
1570    INCREMENT BY 1
1571    NO MINVALUE
1572    NO MAXVALUE
1573    CACHE 1;
1574
1575
1576--
1577-- Name: planograms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1578--
1579
1580ALTER SEQUENCE planograms_id_seq OWNED BY planograms.id;
1581
1582
1583--
1584-- Name: ppm_goals; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1585--
1586
1587CREATE TABLE ppm_goals (
1588    id integer NOT NULL,
1589    recipe_detail_item_id integer NOT NULL,
1590    facility_id integer NOT NULL,
1591    goal double precision,
1592    automation character varying,
1593    created_at timestamp without time zone NOT NULL,
1594    updated_at timestamp without time zone NOT NULL
1595);
1596
1597
1598--
1599-- Name: ppm_goals_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1600--
1601
1602CREATE SEQUENCE ppm_goals_id_seq
1603    START WITH 1
1604    INCREMENT BY 1
1605    NO MINVALUE
1606    NO MAXVALUE
1607    CACHE 1;
1608
1609
1610--
1611-- Name: ppm_goals_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1612--
1613
1614ALTER SEQUENCE ppm_goals_id_seq OWNED BY ppm_goals.id;
1615
1616
1617--
1618-- Name: ppm_ingredient_events; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1619--
1620
1621CREATE TABLE ppm_ingredient_events (
1622    id integer NOT NULL,
1623    ppm_ingredient_id integer NOT NULL,
1624    event_type integer NOT NULL,
1625    completed_portions integer,
1626    actual_ppm numeric(8,1),
1627    created_at timestamp without time zone NOT NULL,
1628    updated_at timestamp without time zone NOT NULL,
1629    started_at timestamp without time zone,
1630    ended_at timestamp without time zone,
1631    event_details character varying,
1632    total_inactive_time integer
1633);
1634
1635
1636--
1637-- Name: ppm_ingredient_events_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1638--
1639
1640CREATE SEQUENCE ppm_ingredient_events_id_seq
1641    START WITH 1
1642    INCREMENT BY 1
1643    NO MINVALUE
1644    NO MAXVALUE
1645    CACHE 1;
1646
1647
1648--
1649-- Name: ppm_ingredient_events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1650--
1651
1652ALTER SEQUENCE ppm_ingredient_events_id_seq OWNED BY ppm_ingredient_events.id;
1653
1654
1655--
1656-- Name: ppm_ingredients; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1657--
1658
1659CREATE TABLE ppm_ingredients (
1660    id integer NOT NULL,
1661    ppm_shift_id integer,
1662    recipe_detail_item_id integer,
1663    ppm_goal numeric(8,1),
1664    completed_at timestamp without time zone,
1665    created_at timestamp without time zone NOT NULL,
1666    updated_at timestamp without time zone NOT NULL,
1667    ppm_session_id integer,
1668    portions_goal integer,
1669    portions_per_bin integer,
1670    specialist_id integer
1671);
1672
1673
1674--
1675-- Name: ppm_ingredients_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1676--
1677
1678CREATE SEQUENCE ppm_ingredients_id_seq
1679    START WITH 1
1680    INCREMENT BY 1
1681    NO MINVALUE
1682    NO MAXVALUE
1683    CACHE 1;
1684
1685
1686--
1687-- Name: ppm_ingredients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1688--
1689
1690ALTER SEQUENCE ppm_ingredients_id_seq OWNED BY ppm_ingredients.id;
1691
1692
1693--
1694-- Name: ppm_portions; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1695--
1696
1697CREATE TABLE ppm_portions (
1698    id integer NOT NULL,
1699    recipe_detail_item_id integer NOT NULL,
1700    facility_id integer NOT NULL,
1701    portion_per_bin integer,
1702    created_at timestamp without time zone NOT NULL,
1703    updated_at timestamp without time zone NOT NULL
1704);
1705
1706
1707--
1708-- Name: ppm_portions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1709--
1710
1711CREATE SEQUENCE ppm_portions_id_seq
1712    START WITH 1
1713    INCREMENT BY 1
1714    NO MINVALUE
1715    NO MAXVALUE
1716    CACHE 1;
1717
1718
1719--
1720-- Name: ppm_portions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1721--
1722
1723ALTER SEQUENCE ppm_portions_id_seq OWNED BY ppm_portions.id;
1724
1725
1726--
1727-- Name: ppm_sessions; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1728--
1729
1730CREATE TABLE ppm_sessions (
1731    id integer NOT NULL,
1732    started_at timestamp without time zone,
1733    ended_at timestamp without time zone,
1734    kitchen_table_id integer NOT NULL,
1735    created_at timestamp without time zone NOT NULL,
1736    updated_at timestamp without time zone NOT NULL
1737);
1738
1739
1740--
1741-- Name: ppm_sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1742--
1743
1744CREATE SEQUENCE ppm_sessions_id_seq
1745    START WITH 1
1746    INCREMENT BY 1
1747    NO MINVALUE
1748    NO MAXVALUE
1749    CACHE 1;
1750
1751
1752--
1753-- Name: ppm_sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1754--
1755
1756ALTER SEQUENCE ppm_sessions_id_seq OWNED BY ppm_sessions.id;
1757
1758
1759--
1760-- Name: ppm_shifts; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1761--
1762
1763CREATE TABLE ppm_shifts (
1764    id integer NOT NULL,
1765    started_at timestamp without time zone,
1766    ended_at timestamp without time zone,
1767    prep_table character varying NOT NULL,
1768    facility_id integer NOT NULL,
1769    created_at timestamp without time zone NOT NULL,
1770    updated_at timestamp without time zone NOT NULL
1771);
1772
1773
1774--
1775-- Name: ppm_shifts_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1776--
1777
1778CREATE SEQUENCE ppm_shifts_id_seq
1779    START WITH 1
1780    INCREMENT BY 1
1781    NO MINVALUE
1782    NO MAXVALUE
1783    CACHE 1;
1784
1785
1786--
1787-- Name: ppm_shifts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1788--
1789
1790ALTER SEQUENCE ppm_shifts_id_seq OWNED BY ppm_shifts.id;
1791
1792
1793--
1794-- Name: purchase_order_inventory_creations; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1795--
1796
1797CREATE TABLE purchase_order_inventory_creations (
1798    id integer NOT NULL,
1799    purchase_order_id integer NOT NULL,
1800    inventory_creation_id integer NOT NULL,
1801    is_archived boolean DEFAULT false NOT NULL,
1802    archived_at timestamp without time zone,
1803    lot_number character varying
1804);
1805
1806
1807--
1808-- Name: purchase_order_inventory_creations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1809--
1810
1811CREATE SEQUENCE purchase_order_inventory_creations_id_seq
1812    START WITH 1
1813    INCREMENT BY 1
1814    NO MINVALUE
1815    NO MAXVALUE
1816    CACHE 1;
1817
1818
1819--
1820-- Name: purchase_order_inventory_creations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1821--
1822
1823ALTER SEQUENCE purchase_order_inventory_creations_id_seq OWNED BY purchase_order_inventory_creations.id;
1824
1825
1826--
1827-- Name: purchase_orders; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1828--
1829
1830CREATE TABLE purchase_orders (
1831    id integer NOT NULL,
1832    purchase_order_number character varying NOT NULL
1833);
1834
1835
1836--
1837-- Name: purchase_orders_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1838--
1839
1840CREATE SEQUENCE purchase_orders_id_seq
1841    START WITH 1
1842    INCREMENT BY 1
1843    NO MINVALUE
1844    NO MAXVALUE
1845    CACHE 1;
1846
1847
1848--
1849-- Name: purchase_orders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1850--
1851
1852ALTER SEQUENCE purchase_orders_id_seq OWNED BY purchase_orders.id;
1853
1854
1855--
1856-- Name: quality_checks; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1857--
1858
1859CREATE TABLE quality_checks (
1860    id integer NOT NULL,
1861    week_starts_on character varying NOT NULL,
1862    archived_at timestamp without time zone,
1863    is_archived boolean DEFAULT false NOT NULL,
1864    facility_id integer NOT NULL,
1865    recipe_type_id integer NOT NULL,
1866    created_at timestamp without time zone,
1867    updated_at timestamp without time zone
1868);
1869
1870
1871--
1872-- Name: quality_checks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1873--
1874
1875CREATE SEQUENCE quality_checks_id_seq
1876    START WITH 1
1877    INCREMENT BY 1
1878    NO MINVALUE
1879    NO MAXVALUE
1880    CACHE 1;
1881
1882
1883--
1884-- Name: quality_checks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1885--
1886
1887ALTER SEQUENCE quality_checks_id_seq OWNED BY quality_checks.id;
1888
1889
1890--
1891-- Name: queue_print_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1892--
1893
1894CREATE SEQUENCE queue_print_jobs_id_seq
1895    START WITH 1
1896    INCREMENT BY 1
1897    NO MINVALUE
1898    NO MAXVALUE
1899    CACHE 1;
1900
1901
1902--
1903-- Name: queue_print_jobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1904--
1905
1906CREATE TABLE queue_print_jobs (
1907    id integer DEFAULT nextval('queue_print_jobs_id_seq'::regclass) NOT NULL,
1908    queue_id uuid NOT NULL,
1909    device_id character varying NOT NULL,
1910    print_started_at timestamp without time zone,
1911    print_ended_at timestamp without time zone,
1912    employee_id integer NOT NULL,
1913    status integer DEFAULT 0 NOT NULL,
1914    created_at timestamp without time zone,
1915    updated_at timestamp without time zone,
1916    batch_number integer,
1917    total_shipments_to_process integer,
1918    total_shipments_ok integer DEFAULT 0,
1919    total_shipments_error integer DEFAULT 0
1920);
1921
1922
1923--
1924-- Name: queue_print_shipments; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1925--
1926
1927CREATE TABLE queue_print_shipments (
1928    id integer NOT NULL,
1929    queue_print_job_id integer,
1930    status integer,
1931    shipping_label text,
1932    box_tag character varying,
1933    error text,
1934    shipment_id uuid,
1935    package_id uuid,
1936    created_at timestamp without time zone NOT NULL,
1937    updated_at timestamp without time zone NOT NULL,
1938    tracking_number character varying
1939);
1940
1941
1942--
1943-- Name: queue_print_shipments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1944--
1945
1946CREATE SEQUENCE queue_print_shipments_id_seq
1947    START WITH 1
1948    INCREMENT BY 1
1949    NO MINVALUE
1950    NO MAXVALUE
1951    CACHE 1;
1952
1953
1954--
1955-- Name: queue_print_shipments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1956--
1957
1958ALTER SEQUENCE queue_print_shipments_id_seq OWNED BY queue_print_shipments.id;
1959
1960
1961--
1962-- Name: rack_types; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1963--
1964
1965CREATE TABLE rack_types (
1966    id integer NOT NULL,
1967    name character varying NOT NULL,
1968    type character varying NOT NULL,
1969    created_at timestamp without time zone NOT NULL,
1970    updated_at timestamp without time zone NOT NULL
1971);
1972
1973
1974--
1975-- Name: rack_types_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1976--
1977
1978CREATE SEQUENCE rack_types_id_seq
1979    START WITH 1
1980    INCREMENT BY 1
1981    NO MINVALUE
1982    NO MAXVALUE
1983    CACHE 1;
1984
1985
1986--
1987-- Name: rack_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1988--
1989
1990ALTER SEQUENCE rack_types_id_seq OWNED BY rack_types.id;
1991
1992
1993--
1994-- Name: recipe_detail_items; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1995--
1996
1997CREATE TABLE recipe_detail_items (
1998    id integer NOT NULL,
1999    recipe_detail_id integer NOT NULL,
2000    item_id integer NOT NULL,
2001    kitchen_specification_id integer,
2002    created_at timestamp without time zone,
2003    updated_at timestamp without time zone,
2004    item_weight_in_oz double precision,
2005    packaging_method character varying,
2006    facility_id integer,
2007    is_archived boolean DEFAULT false NOT NULL,
2008    shelf_life integer,
2009    portion_count integer,
2010    purchasing_ingredient_number integer,
2011    purchasing_ingredient_label character varying,
2012    images json DEFAULT '{}'::json,
2013    range character varying,
2014    production_spec character varying,
2015    clone_id integer,
2016    number_of_pack_line_slots integer,
2017    production_spec_slot_1 character varying,
2018    production_spec_slot_2 character varying,
2019    measurement_type character varying,
2020    archived_at timestamp without time zone
2021);
2022
2023
2024--
2025-- Name: recipe_detail_items_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2026--
2027
2028CREATE SEQUENCE recipe_detail_items_id_seq
2029    START WITH 1
2030    INCREMENT BY 1
2031    NO MINVALUE
2032    NO MAXVALUE
2033    CACHE 1;
2034
2035
2036--
2037-- Name: recipe_detail_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2038--
2039
2040ALTER SEQUENCE recipe_detail_items_id_seq OWNED BY recipe_detail_items.id;
2041
2042
2043--
2044-- Name: recipe_details; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2045--
2046
2047CREATE TABLE recipe_details (
2048    id integer NOT NULL,
2049    delivery_recipe_id integer NOT NULL,
2050    recipe_title character varying NOT NULL,
2051    created_at timestamp without time zone,
2052    updated_at timestamp without time zone,
2053    week_starts_on date NOT NULL,
2054    recipe_type_id integer NOT NULL
2055);
2056
2057
2058--
2059-- Name: recipe_details_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2060--
2061
2062CREATE SEQUENCE recipe_details_id_seq
2063    START WITH 1
2064    INCREMENT BY 1
2065    NO MINVALUE
2066    NO MAXVALUE
2067    CACHE 1;
2068
2069
2070--
2071-- Name: recipe_details_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2072--
2073
2074ALTER SEQUENCE recipe_details_id_seq OWNED BY recipe_details.id;
2075
2076
2077--
2078-- Name: recipe_type_meal_configs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2079--
2080
2081CREATE TABLE recipe_type_meal_configs (
2082    id uuid DEFAULT uuid_generate_v4() NOT NULL,
2083    meal_configuration_id uuid,
2084    recipe_type_id integer,
2085    created_at timestamp without time zone NOT NULL,
2086    updated_at timestamp without time zone NOT NULL
2087);
2088
2089
2090--
2091-- Name: recipe_types; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2092--
2093
2094CREATE TABLE recipe_types (
2095    id integer NOT NULL,
2096    meal_type character varying,
2097    created_at timestamp without time zone,
2098    updated_at timestamp without time zone,
2099    short_code character varying,
2100    color_code character varying,
2101    pack_order integer,
2102    color_name character varying NOT NULL
2103);
2104
2105
2106--
2107-- Name: recipe_types_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2108--
2109
2110CREATE SEQUENCE recipe_types_id_seq
2111    START WITH 1
2112    INCREMENT BY 1
2113    NO MINVALUE
2114    NO MAXVALUE
2115    CACHE 1;
2116
2117
2118--
2119-- Name: recipe_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2120--
2121
2122ALTER SEQUENCE recipe_types_id_seq OWNED BY recipe_types.id;
2123
2124
2125--
2126-- Name: roles; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2127--
2128
2129CREATE TABLE roles (
2130    id integer NOT NULL,
2131    name character varying(255),
2132    resource_id integer,
2133    resource_type character varying(255),
2134    created_at timestamp without time zone,
2135    updated_at timestamp without time zone
2136);
2137
2138
2139--
2140-- Name: roles_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2141--
2142
2143CREATE SEQUENCE roles_id_seq
2144    START WITH 1
2145    INCREMENT BY 1
2146    NO MINVALUE
2147    NO MAXVALUE
2148    CACHE 1;
2149
2150
2151--
2152-- Name: roles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2153--
2154
2155ALTER SEQUENCE roles_id_seq OWNED BY roles.id;
2156
2157
2158--
2159-- Name: scan_devices; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2160--
2161
2162CREATE TABLE scan_devices (
2163    id integer NOT NULL,
2164    device_id character varying(255) NOT NULL,
2165    created_at timestamp without time zone,
2166    updated_at timestamp without time zone,
2167    friendly_name character varying
2168);
2169
2170
2171--
2172-- Name: scan_devices_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2173--
2174
2175CREATE SEQUENCE scan_devices_id_seq
2176    START WITH 1
2177    INCREMENT BY 1
2178    NO MINVALUE
2179    NO MAXVALUE
2180    CACHE 1;
2181
2182
2183--
2184-- Name: scan_devices_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2185--
2186
2187ALTER SEQUENCE scan_devices_id_seq OWNED BY scan_devices.id;
2188
2189
2190--
2191-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2192--
2193
2194CREATE TABLE schema_migrations (
2195    version character varying(255) NOT NULL
2196);
2197
2198
2199--
2200-- Name: shipping_methods; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2201--
2202
2203CREATE TABLE shipping_methods (
2204    id integer NOT NULL,
2205    facility_id integer NOT NULL,
2206    name character varying NOT NULL,
2207    ba_shipping_method_id integer NOT NULL,
2208    transit_days integer,
2209    pull_time_offset_minutes integer NOT NULL,
2210    text_color character varying,
2211    color character varying,
2212    box_type character varying,
2213    created_at timestamp without time zone,
2214    updated_at timestamp without time zone,
2215    uuid uuid,
2216    delivery_type character varying,
2217    code character varying,
2218    is_donation boolean,
2219    load_order integer,
2220    pickup_code character varying,
2221    ba_shipping_carrier_id character varying,
2222    sort_code character varying,
2223    stripe_color character varying
2224);
2225
2226
2227--
2228-- Name: shipping_methods_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2229--
2230
2231CREATE SEQUENCE shipping_methods_id_seq
2232    START WITH 1
2233    INCREMENT BY 1
2234    NO MINVALUE
2235    NO MAXVALUE
2236    CACHE 1;
2237
2238
2239--
2240-- Name: shipping_methods_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2241--
2242
2243ALTER SEQUENCE shipping_methods_id_seq OWNED BY shipping_methods.id;
2244
2245
2246--
2247-- Name: state_histories; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2248--
2249
2250CREATE TABLE state_histories (
2251    id integer NOT NULL,
2252    state character varying NOT NULL,
2253    previous_state character varying NOT NULL,
2254    stateable_id integer NOT NULL,
2255    stateable_type character varying NOT NULL,
2256    event character varying NOT NULL,
2257    participants json NOT NULL,
2258    created_at timestamp without time zone NOT NULL,
2259    updated_at timestamp without time zone NOT NULL
2260);
2261
2262
2263--
2264-- Name: state_histories_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2265--
2266
2267CREATE SEQUENCE state_histories_id_seq
2268    START WITH 1
2269    INCREMENT BY 1
2270    NO MINVALUE
2271    NO MAXVALUE
2272    CACHE 1;
2273
2274
2275--
2276-- Name: state_histories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2277--
2278
2279ALTER SEQUENCE state_histories_id_seq OWNED BY state_histories.id;
2280
2281
2282--
2283-- Name: workflow_participants; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2284--
2285
2286CREATE TABLE workflow_participants (
2287    id integer NOT NULL,
2288    workflow_id integer NOT NULL,
2289    participant_id integer NOT NULL,
2290    participant_type character varying NOT NULL,
2291    created_at timestamp without time zone,
2292    updated_at timestamp without time zone,
2293    role character varying,
2294    status integer,
2295    is_multiple_actives_allowed boolean DEFAULT false
2296);
2297
2298
2299--
2300-- Name: workflow_participants_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2301--
2302
2303CREATE SEQUENCE workflow_participants_id_seq
2304    START WITH 1
2305    INCREMENT BY 1
2306    NO MINVALUE
2307    NO MAXVALUE
2308    CACHE 1;
2309
2310
2311--
2312-- Name: workflow_participants_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2313--
2314
2315ALTER SEQUENCE workflow_participants_id_seq OWNED BY workflow_participants.id;
2316
2317
2318--
2319-- Name: workflows; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2320--
2321
2322CREATE TABLE workflows (
2323    id integer NOT NULL,
2324    status character varying NOT NULL,
2325    type character varying,
2326    subtype character varying,
2327    started_at timestamp without time zone,
2328    ended_at timestamp without time zone,
2329    created_at timestamp without time zone NOT NULL,
2330    updated_at timestamp without time zone NOT NULL,
2331    facility_id integer
2332);
2333
2334
2335--
2336-- Name: workflows_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2337--
2338
2339CREATE SEQUENCE workflows_id_seq
2340    START WITH 1
2341    INCREMENT BY 1
2342    NO MINVALUE
2343    NO MAXVALUE
2344    CACHE 1;
2345
2346
2347--
2348-- Name: workflows_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2349--
2350
2351ALTER SEQUENCE workflows_id_seq OWNED BY workflows.id;
2352
2353
2354--
2355-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2356--
2357
2358ALTER TABLE ONLY accepted_container_types ALTER COLUMN id SET DEFAULT nextval('accepted_container_types_id_seq'::regclass);
2359
2360
2361--
2362-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2363--
2364
2365ALTER TABLE ONLY accepted_inventory_types ALTER COLUMN id SET DEFAULT nextval('accepted_inventory_types_id_seq'::regclass);
2366
2367
2368--
2369-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2370--
2371
2372ALTER TABLE ONLY area_types ALTER COLUMN id SET DEFAULT nextval('area_types_id_seq'::regclass);
2373
2374
2375--
2376-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2377--
2378
2379ALTER TABLE ONLY areas ALTER COLUMN id SET DEFAULT nextval('areas_id_seq'::regclass);
2380
2381
2382--
2383-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2384--
2385
2386ALTER TABLE ONLY container_parent_change_logs ALTER COLUMN id SET DEFAULT nextval('container_parent_change_logs_id_seq'::regclass);
2387
2388
2389--
2390-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2391--
2392
2393ALTER TABLE ONLY container_snapshots ALTER COLUMN id SET DEFAULT nextval('container_snapshots_id_seq'::regclass);
2394
2395
2396--
2397-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2398--
2399
2400ALTER TABLE ONLY container_types ALTER COLUMN id SET DEFAULT nextval('container_types_id_seq'::regclass);
2401
2402
2403--
2404-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2405--
2406
2407ALTER TABLE ONLY containers ALTER COLUMN id SET DEFAULT nextval('containers_id_seq'::regclass);
2408
2409
2410--
2411-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2412--
2413
2414ALTER TABLE ONLY contents ALTER COLUMN id SET DEFAULT nextval('contents_id_seq'::regclass);
2415
2416
2417--
2418-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2419--
2420
2421ALTER TABLE ONLY cycle_count_requests ALTER COLUMN id SET DEFAULT nextval('cycle_count_requests_id_seq'::regclass);
2422
2423
2424--
2425-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2426--
2427
2428ALTER TABLE ONLY cycle_recipe_order_counts ALTER COLUMN id SET DEFAULT nextval('cycle_recipe_order_counts_id_seq'::regclass);
2429
2430
2431--
2432-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2433--
2434
2435ALTER TABLE ONLY default_planogram_slots ALTER COLUMN id SET DEFAULT nextval('default_planogram_slots_id_seq'::regclass);
2436
2437
2438--
2439-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2440--
2441
2442ALTER TABLE ONLY employees ALTER COLUMN id SET DEFAULT nextval('employees_id_seq'::regclass);
2443
2444
2445--
2446-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2447--
2448
2449ALTER TABLE ONLY employees_ppm_ingredients ALTER COLUMN id SET DEFAULT nextval('employees_ppm_ingredients_id_seq'::regclass);
2450
2451
2452--
2453-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2454--
2455
2456ALTER TABLE ONLY facilities ALTER COLUMN id SET DEFAULT nextval('facilities_id_seq'::regclass);
2457
2458
2459--
2460-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2461--
2462
2463ALTER TABLE ONLY inventories ALTER COLUMN id SET DEFAULT nextval('inventories_id_seq'::regclass);
2464
2465
2466--
2467-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2468--
2469
2470ALTER TABLE ONLY inventory_activities ALTER COLUMN id SET DEFAULT nextval('inventory_activities_id_seq'::regclass);
2471
2472
2473--
2474-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2475--
2476
2477ALTER TABLE ONLY inventory_activity_tags ALTER COLUMN id SET DEFAULT nextval('inventory_activity_tags_id_seq'::regclass);
2478
2479
2480--
2481-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2482--
2483
2484ALTER TABLE ONLY inventory_types ALTER COLUMN id SET DEFAULT nextval('inventory_types_id_seq'::regclass);
2485
2486
2487--
2488-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2489--
2490
2491ALTER TABLE ONLY item_components ALTER COLUMN id SET DEFAULT nextval('item_components_id_seq'::regclass);
2492
2493
2494--
2495-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2496--
2497
2498ALTER TABLE ONLY item_groups ALTER COLUMN id SET DEFAULT nextval('item_groups_id_seq'::regclass);
2499
2500
2501--
2502-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2503--
2504
2505ALTER TABLE ONLY item_tags ALTER COLUMN id SET DEFAULT nextval('item_tags_id_seq'::regclass);
2506
2507
2508--
2509-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2510--
2511
2512ALTER TABLE ONLY items ALTER COLUMN id SET DEFAULT nextval('items_id_seq'::regclass);
2513
2514
2515--
2516-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2517--
2518
2519ALTER TABLE ONLY kitchen_tables ALTER COLUMN id SET DEFAULT nextval('kitchen_tables_id_seq'::regclass);
2520
2521
2522--
2523-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2524--
2525
2526ALTER TABLE ONLY location_sizes ALTER COLUMN id SET DEFAULT nextval('location_sizes_id_seq'::regclass);
2527
2528
2529--
2530-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2531--
2532
2533ALTER TABLE ONLY locations ALTER COLUMN id SET DEFAULT nextval('locations_id_seq'::regclass);
2534
2535
2536--
2537-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2538--
2539
2540ALTER TABLE ONLY looker_views ALTER COLUMN id SET DEFAULT nextval('looker_views_id_seq'::regclass);
2541
2542
2543--
2544-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2545--
2546
2547ALTER TABLE ONLY pack_line_configurations ALTER COLUMN id SET DEFAULT nextval('pack_line_configurations_id_seq'::regclass);
2548
2549
2550--
2551-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2552--
2553
2554ALTER TABLE ONLY pack_line_scan_device_assignments ALTER COLUMN id SET DEFAULT nextval('pack_line_scan_device_assignments_id_seq'::regclass);
2555
2556
2557--
2558-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2559--
2560
2561ALTER TABLE ONLY pack_line_slot_assignments ALTER COLUMN id SET DEFAULT nextval('pack_line_slot_assignments_id_seq'::regclass);
2562
2563
2564--
2565-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2566--
2567
2568ALTER TABLE ONLY pack_line_slot_configurations ALTER COLUMN id SET DEFAULT nextval('pack_line_slot_configurations_id_seq'::regclass);
2569
2570
2571--
2572-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2573--
2574
2575ALTER TABLE ONLY pack_line_slot_locks ALTER COLUMN id SET DEFAULT nextval('pack_line_slot_locks_id_seq'::regclass);
2576
2577
2578--
2579-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2580--
2581
2582ALTER TABLE ONLY pack_line_slot_verification_attempts ALTER COLUMN id SET DEFAULT nextval('pack_line_slot_verification_attempts_id_seq'::regclass);
2583
2584
2585--
2586-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2587--
2588
2589ALTER TABLE ONLY pack_line_slots ALTER COLUMN id SET DEFAULT nextval('pack_line_slots_id_seq'::regclass);
2590
2591
2592--
2593-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2594--
2595
2596ALTER TABLE ONLY pack_lines ALTER COLUMN id SET DEFAULT nextval('pack_lines_id_seq'::regclass);
2597
2598
2599--
2600-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2601--
2602
2603ALTER TABLE ONLY packagings ALTER COLUMN id SET DEFAULT nextval('packagings_id_seq'::regclass);
2604
2605
2606--
2607-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2608--
2609
2610ALTER TABLE ONLY planogram_lines ALTER COLUMN id SET DEFAULT nextval('planogram_lines_id_seq'::regclass);
2611
2612
2613--
2614-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2615--
2616
2617ALTER TABLE ONLY planogram_slots ALTER COLUMN id SET DEFAULT nextval('planogram_slots_id_seq'::regclass);
2618
2619
2620--
2621-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2622--
2623
2624ALTER TABLE ONLY planograms ALTER COLUMN id SET DEFAULT nextval('planograms_id_seq'::regclass);
2625
2626
2627--
2628-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2629--
2630
2631ALTER TABLE ONLY ppm_goals ALTER COLUMN id SET DEFAULT nextval('ppm_goals_id_seq'::regclass);
2632
2633
2634--
2635-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2636--
2637
2638ALTER TABLE ONLY ppm_ingredient_events ALTER COLUMN id SET DEFAULT nextval('ppm_ingredient_events_id_seq'::regclass);
2639
2640
2641--
2642-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2643--
2644
2645ALTER TABLE ONLY ppm_ingredients ALTER COLUMN id SET DEFAULT nextval('ppm_ingredients_id_seq'::regclass);
2646
2647
2648--
2649-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2650--
2651
2652ALTER TABLE ONLY ppm_portions ALTER COLUMN id SET DEFAULT nextval('ppm_portions_id_seq'::regclass);
2653
2654
2655--
2656-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2657--
2658
2659ALTER TABLE ONLY ppm_sessions ALTER COLUMN id SET DEFAULT nextval('ppm_sessions_id_seq'::regclass);
2660
2661
2662--
2663-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2664--
2665
2666ALTER TABLE ONLY ppm_shifts ALTER COLUMN id SET DEFAULT nextval('ppm_shifts_id_seq'::regclass);
2667
2668
2669--
2670-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2671--
2672
2673ALTER TABLE ONLY purchase_order_inventory_creations ALTER COLUMN id SET DEFAULT nextval('purchase_order_inventory_creations_id_seq'::regclass);
2674
2675
2676--
2677-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2678--
2679
2680ALTER TABLE ONLY purchase_orders ALTER COLUMN id SET DEFAULT nextval('purchase_orders_id_seq'::regclass);
2681
2682
2683--
2684-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2685--
2686
2687ALTER TABLE ONLY quality_checks ALTER COLUMN id SET DEFAULT nextval('quality_checks_id_seq'::regclass);
2688
2689
2690--
2691-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2692--
2693
2694ALTER TABLE ONLY queue_print_shipments ALTER COLUMN id SET DEFAULT nextval('queue_print_shipments_id_seq'::regclass);
2695
2696
2697--
2698-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2699--
2700
2701ALTER TABLE ONLY rack_types ALTER COLUMN id SET DEFAULT nextval('rack_types_id_seq'::regclass);
2702
2703
2704--
2705-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2706--
2707
2708ALTER TABLE ONLY recipe_detail_items ALTER COLUMN id SET DEFAULT nextval('recipe_detail_items_id_seq'::regclass);
2709
2710
2711--
2712-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2713--
2714
2715ALTER TABLE ONLY recipe_details ALTER COLUMN id SET DEFAULT nextval('recipe_details_id_seq'::regclass);
2716
2717
2718--
2719-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2720--
2721
2722ALTER TABLE ONLY recipe_types ALTER COLUMN id SET DEFAULT nextval('recipe_types_id_seq'::regclass);
2723
2724
2725--
2726-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2727--
2728
2729ALTER TABLE ONLY roles ALTER COLUMN id SET DEFAULT nextval('roles_id_seq'::regclass);
2730
2731
2732--
2733-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2734--
2735
2736ALTER TABLE ONLY scan_devices ALTER COLUMN id SET DEFAULT nextval('scan_devices_id_seq'::regclass);
2737
2738
2739--
2740-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2741--
2742
2743ALTER TABLE ONLY shipping_methods ALTER COLUMN id SET DEFAULT nextval('shipping_methods_id_seq'::regclass);
2744
2745
2746--
2747-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2748--
2749
2750ALTER TABLE ONLY state_histories ALTER COLUMN id SET DEFAULT nextval('state_histories_id_seq'::regclass);
2751
2752
2753--
2754-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2755--
2756
2757ALTER TABLE ONLY workflow_participants ALTER COLUMN id SET DEFAULT nextval('workflow_participants_id_seq'::regclass);
2758
2759
2760--
2761-- Name: id; Type: DEFAULT; Schema: public; Owner: -
2762--
2763
2764ALTER TABLE ONLY workflows ALTER COLUMN id SET DEFAULT nextval('workflows_id_seq'::regclass);
2765
2766
2767--
2768-- Name: accepted_container_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2769--
2770
2771ALTER TABLE ONLY accepted_container_types
2772    ADD CONSTRAINT accepted_container_types_pkey PRIMARY KEY (id);
2773
2774
2775--
2776-- Name: accepted_inventory_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2777--
2778
2779ALTER TABLE ONLY accepted_inventory_types
2780    ADD CONSTRAINT accepted_inventory_types_pkey PRIMARY KEY (id);
2781
2782
2783--
2784-- Name: area_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2785--
2786
2787ALTER TABLE ONLY area_types
2788    ADD CONSTRAINT area_types_pkey PRIMARY KEY (id);
2789
2790
2791--
2792-- Name: bin_activities_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2793--
2794
2795ALTER TABLE ONLY inventory_activities
2796    ADD CONSTRAINT bin_activities_pkey PRIMARY KEY (id);
2797
2798
2799--
2800-- Name: bin_contents_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2801--
2802
2803ALTER TABLE ONLY contents
2804    ADD CONSTRAINT bin_contents_pkey PRIMARY KEY (id);
2805
2806
2807--
2808-- Name: bin_inventories_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2809--
2810
2811ALTER TABLE ONLY inventories
2812    ADD CONSTRAINT bin_inventories_pkey PRIMARY KEY (id);
2813
2814
2815--
2816-- Name: bins_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2817--
2818
2819ALTER TABLE ONLY containers
2820    ADD CONSTRAINT bins_pkey PRIMARY KEY (id);
2821
2822
2823--
2824-- Name: container_parent_change_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2825--
2826
2827ALTER TABLE ONLY container_parent_change_logs
2828    ADD CONSTRAINT container_parent_change_logs_pkey PRIMARY KEY (id);
2829
2830
2831--
2832-- Name: container_snapshots_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2833--
2834
2835ALTER TABLE ONLY container_snapshots
2836    ADD CONSTRAINT container_snapshots_pkey PRIMARY KEY (id);
2837
2838
2839--
2840-- Name: container_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2841--
2842
2843ALTER TABLE ONLY container_types
2844    ADD CONSTRAINT container_types_pkey PRIMARY KEY (id);
2845
2846
2847--
2848-- Name: cycle_count_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2849--
2850
2851ALTER TABLE ONLY cycle_count_requests
2852    ADD CONSTRAINT cycle_count_requests_pkey PRIMARY KEY (id);
2853
2854
2855--
2856-- Name: cycle_recipe_order_counts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2857--
2858
2859ALTER TABLE ONLY cycle_recipe_order_counts
2860    ADD CONSTRAINT cycle_recipe_order_counts_pkey PRIMARY KEY (id);
2861
2862
2863--
2864-- Name: default_planogram_slots_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2865--
2866
2867ALTER TABLE ONLY default_planogram_slots
2868    ADD CONSTRAINT default_planogram_slots_pkey PRIMARY KEY (id);
2869
2870
2871--
2872-- Name: employees_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2873--
2874
2875ALTER TABLE ONLY employees
2876    ADD CONSTRAINT employees_pkey PRIMARY KEY (id);
2877
2878
2879--
2880-- Name: employees_ppm_ingredients_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2881--
2882
2883ALTER TABLE ONLY employees_ppm_ingredients
2884    ADD CONSTRAINT employees_ppm_ingredients_pkey PRIMARY KEY (id);
2885
2886
2887--
2888-- Name: facilities_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2889--
2890
2891ALTER TABLE ONLY facilities
2892    ADD CONSTRAINT facilities_pkey PRIMARY KEY (id);
2893
2894
2895--
2896-- Name: inventory_activity_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2897--
2898
2899ALTER TABLE ONLY inventory_activity_tags
2900    ADD CONSTRAINT inventory_activity_tags_pkey PRIMARY KEY (id);
2901
2902
2903--
2904-- Name: inventory_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2905--
2906
2907ALTER TABLE ONLY inventory_types
2908    ADD CONSTRAINT inventory_types_pkey PRIMARY KEY (id);
2909
2910
2911--
2912-- Name: item_components_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2913--
2914
2915ALTER TABLE ONLY item_components
2916    ADD CONSTRAINT item_components_pkey PRIMARY KEY (id);
2917
2918
2919--
2920-- Name: item_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2921--
2922
2923ALTER TABLE ONLY item_groups
2924    ADD CONSTRAINT item_groups_pkey PRIMARY KEY (id);
2925
2926
2927--
2928-- Name: item_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2929--
2930
2931ALTER TABLE ONLY item_tags
2932    ADD CONSTRAINT item_tags_pkey PRIMARY KEY (id);
2933
2934
2935--
2936-- Name: items_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2937--
2938
2939ALTER TABLE ONLY items
2940    ADD CONSTRAINT items_pkey PRIMARY KEY (id);
2941
2942
2943--
2944-- Name: kitchen_tables_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2945--
2946
2947ALTER TABLE ONLY kitchen_tables
2948    ADD CONSTRAINT kitchen_tables_pkey PRIMARY KEY (id);
2949
2950
2951--
2952-- Name: location_sizes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2953--
2954
2955ALTER TABLE ONLY location_sizes
2956    ADD CONSTRAINT location_sizes_pkey PRIMARY KEY (id);
2957
2958
2959--
2960-- Name: locations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2961--
2962
2963ALTER TABLE ONLY locations
2964    ADD CONSTRAINT locations_pkey PRIMARY KEY (id);
2965
2966
2967--
2968-- Name: looker_views_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2969--
2970
2971ALTER TABLE ONLY looker_views
2972    ADD CONSTRAINT looker_views_pkey PRIMARY KEY (id);
2973
2974
2975--
2976-- Name: meal_configurations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2977--
2978
2979ALTER TABLE ONLY meal_configurations
2980    ADD CONSTRAINT meal_configurations_pkey PRIMARY KEY (id);
2981
2982
2983--
2984-- Name: pack_line_configurations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2985--
2986
2987ALTER TABLE ONLY pack_line_configurations
2988    ADD CONSTRAINT pack_line_configurations_pkey PRIMARY KEY (id);
2989
2990
2991--
2992-- Name: pack_line_scan_device_assignments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2993--
2994
2995ALTER TABLE ONLY pack_line_scan_device_assignments
2996    ADD CONSTRAINT pack_line_scan_device_assignments_pkey PRIMARY KEY (id);
2997
2998
2999--
3000-- Name: pack_line_slot_assignments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3001--
3002
3003ALTER TABLE ONLY pack_line_slot_assignments
3004    ADD CONSTRAINT pack_line_slot_assignments_pkey PRIMARY KEY (id);
3005
3006
3007--
3008-- Name: pack_line_slot_configurations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3009--
3010
3011ALTER TABLE ONLY pack_line_slot_configurations
3012    ADD CONSTRAINT pack_line_slot_configurations_pkey PRIMARY KEY (id);
3013
3014
3015--
3016-- Name: pack_line_slot_locks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3017--
3018
3019ALTER TABLE ONLY pack_line_slot_locks
3020    ADD CONSTRAINT pack_line_slot_locks_pkey PRIMARY KEY (id);
3021
3022
3023--
3024-- Name: pack_line_slot_verification_attempts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3025--
3026
3027ALTER TABLE ONLY pack_line_slot_verification_attempts
3028    ADD CONSTRAINT pack_line_slot_verification_attempts_pkey PRIMARY KEY (id);
3029
3030
3031--
3032-- Name: pack_line_slots_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3033--
3034
3035ALTER TABLE ONLY pack_line_slots
3036    ADD CONSTRAINT pack_line_slots_pkey PRIMARY KEY (id);
3037
3038
3039--
3040-- Name: pack_lines_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3041--
3042
3043ALTER TABLE ONLY pack_lines
3044    ADD CONSTRAINT pack_lines_pkey PRIMARY KEY (id);
3045
3046
3047--
3048-- Name: packaging_notes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3049--
3050
3051ALTER TABLE ONLY packaging_notes
3052    ADD CONSTRAINT packaging_notes_pkey PRIMARY KEY (id);
3053
3054
3055--
3056-- Name: packagings_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3057--
3058
3059ALTER TABLE ONLY packagings
3060    ADD CONSTRAINT packagings_pkey PRIMARY KEY (id);
3061
3062
3063--
3064-- Name: planogram_lines_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3065--
3066
3067ALTER TABLE ONLY planogram_lines
3068    ADD CONSTRAINT planogram_lines_pkey PRIMARY KEY (id);
3069
3070
3071--
3072-- Name: planogram_slots_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3073--
3074
3075ALTER TABLE ONLY planogram_slots
3076    ADD CONSTRAINT planogram_slots_pkey PRIMARY KEY (id);
3077
3078
3079--
3080-- Name: planograms_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3081--
3082
3083ALTER TABLE ONLY planograms
3084    ADD CONSTRAINT planograms_pkey PRIMARY KEY (id);
3085
3086
3087--
3088-- Name: ppm_goals_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3089--
3090
3091ALTER TABLE ONLY ppm_goals
3092    ADD CONSTRAINT ppm_goals_pkey PRIMARY KEY (id);
3093
3094
3095--
3096-- Name: ppm_ingredient_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3097--
3098
3099ALTER TABLE ONLY ppm_ingredient_events
3100    ADD CONSTRAINT ppm_ingredient_events_pkey PRIMARY KEY (id);
3101
3102
3103--
3104-- Name: ppm_ingredients_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3105--
3106
3107ALTER TABLE ONLY ppm_ingredients
3108    ADD CONSTRAINT ppm_ingredients_pkey PRIMARY KEY (id);
3109
3110
3111--
3112-- Name: ppm_portions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3113--
3114
3115ALTER TABLE ONLY ppm_portions
3116    ADD CONSTRAINT ppm_portions_pkey PRIMARY KEY (id);
3117
3118
3119--
3120-- Name: ppm_sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3121--
3122
3123ALTER TABLE ONLY ppm_sessions
3124    ADD CONSTRAINT ppm_sessions_pkey PRIMARY KEY (id);
3125
3126
3127--
3128-- Name: ppm_shifts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3129--
3130
3131ALTER TABLE ONLY ppm_shifts
3132    ADD CONSTRAINT ppm_shifts_pkey PRIMARY KEY (id);
3133
3134
3135--
3136-- Name: purchase_order_inventory_creations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3137--
3138
3139ALTER TABLE ONLY purchase_order_inventory_creations
3140    ADD CONSTRAINT purchase_order_inventory_creations_pkey PRIMARY KEY (id);
3141
3142
3143--
3144-- Name: purchase_orders_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3145--
3146
3147ALTER TABLE ONLY purchase_orders
3148    ADD CONSTRAINT purchase_orders_pkey PRIMARY KEY (id);
3149
3150
3151--
3152-- Name: quality_checks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3153--
3154
3155ALTER TABLE ONLY quality_checks
3156    ADD CONSTRAINT quality_checks_pkey PRIMARY KEY (id);
3157
3158
3159--
3160-- Name: queue_print_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3161--
3162
3163ALTER TABLE ONLY queue_print_jobs
3164    ADD CONSTRAINT queue_print_jobs_pkey PRIMARY KEY (id);
3165
3166
3167--
3168-- Name: queue_print_shipments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3169--
3170
3171ALTER TABLE ONLY queue_print_shipments
3172    ADD CONSTRAINT queue_print_shipments_pkey PRIMARY KEY (id);
3173
3174
3175--
3176-- Name: rack_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3177--
3178
3179ALTER TABLE ONLY rack_types
3180    ADD CONSTRAINT rack_types_pkey PRIMARY KEY (id);
3181
3182
3183--
3184-- Name: recipe_detail_items_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3185--
3186
3187ALTER TABLE ONLY recipe_detail_items
3188    ADD CONSTRAINT recipe_detail_items_pkey PRIMARY KEY (id);
3189
3190
3191--
3192-- Name: recipe_details_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3193--
3194
3195ALTER TABLE ONLY recipe_details
3196    ADD CONSTRAINT recipe_details_pkey PRIMARY KEY (id);
3197
3198
3199--
3200-- Name: recipe_type_meal_configs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3201--
3202
3203ALTER TABLE ONLY recipe_type_meal_configs
3204    ADD CONSTRAINT recipe_type_meal_configs_pkey PRIMARY KEY (id);
3205
3206
3207--
3208-- Name: recipe_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3209--
3210
3211ALTER TABLE ONLY recipe_types
3212    ADD CONSTRAINT recipe_types_pkey PRIMARY KEY (id);
3213
3214
3215--
3216-- Name: roles_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3217--
3218
3219ALTER TABLE ONLY roles
3220    ADD CONSTRAINT roles_pkey PRIMARY KEY (id);
3221
3222
3223--
3224-- Name: rooms_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3225--
3226
3227ALTER TABLE ONLY areas
3228    ADD CONSTRAINT rooms_pkey PRIMARY KEY (id);
3229
3230
3231--
3232-- Name: scan_devices_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3233--
3234
3235ALTER TABLE ONLY scan_devices
3236    ADD CONSTRAINT scan_devices_pkey PRIMARY KEY (id);
3237
3238
3239--
3240-- Name: shipping_methods_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3241--
3242
3243ALTER TABLE ONLY shipping_methods
3244    ADD CONSTRAINT shipping_methods_pkey PRIMARY KEY (id);
3245
3246
3247--
3248-- Name: state_histories_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3249--
3250
3251ALTER TABLE ONLY state_histories
3252    ADD CONSTRAINT state_histories_pkey PRIMARY KEY (id);
3253
3254
3255--
3256-- Name: workflow_participants_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3257--
3258
3259ALTER TABLE ONLY workflow_participants
3260    ADD CONSTRAINT workflow_participants_pkey PRIMARY KEY (id);
3261
3262
3263--
3264-- Name: workflows_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3265--
3266
3267ALTER TABLE ONLY workflows
3268    ADD CONSTRAINT workflows_pkey PRIMARY KEY (id);
3269
3270
3271--
3272-- Name: idx_cycle_recipe_order_counts_facility_recipe_detail_ship_date; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3273--
3274
3275CREATE UNIQUE INDEX idx_cycle_recipe_order_counts_facility_recipe_detail_ship_date ON cycle_recipe_order_counts USING btree (facility_id, recipe_detail_id, ship_date);
3276
3277
3278--
3279-- Name: idx_inventory_activities_container_and_destination_content; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3280--
3281
3282CREATE INDEX idx_inventory_activities_container_and_destination_content ON inventory_activities USING btree (container_id, destination_content_after_activity_id);
3283
3284
3285--
3286-- Name: idx_inventory_activities_dest_content_after_and_reason; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3287--
3288
3289CREATE INDEX idx_inventory_activities_dest_content_after_and_reason ON inventory_activities USING btree (destination_content_after_activity_id, reason);
3290
3291
3292--
3293-- Name: idx_inventory_activities_on_status_and_destination_location_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3294--
3295
3296CREATE INDEX idx_inventory_activities_on_status_and_destination_location_id ON inventory_activities USING btree (destination_location_id, status);
3297
3298
3299--
3300-- Name: idx_inventory_activities_on_status_and_source_location_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3301--
3302
3303CREATE INDEX idx_inventory_activities_on_status_and_source_location_id ON inventory_activities USING btree (source_location_id, status);
3304
3305
3306--
3307-- Name: idx_purchase_order_inventory_creations_on_inventory_creation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3308--
3309
3310CREATE INDEX idx_purchase_order_inventory_creations_on_inventory_creation_id ON purchase_order_inventory_creations USING btree (inventory_creation_id);
3311
3312
3313--
3314-- Name: idx_workflow_participants_participant_id_and_participant_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3315--
3316
3317CREATE INDEX idx_workflow_participants_participant_id_and_participant_type ON workflow_participants USING btree (participant_id, participant_type);
3318
3319
3320--
3321-- Name: index_accepted_container_types_on_container_type_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3322--
3323
3324CREATE INDEX index_accepted_container_types_on_container_type_id ON accepted_container_types USING btree (container_type_id);
3325
3326
3327--
3328-- Name: index_accepted_inventory_types_on_inventory_type_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3329--
3330
3331CREATE INDEX index_accepted_inventory_types_on_inventory_type_id ON accepted_inventory_types USING btree (inventory_type_id);
3332
3333
3334--
3335-- Name: index_container_parent_change_logs_on_container_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3336--
3337
3338CREATE INDEX index_container_parent_change_logs_on_container_id ON container_parent_change_logs USING btree (container_id);
3339
3340
3341--
3342-- Name: index_container_snapshots_on_cycle_count_request_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3343--
3344
3345CREATE INDEX index_container_snapshots_on_cycle_count_request_id ON container_snapshots USING btree (cycle_count_request_id);
3346
3347
3348--
3349-- Name: index_container_snapshots_on_status; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3350--
3351
3352CREATE INDEX index_container_snapshots_on_status ON container_snapshots USING btree (status);
3353
3354
3355--
3356-- Name: index_containers_on_code; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3357--
3358
3359CREATE UNIQUE INDEX index_containers_on_code ON containers USING btree (code);
3360
3361
3362--
3363-- Name: index_containers_on_facility_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3364--
3365
3366CREATE INDEX index_containers_on_facility_id ON containers USING btree (facility_id) WHERE (retired_at IS NULL);
3367
3368
3369--
3370-- Name: index_containers_on_retired_at; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3371--
3372
3373CREATE INDEX index_containers_on_retired_at ON containers USING btree (retired_at);
3374
3375
3376--
3377-- Name: index_contents_on_item_amount; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3378--
3379
3380CREATE INDEX index_contents_on_item_amount ON contents USING btree (item_amount);
3381
3382
3383--
3384-- Name: index_contents_on_item_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3385--
3386
3387CREATE INDEX index_contents_on_item_id ON contents USING btree (item_id);
3388
3389
3390--
3391-- Name: index_contents_on_recipe_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3392--
3393
3394CREATE INDEX index_contents_on_recipe_detail_id ON contents USING btree (recipe_detail_id);
3395
3396
3397--
3398-- Name: index_cycle_count_requests_on_container_id_and_facility_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3399--
3400
3401CREATE UNIQUE INDEX index_cycle_count_requests_on_container_id_and_facility_id ON cycle_count_requests USING btree (container_id, facility_id) WHERE (((status)::text = ANY (ARRAY[('unstarted'::character varying)::text, ('started'::character varying)::text])) AND (container_id IS NOT NULL));
3402
3403
3404--
3405-- Name: index_cycle_count_requests_on_facility_id_and_status; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3406--
3407
3408CREATE INDEX index_cycle_count_requests_on_facility_id_and_status ON cycle_count_requests USING btree (facility_id, status);
3409
3410
3411--
3412-- Name: index_cycle_count_requests_on_item_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3413--
3414
3415CREATE INDEX index_cycle_count_requests_on_item_id ON cycle_count_requests USING btree (item_id);
3416
3417
3418--
3419-- Name: index_cycle_count_requests_on_item_id_and_facility_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3420--
3421
3422CREATE UNIQUE INDEX index_cycle_count_requests_on_item_id_and_facility_id ON cycle_count_requests USING btree (item_id, facility_id) WHERE (((status)::text = ANY (ARRAY[('unstarted'::character varying)::text, ('started'::character varying)::text])) AND (item_id IS NOT NULL));
3423
3424
3425--
3426-- Name: index_default_planogram_slots_on_facility_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3427--
3428
3429CREATE INDEX index_default_planogram_slots_on_facility_id ON default_planogram_slots USING btree (facility_id);
3430
3431
3432--
3433-- Name: index_employees_on_container_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3434--
3435
3436CREATE UNIQUE INDEX index_employees_on_container_id ON employees USING btree (container_id);
3437
3438
3439--
3440-- Name: index_employees_on_email; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3441--
3442
3443CREATE UNIQUE INDEX index_employees_on_email ON employees USING btree (email);
3444
3445
3446--
3447-- Name: index_employees_on_employee_number; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3448--
3449
3450CREATE UNIQUE INDEX index_employees_on_employee_number ON employees USING btree (employee_number);
3451
3452
3453--
3454-- Name: index_employees_on_facility_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3455--
3456
3457CREATE INDEX index_employees_on_facility_id ON employees USING btree (facility_id);
3458
3459
3460--
3461-- Name: index_employees_on_reset_password_token; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3462--
3463
3464CREATE UNIQUE INDEX index_employees_on_reset_password_token ON employees USING btree (reset_password_token);
3465
3466
3467--
3468-- Name: index_employees_on_role_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3469--
3470
3471CREATE INDEX index_employees_on_role_id ON employees USING btree (role_id);
3472
3473
3474--
3475-- Name: index_employees_ppm_ingredients_on_employee_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3476--
3477
3478CREATE INDEX index_employees_ppm_ingredients_on_employee_id ON employees_ppm_ingredients USING btree (employee_id);
3479
3480
3481--
3482-- Name: index_employees_ppm_ingredients_on_ppm_ingredient_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3483--
3484
3485CREATE INDEX index_employees_ppm_ingredients_on_ppm_ingredient_id ON employees_ppm_ingredients USING btree (ppm_ingredient_id);
3486
3487
3488--
3489-- Name: index_facilities_on_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3490--
3491
3492CREATE UNIQUE INDEX index_facilities_on_name ON facilities USING btree (name);
3493
3494
3495--
3496-- Name: index_inventories_on_container_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3497--
3498
3499CREATE UNIQUE INDEX index_inventories_on_container_id ON inventories USING btree (container_id);
3500
3501
3502--
3503-- Name: index_inventories_on_content_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3504--
3505
3506CREATE UNIQUE INDEX index_inventories_on_content_id ON inventories USING btree (content_id);
3507
3508
3509--
3510-- Name: index_inventories_on_location_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3511--
3512
3513CREATE INDEX index_inventories_on_location_id ON inventories USING btree (location_id);
3514
3515
3516--
3517-- Name: index_inventory_activities_on_activity_type_and_ended_at; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3518--
3519
3520CREATE INDEX index_inventory_activities_on_activity_type_and_ended_at ON inventory_activities USING btree (activity_type, ended_at);
3521
3522
3523--
3524-- Name: index_inventory_activities_on_activity_type_and_reason; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3525--
3526
3527CREATE INDEX index_inventory_activities_on_activity_type_and_reason ON inventory_activities USING btree (activity_type, reason);
3528
3529
3530--
3531-- Name: index_inventory_activities_on_activity_type_and_started_at; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3532--
3533
3534CREATE INDEX index_inventory_activities_on_activity_type_and_started_at ON inventory_activities USING btree (activity_type, started_at);
3535
3536
3537--
3538-- Name: index_inventory_activities_on_container_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3539--
3540
3541CREATE INDEX index_inventory_activities_on_container_id ON inventory_activities USING btree (container_id) WHERE ((activity_type)::text = 'InventoryCreation'::text);
3542
3543
3544--
3545-- Name: index_inventory_activities_on_content_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3546--
3547
3548CREATE INDEX index_inventory_activities_on_content_id ON inventory_activities USING btree (content_id);
3549
3550
3551--
3552-- Name: index_inventory_activities_on_destination_inventory_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3553--
3554
3555CREATE INDEX index_inventory_activities_on_destination_inventory_id ON inventory_activities USING btree (destination_inventory_id);
3556
3557
3558--
3559-- Name: index_inventory_activities_on_inventory_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3560--
3561
3562CREATE INDEX index_inventory_activities_on_inventory_id ON inventory_activities USING btree (inventory_id);
3563
3564
3565--
3566-- Name: index_inventory_activities_on_source_inventory_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3567--
3568
3569CREATE INDEX index_inventory_activities_on_source_inventory_id ON inventory_activities USING btree (source_inventory_id);
3570
3571
3572--
3573-- Name: index_inventory_activity_taggings_on_inventory_activity_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3574--
3575
3576CREATE INDEX index_inventory_activity_taggings_on_inventory_activity_id ON inventory_activity_taggings USING btree (inventory_activity_id);
3577
3578
3579--
3580-- Name: index_inventory_activity_taggings_on_inventory_activity_tag_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3581--
3582
3583CREATE INDEX index_inventory_activity_taggings_on_inventory_activity_tag_id ON inventory_activity_taggings USING btree (inventory_activity_tag_id);
3584
3585
3586--
3587-- Name: index_inventory_types_on_code; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3588--
3589
3590CREATE UNIQUE INDEX index_inventory_types_on_code ON inventory_types USING btree (code);
3591
3592
3593--
3594-- Name: index_inventory_types_on_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3595--
3596
3597CREATE UNIQUE INDEX index_inventory_types_on_name ON inventory_types USING btree (name);
3598
3599
3600--
3601-- Name: index_item_components_on_child_item_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3602--
3603
3604CREATE INDEX index_item_components_on_child_item_id ON item_components USING btree (child_item_id);
3605
3606
3607--
3608-- Name: index_item_components_on_parent_item_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3609--
3610
3611CREATE INDEX index_item_components_on_parent_item_id ON item_components USING btree (parent_item_id);
3612
3613
3614--
3615-- Name: index_item_taggings_on_item_id_and_item_tag_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3616--
3617
3618CREATE UNIQUE INDEX index_item_taggings_on_item_id_and_item_tag_id ON item_taggings USING btree (item_id, item_tag_id);
3619
3620
3621--
3622-- Name: index_item_taggings_on_item_tag_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3623--
3624
3625CREATE INDEX index_item_taggings_on_item_tag_id ON item_taggings USING btree (item_tag_id);
3626
3627
3628--
3629-- Name: index_items_on_code; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3630--
3631
3632CREATE UNIQUE INDEX index_items_on_code ON items USING btree (code);
3633
3634
3635--
3636-- Name: index_items_on_item_group_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3637--
3638
3639CREATE INDEX index_items_on_item_group_id ON items USING btree (item_group_id);
3640
3641
3642--
3643-- Name: index_items_on_itemizable_type_and_itemizable_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3644--
3645
3646CREATE INDEX index_items_on_itemizable_type_and_itemizable_id ON items USING btree (itemizable_type, itemizable_id);
3647
3648
3649--
3650-- Name: index_items_on_reference_type_and_description; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3651--
3652
3653CREATE INDEX index_items_on_reference_type_and_description ON items USING btree (reference_type, description);
3654
3655
3656--
3657-- Name: index_items_on_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3658--
3659
3660CREATE INDEX index_items_on_type ON items USING btree (type);
3661
3662
3663--
3664-- Name: index_kitchen_tables_on_device_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3665--
3666
3667CREATE UNIQUE INDEX index_kitchen_tables_on_device_uuid ON kitchen_tables USING btree (device_uuid) WHERE (is_archived = false);
3668
3669
3670--
3671-- Name: index_location_sizes_on_rack_type_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3672--
3673
3674CREATE INDEX index_location_sizes_on_rack_type_id ON location_sizes USING btree (rack_type_id);
3675
3676
3677--
3678-- Name: index_locations_on_area_id_and_used_for; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3679--
3680
3681CREATE INDEX index_locations_on_area_id_and_used_for ON locations USING btree (area_id, used_for);
3682
3683
3684--
3685-- Name: index_locations_on_code; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3686--
3687
3688CREATE UNIQUE INDEX index_locations_on_code ON locations USING btree (code) WHERE (is_archived = false);
3689
3690
3691--
3692-- Name: index_locations_on_container_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3693--
3694
3695CREATE UNIQUE INDEX index_locations_on_container_id ON locations USING btree (container_id);
3696
3697
3698--
3699-- Name: index_locations_on_item_group_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3700--
3701
3702CREATE INDEX index_locations_on_item_group_id ON locations USING btree (item_group_id);
3703
3704
3705--
3706-- Name: index_locations_on_temperature; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3707--
3708
3709CREATE INDEX index_locations_on_temperature ON locations USING btree (temperature);
3710
3711
3712--
3713-- Name: index_locations_on_used_for; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3714--
3715
3716CREATE INDEX index_locations_on_used_for ON locations USING btree (used_for);
3717
3718
3719--
3720-- Name: index_looker_views_on_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3721--
3722
3723CREATE UNIQUE INDEX index_looker_views_on_name ON looker_views USING btree (name);
3724
3725
3726--
3727-- Name: index_meal_configurations_on_is_active; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3728--
3729
3730CREATE INDEX index_meal_configurations_on_is_active ON meal_configurations USING btree (is_active);
3731
3732
3733--
3734-- Name: index_meal_configurations_on_short_code; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3735--
3736
3737CREATE UNIQUE INDEX index_meal_configurations_on_short_code ON meal_configurations USING btree (short_code);
3738
3739
3740--
3741-- Name: index_pack_line_configurations_on_pack_line_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3742--
3743
3744CREATE INDEX index_pack_line_configurations_on_pack_line_id ON pack_line_configurations USING btree (pack_line_id);
3745
3746
3747--
3748-- Name: index_pack_line_configurations_on_pack_line_id_and_is_started; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3749--
3750
3751CREATE UNIQUE INDEX index_pack_line_configurations_on_pack_line_id_and_is_started ON pack_line_configurations USING btree (pack_line_id, is_started) WHERE (is_started IS TRUE);
3752
3753
3754--
3755-- Name: index_pack_line_scan_device_assignments_on_pack_line_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3756--
3757
3758CREATE INDEX index_pack_line_scan_device_assignments_on_pack_line_id ON pack_line_scan_device_assignments USING btree (pack_line_id);
3759
3760
3761--
3762-- Name: index_pack_line_scan_device_assignments_on_scan_device_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3763--
3764
3765CREATE INDEX index_pack_line_scan_device_assignments_on_scan_device_id ON pack_line_scan_device_assignments USING btree (scan_device_id);
3766
3767
3768--
3769-- Name: index_pack_line_scan_device_assignments_unique_started; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3770--
3771
3772CREATE UNIQUE INDEX index_pack_line_scan_device_assignments_unique_started ON pack_line_scan_device_assignments USING btree (pack_line_id, is_started) WHERE (is_started IS TRUE);
3773
3774
3775--
3776-- Name: index_pack_line_scan_device_unique_started; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3777--
3778
3779CREATE UNIQUE INDEX index_pack_line_scan_device_unique_started ON pack_line_scan_device_assignments USING btree (scan_device_id, is_started) WHERE (is_started IS TRUE);
3780
3781
3782--
3783-- Name: index_pack_line_slot_assignments_on_employee_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3784--
3785
3786CREATE INDEX index_pack_line_slot_assignments_on_employee_id ON pack_line_slot_assignments USING btree (employee_id);
3787
3788
3789--
3790-- Name: index_pack_line_slot_assignments_on_is_started; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3791--
3792
3793CREATE INDEX index_pack_line_slot_assignments_on_is_started ON pack_line_slot_assignments USING btree (is_started);
3794
3795
3796--
3797-- Name: index_pack_line_slot_assignments_on_pack_line_slot_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3798--
3799
3800CREATE INDEX index_pack_line_slot_assignments_on_pack_line_slot_id ON pack_line_slot_assignments USING btree (pack_line_slot_id);
3801
3802
3803--
3804-- Name: index_pack_line_slot_assignments_unique_started; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3805--
3806
3807CREATE UNIQUE INDEX index_pack_line_slot_assignments_unique_started ON pack_line_slot_assignments USING btree (pack_line_slot_id, is_started) WHERE (is_started IS TRUE);
3808
3809
3810--
3811-- Name: index_pack_line_slot_configurations_on_is_started; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3812--
3813
3814CREATE INDEX index_pack_line_slot_configurations_on_is_started ON pack_line_slot_configurations USING btree (is_started);
3815
3816
3817--
3818-- Name: index_pack_line_slot_configurations_on_pack_line_slot_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3819--
3820
3821CREATE INDEX index_pack_line_slot_configurations_on_pack_line_slot_id ON pack_line_slot_configurations USING btree (pack_line_slot_id);
3822
3823
3824--
3825-- Name: index_pack_line_slot_configurations_pscid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3826--
3827
3828CREATE INDEX index_pack_line_slot_configurations_pscid ON pack_line_slot_configurations USING btree (planogram_slot_id);
3829
3830
3831--
3832-- Name: index_pack_line_slot_configurations_unique_started; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3833--
3834
3835CREATE UNIQUE INDEX index_pack_line_slot_configurations_unique_started ON pack_line_slot_configurations USING btree (pack_line_slot_id, is_started) WHERE (is_started IS TRUE);
3836
3837
3838--
3839-- Name: index_pack_line_slot_locks_on_pack_line_slot_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3840--
3841
3842CREATE INDEX index_pack_line_slot_locks_on_pack_line_slot_id ON pack_line_slot_locks USING btree (pack_line_slot_id);
3843
3844
3845--
3846-- Name: index_pack_line_slot_locks_on_pack_line_slot_id_and_is_active; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3847--
3848
3849CREATE UNIQUE INDEX index_pack_line_slot_locks_on_pack_line_slot_id_and_is_active ON pack_line_slot_locks USING btree (pack_line_slot_id, is_active) WHERE (is_active IS TRUE);
3850
3851
3852--
3853-- Name: index_pack_line_slot_locks_on_pack_line_slot_id_and_unlocked_at; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3854--
3855
3856CREATE UNIQUE INDEX index_pack_line_slot_locks_on_pack_line_slot_id_and_unlocked_at ON pack_line_slot_locks USING btree (pack_line_slot_id, unlocked_at) WHERE (unlocked_at IS NULL);
3857
3858
3859--
3860-- Name: index_pack_line_slot_verification_attempts_configuration_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3861--
3862
3863CREATE INDEX index_pack_line_slot_verification_attempts_configuration_id ON pack_line_slot_verification_attempts USING btree (pack_line_slot_configuration_id);
3864
3865
3866--
3867-- Name: index_pack_line_slots_on_location_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3868--
3869
3870CREATE INDEX index_pack_line_slots_on_location_id ON pack_line_slots USING btree (location_id);
3871
3872
3873--
3874-- Name: index_pack_line_slots_on_pack_line_id_and_slot_number; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3875--
3876
3877CREATE UNIQUE INDEX index_pack_line_slots_on_pack_line_id_and_slot_number ON pack_line_slots USING btree (pack_line_id, slot_number);
3878
3879
3880--
3881-- Name: index_pack_lines_on_facility_id_and_description; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3882--
3883
3884CREATE UNIQUE INDEX index_pack_lines_on_facility_id_and_description ON pack_lines USING btree (facility_id, description);
3885
3886
3887--
3888-- Name: index_packaging_notes_on_week_starts_on; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3889--
3890
3891CREATE INDEX index_packaging_notes_on_week_starts_on ON packaging_notes USING btree (week_starts_on);
3892
3893
3894--
3895-- Name: index_packaging_notes_planogram_slots_on_planogram_slot_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3896--
3897
3898CREATE INDEX index_packaging_notes_planogram_slots_on_planogram_slot_id ON packaging_notes_planogram_slots USING btree (planogram_slot_id);
3899
3900
3901--
3902-- Name: index_planogram_line_attrs; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3903--
3904
3905CREATE INDEX index_planogram_line_attrs ON planogram_lines USING btree (planogram_id, meal_configuration_id, transit_days);
3906
3907
3908--
3909-- Name: index_planogram_lines_on_recipe_type_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3910--
3911
3912CREATE INDEX index_planogram_lines_on_recipe_type_id ON planogram_lines USING btree (recipe_type_id);
3913
3914
3915--
3916-- Name: index_planograms_on_facility_id_and_week_starts_on; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3917--
3918
3919CREATE INDEX index_planograms_on_facility_id_and_week_starts_on ON planograms USING btree (facility_id, week_starts_on);
3920
3921
3922--
3923-- Name: index_planograms_on_week_starts_on; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3924--
3925
3926CREATE INDEX index_planograms_on_week_starts_on ON planograms USING btree (week_starts_on);
3927
3928
3929--
3930-- Name: index_planograms_unique_started; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3931--
3932
3933CREATE UNIQUE INDEX index_planograms_unique_started ON planograms USING btree (facility_id, week_starts_on, is_started) WHERE (is_started IS TRUE);
3934
3935
3936--
3937-- Name: index_ppm_goals_on_recipe_detail_item_id_and_facility_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3938--
3939
3940CREATE INDEX index_ppm_goals_on_recipe_detail_item_id_and_facility_id ON ppm_goals USING btree (recipe_detail_item_id, facility_id);
3941
3942
3943--
3944-- Name: index_ppm_ingredient_events_on_event_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3945--
3946
3947CREATE INDEX index_ppm_ingredient_events_on_event_type ON ppm_ingredient_events USING btree (event_type);
3948
3949
3950--
3951-- Name: index_ppm_ingredient_events_on_ppm_ingredient_id_and_event_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3952--
3953
3954CREATE INDEX index_ppm_ingredient_events_on_ppm_ingredient_id_and_event_type ON ppm_ingredient_events USING btree (ppm_ingredient_id, event_type);
3955
3956
3957--
3958-- Name: index_ppm_ingredients_on_specialist_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3959--
3960
3961CREATE INDEX index_ppm_ingredients_on_specialist_id ON ppm_ingredients USING btree (specialist_id);
3962
3963
3964--
3965-- Name: index_ppm_portions_on_recipe_detail_item_id_and_facility_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3966--
3967
3968CREATE UNIQUE INDEX index_ppm_portions_on_recipe_detail_item_id_and_facility_id ON ppm_portions USING btree (recipe_detail_item_id, facility_id);
3969
3970
3971--
3972-- Name: index_queue_print_shipments_on_queue_print_job_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3973--
3974
3975CREATE INDEX index_queue_print_shipments_on_queue_print_job_id ON queue_print_shipments USING btree (queue_print_job_id);
3976
3977
3978--
3979-- Name: index_recipe_detail_items_on_item_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3980--
3981
3982CREATE INDEX index_recipe_detail_items_on_item_id ON recipe_detail_items USING btree (item_id);
3983
3984
3985--
3986-- Name: index_recipe_detail_items_on_kitchen_specification_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3987--
3988
3989CREATE INDEX index_recipe_detail_items_on_kitchen_specification_id ON recipe_detail_items USING btree (kitchen_specification_id);
3990
3991
3992--
3993-- Name: index_recipe_detail_items_on_recipe_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3994--
3995
3996CREATE INDEX index_recipe_detail_items_on_recipe_detail_id ON recipe_detail_items USING btree (recipe_detail_id);
3997
3998
3999--
4000-- Name: index_roles_on_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4001--
4002
4003CREATE UNIQUE INDEX index_roles_on_name ON roles USING btree (name);
4004
4005
4006--
4007-- Name: index_roles_on_name_and_resource_type_and_resource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4008--
4009
4010CREATE INDEX index_roles_on_name_and_resource_type_and_resource_id ON roles USING btree (name, resource_type, resource_id);
4011
4012
4013--
4014-- Name: index_scan_devices_on_device_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4015--
4016
4017CREATE INDEX index_scan_devices_on_device_id ON scan_devices USING btree (device_id);
4018
4019
4020--
4021-- Name: index_shipping_methods_on_ba_shipping_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4022--
4023
4024CREATE UNIQUE INDEX index_shipping_methods_on_ba_shipping_method_id ON shipping_methods USING btree (ba_shipping_method_id);
4025
4026
4027--
4028-- Name: index_shipping_methods_on_facility_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4029--
4030
4031CREATE INDEX index_shipping_methods_on_facility_id ON shipping_methods USING btree (facility_id);
4032
4033
4034--
4035-- Name: index_shipping_methods_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4036--
4037
4038CREATE UNIQUE INDEX index_shipping_methods_on_uuid ON shipping_methods USING btree (uuid);
4039
4040
4041--
4042-- Name: index_state_histories_on_stateable_id_and_stateable_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4043--
4044
4045CREATE INDEX index_state_histories_on_stateable_id_and_stateable_type ON state_histories USING btree (stateable_id, stateable_type);
4046
4047
4048--
4049-- Name: index_workflow_participants_on_workflow_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4050--
4051
4052CREATE INDEX index_workflow_participants_on_workflow_id ON workflow_participants USING btree (workflow_id);
4053
4054
4055--
4056-- Name: index_workflows_on_facility_id_and_status; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4057--
4058
4059CREATE INDEX index_workflows_on_facility_id_and_status ON workflows USING btree (facility_id, status);
4060
4061
4062--
4063-- Name: pack_lc_by_planogram_lc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4064--
4065
4066CREATE INDEX pack_lc_by_planogram_lc ON pack_line_configurations USING btree (planogram_line_id);
4067
4068
4069--
4070-- Name: planogram_sc_by_planogram_lc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4071--
4072
4073CREATE INDEX planogram_sc_by_planogram_lc ON planogram_slots USING btree (planogram_line_id);
4074
4075
4076--
4077-- Name: unique_data_migrations; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4078--
4079
4080CREATE UNIQUE INDEX unique_data_migrations ON data_migrations USING btree (version);
4081
4082
4083--
4084-- Name: unique_location_id_inventory_type_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4085--
4086
4087CREATE UNIQUE INDEX unique_location_id_inventory_type_id ON accepted_inventory_types USING btree (location_id, inventory_type_id);
4088
4089
4090--
4091-- Name: unique_location_size_id_container_type_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4092--
4093
4094CREATE UNIQUE INDEX unique_location_size_id_container_type_id ON accepted_container_types USING btree (location_size_id, container_type_id);
4095
4096
4097--
4098-- Name: unique_participant_id_on_workflow_participants; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4099--
4100
4101CREATE UNIQUE INDEX unique_participant_id_on_workflow_participants ON workflow_participants USING btree (participant_id, participant_type, status) WHERE (status = 1);
4102
4103
4104--
4105-- Name: unique_participant_type_on_workflow_participants; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4106--
4107
4108CREATE UNIQUE INDEX unique_participant_type_on_workflow_participants ON workflow_participants USING btree (workflow_id, participant_type, status) WHERE ((status = 1) AND (is_multiple_actives_allowed = false));
4109
4110
4111--
4112-- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4113--
4114
4115CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);
4116
4117
4118--
4119-- Name: fk_rails_005d8f8455; Type: FK CONSTRAINT; Schema: public; Owner: -
4120--
4121
4122ALTER TABLE ONLY queue_print_jobs
4123    ADD CONSTRAINT fk_rails_005d8f8455 FOREIGN KEY (employee_id) REFERENCES employees(id);
4124
4125
4126--
4127-- Name: fk_rails_10976948f3; Type: FK CONSTRAINT; Schema: public; Owner: -
4128--
4129
4130ALTER TABLE ONLY ppm_ingredient_events
4131    ADD CONSTRAINT fk_rails_10976948f3 FOREIGN KEY (ppm_ingredient_id) REFERENCES ppm_ingredients(id);
4132
4133
4134--
4135-- Name: fk_rails_1a96cd1b62; Type: FK CONSTRAINT; Schema: public; Owner: -
4136--
4137
4138ALTER TABLE ONLY container_parent_change_logs
4139    ADD CONSTRAINT fk_rails_1a96cd1b62 FOREIGN KEY (container_id) REFERENCES containers(id);
4140
4141
4142--
4143-- Name: fk_rails_24bc67ae55; Type: FK CONSTRAINT; Schema: public; Owner: -
4144--
4145
4146ALTER TABLE ONLY employees
4147    ADD CONSTRAINT fk_rails_24bc67ae55 FOREIGN KEY (role_id) REFERENCES roles(id);
4148
4149
4150--
4151-- Name: fk_rails_2610547605; Type: FK CONSTRAINT; Schema: public; Owner: -
4152--
4153
4154ALTER TABLE ONLY cycle_count_requests
4155    ADD CONSTRAINT fk_rails_2610547605 FOREIGN KEY (container_id) REFERENCES containers(id);
4156
4157
4158--
4159-- Name: fk_rails_27a595077b; Type: FK CONSTRAINT; Schema: public; Owner: -
4160--
4161
4162ALTER TABLE ONLY shipping_methods
4163    ADD CONSTRAINT fk_rails_27a595077b FOREIGN KEY (facility_id) REFERENCES facilities(id);
4164
4165
4166--
4167-- Name: fk_rails_2b446f20b2; Type: FK CONSTRAINT; Schema: public; Owner: -
4168--
4169
4170ALTER TABLE ONLY accepted_inventory_types
4171    ADD CONSTRAINT fk_rails_2b446f20b2 FOREIGN KEY (location_id) REFERENCES locations(id) ON DELETE CASCADE;
4172
4173
4174--
4175-- Name: fk_rails_47e1d0e34c; Type: FK CONSTRAINT; Schema: public; Owner: -
4176--
4177
4178ALTER TABLE ONLY container_parent_change_logs
4179    ADD CONSTRAINT fk_rails_47e1d0e34c FOREIGN KEY (old_parent_container_id) REFERENCES containers(id);
4180
4181
4182--
4183-- Name: fk_rails_4e02fbe7da; Type: FK CONSTRAINT; Schema: public; Owner: -
4184--
4185
4186ALTER TABLE ONLY areas
4187    ADD CONSTRAINT fk_rails_4e02fbe7da FOREIGN KEY (area_type_id) REFERENCES area_types(id);
4188
4189
4190--
4191-- Name: fk_rails_4e49e30b0f; Type: FK CONSTRAINT; Schema: public; Owner: -
4192--
4193
4194ALTER TABLE ONLY queue_print_shipments
4195    ADD CONSTRAINT fk_rails_4e49e30b0f FOREIGN KEY (queue_print_job_id) REFERENCES queue_print_jobs(id);
4196
4197
4198--
4199-- Name: fk_rails_52e3280157; Type: FK CONSTRAINT; Schema: public; Owner: -
4200--
4201
4202ALTER TABLE ONLY ppm_portions
4203    ADD CONSTRAINT fk_rails_52e3280157 FOREIGN KEY (recipe_detail_item_id) REFERENCES recipe_detail_items(id);
4204
4205
4206--
4207-- Name: fk_rails_6c2aee822a; Type: FK CONSTRAINT; Schema: public; Owner: -
4208--
4209
4210ALTER TABLE ONLY locations
4211    ADD CONSTRAINT fk_rails_6c2aee822a FOREIGN KEY (container_id) REFERENCES containers(id);
4212
4213
4214--
4215-- Name: fk_rails_714f25b0f5; Type: FK CONSTRAINT; Schema: public; Owner: -
4216--
4217
4218ALTER TABLE ONLY ppm_goals
4219    ADD CONSTRAINT fk_rails_714f25b0f5 FOREIGN KEY (recipe_detail_item_id) REFERENCES recipe_detail_items(id);
4220
4221
4222--
4223-- Name: fk_rails_81a8a22cc3; Type: FK CONSTRAINT; Schema: public; Owner: -
4224--
4225
4226ALTER TABLE ONLY ppm_goals
4227    ADD CONSTRAINT fk_rails_81a8a22cc3 FOREIGN KEY (facility_id) REFERENCES facilities(id);
4228
4229
4230--
4231-- Name: fk_rails_91a025275c; Type: FK CONSTRAINT; Schema: public; Owner: -
4232--
4233
4234ALTER TABLE ONLY contents
4235    ADD CONSTRAINT fk_rails_91a025275c FOREIGN KEY (item_id) REFERENCES items(id);
4236
4237
4238--
4239-- Name: fk_rails_949cb4e739; Type: FK CONSTRAINT; Schema: public; Owner: -
4240--
4241
4242ALTER TABLE ONLY locations
4243    ADD CONSTRAINT fk_rails_949cb4e739 FOREIGN KEY (location_size_id) REFERENCES location_sizes(id);
4244
4245
4246--
4247-- Name: fk_rails_97876a3deb; Type: FK CONSTRAINT; Schema: public; Owner: -
4248--
4249
4250ALTER TABLE ONLY items
4251    ADD CONSTRAINT fk_rails_97876a3deb FOREIGN KEY (item_group_id) REFERENCES item_groups(id);
4252
4253
4254--
4255-- Name: fk_rails_9bbe8f89cb; Type: FK CONSTRAINT; Schema: public; Owner: -
4256--
4257
4258ALTER TABLE ONLY workflow_participants
4259    ADD CONSTRAINT fk_rails_9bbe8f89cb FOREIGN KEY (workflow_id) REFERENCES workflows(id);
4260
4261
4262--
4263-- Name: fk_rails_a1320257b8; Type: FK CONSTRAINT; Schema: public; Owner: -
4264--
4265
4266ALTER TABLE ONLY inventories
4267    ADD CONSTRAINT fk_rails_a1320257b8 FOREIGN KEY (content_id) REFERENCES contents(id);
4268
4269
4270--
4271-- Name: fk_rails_a7be380d2d; Type: FK CONSTRAINT; Schema: public; Owner: -
4272--
4273
4274ALTER TABLE ONLY locations
4275    ADD CONSTRAINT fk_rails_a7be380d2d FOREIGN KEY (item_group_id) REFERENCES item_groups(id);
4276
4277
4278--
4279-- Name: fk_rails_bc37a5d38d; Type: FK CONSTRAINT; Schema: public; Owner: -
4280--
4281
4282ALTER TABLE ONLY accepted_inventory_types
4283    ADD CONSTRAINT fk_rails_bc37a5d38d FOREIGN KEY (inventory_type_id) REFERENCES inventory_types(id) ON DELETE CASCADE;
4284
4285
4286--
4287-- Name: fk_rails_c9d80342cf; Type: FK CONSTRAINT; Schema: public; Owner: -
4288--
4289
4290ALTER TABLE ONLY employees
4291    ADD CONSTRAINT fk_rails_c9d80342cf FOREIGN KEY (container_id) REFERENCES containers(id);
4292
4293
4294--
4295-- Name: fk_rails_d4dc4f70bd; Type: FK CONSTRAINT; Schema: public; Owner: -
4296--
4297
4298ALTER TABLE ONLY cycle_count_requests
4299    ADD CONSTRAINT fk_rails_d4dc4f70bd FOREIGN KEY (item_id) REFERENCES items(id);
4300
4301
4302--
4303-- Name: fk_rails_db13ac6174; Type: FK CONSTRAINT; Schema: public; Owner: -
4304--
4305
4306ALTER TABLE ONLY containers
4307    ADD CONSTRAINT fk_rails_db13ac6174 FOREIGN KEY (parent_id) REFERENCES containers(id);
4308
4309
4310--
4311-- Name: fk_rails_e3b7e2d285; Type: FK CONSTRAINT; Schema: public; Owner: -
4312--
4313
4314ALTER TABLE ONLY container_parent_change_logs
4315    ADD CONSTRAINT fk_rails_e3b7e2d285 FOREIGN KEY (new_parent_container_id) REFERENCES containers(id);
4316
4317
4318--
4319-- Name: fk_rails_ee0cff5d66; Type: FK CONSTRAINT; Schema: public; Owner: -
4320--
4321
4322ALTER TABLE ONLY location_sizes
4323    ADD CONSTRAINT fk_rails_ee0cff5d66 FOREIGN KEY (rack_type_id) REFERENCES rack_types(id);
4324
4325
4326--
4327-- Name: fk_rails_f0fceaba20; Type: FK CONSTRAINT; Schema: public; Owner: -
4328--
4329
4330ALTER TABLE ONLY ppm_portions
4331    ADD CONSTRAINT fk_rails_f0fceaba20 FOREIGN KEY (facility_id) REFERENCES facilities(id);
4332
4333
4334--
4335-- Name: fk_rails_f14889d5da; Type: FK CONSTRAINT; Schema: public; Owner: -
4336--
4337
4338ALTER TABLE ONLY purchase_order_inventory_creations
4339    ADD CONSTRAINT fk_rails_f14889d5da FOREIGN KEY (inventory_creation_id) REFERENCES inventory_activities(id);
4340
4341
4342--
4343-- Name: fk_rails_f563371c64; Type: FK CONSTRAINT; Schema: public; Owner: -
4344--
4345
4346ALTER TABLE ONLY inventories
4347    ADD CONSTRAINT fk_rails_f563371c64 FOREIGN KEY (location_id) REFERENCES locations(id);
4348
4349
4350--
4351-- Name: fk_rails_f919ce4afc; Type: FK CONSTRAINT; Schema: public; Owner: -
4352--
4353
4354ALTER TABLE ONLY locations
4355    ADD CONSTRAINT fk_rails_f919ce4afc FOREIGN KEY (area_id) REFERENCES areas(id);
4356
4357
4358--
4359-- Name: fk_rails_fc216669d8; Type: FK CONSTRAINT; Schema: public; Owner: -
4360--
4361
4362ALTER TABLE ONLY workflows
4363    ADD CONSTRAINT fk_rails_fc216669d8 FOREIGN KEY (facility_id) REFERENCES facilities(id);
4364
4365
4366--
4367-- Name: fk_rails_fe5eef0392; Type: FK CONSTRAINT; Schema: public; Owner: -
4368--
4369
4370ALTER TABLE ONLY areas
4371    ADD CONSTRAINT fk_rails_fe5eef0392 FOREIGN KEY (facility_id) REFERENCES facilities(id);
4372
4373
4374--
4375-- PostgreSQL database dump complete
4376--
4377
4378SET search_path TO "$user",public;
4379
4380INSERT INTO schema_migrations (version) VALUES ('20140721204043');
4381
4382INSERT INTO schema_migrations (version) VALUES ('20140721212019');
4383
4384INSERT INTO schema_migrations (version) VALUES ('20140721213723');
4385
4386INSERT INTO schema_migrations (version) VALUES ('20140721214531');
4387
4388INSERT INTO schema_migrations (version) VALUES ('20140721220900');
4389
4390INSERT INTO schema_migrations (version) VALUES ('20140721221740');
4391
4392INSERT INTO schema_migrations (version) VALUES ('20140721222120');
4393
4394INSERT INTO schema_migrations (version) VALUES ('20140721222617');
4395
4396INSERT INTO schema_migrations (version) VALUES ('20140723151943');
4397
4398INSERT INTO schema_migrations (version) VALUES ('20140806151202');
4399
4400INSERT INTO schema_migrations (version) VALUES ('20140806155005');
4401
4402INSERT INTO schema_migrations (version) VALUES ('20140806193704');
4403
4404INSERT INTO schema_migrations (version) VALUES ('20140807151850');
4405
4406INSERT INTO schema_migrations (version) VALUES ('20140813211017');
4407
4408INSERT INTO schema_migrations (version) VALUES ('20140813211018');
4409
4410INSERT INTO schema_migrations (version) VALUES ('20140813211019');
4411
4412INSERT INTO schema_migrations (version) VALUES ('20140813211344');
4413
4414INSERT INTO schema_migrations (version) VALUES ('20140813211416');
4415
4416INSERT INTO schema_migrations (version) VALUES ('20140813211422');
4417
4418INSERT INTO schema_migrations (version) VALUES ('20140813211426');
4419
4420INSERT INTO schema_migrations (version) VALUES ('20140813211446');
4421
4422INSERT INTO schema_migrations (version) VALUES ('20140814011632');
4423
4424INSERT INTO schema_migrations (version) VALUES ('20140814014306');
4425
4426INSERT INTO schema_migrations (version) VALUES ('20140814014307');
4427
4428INSERT INTO schema_migrations (version) VALUES ('20140814224653');
4429
4430INSERT INTO schema_migrations (version) VALUES ('20140814224654');
4431
4432INSERT INTO schema_migrations (version) VALUES ('20140816055502');
4433
4434INSERT INTO schema_migrations (version) VALUES ('20140818223258');
4435
4436INSERT INTO schema_migrations (version) VALUES ('20140818223727');
4437
4438INSERT INTO schema_migrations (version) VALUES ('20140818230007');
4439
4440INSERT INTO schema_migrations (version) VALUES ('20140820014524');
4441
4442INSERT INTO schema_migrations (version) VALUES ('20140820045928');
4443
4444INSERT INTO schema_migrations (version) VALUES ('20140820060918');
4445
4446INSERT INTO schema_migrations (version) VALUES ('20140820063052');
4447
4448INSERT INTO schema_migrations (version) VALUES ('20140820143816');
4449
4450INSERT INTO schema_migrations (version) VALUES ('20140820145519');
4451
4452INSERT INTO schema_migrations (version) VALUES ('20140825171232');
4453
4454INSERT INTO schema_migrations (version) VALUES ('20140825193330');
4455
4456INSERT INTO schema_migrations (version) VALUES ('20140828220324');
4457
4458INSERT INTO schema_migrations (version) VALUES ('20140828220355');
4459
4460INSERT INTO schema_migrations (version) VALUES ('20140903211338');
4461
4462INSERT INTO schema_migrations (version) VALUES ('20140903211858');
4463
4464INSERT INTO schema_migrations (version) VALUES ('20140903212400');
4465
4466INSERT INTO schema_migrations (version) VALUES ('20140903212435');
4467
4468INSERT INTO schema_migrations (version) VALUES ('20140903212451');
4469
4470INSERT INTO schema_migrations (version) VALUES ('20140903212732');
4471
4472INSERT INTO schema_migrations (version) VALUES ('20140904191620');
4473
4474INSERT INTO schema_migrations (version) VALUES ('20140904193319');
4475
4476INSERT INTO schema_migrations (version) VALUES ('20140904204205');
4477
4478INSERT INTO schema_migrations (version) VALUES ('20140904205037');
4479
4480INSERT INTO schema_migrations (version) VALUES ('20140905153932');
4481
4482INSERT INTO schema_migrations (version) VALUES ('20140905154013');
4483
4484INSERT INTO schema_migrations (version) VALUES ('20140905154039');
4485
4486INSERT INTO schema_migrations (version) VALUES ('20140905191018');
4487
4488INSERT INTO schema_migrations (version) VALUES ('20140905194619');
4489
4490INSERT INTO schema_migrations (version) VALUES ('20140908153141');
4491
4492INSERT INTO schema_migrations (version) VALUES ('20140908153200');
4493
4494INSERT INTO schema_migrations (version) VALUES ('20140908192357');
4495
4496INSERT INTO schema_migrations (version) VALUES ('20140909150321');
4497
4498INSERT INTO schema_migrations (version) VALUES ('20140909150516');
4499
4500INSERT INTO schema_migrations (version) VALUES ('20140909150616');
4501
4502INSERT INTO schema_migrations (version) VALUES ('20140909150652');
4503
4504INSERT INTO schema_migrations (version) VALUES ('20140909152917');
4505
4506INSERT INTO schema_migrations (version) VALUES ('20140909163401');
4507
4508INSERT INTO schema_migrations (version) VALUES ('20140909165009');
4509
4510INSERT INTO schema_migrations (version) VALUES ('20140909170728');
4511
4512INSERT INTO schema_migrations (version) VALUES ('20140909170916');
4513
4514INSERT INTO schema_migrations (version) VALUES ('20140909230953');
4515
4516INSERT INTO schema_migrations (version) VALUES ('20140910001555');
4517
4518INSERT INTO schema_migrations (version) VALUES ('20140910001835');
4519
4520INSERT INTO schema_migrations (version) VALUES ('20140910002759');
4521
4522INSERT INTO schema_migrations (version) VALUES ('20140910003032');
4523
4524INSERT INTO schema_migrations (version) VALUES ('20140910003409');
4525
4526INSERT INTO schema_migrations (version) VALUES ('20140910154130');
4527
4528INSERT INTO schema_migrations (version) VALUES ('20140910163404');
4529
4530INSERT INTO schema_migrations (version) VALUES ('20140910163850');
4531
4532INSERT INTO schema_migrations (version) VALUES ('20140910163917');
4533
4534INSERT INTO schema_migrations (version) VALUES ('20140911151422');
4535
4536INSERT INTO schema_migrations (version) VALUES ('20140911154723');
4537
4538INSERT INTO schema_migrations (version) VALUES ('20140911181748');
4539
4540INSERT INTO schema_migrations (version) VALUES ('20140911191525');
4541
4542INSERT INTO schema_migrations (version) VALUES ('20140911235822');
4543
4544INSERT INTO schema_migrations (version) VALUES ('20140913004959');
4545
4546INSERT INTO schema_migrations (version) VALUES ('20140916045135');
4547
4548INSERT INTO schema_migrations (version) VALUES ('20140916145521');
4549
4550INSERT INTO schema_migrations (version) VALUES ('20140916215347');
4551
4552INSERT INTO schema_migrations (version) VALUES ('20140916232219');
4553
4554INSERT INTO schema_migrations (version) VALUES ('20140917142503');
4555
4556INSERT INTO schema_migrations (version) VALUES ('20140917143726');
4557
4558INSERT INTO schema_migrations (version) VALUES ('20140917181105');
4559
4560INSERT INTO schema_migrations (version) VALUES ('20140917193455');
4561
4562INSERT INTO schema_migrations (version) VALUES ('20140917193826');
4563
4564INSERT INTO schema_migrations (version) VALUES ('20140918151844');
4565
4566INSERT INTO schema_migrations (version) VALUES ('20140918152403');
4567
4568INSERT INTO schema_migrations (version) VALUES ('20140918182044');
4569
4570INSERT INTO schema_migrations (version) VALUES ('20140918185311');
4571
4572INSERT INTO schema_migrations (version) VALUES ('20140918215400');
4573
4574INSERT INTO schema_migrations (version) VALUES ('20140920145124');
4575
4576INSERT INTO schema_migrations (version) VALUES ('20140924155321');
4577
4578INSERT INTO schema_migrations (version) VALUES ('20140924155405');
4579
4580INSERT INTO schema_migrations (version) VALUES ('20140924155425');
4581
4582INSERT INTO schema_migrations (version) VALUES ('20140924161605');
4583
4584INSERT INTO schema_migrations (version) VALUES ('20140924213723');
4585
4586INSERT INTO schema_migrations (version) VALUES ('20140924213849');
4587
4588INSERT INTO schema_migrations (version) VALUES ('20140924214213');
4589
4590INSERT INTO schema_migrations (version) VALUES ('20140925135156');
4591
4592INSERT INTO schema_migrations (version) VALUES ('20140925151833');
4593
4594INSERT INTO schema_migrations (version) VALUES ('20140925183822');
4595
4596INSERT INTO schema_migrations (version) VALUES ('20140925201037');
4597
4598INSERT INTO schema_migrations (version) VALUES ('20140926212541');
4599
4600INSERT INTO schema_migrations (version) VALUES ('20140926221119');
4601
4602INSERT INTO schema_migrations (version) VALUES ('20140926223232');
4603
4604INSERT INTO schema_migrations (version) VALUES ('20140928182751');
4605
4606INSERT INTO schema_migrations (version) VALUES ('20140928191422');
4607
4608INSERT INTO schema_migrations (version) VALUES ('20140929153053');
4609
4610INSERT INTO schema_migrations (version) VALUES ('20140929191422');
4611
4612INSERT INTO schema_migrations (version) VALUES ('20140929191423');
4613
4614INSERT INTO schema_migrations (version) VALUES ('20140929191428');
4615
4616INSERT INTO schema_migrations (version) VALUES ('20140929191550');
4617
4618INSERT INTO schema_migrations (version) VALUES ('20140930144213');
4619
4620INSERT INTO schema_migrations (version) VALUES ('20140930151455');
4621
4622INSERT INTO schema_migrations (version) VALUES ('20140930175801');
4623
4624INSERT INTO schema_migrations (version) VALUES ('20140930200246');
4625
4626INSERT INTO schema_migrations (version) VALUES ('20141001134633');
4627
4628INSERT INTO schema_migrations (version) VALUES ('20141001134643');
4629
4630INSERT INTO schema_migrations (version) VALUES ('20141001211257');
4631
4632INSERT INTO schema_migrations (version) VALUES ('20141001221218');
4633
4634INSERT INTO schema_migrations (version) VALUES ('20141003143521');
4635
4636INSERT INTO schema_migrations (version) VALUES ('20141003145640');
4637
4638INSERT INTO schema_migrations (version) VALUES ('20141007143845');
4639
4640INSERT INTO schema_migrations (version) VALUES ('20141007152531');
4641
4642INSERT INTO schema_migrations (version) VALUES ('20141007153920');
4643
4644INSERT INTO schema_migrations (version) VALUES ('20141007223051');
4645
4646INSERT INTO schema_migrations (version) VALUES ('20141008143956');
4647
4648INSERT INTO schema_migrations (version) VALUES ('20141008150055');
4649
4650INSERT INTO schema_migrations (version) VALUES ('20141008160904');
4651
4652INSERT INTO schema_migrations (version) VALUES ('20141008223730');
4653
4654INSERT INTO schema_migrations (version) VALUES ('20141008233716');
4655
4656INSERT INTO schema_migrations (version) VALUES ('20141009154956');
4657
4658INSERT INTO schema_migrations (version) VALUES ('20141009171348');
4659
4660INSERT INTO schema_migrations (version) VALUES ('20141010172617');
4661
4662INSERT INTO schema_migrations (version) VALUES ('20141010180917');
4663
4664INSERT INTO schema_migrations (version) VALUES ('20141013152907');
4665
4666INSERT INTO schema_migrations (version) VALUES ('20141013183558');
4667
4668INSERT INTO schema_migrations (version) VALUES ('20141014020234');
4669
4670INSERT INTO schema_migrations (version) VALUES ('20141014193443');
4671
4672INSERT INTO schema_migrations (version) VALUES ('20141014202501');
4673
4674INSERT INTO schema_migrations (version) VALUES ('20141014202730');
4675
4676INSERT INTO schema_migrations (version) VALUES ('20141021195908');
4677
4678INSERT INTO schema_migrations (version) VALUES ('20141022180905');
4679
4680INSERT INTO schema_migrations (version) VALUES ('20141022205348');
4681
4682INSERT INTO schema_migrations (version) VALUES ('20141023202418');
4683
4684INSERT INTO schema_migrations (version) VALUES ('20141023212528');
4685
4686INSERT INTO schema_migrations (version) VALUES ('20141024151020');
4687
4688INSERT INTO schema_migrations (version) VALUES ('20141024201254');
4689
4690INSERT INTO schema_migrations (version) VALUES ('20141104174311');
4691
4692INSERT INTO schema_migrations (version) VALUES ('20141105180305');
4693
4694INSERT INTO schema_migrations (version) VALUES ('20141105183802');
4695
4696INSERT INTO schema_migrations (version) VALUES ('20141105223115');
4697
4698INSERT INTO schema_migrations (version) VALUES ('20141105223140');
4699
4700INSERT INTO schema_migrations (version) VALUES ('20141106195750');
4701
4702INSERT INTO schema_migrations (version) VALUES ('20141106220223');
4703
4704INSERT INTO schema_migrations (version) VALUES ('20141111231743');
4705
4706INSERT INTO schema_migrations (version) VALUES ('20141114205002');
4707
4708INSERT INTO schema_migrations (version) VALUES ('20141117192817');
4709
4710INSERT INTO schema_migrations (version) VALUES ('20141120201459');
4711
4712INSERT INTO schema_migrations (version) VALUES ('20141120202203');
4713
4714INSERT INTO schema_migrations (version) VALUES ('20141120220044');
4715
4716INSERT INTO schema_migrations (version) VALUES ('20141124200012');
4717
4718INSERT INTO schema_migrations (version) VALUES ('20141124230100');
4719
4720INSERT INTO schema_migrations (version) VALUES ('20141125170809');
4721
4722INSERT INTO schema_migrations (version) VALUES ('20141125180935');
4723
4724INSERT INTO schema_migrations (version) VALUES ('20141125182829');
4725
4726INSERT INTO schema_migrations (version) VALUES ('20141201162843');
4727
4728INSERT INTO schema_migrations (version) VALUES ('20141201205400');
4729
4730INSERT INTO schema_migrations (version) VALUES ('20141202210545');
4731
4732INSERT INTO schema_migrations (version) VALUES ('20141204192330');
4733
4734INSERT INTO schema_migrations (version) VALUES ('20141205155834');
4735
4736INSERT INTO schema_migrations (version) VALUES ('20141208221626');
4737
4738INSERT INTO schema_migrations (version) VALUES ('20141209205015');
4739
4740INSERT INTO schema_migrations (version) VALUES ('20141210221158');
4741
4742INSERT INTO schema_migrations (version) VALUES ('20141210225135');
4743
4744INSERT INTO schema_migrations (version) VALUES ('20141212194529');
4745
4746INSERT INTO schema_migrations (version) VALUES ('20141212220706');
4747
4748INSERT INTO schema_migrations (version) VALUES ('20141215182442');
4749
4750INSERT INTO schema_migrations (version) VALUES ('20141216035920');
4751
4752INSERT INTO schema_migrations (version) VALUES ('20141216040909');
4753
4754INSERT INTO schema_migrations (version) VALUES ('20141216041825');
4755
4756INSERT INTO schema_migrations (version) VALUES ('20141216042531');
4757
4758INSERT INTO schema_migrations (version) VALUES ('20141216043303');
4759
4760INSERT INTO schema_migrations (version) VALUES ('20141216043905');
4761
4762INSERT INTO schema_migrations (version) VALUES ('20141216044602');
4763
4764INSERT INTO schema_migrations (version) VALUES ('20141217055953');
4765
4766INSERT INTO schema_migrations (version) VALUES ('20141218162212');
4767
4768INSERT INTO schema_migrations (version) VALUES ('20141218162240');
4769
4770INSERT INTO schema_migrations (version) VALUES ('20141219192733');
4771
4772INSERT INTO schema_migrations (version) VALUES ('20141230185809');
4773
4774INSERT INTO schema_migrations (version) VALUES ('20141230195300');
4775
4776INSERT INTO schema_migrations (version) VALUES ('20150104042147');
4777
4778INSERT INTO schema_migrations (version) VALUES ('20150107161053');
4779
4780INSERT INTO schema_migrations (version) VALUES ('20150108140010');
4781
4782INSERT INTO schema_migrations (version) VALUES ('20150108224505');
4783
4784INSERT INTO schema_migrations (version) VALUES ('20150109175101');
4785
4786INSERT INTO schema_migrations (version) VALUES ('20150113160243');
4787
4788INSERT INTO schema_migrations (version) VALUES ('20150113161314');
4789
4790INSERT INTO schema_migrations (version) VALUES ('20150113161453');
4791
4792INSERT INTO schema_migrations (version) VALUES ('20150122171632');
4793
4794INSERT INTO schema_migrations (version) VALUES ('20150122179000');
4795
4796INSERT INTO schema_migrations (version) VALUES ('20150123220218');
4797
4798INSERT INTO schema_migrations (version) VALUES ('20150128200635');
4799
4800INSERT INTO schema_migrations (version) VALUES ('20150128200636');
4801
4802INSERT INTO schema_migrations (version) VALUES ('20150128222318');
4803
4804INSERT INTO schema_migrations (version) VALUES ('20150129164809');
4805
4806INSERT INTO schema_migrations (version) VALUES ('20150129165008');
4807
4808INSERT INTO schema_migrations (version) VALUES ('20150203200534');
4809
4810INSERT INTO schema_migrations (version) VALUES ('20150203210700');
4811
4812INSERT INTO schema_migrations (version) VALUES ('20150203235843');
4813
4814INSERT INTO schema_migrations (version) VALUES ('20150204160809');
4815
4816INSERT INTO schema_migrations (version) VALUES ('20150204162259');
4817
4818INSERT INTO schema_migrations (version) VALUES ('20150204170657');
4819
4820INSERT INTO schema_migrations (version) VALUES ('20150206190406');
4821
4822INSERT INTO schema_migrations (version) VALUES ('20150209135008');
4823
4824INSERT INTO schema_migrations (version) VALUES ('20150210025321');
4825
4826INSERT INTO schema_migrations (version) VALUES ('20150210162122');
4827
4828INSERT INTO schema_migrations (version) VALUES ('20150210162443');
4829
4830INSERT INTO schema_migrations (version) VALUES ('20150210214046');
4831
4832INSERT INTO schema_migrations (version) VALUES ('20150211045247');
4833
4834INSERT INTO schema_migrations (version) VALUES ('20150211045852');
4835
4836INSERT INTO schema_migrations (version) VALUES ('20150211223503');
4837
4838INSERT INTO schema_migrations (version) VALUES ('20150212002014');
4839
4840INSERT INTO schema_migrations (version) VALUES ('20150212161243');
4841
4842INSERT INTO schema_migrations (version) VALUES ('20150212183204');
4843
4844INSERT INTO schema_migrations (version) VALUES ('20150212183234');
4845
4846INSERT INTO schema_migrations (version) VALUES ('20150212183257');
4847
4848INSERT INTO schema_migrations (version) VALUES ('20150213152237');
4849
4850INSERT INTO schema_migrations (version) VALUES ('20150213172312');
4851
4852INSERT INTO schema_migrations (version) VALUES ('20150213211851');
4853
4854INSERT INTO schema_migrations (version) VALUES ('20150213212014');
4855
4856INSERT INTO schema_migrations (version) VALUES ('20150214025017');
4857
4858INSERT INTO schema_migrations (version) VALUES ('20150216154824');
4859
4860INSERT INTO schema_migrations (version) VALUES ('20150217052844');
4861
4862INSERT INTO schema_migrations (version) VALUES ('20150218204743');
4863
4864INSERT INTO schema_migrations (version) VALUES ('20150218213020');
4865
4866INSERT INTO schema_migrations (version) VALUES ('20150219163108');
4867
4868INSERT INTO schema_migrations (version) VALUES ('20150220220640');
4869
4870INSERT INTO schema_migrations (version) VALUES ('20150223194729');
4871
4872INSERT INTO schema_migrations (version) VALUES ('20150223200616');
4873
4874INSERT INTO schema_migrations (version) VALUES ('20150223204218');
4875
4876INSERT INTO schema_migrations (version) VALUES ('20150224200121');
4877
4878INSERT INTO schema_migrations (version) VALUES ('20150227181017');
4879
4880INSERT INTO schema_migrations (version) VALUES ('20150227224335');
4881
4882INSERT INTO schema_migrations (version) VALUES ('20150228184805');
4883
4884INSERT INTO schema_migrations (version) VALUES ('20150302222515');
4885
4886INSERT INTO schema_migrations (version) VALUES ('20150302222542');
4887
4888INSERT INTO schema_migrations (version) VALUES ('20150303141927');
4889
4890INSERT INTO schema_migrations (version) VALUES ('20150304205243');
4891
4892INSERT INTO schema_migrations (version) VALUES ('20150304205812');
4893
4894INSERT INTO schema_migrations (version) VALUES ('20150305035518');
4895
4896INSERT INTO schema_migrations (version) VALUES ('20150305043352');
4897
4898INSERT INTO schema_migrations (version) VALUES ('20150305163514');
4899
4900INSERT INTO schema_migrations (version) VALUES ('20150305164100');
4901
4902INSERT INTO schema_migrations (version) VALUES ('20150305170011');
4903
4904INSERT INTO schema_migrations (version) VALUES ('20150306142527');
4905
4906INSERT INTO schema_migrations (version) VALUES ('20150309183546');
4907
4908INSERT INTO schema_migrations (version) VALUES ('20150310151402');
4909
4910INSERT INTO schema_migrations (version) VALUES ('20150310215218');
4911
4912INSERT INTO schema_migrations (version) VALUES ('20150312030204');
4913
4914INSERT INTO schema_migrations (version) VALUES ('20150312035920');
4915
4916INSERT INTO schema_migrations (version) VALUES ('20150312044339');
4917
4918INSERT INTO schema_migrations (version) VALUES ('20150312044340');
4919
4920INSERT INTO schema_migrations (version) VALUES ('20150313125015');
4921
4922INSERT INTO schema_migrations (version) VALUES ('20150313132647');
4923
4924INSERT INTO schema_migrations (version) VALUES ('20150313180730');
4925
4926INSERT INTO schema_migrations (version) VALUES ('20150313182203');
4927
4928INSERT INTO schema_migrations (version) VALUES ('20150313182241');
4929
4930INSERT INTO schema_migrations (version) VALUES ('20150313182258');
4931
4932INSERT INTO schema_migrations (version) VALUES ('20150313211934');
4933
4934INSERT INTO schema_migrations (version) VALUES ('20150313211957');
4935
4936INSERT INTO schema_migrations (version) VALUES ('20150317190423');
4937
4938INSERT INTO schema_migrations (version) VALUES ('20150320230854');
4939
4940INSERT INTO schema_migrations (version) VALUES ('20150326161944');
4941
4942INSERT INTO schema_migrations (version) VALUES ('20150330142002');
4943
4944INSERT INTO schema_migrations (version) VALUES ('20150330205753');
4945
4946INSERT INTO schema_migrations (version) VALUES ('20150330205903');
4947
4948INSERT INTO schema_migrations (version) VALUES ('20150330211819');
4949
4950INSERT INTO schema_migrations (version) VALUES ('20150331143738');
4951
4952INSERT INTO schema_migrations (version) VALUES ('20150401140926');
4953
4954INSERT INTO schema_migrations (version) VALUES ('20150401193113');
4955
4956INSERT INTO schema_migrations (version) VALUES ('20150401215352');
4957
4958INSERT INTO schema_migrations (version) VALUES ('20150404022705');
4959
4960INSERT INTO schema_migrations (version) VALUES ('20150406195908');
4961
4962INSERT INTO schema_migrations (version) VALUES ('20150408175214');
4963
4964INSERT INTO schema_migrations (version) VALUES ('20150408203645');
4965
4966INSERT INTO schema_migrations (version) VALUES ('20150413153311');
4967
4968INSERT INTO schema_migrations (version) VALUES ('20150413153655');
4969
4970INSERT INTO schema_migrations (version) VALUES ('20150415154555');
4971
4972INSERT INTO schema_migrations (version) VALUES ('20150416205517');
4973
4974INSERT INTO schema_migrations (version) VALUES ('20150416210839');
4975
4976INSERT INTO schema_migrations (version) VALUES ('20150417213646');
4977
4978INSERT INTO schema_migrations (version) VALUES ('20150422173107');
4979
4980INSERT INTO schema_migrations (version) VALUES ('20150423153237');
4981
4982INSERT INTO schema_migrations (version) VALUES ('20150424190306');
4983
4984INSERT INTO schema_migrations (version) VALUES ('20150424190307');
4985
4986INSERT INTO schema_migrations (version) VALUES ('20150427151938');
4987
4988INSERT INTO schema_migrations (version) VALUES ('20150430152012');
4989
4990INSERT INTO schema_migrations (version) VALUES ('20150505160658');
4991
4992INSERT INTO schema_migrations (version) VALUES ('20150506175959');
4993
4994INSERT INTO schema_migrations (version) VALUES ('20150507161134');
4995
4996INSERT INTO schema_migrations (version) VALUES ('20150507165013');
4997
4998INSERT INTO schema_migrations (version) VALUES ('20150508194043');
4999
5000INSERT INTO schema_migrations (version) VALUES ('20150509234530');
5001
5002INSERT INTO schema_migrations (version) VALUES ('20150511142721');
5003
5004INSERT INTO schema_migrations (version) VALUES ('20150511142737');
5005
5006INSERT INTO schema_migrations (version) VALUES ('20150511160014');
5007
5008INSERT INTO schema_migrations (version) VALUES ('20150512031815');
5009
5010INSERT INTO schema_migrations (version) VALUES ('20150512050825');
5011
5012INSERT INTO schema_migrations (version) VALUES ('20150512151712');
5013
5014INSERT INTO schema_migrations (version) VALUES ('20150512202112');
5015
5016INSERT INTO schema_migrations (version) VALUES ('20150512202513');
5017
5018INSERT INTO schema_migrations (version) VALUES ('20150513143407');
5019
5020INSERT INTO schema_migrations (version) VALUES ('20150514200458');
5021
5022INSERT INTO schema_migrations (version) VALUES ('20150515141802');
5023
5024INSERT INTO schema_migrations (version) VALUES ('20150518212056');
5025
5026INSERT INTO schema_migrations (version) VALUES ('20150519202209');
5027
5028INSERT INTO schema_migrations (version) VALUES ('20150521213627');
5029
5030INSERT INTO schema_migrations (version) VALUES ('20150521213628');
5031
5032INSERT INTO schema_migrations (version) VALUES ('20150522145045');
5033
5034INSERT INTO schema_migrations (version) VALUES ('20150522145511');
5035
5036INSERT INTO schema_migrations (version) VALUES ('20150527203604');
5037
5038INSERT INTO schema_migrations (version) VALUES ('20150529211107');
5039
5040INSERT INTO schema_migrations (version) VALUES ('20150529211108');
5041
5042INSERT INTO schema_migrations (version) VALUES ('20150529220436');
5043
5044INSERT INTO schema_migrations (version) VALUES ('20150530033536');
5045
5046INSERT INTO schema_migrations (version) VALUES ('20150603144022');
5047
5048INSERT INTO schema_migrations (version) VALUES ('20150604202739');
5049
5050INSERT INTO schema_migrations (version) VALUES ('20150609151628');
5051
5052INSERT INTO schema_migrations (version) VALUES ('20150609215545');
5053
5054INSERT INTO schema_migrations (version) VALUES ('20150611202810');
5055
5056INSERT INTO schema_migrations (version) VALUES ('20150612160634');
5057
5058INSERT INTO schema_migrations (version) VALUES ('20150616200524');
5059
5060INSERT INTO schema_migrations (version) VALUES ('20150616200636');
5061
5062INSERT INTO schema_migrations (version) VALUES ('20150617203152');
5063
5064INSERT INTO schema_migrations (version) VALUES ('20150617203153');
5065
5066INSERT INTO schema_migrations (version) VALUES ('20150617221003');
5067
5068INSERT INTO schema_migrations (version) VALUES ('20150618192144');
5069
5070INSERT INTO schema_migrations (version) VALUES ('20150619192733');
5071
5072INSERT INTO schema_migrations (version) VALUES ('20150619205717');
5073
5074INSERT INTO schema_migrations (version) VALUES ('20150619223631');
5075
5076INSERT INTO schema_migrations (version) VALUES ('20150622195426');
5077
5078INSERT INTO schema_migrations (version) VALUES ('20150622195817');
5079
5080INSERT INTO schema_migrations (version) VALUES ('20150623192051');
5081
5082INSERT INTO schema_migrations (version) VALUES ('20150625144343');
5083
5084INSERT INTO schema_migrations (version) VALUES ('20150626170625');
5085
5086INSERT INTO schema_migrations (version) VALUES ('20150629212533');
5087
5088INSERT INTO schema_migrations (version) VALUES ('20150629212642');
5089
5090INSERT INTO schema_migrations (version) VALUES ('20150630221014');
5091
5092INSERT INTO schema_migrations (version) VALUES ('20150701181844');
5093
5094INSERT INTO schema_migrations (version) VALUES ('20150702151147');
5095
5096INSERT INTO schema_migrations (version) VALUES ('20150702173814');
5097
5098INSERT INTO schema_migrations (version) VALUES ('20150702223050');
5099
5100INSERT INTO schema_migrations (version) VALUES ('20150704003547');
5101
5102INSERT INTO schema_migrations (version) VALUES ('20150707150728');
5103
5104INSERT INTO schema_migrations (version) VALUES ('20150707182746');
5105
5106INSERT INTO schema_migrations (version) VALUES ('20150707194125');
5107
5108INSERT INTO schema_migrations (version) VALUES ('20150707205037');
5109
5110INSERT INTO schema_migrations (version) VALUES ('20150707205736');
5111
5112INSERT INTO schema_migrations (version) VALUES ('20150708185424');
5113
5114INSERT INTO schema_migrations (version) VALUES ('20150708185623');
5115
5116INSERT INTO schema_migrations (version) VALUES ('20150710154040');
5117
5118INSERT INTO schema_migrations (version) VALUES ('20150713023048');
5119
5120INSERT INTO schema_migrations (version) VALUES ('20150713125116');
5121
5122INSERT INTO schema_migrations (version) VALUES ('20150713180028');
5123
5124INSERT INTO schema_migrations (version) VALUES ('20150713185555');
5125
5126INSERT INTO schema_migrations (version) VALUES ('20150713194016');
5127
5128INSERT INTO schema_migrations (version) VALUES ('20150714162544');
5129
5130INSERT INTO schema_migrations (version) VALUES ('20150714180357');
5131
5132INSERT INTO schema_migrations (version) VALUES ('20150715140434');
5133
5134INSERT INTO schema_migrations (version) VALUES ('20150715145645');
5135
5136INSERT INTO schema_migrations (version) VALUES ('20150715162001');
5137
5138INSERT INTO schema_migrations (version) VALUES ('20150715170428');
5139
5140INSERT INTO schema_migrations (version) VALUES ('20150715172625');
5141
5142INSERT INTO schema_migrations (version) VALUES ('20150715200632');
5143
5144INSERT INTO schema_migrations (version) VALUES ('20150716163044');
5145
5146INSERT INTO schema_migrations (version) VALUES ('20150716225630');
5147
5148INSERT INTO schema_migrations (version) VALUES ('20150717125623');
5149
5150INSERT INTO schema_migrations (version) VALUES ('20150718000954');
5151
5152INSERT INTO schema_migrations (version) VALUES ('20150727144720');
5153
5154INSERT INTO schema_migrations (version) VALUES ('20150727144919');
5155
5156INSERT INTO schema_migrations (version) VALUES ('20150727145140');
5157
5158INSERT INTO schema_migrations (version) VALUES ('20150730152916');
5159
5160INSERT INTO schema_migrations (version) VALUES ('20150730153743');
5161
5162INSERT INTO schema_migrations (version) VALUES ('20150731152910');
5163
5164INSERT INTO schema_migrations (version) VALUES ('20150803195523');
5165
5166INSERT INTO schema_migrations (version) VALUES ('20150803195728');
5167
5168INSERT INTO schema_migrations (version) VALUES ('20150810192402');
5169
5170INSERT INTO schema_migrations (version) VALUES ('20150811191912');
5171
5172INSERT INTO schema_migrations (version) VALUES ('20150814172637');
5173
5174INSERT INTO schema_migrations (version) VALUES ('20150817151610');
5175
5176INSERT INTO schema_migrations (version) VALUES ('20150817170741');
5177
5178INSERT INTO schema_migrations (version) VALUES ('20150817205732');
5179
5180INSERT INTO schema_migrations (version) VALUES ('20150818135821');
5181
5182INSERT INTO schema_migrations (version) VALUES ('20150818144001');
5183
5184INSERT INTO schema_migrations (version) VALUES ('20150820160403');
5185
5186INSERT INTO schema_migrations (version) VALUES ('20150820165748');
5187
5188INSERT INTO schema_migrations (version) VALUES ('20150820175029');
5189
5190INSERT INTO schema_migrations (version) VALUES ('20150821153412');
5191
5192INSERT INTO schema_migrations (version) VALUES ('20150821160921');
5193
5194INSERT INTO schema_migrations (version) VALUES ('20150821163225');
5195
5196INSERT INTO schema_migrations (version) VALUES ('20150821180547');
5197
5198INSERT INTO schema_migrations (version) VALUES ('20150821214443');
5199
5200INSERT INTO schema_migrations (version) VALUES ('20150827145935');
5201
5202INSERT INTO schema_migrations (version) VALUES ('20150827161604');
5203
5204INSERT INTO schema_migrations (version) VALUES ('20150827185104');
5205
5206INSERT INTO schema_migrations (version) VALUES ('20150828174905');
5207
5208INSERT INTO schema_migrations (version) VALUES ('20150904142353');
5209
5210INSERT INTO schema_migrations (version) VALUES ('20150904142633');
5211
5212INSERT INTO schema_migrations (version) VALUES ('20150904201727');
5213
5214INSERT INTO schema_migrations (version) VALUES ('20150909195015');
5215
5216INSERT INTO schema_migrations (version) VALUES ('20150910144228');
5217
5218INSERT INTO schema_migrations (version) VALUES ('20150910144950');
5219
5220INSERT INTO schema_migrations (version) VALUES ('20150910152334');
5221
5222INSERT INTO schema_migrations (version) VALUES ('20150910183531');
5223
5224INSERT INTO schema_migrations (version) VALUES ('20150910184059');
5225
5226INSERT INTO schema_migrations (version) VALUES ('20150910184100');
5227
5228INSERT INTO schema_migrations (version) VALUES ('20150910214225');
5229
5230INSERT INTO schema_migrations (version) VALUES ('20150911173249');
5231
5232INSERT INTO schema_migrations (version) VALUES ('20150916171400');
5233
5234INSERT INTO schema_migrations (version) VALUES ('20150916205101');
5235
5236INSERT INTO schema_migrations (version) VALUES ('20150917192404');
5237
5238INSERT INTO schema_migrations (version) VALUES ('20150917192932');
5239
5240INSERT INTO schema_migrations (version) VALUES ('20150918030425');
5241
5242INSERT INTO schema_migrations (version) VALUES ('20150918031024');
5243
5244INSERT INTO schema_migrations (version) VALUES ('20150918031335');
5245
5246INSERT INTO schema_migrations (version) VALUES ('20150918031852');
5247
5248INSERT INTO schema_migrations (version) VALUES ('20150918032215');
5249
5250INSERT INTO schema_migrations (version) VALUES ('20150918032451');
5251
5252INSERT INTO schema_migrations (version) VALUES ('20150918144629');
5253
5254INSERT INTO schema_migrations (version) VALUES ('20150918163323');
5255
5256INSERT INTO schema_migrations (version) VALUES ('20150918185522');
5257
5258INSERT INTO schema_migrations (version) VALUES ('20150918212014');
5259
5260INSERT INTO schema_migrations (version) VALUES ('20150921185520');
5261
5262INSERT INTO schema_migrations (version) VALUES ('20150921185521');
5263
5264INSERT INTO schema_migrations (version) VALUES ('20150921185522');
5265
5266INSERT INTO schema_migrations (version) VALUES ('20150922204351');
5267
5268INSERT INTO schema_migrations (version) VALUES ('20150923161320');
5269
5270INSERT INTO schema_migrations (version) VALUES ('20150923214208');
5271
5272INSERT INTO schema_migrations (version) VALUES ('20150925174813');
5273
5274INSERT INTO schema_migrations (version) VALUES ('20150925193834');
5275
5276INSERT INTO schema_migrations (version) VALUES ('20150930184006');
5277
5278INSERT INTO schema_migrations (version) VALUES ('20150930190951');
5279
5280INSERT INTO schema_migrations (version) VALUES ('20151001174519');
5281
5282INSERT INTO schema_migrations (version) VALUES ('20151002150830');
5283
5284INSERT INTO schema_migrations (version) VALUES ('20151006144439');
5285
5286INSERT INTO schema_migrations (version) VALUES ('20151006150222');
5287
5288INSERT INTO schema_migrations (version) VALUES ('20151006152016');
5289
5290INSERT INTO schema_migrations (version) VALUES ('20151006152244');
5291
5292INSERT INTO schema_migrations (version) VALUES ('20151006152936');
5293
5294INSERT INTO schema_migrations (version) VALUES ('20151006171428');
5295
5296INSERT INTO schema_migrations (version) VALUES ('20151006200647');
5297
5298INSERT INTO schema_migrations (version) VALUES ('20151006202023');
5299
5300INSERT INTO schema_migrations (version) VALUES ('20151006210620');
5301
5302INSERT INTO schema_migrations (version) VALUES ('20151007172431');
5303
5304INSERT INTO schema_migrations (version) VALUES ('20151007211418');
5305
5306INSERT INTO schema_migrations (version) VALUES ('20151009175207');
5307
5308INSERT INTO schema_migrations (version) VALUES ('20151013142048');
5309
5310INSERT INTO schema_migrations (version) VALUES ('20151013171307');
5311
5312INSERT INTO schema_migrations (version) VALUES ('20151013202710');
5313
5314INSERT INTO schema_migrations (version) VALUES ('20151014021358');
5315
5316INSERT INTO schema_migrations (version) VALUES ('20151014120823');
5317
5318INSERT INTO schema_migrations (version) VALUES ('20151014184652');
5319
5320INSERT INTO schema_migrations (version) VALUES ('20151016160114');
5321
5322INSERT INTO schema_migrations (version) VALUES ('20151016160546');
5323
5324INSERT INTO schema_migrations (version) VALUES ('20151016161543');
5325
5326INSERT INTO schema_migrations (version) VALUES ('20151016170944');
5327
5328INSERT INTO schema_migrations (version) VALUES ('20151016180217');
5329
5330INSERT INTO schema_migrations (version) VALUES ('20151016203430');
5331
5332INSERT INTO schema_migrations (version) VALUES ('20151019173600');
5333
5334INSERT INTO schema_migrations (version) VALUES ('20151020165122');
5335
5336INSERT INTO schema_migrations (version) VALUES ('20151020190750');
5337
5338INSERT INTO schema_migrations (version) VALUES ('20151021172843');
5339
5340INSERT INTO schema_migrations (version) VALUES ('20151022145839');
5341
5342INSERT INTO schema_migrations (version) VALUES ('20151022151609');
5343
5344INSERT INTO schema_migrations (version) VALUES ('20151023161635');
5345
5346INSERT INTO schema_migrations (version) VALUES ('20151023172157');
5347
5348INSERT INTO schema_migrations (version) VALUES ('20151023212250');
5349
5350INSERT INTO schema_migrations (version) VALUES ('20151024190447');
5351
5352INSERT INTO schema_migrations (version) VALUES ('20151025224142');
5353
5354INSERT INTO schema_migrations (version) VALUES ('20151026213048');
5355
5356INSERT INTO schema_migrations (version) VALUES ('20151026213241');
5357
5358INSERT INTO schema_migrations (version) VALUES ('20151027175903');
5359
5360INSERT INTO schema_migrations (version) VALUES ('20151029155718');
5361
5362INSERT INTO schema_migrations (version) VALUES ('20151103160856');
5363
5364INSERT INTO schema_migrations (version) VALUES ('20151103205156');
5365
5366INSERT INTO schema_migrations (version) VALUES ('20151105222520');
5367
5368INSERT INTO schema_migrations (version) VALUES ('20151106182109');
5369
5370INSERT INTO schema_migrations (version) VALUES ('20151109153234');
5371
5372INSERT INTO schema_migrations (version) VALUES ('20151109153533');
5373
5374INSERT INTO schema_migrations (version) VALUES ('20151109194757');
5375
5376INSERT INTO schema_migrations (version) VALUES ('20151109195032');
5377
5378INSERT INTO schema_migrations (version) VALUES ('20151109230000');
5379
5380INSERT INTO schema_migrations (version) VALUES ('20151113034210');
5381
5382INSERT INTO schema_migrations (version) VALUES ('20151116160924');
5383
5384INSERT INTO schema_migrations (version) VALUES ('20151116192433');
5385
5386INSERT INTO schema_migrations (version) VALUES ('20151116193647');
5387
5388INSERT INTO schema_migrations (version) VALUES ('20151116224012');
5389
5390INSERT INTO schema_migrations (version) VALUES ('20151116224013');
5391
5392INSERT INTO schema_migrations (version) VALUES ('20151120181529');
5393
5394INSERT INTO schema_migrations (version) VALUES ('20151120195550');
5395
5396INSERT INTO schema_migrations (version) VALUES ('20151123185617');
5397
5398INSERT INTO schema_migrations (version) VALUES ('20151123204357');
5399
5400INSERT INTO schema_migrations (version) VALUES ('20151124172309');
5401
5402INSERT INTO schema_migrations (version) VALUES ('20151201171454');
5403
5404INSERT INTO schema_migrations (version) VALUES ('20151203155439');
5405
5406INSERT INTO schema_migrations (version) VALUES ('20151203185425');
5407
5408INSERT INTO schema_migrations (version) VALUES ('20151204170840');
5409
5410INSERT INTO schema_migrations (version) VALUES ('20151204170849');
5411
5412INSERT INTO schema_migrations (version) VALUES ('20151204172801');
5413
5414INSERT INTO schema_migrations (version) VALUES ('20151204173035');
5415
5416INSERT INTO schema_migrations (version) VALUES ('20151204173320');
5417
5418INSERT INTO schema_migrations (version) VALUES ('20151207195641');
5419
5420INSERT INTO schema_migrations (version) VALUES ('20151208011832');
5421
5422INSERT INTO schema_migrations (version) VALUES ('20151209161159');
5423
5424INSERT INTO schema_migrations (version) VALUES ('20151211155438');
5425
5426INSERT INTO schema_migrations (version) VALUES ('20151211160357');
5427
5428INSERT INTO schema_migrations (version) VALUES ('20151211212801');
5429
5430INSERT INTO schema_migrations (version) VALUES ('20151211225158');
5431
5432INSERT INTO schema_migrations (version) VALUES ('20151215011832');
5433
5434INSERT INTO schema_migrations (version) VALUES ('20151215161415');
5435
5436INSERT INTO schema_migrations (version) VALUES ('20151216161018');
5437
5438INSERT INTO schema_migrations (version) VALUES ('20151216170058');
5439
5440INSERT INTO schema_migrations (version) VALUES ('20151217173921');
5441
5442INSERT INTO schema_migrations (version) VALUES ('20151217181146');
5443
5444INSERT INTO schema_migrations (version) VALUES ('20151217223441');
5445
5446INSERT INTO schema_migrations (version) VALUES ('20151218184814');
5447
5448INSERT INTO schema_migrations (version) VALUES ('20151219031213');
5449
5450INSERT INTO schema_migrations (version) VALUES ('20151221211845');
5451
5452INSERT INTO schema_migrations (version) VALUES ('20151221223709');
5453
5454INSERT INTO schema_migrations (version) VALUES ('20151221223830');
5455
5456INSERT INTO schema_migrations (version) VALUES ('20151222152544');
5457
5458INSERT INTO schema_migrations (version) VALUES ('20151222174911');
5459
5460INSERT INTO schema_migrations (version) VALUES ('20151223191418');
5461
5462INSERT INTO schema_migrations (version) VALUES ('20151228162853');
5463
5464INSERT INTO schema_migrations (version) VALUES ('20151228164743');
5465
5466INSERT INTO schema_migrations (version) VALUES ('20151229193419');
5467
5468INSERT INTO schema_migrations (version) VALUES ('20160106143109');
5469
5470INSERT INTO schema_migrations (version) VALUES ('20160106180000');
5471
5472INSERT INTO schema_migrations (version) VALUES ('20160106211101');
5473
5474INSERT INTO schema_migrations (version) VALUES ('20160107162134');
5475
5476INSERT INTO schema_migrations (version) VALUES ('20160107173904');
5477
5478INSERT INTO schema_migrations (version) VALUES ('20160107213737');
5479
5480INSERT INTO schema_migrations (version) VALUES ('20160108153610');
5481
5482INSERT INTO schema_migrations (version) VALUES ('20160111160518');
5483
5484INSERT INTO schema_migrations (version) VALUES ('20160111181907');
5485
5486INSERT INTO schema_migrations (version) VALUES ('20160111230520');
5487
5488INSERT INTO schema_migrations (version) VALUES ('20160111230608');
5489
5490INSERT INTO schema_migrations (version) VALUES ('20160111231500');
5491
5492INSERT INTO schema_migrations (version) VALUES ('20160113185054');
5493
5494INSERT INTO schema_migrations (version) VALUES ('20160114032356');
5495
5496INSERT INTO schema_migrations (version) VALUES ('20160114134345');
5497
5498INSERT INTO schema_migrations (version) VALUES ('20160114134440');
5499
5500INSERT INTO schema_migrations (version) VALUES ('20160114170233');
5501
5502INSERT INTO schema_migrations (version) VALUES ('20160114200037');
5503
5504INSERT INTO schema_migrations (version) VALUES ('20160115164510');
5505
5506INSERT INTO schema_migrations (version) VALUES ('20160115223057');
5507
5508INSERT INTO schema_migrations (version) VALUES ('20160118153418');
5509
5510INSERT INTO schema_migrations (version) VALUES ('20160118194912');
5511
5512INSERT INTO schema_migrations (version) VALUES ('20160121214536');
5513
5514INSERT INTO schema_migrations (version) VALUES ('20160121214617');
5515
5516INSERT INTO schema_migrations (version) VALUES ('20160122194722');
5517
5518INSERT INTO schema_migrations (version) VALUES ('20160122200022');
5519
5520INSERT INTO schema_migrations (version) VALUES ('20160127170246');
5521
5522INSERT INTO schema_migrations (version) VALUES ('20160127174547');
5523
5524INSERT INTO schema_migrations (version) VALUES ('20160127174746');
5525
5526INSERT INTO schema_migrations (version) VALUES ('20160127210801');
5527
5528INSERT INTO schema_migrations (version) VALUES ('20160127211745');
5529
5530INSERT INTO schema_migrations (version) VALUES ('20160127211909');
5531
5532INSERT INTO schema_migrations (version) VALUES ('20160129161057');
5533
5534INSERT INTO schema_migrations (version) VALUES ('20160201202339');
5535
5536INSERT INTO schema_migrations (version) VALUES ('20160202154135');
5537
5538INSERT INTO schema_migrations (version) VALUES ('20160202233425');
5539
5540INSERT INTO schema_migrations (version) VALUES ('20160204162458');
5541
5542INSERT INTO schema_migrations (version) VALUES ('20160204183406');
5543
5544INSERT INTO schema_migrations (version) VALUES ('20160204183414');
5545
5546INSERT INTO schema_migrations (version) VALUES ('20160204185623');
5547
5548INSERT INTO schema_migrations (version) VALUES ('20160208233846');
5549
5550INSERT INTO schema_migrations (version) VALUES ('20160209154342');
5551
5552INSERT INTO schema_migrations (version) VALUES ('20160209211706');
5553
5554INSERT INTO schema_migrations (version) VALUES ('20160215151713');
5555
5556INSERT INTO schema_migrations (version) VALUES ('20160216183222');
5557
5558INSERT INTO schema_migrations (version) VALUES ('20160216211840');
5559
5560INSERT INTO schema_migrations (version) VALUES ('20160217163537');
5561
5562INSERT INTO schema_migrations (version) VALUES ('20160217184355');
5563
5564INSERT INTO schema_migrations (version) VALUES ('20160222212356');
5565
5566INSERT INTO schema_migrations (version) VALUES ('20160223211727');
5567
5568INSERT INTO schema_migrations (version) VALUES ('20160226164547');
5569
5570INSERT INTO schema_migrations (version) VALUES ('20160307154811');
5571
5572INSERT INTO schema_migrations (version) VALUES ('20160307165629');
5573
5574INSERT INTO schema_migrations (version) VALUES ('20160307172438');
5575
5576INSERT INTO schema_migrations (version) VALUES ('20160307202408');
5577
5578INSERT INTO schema_migrations (version) VALUES ('20160307202448');
5579
5580INSERT INTO schema_migrations (version) VALUES ('20160307202510');
5581
5582INSERT INTO schema_migrations (version) VALUES ('20160307205219');
5583
5584INSERT INTO schema_migrations (version) VALUES ('20160307211034');
5585
5586INSERT INTO schema_migrations (version) VALUES ('20160307212013');
5587
5588INSERT INTO schema_migrations (version) VALUES ('20160307212016');
5589
5590INSERT INTO schema_migrations (version) VALUES ('20160307221055');
5591
5592INSERT INTO schema_migrations (version) VALUES ('20160309025011');
5593
5594INSERT INTO schema_migrations (version) VALUES ('20160309192436');
5595
5596INSERT INTO schema_migrations (version) VALUES ('20160316155029');
5597
5598INSERT INTO schema_migrations (version) VALUES ('20160321184421');
5599
5600INSERT INTO schema_migrations (version) VALUES ('20160321184521');
5601
5602INSERT INTO schema_migrations (version) VALUES ('20160321205056');
5603
5604INSERT INTO schema_migrations (version) VALUES ('20160323144801');
5605
5606INSERT INTO schema_migrations (version) VALUES ('20160324180730');
5607
5608INSERT INTO schema_migrations (version) VALUES ('20160324213351');
5609
5610INSERT INTO schema_migrations (version) VALUES ('20160328150457');
5611
5612INSERT INTO schema_migrations (version) VALUES ('20160328151249');
5613
5614INSERT INTO schema_migrations (version) VALUES ('20160330191116');
5615
5616INSERT INTO schema_migrations (version) VALUES ('20160412151358');
5617
5618INSERT INTO schema_migrations (version) VALUES ('20160412155435');
5619
5620INSERT INTO schema_migrations (version) VALUES ('20160413194032');
5621
5622INSERT INTO schema_migrations (version) VALUES ('20160418195624');
5623
5624INSERT INTO schema_migrations (version) VALUES ('20160419213527');
5625
5626INSERT INTO schema_migrations (version) VALUES ('20160420153209');
5627
5628INSERT INTO schema_migrations (version) VALUES ('20160425152504');
5629
5630INSERT INTO schema_migrations (version) VALUES ('20160426223516');
5631
5632INSERT INTO schema_migrations (version) VALUES ('20160506191401');
5633
5634INSERT INTO schema_migrations (version) VALUES ('20160509225818');
5635
5636INSERT INTO schema_migrations (version) VALUES ('20160510165303');
5637
5638INSERT INTO schema_migrations (version) VALUES ('20160510165522');
5639
5640INSERT INTO schema_migrations (version) VALUES ('20160510165736');
5641
5642INSERT INTO schema_migrations (version) VALUES ('20160510223227');
5643
5644INSERT INTO schema_migrations (version) VALUES ('20160510230512');
5645
5646INSERT INTO schema_migrations (version) VALUES ('20160511151043');
5647
5648INSERT INTO schema_migrations (version) VALUES ('20160517161827');
5649
5650INSERT INTO schema_migrations (version) VALUES ('20160519165037');
5651
5652INSERT INTO schema_migrations (version) VALUES ('20160519165143');
5653
5654INSERT INTO schema_migrations (version) VALUES ('20160519165253');
5655
5656INSERT INTO schema_migrations (version) VALUES ('20160519165349');
5657
5658INSERT INTO schema_migrations (version) VALUES ('20160519165444');
5659
5660INSERT INTO schema_migrations (version) VALUES ('20160519165537');
5661
5662INSERT INTO schema_migrations (version) VALUES ('20160519203038');
5663
5664INSERT INTO schema_migrations (version) VALUES ('20160519203913');
5665
5666INSERT INTO schema_migrations (version) VALUES ('20160519213022');
5667
5668INSERT INTO schema_migrations (version) VALUES ('20160520195140');
5669
5670INSERT INTO schema_migrations (version) VALUES ('20160523223025');
5671
5672INSERT INTO schema_migrations (version) VALUES ('20160525160722');
5673
5674INSERT INTO schema_migrations (version) VALUES ('20160525200205');
5675
5676INSERT INTO schema_migrations (version) VALUES ('20160531183416');
5677
5678INSERT INTO schema_migrations (version) VALUES ('20160607142353');
5679
5680INSERT INTO schema_migrations (version) VALUES ('20160608201536');
5681
5682INSERT INTO schema_migrations (version) VALUES ('20160620154735');
5683
5684INSERT INTO schema_migrations (version) VALUES ('20160621202736');
5685
5686INSERT INTO schema_migrations (version) VALUES ('20160622150343');
5687
5688INSERT INTO schema_migrations (version) VALUES ('20160622150857');
5689
5690INSERT INTO schema_migrations (version) VALUES ('20160622192250');
5691
5692INSERT INTO schema_migrations (version) VALUES ('20160627214529');
5693
5694INSERT INTO schema_migrations (version) VALUES ('20160628153338');
5695
5696INSERT INTO schema_migrations (version) VALUES ('20160628175145');
5697
5698INSERT INTO schema_migrations (version) VALUES ('20160629165930');
5699
5700INSERT INTO schema_migrations (version) VALUES ('20160714152938');
5701
5702INSERT INTO schema_migrations (version) VALUES ('20160720131657');
5703
5704INSERT INTO schema_migrations (version) VALUES ('20160720212016');
5705
5706INSERT INTO schema_migrations (version) VALUES ('20160722212231');
5707
5708INSERT INTO schema_migrations (version) VALUES ('20160727204420');
5709
5710INSERT INTO schema_migrations (version) VALUES ('20160728192049');
5711
5712INSERT INTO schema_migrations (version) VALUES ('20160728192847');
5713
5714INSERT INTO schema_migrations (version) VALUES ('20160804180712');
5715
5716INSERT INTO schema_migrations (version) VALUES ('20160805193504');
5717
5718INSERT INTO schema_migrations (version) VALUES ('20160808193543');
5719
5720INSERT INTO schema_migrations (version) VALUES ('20160815185631');
5721
5722INSERT INTO schema_migrations (version) VALUES ('20160819204118');
5723
5724INSERT INTO schema_migrations (version) VALUES ('20160821032108');
5725
5726INSERT INTO schema_migrations (version) VALUES ('20160821172306');
5727
5728INSERT INTO schema_migrations (version) VALUES ('20160830193341');