· 10 years ago · Sep 23, 2016, 08:56 AM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.5.1
6-- Dumped by pg_dump version 9.5.0
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET client_encoding = 'UTF8';
11SET standard_conforming_strings = on;
12SET check_function_bodies = false;
13SET client_min_messages = warning;
14SET row_security = off;
15
16--
17-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
18--
19
20CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
21
22
23--
24-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
25--
26
27COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
28
29
30SET search_path = public, pg_catalog;
31
32SET default_tablespace = '';
33
34SET default_with_oids = false;
35
36--
37-- Name: events; Type: TABLE; Schema: public; Owner: adam
38--
39
40CREATE TABLE events (
41 id integer NOT NULL,
42 name character varying,
43 startdate timestamp with time zone,
44 format character varying,
45 notes character varying
46);
47
48
49ALTER TABLE events OWNER TO adam;
50
51--
52-- Name: events_id_seq; Type: SEQUENCE; Schema: public; Owner: adam
53--
54
55CREATE SEQUENCE events_id_seq
56 START WITH 1
57 INCREMENT BY 1
58 NO MINVALUE
59 NO MAXVALUE
60 CACHE 1;
61
62
63ALTER TABLE events_id_seq OWNER TO adam;
64
65--
66-- Name: events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: adam
67--
68
69ALTER SEQUENCE events_id_seq OWNED BY events.id;
70
71
72--
73-- Name: logins; Type: TABLE; Schema: public; Owner: adam
74--
75
76CREATE TABLE logins (
77 loginid character varying NOT NULL,
78 pass character varying
79);
80
81
82ALTER TABLE logins OWNER TO adam;
83
84--
85-- Name: participants; Type: TABLE; Schema: public; Owner: adam
86--
87
88CREATE TABLE participants (
89 id bigint,
90 eventid integer NOT NULL,
91 placement integer
92);
93
94
95ALTER TABLE participants OWNER TO adam;
96
97--
98-- Name: participants_eventid_seq; Type: SEQUENCE; Schema: public; Owner: adam
99--
100
101CREATE SEQUENCE participants_eventid_seq
102 START WITH 1
103 INCREMENT BY 1
104 NO MINVALUE
105 NO MAXVALUE
106 CACHE 1;
107
108
109ALTER TABLE participants_eventid_seq OWNER TO adam;
110
111--
112-- Name: participants_eventid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: adam
113--
114
115ALTER SEQUENCE participants_eventid_seq OWNED BY participants.eventid;
116
117
118--
119-- Name: users; Type: TABLE; Schema: public; Owner: adam
120--
121
122CREATE TABLE users (
123 id bigint NOT NULL,
124 firstname character varying,
125 lastname character varying,
126 email character varying,
127 faculty character varying,
128 questid character varying,
129 paid boolean,
130 created date DEFAULT ('now'::text)::date
131);
132
133
134ALTER TABLE users OWNER TO adam;
135
136--
137-- Name: id; Type: DEFAULT; Schema: public; Owner: adam
138--
139
140ALTER TABLE ONLY events ALTER COLUMN id SET DEFAULT nextval('events_id_seq'::regclass);
141
142
143--
144-- Name: eventid; Type: DEFAULT; Schema: public; Owner: adam
145--
146
147ALTER TABLE ONLY participants ALTER COLUMN eventid SET DEFAULT nextval('participants_eventid_seq'::regclass);
148
149
150--
151-- Data for Name: events; Type: TABLE DATA; Schema: public; Owner: adam
152--
153
154COPY events (id, name, startdate, format, notes) FROM stdin;
1551 Clubs Day 2016-09-22 00:00:00-04 Clubs Start: 10:00 AM
156\.
157
158
159--
160-- Name: events_id_seq; Type: SEQUENCE SET; Schema: public; Owner: adam
161--
162
163SELECT pg_catalog.setval('events_id_seq', 1, true);
164
165
166--
167-- Data for Name: logins; Type: TABLE DATA; Schema: public; Owner: adam
168--
169
170COPY logins (loginid, pass) FROM stdin;
171pokeradmin $2a$10$f205Lijh1rULutiTjDIwgue67WizUuLy5q8MilF6nK6c9EDJcj.Bm
172\.
173
174
175--
176-- Data for Name: participants; Type: TABLE DATA; Schema: public; Owner: adam
177--
178
179COPY participants (id, eventid, placement) FROM stdin;
18020466620 1 \N
181\.
182
183
184--
185-- Name: participants_eventid_seq; Type: SEQUENCE SET; Schema: public; Owner: adam
186--
187
188SELECT pg_catalog.setval('participants_eventid_seq', 1, false);
189
190
191--
192-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: adam
193--
194
195COPY users (id, firstname, lastname, email, faculty, questid, paid, created) FROM stdin;
19620466620 Adam Rafeek arafeek@uwaterloo.ca Mathematics arafeek t 2016-09-19
19720654164 Bryan Qiang qiangbryan@gmail.com \N \N f 2016-09-22
19820518049 Edmund Chu Chu.edmund@yahoo.ca \N \N f 2016-09-22
19920656393 Laindon Burnett Laindon.burnett@gmail.com \N \N f 2016-09-22
20020664155 Soham Suvarnkar soham.2019@gmail.com \N \N f 2016-09-22
20120668738 Daniel Lin dlin980322@gmail.com \N \N f 2016-09-22
20220654103 Jonathan Chow jdhchow@uwaterloo.ca \N \N f 2016-09-22
20320675735 Aaron Levant chbdtyy@gmail.com \N \N f 2016-09-22
20420287406 sebastian lamprea js_lamprea@hotmail.com \N \N f 2016-09-22
20520338821 Lisa O'Brien lisaobrien2009@hotmail.com \N \N f 2016-09-22
20620677611 Bob Zhang bob.zhang.333@gmail.com \N \N f 2016-09-22
20720516178 Brad Wang bradwang9999@hotmail.com \N \N f 2016-09-22
20820559482 Nikhil Goyal n5goyal@uwaterloo.ca \N \N f 2016-09-22
20920601949 Arjun Sivaloganathan a3sivalo@uwaterloo.ca \N \N f 2016-09-22
21020674706 Nathan Tio nathanieltio@hotmail.com \N \N f 2016-09-22
21120671115 Hennadiy Markov hennadiy1998@gmail.com \N \N f 2016-09-22
21220682197 Reuben McCleary reubenm@bell.net \N \N f 2016-09-22
21320527837 Andrew Kim jj27kim@uwaterloo.ca \N \N f 2016-09-22
21420621304 Ryan Soares soar5120@myaurier.ca \N \N f 2016-09-22
21520620337 Chris Chiu c44chiu@uwaterloo.ca \N \N f 2016-09-22
21620569009 Jai Rajan jrajan@uwaterloo.ca \N \N f 2016-09-22
21720588369 Ho kane ky7ho@uwaterloo.ca \N \N f 2016-09-22
21820510307 Deep Morjaria dmorjari@uwaterloo.ca \N \N f 2016-09-22
21920563856 Mohammad Ahmad m54ahmad@uwaterloo.ca \N \N f 2016-09-22
22020628888 Kevin Hua k5hua@uwaterloo.ca \N \N f 2016-09-22
22120561150 arun Mahanathan mahanathana@gmail.com \N \N t 2016-09-22
22220667645 Sam Wong s225wong@uwaterloo.ca \N \N f 2016-09-22
22320521923 laura macdonald laura_macdonald@hotmail.com \N \N t 2016-09-22
22420459899 Jacky He zf2he@uwaterloo.ca \N \N f 2016-09-22
22520671833 Shengbo Jia s22jia@uwaterloo.ca \N \N f 2016-09-22
22620659044 Isabel Lim ijlim@uwaterloo.ca \N \N f 2016-09-22
22720613990 kefei su kefeisu@gmail.com \N \N f 2016-09-22
22820669863 In Tae Baik itbaik@uwaterloo.ca \N \N f 2016-09-22
22920691075 Yudhistira Hamijoyo yhamijoy@uwaterloo.ca \N \N f 2016-09-22
23020695324 Carter Zhao j286zhao@uwaterloo.ca \N \N f 2016-09-22
23120616020 Matthew Lourenco mlourenc@uwaterloo.ca \N \N f 2016-09-22
23220522041 Taher Rehmanji trehmanj@uwaterloo.ca \N \N f 2016-09-22
23320518731 Quang Vo qmvo@uwaterloo.ca \N \N f 2016-09-22
23420631551 Simran Bhatti sbhatti1997@live.com \N \N f 2016-09-22
23520604522 Sam Gatchene samantha.gatchene@hotmail.com \N \N f 2016-09-22
23620569038 arnab sarker primor.arnab@gmail.com \N \N f 2016-09-22
23720534230 jimmy pham j22pham@uwaterloo.ca \N \N f 2016-09-22
23820484280 Andrew Yoon andrew_yoon4029@hotmail.com \N \N f 2016-09-22
23920677403 Nikolas Avsenik nikavsenik@gmail.com \N \N f 2016-09-22
24020684227 melissa Tran melissais@hotmail.com \N \N f 2016-09-22
24120692937 Mason Lau y2247liu@uwaterloo.ca \N \N f 2016-09-22
24220681515 Zac Van Oosten zacharyvanoosten@gmail.com \N \N f 2016-09-22
24320680922 Noah Daudlin daudlinnoah@gmail.com \N \N f 2016-09-22
24420674864 Edmund Su gjsu@edu.uwaterloo.ca \N \N f 2016-09-22
24520640838 Sasha Nayar sashanayar1@gmail.com \N \N t 2016-09-22
24620497559 Deniz Dogan tddogan@uwaterloo.ca \N \N f 2016-09-22
24720651521 waqas khan waqaskhan696@gmail.com \N \N f 2016-09-22
24820457394 Simon Lacoste slacoste5@gmail.com \N \N t 2016-09-22
24920650970 shing wong sy9wong@uwaterloo.ca \N \N f 2016-09-22
25020571046 Lance Baldonado labaldon@uwaterloo.ca \N \N f 2016-09-22
25120623364 David Radzikovsky dradziko@uwaterloo.ca \N \N f 2016-09-22
25220651136 Alan Gortchakov agortcha@uwaterloo.ca \N \N f 2016-09-22
25320385665 Jobanjot Sidhu j4sidhu@uwaterloo.ca \N \N f 2016-09-22
25420370338 Allen Lin alin@uwaterloo.ca \N \N f 2016-09-22
25520664385 Tyler Gaunr tsgaunt@uwaterloo.ca \N \N t 2016-09-22
25620695495 Anamaya Garodia anamaya.garodia@gmail.com \N \N f 2016-09-22
25720578911 Viola Shen violayuwei@gmail.com \N \N f 2016-09-22
25820673898 Hasan Ahmed sh2ahmed@edu.uwaterloo.ca \N \N f 2016-09-22
25920669855 Jonathan Wong hf2wong@edu.uwaterloo.ca \N \N f 2016-09-22
26020654590 Timothy Wong timothy.wong197@gmail.com \N \N f 2016-09-22
26120671719 Gerald Wang geraldwang56@yahoo.ca \N \N f 2016-09-22
26220658229 Victor Z candy74657465@gmail.com \N \N f 2016-09-22
26320460336 Dylan Arena dylanarena57@gmail.com \N \N f 2016-09-22
26420621003 Yaoyu Liu y854liu@uwaterloo.ca \N \N f 2016-09-22
26520683865 Iris Wu w89wu@uwaterloo.ca \N \N f 2016-09-22
26620634084 David Turner db2turne@uwaterloo.ca \N \N f 2016-09-22
26720616315 Nicole Tran n.tran@outlook.com \N \N f 2016-09-22
26820618808 Amy Zhou yj3zhou@uwaterloo.ca \N \N f 2016-09-22
26920567265 Oscar Leung oleung96@gmail.com \N \N t 2016-09-22
27020624782 Nathan D'souza nathan.m.dsouza@gmail.com \N \N f 2016-09-22
27120677955 Wes Moyer westleym08@gmail.com \N \N f 2016-09-22
27220516566 Joshua Bauman jwbauman@uwaterloo.ca \N \N t 2016-09-22
27320569929 Zihao Zhang zzh8829@gmail.com \N \N f 2016-09-22
27420533101 Karan Sindhwani kksindhw@uwaterloo.ca \N \N t 2016-09-22
27520683997 wajih shah shah.wajiha@hotmail.com \N \N f 2016-09-22
27620573526 Viet Pham viet.pham.2929@gmail.com \N \N t 2016-09-22
27720486562 Allan Wong allanwong3333@gmail.com \N \N f 2016-09-22
27820521483 Keharan Puvanenthiran ketharan_15@hotmail.com \N \N f 2016-09-22
27920609749 Atom Luo qhluo@uwaterloo.ca \N \N f 2016-09-22
28020611147 Aysegul Alpay aalpay@uwaterloo.ca \N \N f 2016-09-22
28120607421 Eli Levinson elilevinson97@gmail.com \N \N f 2016-09-22
28220579510 Constantijn Dinklo cos.dinklo@gmail.com \N \N f 2016-09-22
28320661293 Jacky Zhu jackzyc1997@gmail.com \N \N f 2016-09-22
28420525391 Jonathan Huynh j42huynh@uwaterloo.ca \N \N f 2016-09-22
28520692059 Soumil Shah soumilshah98@gmail.com \N \N f 2016-09-22
28620650255 james Zhang jameszhang14@outlook.com \N \N f 2016-09-22
28720662907 Neil Kothari neilkothari98@gmail.com \N \N f 2016-09-22
28820669782 Michael Chen michaelluchen1998@gmail.com \N \N f 2016-09-22
28920693699 Jedri de Luna jedri_deluna@live.com \N \N f 2016-09-22
29020696964 Fangren Yu f37yu@uwaterloo.ca \N \N f 2016-09-22
29120696525 Kumail Jaffer kjaffer7@gmail.com \N \N f 2016-09-22
29220474173 Jubin Mathew jtmathew@uwaterloo.ca \N \N t 2016-09-22
29320613433 Rohit Das r8das@uwaterloo.ca \N \N t 2016-09-22
29420693202 Talha Suboor mtsuboor@uwaterloo.ca \N \N f 2016-09-22
29520658748 Richard Fu richard.0125@hotmail.com \N \N t 2016-09-22
29620673489 Steven Lin stevenlin266@hotmail.com \N \N f 2016-09-22
29720437654 Reh Lakhani reh_1713@hotmail.com \N \N f 2016-09-22
29820671022 Zijun Yu z94yu@edu.uwaterloo.ca \N \N f 2016-09-22
29920679806 Yihan Lan y8lan@edu.uwaterloo.ca \N \N f 2016-09-22
30020634499 Kazem Izadi mkizadin@uwaterloo.ca \N \N t 2016-09-22
30120437444 Tommy Nguyen t67nguye@uwaterloo.ca \N \N f 2016-09-22
30220689938 Nathan Knight n2knight@uwaterloo.ca \N \N f 2016-09-22
30320693706 Yawar Ahnad yawaraziz91@hotmail.com \N \N f 2016-09-22
30420508106 sebastian Djie stsdjie@uwaterloo.ca \N \N f 2016-09-22
30520676853 carolina romero carolina.pr.la@hotmail.com \N \N f 2016-09-22
30620670765 Jason Pan pan.jason.1998@gmail.com \N \N t 2016-09-22
30720668321 Timmy Wen timmythwen@hotmail.com \N \N f 2016-09-22
30820662073 Jacob Matsui jacobmatsui98@gmail.com \N \N f 2016-09-22
30920665754 Evan Pai zwerewere@gmail.com \N \N f 2016-09-22
31020669988 Luke Agnel luke_agnel@hotmail.com \N \N f 2016-09-22
31120664273 Grace Guo grace.xt.guo@hotmail.com \N \N f 2016-09-22
31220665741 arbaaz syed arbaazshakeel101@gmail.com \N \N f 2016-09-22
31320694111 Terry Mao x9mao@uwaterloo.ca \N \N f 2016-09-22
31420474761 ankit joshi as3joshi@uwaterloo.ca \N \N f 2016-09-22
31520461982 Ryan Beatty rcbeatty@uwaterloo.ca \N \N f 2016-09-22
31620566326 kevin Van Dam kevandam19@gmail.com \N \N f 2016-09-22
31720668779 Charles Zhang hc2zhang@edu.uwaterloo.ca \N \N f 2016-09-22
31820655332 Kaarthic Pulogarajah kpulogar@uwaterloo.ca \N \N f 2016-09-22
31920580889 Riley Stone r2stone@uwaterloo.ca \N \N t 2016-09-22
32020650634 Austin Young azzy6105@gmail.com \N \N f 2016-09-22
32120608545 Sharon Chan sharon851226@hotmail.com \N \N f 2016-09-22
32220654108 Zihan LI zihan.li@hotmail.com \N \N f 2016-09-22
32320661580 Jason Li j774li@uwaterloo.ca \N \N f 2016-09-22
32420632897 jimmy chu rjchu@uwaterloo.ca \N \N f 2016-09-22
32520662922 hobin kang hb2kang@uwaterloo.ca \N \N f 2016-09-22
32620659628 michael Cai z46cai@uwaterloo.ca \N \N f 2016-09-22
32720657716 Colin Marsch cjpmarsc@uwaterloo.ca \N \N f 2016-09-22
32820691786 Sean Lee seanlee237@hotmail.com \N \N f 2016-09-22
32920498998 Ben Davis bmdmedia7@gmail.com \N \N f 2016-09-22
33020666825 Mateo Djuric mateo22@live.ca \N \N f 2016-09-22
33120522391 Keerthan Keerthisingham k2keerth@uwaterloo.ca \N \N f 2016-09-22
33220625101 Billy Liu z376liu@uwaterloo.ca \N \N f 2016-09-22
33320607690 Genesius Julian Muljadi gjmuljad@uwaterloo.ca \N \N t 2016-09-22
33420640146 Daniyal Ali daniyal.ali96@hotmail.com \N \N f 2016-09-22
33520662316 Ryan Karumanchery rtkaruma@uwaterloo.ca \N \N f 2016-09-22
33620662402 Tiger Li h459li@uwaterloo.ca \N \N f 2016-09-22
33720651375 Steven Vallejo sdvallej@uwaterloo.ca \N \N f 2016-09-22
33820660484 Christian Alvarez ca2alvar@uwaterloo.ca \N \N f 2016-09-22
33920472744 Fahad Al Zaman falzaman@uwaterloo.ca \N \N t 2016-09-22
34020561608 Gerry Shebib gmshebib@uwaterloo.ca \N \N f 2016-09-22
34120675382 Terri White tnwhite@edu.uwaterloo.ca \N \N f 2016-09-22
34220393833 Kai Jiang k3jiang@uwaterloo.ca \N \N f 2016-09-22
34320523269 Aniket Gaikwad aniket.gee@gmail.com \N \N f 2016-09-22
34420689618 Gabe Madrid gabe.mad1997@gmail.com \N \N f 2016-09-22
34520674295 Wesley Leung wesley.leung06@gmail.com \N \N f 2016-09-22
34620678839 Eamonn Ye eamonnye@hotmail.com \N \N f 2016-09-22
3472269728890 Edison Wang k236wang@uwaterloo.ca \N \N f 2016-09-22
34820673053 Terry Huang terryhuang7266@hotmail.com \N \N f 2016-09-22
34920509864 Betty Zhang by9zhang@uwaterloo.ca \N \N f 2016-09-22
35020544605 Bob Qin y37qin@gmail.com \N \N f 2016-09-22
35120509653 Austin Wong austin.wong@hotmail.com \N \N f 2016-09-22
35220561949 Art Tsai tsaiarttsaiart@hotmail.com \N \N f 2016-09-22
35320656081 Ali Toyserkani ali.toyserkani1998@gmail.com \N \N f 2016-09-22
35420664279 tony wang whao83@yahoo.com \N \N f 2016-09-22
35520687873 Yvan Soetarman yvancs@gmail.com \N \N f 2016-09-22
35620677342 Neethan Balaventhan neethan.bala@gmail.com \N \N f 2016-09-22
35720562325 Peggy Zou pzou@uwaterloo.ca \N \N f 2016-09-22
35820585876 Alban Kaltani v2alban@gmail.com \N \N f 2016-09-22
35920521842 Daniel Bergin daniel.bergin56@gmail.com \N \N f 2016-09-22
36020473076 Chun Li c269li@uwaterloo.ca \N \N f 2016-09-22
36120668764 Matthew Lam matthew98lam@gmail.com \N \N f 2016-09-22
36220669428 Ashoke Mohanraj c2rm@hotmail.com \N \N f 2016-09-22
36320426932 Hassaan Maan hassaanmaan@hotmail.com \N \N f 2016-09-22
36420381821 Chris Hong chong@uwaterloo.ca \N \N f 2016-09-22
36520680892 Apaar Madan apaar186@gmail.com \N \N f 2016-09-22
36620668326 Aiden Yin akyin@edu.uwaterloo.ca \N \N f 2016-09-22
36720674124 Michelle Dang mbdang@uwaterloo.ca \N \N f 2016-09-22
36820580896 Brandon Keobounma brandon_keo@hotmail.com \N \N f 2016-09-22
36920678020 Zaeem Patel zaeemp@gmail.com \N \N f 2016-09-22
37020654045 Zack Kellar zackkellar19@hotmail.com \N \N f 2016-09-22
37120658857 Deb Dutta debarghya31@gmail.com \N \N f 2016-09-22
37220377013 Dennis Au dennisau@live.ca \N \N f 2016-09-22
37320667032 Celina Tang h54tang@uwaterloo.ca \N \N f 2016-09-22
37420578894 Ayush \N 29venka@uwaterloo.ca \N \N f 2016-09-22
37520666199 Kevin Zhang kzzhang@uwaterloo.ca \N \N f 2016-09-22
37620516395 Derek taylor ddtaylor@uwaterloo.ca \N \N t 2016-09-22
37720681599 Kiyan Ladha kiyanl@rogers.com \N \N f 2016-09-22
37820653113 Bonnie Xu bonnie.xuu@gmail.com \N \N f 2016-09-22
37920664265 Ryan Wong r53wong@edu.uwaterlooca \N \N f 2016-09-22
38020614905 monish bhambhani mbhambha@uwaterloo.ca \N \N f 2016-09-22
38120510442 Tian li tianshili@live.ca \N \N t 2016-09-22
38220673139 vytas matulis vamatuli@uwaterloo.ca \N \N f 2016-09-22
38320655192 Huandong Cao h23cao@uwaterloo.ca \N \N f 2016-09-22
38420563736 Kokul Subendran ksubendr@uwaterloo.ca \N \N f 2016-09-22
38520654731 shuang Tan 1302446255@qq.com \N \N f 2016-09-22
38620479749 ang zhu zhuangpitt@gmail.com \N \N f 2016-09-22
38720668577 Neil Dickinson nsdickin@uwaterloo.ca \N \N f 2016-09-22
38820653950 Aiden Benner aiden.benner@gmail.com \N \N f 2016-09-22
38920694015 Sajjad Zamani zamanisz97@gmail.com \N \N f 2016-09-22
39020533225 Vlad Artym Vlad_artym@live.ca \N \N f 2016-09-22
39120561346 suhho kim sh66kim@uwaterloo.ca \N \N f 2016-09-22
39220560019 Imthiaz Syed siasyeda@uwaterloo.ca \N \N f 2016-09-22
39320679752 talha balaventhan timmylu0612@gmail.com \N \N f 2016-09-22
39420679983 Tarun Batra tarun.batra@uwaterloo.ca \N \N f 2016-09-22
39520676855 Fahad Salman fahadsalman99@gmail.com \N \N f 2016-09-22
39620663074 Shana Li ss7li@uwaterloo.a \N \N f 2016-09-22
39720694146 \\jackson Lau jackson574684@gmail.com \N \N f 2016-09-22
39820570180 Zifan Zhang \N \N \N f 2016-09-22
39920653191 June Xu hqxu@uwatterloo.ca \N \N f 2016-09-22
40020667352 Yevhenii Syvytskyi ysyvytsk@uwaterloo.ca \N \N t 2016-09-22
40120680386 Andy Chang cy7chang@uwaterloo.ca \N \N f 2016-09-22
40220608198 Ansen On acon@uwaterloo.ca \N \N f 2016-09-22
40320465234 Kajeeban Raja k2rajali@uwaterloo.ca \N \N f 2016-09-22
40420512079 Maggie Gao maggie0-0@hotmail.com \N \N f 2016-09-22
40520682708 David Jiang d33jiang@edu.uwaterloo.ca \N \N f 2016-09-22
40620692747 Martin Mihaylov martin.mihaylov@uwaterloo.ca \N \N f 2016-09-22
40720669839 Hanvid Lee hanvidlee@gmail.com \N \N f 2016-09-22
40820693245 Anselme Goetschmann agoetsch@uwaterloo.ca \N \N f 2016-09-22
40920650705 Kemar St.Hill clok736@hotmail.com \N \N t 2016-09-22
410160858610 Owen Liu liux8610@mylaurier.ca \N \N f 2016-09-22
41120669364 Kelvin Yu kelvin.yu98@gmail.com \N \N f 2016-09-22
41220659063 Griffin Keglevich griffinkeglevich@gmail.com \N \N f 2016-09-22
41320660735 Danny Jiang danny.jiang@yahoo.ca \N \N f 2016-09-22
41420675597 Curtis Phan cdkphan@edu.uwaterloo.ca \N \N f 2016-09-22
41520680136 Anthony Tckencko Anthony.b.tkachenko@gmail.comm \N \N f 2016-09-22
41620662975 Noah Bussmann noah.n.bussmann@gmail.com \N \N f 2016-09-22
41720525656 Nathaniel Kwok n4kwok@uwaterloo.ca \N \N f 2016-09-22
41820665662 Purav Naik puravnaik834@gmail.com \N \N f 2016-09-22
41920573239 Huming Guo hmguo@uwaterloo.ca \N \N f 2016-09-22
42020670127 Jay Chowdhary j3chowdh@uwaterloo.ca \N \N f 2016-09-22
42120521443 Kevin Lin linkevin422@gmail.com \N \N f 2016-09-22
42220689207 An-Chi Cheng anchicheng98@gmail.com \N \N f 2016-09-22
42320593418 Mason Mackaman masondeanm@aol.com \N \N f 2016-09-22
42420672785 Zeen Lu luzeenamtf1018@gmail.com \N \N f 2016-09-22
42520663211 Roger Jiang rogerjiangcf@gmail.com \N \N f 2016-09-22
42620616350 Justin Ip justinip@hotmail.com \N \N f 2016-09-22
42720535691 Hassaan shahed mhshahed@uwaterloo.ca \N \N f 2016-09-22
42820554735 gogulashanth sathiyaseelan g3sathiy@uwaterloo.ca \N \N f 2016-09-22
42920616833 Simon van Hoeve simon_vanhoeve@hotmail.com \N \N f 2016-09-22
430\.
431
432
433--
434-- Name: events_pkey; Type: CONSTRAINT; Schema: public; Owner: adam
435--
436
437ALTER TABLE ONLY events
438 ADD CONSTRAINT events_pkey PRIMARY KEY (id);
439
440
441--
442-- Name: logins_pkey; Type: CONSTRAINT; Schema: public; Owner: adam
443--
444
445ALTER TABLE ONLY logins
446 ADD CONSTRAINT logins_pkey PRIMARY KEY (loginid);
447
448
449--
450-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: adam
451--
452
453ALTER TABLE ONLY users
454 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
455
456
457--
458-- Name: participants_eventid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: adam
459--
460
461ALTER TABLE ONLY participants
462 ADD CONSTRAINT participants_eventid_fkey FOREIGN KEY (eventid) REFERENCES events(id);
463
464
465--
466-- Name: participants_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: adam
467--
468
469ALTER TABLE ONLY participants
470 ADD CONSTRAINT participants_id_fkey FOREIGN KEY (id) REFERENCES users(id);
471
472
473--
474-- Name: public; Type: ACL; Schema: -; Owner: postgres
475--
476
477REVOKE ALL ON SCHEMA public FROM PUBLIC;
478REVOKE ALL ON SCHEMA public FROM postgres;
479GRANT ALL ON SCHEMA public TO postgres;
480GRANT ALL ON SCHEMA public TO PUBLIC;
481
482
483--
484-- PostgreSQL database dump complete
485--