db-init.sql

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: views; Type: SCHEMA; Schema: -; Owner: -
--

CREATE SCHEMA views;


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE address (
    id bigint NOT NULL,
    "to" character varying,
    street character varying,
    city character varying,
    state character varying
);


--
-- Name: customer; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE customer (
    id bigint NOT NULL,
    name character varying NOT NULL
);


--
-- Name: customer_address; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE customer_address (
    customer_id bigint NOT NULL,
    address_id bigint NOT NULL
);


--
-- Name: order; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE "order" (
    id bigint NOT NULL,
    customer_id bigint NOT NULL,
    store_id bigint NOT NULL,
    placed_at timestamp without time zone DEFAULT now() NOT NULL,
    total integer NOT NULL
);

--
-- Name: store; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE store (
    id bigint NOT NULL,
    name character varying
);



--
-- Data for Name: address; Type: TABLE DATA; Schema: public; Owner: -
--

COPY address (id, "to", street, city, state) FROM stdin;
61	Nickolas Ferrel  	123 Fake St	New York	NY
62	Sharice Renaud  	124 Fake St	Chicago	IL
63	Barney Howery  	125 Fake St	Austin	TX
64	Alisha Burget  	126 Fake St	Seattle	WA
65	Darby Main  	127 Fake St	Chicago	IL
66	Lavenia Herzig  	128 Fake St	Austin	TX
67	Juanita Gottschalk  	129 Fake St	Seattle	WA
68	Ozella Schmaltz  	130 Fake St	Austin	TX
69	Fannie Morneau  	131 Fake St	Austin	TX
70	Mckinley Poblete  	132 Fake St	Chicago	IL
71	Toi Hornback  	133 Fake St	Seattle	WA
72	Evelina Pelfrey  	134 Fake St	Seattle	WA
73	Corrine Westrich  	135 Fake St	Austin	TX
74	Nannette Delosreyes  	136 Fake St	Seattle	WA
75	Helga Alaniz  	137 Fake St	Chicago	IL
76	Melodee Gariepy  	138 Fake St	Austin	TX
77	Jacquetta Unruh  	139 Fake St	Austin	TX
78	Rodrick Mower  	140 Fake St	Seattle	WA
79	Wanetta Benoit  	141 Fake St	Seattle	WA
80	Martine Dinh  	142 Fake St	Seattle	WA
81	Jacki Mayhew  	143 Fake St	Chicago	IL
82	Jamel Paugh  	144 Fake St	Austin	TX
83	Arcelia Garofalo  	145 Fake St	Seattle	WA
84	Agustina Trogdon  	146 Fake St	Seattle	WA
85	Cheryle Everhart  	147 Fake St	Seattle	WA
86	Leo Duke  	148 Fake St	Seattle	WA
87	Frederica Gerhardt  	149 Fake St	New York	NY
88	Kanesha Royster  	150 Fake St	Denver	CO
89	Latrisha Babiarz  	151 Fake St	Austin	TX
90	Naida Dole  	152 Fake St	Austin	TX
91	Rodolfo Musso  	153 Fake St	Austin	TX
92	Sindy Underdown  	154 Fake St	Denver	CO
93	Zaida Souther  	155 Fake St	New York	NY
94	Asha Mcgonigal  	156 Fake St	Denver	CO
95	Charlie Nason  	157 Fake St	Portland	OR
96	Mayola Ahrens  	158 Fake St	Portland	OR
97	Gordon Hang  	159 Fake St	Denver	CO
98	Burton Casagrande  	160 Fake St	Portland	OR
99	Len Hershberger  	161 Fake St	New York	NY
100	Albertha Grunewald  	162 Fake St	Portland	OR
101	Bernardine Light  	163 Fake St	Portland	OR
102	Serena Whitehead  	164 Fake St	Denver	CO
103	Danille Witzke  	165 Fake St	Portland	OR
104	Lela Ursery  	166 Fake St	Denver	CO
105	Kiara Saito  	167 Fake St	Portland	OR
106	Domitila Dirksen  	168 Fake St	Denver	CO
107	Soon Kerlin  	169 Fake St	New York	NY
108	Lenna Hendrixson  	170 Fake St	Portland	OR
109	Carmelo Allin  	171 Fake St	Austin	TX
110	Malcom Harps  	172 Fake St	Portland	OR
111	Rodolfo Musso  	173 Fake St	New York	NY
112	Rodolfo Musso  	174 Fake St	New York	NY
113	Rodolfo Musso  	175 Fake St	New York	NY
114	Rodolfo Musso  	176 Fake St	New York	NY
115	Sindy Underdown  	177 Fake St	New York	NY
116	Sindy Underdown  	178 Fake St	New York	NY
117	Sindy Underdown  	179 Fake St	New York	NY
118	Sindy Underdown  	180 Fake St	New York	NY
119	Sindy Underdown  	181 Fake St	New York	NY
120	Sindy Underdown  	182 Fake St	New York	NY
121	Bernardine Light  	183 Fake St	Denver	CO
122	Serena Whitehead  	184 Fake St	New York	NY
123	Danille Witzke  	185 Fake St	Denver	CO
124	Nickolas Ferrel  	186 Fake St	Austin	TX
125	Sharice Renaud  	187 Fake St	Portland	OR
126	Barney Howery  	188 Fake St	New York	NY
127	Alisha Burget  	189 Fake St	Portland	OR
\.


