-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathturtlecamp_dev_db.psql
696 lines (495 loc) · 24.5 KB
/
turtlecamp_dev_db.psql
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
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.6.1
-- Dumped by pg_dump version 9.6.1
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;
--
-- 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: ar_internal_metadata; Type: TABLE; Schema: public; Owner: guochunzhong
--
CREATE TABLE ar_internal_metadata (
key character varying NOT NULL,
value character varying,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE ar_internal_metadata OWNER TO guochunzhong;
--
-- Name: attachments; Type: TABLE; Schema: public; Owner: guochunzhong
--
CREATE TABLE attachments (
id integer NOT NULL,
format character varying,
task_id integer,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE attachments OWNER TO guochunzhong;
--
-- Name: attachments_id_seq; Type: SEQUENCE; Schema: public; Owner: guochunzhong
--
CREATE SEQUENCE attachments_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE attachments_id_seq OWNER TO guochunzhong;
--
-- Name: attachments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: guochunzhong
--
ALTER SEQUENCE attachments_id_seq OWNED BY attachments.id;
--
-- Name: college_apps; Type: TABLE; Schema: public; Owner: guochunzhong
--
CREATE TABLE college_apps (
id integer NOT NULL,
deadline timestamp without time zone,
category character varying,
status boolean,
user_id integer,
college_id integer,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE college_apps OWNER TO guochunzhong;
--
-- Name: college_apps_id_seq; Type: SEQUENCE; Schema: public; Owner: guochunzhong
--
CREATE SEQUENCE college_apps_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE college_apps_id_seq OWNER TO guochunzhong;
--
-- Name: college_apps_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: guochunzhong
--
ALTER SEQUENCE college_apps_id_seq OWNED BY college_apps.id;
--
-- Name: colleges; Type: TABLE; Schema: public; Owner: guochunzhong
--
CREATE TABLE colleges (
id integer NOT NULL,
name character varying,
address character varying,
website character varying,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE colleges OWNER TO guochunzhong;
--
-- Name: colleges_id_seq; Type: SEQUENCE; Schema: public; Owner: guochunzhong
--
CREATE SEQUENCE colleges_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE colleges_id_seq OWNER TO guochunzhong;
--
-- Name: colleges_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: guochunzhong
--
ALTER SEQUENCE colleges_id_seq OWNED BY colleges.id;
--
-- Name: notifications; Type: TABLE; Schema: public; Owner: guochunzhong
--
CREATE TABLE notifications (
id integer NOT NULL,
content character varying,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE notifications OWNER TO guochunzhong;
--
-- Name: notifications_id_seq; Type: SEQUENCE; Schema: public; Owner: guochunzhong
--
CREATE SEQUENCE notifications_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE notifications_id_seq OWNER TO guochunzhong;
--
-- Name: notifications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: guochunzhong
--
ALTER SEQUENCE notifications_id_seq OWNED BY notifications.id;
--
-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: guochunzhong
--
CREATE TABLE schema_migrations (
version character varying NOT NULL
);
ALTER TABLE schema_migrations OWNER TO guochunzhong;
--
-- Name: tasks; Type: TABLE; Schema: public; Owner: guochunzhong
--
CREATE TABLE tasks (
id integer NOT NULL,
name character varying,
due_date timestamp without time zone NOT NULL,
status character varying DEFAULT 'not done'::character varying,
college_app_id integer,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
document character varying
);
ALTER TABLE tasks OWNER TO guochunzhong;
--
-- Name: tasks_id_seq; Type: SEQUENCE; Schema: public; Owner: guochunzhong
--
CREATE SEQUENCE tasks_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE tasks_id_seq OWNER TO guochunzhong;
--
-- Name: tasks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: guochunzhong
--
ALTER SEQUENCE tasks_id_seq OWNED BY tasks.id;
--
-- Name: users; Type: TABLE; Schema: public; Owner: guochunzhong
--
CREATE TABLE users (
id integer NOT NULL,
email character varying DEFAULT ''::character varying NOT NULL,
encrypted_password character varying DEFAULT ''::character varying NOT NULL,
reset_password_token character varying,
reset_password_sent_at timestamp without time zone,
remember_created_at timestamp without time zone,
sign_in_count integer DEFAULT 0 NOT NULL,
current_sign_in_at timestamp without time zone,
last_sign_in_at timestamp without time zone,
current_sign_in_ip inet,
last_sign_in_ip inet,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
name character varying NOT NULL,
current_school character varying,
satm integer,
satv integer,
satwr integer,
act integer,
toeflr integer,
toeflwr integer,
toefls integer,
toefll integer,
is_counselor boolean DEFAULT true NOT NULL,
admin boolean DEFAULT false NOT NULL,
counselor_ref integer
);
ALTER TABLE users OWNER TO guochunzhong;
--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: guochunzhong
--
CREATE SEQUENCE users_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE users_id_seq OWNER TO guochunzhong;
--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: guochunzhong
--
ALTER SEQUENCE users_id_seq OWNED BY users.id;
--
-- Name: attachments id; Type: DEFAULT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY attachments ALTER COLUMN id SET DEFAULT nextval('attachments_id_seq'::regclass);
--
-- Name: college_apps id; Type: DEFAULT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY college_apps ALTER COLUMN id SET DEFAULT nextval('college_apps_id_seq'::regclass);
--
-- Name: colleges id; Type: DEFAULT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY colleges ALTER COLUMN id SET DEFAULT nextval('colleges_id_seq'::regclass);
--
-- Name: notifications id; Type: DEFAULT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY notifications ALTER COLUMN id SET DEFAULT nextval('notifications_id_seq'::regclass);
--
-- Name: tasks id; Type: DEFAULT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY tasks ALTER COLUMN id SET DEFAULT nextval('tasks_id_seq'::regclass);
--
-- Name: users id; Type: DEFAULT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
--
-- Data for Name: ar_internal_metadata; Type: TABLE DATA; Schema: public; Owner: guochunzhong
--
COPY ar_internal_metadata (key, value, created_at, updated_at) FROM stdin;
environment development 2017-03-30 11:30:28.76085 2017-03-30 11:30:28.76085
\.
--
-- Data for Name: attachments; Type: TABLE DATA; Schema: public; Owner: guochunzhong
--
COPY attachments (id, format, task_id, created_at, updated_at) FROM stdin;
\.
--
-- Name: attachments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: guochunzhong
--
SELECT pg_catalog.setval('attachments_id_seq', 1, false);
--
-- Data for Name: college_apps; Type: TABLE DATA; Schema: public; Owner: guochunzhong
--
COPY college_apps (id, deadline, category, status, user_id, college_id, created_at, updated_at) FROM stdin;
13 \N REACH \N 2 1 2017-03-31 04:05:22.99858 2017-03-31 04:05:22.99858
16 2017-01-01 00:00:00 REACH \N 2 3 2017-03-31 04:22:19.70042 2017-03-31 04:22:19.70042
17 \N REACH \N 3 4 2017-03-31 05:21:57.214807 2017-03-31 05:21:57.214807
18 2017-01-01 00:00:00 REACH \N 3 2 2017-03-31 05:22:09.254827 2017-03-31 05:22:09.254827
19 2017-01-01 00:00:00 REACH \N 4 2 2017-03-31 05:31:24.720453 2017-03-31 05:31:24.720453
20 \N TARGET \N 4 3 2017-03-31 06:20:56.091386 2017-03-31 07:00:35.261037
22 2017-01-10 00:00:00 TARGET \N 4 1 2017-03-31 06:27:09.289307 2017-03-31 07:00:51.986324
25 2017-01-01 00:00:00 TARGET \N 5 1 2017-03-31 07:06:52.183302 2017-03-31 07:07:39.930101
27 \N REACH \N 7 1 2017-03-31 07:29:42.823198 2017-03-31 07:29:42.823198
28 2017-02-02 00:00:00 REACH \N 8 2 2017-03-31 09:13:04.021352 2017-03-31 09:13:04.021352
29 2017-01-01 00:00:00 REACH \N 8 1 2017-03-31 09:20:36.792887 2017-03-31 09:20:36.792887
31 2017-01-01 00:00:00 REACH \N 2 2 2017-04-01 04:08:28.435873 2017-04-01 04:08:28.435873
32 2017-01-01 00:00:00 REACH \N 2 4 2017-04-01 04:52:16.081664 2017-04-01 04:52:16.081664
33 \N REACH \N 3 1 2017-04-01 09:59:14.525082 2017-04-01 09:59:14.525082
34 2017-01-01 00:00:00 REACH \N 3 3 2017-04-01 09:59:34.180192 2017-04-01 09:59:34.180192
35 2017-01-01 00:00:00 REACH \N 9 1 2017-04-01 10:34:12.390781 2017-04-01 10:34:12.390781
36 2017-01-01 00:00:00 REACH \N 4 4 2017-04-01 11:16:09.612185 2017-04-01 11:16:09.612185
37 2017-01-01 00:00:00 TARGET \N 11 2 2017-04-01 11:56:52.248549 2017-04-01 12:22:33.465241
\.
--
-- Name: college_apps_id_seq; Type: SEQUENCE SET; Schema: public; Owner: guochunzhong
--
SELECT pg_catalog.setval('college_apps_id_seq', 37, true);
--
-- Data for Name: colleges; Type: TABLE DATA; Schema: public; Owner: guochunzhong
--
COPY colleges (id, name, address, website, created_at, updated_at) FROM stdin;
1 Harvard Cambridge, MA \N 2017-03-30 11:30:28.920381 2017-03-30 11:30:28.920381
2 Yale New Haven, CT \N 2017-03-30 11:30:28.930851 2017-03-30 11:30:28.930851
3 Whitman 345 Boyer Ave, Walla Walla, WA \N 2017-03-30 11:30:28.933571 2017-03-30 11:30:28.933571
4 Middlebury 14 Old Chapel Rd, Middlebury, VT \N 2017-03-30 11:30:28.935449 2017-03-30 11:30:28.935449
\.
--
-- Name: colleges_id_seq; Type: SEQUENCE SET; Schema: public; Owner: guochunzhong
--
SELECT pg_catalog.setval('colleges_id_seq', 4, true);
--
-- Data for Name: notifications; Type: TABLE DATA; Schema: public; Owner: guochunzhong
--
COPY notifications (id, content, created_at, updated_at) FROM stdin;
\.
--
-- Name: notifications_id_seq; Type: SEQUENCE SET; Schema: public; Owner: guochunzhong
--
SELECT pg_catalog.setval('notifications_id_seq', 1, false);
--
-- Data for Name: schema_migrations; Type: TABLE DATA; Schema: public; Owner: guochunzhong
--
COPY schema_migrations (version) FROM stdin;
20170330100501
20170328044204
20170328081450
20170329063031
20170329063503
20170329064016
20170329064819
20170329064941
20170329172316
20170330150219
20170401100953
\.
--
-- Data for Name: tasks; Type: TABLE DATA; Schema: public; Owner: guochunzhong
--
COPY tasks (id, name, due_date, status, college_app_id, created_at, updated_at, document) FROM stdin;
7 Go buy a gun 2017-01-01 00:00:00 not done 19 2017-03-31 05:32:12.6488 2017-03-31 05:32:12.6488 \N
8 Go buy a gun 2017-01-01 00:00:00 not done 19 2017-03-31 05:33:36.795652 2017-03-31 05:33:36.795652 mvtg5kac1sanptofdlp7.docx
9 gogogo 2017-01-01 00:00:00 not done 20 2017-03-31 06:33:27.700263 2017-03-31 06:33:27.700263 \N
11 uglyface 2018-01-01 00:00:00 not done 20 2017-03-31 06:37:29.845885 2017-03-31 06:37:29.845885 \N
14 gofasfas 2017-01-01 00:00:00 not done 25 2017-03-31 07:07:01.474306 2017-03-31 07:07:01.474306 \N
16 go fishing n stuff 2017-02-01 00:00:00 not done 27 2017-03-31 08:18:44.048957 2017-03-31 08:18:44.048957 \N
17 go fishing n stuff 2017-01-01 00:00:00 not done 28 2017-03-31 09:13:13.115266 2017-03-31 09:13:13.115266 \N
18 go fishing n stuff 2017-12-01 00:00:00 not done 29 2017-03-31 09:20:58.168676 2017-03-31 09:20:58.168676 \N
19 fafas 2017-01-01 00:00:00 not done 29 2017-03-31 09:24:32.573891 2017-03-31 09:24:32.573891 aiorzalvapizstxuvbvp.png
20 suckasfhjas 2017-01-01 00:00:00 not done 31 2017-04-01 04:08:43.476594 2017-04-01 04:08:43.476594 \N
26 Testing the attachment 2016-01-01 00:00:00 approved 32 2017-04-01 06:22:38.122437 2017-04-01 09:08:25.79846 fqnycatpqhtrz38qzp1w.pdf
29 Upload passport 2016-04-02 00:00:00 approved 32 2017-04-01 08:45:02.402516 2017-04-01 09:12:21.875079 \N
23 get married and have kids 2017-01-01 00:00:00 approved 32 2017-04-01 05:18:23.167534 2017-04-01 09:15:45.119408 \N
25 hate life 2017-01-01 00:00:00 approved 32 2017-04-01 05:43:17.307751 2017-04-01 09:26:46.639439 \N
22 be free and fuck shit up 2017-01-01 00:00:00 approved 32 2017-04-01 04:52:36.522432 2017-04-01 09:27:11.569647 \N
27 go 2017-01-01 00:00:00 approved 32 2017-04-01 07:11:48.373558 2017-04-01 09:28:25.008498 \N
24 asfsa 2017-01-02 00:00:00 approved 32 2017-04-01 05:30:45.293929 2017-04-01 09:29:49.848736 \N
21 go fishing n stuff 2018-01-01 00:00:00 approved 32 2017-04-01 04:52:26.359505 2017-04-01 09:31:56.5576 \N
28 Hahaha 2017-01-02 00:00:00 approved 32 2017-04-01 07:12:14.42947 2017-04-01 09:32:34.950642 oibdigun2oglz89xdc51.jpg
30 asfafs 2016-01-01 00:00:00 approved 32 2017-04-01 09:34:14.447224 2017-04-01 09:34:48.055417 \N
31 asfas 2017-01-01 00:00:00 approved 32 2017-04-01 09:37:12.009973 2017-04-01 09:38:56.465201 \N
32 afshahs 2015-01-01 00:00:00 not done 32 2017-04-01 09:45:43.898209 2017-04-01 09:45:43.898209 \N
33 Go swimming 2017-01-01 00:00:00 approved 34 2017-04-01 09:59:43.761221 2017-04-01 09:59:50.365448 \N
35 write essay 2017-01-01 00:00:00 pending 34 2017-04-01 10:01:35.266746 2017-04-01 10:01:59.697719 \N
34 upload my passport 2017-01-01 00:00:00 approved 34 2017-04-01 10:00:50.375747 2017-04-01 10:02:07.989418 \N
37 upload my passport 2015-01-01 00:00:00 pending 34 2017-04-01 10:08:39.917642 2017-04-01 10:08:55.795301 \N
6 Write an amazing life changufwaskjfhasf saofsng 2017-04-08 10:17:58.73482 not done 19 2017-03-31 05:32:01.925254 2017-03-31 05:32:01.925254 \N
36 go fishing n stuff 2017-01-01 00:00:00 pending 34 2017-04-01 10:08:24.282316 2017-04-01 10:18:42.833126 \N
38 Get incredibly lit 2017-01-01 00:00:00 not done 34 2017-04-01 10:20:47.160867 2017-04-01 10:20:47.160867 \N
39 Finish my essay 2014-01-01 00:00:00 pending 34 2017-04-01 10:21:10.567758 2017-04-01 10:21:15.636225 \N
46 Go sledding 2017-01-01 00:00:00 approved 36 2017-04-01 11:19:07.772762 2017-04-01 11:29:21.200834 \N
10 get super hig 2017-01-01 00:00:00 approved 22 2017-03-31 06:36:23.235125 2017-04-01 10:22:14.237104 \N
12 get super hig 2017-01-01 00:00:00 approved 22 2017-03-31 06:37:39.497568 2017-04-01 10:22:50.016066 pp05t5skxtcah5zxfnjz.png
13 blash 2018-02-02 00:00:00 approved 22 2017-03-31 06:52:25.20584 2017-04-01 10:24:07.425313 \N
40 Cry and go die 2017-01-01 00:00:00 approved 22 2017-04-01 10:25:02.828945 2017-04-01 10:26:32.214483 \N
41 go for a run 2017-01-01 00:00:00 approved 22 2017-04-01 10:26:45.728271 2017-04-01 10:27:04.340582 \N
47 go 2017-01-01 00:00:00 approved 36 2017-04-01 11:29:46.251422 2017-04-01 11:29:56.260721 \N
42 Go sledding 2017-01-01 00:00:00 approved 35 2017-04-01 10:34:26.646604 2017-04-01 10:35:57.772023 \N
43 ahfash 2017-01-01 00:00:00 approved 35 2017-04-01 10:44:19.91717 2017-04-01 10:44:28.518398 \N
48 go 2017-01-01 00:00:00 approved 36 2017-04-01 11:30:15.659796 2017-04-01 11:30:17.88904 \N
44 fasasf 2017-12-01 00:00:00 approved 35 2017-04-01 10:45:04.240042 2017-04-01 10:46:04.588018 \N
45 hate 2017-01-01 00:00:00 approved 35 2017-04-01 10:48:04.528845 2017-04-01 10:48:06.766148 \N
49 afsfsa 2017-01-01 00:00:00 approved 36 2017-04-01 11:30:28.799618 2017-04-01 11:30:51.184426 \N
50 My passport 2017-01-01 00:00:00 not done 36 2017-04-01 11:33:28.053423 2017-04-01 11:33:28.053423 dxogdcf3cvy3bnd8xx9k.png
51 Upload your passport 2017-01-01 00:00:00 approved 36 2017-04-01 11:33:52.275973 2017-04-01 11:34:02.227986 \N
52 Upload your passport 2017-02-01 00:00:00 approved 37 2017-04-01 11:57:13.057356 2017-04-01 11:59:22.351139 \N
55 Task with document 2017-01-01 00:00:00 pending 37 2017-04-01 13:13:58.135914 2017-04-01 13:15:34.39893 spriyrwcf00n0fwiy8t7.png
64 sfaasf 2017-01-01 00:00:00 pending 37 2017-04-01 14:04:28.096454 2017-04-01 14:04:36.768745 \N
54 task with no attachment 2017-01-01 00:00:00 approved 37 2017-04-01 13:12:54.264506 2017-04-01 13:50:56.752374 \N
63 asfasf 2017-01-01 00:00:00 approved 37 2017-04-01 14:04:17.627884 2017-04-01 14:18:21.436373 oe3madzizfrshgnmb3vz.png
58 safsaf 2017-01-02 00:00:00 approved 37 2017-04-01 13:51:10.401878 2017-04-01 13:51:16.408661 \N
53 hhjjhhj 2017-01-01 00:00:00 pending 37 2017-04-01 12:56:14.422293 2017-04-01 14:18:42.192396 iozisj0riedyfjamjonv.png
56 My shit 2017-01-01 00:00:00 approved 37 2017-04-01 13:28:36.964332 2017-04-01 13:51:41.196662 dycxlshr14rs4mf4jdjn.png
62 fsaasf 2017-01-01 00:00:00 approved 37 2017-04-01 14:04:06.615955 2017-04-01 14:20:06.732486 y3w1ujhyhtnakuon9e0g.png
59 asfsafsa 2017-01-01 00:00:00 approved 37 2017-04-01 13:51:26.402622 2017-04-01 14:03:37.711331 \N
60 asfsaf 2017-01-01 00:00:00 pending 37 2017-04-01 14:03:33.916002 2017-04-01 14:03:46.15614 \N
61 afs 2017-01-01 00:00:00 pending 37 2017-04-01 14:03:53.987352 2017-04-01 14:20:20.954916 dluiimg8dle8nkagzagr.png
\.
--
-- Name: tasks_id_seq; Type: SEQUENCE SET; Schema: public; Owner: guochunzhong
--
SELECT pg_catalog.setval('tasks_id_seq', 64, true);
--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: guochunzhong
--
COPY users (id, email, encrypted_password, reset_password_token, reset_password_sent_at, remember_created_at, sign_in_count, current_sign_in_at, last_sign_in_at, current_sign_in_ip, last_sign_in_ip, created_at, updated_at, name, current_school, satm, satv, satwr, act, toeflr, toeflwr, toefls, toefll, is_counselor, admin, counselor_ref) FROM stdin;
3 [email protected] $2a$11$Lsm.yWxgQrDt9IeaGmGG/u4LyadXXyeffjlHDJpkmxDwNgkk2KQUi \N \N \N 10 2017-04-01 10:24:32.56931 2017-04-01 10:21:58.31498 127.0.0.1 127.0.0.1 2017-03-30 14:20:12.433194 2017-04-01 10:24:32.570276 Mamoru Chiba \N \N \N \N \N \N \N \N \N f f 1
9 [email protected] $2a$11$b9sDx80pmODM7dc4rGEb/Oy7efgo7G1TupoGlKoYBw/MxlGyKpKaK \N \N \N 1 2017-04-01 10:34:51.931065 2017-04-01 10:34:51.931065 127.0.0.1 127.0.0.1 2017-04-01 10:34:04.50011 2017-04-01 10:34:51.931797 stupidho \N \N \N \N \N \N \N \N \N f f 1
1 [email protected] $2a$11$EYo7DgGEMF8k0d8byRaq/uCU3NrVu2lmJ6XJuy9lcHD1I/Z/Vu/Gy \N \N \N 18 2017-04-01 11:15:45.508803 2017-04-01 10:45:43.355311 127.0.0.1 127.0.0.1 2017-03-30 11:31:15.23544 2017-04-01 11:15:45.50986 john \N \N \N \N \N \N \N \N \N t f \N
2 [email protected] $2a$11$AfASSCkBk1mHmZ1OZoiB1.m4yK.t82YotnsytOBqfomLQloyoaEYG \N \N \N 4 2017-04-01 11:16:41.323471 2017-04-01 10:31:32.81201 127.0.0.1 127.0.0.1 2017-03-30 11:32:42.513808 2017-04-01 11:16:41.3244 Usagi Tsukino \N \N \N \N \N \N \N \N \N f f 1
4 [email protected] $2a$11$PDxAoOuE.Y0P.ntaO40eAejFSQd1vlnLm7uycgFdSEwYpnSzwP9qq \N \N \N 2 2017-04-01 11:17:13.435592 2017-03-31 06:34:52.404111 127.0.0.1 127.0.0.1 2017-03-31 05:31:17.45707 2017-04-01 11:17:13.43678 Ryuichi Sakomoto \N \N \N \N \N \N \N \N \N f f 1
10 [email protected] $2a$11$.FM7OALQTEAoRnh4MifecOx7L.moQtDpkAUU5R0sZc9jyVlYsRlFO \N \N \N 1 2017-04-01 11:55:51.086289 2017-04-01 11:55:51.086289 127.0.0.1 127.0.0.1 2017-04-01 11:55:51.082476 2017-04-01 11:55:51.087163 Dounan \N \N \N \N \N \N \N \N \N t f \N
11 [email protected] $2a$11$AJr1wBoaJhPFawioduHLEucJlcmJ/y2l4fjUu4wrzfdPI0cgWwghq \N \N \N 1 2017-04-01 11:57:41.296818 2017-04-01 11:57:41.296818 127.0.0.1 127.0.0.1 2017-04-01 11:56:28.546618 2017-04-01 11:57:41.297607 John Student \N \N \N \N \N \N \N \N \N f f 10
5 [email protected] $2a$11$fZosClWxaF9fU1iv39YOLu9JvU0bB7mjDh40oTY0dtB62I5OcOECe \N \N \N 1 2017-03-31 07:06:31.281798 2017-03-31 07:06:31.281798 127.0.0.1 127.0.0.1 2017-03-31 07:05:49.128017 2017-03-31 07:06:31.282632 Kyari pamyu \N \N \N \N \N \N \N \N \N f f 1
6 [email protected] $2a$11$RMuT9nURhovsfrf.Kx4LB.U2tSIfH13M5NaRlQhzXpE1ac8ghpB3O \N \N \N 1 2017-03-31 07:29:11.533205 2017-03-31 07:29:11.533205 127.0.0.1 127.0.0.1 2017-03-31 07:29:11.529438 2017-03-31 07:29:11.534089 fuck \N \N \N \N \N \N \N \N \N t f \N
7 [email protected] $2a$11$XGzOGtW8uMFRYNiQFoSYjOB7veH5LUAwZs3z8orwZiaeWXx4rzmJS \N \N \N 1 2017-03-31 07:32:13.922671 2017-03-31 07:32:13.922671 127.0.0.1 127.0.0.1 2017-03-31 07:29:38.570748 2017-03-31 07:32:13.923436 yosuke \N \N \N \N \N \N \N \N \N f f 6
8 [email protected] $2a$11$gSkFF466Hi0NFIycQCwvlODahM02RzXKMo86dIPffVyUaJzyEDBzi \N \N \N 0 \N \N \N \N 2017-03-31 09:12:56.00201 2017-03-31 09:12:56.00201 gogog \N \N \N \N \N \N \N \N \N f f 1
\.
--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: guochunzhong
--
SELECT pg_catalog.setval('users_id_seq', 11, true);
--
-- Name: ar_internal_metadata ar_internal_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY ar_internal_metadata
ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key);
--
-- Name: attachments attachments_pkey; Type: CONSTRAINT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY attachments
ADD CONSTRAINT attachments_pkey PRIMARY KEY (id);
--
-- Name: college_apps college_apps_pkey; Type: CONSTRAINT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY college_apps
ADD CONSTRAINT college_apps_pkey PRIMARY KEY (id);
--
-- Name: colleges colleges_pkey; Type: CONSTRAINT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY colleges
ADD CONSTRAINT colleges_pkey PRIMARY KEY (id);
--
-- Name: notifications notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY notifications
ADD CONSTRAINT notifications_pkey PRIMARY KEY (id);
--
-- Name: schema_migrations schema_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY schema_migrations
ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version);
--
-- Name: tasks tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY tasks
ADD CONSTRAINT tasks_pkey PRIMARY KEY (id);
--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY users
ADD CONSTRAINT users_pkey PRIMARY KEY (id);
--
-- Name: index_attachments_on_task_id; Type: INDEX; Schema: public; Owner: guochunzhong
--
CREATE INDEX index_attachments_on_task_id ON attachments USING btree (task_id);
--
-- Name: index_college_apps_on_college_id; Type: INDEX; Schema: public; Owner: guochunzhong
--
CREATE INDEX index_college_apps_on_college_id ON college_apps USING btree (college_id);
--
-- Name: index_college_apps_on_user_id; Type: INDEX; Schema: public; Owner: guochunzhong
--
CREATE INDEX index_college_apps_on_user_id ON college_apps USING btree (user_id);
--
-- Name: index_tasks_on_college_app_id; Type: INDEX; Schema: public; Owner: guochunzhong
--
CREATE INDEX index_tasks_on_college_app_id ON tasks USING btree (college_app_id);
--
-- Name: index_users_on_email; Type: INDEX; Schema: public; Owner: guochunzhong
--
CREATE UNIQUE INDEX index_users_on_email ON users USING btree (email);
--
-- Name: index_users_on_reset_password_token; Type: INDEX; Schema: public; Owner: guochunzhong
--
CREATE UNIQUE INDEX index_users_on_reset_password_token ON users USING btree (reset_password_token);
--
-- Name: tasks fk_rails_1885d3d6a9; Type: FK CONSTRAINT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY tasks
ADD CONSTRAINT fk_rails_1885d3d6a9 FOREIGN KEY (college_app_id) REFERENCES college_apps(id);
--
-- Name: college_apps fk_rails_82eb192bf0; Type: FK CONSTRAINT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY college_apps
ADD CONSTRAINT fk_rails_82eb192bf0 FOREIGN KEY (user_id) REFERENCES users(id);
--
-- Name: attachments fk_rails_98bb5e58c9; Type: FK CONSTRAINT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY attachments
ADD CONSTRAINT fk_rails_98bb5e58c9 FOREIGN KEY (task_id) REFERENCES tasks(id);
--
-- Name: college_apps fk_rails_b80e6614c1; Type: FK CONSTRAINT; Schema: public; Owner: guochunzhong
--
ALTER TABLE ONLY college_apps
ADD CONSTRAINT fk_rails_b80e6614c1 FOREIGN KEY (college_id) REFERENCES colleges(id);
--
-- PostgreSQL database dump complete
--