-
Notifications
You must be signed in to change notification settings - Fork 1
/
open_mar_db_backup_3-24-15.sql
412 lines (325 loc) · 14 KB
/
open_mar_db_backup_3-24-15.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
--
-- 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: plpgsql; Type: EXTENSION; Schema: -; Owner:
--
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: guests; Type: TABLE; Schema: public; Owner: root; Tablespace:
--
CREATE TABLE guests (
id integer NOT NULL,
invitation_id integer,
title character varying(8),
name character varying(64),
email character varying(128),
is_attending boolean,
is_plusone boolean DEFAULT false NOT NULL,
password character varying(16),
groups character varying(256),
invite_key character varying(8),
allergies character varying(256),
food_pref character varying(256),
total_attending character varying(256),
attending_names character varying(256),
meal character varying(32),
is_attending_brunch boolean DEFAULT true NOT NULL,
CONSTRAINT meal CHECK (((meal)::text = ANY ((ARRAY['vegan'::character varying, 'vegetarian'::character varying, 'none'::character varying])::text[])))
);
ALTER TABLE public.guests OWNER TO root;
--
-- Name: guests_id_seq; Type: SEQUENCE; Schema: public; Owner: root
--
CREATE SEQUENCE guests_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.guests_id_seq OWNER TO root;
--
-- Name: guests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
--
ALTER SEQUENCE guests_id_seq OWNED BY guests.id;
--
-- Name: invitations; Type: TABLE; Schema: public; Owner: root; Tablespace:
--
CREATE TABLE invitations (
id integer NOT NULL,
address text,
rsvpd boolean DEFAULT false NOT NULL,
allow_plusone boolean DEFAULT false NOT NULL,
has_children boolean DEFAULT false NOT NULL
);
ALTER TABLE public.invitations OWNER TO root;
--
-- Name: invitations_id_seq; Type: SEQUENCE; Schema: public; Owner: root
--
CREATE SEQUENCE invitations_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.invitations_id_seq OWNER TO root;
--
-- Name: invitations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
--
ALTER SEQUENCE invitations_id_seq OWNED BY invitations.id;
--
-- Name: migrations; Type: TABLE; Schema: public; Owner: root; Tablespace:
--
CREATE TABLE migrations (
id integer NOT NULL,
name character varying(255) NOT NULL,
run_on timestamp without time zone NOT NULL
);
ALTER TABLE public.migrations OWNER TO root;
--
-- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: root
--
CREATE SEQUENCE migrations_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.migrations_id_seq OWNER TO root;
--
-- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
--
ALTER SEQUENCE migrations_id_seq OWNED BY migrations.id;
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: root
--
ALTER TABLE ONLY guests ALTER COLUMN id SET DEFAULT nextval('guests_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: root
--
ALTER TABLE ONLY invitations ALTER COLUMN id SET DEFAULT nextval('invitations_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: root
--
ALTER TABLE ONLY migrations ALTER COLUMN id SET DEFAULT nextval('migrations_id_seq'::regclass);
--
-- Data for Name: guests; Type: TABLE DATA; Schema: public; Owner: root
--
COPY guests (id, invitation_id, title, name, email, is_attending, is_plusone, password, groups, invite_key, allergies, food_pref, total_attending, attending_names, meal, is_attending_brunch) FROM stdin;
1 1 Mr. Ian & Katya [email protected] \N f Password1 admin ianw \N \N \N \N \N t
2 2 Mark & Miff Koltiska [email protected] \N f 8sl1js family \N \N \N \N \N t
3 3 Monty Miller & Eugene [email protected] \N f x811js family \N \N \N \N \N t
4 4 Jared & Olivia [email protected] \N f 8sk2j friend \N \N \N \N \N t
5 5 John & Sandy Koltiska [email protected] \N f ksk2j friend \N \N \N \N \N t
6 6 Doug & Susan Koltiska [email protected] \N f 8jj2j friend \N \N \N \N \N t
7 7 Kevin Berry [email protected] \N f 8jj772 wedding_party \N \N \N \N \N t
8 8 Ali & Chris [email protected] \N f 86gt72 wedding_party \N \N \N \N \N t
9 9 Will & Chrystal Riley [email protected] \N f 869972 friend \N \N \N \N \N t
10 10 Ryan & Ashley Koltiska [email protected] \N f mys972 friend \N \N \N \N \N t
13 13 Martha & Micheal Nesbit [email protected] \N f 55s9g2 family \N \N \N \N \N t
14 14 Brett & Brooke Fox [email protected] \N f 5us9g2 family \N \N \N \N \N t
15 15 Skip & Mary Serrell [email protected] \N f 57s9g2 family \N \N \N \N \N t
16 16 Grandpop & Gags [email protected] \N f 5aba2 family \N \N \N \N \N t
17 17 Denise & Dennis [email protected] \N f 5aaba2 friend \N \N \N \N \N t
18 18 Martha & Jack Roberts [email protected] \N f 8uaba2 friend \N \N \N \N \N t
19 19 Ed & Michelle Carpenter [email protected] \N f 8ubbba2 family \N \N \N \N \N t
20 20 Scott & Darcy [email protected] \N f 8uasba2 family \N \N \N \N \N t
21 21 Dave Chen [email protected] \N f 8ua22a2 friend \N \N \N \N \N t
22 22 Tom Praderio [email protected] \N f 8unt2a2 friend \N \N \N \N \N t
23 23 Dan Becker [email protected] \N f 8u222a2 friend \N \N \N \N \N t
24 24 Chris Kanitra [email protected] \N f 8uzn2a2 friend \N \N \N \N \N t
25 25 David Cardelli [email protected] \N f 8um72a2 friend \N \N \N \N \N t
26 26 Marcus & Margo Wilkerson [email protected] \N f 8u66a2 friend \N \N \N \N \N t
27 27 Sam & Holly Griffin [email protected] \N f 8ubba2 family \N \N \N \N \N t
28 28 Jeffory Griffin [email protected] \N f 8ubba2 family \N \N \N \N \N t
29 29 Frank & Colleen [email protected] \N f 8ubba2 family \N \N \N \N \N t
30 30 Lindsay Galey [email protected] \N f 8uZZa2 family \N \N \N \N \N t
31 31 Dustin Williams [email protected] \N f 8u88a2 friend \N \N \N \N \N t
32 32 Phil & Ellen Duran [email protected] \N f 8u00a2 wedding_party \N \N \N \N \N t
33 33 Stormy Knight [email protected] \N f 8u00a2 friend \N \N \N \N \N t
34 34 Rob & Sharon Anstead [email protected] \N f 8u00a2 family \N \N \N \N \N t
35 35 James Smith & Family [email protected] \N f 8LL0a2 friend \N \N \N \N \N t
36 36 Payam Banazadeh [email protected] \N f 8II0a2 friend \N \N \N \N \N t
37 37 Ernie Diaz [email protected] \N f 8kma2 friend \N \N \N \N \N t
38 38 Bill & Joanne Sinclair [email protected] \N f 8kjjn2 family \N \N \N \N \N t
39 39 Stacy Kawecki [email protected] \N f 8kuun2 friend \N \N \N \N \N t
40 40 Julie Barron [email protected] \N f 8kumic2 friend \N \N \N \N \N t
41 41 Monique McCullum [email protected] \N f 8ku88c2 family \N \N \N \N \N t
42 42 Marget Davis [email protected] \N f 8ku99c2 family \N \N \N \N \N t
43 43 Sue Bowyer [email protected] \N f 8kuuty2 family \N \N \N \N \N t
44 44 Tony Davis [email protected] \N f 8kuuty2 family \N \N \N \N \N t
45 45 Niles & Patricia Seifert [email protected] \N f 8kTuty2 family \N \N \N \N \N t
46 46 Frankie & JT McSeifert [email protected] \N f 8kTtny2 family \N \N \N \N \N t
47 47 Marisa & Lynne Seifert [email protected] \N f 8kMtny2 family \N \N \N \N \N t
48 48 Moriarty [email protected] \N f 8kMtny2 family \N \N \N \N \N t
49 49 Raichel & Stewart Hankin [email protected] \N f 8kMtnY family \N \N \N \N \N t
50 50 Luke Moriarty [email protected] \N f 8kM7nY family \N \N \N \N \N t
51 51 Tracy Ricker [email protected] \N f 8ke7nY wedding_party \N \N \N \N \N t
52 52 Anita Winegar [email protected] \N f 8k6ynY family \N \N \N \N \N t
54 54 Lisa Black [email protected] \N f 9y6y7Y family \N \N \N \N \N t
56 56 Seneca Lindsey [email protected] \N f 9u887Y friend \N \N \N \N \N t
57 57 Ayoe Buus Hansen [email protected] \N f 9u88uY friend \N \N \N \N \N t
58 58 Drew Jones [email protected] \N f 9u88uY friend \N \N \N \N \N t
59 59 Jake Wolkenhauer [email protected] \N f 9utbuY friend \N \N \N \N \N t
60 60 Jonathan Nickerson [email protected] \N f 4NbuY friend \N \N \N \N \N t
61 61 Juliet McGraw [email protected] \N f 4Nb6uY friend \N \N \N \N \N t
62 62 John & Tiffany Braitsch [email protected] \N f 4UM6uY friend \N \N \N \N \N t
63 63 Holly Curatolo [email protected] \N f 4U66uY friend \N \N \N \N \N t
64 64 Kevin Owen [email protected] \N f 3e66uY friend \N \N \N \N \N t
65 65 David Sebastian [email protected] \N f 3e66UU friend \N \N \N \N \N t
66 66 Rachel Kroodsma [email protected] \N f 3eTgUU friend \N \N \N \N \N t
67 67 Chris LeDoux [email protected] \N f 3eT66U friend \N \N \N \N \N t
68 68 JT & Melissa [email protected] \N f 3eTybU friend \N \N \N \N \N t
69 69 Celena Byers [email protected] \N f 3eTyMM friend \N \N \N \N \N t
70 70 Jesse Grosinger [email protected] \N f 3eAAmM friend \N \N \N \N \N t
71 71 Ryan Abell [email protected] \N f 3eUMmM friend \N \N \N \N \N t
74 72 Joelle Tjahjadi [email protected] \N f 3e77mM friend \N \N \N \N \N t
53 53 Nicole Black [email protected] \N f 9y6ynY family \N \N \N \N \N t
55 55 Sasha Carter [email protected] \N f 9umy7Y friend \N \N \N \N \N t
12 12 Henry & Holly Wendt [email protected] \N f 55suy2 family \N \N \N \N \N t
11 11 Nancy Cushing & Bob Evans [email protected] \N f 55s972 family \N \N \N \N \N t
\.
--
-- Name: guests_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
--
SELECT pg_catalog.setval('guests_id_seq', 74, true);
--
-- Data for Name: invitations; Type: TABLE DATA; Schema: public; Owner: root
--
COPY invitations (id, address, rsvpd, allow_plusone, has_children) FROM stdin;
1 [email protected] f f f
2 [email protected] f f f
3 [email protected] f f f
4 [email protected] f f f
5 [email protected] f f f
6 [email protected] f f f
7 [email protected] f f f
8 [email protected] f f f
9 [email protected] f f f
10 [email protected] f f f
11 [email protected] f f f
12 [email protected] f f f
13 [email protected] f f f
14 [email protected] f f f
15 [email protected] f f f
16 [email protected] f f f
17 [email protected] f f f
18 [email protected] f f f
19 [email protected] f f f
20 [email protected] f f f
21 [email protected] f f f
22 [email protected] f f f
23 [email protected] f f f
24 [email protected] f f f
25 [email protected] f f f
26 [email protected] f f f
27 [email protected] f f f
28 [email protected] f f f
29 [email protected] f f f
30 [email protected] f f f
31 [email protected] f f f
32 [email protected] f f f
33 [email protected] f f f
34 [email protected] f f f
35 [email protected] f f f
36 [email protected] f f f
37 [email protected] f f f
38 [email protected] f f f
39 [email protected] f f f
40 [email protected] f f f
41 [email protected] f f f
42 [email protected] f f f
43 [email protected] f f f
44 [email protected] f f f
45 [email protected] f f f
46 [email protected] f f f
47 [email protected] f f f
48 [email protected] f f f
49 [email protected] f f f
50 [email protected] f f f
51 [email protected] f f f
52 [email protected] f f f
53 [email protected] f f f
54 [email protected] f f f
55 [email protected] f f f
56 [email protected] f f f
57 [email protected] f f f
58 [email protected] f f f
59 [email protected] f f f
60 [email protected] f f f
61 [email protected] f f f
62 [email protected] f f f
63 [email protected] f f f
64 [email protected] f f f
65 [email protected] f f f
66 [email protected] f f f
67 [email protected] f f f
68 [email protected] f f f
69 [email protected] f f f
70 [email protected] f f f
71 [email protected] f f f
72 [email protected] f f f
\.
--
-- Name: invitations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
--
SELECT pg_catalog.setval('invitations_id_seq', 72, true);
--
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: root
--
COPY migrations (id, name, run_on) FROM stdin;
1 20130203063826-add-invitations-table 2014-03-24 19:34:35.123
2 20130203075859-add-guests-table 2014-03-24 19:34:35.158
3 20130218030808-alter-tables-non-null-booleans 2014-03-24 19:34:35.171
4 20130504215230-alter-invitations-rename-rsvp-col 2014-03-24 19:34:35.175
5 20130715165319-alter-invitations-remove-send-paper-col 2014-03-24 19:34:35.189
6 20130726221054-alter-guests-add-meal-col 2014-03-24 19:34:35.194
7 20130915195205-alter-guests-add-is-attending-brunch-col 2014-03-24 19:34:35.214
\.
--
-- Name: migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
--
SELECT pg_catalog.setval('migrations_id_seq', 7, true);
--
-- Name: guests_pkey; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace:
--
ALTER TABLE ONLY guests
ADD CONSTRAINT guests_pkey PRIMARY KEY (id);
--
-- Name: invitations_pkey; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace:
--
ALTER TABLE ONLY invitations
ADD CONSTRAINT invitations_pkey PRIMARY KEY (id);
--
-- Name: migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace:
--
ALTER TABLE ONLY migrations
ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);
--
-- Name: guests_invitation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: root
--
ALTER TABLE ONLY guests
ADD CONSTRAINT guests_invitation_id_fkey FOREIGN KEY (invitation_id) REFERENCES invitations(id);
--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
--
-- PostgreSQL database dump complete
--