--
-- Data for Name: customer; Type: TABLE DATA; Schema: public; Owner: -
--

COPY customer (id, name) FROM stdin;
11	Nickolas Ferrel  
12	Sharice Renaud  
13	Barney Howery  
14	Alisha Burget  
15	Darby Main  
16	Lavenia Herzig  
17	Juanita Gottschalk  
18	Ozella Schmaltz  
19	Fannie Morneau  
20	Mckinley Poblete  
21	Toi Hornback  
22	Evelina Pelfrey  
23	Corrine Westrich  
24	Nannette Delosreyes  
25	Helga Alaniz  
26	Melodee Gariepy  
27	Jacquetta Unruh  
28	Rodrick Mower  
29	Wanetta Benoit  
30	Martine Dinh  
31	Jacki Mayhew  
32	Jamel Paugh  
33	Arcelia Garofalo  
34	Agustina Trogdon  
35	Cheryle Everhart  
36	Leo Duke  
37	Frederica Gerhardt  
38	Kanesha Royster  
39	Latrisha Babiarz  
40	Naida Dole  
41	Rodolfo Musso  
42	Sindy Underdown  
43	Zaida Souther  
44	Asha Mcgonigal  
45	Charlie Nason  
46	Mayola Ahrens  
47	Gordon Hang  
48	Burton Casagrande  
49	Len Hershberger  
50	Albertha Grunewald  
51	Bernardine Light  
52	Serena Whitehead  
53	Danille Witzke  
54	Lela Ursery  
55	Kiara Saito  
56	Domitila Dirksen  
57	Soon Kerlin  
58	Lenna Hendrixson  
59	Carmelo Allin  
60	Malcom Harps  
\.


--
-- Data for Name: customer_address; Type: TABLE DATA; Schema: public; Owner: -
--

COPY customer_address (customer_id, address_id) FROM stdin;
11	61
12	62
13	63
14	64
15	65
16	66
17	67
18	68
19	69
20	70
21	71
22	72
23	73
24	74
25	75
26	76
27	77
28	78
29	79
30	80
31	81
32	82
33	83
34	84
35	85
36	86
37	87
38	88
39	89
40	90
41	91
42	92
43	93
44	94
45	95
46	96
47	97
48	98
49	99
50	100
51	101
52	102
53	103
54	104
55	105
56	106
57	107
58	108
59	109
60	110
41	111
41	112
41	113
41	114
42	115
42	116
42	117
42	118
42	119
42	120
51	121
52	122
53	123
11	124
12	125
13	126
14	127
\.


