ice_cream_db.sql

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

CREATE TABLE public.stocks (
    store_id integer NOT NULL,
    flavour character varying(255) NOT NULL,
    amount integer NOT NULL
);

CREATE TABLE public.stores (
    id integer NOT NULL,
    name character varying(255),
    country character varying(100) DEFAULT NULL::character varying
);

CREATE SEQUENCE public.stores_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE public.stores_id_seq OWNED BY public.stores.id;

CREATE TABLE public.users (
    id integer NOT NULL,
    name character varying(255) DEFAULT NULL::character varying,
    country character varying(100) DEFAULT NULL::character varying
);

CREATE SEQUENCE public.users_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;

ALTER TABLE ONLY public.stores ALTER COLUMN id SET DEFAULT nextval('public.stores_id_seq'::regclass);

ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);

COPY public.stocks (store_id, flavour, amount) FROM stdin;
1	Strawberry	47
1	Caramel	67
1	Green tea	51
1	Vanilla	48
3	Chocolate	89
3	Vanilla	21
3	Coffee	5
4	Chocolate	46
4	Coffee	55
4	Vanilla	90
4	Mint	50
4	Green tea	53
4	Caramel	14
5	Mint	63
5	Caramel	14
5	Strawberry	25
5	Chocolate	81
5	Coffee	71
5	Green tea	56
6	Vanilla	18
7	Caramel	72
8	Green tea	49
8	Mint	62
9	Vanilla	81
9	Green tea	24
9	Strawberry	55
11	Strawberry	65
11	Mint	42
11	Caramel	46
11	Vanilla	91
11	Coffee	98
12	Coffee	89
12	Green tea	68
12	Chocolate	37
12	Mint	27
12	Strawberry	41
12	Vanilla	9
12	Caramel	10
13	Chocolate	97
13	Mint	18
13	Strawberry	39
13	Coffee	7
13	Caramel	30
13	Vanilla	15
13	Green tea	8
15	Green tea	80
15	Chocolate	3
15	Strawberry	68
16	Coffee	66
16	Vanilla	99
16	Mint	13
16	Chocolate	57
17	Strawberry	96
17	Coffee	54
17	Green tea	2
17	Chocolate	57
17	Mint	6
18	Chocolate	36
19	Caramel	26
19	Strawberry	1
19	Coffee	48
19	Mint	34
19	Chocolate	56
20	Caramel	26
21	Vanilla	81
21	Strawberry	19
21	Coffee	9
21	Caramel	92
21	Green tea	4
21	Mint	99
21	Chocolate	41
22	Caramel	2
22	Strawberry	88
22	Green tea	15
22	Coffee	18
22	Mint	95
22	Chocolate	23
22	Vanilla	2
23	Strawberry	63
23	Vanilla	96
24	Vanilla	60
24	Caramel	15
24	Strawberry	79
24	Chocolate	17
24	Mint	50
25	Mint	6
26	Coffee	17
26	Mint	74
26	Green tea	44
26	Caramel	38
26	Chocolate	61
26	Strawberry	63
26	Vanilla	58
27	Coffee	88
27	Strawberry	38
27	Mint	29
27	Vanilla	61
27	Green tea	95
28	Chocolate	73
28	Green tea	7
28	Coffee	70
28	Vanilla	100
29	Strawberry	65
29	Green tea	49
29	Coffee	33
29	Chocolate	92
29	Vanilla	74
30	Mint	41
30	Vanilla	1
30	Chocolate	28
30	Caramel	46
31	Vanilla	77
31	Chocolate	73
31	Mint	74
31	Caramel	14
32	Green tea	25
32	Coffee	27
32	Mint	8
33	Mint	73
33	Coffee	37
33	Caramel	43
34	Vanilla	38
34	Mint	18
34	Chocolate	50
34	Green tea	66
35	Green tea	80
35	Caramel	70
35	Chocolate	67
35	Mint	19
36	Green tea	97
36	Mint	1
37	Coffee	49
37	Caramel	30
37	Chocolate	73
37	Mint	93
38	Vanilla	55
38	Green tea	95
38	Strawberry	23
39	Strawberry	6
39	Caramel	1
39	Mint	45
39	Green tea	8
39	Chocolate	22
39	Coffee	61
40	Chocolate	64
40	Vanilla	94
40	Strawberry	92
40	Green tea	42
41	Chocolate	10
41	Caramel	1
41	Green tea	34
41	Vanilla	93
41	Mint	47
43	Strawberry	36
43	Green tea	62
43	Coffee	54
44	Vanilla	69
44	Caramel	76
44	Coffee	71
44	Green tea	73
44	Chocolate	19
44	Mint	40
44	Strawberry	26
45	Caramel	95
45	Coffee	24
45	Strawberry	2
47	Mint	22
47	Coffee	61
48	Strawberry	90
48	Mint	23
48	Chocolate	15
48	Coffee	83
48	Caramel	26
48	Green tea	23
49	Strawberry	68
49	Mint	16
49	Coffee	4
51	Green tea	63
51	Chocolate	84
51	Caramel	1
51	Vanilla	26
51	Coffee	9
51	Strawberry	62
52	Chocolate	76
52	Coffee	45
52	Mint	73
52	Green tea	65
52	Vanilla	60
52	Strawberry	34
52	Caramel	48
55	Vanilla	65
56	Strawberry	64
56	Mint	39
56	Chocolate	86
56	Coffee	34
56	Caramel	47
57	Coffee	15
58	Caramel	8
58	Coffee	59
58	Mint	99
58	Chocolate	34
59	Vanilla	27
59	Strawberry	45
59	Caramel	52
59	Chocolate	53
60	Strawberry	96
60	Caramel	11
60	Vanilla	53
60	Green tea	21
60	Mint	14
61	Strawberry	83
61	Caramel	29
61	Chocolate	68
61	Mint	64
61	Green tea	62
63	Strawberry	38
63	Chocolate	78
63	Coffee	20
63	Mint	32
64	Strawberry	72
64	Caramel	16
64	Mint	61
64	Green tea	98
64	Vanilla	74
64	Chocolate	63
65	Vanilla	80
65	Coffee	67
65	Green tea	20
65	Chocolate	15
65	Caramel	53
65	Mint	61
65	Strawberry	39
66	Strawberry	13
66	Chocolate	20
66	Mint	95
67	Coffee	57
67	Chocolate	25
67	Caramel	18
67	Mint	36
68	Coffee	99
68	Strawberry	11
68	Chocolate	6
68	Vanilla	38
68	Mint	39
68	Caramel	43
68	Green tea	12
69	Caramel	65
69	Chocolate	86
69	Vanilla	66
70	Caramel	61
70	Mint	38
70	Chocolate	90
70	Vanilla	93
71	Vanilla	24
71	Chocolate	50
72	Strawberry	63
72	Mint	81
73	Coffee	59
73	Strawberry	52
74	Coffee	9
74	Green tea	82
74	Chocolate	6
74	Caramel	34
74	Vanilla	73
74	Strawberry	50
75	Chocolate	79
75	Green tea	4
75	Coffee	35
75	Strawberry	26
75	Mint	5
76	Chocolate	38
76	Vanilla	3
76	Coffee	40
77	Green tea	100
77	Strawberry	30
77	Vanilla	4
77	Mint	3
78	Chocolate	33
78	Vanilla	7
78	Coffee	43
78	Green tea	33
79	Vanilla	64
79	Green tea	8
79	Mint	31
79	Coffee	91
79	Strawberry	9
80	Caramel	45
80	Strawberry	31
80	Vanilla	82
80	Mint	51
81	Chocolate	58
82	Green tea	96
82	Chocolate	98
82	Caramel	20
82	Coffee	93
85	Vanilla	40
85	Mint	35
85	Chocolate	59
85	Green tea	2
85	Strawberry	69
85	Coffee	34
85	Caramel	28
86	Mint	93
87	Strawberry	47
87	Green tea	12
87	Chocolate	95
87	Caramel	88
88	Caramel	76
88	Chocolate	83
88	Strawberry	65
88	Coffee	99
89	Caramel	11
89	Green tea	45
89	Strawberry	17
89	Mint	77
89	Coffee	59
90	Strawberry	33
90	Caramel	54
90	Mint	72
90	Green tea	100
90	Vanilla	42
92	Vanilla	17
92	Green tea	9
92	Coffee	30
92	Caramel	28
93	Vanilla	73
93	Coffee	50
93	Green tea	89
93	Caramel	63
94	Green tea	83
94	Coffee	68
94	Strawberry	32
94	Mint	35
94	Caramel	25
94	Vanilla	16
95	Mint	53
95	Strawberry	73
95	Vanilla	8
95	Green tea	53
96	Mint	8
96	Chocolate	38
96	Strawberry	92
96	Coffee	77
96	Green tea	63
96	Caramel	85
96	Vanilla	46
99	Green tea	13
99	Vanilla	2
99	Mint	92
99	Caramel	47
99	Coffee	38
99	Strawberry	45
100	Green tea	41
100	Caramel	98
100	Chocolate	51
100	Mint	31
100	Strawberry	69
100	Coffee	19
101	Caramel	54
101	Chocolate	96
102	Vanilla	75
102	Caramel	71
102	Mint	20
104	Coffee	39
104	Chocolate	93
104	Caramel	48
104	Mint	22
104	Green tea	53
105	Green tea	19
105	Vanilla	54
105	Strawberry	22
105	Mint	55
106	Chocolate	96
106	Vanilla	84
106	Green tea	62
106	Mint	94
107	Strawberry	25
107	Vanilla	76
107	Chocolate	71
107	Green tea	49
107	Mint	93
107	Caramel	87
108	Caramel	72
108	Mint	9
108	Coffee	33
108	Green tea	69
108	Chocolate	86
108	Vanilla	18
109	Vanilla	87
109	Mint	76
109	Chocolate	2
110	Mint	28
110	Strawberry	94
110	Vanilla	72
110	Caramel	96
110	Green tea	98
111	Coffee	69
111	Vanilla	3
111	Strawberry	38
112	Mint	31
112	Caramel	36
112	Vanilla	73
112	Chocolate	63
112	Coffee	89
113	Strawberry	86
113	Vanilla	97
113	Mint	57
114	Green tea	2
114	Vanilla	20
114	Mint	69
114	Caramel	39
114	Coffee	82
114	Strawberry	8
115	Strawberry	18
115	Chocolate	61
115	Green tea	31
115	Mint	43
115	Vanilla	31
115	Caramel	31
116	Caramel	50
116	Mint	7
116	Vanilla	63
116	Strawberry	33
117	Strawberry	67
117	Coffee	47
117	Caramel	24
117	Vanilla	47
117	Green tea	49
117	Chocolate	24
117	Mint	38
118	Green tea	91
118	Chocolate	3
118	Caramel	31
118	Coffee	19
118	Strawberry	15
118	Vanilla	17
119	Strawberry	46
119	Vanilla	99
119	Chocolate	29
119	Mint	80
119	Coffee	22
120	Caramel	62
120	Strawberry	54
120	Mint	84
120	Coffee	32
120	Chocolate	17
121	Coffee	76
121	Caramel	88
121	Vanilla	65
121	Strawberry	40
121	Chocolate	21
121	Mint	68
122	Caramel	56
122	Chocolate	67
122	Coffee	97
122	Green tea	31
122	Strawberry	74
123	Caramel	30
123	Vanilla	96
123	Coffee	5
123	Strawberry	74
123	Mint	69
123	Green tea	16
124	Chocolate	63
124	Caramel	88
124	Coffee	40
124	Strawberry	89
124	Vanilla	74
124	Green tea	77
124	Mint	35
125	Mint	81
125	Coffee	71
125	Caramel	91
125	Vanilla	46
126	Chocolate	99
126	Green tea	79
126	Coffee	63
129	Caramel	35
129	Vanilla	29
129	Strawberry	86
129	Mint	34
129	Green tea	94
130	Chocolate	92
130	Green tea	29
131	Mint	6
131	Chocolate	66
132	Vanilla	80
132	Mint	24
132	Coffee	66
132	Green tea	50
132	Caramel	36
132	Chocolate	71
132	Strawberry	5
133	Vanilla	18
133	Mint	44
133	Chocolate	16
133	Caramel	44
133	Coffee	43
134	Green tea	63
134	Mint	42
134	Strawberry	42
134	Chocolate	2
134	Caramel	61
137	Mint	22
138	Caramel	37
138	Strawberry	4
138	Vanilla	62
138	Coffee	7
138	Mint	54
138	Green tea	6
138	Chocolate	39
139	Strawberry	98
139	Coffee	80
139	Chocolate	8
140	Chocolate	46
140	Mint	21
140	Green tea	83
141	Chocolate	71
141	Coffee	90
141	Caramel	54
141	Mint	19
141	Strawberry	15
141	Vanilla	22
141	Green tea	19
142	Mint	95
142	Strawberry	73
142	Green tea	11
142	Vanilla	7
142	Coffee	23
142	Caramel	37
143	Caramel	65
143	Green tea	83
143	Coffee	85
143	Mint	92
145	Vanilla	47
146	Green tea	23
146	Caramel	50
146	Vanilla	47
146	Coffee	86
146	Mint	36
147	Chocolate	39
147	Vanilla	25
147	Green tea	13
147	Coffee	11
147	Caramel	23
147	Strawberry	91
147	Mint	91
148	Chocolate	98
148	Vanilla	89
148	Strawberry	16
148	Coffee	55
149	Strawberry	13
150	Vanilla	74
150	Green tea	97
151	Green tea	63
151	Mint	18
151	Chocolate	17
152	Vanilla	50
152	Coffee	82
152	Mint	29
152	Chocolate	69
152	Strawberry	27
153	Caramel	71
153	Strawberry	56
153	Vanilla	78
153	Coffee	94
154	Strawberry	39
154	Green tea	88
154	Vanilla	43
154	Coffee	71
154	Mint	49
154	Caramel	13
154	Chocolate	65
155	Caramel	74
155	Chocolate	25
156	Vanilla	58
156	Coffee	37
158	Caramel	71
158	Coffee	30
159	Green tea	2
159	Caramel	98
159	Coffee	62
159	Vanilla	52
159	Chocolate	44
159	Strawberry	17
159	Mint	23
160	Mint	54
160	Caramel	72
160	Vanilla	46
160	Chocolate	63
160	Strawberry	63
160	Coffee	42
160	Green tea	90
161	Green tea	68
161	Strawberry	46
162	Coffee	80
162	Chocolate	99
162	Caramel	17
162	Strawberry	62
162	Vanilla	79
162	Mint	81
162	Green tea	20
163	Green tea	86
163	Strawberry	69
163	Chocolate	82
164	Coffee	45
164	Strawberry	90
164	Caramel	97
164	Green tea	15
164	Chocolate	55
164	Mint	86
165	Coffee	44
165	Green tea	23
166	Chocolate	78
166	Green tea	8
166	Caramel	70
166	Coffee	48
166	Vanilla	52
166	Mint	40
167	Vanilla	90
167	Caramel	18
167	Mint	95
167	Chocolate	81
168	Caramel	42
169	Strawberry	87
169	Vanilla	27
169	Green tea	89
170	Strawberry	65
170	Coffee	50
170	Vanilla	92
170	Caramel	33
170	Green tea	55
171	Coffee	11
171	Green tea	32
171	Chocolate	15
171	Caramel	46
171	Strawberry	65
172	Mint	56
172	Chocolate	8
175	Chocolate	34
175	Coffee	37
175	Caramel	66
175	Mint	78
176	Caramel	83
176	Strawberry	40
179	Coffee	72
181	Strawberry	77
181	Coffee	64
181	Chocolate	94
182	Strawberry	59
183	Strawberry	26
183	Green tea	54
183	Vanilla	53
184	Chocolate	92
184	Coffee	67
185	Strawberry	51
185	Chocolate	53
185	Green tea	28
186	Caramel	68
186	Chocolate	1
187	Vanilla	25
187	Caramel	59
187	Green tea	57
187	Coffee	70
187	Mint	85
188	Caramel	33
188	Green tea	86
188	Coffee	49
189	Mint	52
189	Coffee	68
189	Caramel	43
189	Strawberry	2
189	Chocolate	28
189	Green tea	15
190	Chocolate	94
190	Vanilla	58
190	Caramel	100
190	Strawberry	4
191	Green tea	86
191	Caramel	45
191	Chocolate	61
191	Vanilla	95
191	Coffee	13
192	Strawberry	75
192	Vanilla	43
192	Caramel	15
193	Strawberry	41
193	Coffee	70
193	Caramel	19
194	Caramel	49
194	Vanilla	12
194	Green tea	46
194	Strawberry	50
194	Coffee	3
194	Mint	26
194	Chocolate	12
195	Caramel	69
195	Chocolate	61
195	Vanilla	24
195	Coffee	26
195	Mint	33
196	Strawberry	83
196	Vanilla	79
196	Green tea	20
196	Mint	17
196	Coffee	51
196	Caramel	82
196	Chocolate	62
197	Green tea	35
197	Chocolate	100
197	Vanilla	58
197	Mint	46
197	Coffee	18
197	Caramel	100
198	Chocolate	96
198	Coffee	6
199	Coffee	50
199	Caramel	66
199	Mint	94
199	Vanilla	83
199	Chocolate	55
199	Strawberry	39
200	Chocolate	65
\.

