· 10 years ago · Oct 16, 2015, 10:40 AM
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
26SET search_path = public, pg_catalog;
27
28SET default_tablespace = '';
29
30SET default_with_oids = false;
31
32--
33-- Name: events; Type: TABLE; Schema: public; Owner: marina; Tablespace:
34--
35
36CREATE TABLE events (
37 id integer NOT NULL,
38 name character varying,
39 pdf_layout character varying DEFAULT 'pdf'::character varying,
40 pdf_template character varying DEFAULT 'pdf'::character varying,
41 location character varying,
42 start_date date,
43 end_date date,
44 workload integer DEFAULT 0,
45 created_at timestamp without time zone NOT NULL,
46 updated_at timestamp without time zone NOT NULL,
47 slug character varying
48);
49
50
51ALTER TABLE public.events OWNER TO marina;
52
53--
54-- Name: events_id_seq; Type: SEQUENCE; Schema: public; Owner: marina
55--
56
57CREATE SEQUENCE events_id_seq
58 START WITH 1
59 INCREMENT BY 1
60 NO MINVALUE
61 NO MAXVALUE
62 CACHE 1;
63
64
65ALTER TABLE public.events_id_seq OWNER TO marina;
66
67--
68-- Name: events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: marina
69--
70
71ALTER SEQUENCE events_id_seq OWNED BY events.id;
72
73
74--
75-- Name: events_participants; Type: TABLE; Schema: public; Owner: marina; Tablespace:
76--
77
78CREATE TABLE events_participants (
79 id integer NOT NULL,
80 event_id integer,
81 participant_id integer
82);
83
84
85ALTER TABLE public.events_participants OWNER TO marina;
86
87--
88-- Name: events_participants_id_seq; Type: SEQUENCE; Schema: public; Owner: marina
89--
90
91CREATE SEQUENCE events_participants_id_seq
92 START WITH 1
93 INCREMENT BY 1
94 NO MINVALUE
95 NO MAXVALUE
96 CACHE 1;
97
98
99ALTER TABLE public.events_participants_id_seq OWNER TO marina;
100
101--
102-- Name: events_participants_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: marina
103--
104
105ALTER SEQUENCE events_participants_id_seq OWNED BY events_participants.id;
106
107
108--
109-- Name: friendly_id_slugs; Type: TABLE; Schema: public; Owner: marina; Tablespace:
110--
111
112CREATE TABLE friendly_id_slugs (
113 id integer NOT NULL,
114 slug character varying NOT NULL,
115 sluggable_id integer NOT NULL,
116 sluggable_type character varying(50),
117 scope character varying,
118 created_at timestamp without time zone
119);
120
121
122ALTER TABLE public.friendly_id_slugs OWNER TO marina;
123
124--
125-- Name: friendly_id_slugs_id_seq; Type: SEQUENCE; Schema: public; Owner: marina
126--
127
128CREATE SEQUENCE friendly_id_slugs_id_seq
129 START WITH 1
130 INCREMENT BY 1
131 NO MINVALUE
132 NO MAXVALUE
133 CACHE 1;
134
135
136ALTER TABLE public.friendly_id_slugs_id_seq OWNER TO marina;
137
138--
139-- Name: friendly_id_slugs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: marina
140--
141
142ALTER SEQUENCE friendly_id_slugs_id_seq OWNED BY friendly_id_slugs.id;
143
144
145--
146-- Name: participants; Type: TABLE; Schema: public; Owner: marina; Tablespace:
147--
148
149CREATE TABLE participants (
150 id integer NOT NULL,
151 name character varying,
152 email character varying,
153 participation_type character varying,
154 created_at timestamp without time zone NOT NULL,
155 updated_at timestamp without time zone NOT NULL,
156 slug character varying
157);
158
159
160ALTER TABLE public.participants OWNER TO marina;
161
162--
163-- Name: participants_id_seq; Type: SEQUENCE; Schema: public; Owner: marina
164--
165
166CREATE SEQUENCE participants_id_seq
167 START WITH 1
168 INCREMENT BY 1
169 NO MINVALUE
170 NO MAXVALUE
171 CACHE 1;
172
173
174ALTER TABLE public.participants_id_seq OWNER TO marina;
175
176--
177-- Name: participants_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: marina
178--
179
180ALTER SEQUENCE participants_id_seq OWNED BY participants.id;
181
182
183--
184-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: marina; Tablespace:
185--
186
187CREATE TABLE schema_migrations (
188 version character varying NOT NULL
189);
190
191
192ALTER TABLE public.schema_migrations OWNER TO marina;
193
194--
195-- Name: id; Type: DEFAULT; Schema: public; Owner: marina
196--
197
198ALTER TABLE ONLY events ALTER COLUMN id SET DEFAULT nextval('events_id_seq'::regclass);
199
200
201--
202-- Name: id; Type: DEFAULT; Schema: public; Owner: marina
203--
204
205ALTER TABLE ONLY events_participants ALTER COLUMN id SET DEFAULT nextval('events_participants_id_seq'::regclass);
206
207
208--
209-- Name: id; Type: DEFAULT; Schema: public; Owner: marina
210--
211
212ALTER TABLE ONLY friendly_id_slugs ALTER COLUMN id SET DEFAULT nextval('friendly_id_slugs_id_seq'::regclass);
213
214
215--
216-- Name: id; Type: DEFAULT; Schema: public; Owner: marina
217--
218
219ALTER TABLE ONLY participants ALTER COLUMN id SET DEFAULT nextval('participants_id_seq'::regclass);
220
221
222--
223-- Data for Name: events; Type: TABLE DATA; Schema: public; Owner: marina
224--
225
226INSERT INTO events (id, name, pdf_layout, pdf_template, location, start_date, end_date, workload, created_at, updated_at, slug) VALUES (1, 'Rails Girls Macei 2015', 'pdf', 'pdf', 'Senac Poo', '2015-10-02', '2015-10-03', 10, '2015-10-16 10:26:09.631424', '2015-10-16 10:26:09.631424', 'rails-girls-maceio-2015');
227
228
229--
230-- Name: events_id_seq; Type: SEQUENCE SET; Schema: public; Owner: marina
231--
232
233SELECT pg_catalog.setval('events_id_seq', 1, true);
234
235
236--
237-- Data for Name: events_participants; Type: TABLE DATA; Schema: public; Owner: marina
238--
239
240INSERT INTO events_participants (id, event_id, participant_id) VALUES (1, 1, 1);
241INSERT INTO events_participants (id, event_id, participant_id) VALUES (2, 1, 2);
242INSERT INTO events_participants (id, event_id, participant_id) VALUES (3, 1, 3);
243INSERT INTO events_participants (id, event_id, participant_id) VALUES (4, 1, 4);
244INSERT INTO events_participants (id, event_id, participant_id) VALUES (5, 1, 5);
245INSERT INTO events_participants (id, event_id, participant_id) VALUES (6, 1, 6);
246INSERT INTO events_participants (id, event_id, participant_id) VALUES (7, 1, 7);
247INSERT INTO events_participants (id, event_id, participant_id) VALUES (8, 1, 8);
248INSERT INTO events_participants (id, event_id, participant_id) VALUES (9, 1, 9);
249INSERT INTO events_participants (id, event_id, participant_id) VALUES (10, 1, 10);
250INSERT INTO events_participants (id, event_id, participant_id) VALUES (11, 1, 11);
251INSERT INTO events_participants (id, event_id, participant_id) VALUES (12, 1, 12);
252INSERT INTO events_participants (id, event_id, participant_id) VALUES (13, 1, 13);
253INSERT INTO events_participants (id, event_id, participant_id) VALUES (14, 1, 14);
254INSERT INTO events_participants (id, event_id, participant_id) VALUES (15, 1, 15);
255INSERT INTO events_participants (id, event_id, participant_id) VALUES (16, 1, 16);
256INSERT INTO events_participants (id, event_id, participant_id) VALUES (17, 1, 17);
257INSERT INTO events_participants (id, event_id, participant_id) VALUES (18, 1, 18);
258INSERT INTO events_participants (id, event_id, participant_id) VALUES (19, 1, 19);
259INSERT INTO events_participants (id, event_id, participant_id) VALUES (20, 1, 20);
260INSERT INTO events_participants (id, event_id, participant_id) VALUES (21, 1, 21);
261INSERT INTO events_participants (id, event_id, participant_id) VALUES (22, 1, 22);
262INSERT INTO events_participants (id, event_id, participant_id) VALUES (23, 1, 23);
263INSERT INTO events_participants (id, event_id, participant_id) VALUES (24, 1, 24);
264INSERT INTO events_participants (id, event_id, participant_id) VALUES (25, 1, 25);
265INSERT INTO events_participants (id, event_id, participant_id) VALUES (26, 1, 26);
266INSERT INTO events_participants (id, event_id, participant_id) VALUES (27, 1, 27);
267INSERT INTO events_participants (id, event_id, participant_id) VALUES (28, 1, 28);
268INSERT INTO events_participants (id, event_id, participant_id) VALUES (29, 1, 29);
269INSERT INTO events_participants (id, event_id, participant_id) VALUES (30, 1, 30);
270INSERT INTO events_participants (id, event_id, participant_id) VALUES (31, 1, 31);
271INSERT INTO events_participants (id, event_id, participant_id) VALUES (32, 1, 32);
272INSERT INTO events_participants (id, event_id, participant_id) VALUES (33, 1, 33);
273INSERT INTO events_participants (id, event_id, participant_id) VALUES (34, 1, 34);
274INSERT INTO events_participants (id, event_id, participant_id) VALUES (35, 1, 35);
275INSERT INTO events_participants (id, event_id, participant_id) VALUES (36, 1, 36);
276INSERT INTO events_participants (id, event_id, participant_id) VALUES (37, 1, 37);
277INSERT INTO events_participants (id, event_id, participant_id) VALUES (38, 1, 38);
278INSERT INTO events_participants (id, event_id, participant_id) VALUES (39, 1, 39);
279
280
281--
282-- Name: events_participants_id_seq; Type: SEQUENCE SET; Schema: public; Owner: marina
283--
284
285SELECT pg_catalog.setval('events_participants_id_seq', 39, true);
286
287
288--
289-- Data for Name: friendly_id_slugs; Type: TABLE DATA; Schema: public; Owner: marina
290--
291
292
293
294--
295-- Name: friendly_id_slugs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: marina
296--
297
298SELECT pg_catalog.setval('friendly_id_slugs_id_seq', 1, false);
299
300
301--
302-- Data for Name: participants; Type: TABLE DATA; Schema: public; Owner: marina
303--
304
305INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (1, 'Al Sandes Silva', 'ale.sandes@hotmail.com', 'ouvinte', '2015-10-16 10:27:44.695991', '2015-10-16 10:27:44.695991', 'ale-sandes-silva');
306INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (2, 'Alysson Darllan Santos Ferreira Lopes', 'alyssonlopes@yahoo.com', 'ouvinte', '2015-10-16 10:27:44.780337', '2015-10-16 10:27:44.780337', 'alysson-darllan-santos-ferreira-lopes');
307INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (3, 'Ana Letcia Gaia da Rocha Almeida', 'anita.gaia@hotmail.com', 'ouvinte', '2015-10-16 10:27:44.802634', '2015-10-16 10:27:44.802634', 'ana-leticia-gaia-da-rocha-almeida');
308INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (4, 'Andrea Ferreira da Silva Maciel', 'deavidinha@hotmail.it', 'ouvinte', '2015-10-16 10:27:44.824585', '2015-10-16 10:27:44.824585', 'andrea-ferreira-da-silva-maciel');
309INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (5, 'Barbara Ferreira Tenrio Ferreira', 'barbara.tf@hotmail.com', 'ouvinte', '2015-10-16 10:27:44.846482', '2015-10-16 10:27:44.846482', 'barbara-ferreira-tenorio-ferreira');
310INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (6, 'Divane Gomes Loureno da Silva', 'divanegomes19@gmail.com', 'ouvinte', '2015-10-16 10:27:44.869177', '2015-10-16 10:27:44.869177', 'divane-gomes-lourenco-da-silva');
311INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (7, 'Ellen Vitria Silva Ramos de Paula', 'ellen.souza0903@hotmail.com', 'ouvinte', '2015-10-16 10:27:44.891414', '2015-10-16 10:27:44.891414', 'ellen-vitoria-silva-ramos-de-paula');
312INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (8, 'Emylle Chrystinne da Silva Euzbio', 'emylle_chrystinne@outlook.com', 'ouvinte', '2015-10-16 10:27:44.913345', '2015-10-16 10:27:44.913345', 'emylle-chrystinne-da-silva-euzebio');
313INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (9, 'Erica Fernanda Gomes dos Santos', 'ericanandagds@gmail.com', 'ouvinte', '2015-10-16 10:27:44.935935', '2015-10-16 10:27:44.935935', 'erica-fernanda-gomes-dos-santos');
314INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (10, 'Esther Nascimento Soares de Freitas', 'estherdefreitas@gmai.com', 'ouvinte', '2015-10-16 10:27:44.957707', '2015-10-16 10:27:44.957707', 'esther-nascimento-soares-de-freitas');
315INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (11, 'Felipe Oliveira', 'felipe.oliveiradev@gmail.com', 'ouvinte', '2015-10-16 10:27:44.979712', '2015-10-16 10:27:44.979712', 'felipe-oliveira');
316INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (12, 'Gabriely Hariely Silva dos Santos', 'gabriely.hariely@gmail.com', 'ouvinte', '2015-10-16 10:27:45.00238', '2015-10-16 10:27:45.00238', 'gabriely-hariely-silva-dos-santos');
317INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (13, 'Girlayne kelly do nascimemto', 'girlaynelarissa@hotmail.com', 'ouvinte', '2015-10-16 10:27:45.024424', '2015-10-16 10:27:45.024424', 'girlayne-kelly-do-nascimemto');
318INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (14, 'Heloisa Vital Domingos', 'domingos.heloisa@gmail.com', 'ouvinte', '2015-10-16 10:27:45.046416', '2015-10-16 10:27:45.046416', 'heloisa-vital-domingos');
319INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (15, 'Iara de Freitas Correia Matos', 'fliara@hotmail.com', 'ouvinte', '2015-10-16 10:27:45.0689', '2015-10-16 10:27:45.0689', 'iara-de-freitas-correia-matos');
320INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (16, 'Ibirajara Barrel Junior', 'ibirajara.junior@gmail.com', 'ouvinte', '2015-10-16 10:27:45.091237', '2015-10-16 10:27:45.091237', 'ibirajara-barrel-junior');
321INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (17, 'Isabelle Regina de Oliveira Queiroz', 'isabelle_regina13@hotmail.com', 'ouvinte', '2015-10-16 10:27:45.113306', '2015-10-16 10:27:45.113306', 'isabelle-regina-de-oliveira-queiroz');
322INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (18, 'Iuri Melo Barrel', 'iurib11@hotmail.com', 'ouvinte', '2015-10-16 10:27:45.135207', '2015-10-16 10:27:45.135207', 'iuri-melo-barrel');
323INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (19, 'Jeyniglio de Gusmo Correia Matos', 'jeyniglis@outlook.com', 'ouvinte', '2015-10-16 10:27:45.157135', '2015-10-16 10:27:45.157135', 'jeyniglio-de-gusmao-correia-matos');
324INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (20, 'Josiane Silva Placido', 'josymiguel25032015@hotmail.com', 'ouvinte', '2015-10-16 10:27:45.179998', '2015-10-16 10:27:45.179998', 'josiane-silva-placido');
325INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (21, 'Jlia Albuquerque Aguiar', 'julia_aa95@hotmail.com', 'ouvinte', '2015-10-16 10:27:45.201865', '2015-10-16 10:27:45.201865', 'julia-albuquerque-aguiar');
326INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (22, 'Juliana Rosendo Giacomo', 'ju.giacomo@gmail.com', 'ouvinte', '2015-10-16 10:27:45.224117', '2015-10-16 10:27:45.224117', 'juliana-rosendo-giacomo');
327INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (23, 'Kennya Kelly Bezerra Gonzalez', 'kennyakbg@gmail.com', 'ouvinte', '2015-10-16 10:27:45.246074', '2015-10-16 10:27:45.246074', 'kennya-kelly-bezerra-gonzalez');
328INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (24, 'Klyvia Maria Silva Farias de Oliveira', 'klyviafarias@hotmail.com', 'ouvinte', '2015-10-16 10:27:45.268113', '2015-10-16 10:27:45.268113', 'klyvia-maria-silva-farias-de-oliveira');
329INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (25, 'Larissa Gomes Eugnio', 'laryeugenio@gmail.com', 'ouvinte', '2015-10-16 10:27:45.290736', '2015-10-16 10:27:45.290736', 'larissa-gomes-eugenio');
330INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (26, 'Letcia Medeiros', 'leticialeca@hotmail.com', 'ouvinte', '2015-10-16 10:27:45.31259', '2015-10-16 10:27:45.31259', 'leticia-medeiros');
331INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (27, 'Liandra Andreza de Oliveira', 'ela.maceio@hotmail.com', 'ouvinte', '2015-10-16 10:27:45.335605', '2015-10-16 10:27:45.335605', 'liandra-andreza-de-oliveira');
332INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (28, 'Lucas Vicente do Nascimento Borges', 'lucasnsborges@gmail.com', 'ouvinte', '2015-10-16 10:27:45.357397', '2015-10-16 10:27:45.357397', 'lucas-vicente-do-nascimento-borges');
333INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (29, 'Marcia Cristine Gomes de Almeida ', 'mcgata@hotmail.com', 'ouvinte', '2015-10-16 10:27:45.379493', '2015-10-16 10:27:45.379493', 'marcia-cristine-gomes-de-almeida');
334INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (30, 'Maria Louise Teobaldo Almeida Santos ', 'maria_louise_129@hotmail.com', 'ouvinte', '2015-10-16 10:27:45.401596', '2015-10-16 10:27:45.401596', 'maria-louise-teobaldo-almeida-santos');
335INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (31, 'Mateus Barros de Moura Pereira', 'butcraft@gmail.com', 'ouvinte', '2015-10-16 10:27:45.423788', '2015-10-16 10:27:45.423788', 'mateus-barros-de-moura-pereira');
336INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (32, 'Michelly da Conceio Oliveira', 'michellyconnolli@gmail.com', 'ouvinte', '2015-10-16 10:27:45.446192', '2015-10-16 10:27:45.446192', 'michelly-da-conceicao-oliveira');
337INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (33, 'Mirella Francino Lessa Neto Limeira', 'mirellaflimeira@gmail.com', 'ouvinte', '2015-10-16 10:27:45.468143', '2015-10-16 10:27:45.468143', 'mirella-francino-lessa-neto-limeira');
338INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (34, 'Natlia Quintella Malda Lessa', 'nataliaquintella@gmail.com', 'ouvinte', '2015-10-16 10:27:45.49036', '2015-10-16 10:27:45.49036', 'natalia-quintella-malda-lessa');
339INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (35, 'Rosana Patrcia Santos do Vale', 'rosanavale@gmail.com', 'ouvinte', '2015-10-16 10:27:45.512405', '2015-10-16 10:27:45.512405', 'rosana-patricia-santos-do-vale');
340INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (36, 'Thalyssa de Almeida Monteiro', 'thalyssa2.0@hotmail.com', 'ouvinte', '2015-10-16 10:27:45.53487', '2015-10-16 10:27:45.53487', 'thalyssa-de-almeida-monteiro');
341INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (37, 'Valeska Nazario Lopes de Lima', 'valeska.nazariolopes@gmail.com', 'ouvinte', '2015-10-16 10:27:45.556826', '2015-10-16 10:27:45.556826', 'valeska-nazario-lopes-de-lima');
342INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (38, 'Wilka Priscilia de Melo Santos', 'wilka.melo@gmail.com', 'ouvinte', '2015-10-16 10:27:45.578833', '2015-10-16 10:27:45.578833', 'wilka-priscilia-de-melo-santos');
343INSERT INTO participants (id, name, email, participation_type, created_at, updated_at, slug) VALUES (39, 'Wilma Conceio da Silva', 'wilma.c.silva@hotmail.com', 'ouvinte', '2015-10-16 10:27:45.601095', '2015-10-16 10:27:45.601095', 'wilma-conceicao-da-silva');
344
345
346--
347-- Name: participants_id_seq; Type: SEQUENCE SET; Schema: public; Owner: marina
348--
349
350SELECT pg_catalog.setval('participants_id_seq', 39, true);
351
352
353--
354-- Data for Name: schema_migrations; Type: TABLE DATA; Schema: public; Owner: marina
355--
356
357INSERT INTO schema_migrations (version) VALUES ('20150513002848');
358INSERT INTO schema_migrations (version) VALUES ('20150425133924');
359INSERT INTO schema_migrations (version) VALUES ('20150510144602');
360INSERT INTO schema_migrations (version) VALUES ('20150425134520');
361INSERT INTO schema_migrations (version) VALUES ('20150510144704');
362INSERT INTO schema_migrations (version) VALUES ('20150425133947');
363
364
365--
366-- Name: events_participants_pkey; Type: CONSTRAINT; Schema: public; Owner: marina; Tablespace:
367--
368
369ALTER TABLE ONLY events_participants
370 ADD CONSTRAINT events_participants_pkey PRIMARY KEY (id);
371
372
373--
374-- Name: events_pkey; Type: CONSTRAINT; Schema: public; Owner: marina; Tablespace:
375--
376
377ALTER TABLE ONLY events
378 ADD CONSTRAINT events_pkey PRIMARY KEY (id);
379
380
381--
382-- Name: friendly_id_slugs_pkey; Type: CONSTRAINT; Schema: public; Owner: marina; Tablespace:
383--
384
385ALTER TABLE ONLY friendly_id_slugs
386 ADD CONSTRAINT friendly_id_slugs_pkey PRIMARY KEY (id);
387
388
389--
390-- Name: participants_pkey; Type: CONSTRAINT; Schema: public; Owner: marina; Tablespace:
391--
392
393ALTER TABLE ONLY participants
394 ADD CONSTRAINT participants_pkey PRIMARY KEY (id);
395
396
397--
398-- Name: index_events_participants_on_event_id; Type: INDEX; Schema: public; Owner: marina; Tablespace:
399--
400
401CREATE INDEX index_events_participants_on_event_id ON events_participants USING btree (event_id);
402
403
404--
405-- Name: index_events_participants_on_participant_id; Type: INDEX; Schema: public; Owner: marina; Tablespace:
406--
407
408CREATE INDEX index_events_participants_on_participant_id ON events_participants USING btree (participant_id);
409
410
411--
412-- Name: index_friendly_id_slugs_on_slug_and_sluggable_type; Type: INDEX; Schema: public; Owner: marina; Tablespace:
413--
414
415CREATE INDEX index_friendly_id_slugs_on_slug_and_sluggable_type ON friendly_id_slugs USING btree (slug, sluggable_type);
416
417
418--
419-- Name: index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope; Type: INDEX; Schema: public; Owner: marina; Tablespace:
420--
421
422CREATE UNIQUE INDEX index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope ON friendly_id_slugs USING btree (slug, sluggable_type, scope);
423
424
425--
426-- Name: index_friendly_id_slugs_on_sluggable_id; Type: INDEX; Schema: public; Owner: marina; Tablespace:
427--
428
429CREATE INDEX index_friendly_id_slugs_on_sluggable_id ON friendly_id_slugs USING btree (sluggable_id);
430
431
432--
433-- Name: index_friendly_id_slugs_on_sluggable_type; Type: INDEX; Schema: public; Owner: marina; Tablespace:
434--
435
436CREATE INDEX index_friendly_id_slugs_on_sluggable_type ON friendly_id_slugs USING btree (sluggable_type);
437
438
439--
440-- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: marina; Tablespace:
441--
442
443CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);
444
445
446--
447-- Name: fk_rails_0d047d6a82; Type: FK CONSTRAINT; Schema: public; Owner: marina
448--
449
450ALTER TABLE ONLY events_participants
451 ADD CONSTRAINT fk_rails_0d047d6a82 FOREIGN KEY (participant_id) REFERENCES participants(id);
452
453
454--
455-- Name: fk_rails_ddbf4232c8; Type: FK CONSTRAINT; Schema: public; Owner: marina
456--
457
458ALTER TABLE ONLY events_participants
459 ADD CONSTRAINT fk_rails_ddbf4232c8 FOREIGN KEY (event_id) REFERENCES events(id);
460
461
462--
463-- Name: public; Type: ACL; Schema: -; Owner: postgres
464--
465
466REVOKE ALL ON SCHEMA public FROM PUBLIC;
467REVOKE ALL ON SCHEMA public FROM postgres;
468GRANT ALL ON SCHEMA public TO postgres;
469GRANT ALL ON SCHEMA public TO PUBLIC;
470
471
472--
473-- PostgreSQL database dump complete
474--
475
476