--
-- Data for Name: order; Type: TABLE DATA; Schema: public; Owner: -
--

COPY "order" (id, customer_id, store_id, placed_at, total) FROM stdin;
128	39	9	2017-01-09 00:00:00	5000
129	40	10	2017-02-10 00:00:00	6250
130	41	1	2017-02-11 00:00:00	1250
131	42	2	2017-02-12 00:00:00	2500
132	43	10	2017-02-13 00:00:00	3750
133	44	10	2017-02-14 00:00:00	5000
134	45	10	2017-02-15 00:00:00	6250
135	46	10	2017-01-16 00:00:00	1250
136	47	3	2017-01-17 00:00:00	2500
137	48	3	2017-01-18 00:00:00	3750
138	49	3	2017-01-19 00:00:00	5000
139	50	3	2017-03-20 00:00:00	6250
140	51	3	2017-03-21 00:00:00	1250
141	52	2	2017-03-22 00:00:00	2500
142	53	3	2017-03-23 00:00:00	3750
143	54	4	2017-02-24 00:00:00	5000
144	55	5	2017-02-25 00:00:00	6250
145	56	6	2017-02-26 00:00:00	1250
146	57	7	2017-02-27 00:00:00	2500
147	58	8	2017-02-28 00:00:00	3750
148	59	9	2017-03-01 00:00:00	5000
149	60	10	2017-03-02 00:00:00	6250
150	11	1	2017-03-01 00:00:00	1250
151	12	2	2017-03-02 00:00:00	2500
152	13	3	2017-03-03 00:00:00	3750
153	14	4	2017-03-04 00:00:00	5000
154	15	5	2017-01-05 00:00:00	6250
155	16	6	2017-01-06 00:00:00	1250
156	17	7	2017-01-07 00:00:00	2500
157	18	8	2017-01-08 00:00:00	3750
158	19	9	2017-01-09 00:00:00	5000
159	20	10	2017-01-10 00:00:00	6250
160	21	1	2017-03-11 00:00:00	1250
161	22	2	2017-04-12 00:00:00	2500
162	23	3	2017-05-13 00:00:00	3750
163	24	4	2017-04-14 00:00:00	5000
164	25	10	2017-05-15 00:00:00	6250
165	26	10	2017-01-16 00:00:00	1250
166	27	10	2017-01-17 00:00:00	2500
167	28	10	2017-01-18 00:00:00	3750
168	29	9	2017-01-19 00:00:00	5000
169	30	10	2017-01-20 00:00:00	6250
170	31	3	2017-02-21 00:00:00	1250
171	32	3	2017-02-22 00:00:00	2500
172	33	3	2017-02-23 00:00:00	3750
173	34	3	2017-02-24 00:00:00	5000
174	35	3	2017-02-25 00:00:00	6250
175	36	3	2017-04-26 00:00:00	1250
176	37	7	2017-04-27 00:00:00	2500
177	38	8	2017-04-28 00:00:00	3750
178	39	9	2017-04-29 00:00:00	5000
179	40	10	2017-01-30 00:00:00	6250
180	41	1	2017-01-01 00:00:00	1250
181	42	2	2017-01-02 00:00:00	2500
182	43	3	2017-01-03 00:00:00	3750
183	44	4	2017-01-04 00:00:00	5000
184	45	5	2017-01-05 00:00:00	6250
185	46	6	2017-01-06 00:00:00	1250
186	47	7	2017-02-07 00:00:00	2500
187	48	8	2017-02-08 00:00:00	3750
188	49	9	2017-02-09 00:00:00	5000
189	50	10	2017-02-10 00:00:00	6250
190	51	1	2017-02-11 00:00:00	1250
191	52	3	2017-02-12 00:00:00	2500
192	53	3	2017-04-13 00:00:00	3750
193	54	3	2017-04-14 00:00:00	5000
194	55	3	2017-05-15 00:00:00	6250
195	56	3	2017-05-16 00:00:00	1250
196	57	3	2017-06-17 00:00:00	2500
197	58	10	2017-06-18 00:00:00	3750
198	59	9	2017-06-19 00:00:00	5000
199	60	10	2017-06-20 00:00:00	6250
200	11	1	2017-06-21 00:00:00	1250
201	12	2	2017-06-22 00:00:00	2500
202	13	3	2017-06-23 00:00:00	3750
203	14	4	2017-01-24 00:00:00	5000
204	15	5	2017-01-25 00:00:00	6250
205	16	6	2017-01-26 00:00:00	1250
206	17	7	2017-01-27 00:00:00	2500
207	18	8	2017-01-28 00:00:00	3750
208	19	9	2017-01-29 00:00:00	5000
209	20	10	2017-01-30 00:00:00	6250
210	21	1	2017-02-01 00:00:00	1250
211	22	2	2017-02-02 00:00:00	2500
212	23	3	2017-02-03 00:00:00	3750
213	24	4	2017-06-04 00:00:00	5000
214	25	5	2017-06-05 00:00:00	6250
215	26	6	2017-01-06 00:00:00	1250
216	27	3	2017-01-07 00:00:00	2500
217	28	3	2017-01-08 00:00:00	3750
218	29	3	2017-01-09 00:00:00	5000
219	30	3	2017-01-10 00:00:00	6250
220	31	3	2017-01-11 00:00:00	1250
221	32	3	2017-01-12 00:00:00	2500
222	33	3	2017-01-13 00:00:00	3750
223	34	3	2017-02-14 00:00:00	5000
224	35	3	2017-02-15 00:00:00	6250
225	36	6	2017-02-16 00:00:00	1250
226	37	7	2017-02-17 00:00:00	2500
227	38	8	2017-02-18 00:00:00	3750
228	39	9	2017-03-19 00:00:00	5000
229	40	10	2017-03-20 00:00:00	6250
230	41	1	2017-01-21 00:00:00	1250
231	42	2	2017-01-22 00:00:00	2500
232	43	3	2017-01-23 00:00:00	3750
233	44	4	2017-01-24 00:00:00	5000
234	45	5	2017-02-25 00:00:00	6250
235	46	6	2017-02-26 00:00:00	1250
236	47	7	2017-02-27 00:00:00	2500
237	48	8	2017-02-28 00:00:00	3750
238	49	9	2017-03-01 00:00:00	5000
239	50	10	2017-03-02 00:00:00	6250
240	51	1	2017-02-01 00:00:00	1250
241	52	2	2017-02-02 00:00:00	2500
242	53	3	2017-02-03 00:00:00	3750
243	54	4	2017-02-04 00:00:00	5000
244	55	5	2017-02-05 00:00:00	6250
245	56	3	2017-02-06 00:00:00	1250
246	57	3	2017-02-07 00:00:00	2500
247	58	3	2017-02-08 00:00:00	3750
248	59	10	2017-03-09 00:00:00	5000
249	60	10	2017-03-10 00:00:00	6250
250	11	10	2017-06-11 00:00:00	1250
251	12	10	2017-06-12 00:00:00	2500
252	13	3	2017-06-13 00:00:00	3750
253	14	4	2017-06-14 00:00:00	5000
254	15	5	2017-06-15 00:00:00	6250
255	16	6	2017-04-16 00:00:00	1250
256	17	7	2017-04-17 00:00:00	2500
257	18	8	2017-04-18 00:00:00	3750
258	19	9	2017-04-19 00:00:00	5000
259	20	10	2017-04-20 00:00:00	6250
260	21	1	2017-04-21 00:00:00	1250
261	22	2	2017-04-22 00:00:00	2500
262	23	3	2017-04-23 00:00:00	3750
263	24	3	2017-02-24 00:00:00	5000
264	25	3	2017-02-25 00:00:00	6250
265	26	3	2017-02-26 00:00:00	1250
266	27	3	2017-02-27 00:00:00	2500
267	28	3	2017-02-28 00:00:00	3750
268	29	9	2017-03-01 00:00:00	5000
269	30	10	2017-03-02 00:00:00	6250
270	31	1	2017-06-01 00:00:00	1250
271	32	2	2017-06-02 00:00:00	2500
272	33	3	2017-05-03 00:00:00	3750
273	34	4	2017-05-04 00:00:00	5000
274	35	5	2017-05-05 00:00:00	6250
275	36	6	2017-05-06 00:00:00	1250
276	37	7	2017-04-07 00:00:00	2500
277	38	8	2017-04-08 00:00:00	3750
278	39	9	2017-04-09 00:00:00	5000
279	40	10	2017-04-10 00:00:00	6250
280	41	3	2017-04-11 00:00:00	1250
281	42	3	2017-02-12 00:00:00	2500
282	43	3	2017-02-13 00:00:00	3750
283	44	3	2017-02-14 00:00:00	5000
284	45	3	2017-02-15 00:00:00	6250
285	46	10	2017-02-16 00:00:00	1250
286	47	7	2017-02-17 00:00:00	2500
287	48	8	2017-04-18 00:00:00	3750
288	49	9	2017-04-19 00:00:00	5000
289	50	10	2017-03-20 00:00:00	6250
290	51	1	2017-03-21 00:00:00	1250
291	52	2	2017-03-22 00:00:00	2500
292	53	3	2017-03-23 00:00:00	3750
293	54	4	2017-03-24 00:00:00	5000
294	55	3	2017-03-25 00:00:00	6250
295	56	3	2017-03-26 00:00:00	1250
296	57	3	2017-04-27 00:00:00	2500
297	58	3	2017-01-28 00:00:00	3750
298	59	3	2017-01-29 00:00:00	5000
299	60	10	2017-01-30 00:00:00	6250
300	11	1	2017-01-01 00:00:00	1250
301	12	2	2017-01-02 00:00:00	2500
302	13	3	2017-04-03 00:00:00	3750
303	14	4	2017-02-04 00:00:00	5000
304	15	5	2017-02-05 00:00:00	6250
305	16	6	2017-02-06 00:00:00	1250
306	17	10	2017-02-07 00:00:00	2500
307	18	10	2017-06-08 00:00:00	3750
308	19	10	2017-06-09 00:00:00	5000
309	20	10	2017-06-10 00:00:00	6250
310	21	1	2017-03-11 00:00:00	1250
311	22	2	2017-03-12 00:00:00	2500
312	23	3	2017-03-13 00:00:00	3750
313	24	4	2017-03-14 00:00:00	5000
314	25	5	2017-03-15 00:00:00	6250
315	26	6	2017-03-16 00:00:00	1250
316	27	7	2017-03-17 00:00:00	2500
317	28	8	2017-03-18 00:00:00	3750
318	29	9	2017-06-19 00:00:00	5000
319	30	10	2017-06-20 00:00:00	6250
320	31	1	2017-06-21 00:00:00	1250
321	32	2	2017-06-22 00:00:00	2500
322	33	3	2017-06-23 00:00:00	3750
323	34	4	2017-06-24 00:00:00	5000
324	35	5	2017-06-25 00:00:00	6250
325	36	6	2017-06-26 00:00:00	1250
326	37	7	2017-02-27 00:00:00	2500
327	38	8	2017-02-28 00:00:00	3750
328	39	9	2017-03-01 00:00:00	5000
329	40	10	2017-03-02 00:00:00	6250
330	41	1	2017-02-01 00:00:00	1250
331	42	2	2017-02-02 00:00:00	2500
332	43	3	2017-02-03 00:00:00	3750
333	44	4	2017-02-04 00:00:00	5000
334	45	5	2017-06-05 00:00:00	6250
335	46	6	2017-06-06 00:00:00	1250
336	47	7	2017-06-07 00:00:00	2500
337	48	8	2017-06-08 00:00:00	3750
338	49	9	2017-06-09 00:00:00	5000
339	50	10	2017-05-10 00:00:00	6250
340	51	1	2017-05-11 00:00:00	1250
341	52	2	2017-05-12 00:00:00	2500
342	53	3	2017-02-13 00:00:00	3750
343	54	4	2017-02-14 00:00:00	5000
344	55	5	2017-02-15 00:00:00	6250
345	56	6	2017-02-16 00:00:00	1250
346	57	7	2017-02-17 00:00:00	2500
347	58	8	2017-02-18 00:00:00	3750
348	59	9	2017-02-19 00:00:00	5000
349	60	10	2017-02-20 00:00:00	6250
350	11	1	2017-02-21 00:00:00	1250
351	12	2	2017-02-22 00:00:00	2500
352	13	3	2017-02-23 00:00:00	3750
353	14	4	2017-05-24 00:00:00	5000
354	15	5	2017-05-25 00:00:00	6250
355	16	6	2017-05-26 00:00:00	1250
356	17	7	2017-05-27 00:00:00	2500
357	18	8	2017-05-28 00:00:00	3750
358	19	9	2017-06-29 00:00:00	5000
359	20	10	2017-06-30 00:00:00	6250
360	21	1	2017-03-01 00:00:00	1250
361	22	2	2017-03-02 00:00:00	2500
362	23	3	2017-03-03 00:00:00	3750
363	24	4	2017-03-04 00:00:00	5000
364	25	5	2017-03-05 00:00:00	6250
365	26	6	2017-03-06 00:00:00	1250
366	27	7	2017-06-07 00:00:00	2500
367	28	8	2017-06-08 00:00:00	3750
368	29	9	2017-06-09 00:00:00	5000
369	30	10	2017-06-10 00:00:00	6250
370	31	1	2017-06-11 00:00:00	1250
371	32	2	2017-06-12 00:00:00	2500
372	33	3	2017-06-13 00:00:00	3750
373	34	4	2017-06-14 00:00:00	5000
374	35	5	2017-02-15 00:00:00	6250
375	36	6	2017-02-16 00:00:00	1250
376	37	7	2017-02-17 00:00:00	2500
377	38	8	2017-02-18 00:00:00	3750
378	39	9	2017-02-19 00:00:00	5000
379	40	10	2017-02-20 00:00:00	6250
380	41	1	2017-02-21 00:00:00	1250
381	42	2	2017-02-22 00:00:00	2500
382	43	3	2017-05-23 00:00:00	3750
383	44	4	2017-04-24 00:00:00	5000
384	45	5	2017-04-25 00:00:00	6250
385	46	6	2017-04-26 00:00:00	1250
386	47	7	2017-04-27 00:00:00	2500
387	48	8	2017-04-28 00:00:00	3750
388	49	9	2017-04-29 00:00:00	5000
389	50	10	2017-04-30 00:00:00	6250
390	51	1	2017-01-01 00:00:00	1250
391	52	2	2017-01-02 00:00:00	2500
392	53	3	2017-01-03 00:00:00	3750
393	54	4	2017-01-04 00:00:00	5000
394	55	5	2017-05-05 00:00:00	6250
395	56	6	2017-05-06 00:00:00	1250
396	57	7	2017-05-07 00:00:00	2500
397	58	8	2017-06-08 00:00:00	3750
398	59	9	2017-06-09 00:00:00	5000
399	60	10	2017-03-10 00:00:00	6250
400	11	1	2017-03-11 00:00:00	1250
401	12	2	2017-01-12 00:00:00	2500
402	13	3	2017-01-13 00:00:00	3750
403	14	4	2017-01-14 00:00:00	5000
404	15	5	2017-01-15 00:00:00	6250
405	16	6	2017-01-16 00:00:00	1250
406	17	7	2017-01-17 00:00:00	2500
407	18	8	2017-02-18 00:00:00	3750
408	19	9	2017-02-19 00:00:00	5000
409	20	10	2017-02-20 00:00:00	6250
410	21	1	2017-02-21 00:00:00	1250
411	22	2	2017-02-22 00:00:00	2500
412	23	3	2017-02-23 00:00:00	3750
413	24	4	2017-02-24 00:00:00	5000
414	25	5	2017-02-25 00:00:00	6250
415	26	6	2017-02-26 00:00:00	1250
416	27	7	2017-03-27 00:00:00	2500
417	28	8	2017-03-28 00:00:00	3750
418	29	9	2017-03-29 00:00:00	5000
419	30	10	2017-06-30 00:00:00	6250
420	31	1	2017-06-01 00:00:00	1250
421	32	2	2017-06-02 00:00:00	2500
422	33	3	2017-06-03 00:00:00	3750
423	34	4	2017-06-04 00:00:00	5000
424	35	5	2017-06-05 00:00:00	6250
425	36	6	2017-02-06 00:00:00	1250
426	37	7	2017-02-07 00:00:00	2500
427	38	8	2017-02-08 00:00:00	3750
428	39	9	2017-02-09 00:00:00	5000
429	40	10	2017-02-10 00:00:00	6250
430	41	1	2017-02-11 00:00:00	1250
431	42	2	2017-02-12 00:00:00	2500
432	43	3	2017-02-13 00:00:00	3750
433	44	4	2017-02-14 00:00:00	5000
434	45	5	2017-01-15 00:00:00	6250
435	46	6	2017-01-16 00:00:00	1250
436	47	7	2017-01-17 00:00:00	2500
437	48	8	2017-06-18 00:00:00	3750
438	49	9	2017-06-19 00:00:00	5000
439	50	10	2017-06-20 00:00:00	6250
440	51	1	2017-06-21 00:00:00	1250
441	52	2	2017-06-22 00:00:00	2500
442	53	3	2017-06-23 00:00:00	3750
443	54	4	2017-06-24 00:00:00	5000
444	55	5	2017-06-25 00:00:00	6250
445	56	6	2017-06-26 00:00:00	1250
446	57	7	2017-06-27 00:00:00	2500
447	58	8	2017-06-28 00:00:00	3750
448	59	9	2017-06-29 00:00:00	5000
449	60	10	2017-04-30 00:00:00	6250
450	11	1	2017-01-01 00:00:00	1250
451	12	2	2017-01-02 00:00:00	2500
452	13	3	2017-01-03 00:00:00	3750
453	14	4	2017-01-04 00:00:00	5000
454	15	5	2017-01-05 00:00:00	6250
455	16	6	2017-01-06 00:00:00	1250
456	17	7	2017-04-07 00:00:00	2500
457	18	8	2017-04-08 00:00:00	3750
458	19	9	2017-03-09 00:00:00	5000
459	20	10	2017-02-10 00:00:00	6250
460	21	1	2017-02-11 00:00:00	1250
461	22	2	2017-02-12 00:00:00	2500
462	23	3	2017-02-13 00:00:00	3750
463	24	4	2017-02-14 00:00:00	5000
464	25	5	2017-02-15 00:00:00	6250
465	26	6	2017-01-16 00:00:00	1250
466	27	7	2017-01-17 00:00:00	2500
467	28	8	2017-01-18 00:00:00	3750
468	29	9	2017-03-19 00:00:00	5000
469	30	10	2017-03-20 00:00:00	6250
470	31	1	2017-03-21 00:00:00	1250
471	32	2	2017-03-22 00:00:00	2500
472	33	3	2017-03-23 00:00:00	3750
473	34	4	2017-04-24 00:00:00	5000
474	35	5	2017-04-25 00:00:00	6250
475	36	6	2017-04-26 00:00:00	1250
476	37	7	2017-04-27 00:00:00	2500
477	38	8	2017-06-28 00:00:00	3750
478	39	9	2017-03-01 00:00:00	5000
479	40	10	2017-03-02 00:00:00	6250
480	41	1	2017-02-01 00:00:00	1250
481	42	2	2017-02-02 00:00:00	2500
482	43	3	2017-02-03 00:00:00	3750
483	44	4	2017-02-04 00:00:00	5000
484	45	5	2017-02-05 00:00:00	6250
485	46	6	2017-02-06 00:00:00	1250
486	47	7	2017-02-07 00:00:00	2500
487	48	8	2017-01-08 00:00:00	3750
488	49	9	2017-01-09 00:00:00	5000
489	50	10	2017-01-10 00:00:00	6250
490	51	1	2017-01-11 00:00:00	1250
491	52	2	2017-05-12 00:00:00	2500
492	53	3	2017-05-13 00:00:00	3750
493	54	4	2017-04-14 00:00:00	5000
494	55	5	2017-04-15 00:00:00	6250
495	56	6	2017-04-16 00:00:00	1250
496	57	7	2017-04-17 00:00:00	2500
497	58	10	2017-03-18 00:00:00	3750
498	59	10	2017-03-19 00:00:00	5000
499	60	10	2017-03-20 00:00:00	6250
500	11	10	2017-03-21 00:00:00	1250
501	12	10	2017-04-22 00:00:00	2500
502	13	10	2017-04-23 00:00:00	3750
503	14	10	2017-02-24 00:00:00	5000
504	15	10	2017-02-25 00:00:00	6250
505	16	10	2017-02-26 00:00:00	1250
506	17	10	2017-02-27 00:00:00	2500
507	18	10	2017-02-28 00:00:00	3750
508	19	10	2017-03-01 00:00:00	5000
509	20	10	2017-03-02 00:00:00	6250
510	21	10	2017-02-01 00:00:00	1250
511	22	10	2017-04-02 00:00:00	2500
512	23	10	2017-03-03 00:00:00	3750
\.



