-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathinsertions.sql
419 lines (341 loc) · 18 KB
/
insertions.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
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
use PostGradDB;
--user1
declare @user1 int
INSERT INTO PostGradUser Values('[email protected]','Mohamed@1')
set @user1= scope_identity();
INSERT INTO GucianStudent Values(@user1,'Mohamed','Khaled','Master','Engineering','south 90 street,NewCairo',2.8,1024)
INSERT INTO GucStudentPhoneNumber Values(@user1,'01111073465')
declare @user14 int
INSERT INTO PostGradUser Values('[email protected]','Hany45&8Gj')
set @user14=scope_identity();
INSERT INTO Supervisor Values(@user14,'Hany ElSharkawy','Engineering')
DECLARE @payment1 INT
INSERT INTO Payment Values(20350,2,10.5)
set @payment1=scope_identity();
INSERT INTO Thesis Values(1,'Artificial Intelligence','Master','AI Real Life Applications','2021/12/20','2022/8/3','2022/8/8',80.5,@payment1,3)
INSERT INTO GUCianStudentRegisterThesis Values(@user1,@user14,1)
INSERT INTO GUCianProgressReport Values(@user1,1,'2022/2/1',80,'in progress',1,@user14)
INSERT INTO Installment Values('2022/1/20',@payment1,6000,0)
INSERT INTO Defense Values(1,'2022/8/8','GUC Campus',80.5)
DECLARE @pub1 INT
INSERT INTO Publication Values('Artificial Intelligence','2022/10/8','GUC Campus',0,'GUC Campus')
set @pub1=scope_identity();
INSERT INTO ThesisHasPublication Values(1,@pub1)
DECLARE @user24 INT
INSERT INTO PostGradUser Values('[email protected]','John**2435')
set @user24=scope_identity();
INSERT INTO Examiner Values(@user24,'John Mikel','Computer Science',0)
INSERT INTO ExaminerEvaluateDefense Values('2022/8/8',1,@user24,'Accepted')
--user2
declare @user2 int
INSERT INTO PostGradUser Values('[email protected]','Amir+2345')
set @user2= scope_identity();
INSERT INTO GucianStudent Values(@user2,'Amir','Magdy','PHD','Engineering','2 Al-sobky street,MasrElGedida',1.5,1025)
INSERT INTO GucStudentPhoneNumber Values(@user2,'01121044465')
declare @user15 INT
INSERT INTO PostGradUser Values('[email protected]','Magdyy56$')
set @user15=scope_identity();
INSERT INTO Supervisor Values(@user15,'Mohamed Magdy','Engineering')
DECLARE @payment2 INT
INSERT Into Payment Values(30000,3,12.5)
set @payment2=scope_identity();
INSERT Into Thesis Values(2,'Cryptography','PHD','Science Of Coding','2021/12/30','2023/4/4','2023/4/8',67.8,@payment2,2)
INSERT INTO Installment Values('2022/3/3',@payment2,15000,0)
INSERT INTO GUCianStudentRegisterThesis Values(@user2,@user15,2)
INSERT INTO Defense Values(2,'2023/4/8','GUC Campus',67.8)
INSERT INTO GUCianProgressReport Values(@user2,2,'2022/8/1',68,'in progress',2,@user15)
DECLARE @pub2 INT
INSERT INTO Publication Values('Cryptography','2023/4/20','GUC Campus',0,'GUC Campus')
set @pub2=scope_identity();
INSERT INTO ThesisHasPublication Values(2,@pub2)
Declare @user25 INT
INSERT INTO PostGradUser Values('[email protected]','Ahmedfg^&*')
set @user25=scope_identity();
INSERT INTO Examiner Values(@user25,'Ahmed Amin','Cryptography',1)
INSERT INTO ExaminerEvaluateDefense Values('2023/4/8',2,@user25,'Accepted')
--user3
declare @user3 int
INSERT INTO PostGradUser Values('[email protected]','Ahmed$267')
set @user3= scope_identity();
INSERT INTO GucianStudent Values(@user3,'Ahmed','Bedair','PHD','Management','12 Ahmed Aly Street,NasrCity',1.9,1027)
INSERT INTO GucStudentPhoneNumber Values(@user3,'01152073490')
declare @user16 INT
INSERT INTO PostGradUser Values('[email protected]','Mosalah@#10')
set @user16=scope_identity();
INSERT INTO Supervisor Values(@user16,'Mohamed Salah','Management')
DECLARE @payment3 INT
INSERT INTO Payment Values(25000,4,15.7)
set @payment3=scope_identity();
INSERT INTO Thesis Values(3,'Digital Marketing','PHD','Influence of digital marketing on start-ups','2021/12/19','2023/8/19','2023/8/25',89.5,@payment3,4)
INSERT INTO Installment Values('2022/4/4',@payment3,4000,0)
INSERT INTO GUCianStudentRegisterThesis Values(@user3,@user16,3)
INSERT INTO Defense Values(3,'2023/8/25','Conrad Hotel',89.5)
INSERT INTO GUCianProgressReport Values(@user3,1,'2022/5/1',90,'in progress',3,@user16)
Declare @pub3 INT
INSERT INTO Publication Values('Digital Marketing','2023/9/25','Conrad Hotel',0,'Conrad Hotel')
set @pub3=scope_identity();
INSERT INTO ThesisHasPublication Values(3,@pub3)
declare @user26 INT
INSERT INTO PostGradUser Values('[email protected]','CHristian67$$')
set @user26=scope_identity();
INSERT INTO Examiner Values(@user26,'Christian Schubert','Digital Marketing',0)
INSERT INTO ExaminerEvaluateDefense Values('2023/8/25',3,@user26,'Accepted')
--user4
declare @user4 int
INSERT INTO PostGradUser Values('[email protected]','Mahmoud#456')
set @user4= scope_identity();
INSERT INTO GucianStudent Values(@user4,'Mahmoud','Khaled','Master','Management','8 Mohamed Hamed street,Giza',2.4,1028)
INSERT INTO GucStudentPhoneNumber Values(@user4,'01011043415')
declare @user17 INT
INSERT INTO PostGradUser Values('[email protected]','ADhoumm56$$')
set @user17=scope_identity();
INSERT INTO Supervisor Values(@user17,'Adham Saleh','Management')
DECLARE @payment4 INT
INSERT INTO Payment Values(22000,3,21)
set @payment4=scope_identity();
INSERT INTO Thesis Values(4,'MBA','Master','Master of Business Adminstration','2021/12/25','2022/12/25','2022/12/30',70.5,@payment4,2)
INSERT INTO Installment Values('2022/4/3',@payment4,11000,0)
INSERT INTO GUCianStudentRegisterThesis Values(@user4,@user17,4)
INSERT INTO Defense Values(4,'2022/12/30','Conrad Hotel',70.5)
INSERT INTO GUCianProgressReport Values(@user4,4,'2022/3/1',71,'in progress',4,@user17)
DECLARE @pub4 INT
INSERT INTO Publication Values('MBA','2023/1/8','Conrad Hotel',0,'Conrad Hotel')
set @pub4=scope_identity();
INSERT INTO ThesisHasPublication Values(4,@pub4)
declare @user27 INT
INSERT INTO PostGradUser Values('[email protected]','Seif56$$')
set @user27=scope_identity();
INSERT INTO Examiner Values(@user27,'Seif Gamal','Finance',1)
INSERT INTO ExaminerEvaluateDefense Values('2022/12/30',4,@user27,'Accepted')
--user5
declare @user5 int
INSERT INTO PostGradUser Values('[email protected]','Mahmoud!675')
set @user5= scope_identity();
INSERT INTO GucianStudent Values(@user5,'Mahmoud','Kased','PHD','Law','ElRehabCity,NewCairo',1.3,1030)
INSERT INTO GucStudentPhoneNumber Values(@user5,'01141173473')
declare @user18 INT
INSERT INTO PostGradUser Values('[email protected]','Hatemm87&&')
set @user18=scope_identity();
INSERT INTO Supervisor Values(@user18,'Hatem Ali','Law')
DECLARE @payment5 INT
INSERT INTO Payment Values(32000,5,32.7)
set @payment5=scope_identity();
INSERT INTO Thesis Values(5,'Arbitration','PHD','Arbitration International Law','2022/1/1','2024/1/1','2024/1/5',92.4,@payment5,1)
INSERT INTO Installment Values('2022/8/8',@payment5,32000,0)
INSERT INTO GUCianStudentRegisterThesis Values(@user5,@user18,5)
INSERT INTO Defense Values(5,'2024/1/5','Fairmont Hotel',92.4)
INSERT INTO GUCianProgressReport Values(@user5,5,'2023/1/18',92,'in progress',5,@user18)
DECLARE @pub5 INT
INSERT INTO Publication Values('Arbitration','2024/1/20','Fairmont Hotel',0,'Fairmont Hotel')
set @pub5=scope_identity();
INSERT INTO ThesisHasPublication Values(5,@pub5)
declare @user28 INT
INSERT INTO PostGradUser Values('[email protected]','karlyy78%')
set @user28=scope_identity();
INSERT INTO Examiner Values(@user28,'Karl Jimenez','Arbitration',0)
INSERT INTO ExaminerEvaluateDefense Values('2024/1/5',5,@user28,'Accepted')
--user6
declare @user6 int
INSERT INTO PostGradUser Values('[email protected]','John%275')
set @user6= scope_identity();
INSERT INTO NonGucianStudent Values(@user6,'John','Nabil','Master','Law','8 Mohamed Ibrahim Street,Maadi',2.6)
INSERT INTO NonGucStudentPhoneNumber Values(@user6,'01129175465')
Declare @course1 INT
INSERT INTO Course Values(8000,4,501)
set @course1 =scope_identity();
INSERT INTO NonGucianStudentTakeCourse Values(@user6,@course1,90)
declare @user19 INT
INSERT INTO PostGradUser Values('[email protected]','Haythamm45%%')
set @user19=scope_identity();
INSERT INTO Supervisor Values(@user19,'Haytham Raouf','Law')
DECLARE @payment6 INT
INSERT INTO Payment Values(27000,2,26.8)
set @payment6=scope_identity();
INSERT INTO Thesis Values(6,'International Law','Master','Master In International Law','2021/12/15','2022/5/5','2022/5/10',52.5,@payment6,3)
INSERT INTO Installment Values('2022/1/20',@payment6,9000,0)
INSERT INTO NonGUCianStudentRegisterThesis Values(@user6,@user19,6)
INSERT INTO Defense Values(6,'2022/5/10','GUC Campus',52.5)
INSERT INTO NonGUCianProgressReport Values(@user6,1,'2022/1/23',53,'in progress',6,@user19)
INSERT INTO NonGucianStudentPayForCourse Values(@user6,@payment6,@course1)
DECLARE @pub6 INT
INSERT INTO Publication Values('International Law','2023/6/20','GUC Campus',0,'GUC Campus')
set @pub6=scope_identity();
INSERT INTO ThesisHasPublication Values(6,@pub6)
declare @user29 INT
INSERT INTO PostGradUser Values('[email protected]','Amir456**')
set @user29=scope_identity();
INSERT INTO Examiner Values(@user29,'Amer Lotfy','International Law',1)
INSERT INTO ExaminerEvaluateDefense Values('2022/5/10',6,@user29,'Accepted')
--user7
declare @user7 int
INSERT INTO PostGradUser Values('[email protected]','Yasser&890')
set @user7= scope_identity();
INSERT INTO NonGucianStudent Values(@user7,'Yasser','Fahmy','PHD','Engineering','9 Nakhla elmotyaey Street,MasrElGedida',1.0)
INSERT INTO NonGucStudentPhoneNumber Values(@user7,'01111190465')
declare @course2 INT
INSERT INTO Course Values(10000,5,504)
set @course2 =scope_identity();
INSERT INTO NonGucianStudentTakeCourse Values(@user7,@course2,75)
declare @user20 INT
INSERT INTO PostGradUser Values('[email protected]','Haze,m45*')
set @user20=scope_identity();
INSERT INTO Supervisor Values(@user20,'Hazem Walid','Engineering')
DECLARE @payment7 INT
INSERT INTO Payment Values(19700,2,12.5)
set @payment7=scope_identity();
INSERT INTO Thesis Values(7,'Software Engineering','PHD','Applications On Software Engineering','2021/11/18','2023/4/23','2023/11/30',85.8,@payment7,2)
INSERT INTO Installment Values('2022/5/5',@payment7,9650,0)
INSERT INTO NonGUCianStudentRegisterThesis Values(@user7,@user20,7)
INSERT INTO Defense Values(7,'2023/11/30','Fairmont Hotel',85.8)
INSERT INTO NonGUCianProgressReport Values(@user7,2,'2022/4/23',86,'in progress',7,@user20)
INSERT INTO NonGucianStudentPayForCourse Values(@user7,@payment7,@course2)
DECLARE @pub7 INT
INSERT INTO Publication Values('Software Engineering','2023/12/20','Fairmont Hotel',0,'Fairmont Hotel')
set @pub7=scope_identity();
INSERT INTO ThesisHasPublication Values(7,@pub7)
declare @user30 INT
INSERT INTO PostGradUser Values('[email protected]','Rodolf%4fg')
set @user30=scope_identity();
INSERT INTO Examiner Values(@user30,'Rodolf Armando','Software Engineering',0)
INSERT INTO ExaminerEvaluateDefense Values('2023/11/30',7,@user30,'Accepted')
--user8
declare @user8 int
INSERT INTO PostGradUser Values('[email protected]','Nader45%71')
set @user8= scope_identity();
INSERT INTO NonGucianStudent Values(@user8,'Nader','Ahmed','Master','Management','17 Morad Ahmed Street,6thOctober',3.0)
INSERT INTO NonGucStudentPhoneNumber Values(@user8,'01149575465')
declare @course3 INT
INSERT INTO Course Values(15000,8,101)
set @course3 =scope_identity();
INSERT INTO NonGucianStudentTakeCourse Values(@user8,@course3,83)
declare @user21 INT
INSERT INTO PostGradUser Values('[email protected]','ADoull89$')
set @user21=scope_identity();
INSERT INTO Supervisor Values(@user21,'Adel Sleem','Management')
DECLARE @payment8 INT
INSERT INTO Payment Values(35000,4,8.7)
set @payment8=scope_identity();
INSERT INTO Thesis Values(8,'Accounting','Master','Fundementals Of Accounting','2021/10/4','2022/6/19','2022/6/29',77.8,@payment8,5)
INSERT INTO Installment Values('2021/11/2',@payment8,7000,0)
INSERT INTO NonGUCianStudentRegisterThesis Values(@user8,@user21,8)
INSERT INTO Defense Values(8,'2022/6/29','ALAzhar Confrenece Center',77.8)
INSERT INTO NonGUCianProgressReport Values(@user8,3,'2022/2/24',78,'in progress',8,@user21)
INSERT INTO NonGucianStudentPayForCourse Values(@user8,@payment8,@course3)
DECLARE @pub8 INT
INSERT INTO Publication Values('Accounting','2022/12/20','AlAzhar Conference Center',0,'AlAzhar Conference Center')
set @pub8=scope_identity();
INSERT INTO ThesisHasPublication Values(8,@pub8)
declare @user31 INT
INSERT INTO PostGradUser Values('[email protected]','Hazem456+')
set @user31=scope_identity();
INSERT INTO Examiner Values(@user31,'Hazem Amin','Accounting',1)
INSERT INTO ExaminerEvaluateDefense Values('2022/6/29',8,@user31,'Accepted')
--user9
declare @user9 int
INSERT INTO PostGradUser Values('[email protected]','Ismail78$90')
set @user9= scope_identity();
INSERT INTO NonGucianStudent Values(@user9,'Ismail','Hamdy','PHD','Pharmacy','19 Ahmed Khalil Street,6thOctober',1.3)
INSERT INTO NonGucStudentPhoneNumber Values(@user9,'01129995465')
declare @course4 INT;
INSERT INTO Course Values(14000,8,502)
set @course4 =scope_identity();
INSERT INTO NonGucianStudentTakeCourse Values(@user9,@course4,68)
declare @user22 INT
INSERT INTO PostGradUser Values('[email protected]','Ahmedfh$%67')
set @user22=scope_identity();
INSERT INTO Supervisor Values(@user22,'Ahmed Walid','Pharmacy')
DECLARE @payment9 INT
INSERT INTO Payment Values(44750,5,29.7)
set @payment9=scope_identity();
INSERT INTO Thesis Values(9,'Pharmacuetical Industry','PHD','PHD In Pharmacuetical Industry','2021/8/8','2023/12/15','2023/12/25',88.3,@payment9,4)
INSERT INTO Installment Values('2021/10/20',@payment9,11185,0)
INSERT INTO NonGUCianStudentRegisterThesis Values(@user9,@user22,9)
INSERT INTO Defense Values(9,'2023/12/25','ALAzhar Conference Center',88.3)
INSERT INTO NonGUCianProgressReport Values(@user9,4,'2022/12/23',88,'in progress',9,@user22)
INSERT INTO NonGucianStudentPayForCourse Values(@user9,@payment9,@course4)
DECLARE @pub9 INT
INSERT INTO Publication Values('Pharmacuetical Industry','2022/12/20','AlAzhar Conference Center',0,'AlAzhar Conference Center')
set @pub9=scope_identity();
INSERT INTO ThesisHasPublication Values(9,@pub9)
declare @user32 INT
INSERT INTO PostGradUser Values('[email protected]','Ricardo987+')
set @user32=scope_identity();
INSERT INTO Examiner Values(@user32,'Ricardo Pina','Pharmacuetical Industry',0)
INSERT INTO ExaminerEvaluateDefense Values('2023/12/25',9,@user32,'Accepted')
--user10
declare @user10 int
INSERT INTO PostGradUser Values('[email protected]','Hamed56@390')
set @user10= scope_identity();
INSERT INTO NonGucianStudent Values(@user10,'Mohamed','Hamed','Master','Pharmacy','5 AbbasAlAkkad Street,NasrCity',2.2)
INSERT INTO NonGucStudentPhoneNumber Values(@user10,'01145084075')
declare @course5 INT;
INSERT INTO Course Values(6000,4,503)
set @course5 =scope_identity();
INSERT INTO NonGucianStudentTakeCourse Values(@user10,@course5,59)
declare @user23 INT
INSERT INTO PostGradUser Values('[email protected]','Ramyyty^56')
set @user23=scope_identity();
INSERT INTO Supervisor Values(@user23,'Ramy Malek','Pharmacy')
DECLARE @payment10 INT
INSERT INTO Payment Values(24750,3,23.4)
set @payment10=scope_identity();
INSERT INTO Thesis Values(10,'viruses','Master','Master In Viruses','2021/9/23','2022/8/1','2022/8/10',74.8,@payment10,3)
INSERT INTO Installment Values('2021/12/1',@payment10,8250,0)
INSERT INTO NonGUCianStudentRegisterThesis Values(@user10,@user23,10)
INSERT INTO Defense Values(10,'2022/8/10','GUC Campus',74.8)
INSERT INTO NonGUCianProgressReport Values(@user10,5,'2022/2/18',75,'in progress',10,@user23)
INSERT INTO NonGucianStudentPayForCourse Values(@user10,@payment10,@course5)
DECLARE @pub10 INT
INSERT INTO Publication Values('viruses','2022/12/20','GUC Campus',0,'GUC Campus')
set @pub10=scope_identity();
INSERT INTO ThesisHasPublication Values(10,@pub10)
declare @user33 INT
INSERT INTO PostGradUser Values('[email protected]','Yasser67#@i')
set @user33=scope_identity();
INSERT INTO Examiner Values(@user33,'Yasser Gamal','Medical Research',1)
INSERT INTO ExaminerEvaluateDefense Values('2022/8/10',10,@user33,'Accepted')
--Admin1
declare @user11 int
INSERT INTO PostGradUser Values('[email protected]','Omar45^781')
set @user11= scope_identity();
INSERT INTO Admin Values(@user11)
--Admin2
declare @user12 int
INSERT INTO PostGradUser Values('[email protected]','Walid45#00')
set @user12= scope_identity();
INSERT INTO Admin Values(@user12)
--Admin3
declare @user13 int
INSERT INTO PostGradUser Values('[email protected]','Belalf35&8')
set @user13= scope_identity();
INSERT INTO Admin Values(@user13)
DECLARE @payment11 INT
INSERT INTO Payment Values(55867,6,50)
set @payment11=scope_identity();
INSERT INTO Thesis Values(11,'Robotics','PHD','Theory Of Robotics','2021/9/4','2023/8/26','2023/9/2',66.7,@payment11,1)
INSERT INTO Installment Values('2022/6/20',@payment11,55867,0)
INSERT INTO Defense Values(11,'2023/9/2','Marriot Hotel',66.7)
DECLARE @payment12 INT
INSERT INTO Payment Values(39750,2,67)
set @payment12=scope_identity();
INSERT INTO Thesis Values(12,'Machine Learning','Master','Theory of Machine Learning','2021/3/3','2022/2/1','2022/2/7',95.2,@payment12,1)
INSERT INTO Installment Values('2021/12/20',@payment12,39750,0)
INSERT INTO Defense Values(12,'2022/2/7','Marriot Hotel',95.2)
DECLARE @payment13 INT
INSERT INTO Payment Values(34850,1,67.9)
set @payment13=scope_identity();
INSERT INTO Thesis Values(13,'Data Science','Master','Fundementals of Data Science','2021/3/28','2022/1/1','2022/1/15',79.8,@payment13,3)
INSERT INTO Installment Values('2021/5/20',@payment13,11280,0)
INSERT INTO Defense Values(13,'2022/1/15','ALSalam Conference Center',79.8)
DECLARE @Payment14 INT
INSERT INTO Payment Values(40850,4,44.8)
set @payment14=scope_identity();
INSERT INTO Thesis Values(14,'Networks','PHD','Networks Analogy','2021/7/7','2022/7/7','2022/7/20',95.2,@payment14,4)
INSERT INTO Installment Values('2021/8/20',@payment14,10212.5,0)
INSERT INTO Defense Values(14,'2022/7/20','ALSalam Conference Center',95.2)
DECLARE @payment15 INT
INSERT INTO Payment Values(60500,6,33.7)
set @payment15=scope_identity();
INSERT INTO Thesis Values(15,'Cyber Security','PHD','Fundementals Of Cyber Security','2021/7/7','2023/7/7','2023/7/25',82.2,@payment15,2)
INSERT INTO Installment Values('2022/1/20',@payment15,30250,0)
INSERT INTO Defense Values(15,'2023/7/25','GUC Campus',82.2)