COPY public.stores (id, name, country) FROM stdin;
1	Amet LLP	Saint Barthélemy
2	Fermentum Risus Limited	Chile
3	Duis Elementum Dui Corporation	Kiribati
4	Phasellus Vitae Mauris Incorporated	Ireland
5	Pellentesque Massa Lobortis Institute	Marshall Islands
6	Sodales Nisi Magna PC	Brunei
7	Integer PC	Nepal
8	Feugiat LLP	Iceland
9	Pharetra Nibh Incorporated	Jordan
10	Nec PC	Liechtenstein
11	Ipsum Suspendisse Incorporated	Mali
12	Tempor Consulting	Chad
13	Luctus Curabitur PC	Guinea-Bissau
14	Amet Faucibus Ut Incorporated	Saint Lucia
15	Sapien Consulting	Viet Nam
16	Hendrerit Donec Porttitor Industries	United Arab Emirates
17	Egestas Ligula Nullam Inc.	Lesotho
18	Turpis In Condimentum Industries	Bahrain
19	Ullamcorper Velit In Company	Côte D'Ivoire (Ivory Coast)
20	Ligula Nullam Enim LLC	Sudan
21	Euismod Et Company	Hungary
23	Vitae Odio Sagittis Associates	Estonia
24	A LLP	Haiti
25	Fusce Mi Foundation	Italy
26	Enim Nec LLP	Luxembourg
27	Justo Proin Consulting	Malta
28	Penatibus Et Magnis Foundation	Saint Pierre and Miquelon
29	Leo In Inc.	Chile
30	Integer Eu Lacus Institute	Cameroon
31	Ut Sagittis Lobortis Industries	Mongolia
32	Vitae Dolor Donec Institute	Benin
33	Ut Inc.	Algeria
34	Orci In Incorporated	Micronesia
35	Faucibus Orci Luctus Foundation	Sweden
36	A PC	Croatia
37	Ipsum Sodales Purus Incorporated	Guadeloupe
38	Eu LLC	Madagascar
39	Turpis Egestas Associates	Brunei
40	Non Associates	Turks and Caicos Islands
41	Dui Quis Inc.	Burundi
42	Duis A Industries	Mexico
43	Magna Et Ipsum Consulting	Guinea-Bissau
44	Non Cursus Non Incorporated	Ireland
45	Praesent Eu Dui Foundation	Georgia
46	Eu Nulla Associates	Brazil
47	Proin Vel Foundation	Ethiopia
48	Et Institute	Turkmenistan
49	Accumsan Convallis Institute	Sao Tome and Principe
50	Vel Industries	Montenegro
51	Sit Ltd	Slovenia
52	Eros Nam Associates	Wallis and Futuna
53	Arcu Nunc Inc.	Tonga
54	Consectetuer Mauris Company	Libya
55	Vehicula Risus Foundation	Brazil
56	Pellentesque PC	Guernsey
58	Curabitur Dictum Incorporated	Venezuela
59	Felis Purus Ac Corp.	Sint Maarten
61	Nam Foundation	New Caledonia
62	Ligula Eu Enim Institute	Tokelau
63	Diam Luctus Lobortis Corporation	Thailand
64	Diam Eu Dolor Company	South Africa
65	Risus Odio Corporation	Luxembourg
66	Sagittis Lobortis Consulting	Palau
67	Curabitur Massa LLP	Falkland Islands
68	Amet Consulting	Saint Kitts and Nevis
69	Sed Sapien Nunc Consulting	Jersey
70	Sem Eget Massa LLC	Latvia
71	Et Magnis Dis Industries	Egypt
72	In Hendrerit Consulting	Papua New Guinea
73	Fusce Mollis Industries	Cuba
74	Risus Donec Consulting	Italy
75	Nam Porttitor Scelerisque Inc.	Somalia
76	Sit Institute	Saint Pierre and Miquelon
77	Semper Dui Associates	Rwanda
78	Pellentesque A Corporation	Sierra Leone
79	Quam Vel Sapien Limited	Slovenia
80	Lacinia Company	Saint Barthélemy
81	Quisque Company	Maldives
82	Dapibus Quam Institute	Pakistan
83	Lorem Ipsum Dolor Consulting	France
84	Erat Corp.	Qatar
86	Ipsum Leo Inc.	Malawi
87	Sed Eu Nibh Industries	Portugal
88	Tristique Senectus Et LLC	Solomon Islands
89	Aptent Taciti LLP	Equatorial Guinea
90	At Lacus Quisque Incorporated	Saudi Arabia
91	Varius Et Corp.	Latvia
92	Rutrum Magna Corporation	Syria
93	Dolor Donec Limited	Belgium
94	Duis Institute	Belgium
95	Molestie Limited	New Caledonia
96	Libero Proin Institute	Indonesia
97	Id Ante Nunc Ltd	Kazakhstan
98	A Odio Institute	Syria
99	Vulputate Mauris Sagittis Company	Mexico
100	Facilisis Magna Corporation	Andorra
101	Nisi Magna Foundation	Pitcairn Islands
102	Turpis Non Enim LLP	Senegal
103	Nec Institute	Jersey
104	Semper Nam Tempor Corporation	Morocco
105	Aliquam Enim Consulting	Ethiopia
106	Est Institute	Comoros
107	Sapien Cursus In Company	Malaysia
108	Tempor Consulting	Jersey
109	Ut Dolor Foundation	Bolivia
110	Dolor Corporation	Saint Barthélemy
111	Aliquam LLC	New Caledonia
112	Magna Malesuada Limited	Turkey
113	Cum Sociis Natoque Industries	Cyprus
114	Sem Associates	Fiji
115	Lacus Company	Bangladesh
116	Nisl Sem LLC	Syria
117	Morbi Accumsan Laoreet PC	Côte D'Ivoire (Ivory Coast)
118	Malesuada Fames Associates	Jersey
119	Fusce Mollis Corp.	Mongolia
85	Sed Malesuada Consulting	Indonesia
57	Ultrices Industries	Indonesia
60	Pede Malesuada PC	Indonesia
120	Nisl Nulla Ltd	Guadeloupe
121	Nibh Dolor Company	Wallis and Futuna
122	A Incorporated	Moldova
123	Donec Vitae Institute	San Marino
124	Erat Volutpat Nulla Limited	Lithuania
125	Placerat LLP	Tunisia
126	Facilisi Sed Foundation	El Salvador
127	Nulla Tincidunt Neque Associates	Monaco
128	Eu Accumsan Sed Industries	Lebanon
129	Euismod Mauris LLC	French Southern Territories
130	Ut Cursus Inc.	Singapore
131	Dignissim Corporation	Guam
132	Imperdiet Industries	Burkina Faso
133	Interdum Nunc Incorporated	Estonia
134	Eu Augue Porttitor LLP	Cook Islands
135	Accumsan Interdum Libero PC	Portugal
136	Vivamus Nisi Mauris LLP	Svalbard and Jan Mayen Islands
137	Enim Condimentum Eget Incorporated	Antarctica
138	Aliquet Phasellus Industries	Sweden
139	Erat LLC	Samoa
140	In Scelerisque Corporation	Solomon Islands
141	Mi Consulting	France
142	Diam Pellentesque LLP	Finland
143	Aliquam PC	Togo
144	At Risus Nunc PC	Norfolk Island
145	Massa Mauris Vestibulum Inc.	Tajikistan
146	Nunc Mauris Ltd	Uzbekistan
147	Arcu Aliquam Limited	Slovenia
148	Dictum Phasellus Inc.	Guernsey
149	Phasellus At Augue Ltd	Latvia
150	Luctus Institute	United Arab Emirates
151	Suspendisse Limited	Oman
152	A Corporation	Nicaragua
153	Nam Interdum LLC	Taiwan
154	Ridiculus Mus LLP	South Sudan
155	Consectetuer Cursus Et Institute	Mongolia
156	Fusce Aliquam Industries	Jersey
157	Nulla Limited	Åland Islands
158	Eu Industries	Peru
159	Lectus PC	Northern Mariana Islands
160	Tempus Eu Institute	Bolivia
161	Eget Corporation	Åland Islands
162	Inceptos Hymenaeos Mauris Corporation	Jordan
163	Sed LLC	Tonga
164	Lacus Inc.	Macedonia
165	Ultricies Dignissim Lacus Institute	Saint Vincent and The Grenadines
166	Molestie PC	Chile
167	Odio Corporation	Viet Nam
168	Nunc Quis Limited	Malta
169	Id Erat Consulting	Cape Verde
170	Commodo At Libero Industries	Comoros
171	A Ltd	Burundi
172	Curabitur Egestas Nunc Incorporated	Montenegro
173	Tempus LLC	New Zealand
174	A Enim Institute	Peru
175	Nam Institute	India
176	Non Industries	Eritrea
177	Convallis Dolor Foundation	Swaziland
178	Arcu Sed Et Inc.	Latvia
179	Ac Mattis Velit Foundation	Kuwait
180	Cursus Purus Nullam Inc.	Mozambique
181	Non Hendrerit Id LLP	United States Minor Outlying Islands
182	Libero Corp.	Bermuda
183	Non Lobortis Quis Company	Chile
184	Eget Volutpat Corporation	Costa Rica
185	Erat Semper Rutrum Consulting	Saint Pierre and Miquelon
186	A Nunc In LLC	Namibia
187	Arcu PC	Myanmar
188	Fringilla Est Industries	Montenegro
189	Adipiscing Corp.	United Arab Emirates
190	Iaculis Quis Pede Associates	Nepal
191	Eros Nec PC	Nigeria
192	Rutrum Lorem Institute	Wallis and Futuna
193	Magna A Foundation	Romania
194	Molestie Tellus Industries	Isle of Man
195	Blandit Consulting	American Samoa
196	Donec Tempus Inc.	British Indian Ocean Territory
197	Elit Corporation	Haiti
199	Vitae Aliquet Associates	Cook Islands
200	Lacinia Vitae Sodales Limited	Azerbaijan
198	Mi Duis Corporation	Indonesia
22	Ullamcorper Velit In LLC	United Kingdom
\.