--
-- Data for Name: store; Type: TABLE DATA; Schema: public; Owner: -
--

COPY store (id, name) FROM stdin;
1	Biofitness Laboratories
2	Mystical Muse
3	Energy Supply Company
4	Singles Swag Cup Crate
5	BeerSauce Inc
6	Culinarie Cuts
7	The BBQ Subscription Box
8	Dans Fine Things
9	Loose Simplicity
10	Cocktail Saloon Crafts
\.




ALTER TABLE ONLY customer 
    ADD CONSTRAINT customer_id_pkey PRIMARY KEY (id);
ALTER TABLE ONLY address 
    ADD CONSTRAINT address_id_pkey PRIMARY KEY (id);
ALTER TABLE ONLY "order" 
    ADD CONSTRAINT order_id_pkey PRIMARY KEY (id);
ALTER TABLE ONLY store
    ADD CONSTRAINT store_id_pkey PRIMARY KEY (id);

ALTER TABLE ONLY customer_address
    ADD CONSTRAINT customer_address_customer_id_fkey FOREIGN KEY (customer_id) REFERENCES customer(id) ON DELETE CASCADE;

ALTER TABLE ONLY customer_address
    ADD CONSTRAINT customer_address_address_id_fkey FOREIGN KEY (address_id) REFERENCES address(id) ON DELETE CASCADE;

ALTER TABLE ONLY "order"
    ADD CONSTRAINT order_store_id_fkey FOREIGN KEY (store_id) REFERENCES store(id) ON DELETE CASCADE;

ALTER TABLE ONLY "order"
    ADD CONSTRAINT order_customer_id_fkey FOREIGN KEY (customer_id) REFERENCES customer(id) ON DELETE CASCADE;




--
-- Name: public; Type: ACL; Schema: -; Owner: -
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--