-
Notifications
You must be signed in to change notification settings - Fork 1
/
insertTables.sql
154 lines (85 loc) · 2.8 KB
/
insertTables.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
insert into users
values(12345678, 'exemail1@gmail.com', 'coconuts',
'example1');
insert into users
values (87654321, 'exemail2@gmail.com', 'bananas',
'example2', );
insert into users
values(13579246, 'exemail3@gmail.com', 'apples',
'example3');
insert into users
values(97531246, 'exemail4@gmail.com', 'oranges',
'example4');
insert into users
values(90863758, 'exemail5@gmail.com', 'limes',
'example5');
insert into sellers
values(12345678);
insert into sellers
values(87654321);
insert into sellers
values(13579246);
insert into sellers
values(97531246);
insert into sellers
values(90863758);
insert into textbooks
values(9780072465631,'Database Management Systems 3/E');
insert into textbooks
values(9780262017350, 'Foundations of 3D Computer Graphics');
insert into textbooks
values(9780133571769, 'Strategic Staffing 3/E');
insert into textbooks
values(9780323355636, 'Textbook of Histology');
insert into textbooks
values(9780321776419, 'Progamming in C');
insert into course
values('CPSC', 304);
insert into course
values('CPSC', 314);
insert into course
values('COHR', 303);
insert into course
values('CAPS', 390);
insert into course
values('APSC', 160);
insert into course_of_textbook
values(9780072465631, 'CPSC', 304);
insert into course_of_textbook
values(9780262017350, 'CPSC', 314);
insert into course_of_textbook
values(9780133571769, 'COHR', 303);
insert into course_of_textbook
values(9780323355636, 'CAPS', 390);
insert into course_of_textbook
values(9780321776419, 'APSC', 160);
insert into authors_in_textbook
values('Ramakrishnan', 9780072465631);
insert into authors_in_textbook
values('Gortier', 9780262017350);
insert into authors_in_textbook
values('Phillips', 9780133571769);
insert into authors_in_textbook
values('Loro', 9780323355636);
insert into authors_in_textbook
values('Kochan', 9780321776419);
insert into posting
values(1, 50, 'Very good condition. Barely used.', 'posting.jpg', 'N', 9780321776419, 12345678);
insert into posting
values(2, 30, 'Some water marks on the book. The rest is completely fine.', 'img1.jpg', 'N', 9780133571769, 97531246);
insert into posting
values(3, 75, 'Brand new, opened one time', 'img_212.jpg', 'N', 9780133571769, 87654321);
insert into posting
values(4, 20 , 'Back cover ripped out. Will sell for cheap', '0239482.jpg', 'N', 9780323355636, 12345678);
insert into posting
values(5, 20, 'Great conditions! Send me a message if interested!', 'IMG4.jpg', 'N', 9780262017350, 13579246);
insert into sellers_sell_textbook
values(12345678, 9780321776419);
insert into sellers_sell_textbook
values(87654321, 9780262017350);
insert into sellers_sell_textbook
values(13579246, 9780323355636);
insert into sellers_sell_textbook
values(97531246, 9780323355636);
insert into sellers_sell_textbook
values(90863758, 9780321776419);