-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathresearchDB_populate.sql
104 lines (87 loc) · 5.68 KB
/
researchDB_populate.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
use researchdb;
insert into PAPERS values('1', 'Chrus Adventures', 'follow our journey duck duck duck duck duck duck duck duck duck duck duck duck duck duck duck duck duck duck duck duck duck duck duck', 'citation1');
insert into PAPERS values('2', 'Drumsticks', 'all you need to know about drumsticks', 'citation2');
insert into PAPERS values('3', 'Pulled Pork', 'simply delicious', 'citation3');
insert into PAPERS values('4', 'Chicken', 'yum', 'citation4');
insert into PAPERS values('5', 'Apple', 'fruit red', 'citation5');
insert into PAPERS values('6', 'Orange', 'fruit yum', 'citation6');
insert into PAPERS values('7', 'Banana', 'yellow', 'citation7');
insert into PAPERS values('8', 'The Heart', 'Biology', 'citation8');
insert into PAPERS values('9', 'The Feets', 'Biology', 'citation9');
insert into PAPERS values('10', 'Eggs', 'Biology', 'citation10');
insert into PAPERS values('11', 'Falling from a Tree', 'Physics', 'citation11');
insert into PAPERS values('12', 'Breaking the Laws', 'Physics', 'citation12');
insert into PAPERS values('13', 'Magiks', 'Physics', 'citation13');
insert into PAPERS values('14', 'Playing with Fire', 'Chemistry', 'citation14');
insert into PAPERS values('15', 'Some H2O2', 'Chemistry', 'citation15');
insert into PAPERS values('16', 'NaBrO', 'Chemistry', 'citation16');
insert into PAPERS values('17', 'Heisenberg Principle', 'Chemistry', 'citation17');
insert into PAPERS values('18', 'Greenhouse Effect', 'Environment', 'citation18');
insert into PAPERS values('19', 'Primate Language', 'Communication', 'citation19');
insert into PAPERS values('20', 'Nanotechnology', 'Technology', 'citation20');
insert into PAPERS values('21', 'Animal Reintroduction', 'Ecology', 'citation21');
insert into searchable_keywords values ('1', '1','random');
insert into searchable_keywords values ('2', '2','meat');
insert into searchable_keywords values ('3', '3','meat');
insert into searchable_keywords values ('4', '4','meat');
insert into searchable_keywords values ('5', '4','bird');
insert into searchable_keywords values ('6', '5','fruit');
insert into searchable_keywords values ('7', '6','fruit');
insert into searchable_keywords values ('8', '7','fruit');
insert into searchable_keywords values ('9', '8','biology');
insert into searchable_keywords values ('10', '9','biology');
insert into searchable_keywords values ('11', '10','bird');
insert into searchable_keywords values ('12', '11','physics');
insert into searchable_keywords values ('13', '12','physics');
insert into searchable_keywords values ('14', '13','physics');
insert into searchable_keywords values ('15', '14','physics');
insert into searchable_keywords values ('16', '15','chemistry');
insert into searchable_keywords values ('17', '16','chemistry');
insert into searchable_keywords values ('18', '17','chemistry');
insert into searchable_keywords values ('19', '15','chem');
insert into searchable_keywords values ('20', '16','chem');
insert into searchable_keywords values ('21', '17','chem');
insert into searchable_keywords values ('22', '18','environment');
insert into searchable_keywords values ('23', '19','comm');
insert into searchable_keywords values ('24', '20','tech');
insert into searchable_keywords values ('25', '21','ecology');
insert into USERS value ('1', 'Kris', 'Brown', 'username1',
'd6e08cfee902d484a95c5ccd4a34c2b60065ed1120293f8c99ac6ca2e9ed81fb',
'3e0e71c7dcd5f79f7fddd9a5148e9fcb3973803440e940a55df2c3f526765d49',
'[email protected]', 'public');
insert into USERS value ('2', 'Lillian', 'Lee', 'username2',
'd6e08cfee902d484a95c5ccd4a34c2b60065ed1120293f8c99ac6ca2e9ed81fb',
'3e0e71c7dcd5f79f7fddd9a5148e9fcb3973803440e940a55df2c3f526765d49',
'[email protected]', 'student');
insert into USERS value ('3', 'Joe', 'Doe', 'username3',
'd6e08cfee902d484a95c5ccd4a34c2b60065ed1120293f8c99ac6ca2e9ed81fb',
'3e0e71c7dcd5f79f7fddd9a5148e9fcb3973803440e940a55df2c3f526765d49',
'[email protected]', 'faculty');
insert into USERS value ('4', 'Boss', 'Guy', 'username4',
'd6e08cfee902d484a95c5ccd4a34c2b60065ed1120293f8c99ac6ca2e9ed81fb',
'3e0e71c7dcd5f79f7fddd9a5148e9fcb3973803440e940a55df2c3f526765d49',
'[email protected]', 'admin');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('1', '1');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('2', '1');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('3', '1');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('3', '2');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('4', '2');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('5', '2');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('6', '2');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('7', '2');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('8', '2');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('7', '3');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('8', '3');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('9', '3');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('10', '3');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('11', '3');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('12', '3');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('13', '4');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('14', '4');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('15', '4');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('16', '4');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('17', '4');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('18', '4');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('19', '4');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('20', '4');
insert into PAPERS_USERS_MAP (papers_fk, users_fk) value ('21', '4');