COPY public.users (id, name, country) FROM stdin;
1	Brynn Leon	San Marino
2	Henry Cobb	Turks and Caicos Islands
3	Honorato Matthews	Albania
4	Cody Hyde	Viet Nam
5	Naida Brewer	French Polynesia
6	Candace York	Belarus
7	Bruno Avery	Macedonia
8	Kelly Cole	Bangladesh
9	Morgan Webb	Morocco
10	Urielle Spears	New Zealand
11	Wyoming Christian	Yemen
12	Blair Drake	Åland Islands
13	Martina Nieves	Bulgaria
14	Yvette Everett	Lithuania
15	Daniel Franklin	Germany
16	Anjolie Conway	Lebanon
17	Keely Grant	Cyprus
18	Garrison Knight	Cameroon
19	Brenda Ayers	New Caledonia
20	Octavius Coleman	Cyprus
21	Connor Collins	Yemen
22	Byron Bryant	Tajikistan
23	Raymond Mueller	Pitcairn Islands
24	Neville Kramer	French Polynesia
25	Lamar Blake	Macedonia
26	Maisie Hatfield	Netherlands
27	Keefe Baird	El Salvador
28	Beau Buck	Romania
29	Thomas Gentry	Guernsey
30	Dennis Austin	Romania
31	Ezra Gross	Iraq
32	Tamara Velazquez	Bouvet Island
33	Noelani Stephenson	Tajikistan
34	Wyatt Stout	Cyprus
35	Hector Fitzpatrick	Cayman Islands
36	Uriah Tucker	Kenya
37	Jillian Delgado	Bouvet Island
38	Zia Cox	Belarus
39	Hamish Owens	Madagascar
40	Gisela Barrett	Romania
41	Russell Summers	Iraq
42	Nehru Cain	Virgin Islands, United States
43	Nolan Smith	Benin
44	Bert Erickson	Japan
45	Tyler Francis	India
46	Finn Pruitt	Sao Tome and Principe
47	Ezra Potter	Bonaire, Sint Eustatius and Saba
48	Sierra Buchanan	Czech Republic
49	Joy Wong	Mayotte
50	Echo Mcneil	Guernsey
51	Mikayla Holmes	Oman
52	Amy Hewitt	Israel
53	Barclay Massey	Tajikistan
54	Alisa Weaver	Senegal
55	Jerry Massey	Antarctica
56	Emma Dominguez	Bolivia
57	Bree Erickson	Madagascar
58	Christopher Leon	Poland
59	Lacy Pate	Honduras
60	Lawrence Rocha	United States
61	Shelly Mcdaniel	Belize
62	Acton Pierce	Curaçao
63	Plato Pollard	Slovenia
64	Autumn Keller	Argentina
65	Daquan Mcintyre	Sri Lanka
66	Devin Hebert	Benin
67	Rudyard Rosa	Bulgaria
68	Kibo Lara	Pitcairn Islands
69	Ayanna Moody	Fiji
70	Camden Browning	Barbados
71	Claudia Luna	Montserrat
72	Mechelle Gill	Congo (Brazzaville)
73	Shaine Jensen	Solomon Islands
74	Britanney Sheppard	Saint Barthélemy
75	Randall Kennedy	Colombia
76	Yvette Spencer	Italy
77	Igor Nunez	Venezuela
78	Gary Leach	Somalia
79	Warren Padilla	Saint Kitts and Nevis
80	Rebecca Charles	Indonesia
81	Oren Love	Holy See (Vatican City State)
82	Kamal Martin	Russian Federation
83	Vincent Callahan	Venezuela
84	Carlos Mays	Singapore
85	Yoshi Stanley	Sao Tome and Principe
86	Dennis Beck	Saudi Arabia
87	Fuller Shelton	India
88	Rhiannon Bartlett	Mexico
89	Nita Brewer	Costa Rica
90	Ariana Williams	Afghanistan
91	Celeste Jennings	Kazakhstan
92	Blossom Trevino	Cape Verde
93	Donovan Mooney	Congo (Brazzaville)
94	Keely Sosa	Finland
95	Xantha Garrison	China
96	Ciaran Morrison	Burkina Faso
97	Kessie Matthews	Jamaica
98	Hayden Hamilton	United Kingdom (Great Britain)
99	Lacey Hernandez	Martinique
100	Kenyon Mcpherson	Uganda
\.

SELECT pg_catalog.setval('public.stores_id_seq', 200, true);

SELECT pg_catalog.setval('public.users_id_seq', 100, true);

ALTER TABLE ONLY public.stocks
    ADD CONSTRAINT stocks_pkey PRIMARY KEY (store_id, flavour);

ALTER TABLE ONLY public.stores
    ADD CONSTRAINT stores_pkey PRIMARY KEY (id);

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);

ALTER TABLE ONLY public.stocks
    ADD CONSTRAINT fk_stocks_store_id FOREIGN KEY (store_id) REFERENCES public.stores(id);

--
-- PostgreSQL database dump complete
--