-
Notifications
You must be signed in to change notification settings - Fork 0
/
QRMS_output_2.sql
899 lines (772 loc) · 217 KB
/
QRMS_output_2.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
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
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
-- MySQL dump 10.13 Distrib 5.1.33, for Win32 (ia32)
--
-- Host: localhost Database: qrmsdb
-- ------------------------------------------------------
-- Server version 5.1.33-community
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `companion_course`
--
DROP TABLE IF EXISTS `companion_course`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `companion_course` (
`id` int(11) NOT NULL,
`companion_course` varchar(255) DEFAULT NULL,
`course_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKlwr2s9unw4sy1fficmxak2s0v` (`companion_course`),
KEY `FKpipt9gv1rpn7ecohrf74mx8p1` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `companion_course`
--
LOCK TABLES `companion_course` WRITE;
/*!40000 ALTER TABLE `companion_course` DISABLE KEYS */;
INSERT INTO `companion_course` VALUES (44,'510106A','510101'),(45,'510106B','510102'),(46,'510106C','510103'),(47,'510106D','510104'),(1,'410254A','410250'),(2,'410254B','410251'),(10,'410255B','410253'),(11,'410255A','410252'),(12,'410246A','410242'),(13,'410246B','410243'),(14,'410247A','410244A'),(15,'410247A','410244B'),(16,'410247A','410244C'),(17,'410247A','410244D'),(18,'410247B','410245A'),(19,'410247B','410245B'),(20,'410247B','410245C'),(21,'410247B','410245D'),(22,'310257','310251'),(23,'310258','310252'),(24,'310256','310254'),(28,'310247','310242'),(29,'310248','310245'),(32,'210255','210251'),(33,'210256','210252'),(34,'210257','210253'),(38,'210246','210242'),(39,'210247','210243'),(40,'210248','210245');
/*!40000 ALTER TABLE `companion_course` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `course`
--
DROP TABLE IF EXISTS `course`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `course` (
`course_id` varchar(255) NOT NULL,
`course_credits` int(11) DEFAULT NULL,
`course_name` varchar(255) DEFAULT NULL,
`course_sem` int(11) DEFAULT NULL,
`course_type` char(1) DEFAULT NULL,
`course_year` varchar(255) DEFAULT NULL,
`is_theory` int(11) DEFAULT NULL,
`no_of_hours` int(11) DEFAULT NULL,
`stud_allocation_flag` int(11) DEFAULT NULL,
`dept_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`course_id`),
KEY `FKq35kfet2x1flha9h3pxai43hw` (`dept_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `course`
--
LOCK TABLES `course` WRITE;
/*!40000 ALTER TABLE `course` DISABLE KEYS */;
INSERT INTO `course` VALUES ('610101',4,'Fault Tolerant Systems',3,'R','ME2',1,4,0,'CO'),('610102',4,'Information Retrieval',3,'R','ME2',1,4,0,'CO'),('610103',5,'Elective 3',3,'E','ME2',1,5,0,'CO'),('510108',4,'Operations Research',2,'R','ME1',1,4,0,'CO'),('510109',4,'System Simulation and Modeling',2,'R','ME1',1,5,0,'CO'),('510110',4,'Machine Learning',2,'R','ME1',1,4,0,'CO'),('510111',5,'Elective 2',2,'E','ME1',1,5,0,'CO'),('510113',4,'LP-2',2,'R','ME1',0,4,0,'CO'),('510101',4,'Research Methodology',1,'R','ME1',1,5,0,'CO'),('510102',4,'Bio-Inspired Optimization Algorithms',1,'R','ME1',1,5,0,'CO'),('510103',4,'Software Development and Version Control',1,'R','ME1',1,5,0,'CO'),('510104',4,'Embedded and Real Time Operating Systems',1,'R','ME1',1,5,0,'CO'),('510105',5,'Elective 1',1,'E','ME1',1,6,0,'CO'),('510106A',4,'LP1-Research Methodology',1,'R','ME1',0,2,0,'CO'),('510106B',4,'LP1-Bio-Inspired Optimization Algorithms',1,'R','ME1',0,2,0,'CO'),('510106C',4,'LP1-Software Development and Version Control',1,'R','ME1',0,2,0,'CO'),('510106D',4,'LP1-Research Methodology',1,'R','ME1',0,2,0,'CO'),('410250',3,'Machine Learning',8,'R','BE',1,3,0,'CO'),('410251',3,'Information and Cyber Security',8,'R','BE',1,3,0,'CO'),('410252',3,'Elective 3',8,'E','BE',1,3,0,'CO'),('410253',3,'Elective 4',8,'E','BE',1,3,0,'CO'),('410254A',1,'LP3-Machine Learning',8,'R','BE',0,2,0,'CO'),('410254B',1,'LP3-Information and Cyber Security',8,'R','BE',0,2,0,'CO'),('410255A',1,'LP4-Elective 3',8,'E','BE',0,2,0,'CO'),('410255B',1,'LP4-Elective 4',8,'E','BE',0,2,0,'CO'),('410241',4,'High Performance Computing',7,'R','BE',1,4,0,'CO'),('410242',3,'Artificial Intelligence and Robotics',7,'R','BE',1,3,0,'CO'),('410243',3,'Data Analytics',7,'R','BE',1,3,0,'CO'),('410244',3,'Elective 1',7,'E','BE',1,3,0,'CO'),('410245',3,'Elective 2',7,'E','BE',1,3,0,'CO'),('410246A',1,'LP1-Data Analytics',7,'R','BE',0,2,0,'CO'),('410246B',1,'LP1-Artificial Intelligence and Robotics',7,'R','BE',0,2,0,'CO'),('410247A',1,'LP2-Elective 1',7,'E','BE',0,2,0,'CO'),('410247B',1,'LP2-Elective 2',7,'E','BE',0,2,0,'CO'),('310250',4,'Design and Analysis of Algorithms',6,'R','TE',1,4,0,'CO'),('310251',4,'System Programming and Operating System',6,'R','TE',1,4,0,'CO'),('310252',4,'Embedded Systems and Internet of Things',6,'R','TE',1,4,0,'CO'),('310253',3,'Software Modeling and Design',6,'R','TE',1,3,0,'CO'),('310254',3,'Web Technology',6,'R','TE',1,3,0,'CO'),('310256',1,'Web TEchnology Lab',6,'R','TE',0,2,0,'CO'),('310257',2,'SPOS Lab',6,'R','TE',0,4,0,'CO'),('310258',1,'ESIOT Lab',5,'R','TE',0,2,0,'CO'),('310241',3,'Theory of Computation',5,'R','TE',1,3,0,'CO'),('310242',3,'Database Management System',5,'R','TE',1,3,0,'CO'),('310243',3,'Software Engineering and Project Management',5,'R','TE',1,3,0,'CO'),('310244',3,'Information Systems and Engineering Economics',5,'R','TE',1,3,0,'CO'),('310245',4,'Computer Networks',5,'R','TE',1,4,0,'CO'),('310246',4,'Skill Development Lab',5,'R','TE',0,4,0,'CO'),('310246A',0,'Skill Development Lab (Tut)',5,'R','TE',1,2,0,'CO'),('310247',2,'DBMS Lab',5,'R','TE',0,4,0,'CO'),('310248',1,'CN Lab',5,'R','TE',0,2,0,'CO'),('207003',5,'Engineering Mathematics 3',4,'R','SE',1,5,0,'CO'),('210251',4,'Computer Graphics',4,'R','SE',1,4,0,'CO'),('210252',4,'Advanced Data Structures',4,'R','SE',1,4,0,'CO'),('210253',4,'Microprocessor',4,'R','SE',1,4,0,'CO'),('210254',3,'Principles of Programming Language',4,'R','SE',1,3,0,'CO'),('210255',1,'CG Lab',4,'R','SE',0,2,0,'CO'),('210256',2,'ADSL Lab',4,'R','SE',0,4,0,'CO'),('210257',2,'MP Lab',4,'R','SE',0,4,0,'CO'),('210241',4,'Discrete Mathematics',3,'R','SE',1,4,0,'CO'),('210242',4,'Digital Electronics and Logic Design',3,'R','SE',1,4,0,'CO'),('210243',4,'Data Structures and Algorithms',3,'R','SE',1,4,0,'CO'),('210244',4,'Computer Organization and Architecture',3,'R','SE',1,4,0,'CO'),('210245',4,'Object Oriented Programming',3,'R','SE',1,4,0,'CO'),('210246',1,'DELD Lab',3,'R','SE',0,2,0,'CO'),('210247',2,'DSA Lab',3,'R','SE',0,4,0,'CO'),('210248',1,'OOP Lab',3,'R','SE',0,2,0,'CO'),('210249',1,'Soft Skills',3,'R','SE',0,2,0,'CO');
/*!40000 ALTER TABLE `course` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `course_list_faculty`
--
DROP TABLE IF EXISTS `course_list_faculty`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `course_list_faculty` (
`id` int(11) NOT NULL,
`course_id` varchar(255) DEFAULT NULL,
`division_id` varchar(255) DEFAULT NULL,
`faculty_id` varchar(255) DEFAULT NULL,
`no_of_hours` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `course_list_faculty`
--
LOCK TABLES `course_list_faculty` WRITE;
/*!40000 ALTER TABLE `course_list_faculty` DISABLE KEYS */;
INSERT INTO `course_list_faculty` VALUES (1056,'610103D','ME2CO-610103D-1','',5),(1710,'610103D','ME2CO-610103D-1','',5),(1494,'510105D','ME1CO-510105D-1','',6),(1274,'610103D','ME2CO-610103D-1','',5),(1492,'610103D','ME2CO-610103D-1','',5),(1491,'610103A','ME2CO-610103A-1','',5),(1709,'610103A','ME2CO-610103A-1','',5),(1915,'610103A','ME2CO-610103A-1','',5),(2124,'510105D','ME1CO-510105D-1','',6),(2330,'510105D','ME1CO-510105D-1','',6),(2122,'610103D','ME2CO-610103D-1','',5),(2121,'610103A','ME2CO-610103A-1','',5),(2537,'410244B','BECO-410244B-1','fac6',3),(2328,'610103D','ME2CO-610103D-1','',5),(2327,'610103A','ME2CO-610103A-1','',5),(2536,'510105D','ME1CO-510105D-1','',6),(1696,'210241','SECOC','',4),(2535,'510105B','ME1CO-510105B-1','fac35',6),(2534,'610103D','ME2CO-610103D-1','',5),(1693,'310246A','TECOC','',2),(1902,'210241','SECOC','',4),(2533,'610103A','ME2CO-610103A-1','',5),(2532,'210245','SECOC','fac8',4),(1899,'310246A','TECOC','',2),(2531,'210245','SECOB','fac12',4),(2530,'210245','SECOA','fac5',4),(2529,'210244','SECOC','fac14',4),(838,'610103D','ME2CO-610103D-1','',5),(2108,'210241','SECOC','',4),(2528,'210244','SECOB','fac14',4),(2527,'210244','SECOA','fac15',4),(2526,'210243','SECOC','fac7',4),(2525,'210243','SECOB','fac25',4),(2314,'210241','SECOC','',4),(846,'410245C','BECO-410245C-1','',3),(2105,'310246A','TECOC','',2),(2524,'210243','SECOA','fac11',4),(2523,'210242','SECOC','fac29',4),(2311,'310246A','TECOC','',2),(2522,'210242','SECOB','fac26',4),(2521,'210242','SECOA','fac26',4),(2520,'210241','SECOC','',4),(1064,'410245C','BECO-410245C-1','',3),(2519,'210241','SECOB','fac36',4),(2518,'210241','SECOA','fac36',4),(2517,'310246A','TECOC','',2),(2516,'310246A','TECOB','fac21',2),(2515,'310246A','TECOA','fac22',2),(1282,'410245C','BECO-410245C-1','',3),(2514,'310245','TECOC','fac27',4),(2513,'310245','TECOB','fac17',4),(2512,'310245','TECOA','fac17',4),(2511,'310244','TECOC','fac16',3),(2510,'310244','TECOB','fac16',3),(1500,'410245C','BECO-410245C-1','',3),(1916,'610103D','ME2CO-610103D-1','',5),(1712,'510105D','ME1CO-510105D-1','',6),(2509,'310244','TECOA','fac31',3),(2508,'310243','TECOC','fac6',3),(2507,'310243','TECOB','fac34',3),(2506,'310243','TECOA','fac34',3),(2505,'310242','TECOC','fac10',3),(2504,'310242','TECOB','fac18',3),(2503,'310242','TECOA','fac13',3),(1918,'510105D','ME1CO-510105D-1','',6),(2502,'310241','TECOC','fac8',3),(2501,'310241','TECOB','fac30',3),(2500,'310241','TECOA','fac30',3),(2499,'410243','BECOC','fac9',3),(2498,'410243','BECOB','fac28',3),(2497,'410243','BECOA','fac2',3),(2496,'410242','BECOC','fac32',3),(2495,'410242','BECOB','fac20',3),(2494,'410242','BECOA','fac20',3),(2493,'410241','BECOC','fac24',4),(2492,'410241','BECOB','fac19',4),(2491,'410241','BECOA','fac19',4),(2490,'510104','ME1COA','fac15',5),(2489,'510103','ME1COA','fac4',5),(2488,'510102','ME1COA','fac3',5),(2487,'510101','ME1COA','fac1',5),(2486,'610102','ME2COA','fac35',4),(2485,'610101','ME2COA','fac22',4),(2538,'410244C','BECO-410244C-1','fac21',3),(2539,'410244D','BECO-410244D-1','fac23',3),(2540,'410245B','BECO-410245B-1','fac23',3),(2541,'410245B','BECO-410245B-2','fac24',3),(2542,'410245C','BECO-410245C-1','fac4',3);
/*!40000 ALTER TABLE `course_list_faculty` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `course_prerequisites`
--
DROP TABLE IF EXISTS `course_prerequisites`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `course_prerequisites` (
`course_id` varchar(255) NOT NULL,
`is_prereq_1_elective` int(11) DEFAULT NULL,
`is_prereq_2_elective` int(11) DEFAULT NULL,
`prereq1` varchar(255) DEFAULT NULL,
`prereq2` varchar(255) DEFAULT NULL,
PRIMARY KEY (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `course_prerequisites`
--
LOCK TABLES `course_prerequisites` WRITE;
/*!40000 ALTER TABLE `course_prerequisites` DISABLE KEYS */;
INSERT INTO `course_prerequisites` VALUES ('610101',-1,-1,'NA','NA'),('610102',-1,-1,'NA','NA'),('610103A',-1,-1,'NA','NA'),('610103B',-1,-1,'NA','NA'),('610103C',-1,-1,'NA','NA'),('610103D',-1,-1,'NA','NA'),('610103E',-1,-1,'NA','NA'),('510107',-1,-1,'NA','NA'),('510108',-1,-1,'NA','NA'),('510109',-1,-1,'NA','NA'),('510110A',-1,-1,'NA','NA'),('510110B',-1,-1,'NA','NA'),('510110C',-1,-1,'NA','NA'),('510110D',-1,-1,'NA','NA'),('510110E',-1,-1,'NA','NA'),('510101',-1,-1,'NA','NA'),('510102',-1,-1,'NA','NA'),('510103',-1,-1,'NA','NA'),('510104',-1,-1,'NA','NA'),('510105A',-1,-1,'NA','NA'),('510105B',-1,-1,'NA','NA'),('510105C',-1,-1,'NA','NA'),('510105D',-1,-1,'NA','NA'),('510105E',-1,-1,'NA','NA'),('410250',0,-1,'207003','NA'),('410251',0,-1,'310245','NA'),('410252A',1,-1,'410244A','NA'),('410252B',0,0,'310241','310251'),('410252C',0,-1,'310251','NA'),('410252D',0,-1,'310250','NA'),('410253A',0,-1,'310245','NA'),('410253B',0,-1,'210251','NA'),('410253C',-1,-1,'NA','NA'),('410253D',-1,-1,'NA','NA'),('410241',0,0,'210253','210244'),('410242',0,-1,'210254','NA'),('410243',0,-1,'310242','NA'),('410244A',0,-1,'207003','NA'),('410244B',0,-1,'310243','NA'),('410244C',0,-1,'310245','NA'),('410244D',0,0,'310242','310244'),('410245A',0,0,'310254','210254'),('410245B',0,0,'310243','310253'),('421245C',0,0,'210241','310243'),('410245D',0,-1,'310245','NA'),('310250',0,0,'210243','210252'),('310251',0,0,'210243','210252'),('310252',0,-1,'310245','NA'),('310253',0,-1,'310243','NA'),('310254',0,0,'310245','310242'),('310241',0,0,'210241','210254'),('310242',0,0,'210243','210252'),('310243',-1,-1,'NA','NA'),('310244',-1,-1,'NA','NA'),('310245',0,-1,'210244','NA'),('207003',-1,-1,'NA','NA'),('210251',0,-1,'210243','NA'),('210252',0,-1,'210243','NA'),('210253',0,-1,'210242','NA'),('210254',0,0,'210243','210245'),('210241',-1,-1,'NA','NA'),('210242',-1,-1,'NA','NA'),('210243',-1,-1,'NA','NA'),('210244',-1,-1,'NA','NA'),('210245',-1,-1,'NA','NA'),('410245C',0,0,'310243','210241');
/*!40000 ALTER TABLE `course_prerequisites` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `current_time_slots`
--
DROP TABLE IF EXISTS `current_time_slots`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `current_time_slots` (
`id` int(11) NOT NULL,
`activity` varchar(255) DEFAULT NULL,
`date` date DEFAULT NULL,
`day` varchar(255) DEFAULT NULL,
`end_time` time DEFAULT NULL,
`start_time` time DEFAULT NULL,
`activity_incharge` varchar(255) DEFAULT NULL,
`resource_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK9nf62x0p2xc3k1obqqx0lrfrf` (`activity_incharge`),
KEY `FKkaitn501l48o6scnvse3ptvtn` (`resource_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `current_time_slots`
--
LOCK TABLES `current_time_slots` WRITE;
/*!40000 ALTER TABLE `current_time_slots` DISABLE KEYS */;
/*!40000 ALTER TABLE `current_time_slots` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `department`
--
DROP TABLE IF EXISTS `department`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `department` (
`dept_id` varchar(255) NOT NULL,
`dept_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`dept_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `department`
--
LOCK TABLES `department` WRITE;
/*!40000 ALTER TABLE `department` DISABLE KEYS */;
INSERT INTO `department` VALUES ('CO','Computer Department'),('ME','Mechanical Department'),('EN','EnTC Department'),('IT','IT Department'),('CI','Civil Department');
/*!40000 ALTER TABLE `department` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `designation_to_hours`
--
DROP TABLE IF EXISTS `designation_to_hours`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `designation_to_hours` (
`designation` varchar(255) NOT NULL,
`max_limit` int(11) DEFAULT NULL,
`min_limit` int(11) DEFAULT NULL,
PRIMARY KEY (`designation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `designation_to_hours`
--
LOCK TABLES `designation_to_hours` WRITE;
/*!40000 ALTER TABLE `designation_to_hours` DISABLE KEYS */;
INSERT INTO `designation_to_hours` VALUES ('Professor',10,8),('Associate Professor',14,12),('Assistant Professor',18,16);
/*!40000 ALTER TABLE `designation_to_hours` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `divisions`
--
DROP TABLE IF EXISTS `divisions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `divisions` (
`div_id` varchar(255) NOT NULL,
`div_name` char(1) DEFAULT NULL,
`no_of_batches` int(11) DEFAULT NULL,
`year` varchar(255) DEFAULT NULL,
`dept_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`div_id`),
KEY `FK16w845hrv8u3b3vh4c7214hip` (`dept_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `divisions`
--
LOCK TABLES `divisions` WRITE;
/*!40000 ALTER TABLE `divisions` DISABLE KEYS */;
INSERT INTO `divisions` VALUES ('ME2COA','A',1,'ME2','CO'),('ME1COA','A',1,'ME1','CO'),('BECOA','A',4,'BE','CO'),('BECOB','B',4,'BE','CO'),('BECOC','C',4,'BE','CO'),('TECOA','A',4,'TE','CO'),('TECOB','B',4,'TE','CO'),('TECOC','C',4,'TE','CO'),('SECOA','A',4,'SE','CO'),('SECOB','B',4,'SE','CO'),('SECOC','C',4,'SE','CO');
/*!40000 ALTER TABLE `divisions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `elective_batches`
--
DROP TABLE IF EXISTS `elective_batches`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `elective_batches` (
`batch_id` varchar(255) NOT NULL,
`elective_id` varchar(255) DEFAULT NULL,
`year` varchar(255) DEFAULT NULL,
`dept_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`batch_id`),
KEY `FK5ftilcs119180cmi9ekoksou` (`dept_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `elective_batches`
--
LOCK TABLES `elective_batches` WRITE;
/*!40000 ALTER TABLE `elective_batches` DISABLE KEYS */;
INSERT INTO `elective_batches` VALUES ('ME2CO-610103A-1','610103A','ME2','CO'),('ME2CO-610103D-1','610103D','ME2','CO'),('ME1CO-510105D-1','510105D','ME1','CO'),('ME1CO-510105B-1','510105B','ME1','CO'),('BECO-410244D-1','410244D','BE','CO'),('BECO-410244C-1','410244C','BE','CO'),('BECO-410244B-1','410244B','BE','CO'),('BECO-410245C-1','410245C','BE','CO'),('BECO-410245B-1','410245B','BE','CO'),('BECO-410245B-2','410245B','BE','CO');
/*!40000 ALTER TABLE `elective_batches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `electives`
--
DROP TABLE IF EXISTS `electives`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `electives` (
`elective_course_id` varchar(255) NOT NULL,
`elective_name` varchar(255) DEFAULT NULL,
`course_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`elective_course_id`),
KEY `FKsv0774m02dvgu99mo1rsqsucb` (`course_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `electives`
--
LOCK TABLES `electives` WRITE;
/*!40000 ALTER TABLE `electives` DISABLE KEYS */;
INSERT INTO `electives` VALUES ('610103A','Cloud Security','610103'),('610103B','Speech Signal Processing','610103'),('610103C','Mobile Ad-hoc Networks','610103'),('610103D','Pattern Recognition','610103'),('610103E','Open Elective','610103'),('510111A','Image Processing','510111'),('510111B','Web Mining','510111'),('510111C','Pervasive and Ubiquitous Computing','510111'),('510111D','Network Security','510111'),('510111E','Open Elective','510111'),('510105A','Advanced Digital Signal Processing','510105'),('510105B','Data Mining','510105'),('510105C','Network Design and Analysis','510105'),('510105D','Data Algorithms','510105'),('510105E','Open Elective','510105'),('410253A','Software Defined Networks','410253'),('410253B','Human Computer Interface','410253'),('410253C','Cloud Computing','410253'),('410253D','Open Elective','410253'),('410252A','Adv Digital Signal Processing','410252'),('410252B','Compilers','410252'),('410252C','Embedded and Real time Operating System','410252'),('410252D','Soft Computing and Optimization Algorithms','410252'),('410245A','Distributed Systems','410245'),('410245B','Software Testing and Quality Assurance','410245'),('410245C','Operations Research','410245'),('410245D','Mobile Communication','410245'),('410244A','Digital Signal Processing','410244'),('410244B','Software Architecture and Design','410244'),('410244C','Pervasive and Ubiquitous Computing','410244'),('410244D','Data Mining and Warehousing','410244');
/*!40000 ALTER TABLE `electives` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `faculty_acad`
--
DROP TABLE IF EXISTS `faculty_acad`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `faculty_acad` (
`user_name` varchar(255) NOT NULL,
`designation` varchar(255) DEFAULT NULL,
`qualification` varchar(255) DEFAULT NULL,
`years_of_experience` double DEFAULT NULL,
`dept_id` varchar(255) DEFAULT NULL,
`user_dets` varchar(255) DEFAULT NULL,
PRIMARY KEY (`user_name`),
KEY `FK94icf6l4yec73egtcamgw5m17` (`dept_id`),
KEY `FKf889o7wt605hqljdbk5p3nay1` (`user_dets`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `faculty_acad`
--
LOCK TABLES `faculty_acad` WRITE;
/*!40000 ALTER TABLE `faculty_acad` DISABLE KEYS */;
INSERT INTO `faculty_acad` VALUES ('fac1','Professor','PHD',20,'CO','fac1'),('fac2','Professor','PHD',18.4,'CO','fac2'),('fac3','Professor','PHD',18.4,'CO','fac3'),('fac4','Assistant Professor','ME',8,'CO','fac4'),('fac5','Assistant Professor','ME',0,'CO','fac5'),('fac6','Associate Professor','ME',25,'CO','fac6'),('fac7','Assistant Professor','MTECH',15.5,'CO','fac7'),('fac8','Assistant Professor','ME',13,'CO','fac8'),('fac9','Assistant Professor','ME',15,'CO','fac9'),('fac10','Assistant Professor','ME',14,'CO','fac10'),('fac11','Assistant Professor','ME',13,'CO','fac11'),('fac12','Assistant Professor','BE',11,'CO','fac12'),('fac13','Assistant Professor','ME',12.2,'CO','fac13'),('fac14','Assistant Professor','ME',13,'CO','fac14'),('fac15','Assistant Professor','ME',14.8,'CO','fac15'),('fac16','Assistant Professor','ME',12,'CO','fac16'),('fac17','Assistant Professor','ME',8.6,'CO','fac17'),('fac18','Assistant Professor','ME',12,'CO','fac18'),('fac19','Assistant Professor','ME',10.5,'CO','fac19'),('fac20','Assistant Professor','ME',10,'CO','fac20'),('fac21','Assistant Professor','ME',10,'CO','fac21'),('fac22','Assistant Professor','ME',5.5,'CO','fac22'),('fac23','Assistant Professor','ME',7.11,'CO','fac23'),('fac24','Assistant Professor','ME',7.6,'CO','fac24'),('fac25','Assistant Professor','ME',5.4,'CO','fac25'),('fac26','Assistant Professor','MTECH',7.5,'CO','fac26'),('fac27','Assistant Professor','MTECH',10,'CO','fac27'),('fac28','Assistant Professor','ME',13,'CO','fac28'),('fac29','Assistant Professor','ME',9,'CO','fac29'),('fac30','Assistant Professor','ME',5.2,'CO','fac30'),('fac31','Assistant Professor','ME',3.4,'CO','fac31'),('fac32','Assistant Professor','MTECH',11.6,'CO','fac32'),('fac34','Professor','PHD',14.7,'CO','fac34'),('fac35','Assistant Professor','ME',14,'CO','fac35'),('fac36','Assistant Professor','ME',6.5,'CO','fac36');
/*!40000 ALTER TABLE `faculty_acad` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `faculty_alloc_course`
--
DROP TABLE IF EXISTS `faculty_alloc_course`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `faculty_alloc_course` (
`id` int(11) NOT NULL,
`course_id` varchar(255) DEFAULT NULL,
`is_elective` int(11) DEFAULT NULL,
`no_of_hrs` int(11) DEFAULT NULL,
`prefno` int(11) DEFAULT NULL,
`user_name` varchar(255) DEFAULT NULL,
`year` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `faculty_alloc_course`
--
LOCK TABLES `faculty_alloc_course` WRITE;
/*!40000 ALTER TABLE `faculty_alloc_course` DISABLE KEYS */;
/*!40000 ALTER TABLE `faculty_alloc_course` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `faculty_alloted_hours`
--
DROP TABLE IF EXISTS `faculty_alloted_hours`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `faculty_alloted_hours` (
`faculty_id` varchar(255) NOT NULL,
`alloted_hours` int(11) DEFAULT NULL,
`max_hours` int(11) DEFAULT NULL,
`practical_hours` int(11) DEFAULT NULL,
`theory_hours` int(11) DEFAULT NULL,
PRIMARY KEY (`faculty_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `faculty_alloted_hours`
--
LOCK TABLES `faculty_alloted_hours` WRITE;
/*!40000 ALTER TABLE `faculty_alloted_hours` DISABLE KEYS */;
INSERT INTO `faculty_alloted_hours` VALUES ('fac7',16,17,12,4),('fac24',17,17,10,7),('fac6',12,13,6,6),('fac25',16,17,12,4),('fac5',16,17,12,4),('fac22',16,17,10,6),('fac4',16,17,8,8),('fac23',16,17,10,6),('fac3',9,9,4,5),('fac28',17,17,14,3),('fac2',9,9,6,3),('fac29',16,17,12,4),('fac1',9,9,4,5),('fac26',16,17,8,8),('fac27',16,17,12,4),('fac20',16,17,10,6),('fac21',17,17,12,5),('fac9',15,17,12,3),('fac8',17,17,10,7),('fac13',17,17,14,3),('fac35',16,17,6,10),('fac14',16,17,8,8),('fac36',16,17,8,8),('fac11',16,17,12,4),('fac12',16,17,12,4),('fac34',8,9,2,6),('fac17',16,17,8,8),('fac18',17,17,14,3),('fac15',17,17,8,9),('fac16',16,17,10,6),('fac31',17,17,14,3),('fac10',15,17,12,3),('fac32',17,17,14,3),('fac30',16,17,10,6),('fac19',16,17,8,8);
/*!40000 ALTER TABLE `faculty_alloted_hours` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `faculty_course_history`
--
DROP TABLE IF EXISTS `faculty_course_history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `faculty_course_history` (
`id` int(11) NOT NULL,
`course_experience` int(11) DEFAULT NULL,
`course_taught` varchar(255) DEFAULT NULL,
`user_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKipqs7rh3e0x361k2my9hp1jf4` (`course_taught`),
KEY `FK61n0mbw2ra094w345mf5yhq3t` (`user_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `faculty_course_history`
--
LOCK TABLES `faculty_course_history` WRITE;
/*!40000 ALTER TABLE `faculty_course_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `faculty_course_history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `faculty_pref`
--
DROP TABLE IF EXISTS `faculty_pref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `faculty_pref` (
`id` int(11) NOT NULL,
`course_exp` int(11) DEFAULT NULL,
`course_id` varchar(255) DEFAULT NULL,
`elective_id` varchar(255) DEFAULT NULL,
`pref_no` int(11) DEFAULT NULL,
`prereq1_exp` int(11) DEFAULT NULL,
`prereq2_exp` int(11) DEFAULT NULL,
`user_name` varchar(255) DEFAULT NULL,
`year` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `faculty_pref`
--
LOCK TABLES `faculty_pref` WRITE;
/*!40000 ALTER TABLE `faculty_pref` DISABLE KEYS */;
INSERT INTO `faculty_pref` VALUES (1,4,NULL,'510105B',1,-1,-1,'fac1','ME1'),(2,2,'510101',NULL,2,-1,-1,'fac1','ME1'),(3,2,'210245',NULL,3,-1,-1,'fac1','SE'),(4,2,'210243',NULL,4,-1,-1,'fac1','SE'),(5,1,'410243',NULL,1,6,-1,'fac2','BE'),(6,6,'310242',NULL,2,0,0,'fac2','TE'),(7,4,NULL,'410244D',3,6,0,'fac2','BE'),(8,1,'310243',NULL,4,-1,-1,'fac2','TE'),(9,1,NULL,'410244D',1,0,0,'fac3','BE'),(10,0,'310242',NULL,2,3,4,'fac3','TE'),(11,0,'410243',NULL,3,0,-1,'fac3','BE'),(12,4,'510101',NULL,4,-1,-1,'fac3','ME1'),(13,2,'510102',NULL,5,-1,-1,'fac3','ME1'),(14,3,'510103',NULL,1,-1,-1,'fac4','ME1'),(15,0,'510101',NULL,2,-1,-1,'fac4','ME1'),(16,4,NULL,'410245A',3,2,0,'fac4','BE'),(17,2,NULL,'410245C',4,3,1,'fac4','BE'),(18,4,'210244',NULL,5,-1,-1,'fac4','SE'),(19,5,'310242',NULL,6,1,0,'fac4','TE'),(27,0,'310242',NULL,4,2,2,'fac7','TE'),(26,0,'310241',NULL,3,3,2,'fac7','TE'),(25,2,'210243',NULL,2,-1,-1,'fac7','SE'),(24,2,'210245',NULL,1,-1,-1,'fac7','SE'),(28,4,'310243',NULL,1,-1,-1,'fac6','TE'),(29,4,'310245',NULL,2,2,-1,'fac6','TE'),(30,2,'210244',NULL,3,-1,-1,'fac6','SE'),(31,2,NULL,'410244B',4,4,-1,'fac6','BE'),(32,2,NULL,'410245D',5,4,-1,'fac6','BE'),(33,2,'310241',NULL,1,1,1,'fac8','TE'),(34,1,NULL,'Tut',2,-1,-1,'fac8','TE'),(35,0,'210245',NULL,3,-1,-1,'fac8','SE'),(36,2,'210243',NULL,4,-1,-1,'fac8','SE'),(37,1,'410243',NULL,1,0,-1,'fac9','BE'),(38,1,'210243',NULL,2,-1,-1,'fac9','SE'),(39,0,'310241',NULL,3,0,3,'fac9','TE'),(40,0,'610102',NULL,4,-1,-1,'fac9','ME2'),(41,3,'310242',NULL,1,0,0,'fac10','TE'),(42,2,NULL,'410244D',2,3,0,'fac10','BE'),(43,3,'410243',NULL,3,3,-1,'fac10','BE'),(44,4,'210242',NULL,4,-1,-1,'fac10','SE'),(45,5,'210243',NULL,1,-1,-1,'fac11','SE'),(46,3,'310241',NULL,2,1,0,'fac11','TE'),(47,0,'310242',NULL,3,4,1,'fac11','TE'),(48,0,'410242',NULL,4,0,-1,'fac11','BE'),(49,3,'210245',NULL,1,-1,-1,'fac12','SE'),(50,2,'210243',NULL,2,-1,-1,'fac12','SE'),(51,1,NULL,'410245B',3,1,1,'fac12','BE'),(52,0,'410242',NULL,4,0,-1,'fac12','BE'),(53,5,'310242',NULL,1,0,0,'fac13','TE'),(54,2,'210244',NULL,2,-1,-1,'fac13','SE'),(55,0,NULL,'410245B',3,0,0,'fac13','BE'),(56,0,'410243',NULL,4,5,-1,'fac13','BE'),(57,5,'210244',NULL,1,-1,-1,'fac14','SE'),(58,0,NULL,'410244D',2,2,1,'fac14','BE'),(59,3,'410241',NULL,3,5,5,'fac14','BE'),(60,1,'310243',NULL,4,-1,-1,'fac14','TE'),(61,15,'210244',NULL,1,-1,-1,'fac15','SE'),(62,3,'510104',NULL,2,-1,-1,'fac15','ME1'),(63,1,'210245',NULL,3,-1,-1,'fac15','SE'),(64,0,'410243',NULL,4,2,-1,'fac15','BE'),(65,3,'210241',NULL,1,-1,-1,'fac16','SE'),(66,1,'310244',NULL,2,-1,-1,'fac16','TE'),(67,0,'310243',NULL,3,-1,-1,'fac16','TE'),(68,0,NULL,'510105D',4,-1,-1,'fac16','ME2'),(69,7,'310245',NULL,1,0,-1,'fac17','TE'),(70,2,NULL,'410244C',2,7,-1,'fac17','BE'),(71,0,'310243',NULL,3,-1,-1,'fac17','TE'),(72,0,'210243',NULL,4,-1,-1,'fac17','SE'),(73,3,'310242',NULL,1,1,1,'fac18','TE'),(74,1,'210245',NULL,2,-1,-1,'fac18','SE'),(75,2,'310243',NULL,3,-1,-1,'fac18','TE'),(76,3,NULL,'410245B',4,2,2,'fac18','BE'),(77,3,'410241',NULL,1,0,0,'fac19','BE'),(78,1,NULL,'Tut',2,-1,-1,'fac19','TE'),(79,0,'210245',NULL,3,-1,-1,'fac19','SE'),(80,2,'210243',NULL,4,-1,-1,'fac19','SE'),(81,2,'410242',NULL,1,0,-1,'fac20','BE'),(82,4,'310242',NULL,2,1,0,'fac20','TE'),(83,0,'410243',NULL,3,4,-1,'fac20','BE'),(84,0,'210243',NULL,4,-1,-1,'fac20','SE'),(85,3,NULL,'410244C',1,2,-1,'fac21','BE'),(86,2,'310242',NULL,2,1,0,'fac21','TE'),(87,2,'410242',NULL,3,1,-1,'fac21','BE'),(88,2,'210245',NULL,4,-1,-1,'fac21','SE'),(89,4,NULL,'Tut',1,-1,-1,'fac22','TE'),(90,2,'310242',NULL,2,0,0,'fac22','TE'),(91,2,'210243',NULL,3,-1,-1,'fac22','SE'),(92,0,'410243',NULL,4,0,-1,'fac22','BE'),(93,2,NULL,'410245B',1,0,0,'fac23','BE'),(94,3,'310242',NULL,2,0,0,'fac23','TE'),(95,0,NULL,'Tut',3,-1,-1,'fac23','TE'),(96,0,NULL,'410244D',4,3,0,'fac23','BE'),(97,2,'410241',NULL,1,2,1,'fac24','BE'),(98,2,'310242',NULL,2,0,0,'fac24','TE'),(99,2,NULL,'Tut',3,-1,-1,'fac24','TE'),(100,0,NULL,'410245B',4,0,0,'fac24','BE'),(101,4,'210243',NULL,1,-1,-1,'fac25','SE'),(102,2,'210242',NULL,2,-1,-1,'fac25','SE'),(103,2,'310242',NULL,3,4,1,'fac25','TE'),(104,0,NULL,'410245B',4,0,0,'fac25','BE'),(105,5,'210242',NULL,1,-1,-1,'fac26','SE'),(106,3,'210245',NULL,2,-1,-1,'fac26','SE'),(107,0,NULL,'Tut',3,-1,-1,'fac26','TE'),(108,0,NULL,'410244A',4,0,-1,'fac26','BE'),(109,2,'310245',NULL,1,1,-1,'fac27','TE'),(110,2,'210245',NULL,2,-1,-1,'fac27','SE'),(111,0,NULL,'410245D',3,2,-1,'fac27','BE'),(112,0,'410242',NULL,4,0,-1,'fac27','BE'),(113,1,'410243',NULL,1,1,-1,'fac28','BE'),(114,3,'210245',NULL,2,-1,-1,'fac28','SE'),(115,4,'310241',NULL,3,0,4,'fac28','TE'),(116,1,'310242',NULL,4,0,2,'fac28','TE'),(117,3,'210242',NULL,1,-1,-1,'fac29','SE'),(118,1,'210245',NULL,2,-1,-1,'fac29','SE'),(119,0,'310242',NULL,3,2,3,'fac29','TE'),(120,0,'410242',NULL,4,1,-1,'fac29','BE'),(121,5,'310241',NULL,1,1,0,'fac30','TE'),(122,1,'210242',NULL,2,-1,-1,'fac30','SE'),(123,3,'310245',NULL,3,0,-1,'fac30','TE'),(124,2,NULL,'410244D',4,0,0,'fac30','BE'),(125,2,'310242',NULL,1,1,0,'fac31','TE'),(126,2,'310244',NULL,2,-1,-1,'fac31','TE'),(127,1,'210244',NULL,3,-1,-1,'fac31','SE'),(128,1,NULL,'410245D',4,0,-1,'fac31','BE'),(129,8,'210245',NULL,1,-1,-1,'fac32','SE'),(130,4,'410242',NULL,2,2,-1,'fac32','BE'),(131,1,NULL,'410245B',3,0,0,'fac32','BE'),(132,2,'310241',NULL,4,0,2,'fac32','TE'),(133,6,'310243',NULL,1,-1,-1,'fac34','TE'),(134,4,NULL,'610103D',2,-1,-1,'fac34','ME2'),(135,2,'410242',NULL,3,0,-1,'fac34','BE'),(136,4,'210243',NULL,4,-1,-1,'fac34','SE'),(137,4,NULL,'510105B',1,-1,-1,'fac35','ME1'),(138,3,'610102',NULL,2,-1,-1,'fac35','ME2'),(139,4,NULL,'410244D',3,0,0,'fac35','BE'),(140,0,'310244',NULL,4,-1,-1,'fac35','TE'),(141,6,'210241',NULL,1,-1,-1,'fac36','SE'),(142,2,NULL,'Tut',2,-1,-1,'fac36','TE'),(143,4,'310245',NULL,3,0,-1,'fac36','TE'),(144,0,NULL,'410244D',4,0,0,'fac36','BE'),(785,0,'210245',NULL,1,-1,-1,'fac5','SE'),(786,0,'210243',NULL,2,-1,-1,'fac5','SE'),(787,0,'310242',NULL,3,0,0,'fac5','TE'),(788,0,'310244',NULL,4,-1,-1,'fac5','TE');
/*!40000 ALTER TABLE `faculty_pref` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `hibernate_sequence`
--
DROP TABLE IF EXISTS `hibernate_sequence`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hibernate_sequence` (
`next_val` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `hibernate_sequence`
--
LOCK TABLES `hibernate_sequence` WRITE;
/*!40000 ALTER TABLE `hibernate_sequence` DISABLE KEYS */;
INSERT INTO `hibernate_sequence` VALUES (2691),(2691),(2691),(2691),(2691),(2691),(2691),(2691),(2691),(2691),(2691),(2691),(2691);
/*!40000 ALTER TABLE `hibernate_sequence` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `old_time_slots`
--
DROP TABLE IF EXISTS `old_time_slots`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `old_time_slots` (
`id` int(11) NOT NULL,
`activity` varchar(255) DEFAULT NULL,
`date` date DEFAULT NULL,
`day` varchar(255) DEFAULT NULL,
`end_time` time DEFAULT NULL,
`start_time` time DEFAULT NULL,
`activity_incharge` varchar(255) DEFAULT NULL,
`resource_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKaonoahix0hsuhh84ueix2xbnv` (`activity_incharge`),
KEY `FK8vhg7f14rcfm2xxxliy1wsjar` (`resource_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `old_time_slots`
--
LOCK TABLES `old_time_slots` WRITE;
/*!40000 ALTER TABLE `old_time_slots` DISABLE KEYS */;
/*!40000 ALTER TABLE `old_time_slots` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `open_faculty_prefs`
--
DROP TABLE IF EXISTS `open_faculty_prefs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `open_faculty_prefs` (
`dept_id` varchar(255) NOT NULL,
`sem_type` int(11) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
PRIMARY KEY (`dept_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `open_faculty_prefs`
--
LOCK TABLES `open_faculty_prefs` WRITE;
/*!40000 ALTER TABLE `open_faculty_prefs` DISABLE KEYS */;
INSERT INTO `open_faculty_prefs` VALUES ('CO',1,0);
/*!40000 ALTER TABLE `open_faculty_prefs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `password_reset_token`
--
DROP TABLE IF EXISTS `password_reset_token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_reset_token` (
`id` bigint(20) NOT NULL,
`expiry_date` datetime DEFAULT NULL,
`token` varchar(255) DEFAULT NULL,
`user_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK5lwtbncug84d4ero33v3cfxvl` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `password_reset_token`
--
LOCK TABLES `password_reset_token` WRITE;
/*!40000 ALTER TABLE `password_reset_token` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_token` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `practical_list_faculty`
--
DROP TABLE IF EXISTS `practical_list_faculty`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `practical_list_faculty` (
`b_id` int(11) NOT NULL,
`div_id` varchar(255) DEFAULT NULL,
`faculty_id` varchar(255) DEFAULT NULL,
`lab_id` varchar(255) DEFAULT NULL,
`no_of_hours` int(11) DEFAULT NULL,
`practical_course_id` varchar(255) DEFAULT NULL,
`theory_course_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`b_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `practical_list_faculty`
--
LOCK TABLES `practical_list_faculty` WRITE;
/*!40000 ALTER TABLE `practical_list_faculty` DISABLE KEYS */;
INSERT INTO `practical_list_faculty` VALUES (2690,'BECOC','fac31','BECOC4',2,'410247B','410245C'),(2689,'BECOC','fac15','BECOC3',2,'410247B','410245C'),(2688,'BECOC','fac13','BECOC2',2,'410247B','410245C'),(2687,'BECOC','fac21','BECOC1',2,'410247B','410245C'),(2686,'BECOB','fac3','BECOB4',2,'410247B','410245C'),(2685,'BECOB','fac24','BECOB3',2,'410247B','410245C'),(2684,'BECOB','fac19','BECOB2',2,'410247B','410245C'),(2683,'BECOB','fac30','BECOB1',2,'410247B','410245C'),(2682,'BECOA','fac16','BECOA4',2,'410247B','410245C'),(2681,'BECOA','fac34','BECOA3',2,'410247B','410245C'),(2680,'BECOA','fac36','BECOA2',2,'410247B','410245C'),(2679,'BECOA','fac14','BECOA1',2,'410247B','410245C'),(2678,'BECOC','fac35','BECOC4',2,'410247B','410245B'),(2677,'BECOC','fac9','BECOC3',2,'410247B','410245B'),(2676,'BECOC','fac23','BECOC2',2,'410247B','410245B'),(2675,'BECOC','fac4','BECOC1',2,'410247B','410245B'),(2674,'BECOB','fac22','BECOB4',2,'410247B','410245B'),(2673,'BECOB','fac6','BECOB3',2,'410247B','410245B'),(2672,'BECOB','fac15','BECOB2',2,'410247B','410245B'),(2671,'BECOB','fac21','BECOB1',2,'410247B','410245B'),(2670,'BECOA','fac24','BECOA4',2,'410247B','410245B'),(2669,'BECOA','fac19','BECOA3',2,'410247B','410245B'),(2668,'BECOA','fac30','BECOA2',2,'410247B','410245B'),(2667,'BECOA','fac16','BECOA1',2,'410247B','410245B'),(2666,'BECOC','fac36','BECOC4',2,'410247A','410244D'),(2665,'BECOC','fac14','BECOC3',2,'410247A','410244D'),(2664,'BECOC','fac35','BECOC2',2,'410247A','410244D'),(2663,'BECOC','fac9','BECOC1',2,'410247A','410244D'),(2662,'BECOB','fac23','BECOB4',2,'410247A','410244D'),(2661,'BECOB','fac4','BECOB3',2,'410247A','410244D'),(2660,'BECOB','fac22','BECOB2',2,'410247A','410244D'),(2659,'BECOB','fac15','BECOB1',2,'410247A','410244D'),(2658,'BECOA','fac21','BECOA4',2,'410247A','410244D'),(2657,'BECOA','fac24','BECOA3',2,'410247A','410244D'),(2656,'BECOA','fac19','BECOA2',2,'410247A','410244D'),(2655,'BECOA','fac30','BECOA1',2,'410247A','410244D'),(2654,'BECOC','fac16','BECOC4',2,'410247A','410244C'),(2653,'BECOC','fac36','BECOC3',2,'410247A','410244C'),(2652,'BECOC','fac14','BECOC2',2,'410247A','410244C'),(2651,'BECOC','fac35','BECOC1',2,'410247A','410244C'),(2650,'BECOB','fac9','BECOB4',2,'410247A','410244C'),(2649,'BECOB','fac23','BECOB3',2,'410247A','410244C'),(2648,'BECOB','fac4','BECOB2',2,'410247A','410244C'),(2647,'BECOB','fac22','BECOB1',2,'410247A','410244C'),(2646,'BECOA','fac21','BECOA4',2,'410247A','410244C'),(2645,'BECOA','fac24','BECOA3',2,'410247A','410244C'),(2644,'BECOA','fac19','BECOA2',2,'410247A','410244C'),(2643,'BECOA','fac30','BECOA1',2,'410247A','410244C'),(2642,'BECOC','fac16','BECOC4',2,'410247A','410244B'),(2641,'BECOC','fac36','BECOC3',2,'410247A','410244B'),(2640,'BECOC','fac14','BECOC2',2,'410247A','410244B'),(2639,'BECOC','fac9','BECOC1',2,'410247A','410244B'),(2638,'BECOB','fac23','BECOB4',2,'410247A','410244B'),(2637,'BECOB','fac22','BECOB3',2,'410247A','410244B'),(2636,'BECOB','fac21','BECOB2',2,'410247A','410244B'),(2635,'BECOB','fac24','BECOB1',2,'410247A','410244B'),(2634,'BECOA','fac30','BECOA4',2,'410247A','410244B'),(2633,'BECOA','fac16','BECOA3',2,'410247A','410244B'),(2632,'BECOA','fac23','BECOA2',2,'410247A','410244B'),(2631,'BECOA','fac22','BECOA1',2,'410247A','410244B'),(2630,'SECOC','fac21','SECOC4',2,'210248','210245'),(2629,'SECOC','fac8','SECOC3',2,'210248','210245'),(2628,'SECOC','fac8','SECOC2',2,'210248','210245'),(2627,'SECOC','fac8','SECOC1',2,'210248','210245'),(2626,'SECOB','fac8','SECOB4',2,'210248','210245'),(2625,'SECOB','fac8','SECOB3',2,'210248','210245'),(2624,'SECOB','fac1','SECOB2',2,'210248','210245'),(2623,'SECOB','fac18','SECOB1',2,'210248','210245'),(2622,'SECOA','fac5','SECOA4',2,'210248','210245'),(2621,'SECOA','fac5','SECOA3',2,'210248','210245'),(2620,'SECOA','fac5','SECOA2',2,'210248','210245'),(2619,'SECOA','fac5','SECOA1',2,'210248','210245'),(2618,'SECOC','fac12','SECOC4',4,'210247','210243'),(2617,'SECOC','fac12','SECOC3',4,'210247','210243'),(2616,'SECOC','fac12','SECOC2',4,'210247','210243'),(2615,'SECOC','fac5','SECOC1',4,'210247','210243'),(2614,'SECOB','fac7','SECOB4',4,'210247','210243'),(2613,'SECOB','fac7','SECOB3',4,'210247','210243'),(2612,'SECOB','fac7','SECOB2',4,'210247','210243'),(2611,'SECOB','fac25','SECOB1',4,'210247','210243'),(2610,'SECOA','fac25','SECOA4',4,'210247','210243'),(2609,'SECOA','fac11','SECOA3',4,'210247','210243'),(2608,'SECOA','fac11','SECOA2',4,'210247','210243'),(2607,'SECOA','fac11','SECOA1',4,'210247','210243'),(2606,'SECOC','fac25','SECOC4',2,'210246','210242'),(2605,'SECOC','fac25','SECOC3',2,'210246','210242'),(2604,'SECOC','fac29','SECOC2',2,'210246','210242'),(2603,'SECOC','fac29','SECOC1',2,'210246','210242'),(2602,'SECOB','fac29','SECOB4',2,'210246','210242'),(2601,'SECOB','fac29','SECOB3',2,'210246','210242'),(2600,'SECOB','fac29','SECOB2',2,'210246','210242'),(2599,'SECOB','fac29','SECOB1',2,'210246','210242'),(2598,'SECOA','fac26','SECOA4',2,'210246','210242'),(2597,'SECOA','fac26','SECOA3',2,'210246','210242'),(2596,'SECOA','fac26','SECOA2',2,'210246','210242'),(2595,'SECOA','fac26','SECOA1',2,'210246','210242'),(2594,'TECOC','fac6','TECOC4',2,'310248','310245'),(2593,'TECOC','fac6','TECOC3',2,'310248','310245'),(2592,'TECOC','fac27','TECOC2',2,'310248','310245'),(2591,'TECOC','fac27','TECOC1',2,'310248','310245'),(2590,'TECOB','fac27','TECOB4',2,'310248','310245'),(2589,'TECOB','fac27','TECOB3',2,'310248','310245'),(2588,'TECOB','fac27','TECOB2',2,'310248','310245'),(2587,'TECOB','fac27','TECOB1',2,'310248','310245'),(2586,'TECOA','fac17','TECOA4',2,'310248','310245'),(2585,'TECOA','fac17','TECOA3',2,'310248','310245'),(2584,'TECOA','fac17','TECOA2',2,'310248','310245'),(2583,'TECOA','fac17','TECOA1',2,'310248','310245'),(2582,'TECOC','fac31','TECOC4',4,'310247','310242'),(2581,'TECOC','fac31','TECOC3',4,'310247','310242'),(2580,'TECOC','fac31','TECOC2',4,'310247','310242'),(2579,'TECOC','fac10','TECOC1',4,'310247','310242'),(2578,'TECOB','fac10','TECOB4',4,'310247','310242'),(2577,'TECOB','fac10','TECOB3',4,'310247','310242'),(2576,'TECOB','fac18','TECOB2',4,'310247','310242'),(2575,'TECOB','fac18','TECOB1',4,'310247','310242'),(2574,'TECOA','fac18','TECOA4',4,'310247','310242'),(2573,'TECOA','fac13','TECOA3',4,'310247','310242'),(2572,'TECOA','fac13','TECOA2',4,'310247','310242'),(2571,'TECOA','fac13','TECOA1',4,'310247','310242'),(2570,'BECOC','fac9','BECOC4',2,'410246B','410243'),(2569,'BECOC','fac9','BECOC3',2,'410246B','410243'),(2568,'BECOC','fac28','BECOC2',2,'410246B','410243'),(2567,'BECOC','fac28','BECOC1',2,'410246B','410243'),(2566,'BECOB','fac28','BECOB4',2,'410246B','410243'),(2565,'BECOB','fac28','BECOB3',2,'410246B','410243'),(2564,'BECOB','fac28','BECOB2',2,'410246B','410243'),(2563,'BECOB','fac28','BECOB1',2,'410246B','410243'),(2562,'BECOA','fac28','BECOA4',2,'410246B','410243'),(2561,'BECOA','fac2','BECOA3',2,'410246B','410243'),(2560,'BECOA','fac2','BECOA2',2,'410246B','410243'),(2559,'BECOA','fac2','BECOA1',2,'410246B','410243'),(2558,'BECOC','fac32','BECOC4',2,'410246A','410242'),(2557,'BECOC','fac32','BECOC3',2,'410246A','410242'),(2556,'BECOC','fac32','BECOC2',2,'410246A','410242'),(2555,'BECOC','fac32','BECOC1',2,'410246A','410242'),(2554,'BECOB','fac32','BECOB4',2,'410246A','410242'),(2553,'BECOB','fac32','BECOB3',2,'410246A','410242'),(2552,'BECOB','fac32','BECOB2',2,'410246A','410242'),(2551,'BECOB','fac20','BECOB1',2,'410246A','410242'),(2550,'BECOA','fac20','BECOA4',2,'410246A','410242'),(2549,'BECOA','fac20','BECOA3',2,'410246A','410242'),(2548,'BECOA','fac20','BECOA2',2,'410246A','410242'),(2547,'BECOA','fac20','BECOA1',2,'410246A','410242'),(2546,'ME1COA','fac15','ME1COA1',2,'510106D','510104'),(2545,'ME1COA','fac4','ME1COA1',2,'510106C','510103'),(2544,'ME1COA','fac3','ME1COA1',2,'510106B','510102'),(2543,'ME1COA','fac1','ME1COA1',2,'510106A','510101');
/*!40000 ALTER TABLE `practical_list_faculty` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `resource`
--
DROP TABLE IF EXISTS `resource`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `resource` (
`resource_id` varchar(255) NOT NULL,
`resource_capacity` int(11) DEFAULT NULL,
`resource_info` varchar(255) DEFAULT NULL,
`resource_name` varchar(255) DEFAULT NULL,
`resource_type` varchar(255) DEFAULT NULL,
`dept` varchar(255) DEFAULT NULL,
`resource_incharge` varchar(255) DEFAULT NULL,
PRIMARY KEY (`resource_id`),
KEY `FKg1masos27n6717qmp0dc9363l` (`dept`),
KEY `FKcsyf2v53qba39njcy5i53w3n4` (`resource_incharge`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `resource`
--
LOCK TABLES `resource` WRITE;
/*!40000 ALTER TABLE `resource` DISABLE KEYS */;
INSERT INTO `resource` VALUES ('CO101',80,'','101','Classroom','CO','fac1'),('CO111',80,'','111','Classroom','CO','fac1'),('CO201',80,'','201','Classroom','CO','fac1'),('CO202',80,'','202','Classroom','CO','fac1'),('CO202A',80,'','202A','Classroom','CO','fac1'),('CO203',80,'','203','Classroom','CO','fac1'),('CO204',80,'','204','Classroom','CO','fac1'),('CO205A',25,'','205A','Lab','CO','fac2'),('CO205B',25,'','205B','Lab','CO','fac3'),('CO205C',25,'','205C','Lab','CO','fac4'),('CO206',25,'','206','Lab','CO','fac5'),('CO207',25,'','207','Lab','CO','fac6'),('CO210',25,'','210','Lab','CO','fac7'),('CO212A',25,'','212A','Lab','CO','fac8'),('CO212B',25,'','212B','Lab','CO','fac9'),('CO212C',25,'','212C','Lab','CO','fac10'),('CO112A',25,'','112A','Lab','CO','fac11'),('CO112B',25,'','112B','Lab','CO','fac12'),('CO112C',25,'','112C','Lab','CO','fac13'),('CO007',25,'','007','Lab','CO','fac14');
/*!40000 ALTER TABLE `resource` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `resource_requests`
--
DROP TABLE IF EXISTS `resource_requests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `resource_requests` (
`request_id` int(11) NOT NULL,
`request_time` time DEFAULT NULL,
`request_date` date DEFAULT NULL,
`slot_activity_name` varchar(255) DEFAULT NULL,
`slot_date` date DEFAULT NULL,
`slot_day` varchar(255) DEFAULT NULL,
`slot_end_time` time DEFAULT NULL,
`slot_start_time` time DEFAULT NULL,
`request_by` varchar(255) DEFAULT NULL,
`resource_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`request_id`),
KEY `FK9jhrl2bjo9lyvqlm8hmxvcfwv` (`request_by`),
KEY `FKqmjlihidt6qajf1avb2gicxbv` (`resource_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `resource_requests`
--
LOCK TABLES `resource_requests` WRITE;
/*!40000 ALTER TABLE `resource_requests` DISABLE KEYS */;
/*!40000 ALTER TABLE `resource_requests` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role`
--
DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role` (
`role_id` int(11) NOT NULL,
`role` varchar(255) DEFAULT NULL,
PRIMARY KEY (`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role`
--
LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
INSERT INTO `role` VALUES (1,'ADMIN'),(2,'FACULTY'),(3,'STUDENT');
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `student_acad`
--
DROP TABLE IF EXISTS `student_acad`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `student_acad` (
`user_name` varchar(255) NOT NULL,
`agg_marks` float DEFAULT NULL,
`rollno` varchar(255) DEFAULT NULL,
`semester` int(11) DEFAULT NULL,
`shift` int(11) DEFAULT NULL,
`year` varchar(255) DEFAULT NULL,
`dept_id` varchar(255) DEFAULT NULL,
`div_id` varchar(255) DEFAULT NULL,
`user_dets` varchar(255) DEFAULT NULL,
PRIMARY KEY (`user_name`),
KEY `FKp7oxob7rewbaaw92t3ih00r7y` (`dept_id`),
KEY `FK51p5ybg00omk44ige080vr3uq` (`div_id`),
KEY `FKnr7x99gx1f0naigcx44ppi121` (`user_dets`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `student_acad`
--
LOCK TABLES `student_acad` WRITE;
/*!40000 ALTER TABLE `student_acad` DISABLE KEYS */;
INSERT INTO `student_acad` VALUES ('stud801',82.08,'ME2COA101',3,1,'ME2','CO','ME2COA','stud801'),('stud802',88.16,'ME2COA102',3,1,'ME2','CO','ME2COA','stud802'),('stud803',83.02,'ME2COA103',3,1,'ME2','CO','ME2COA','stud803'),('stud804',85.19,'ME2COA104',3,1,'ME2','CO','ME2COA','stud804'),('stud805',51.12,'ME2COA105',3,1,'ME2','CO','ME2COA','stud805'),('stud806',65.21,'ME2COA106',3,1,'ME2','CO','ME2COA','stud806'),('stud807',86.43,'ME2COA107',3,1,'ME2','CO','ME2COA','stud807'),('stud808',62.36,'ME2COA108',3,1,'ME2','CO','ME2COA','stud808'),('stud809',73.94,'ME2COA109',3,1,'ME2','CO','ME2COA','stud809'),('stud810',81.66,'ME2COA110',3,1,'ME2','CO','ME2COA','stud810'),('stud811',63.04,'ME2COA111',3,1,'ME2','CO','ME2COA','stud811'),('stud812',53.18,'ME2COA112',3,1,'ME2','CO','ME2COA','stud812'),('stud813',89.86,'ME2COA113',3,1,'ME2','CO','ME2COA','stud813'),('stud814',51.25,'ME2COA114',3,1,'ME2','CO','ME2COA','stud814'),('stud815',87.74,'ME2COA115',3,1,'ME2','CO','ME2COA','stud815'),('stud816',75.26,'ME2COA116',3,1,'ME2','CO','ME2COA','stud816'),('stud817',62.12,'ME2COA117',3,1,'ME2','CO','ME2COA','stud817'),('stud818',92.14,'ME2COA118',3,1,'ME2','CO','ME2COA','stud818'),('stud819',91.86,'ME2COA119',3,1,'ME2','CO','ME2COA','stud819'),('stud820',74.58,'ME2COA120',3,1,'ME2','CO','ME2COA','stud820'),('stud821',88.48,'ME2COA121',3,1,'ME2','CO','ME2COA','stud821'),('stud822',92.53,'ME2COA122',3,1,'ME2','CO','ME2COA','stud822'),('stud823',87.74,'ME2COA123',3,1,'ME2','CO','ME2COA','stud823'),('stud824',96.08,'ME2COA124',3,1,'ME2','CO','ME2COA','stud824'),('stud825',75.23,'ME2COA125',3,1,'ME2','CO','ME2COA','stud825'),('stud826',83.53,'ME2COA126',3,1,'ME2','CO','ME2COA','stud826'),('stud827',72.98,'ME2COA127',3,1,'ME2','CO','ME2COA','stud827'),('stud828',96.26,'ME2COA128',3,1,'ME2','CO','ME2COA','stud828'),('stud829',87.02,'ME2COA129',3,1,'ME2','CO','ME2COA','stud829'),('stud830',50.69,'ME2COA130',3,1,'ME2','CO','ME2COA','stud830'),('stud831',97.57,'ME2COA131',3,1,'ME2','CO','ME2COA','stud831'),('stud832',99.62,'ME2COA132',3,1,'ME2','CO','ME2COA','stud832'),('stud833',96.09,'ME2COA133',3,1,'ME2','CO','ME2COA','stud833'),('stud834',78.84,'ME2COA134',3,1,'ME2','CO','ME2COA','stud834'),('stud835',65.06,'ME2COA135',3,1,'ME2','CO','ME2COA','stud835'),('stud836',66.35,'ME2COA136',3,1,'ME2','CO','ME2COA','stud836'),('stud837',72.82,'ME2COA137',3,1,'ME2','CO','ME2COA','stud837'),('stud838',79.48,'ME2COA138',3,1,'ME2','CO','ME2COA','stud838'),('stud839',67.12,'ME2COA139',3,1,'ME2','CO','ME2COA','stud839'),('stud840',89.29,'ME2COA140',3,1,'ME2','CO','ME2COA','stud840'),('stud841',53.83,'ME2COA141',3,1,'ME2','CO','ME2COA','stud841'),('stud842',61.17,'ME2COA142',3,1,'ME2','CO','ME2COA','stud842'),('stud843',78.33,'ME2COA143',3,1,'ME2','CO','ME2COA','stud843'),('stud844',99.36,'ME2COA144',3,1,'ME2','CO','ME2COA','stud844'),('stud845',91.45,'ME2COA145',3,1,'ME2','CO','ME2COA','stud845'),('stud846',63.99,'ME2COA146',3,1,'ME2','CO','ME2COA','stud846'),('stud847',58.57,'ME2COA147',3,1,'ME2','CO','ME2COA','stud847'),('stud848',73.9,'ME2COA148',3,1,'ME2','CO','ME2COA','stud848'),('stud849',89.68,'ME2COA149',3,1,'ME2','CO','ME2COA','stud849'),('stud850',72.05,'ME2COA150',3,1,'ME2','CO','ME2COA','stud850'),('stud851',81.9,'ME2COA151',3,1,'ME2','CO','ME2COA','stud851'),('stud852',89.31,'ME2COA152',3,1,'ME2','CO','ME2COA','stud852'),('stud853',84.32,'ME2COA153',3,1,'ME2','CO','ME2COA','stud853'),('stud854',95.93,'ME2COA154',3,1,'ME2','CO','ME2COA','stud854'),('stud855',50.76,'ME2COA155',3,1,'ME2','CO','ME2COA','stud855'),('stud856',68.66,'ME2COA156',3,1,'ME2','CO','ME2COA','stud856'),('stud857',85.6,'ME2COA157',3,1,'ME2','CO','ME2COA','stud857'),('stud858',55.09,'ME2COA158',3,1,'ME2','CO','ME2COA','stud858'),('stud859',53.08,'ME2COA159',3,1,'ME2','CO','ME2COA','stud859'),('stud860',76.39,'ME2COA160',3,1,'ME2','CO','ME2COA','stud860'),('stud861',92.31,'ME2COA161',3,1,'ME2','CO','ME2COA','stud861'),('stud862',72.97,'ME2COA162',3,1,'ME2','CO','ME2COA','stud862'),('stud863',74.96,'ME2COA163',3,1,'ME2','CO','ME2COA','stud863'),('stud864',88.94,'ME2COA164',3,1,'ME2','CO','ME2COA','stud864'),('stud865',58.56,'ME2COA165',3,1,'ME2','CO','ME2COA','stud865'),('stud866',92.49,'ME2COA166',3,1,'ME2','CO','ME2COA','stud866'),('stud867',51.67,'ME2COA167',3,1,'ME2','CO','ME2COA','stud867'),('stud868',78.59,'ME2COA168',3,1,'ME2','CO','ME2COA','stud868'),('stud869',58.53,'ME2COA169',3,1,'ME2','CO','ME2COA','stud869'),('stud870',72.82,'ME2COA170',3,1,'ME2','CO','ME2COA','stud870'),('stud871',55.9,'ME2COA171',3,1,'ME2','CO','ME2COA','stud871'),('stud872',90.84,'ME2COA172',3,1,'ME2','CO','ME2COA','stud872'),('stud873',55.99,'ME2COA173',3,1,'ME2','CO','ME2COA','stud873'),('stud874',66.02,'ME2COA174',3,1,'ME2','CO','ME2COA','stud874'),('stud875',60.9,'ME2COA175',3,1,'ME2','CO','ME2COA','stud875'),('stud876',60.77,'ME2COA176',3,1,'ME2','CO','ME2COA','stud876'),('stud877',80.03,'ME2COA177',3,1,'ME2','CO','ME2COA','stud877'),('stud878',64.22,'ME2COA178',3,1,'ME2','CO','ME2COA','stud878'),('stud879',50.69,'ME2COA179',3,1,'ME2','CO','ME2COA','stud879'),('stud880',82.11,'ME2COA180',3,1,'ME2','CO','ME2COA','stud880'),('stud721',52.21,'ME1COA101',1,1,'ME1','CO','ME1COA','stud721'),('stud722',71.85,'ME1COA102',1,1,'ME1','CO','ME1COA','stud722'),('stud723',58.16,'ME1COA103',1,1,'ME1','CO','ME1COA','stud723'),('stud724',56.04,'ME1COA104',1,1,'ME1','CO','ME1COA','stud724'),('stud725',74.5,'ME1COA105',1,1,'ME1','CO','ME1COA','stud725'),('stud726',75.04,'ME1COA106',1,1,'ME1','CO','ME1COA','stud726'),('stud727',87.58,'ME1COA107',1,1,'ME1','CO','ME1COA','stud727'),('stud728',53.73,'ME1COA108',1,1,'ME1','CO','ME1COA','stud728'),('stud729',55.46,'ME1COA109',1,1,'ME1','CO','ME1COA','stud729'),('stud730',69.29,'ME1COA110',1,1,'ME1','CO','ME1COA','stud730'),('stud731',77.56,'ME1COA111',1,1,'ME1','CO','ME1COA','stud731'),('stud732',82.87,'ME1COA112',1,1,'ME1','CO','ME1COA','stud732'),('stud733',92.65,'ME1COA113',1,1,'ME1','CO','ME1COA','stud733'),('stud734',60.94,'ME1COA114',1,1,'ME1','CO','ME1COA','stud734'),('stud735',76.25,'ME1COA115',1,1,'ME1','CO','ME1COA','stud735'),('stud736',97.35,'ME1COA116',1,1,'ME1','CO','ME1COA','stud736'),('stud737',94.38,'ME1COA117',1,1,'ME1','CO','ME1COA','stud737'),('stud738',91.85,'ME1COA118',1,1,'ME1','CO','ME1COA','stud738'),('stud739',57.96,'ME1COA119',1,1,'ME1','CO','ME1COA','stud739'),('stud740',67.52,'ME1COA120',1,1,'ME1','CO','ME1COA','stud740'),('stud741',95.42,'ME1COA121',1,1,'ME1','CO','ME1COA','stud741'),('stud742',98.18,'ME1COA122',1,1,'ME1','CO','ME1COA','stud742'),('stud743',60.04,'ME1COA123',1,1,'ME1','CO','ME1COA','stud743'),('stud744',95.01,'ME1COA124',1,1,'ME1','CO','ME1COA','stud744'),('stud745',78,'ME1COA125',1,1,'ME1','CO','ME1COA','stud745'),('stud746',51.83,'ME1COA126',1,1,'ME1','CO','ME1COA','stud746'),('stud747',92.75,'ME1COA127',1,1,'ME1','CO','ME1COA','stud747'),('stud748',55.88,'ME1COA128',1,1,'ME1','CO','ME1COA','stud748'),('stud749',88.04,'ME1COA129',1,1,'ME1','CO','ME1COA','stud749'),('stud750',51.79,'ME1COA130',1,1,'ME1','CO','ME1COA','stud750'),('stud751',72.68,'ME1COA131',1,1,'ME1','CO','ME1COA','stud751'),('stud752',52.53,'ME1COA132',1,1,'ME1','CO','ME1COA','stud752'),('stud753',62.64,'ME1COA133',1,1,'ME1','CO','ME1COA','stud753'),('stud754',98.72,'ME1COA134',1,1,'ME1','CO','ME1COA','stud754'),('stud755',83.5,'ME1COA135',1,1,'ME1','CO','ME1COA','stud755'),('stud756',74.18,'ME1COA136',1,1,'ME1','CO','ME1COA','stud756'),('stud757',53.34,'ME1COA137',1,1,'ME1','CO','ME1COA','stud757'),('stud758',67.42,'ME1COA138',1,1,'ME1','CO','ME1COA','stud758'),('stud759',54.84,'ME1COA139',1,1,'ME1','CO','ME1COA','stud759'),('stud760',78.23,'ME1COA140',1,1,'ME1','CO','ME1COA','stud760'),('stud761',96.87,'ME1COA141',1,1,'ME1','CO','ME1COA','stud761'),('stud762',75.65,'ME1COA142',1,1,'ME1','CO','ME1COA','stud762'),('stud763',98.59,'ME1COA143',1,1,'ME1','CO','ME1COA','stud763'),('stud764',71.58,'ME1COA144',1,1,'ME1','CO','ME1COA','stud764'),('stud765',51.05,'ME1COA145',1,1,'ME1','CO','ME1COA','stud765'),('stud766',76.37,'ME1COA146',1,1,'ME1','CO','ME1COA','stud766'),('stud767',78.13,'ME1COA147',1,1,'ME1','CO','ME1COA','stud767'),('stud768',65.52,'ME1COA148',1,1,'ME1','CO','ME1COA','stud768'),('stud769',70.1,'ME1COA149',1,1,'ME1','CO','ME1COA','stud769'),('stud770',81.09,'ME1COA150',1,1,'ME1','CO','ME1COA','stud770'),('stud771',89.53,'ME1COA151',1,1,'ME1','CO','ME1COA','stud771'),('stud772',70.3,'ME1COA152',1,1,'ME1','CO','ME1COA','stud772'),('stud773',86.76,'ME1COA153',1,1,'ME1','CO','ME1COA','stud773'),('stud774',72.93,'ME1COA154',1,1,'ME1','CO','ME1COA','stud774'),('stud775',91.95,'ME1COA155',1,1,'ME1','CO','ME1COA','stud775'),('stud776',56.96,'ME1COA156',1,1,'ME1','CO','ME1COA','stud776'),('stud777',94.71,'ME1COA157',1,1,'ME1','CO','ME1COA','stud777'),('stud778',81.7,'ME1COA158',1,1,'ME1','CO','ME1COA','stud778'),('stud779',98.41,'ME1COA159',1,1,'ME1','CO','ME1COA','stud779'),('stud780',67.81,'ME1COA160',1,1,'ME1','CO','ME1COA','stud780'),('stud781',96.92,'ME1COA161',1,1,'ME1','CO','ME1COA','stud781'),('stud782',67.79,'ME1COA162',1,1,'ME1','CO','ME1COA','stud782'),('stud783',92.61,'ME1COA163',1,1,'ME1','CO','ME1COA','stud783'),('stud784',66.48,'ME1COA164',1,1,'ME1','CO','ME1COA','stud784'),('stud785',57.48,'ME1COA165',1,1,'ME1','CO','ME1COA','stud785'),('stud786',82.05,'ME1COA166',1,1,'ME1','CO','ME1COA','stud786'),('stud787',90.34,'ME1COA167',1,1,'ME1','CO','ME1COA','stud787'),('stud788',53.05,'ME1COA168',1,1,'ME1','CO','ME1COA','stud788'),('stud789',51.95,'ME1COA169',1,1,'ME1','CO','ME1COA','stud789'),('stud790',57.24,'ME1COA170',1,1,'ME1','CO','ME1COA','stud790'),('stud791',84.23,'ME1COA171',1,1,'ME1','CO','ME1COA','stud791'),('stud792',55.1,'ME1COA172',1,1,'ME1','CO','ME1COA','stud792'),('stud793',64.38,'ME1COA173',1,1,'ME1','CO','ME1COA','stud793'),('stud794',63.14,'ME1COA174',1,1,'ME1','CO','ME1COA','stud794'),('stud795',54.08,'ME1COA175',1,1,'ME1','CO','ME1COA','stud795'),('stud796',92.84,'ME1COA176',1,1,'ME1','CO','ME1COA','stud796'),('stud797',58.17,'ME1COA177',1,1,'ME1','CO','ME1COA','stud797'),('stud798',69.31,'ME1COA178',1,1,'ME1','CO','ME1COA','stud798'),('stud799',81.38,'ME1COA179',1,1,'ME1','CO','ME1COA','stud799'),('stud800',96.18,'ME1COA180',1,1,'ME1','CO','ME1COA','stud800'),('stud641',59.25,'BECOC301',7,2,'BE','CO','BECOC','stud641'),('stud642',66.18,'BECOC302',7,2,'BE','CO','BECOC','stud642'),('stud643',65.94,'BECOC303',7,2,'BE','CO','BECOC','stud643'),('stud644',86.56,'BECOC304',7,2,'BE','CO','BECOC','stud644'),('stud645',75.37,'BECOC305',7,2,'BE','CO','BECOC','stud645'),('stud646',89.28,'BECOC306',7,2,'BE','CO','BECOC','stud646'),('stud647',56.74,'BECOC307',7,2,'BE','CO','BECOC','stud647'),('stud648',71.65,'BECOC308',7,2,'BE','CO','BECOC','stud648'),('stud649',77.61,'BECOC309',7,2,'BE','CO','BECOC','stud649'),('stud650',78.55,'BECOC310',7,2,'BE','CO','BECOC','stud650'),('stud651',55.82,'BECOC311',7,2,'BE','CO','BECOC','stud651'),('stud652',77.18,'BECOC312',7,2,'BE','CO','BECOC','stud652'),('stud653',61.16,'BECOC313',7,2,'BE','CO','BECOC','stud653'),('stud654',87.66,'BECOC314',7,2,'BE','CO','BECOC','stud654'),('stud655',50.93,'BECOC315',7,2,'BE','CO','BECOC','stud655'),('stud656',68.38,'BECOC316',7,2,'BE','CO','BECOC','stud656'),('stud657',65.6,'BECOC317',7,2,'BE','CO','BECOC','stud657'),('stud658',67.84,'BECOC318',7,2,'BE','CO','BECOC','stud658'),('stud659',86.09,'BECOC319',7,2,'BE','CO','BECOC','stud659'),('stud660',74.52,'BECOC320',7,2,'BE','CO','BECOC','stud660'),('stud661',68.97,'BECOC321',7,2,'BE','CO','BECOC','stud661'),('stud662',79.25,'BECOC322',7,2,'BE','CO','BECOC','stud662'),('stud663',87.37,'BECOC323',7,2,'BE','CO','BECOC','stud663'),('stud664',98.28,'BECOC324',7,2,'BE','CO','BECOC','stud664'),('stud665',86.81,'BECOC325',7,2,'BE','CO','BECOC','stud665'),('stud666',97.6,'BECOC326',7,2,'BE','CO','BECOC','stud666'),('stud667',81.63,'BECOC327',7,2,'BE','CO','BECOC','stud667'),('stud668',84.71,'BECOC328',7,2,'BE','CO','BECOC','stud668'),('stud669',52.01,'BECOC329',7,2,'BE','CO','BECOC','stud669'),('stud670',87.98,'BECOC330',7,2,'BE','CO','BECOC','stud670'),('stud671',73.44,'BECOC331',7,2,'BE','CO','BECOC','stud671'),('stud672',72.27,'BECOC332',7,2,'BE','CO','BECOC','stud672'),('stud673',80.37,'BECOC333',7,2,'BE','CO','BECOC','stud673'),('stud674',62.23,'BECOC334',7,2,'BE','CO','BECOC','stud674'),('stud675',67.68,'BECOC335',7,2,'BE','CO','BECOC','stud675'),('stud676',69.23,'BECOC336',7,2,'BE','CO','BECOC','stud676'),('stud677',95.26,'BECOC337',7,2,'BE','CO','BECOC','stud677'),('stud678',68.36,'BECOC338',7,2,'BE','CO','BECOC','stud678'),('stud679',71.49,'BECOC339',7,2,'BE','CO','BECOC','stud679'),('stud680',50.95,'BECOC340',7,2,'BE','CO','BECOC','stud680'),('stud681',66.67,'BECOC341',7,2,'BE','CO','BECOC','stud681'),('stud682',67.52,'BECOC342',7,2,'BE','CO','BECOC','stud682'),('stud683',60.19,'BECOC343',7,2,'BE','CO','BECOC','stud683'),('stud684',53.89,'BECOC344',7,2,'BE','CO','BECOC','stud684'),('stud685',89.6,'BECOC345',7,2,'BE','CO','BECOC','stud685'),('stud686',67.76,'BECOC346',7,2,'BE','CO','BECOC','stud686'),('stud687',50.25,'BECOC347',7,2,'BE','CO','BECOC','stud687'),('stud688',92.56,'BECOC348',7,2,'BE','CO','BECOC','stud688'),('stud689',53.17,'BECOC349',7,2,'BE','CO','BECOC','stud689'),('stud690',76.92,'BECOC350',7,2,'BE','CO','BECOC','stud690'),('stud691',74.58,'BECOC351',7,2,'BE','CO','BECOC','stud691'),('stud692',71.68,'BECOC352',7,2,'BE','CO','BECOC','stud692'),('stud693',91.83,'BECOC353',7,2,'BE','CO','BECOC','stud693'),('stud694',87.86,'BECOC354',7,2,'BE','CO','BECOC','stud694'),('stud695',70.38,'BECOC355',7,2,'BE','CO','BECOC','stud695'),('stud696',62.66,'BECOC356',7,2,'BE','CO','BECOC','stud696'),('stud697',53.97,'BECOC357',7,2,'BE','CO','BECOC','stud697'),('stud698',57.71,'BECOC358',7,2,'BE','CO','BECOC','stud698'),('stud699',92.97,'BECOC359',7,2,'BE','CO','BECOC','stud699'),('stud700',50.74,'BECOC360',7,2,'BE','CO','BECOC','stud700'),('stud701',71.63,'BECOC361',7,2,'BE','CO','BECOC','stud701'),('stud702',87.76,'BECOC362',7,2,'BE','CO','BECOC','stud702'),('stud703',99.24,'BECOC363',7,2,'BE','CO','BECOC','stud703'),('stud704',51.99,'BECOC364',7,2,'BE','CO','BECOC','stud704'),('stud705',80.34,'BECOC365',7,2,'BE','CO','BECOC','stud705'),('stud706',88.85,'BECOC366',7,2,'BE','CO','BECOC','stud706'),('stud707',69.41,'BECOC367',7,2,'BE','CO','BECOC','stud707'),('stud708',90.38,'BECOC368',7,2,'BE','CO','BECOC','stud708'),('stud709',53.98,'BECOC369',7,2,'BE','CO','BECOC','stud709'),('stud710',69.3,'BECOC370',7,2,'BE','CO','BECOC','stud710'),('stud711',52.17,'BECOC371',7,2,'BE','CO','BECOC','stud711'),('stud712',69.11,'BECOC372',7,2,'BE','CO','BECOC','stud712'),('stud713',56.36,'BECOC373',7,2,'BE','CO','BECOC','stud713'),('stud714',58.65,'BECOC374',7,2,'BE','CO','BECOC','stud714'),('stud715',57.94,'BECOC375',7,2,'BE','CO','BECOC','stud715'),('stud716',51.68,'BECOC376',7,2,'BE','CO','BECOC','stud716'),('stud717',85.21,'BECOC377',7,2,'BE','CO','BECOC','stud717'),('stud718',79.44,'BECOC378',7,2,'BE','CO','BECOC','stud718'),('stud719',78.06,'BECOC379',7,2,'BE','CO','BECOC','stud719'),('stud720',89.73,'BECOC380',7,2,'BE','CO','BECOC','stud720'),('stud561',79.65,'BECOB201',7,1,'BE','CO','BECOB','stud561'),('stud562',53.49,'BECOB202',7,1,'BE','CO','BECOB','stud562'),('stud563',84.71,'BECOB203',7,1,'BE','CO','BECOB','stud563'),('stud564',97.3,'BECOB204',7,1,'BE','CO','BECOB','stud564'),('stud565',98.1,'BECOB205',7,1,'BE','CO','BECOB','stud565'),('stud566',61.58,'BECOB206',7,1,'BE','CO','BECOB','stud566'),('stud567',70.55,'BECOB207',7,1,'BE','CO','BECOB','stud567'),('stud568',82.36,'BECOB208',7,1,'BE','CO','BECOB','stud568'),('stud569',97.54,'BECOB209',7,1,'BE','CO','BECOB','stud569'),('stud570',77.17,'BECOB210',7,1,'BE','CO','BECOB','stud570'),('stud571',60.32,'BECOB211',7,1,'BE','CO','BECOB','stud571'),('stud572',82.06,'BECOB212',7,1,'BE','CO','BECOB','stud572'),('stud573',52.69,'BECOB213',7,1,'BE','CO','BECOB','stud573'),('stud574',82.34,'BECOB214',7,1,'BE','CO','BECOB','stud574'),('stud575',53.31,'BECOB215',7,1,'BE','CO','BECOB','stud575'),('stud576',55.3,'BECOB216',7,1,'BE','CO','BECOB','stud576'),('stud577',87.85,'BECOB217',7,1,'BE','CO','BECOB','stud577'),('stud578',87.6,'BECOB218',7,1,'BE','CO','BECOB','stud578'),('stud579',80.27,'BECOB219',7,1,'BE','CO','BECOB','stud579'),('stud580',85.49,'BECOB220',7,1,'BE','CO','BECOB','stud580'),('stud581',79.48,'BECOB221',7,1,'BE','CO','BECOB','stud581'),('stud582',84.14,'BECOB222',7,1,'BE','CO','BECOB','stud582'),('stud583',86.74,'BECOB223',7,1,'BE','CO','BECOB','stud583'),('stud584',72.07,'BECOB224',7,1,'BE','CO','BECOB','stud584'),('stud585',57.78,'BECOB225',7,1,'BE','CO','BECOB','stud585'),('stud586',81.88,'BECOB226',7,1,'BE','CO','BECOB','stud586'),('stud587',71.12,'BECOB227',7,1,'BE','CO','BECOB','stud587'),('stud588',93.71,'BECOB228',7,1,'BE','CO','BECOB','stud588'),('stud589',99.27,'BECOB229',7,1,'BE','CO','BECOB','stud589'),('stud590',88.58,'BECOB230',7,1,'BE','CO','BECOB','stud590'),('stud591',58.76,'BECOB231',7,1,'BE','CO','BECOB','stud591'),('stud592',91.07,'BECOB232',7,1,'BE','CO','BECOB','stud592'),('stud593',86.15,'BECOB233',7,1,'BE','CO','BECOB','stud593'),('stud594',71.38,'BECOB234',7,1,'BE','CO','BECOB','stud594'),('stud595',62.91,'BECOB235',7,1,'BE','CO','BECOB','stud595'),('stud596',62.38,'BECOB236',7,1,'BE','CO','BECOB','stud596'),('stud597',81.56,'BECOB237',7,1,'BE','CO','BECOB','stud597'),('stud598',61.24,'BECOB238',7,1,'BE','CO','BECOB','stud598'),('stud599',67.52,'BECOB239',7,1,'BE','CO','BECOB','stud599'),('stud600',92.22,'BECOB240',7,1,'BE','CO','BECOB','stud600'),('stud601',88.29,'BECOB241',7,1,'BE','CO','BECOB','stud601'),('stud602',76.99,'BECOB242',7,1,'BE','CO','BECOB','stud602'),('stud603',74.56,'BECOB243',7,1,'BE','CO','BECOB','stud603'),('stud604',62.95,'BECOB244',7,1,'BE','CO','BECOB','stud604'),('stud605',87.87,'BECOB245',7,1,'BE','CO','BECOB','stud605'),('stud606',82.54,'BECOB246',7,1,'BE','CO','BECOB','stud606'),('stud607',78.29,'BECOB247',7,1,'BE','CO','BECOB','stud607'),('stud608',87.55,'BECOB248',7,1,'BE','CO','BECOB','stud608'),('stud609',97.96,'BECOB249',7,1,'BE','CO','BECOB','stud609'),('stud610',63.67,'BECOB250',7,1,'BE','CO','BECOB','stud610'),('stud611',79.75,'BECOB251',7,1,'BE','CO','BECOB','stud611'),('stud612',94.97,'BECOB252',7,1,'BE','CO','BECOB','stud612'),('stud613',54.53,'BECOB253',7,1,'BE','CO','BECOB','stud613'),('stud614',73.7,'BECOB254',7,1,'BE','CO','BECOB','stud614'),('stud615',58.2,'BECOB255',7,1,'BE','CO','BECOB','stud615'),('stud616',96.26,'BECOB256',7,1,'BE','CO','BECOB','stud616'),('stud617',73.65,'BECOB257',7,1,'BE','CO','BECOB','stud617'),('stud618',75.64,'BECOB258',7,1,'BE','CO','BECOB','stud618'),('stud619',83.29,'BECOB259',7,1,'BE','CO','BECOB','stud619'),('stud620',66.1,'BECOB260',7,1,'BE','CO','BECOB','stud620'),('stud621',86.17,'BECOB261',7,1,'BE','CO','BECOB','stud621'),('stud622',74.37,'BECOB262',7,1,'BE','CO','BECOB','stud622'),('stud623',95.78,'BECOB263',7,1,'BE','CO','BECOB','stud623'),('stud624',94.86,'BECOB264',7,1,'BE','CO','BECOB','stud624'),('stud625',98.54,'BECOB265',7,1,'BE','CO','BECOB','stud625'),('stud626',64.79,'BECOB266',7,1,'BE','CO','BECOB','stud626'),('stud627',76.29,'BECOB267',7,1,'BE','CO','BECOB','stud627'),('stud628',67.7,'BECOB268',7,1,'BE','CO','BECOB','stud628'),('stud629',98.88,'BECOB269',7,1,'BE','CO','BECOB','stud629'),('stud630',94.01,'BECOB270',7,1,'BE','CO','BECOB','stud630'),('stud631',53.95,'BECOB271',7,1,'BE','CO','BECOB','stud631'),('stud632',91.33,'BECOB272',7,1,'BE','CO','BECOB','stud632'),('stud633',82.2,'BECOB273',7,1,'BE','CO','BECOB','stud633'),('stud634',97.87,'BECOB274',7,1,'BE','CO','BECOB','stud634'),('stud635',62.41,'BECOB275',7,1,'BE','CO','BECOB','stud635'),('stud636',88.69,'BECOB276',7,1,'BE','CO','BECOB','stud636'),('stud637',74.29,'BECOB277',7,1,'BE','CO','BECOB','stud637'),('stud638',79.42,'BECOB278',7,1,'BE','CO','BECOB','stud638'),('stud639',60.91,'BECOB279',7,1,'BE','CO','BECOB','stud639'),('stud640',59.92,'BECOB280',7,1,'BE','CO','BECOB','stud640'),('stud481',77.47,'BECOA101',7,1,'BE','CO','BECOA','stud481'),('stud482',78.82,'BECOA102',7,1,'BE','CO','BECOA','stud482'),('stud483',56.86,'BECOA103',7,1,'BE','CO','BECOA','stud483'),('stud484',89.51,'BECOA104',7,1,'BE','CO','BECOA','stud484'),('stud485',86.55,'BECOA105',7,1,'BE','CO','BECOA','stud485'),('stud486',85.91,'BECOA106',7,1,'BE','CO','BECOA','stud486'),('stud487',83.17,'BECOA107',7,1,'BE','CO','BECOA','stud487'),('stud488',74.4,'BECOA108',7,1,'BE','CO','BECOA','stud488'),('stud489',78.86,'BECOA109',7,1,'BE','CO','BECOA','stud489'),('stud490',67.31,'BECOA110',7,1,'BE','CO','BECOA','stud490'),('stud491',93.52,'BECOA111',7,1,'BE','CO','BECOA','stud491'),('stud492',66.31,'BECOA112',7,1,'BE','CO','BECOA','stud492'),('stud493',84.81,'BECOA113',7,1,'BE','CO','BECOA','stud493'),('stud494',95.62,'BECOA114',7,1,'BE','CO','BECOA','stud494'),('stud495',91.38,'BECOA115',7,1,'BE','CO','BECOA','stud495'),('stud496',85.63,'BECOA116',7,1,'BE','CO','BECOA','stud496'),('stud497',63.84,'BECOA117',7,1,'BE','CO','BECOA','stud497'),('stud498',78.38,'BECOA118',7,1,'BE','CO','BECOA','stud498'),('stud499',87.21,'BECOA119',7,1,'BE','CO','BECOA','stud499'),('stud500',78.15,'BECOA120',7,1,'BE','CO','BECOA','stud500'),('stud501',52.08,'BECOA121',7,1,'BE','CO','BECOA','stud501'),('stud502',79.8,'BECOA122',7,1,'BE','CO','BECOA','stud502'),('stud503',99.2,'BECOA123',7,1,'BE','CO','BECOA','stud503'),('stud504',51.34,'BECOA124',7,1,'BE','CO','BECOA','stud504'),('stud505',81.15,'BECOA125',7,1,'BE','CO','BECOA','stud505'),('stud506',53.5,'BECOA126',7,1,'BE','CO','BECOA','stud506'),('stud507',80.68,'BECOA127',7,1,'BE','CO','BECOA','stud507'),('stud508',95.95,'BECOA128',7,1,'BE','CO','BECOA','stud508'),('stud509',84.39,'BECOA129',7,1,'BE','CO','BECOA','stud509'),('stud510',64.99,'BECOA130',7,1,'BE','CO','BECOA','stud510'),('stud511',84.46,'BECOA131',7,1,'BE','CO','BECOA','stud511'),('stud512',84.17,'BECOA132',7,1,'BE','CO','BECOA','stud512'),('stud513',78.89,'BECOA133',7,1,'BE','CO','BECOA','stud513'),('stud514',88.15,'BECOA134',7,1,'BE','CO','BECOA','stud514'),('stud515',76,'BECOA135',7,1,'BE','CO','BECOA','stud515'),('stud516',56.6,'BECOA136',7,1,'BE','CO','BECOA','stud516'),('stud517',93.61,'BECOA137',7,1,'BE','CO','BECOA','stud517'),('stud518',69.22,'BECOA138',7,1,'BE','CO','BECOA','stud518'),('stud519',52.32,'BECOA139',7,1,'BE','CO','BECOA','stud519'),('stud520',77.22,'BECOA140',7,1,'BE','CO','BECOA','stud520'),('stud521',88.25,'BECOA141',7,1,'BE','CO','BECOA','stud521'),('stud522',99.33,'BECOA142',7,1,'BE','CO','BECOA','stud522'),('stud523',85.35,'BECOA143',7,1,'BE','CO','BECOA','stud523'),('stud524',81.65,'BECOA144',7,1,'BE','CO','BECOA','stud524'),('stud525',98.52,'BECOA145',7,1,'BE','CO','BECOA','stud525'),('stud526',76.05,'BECOA146',7,1,'BE','CO','BECOA','stud526'),('stud527',87.08,'BECOA147',7,1,'BE','CO','BECOA','stud527'),('stud528',89.21,'BECOA148',7,1,'BE','CO','BECOA','stud528'),('stud529',59.02,'BECOA149',7,1,'BE','CO','BECOA','stud529'),('stud530',81.41,'BECOA150',7,1,'BE','CO','BECOA','stud530'),('stud531',74.16,'BECOA151',7,1,'BE','CO','BECOA','stud531'),('stud532',52.71,'BECOA152',7,1,'BE','CO','BECOA','stud532'),('stud533',81.07,'BECOA153',7,1,'BE','CO','BECOA','stud533'),('stud534',71.51,'BECOA154',7,1,'BE','CO','BECOA','stud534'),('stud535',64.25,'BECOA155',7,1,'BE','CO','BECOA','stud535'),('stud536',94.23,'BECOA156',7,1,'BE','CO','BECOA','stud536'),('stud537',88.83,'BECOA157',7,1,'BE','CO','BECOA','stud537'),('stud538',65.55,'BECOA158',7,1,'BE','CO','BECOA','stud538'),('stud539',94.16,'BECOA159',7,1,'BE','CO','BECOA','stud539'),('stud540',63.13,'BECOA160',7,1,'BE','CO','BECOA','stud540'),('stud541',50.84,'BECOA161',7,1,'BE','CO','BECOA','stud541'),('stud542',56.55,'BECOA162',7,1,'BE','CO','BECOA','stud542'),('stud543',56.33,'BECOA163',7,1,'BE','CO','BECOA','stud543'),('stud544',59.9,'BECOA164',7,1,'BE','CO','BECOA','stud544'),('stud545',83.83,'BECOA165',7,1,'BE','CO','BECOA','stud545'),('stud546',89.56,'BECOA166',7,1,'BE','CO','BECOA','stud546'),('stud547',86.45,'BECOA167',7,1,'BE','CO','BECOA','stud547'),('stud548',66.79,'BECOA168',7,1,'BE','CO','BECOA','stud548'),('stud549',51.09,'BECOA169',7,1,'BE','CO','BECOA','stud549'),('stud550',85.89,'BECOA170',7,1,'BE','CO','BECOA','stud550'),('stud551',67.07,'BECOA171',7,1,'BE','CO','BECOA','stud551'),('stud552',84.91,'BECOA172',7,1,'BE','CO','BECOA','stud552'),('stud553',79.95,'BECOA173',7,1,'BE','CO','BECOA','stud553'),('stud554',88.37,'BECOA174',7,1,'BE','CO','BECOA','stud554'),('stud555',99,'BECOA175',7,1,'BE','CO','BECOA','stud555'),('stud556',70.95,'BECOA176',7,1,'BE','CO','BECOA','stud556'),('stud557',69.09,'BECOA177',7,1,'BE','CO','BECOA','stud557'),('stud558',50.14,'BECOA178',7,1,'BE','CO','BECOA','stud558'),('stud559',99.06,'BECOA179',7,1,'BE','CO','BECOA','stud559'),('stud560',95.82,'BECOA180',7,1,'BE','CO','BECOA','stud560'),('stud401',94.01,'TECOC301',5,1,'TE','CO','TECOC','stud401'),('stud402',82.93,'TECOC302',5,1,'TE','CO','TECOC','stud402'),('stud403',70.02,'TECOC303',5,1,'TE','CO','TECOC','stud403'),('stud404',97.65,'TECOC304',5,1,'TE','CO','TECOC','stud404'),('stud405',93.84,'TECOC305',5,1,'TE','CO','TECOC','stud405'),('stud406',74.66,'TECOC306',5,1,'TE','CO','TECOC','stud406'),('stud407',85.44,'TECOC307',5,1,'TE','CO','TECOC','stud407'),('stud408',78.22,'TECOC308',5,1,'TE','CO','TECOC','stud408'),('stud409',54.19,'TECOC309',5,1,'TE','CO','TECOC','stud409'),('stud410',89.26,'TECOC310',5,1,'TE','CO','TECOC','stud410'),('stud411',73.77,'TECOC311',5,1,'TE','CO','TECOC','stud411'),('stud412',59.58,'TECOC312',5,1,'TE','CO','TECOC','stud412'),('stud413',79.37,'TECOC313',5,1,'TE','CO','TECOC','stud413'),('stud414',96.39,'TECOC314',5,1,'TE','CO','TECOC','stud414'),('stud415',61.21,'TECOC315',5,1,'TE','CO','TECOC','stud415'),('stud416',52.18,'TECOC316',5,1,'TE','CO','TECOC','stud416'),('stud417',88.67,'TECOC317',5,1,'TE','CO','TECOC','stud417'),('stud418',99.49,'TECOC318',5,1,'TE','CO','TECOC','stud418'),('stud419',82.44,'TECOC319',5,1,'TE','CO','TECOC','stud419'),('stud420',67.07,'TECOC320',5,1,'TE','CO','TECOC','stud420'),('stud421',82.89,'TECOC321',5,1,'TE','CO','TECOC','stud421'),('stud422',93.54,'TECOC322',5,1,'TE','CO','TECOC','stud422'),('stud423',97.73,'TECOC323',5,1,'TE','CO','TECOC','stud423'),('stud424',95.74,'TECOC324',5,1,'TE','CO','TECOC','stud424'),('stud425',57.71,'TECOC325',5,1,'TE','CO','TECOC','stud425'),('stud426',84.07,'TECOC326',5,1,'TE','CO','TECOC','stud426'),('stud427',51.46,'TECOC327',5,1,'TE','CO','TECOC','stud427'),('stud428',74.26,'TECOC328',5,1,'TE','CO','TECOC','stud428'),('stud429',72.05,'TECOC329',5,1,'TE','CO','TECOC','stud429'),('stud430',57.26,'TECOC330',5,1,'TE','CO','TECOC','stud430'),('stud431',51.45,'TECOC331',5,1,'TE','CO','TECOC','stud431'),('stud432',88.29,'TECOC332',5,1,'TE','CO','TECOC','stud432'),('stud433',75.21,'TECOC333',5,1,'TE','CO','TECOC','stud433'),('stud434',53.57,'TECOC334',5,1,'TE','CO','TECOC','stud434'),('stud435',86.37,'TECOC335',5,1,'TE','CO','TECOC','stud435'),('stud436',57.88,'TECOC336',5,1,'TE','CO','TECOC','stud436'),('stud437',56,'TECOC337',5,1,'TE','CO','TECOC','stud437'),('stud438',63.76,'TECOC338',5,1,'TE','CO','TECOC','stud438'),('stud439',94.75,'TECOC339',5,1,'TE','CO','TECOC','stud439'),('stud440',86.16,'TECOC340',5,1,'TE','CO','TECOC','stud440'),('stud441',95.1,'TECOC341',5,1,'TE','CO','TECOC','stud441'),('stud442',62.83,'TECOC342',5,1,'TE','CO','TECOC','stud442'),('stud443',92.21,'TECOC343',5,1,'TE','CO','TECOC','stud443'),('stud444',93.06,'TECOC344',5,1,'TE','CO','TECOC','stud444'),('stud445',69.4,'TECOC345',5,1,'TE','CO','TECOC','stud445'),('stud446',56.65,'TECOC346',5,1,'TE','CO','TECOC','stud446'),('stud447',60.6,'TECOC347',5,1,'TE','CO','TECOC','stud447'),('stud448',79.13,'TECOC348',5,1,'TE','CO','TECOC','stud448'),('stud449',65.13,'TECOC349',5,1,'TE','CO','TECOC','stud449'),('stud450',67.99,'TECOC350',5,1,'TE','CO','TECOC','stud450'),('stud451',94.15,'TECOC351',5,1,'TE','CO','TECOC','stud451'),('stud452',93.8,'TECOC352',5,1,'TE','CO','TECOC','stud452'),('stud453',72.73,'TECOC353',5,1,'TE','CO','TECOC','stud453'),('stud454',91.84,'TECOC354',5,1,'TE','CO','TECOC','stud454'),('stud455',83.02,'TECOC355',5,1,'TE','CO','TECOC','stud455'),('stud456',74.95,'TECOC356',5,1,'TE','CO','TECOC','stud456'),('stud457',55.73,'TECOC357',5,1,'TE','CO','TECOC','stud457'),('stud458',84.65,'TECOC358',5,1,'TE','CO','TECOC','stud458'),('stud459',72.93,'TECOC359',5,1,'TE','CO','TECOC','stud459'),('stud460',50.63,'TECOC360',5,1,'TE','CO','TECOC','stud460'),('stud461',59.69,'TECOC361',5,1,'TE','CO','TECOC','stud461'),('stud462',68.98,'TECOC362',5,1,'TE','CO','TECOC','stud462'),('stud463',79.48,'TECOC363',5,1,'TE','CO','TECOC','stud463'),('stud464',85.73,'TECOC364',5,1,'TE','CO','TECOC','stud464'),('stud465',63.7,'TECOC365',5,1,'TE','CO','TECOC','stud465'),('stud466',98.23,'TECOC366',5,1,'TE','CO','TECOC','stud466'),('stud467',57.5,'TECOC367',5,1,'TE','CO','TECOC','stud467'),('stud468',99.89,'TECOC368',5,1,'TE','CO','TECOC','stud468'),('stud469',65.72,'TECOC369',5,1,'TE','CO','TECOC','stud469'),('stud470',75.81,'TECOC370',5,1,'TE','CO','TECOC','stud470'),('stud471',69.7,'TECOC371',5,1,'TE','CO','TECOC','stud471'),('stud472',62.36,'TECOC372',5,1,'TE','CO','TECOC','stud472'),('stud473',54.58,'TECOC373',5,1,'TE','CO','TECOC','stud473'),('stud474',79.11,'TECOC374',5,1,'TE','CO','TECOC','stud474'),('stud475',93.86,'TECOC375',5,1,'TE','CO','TECOC','stud475'),('stud476',72.89,'TECOC376',5,1,'TE','CO','TECOC','stud476'),('stud477',82.87,'TECOC377',5,1,'TE','CO','TECOC','stud477'),('stud478',82.13,'TECOC378',5,1,'TE','CO','TECOC','stud478'),('stud479',83.88,'TECOC379',5,1,'TE','CO','TECOC','stud479'),('stud480',64.78,'TECOC380',5,1,'TE','CO','TECOC','stud480'),('stud321',54.95,'TECOB201',5,1,'TE','CO','TECOB','stud321'),('stud322',66.46,'TECOB202',5,1,'TE','CO','TECOB','stud322'),('stud323',78.16,'TECOB203',5,1,'TE','CO','TECOB','stud323'),('stud324',78.99,'TECOB204',5,1,'TE','CO','TECOB','stud324'),('stud325',77,'TECOB205',5,1,'TE','CO','TECOB','stud325'),('stud326',98.85,'TECOB206',5,1,'TE','CO','TECOB','stud326'),('stud327',85.92,'TECOB207',5,1,'TE','CO','TECOB','stud327'),('stud328',63.87,'TECOB208',5,1,'TE','CO','TECOB','stud328'),('stud329',72.72,'TECOB209',5,1,'TE','CO','TECOB','stud329'),('stud330',75.91,'TECOB210',5,1,'TE','CO','TECOB','stud330'),('stud331',96.64,'TECOB211',5,1,'TE','CO','TECOB','stud331'),('stud332',96.88,'TECOB212',5,1,'TE','CO','TECOB','stud332'),('stud333',63.01,'TECOB213',5,1,'TE','CO','TECOB','stud333'),('stud334',57.63,'TECOB214',5,1,'TE','CO','TECOB','stud334'),('stud335',80.14,'TECOB215',5,1,'TE','CO','TECOB','stud335'),('stud336',88.99,'TECOB216',5,1,'TE','CO','TECOB','stud336'),('stud337',81.16,'TECOB217',5,1,'TE','CO','TECOB','stud337'),('stud338',53.44,'TECOB218',5,1,'TE','CO','TECOB','stud338'),('stud339',83.5,'TECOB219',5,1,'TE','CO','TECOB','stud339'),('stud340',57.49,'TECOB220',5,1,'TE','CO','TECOB','stud340'),('stud341',70.92,'TECOB221',5,1,'TE','CO','TECOB','stud341'),('stud342',57.27,'TECOB222',5,1,'TE','CO','TECOB','stud342'),('stud343',99.77,'TECOB223',5,1,'TE','CO','TECOB','stud343'),('stud344',77.85,'TECOB224',5,1,'TE','CO','TECOB','stud344'),('stud345',50.51,'TECOB225',5,1,'TE','CO','TECOB','stud345'),('stud346',85.22,'TECOB226',5,1,'TE','CO','TECOB','stud346'),('stud347',70.69,'TECOB227',5,1,'TE','CO','TECOB','stud347'),('stud348',51.06,'TECOB228',5,1,'TE','CO','TECOB','stud348'),('stud349',94.32,'TECOB229',5,1,'TE','CO','TECOB','stud349'),('stud350',88.71,'TECOB230',5,1,'TE','CO','TECOB','stud350'),('stud351',70.18,'TECOB231',5,1,'TE','CO','TECOB','stud351'),('stud352',98.37,'TECOB232',5,1,'TE','CO','TECOB','stud352'),('stud353',85.34,'TECOB233',5,1,'TE','CO','TECOB','stud353'),('stud354',81.54,'TECOB234',5,1,'TE','CO','TECOB','stud354'),('stud355',72.76,'TECOB235',5,1,'TE','CO','TECOB','stud355'),('stud356',61.51,'TECOB236',5,1,'TE','CO','TECOB','stud356'),('stud357',89.88,'TECOB237',5,1,'TE','CO','TECOB','stud357'),('stud358',80.94,'TECOB238',5,1,'TE','CO','TECOB','stud358'),('stud359',83.82,'TECOB239',5,1,'TE','CO','TECOB','stud359'),('stud360',95.32,'TECOB240',5,1,'TE','CO','TECOB','stud360'),('stud361',85.61,'TECOB241',5,1,'TE','CO','TECOB','stud361'),('stud362',96.01,'TECOB242',5,1,'TE','CO','TECOB','stud362'),('stud363',95.81,'TECOB243',5,1,'TE','CO','TECOB','stud363'),('stud364',85.88,'TECOB244',5,1,'TE','CO','TECOB','stud364'),('stud365',96.78,'TECOB245',5,1,'TE','CO','TECOB','stud365'),('stud366',95.4,'TECOB246',5,1,'TE','CO','TECOB','stud366'),('stud367',87.82,'TECOB247',5,1,'TE','CO','TECOB','stud367'),('stud368',72.12,'TECOB248',5,1,'TE','CO','TECOB','stud368'),('stud369',83.4,'TECOB249',5,1,'TE','CO','TECOB','stud369'),('stud370',82.25,'TECOB250',5,1,'TE','CO','TECOB','stud370'),('stud371',91.61,'TECOB251',5,1,'TE','CO','TECOB','stud371'),('stud372',57.43,'TECOB252',5,1,'TE','CO','TECOB','stud372'),('stud373',87.56,'TECOB253',5,1,'TE','CO','TECOB','stud373'),('stud374',50,'TECOB254',5,1,'TE','CO','TECOB','stud374'),('stud375',66.3,'TECOB255',5,1,'TE','CO','TECOB','stud375'),('stud376',54.17,'TECOB256',5,1,'TE','CO','TECOB','stud376'),('stud377',72.77,'TECOB257',5,1,'TE','CO','TECOB','stud377'),('stud378',87.43,'TECOB258',5,1,'TE','CO','TECOB','stud378'),('stud379',87.09,'TECOB259',5,1,'TE','CO','TECOB','stud379'),('stud380',70.4,'TECOB260',5,1,'TE','CO','TECOB','stud380'),('stud381',71.46,'TECOB261',5,1,'TE','CO','TECOB','stud381'),('stud382',64.7,'TECOB262',5,1,'TE','CO','TECOB','stud382'),('stud383',74.35,'TECOB263',5,1,'TE','CO','TECOB','stud383'),('stud384',62.35,'TECOB264',5,1,'TE','CO','TECOB','stud384'),('stud385',84.49,'TECOB265',5,1,'TE','CO','TECOB','stud385'),('stud386',61.4,'TECOB266',5,1,'TE','CO','TECOB','stud386'),('stud387',78.08,'TECOB267',5,1,'TE','CO','TECOB','stud387'),('stud388',55.03,'TECOB268',5,1,'TE','CO','TECOB','stud388'),('stud389',92.35,'TECOB269',5,1,'TE','CO','TECOB','stud389'),('stud390',58.91,'TECOB270',5,1,'TE','CO','TECOB','stud390'),('stud391',85.59,'TECOB271',5,1,'TE','CO','TECOB','stud391'),('stud392',50.37,'TECOB272',5,1,'TE','CO','TECOB','stud392'),('stud393',55.77,'TECOB273',5,1,'TE','CO','TECOB','stud393'),('stud394',76.4,'TECOB274',5,1,'TE','CO','TECOB','stud394'),('stud395',88.72,'TECOB275',5,1,'TE','CO','TECOB','stud395'),('stud396',92.73,'TECOB276',5,1,'TE','CO','TECOB','stud396'),('stud397',84.45,'TECOB277',5,1,'TE','CO','TECOB','stud397'),('stud398',68.45,'TECOB278',5,1,'TE','CO','TECOB','stud398'),('stud399',91.89,'TECOB279',5,1,'TE','CO','TECOB','stud399'),('stud400',70.89,'TECOB280',5,1,'TE','CO','TECOB','stud400'),('stud241',96.17,'TECOA101',5,1,'TE','CO','TECOA','stud241'),('stud242',82.11,'TECOA102',5,1,'TE','CO','TECOA','stud242'),('stud243',73.88,'TECOA103',5,1,'TE','CO','TECOA','stud243'),('stud244',89.43,'TECOA104',5,1,'TE','CO','TECOA','stud244'),('stud245',82.62,'TECOA105',5,1,'TE','CO','TECOA','stud245'),('stud246',91.96,'TECOA106',5,1,'TE','CO','TECOA','stud246'),('stud247',57.08,'TECOA107',5,1,'TE','CO','TECOA','stud247'),('stud248',61.04,'TECOA108',5,1,'TE','CO','TECOA','stud248'),('stud249',93.93,'TECOA109',5,1,'TE','CO','TECOA','stud249'),('stud250',52.7,'TECOA110',5,1,'TE','CO','TECOA','stud250'),('stud251',78.93,'TECOA111',5,1,'TE','CO','TECOA','stud251'),('stud252',55.5,'TECOA112',5,1,'TE','CO','TECOA','stud252'),('stud253',71.27,'TECOA113',5,1,'TE','CO','TECOA','stud253'),('stud254',84.85,'TECOA114',5,1,'TE','CO','TECOA','stud254'),('stud255',72.59,'TECOA115',5,1,'TE','CO','TECOA','stud255'),('stud256',65.95,'TECOA116',5,1,'TE','CO','TECOA','stud256'),('stud257',85.68,'TECOA117',5,1,'TE','CO','TECOA','stud257'),('stud258',79.82,'TECOA118',5,1,'TE','CO','TECOA','stud258'),('stud259',56.59,'TECOA119',5,1,'TE','CO','TECOA','stud259'),('stud260',73.36,'TECOA120',5,1,'TE','CO','TECOA','stud260'),('stud261',67.95,'TECOA121',5,1,'TE','CO','TECOA','stud261'),('stud262',92.61,'TECOA122',5,1,'TE','CO','TECOA','stud262'),('stud263',84.79,'TECOA123',5,1,'TE','CO','TECOA','stud263'),('stud264',63.53,'TECOA124',5,1,'TE','CO','TECOA','stud264'),('stud265',53.56,'TECOA125',5,1,'TE','CO','TECOA','stud265'),('stud266',96.93,'TECOA126',5,1,'TE','CO','TECOA','stud266'),('stud267',99.12,'TECOA127',5,1,'TE','CO','TECOA','stud267'),('stud268',74.95,'TECOA128',5,1,'TE','CO','TECOA','stud268'),('stud269',92.13,'TECOA129',5,1,'TE','CO','TECOA','stud269'),('stud270',51,'TECOA130',5,1,'TE','CO','TECOA','stud270'),('stud271',75.4,'TECOA131',5,1,'TE','CO','TECOA','stud271'),('stud272',76.5,'TECOA132',5,1,'TE','CO','TECOA','stud272'),('stud273',58.68,'TECOA133',5,1,'TE','CO','TECOA','stud273'),('stud274',66.59,'TECOA134',5,1,'TE','CO','TECOA','stud274'),('stud275',58.67,'TECOA135',5,1,'TE','CO','TECOA','stud275'),('stud276',52.35,'TECOA136',5,1,'TE','CO','TECOA','stud276'),('stud277',56.89,'TECOA137',5,1,'TE','CO','TECOA','stud277'),('stud278',81.23,'TECOA138',5,1,'TE','CO','TECOA','stud278'),('stud279',90.57,'TECOA139',5,1,'TE','CO','TECOA','stud279'),('stud280',93.31,'TECOA140',5,1,'TE','CO','TECOA','stud280'),('stud281',57.89,'TECOA141',5,1,'TE','CO','TECOA','stud281'),('stud282',62.67,'TECOA142',5,1,'TE','CO','TECOA','stud282'),('stud283',81.09,'TECOA143',5,1,'TE','CO','TECOA','stud283'),('stud284',98.15,'TECOA144',5,1,'TE','CO','TECOA','stud284'),('stud285',70.06,'TECOA145',5,1,'TE','CO','TECOA','stud285'),('stud286',63.73,'TECOA146',5,1,'TE','CO','TECOA','stud286'),('stud287',66.57,'TECOA147',5,1,'TE','CO','TECOA','stud287'),('stud288',83.21,'TECOA148',5,1,'TE','CO','TECOA','stud288'),('stud289',96.39,'TECOA149',5,1,'TE','CO','TECOA','stud289'),('stud290',88.73,'TECOA150',5,1,'TE','CO','TECOA','stud290'),('stud291',53.06,'TECOA151',5,1,'TE','CO','TECOA','stud291'),('stud292',95.05,'TECOA152',5,1,'TE','CO','TECOA','stud292'),('stud293',84.03,'TECOA153',5,1,'TE','CO','TECOA','stud293'),('stud294',91.03,'TECOA154',5,1,'TE','CO','TECOA','stud294'),('stud295',85.79,'TECOA155',5,1,'TE','CO','TECOA','stud295'),('stud296',59.76,'TECOA156',5,1,'TE','CO','TECOA','stud296'),('stud297',75.05,'TECOA157',5,1,'TE','CO','TECOA','stud297'),('stud298',63.78,'TECOA158',5,1,'TE','CO','TECOA','stud298'),('stud299',68.18,'TECOA159',5,1,'TE','CO','TECOA','stud299'),('stud300',84.34,'TECOA160',5,1,'TE','CO','TECOA','stud300'),('stud301',83.21,'TECOA161',5,1,'TE','CO','TECOA','stud301'),('stud302',61.14,'TECOA162',5,1,'TE','CO','TECOA','stud302'),('stud303',81.26,'TECOA163',5,1,'TE','CO','TECOA','stud303'),('stud304',52.66,'TECOA164',5,1,'TE','CO','TECOA','stud304'),('stud305',86.44,'TECOA165',5,1,'TE','CO','TECOA','stud305'),('stud306',95.74,'TECOA166',5,1,'TE','CO','TECOA','stud306'),('stud307',62.17,'TECOA167',5,1,'TE','CO','TECOA','stud307'),('stud308',84.96,'TECOA168',5,1,'TE','CO','TECOA','stud308'),('stud309',59.1,'TECOA169',5,1,'TE','CO','TECOA','stud309'),('stud310',99,'TECOA170',5,1,'TE','CO','TECOA','stud310'),('stud311',55.31,'TECOA171',5,1,'TE','CO','TECOA','stud311'),('stud312',95.52,'TECOA172',5,1,'TE','CO','TECOA','stud312'),('stud313',70.25,'TECOA173',5,1,'TE','CO','TECOA','stud313'),('stud314',56.47,'TECOA174',5,1,'TE','CO','TECOA','stud314'),('stud315',70.5,'TECOA175',5,1,'TE','CO','TECOA','stud315'),('stud316',75.87,'TECOA176',5,1,'TE','CO','TECOA','stud316'),('stud317',88.97,'TECOA177',5,1,'TE','CO','TECOA','stud317'),('stud318',98.58,'TECOA178',5,1,'TE','CO','TECOA','stud318'),('stud319',66.19,'TECOA179',5,1,'TE','CO','TECOA','stud319'),('stud320',92.35,'TECOA180',5,1,'TE','CO','TECOA','stud320'),('stud161',92.95,'SECOC301',3,1,'SE','CO','SECOC','stud161'),('stud162',66.94,'SECOC302',3,1,'SE','CO','SECOC','stud162'),('stud163',65.22,'SECOC303',3,1,'SE','CO','SECOC','stud163'),('stud164',56.46,'SECOC304',3,1,'SE','CO','SECOC','stud164'),('stud165',97.34,'SECOC305',3,1,'SE','CO','SECOC','stud165'),('stud166',80.93,'SECOC306',3,1,'SE','CO','SECOC','stud166'),('stud167',55.28,'SECOC307',3,1,'SE','CO','SECOC','stud167'),('stud168',70.85,'SECOC308',3,1,'SE','CO','SECOC','stud168'),('stud169',96.43,'SECOC309',3,1,'SE','CO','SECOC','stud169'),('stud170',80.29,'SECOC310',3,1,'SE','CO','SECOC','stud170'),('stud171',68.74,'SECOC311',3,1,'SE','CO','SECOC','stud171'),('stud172',50.24,'SECOC312',3,1,'SE','CO','SECOC','stud172'),('stud173',53.13,'SECOC313',3,1,'SE','CO','SECOC','stud173'),('stud174',92.53,'SECOC314',3,1,'SE','CO','SECOC','stud174'),('stud175',58.82,'SECOC315',3,1,'SE','CO','SECOC','stud175'),('stud176',94.95,'SECOC316',3,1,'SE','CO','SECOC','stud176'),('stud177',59.94,'SECOC317',3,1,'SE','CO','SECOC','stud177'),('stud178',76.26,'SECOC318',3,1,'SE','CO','SECOC','stud178'),('stud179',67.36,'SECOC319',3,1,'SE','CO','SECOC','stud179'),('stud180',89.43,'SECOC320',3,1,'SE','CO','SECOC','stud180'),('stud181',83.19,'SECOC321',3,1,'SE','CO','SECOC','stud181'),('stud182',62.67,'SECOC322',3,1,'SE','CO','SECOC','stud182'),('stud183',70.17,'SECOC323',3,1,'SE','CO','SECOC','stud183'),('stud184',96.16,'SECOC324',3,1,'SE','CO','SECOC','stud184'),('stud185',55.82,'SECOC325',3,1,'SE','CO','SECOC','stud185'),('stud186',69.64,'SECOC326',3,1,'SE','CO','SECOC','stud186'),('stud187',56.62,'SECOC327',3,1,'SE','CO','SECOC','stud187'),('stud188',65.93,'SECOC328',3,1,'SE','CO','SECOC','stud188'),('stud189',65.24,'SECOC329',3,1,'SE','CO','SECOC','stud189'),('stud190',63.02,'SECOC330',3,1,'SE','CO','SECOC','stud190'),('stud191',53.29,'SECOC331',3,1,'SE','CO','SECOC','stud191'),('stud192',56.44,'SECOC332',3,1,'SE','CO','SECOC','stud192'),('stud193',73.93,'SECOC333',3,1,'SE','CO','SECOC','stud193'),('stud194',98.83,'SECOC334',3,1,'SE','CO','SECOC','stud194'),('stud195',83.4,'SECOC335',3,1,'SE','CO','SECOC','stud195'),('stud196',78.06,'SECOC336',3,1,'SE','CO','SECOC','stud196'),('stud197',73.75,'SECOC337',3,1,'SE','CO','SECOC','stud197'),('stud198',50.67,'SECOC338',3,1,'SE','CO','SECOC','stud198'),('stud199',54.36,'SECOC339',3,1,'SE','CO','SECOC','stud199'),('stud200',95.26,'SECOC340',3,1,'SE','CO','SECOC','stud200'),('stud201',75.68,'SECOC341',3,1,'SE','CO','SECOC','stud201'),('stud202',64.09,'SECOC342',3,1,'SE','CO','SECOC','stud202'),('stud203',77.21,'SECOC343',3,1,'SE','CO','SECOC','stud203'),('stud204',76.25,'SECOC344',3,1,'SE','CO','SECOC','stud204'),('stud205',80.49,'SECOC345',3,1,'SE','CO','SECOC','stud205'),('stud206',73.72,'SECOC346',3,1,'SE','CO','SECOC','stud206'),('stud207',78.36,'SECOC347',3,1,'SE','CO','SECOC','stud207'),('stud208',75.43,'SECOC348',3,1,'SE','CO','SECOC','stud208'),('stud209',58.34,'SECOC349',3,1,'SE','CO','SECOC','stud209'),('stud210',56.01,'SECOC350',3,1,'SE','CO','SECOC','stud210'),('stud211',61.98,'SECOC351',3,1,'SE','CO','SECOC','stud211'),('stud212',89.85,'SECOC352',3,1,'SE','CO','SECOC','stud212'),('stud213',69.7,'SECOC353',3,1,'SE','CO','SECOC','stud213'),('stud214',75.33,'SECOC354',3,1,'SE','CO','SECOC','stud214'),('stud215',92.53,'SECOC355',3,1,'SE','CO','SECOC','stud215'),('stud216',78.8,'SECOC356',3,1,'SE','CO','SECOC','stud216'),('stud217',72.74,'SECOC357',3,1,'SE','CO','SECOC','stud217'),('stud218',78.37,'SECOC358',3,1,'SE','CO','SECOC','stud218'),('stud219',59.22,'SECOC359',3,1,'SE','CO','SECOC','stud219'),('stud220',61.98,'SECOC360',3,1,'SE','CO','SECOC','stud220'),('stud221',98.67,'SECOC361',3,1,'SE','CO','SECOC','stud221'),('stud222',51.72,'SECOC362',3,1,'SE','CO','SECOC','stud222'),('stud223',71.21,'SECOC363',3,1,'SE','CO','SECOC','stud223'),('stud224',98.94,'SECOC364',3,1,'SE','CO','SECOC','stud224'),('stud225',81.92,'SECOC365',3,1,'SE','CO','SECOC','stud225'),('stud226',95.21,'SECOC366',3,1,'SE','CO','SECOC','stud226'),('stud227',71.47,'SECOC367',3,1,'SE','CO','SECOC','stud227'),('stud228',84.18,'SECOC368',3,1,'SE','CO','SECOC','stud228'),('stud229',57.41,'SECOC369',3,1,'SE','CO','SECOC','stud229'),('stud230',63.7,'SECOC370',3,1,'SE','CO','SECOC','stud230'),('stud231',54.33,'SECOC371',3,1,'SE','CO','SECOC','stud231'),('stud232',89.28,'SECOC372',3,1,'SE','CO','SECOC','stud232'),('stud233',95.53,'SECOC373',3,1,'SE','CO','SECOC','stud233'),('stud234',84.33,'SECOC374',3,1,'SE','CO','SECOC','stud234'),('stud235',51.96,'SECOC375',3,1,'SE','CO','SECOC','stud235'),('stud236',58.89,'SECOC376',3,1,'SE','CO','SECOC','stud236'),('stud237',52.4,'SECOC377',3,1,'SE','CO','SECOC','stud237'),('stud238',63.86,'SECOC378',3,1,'SE','CO','SECOC','stud238'),('stud239',95.37,'SECOC379',3,1,'SE','CO','SECOC','stud239'),('stud240',98.69,'SECOC380',3,1,'SE','CO','SECOC','stud240'),('stud81',90.02,'SECOB201',3,1,'SE','CO','SECOB','stud81'),('stud82',93.63,'SECOB202',3,1,'SE','CO','SECOB','stud82'),('stud83',53.24,'SECOB203',3,1,'SE','CO','SECOB','stud83'),('stud84',92.57,'SECOB204',3,1,'SE','CO','SECOB','stud84'),('stud85',85.75,'SECOB205',3,1,'SE','CO','SECOB','stud85'),('stud86',82.41,'SECOB206',3,1,'SE','CO','SECOB','stud86'),('stud87',78.49,'SECOB207',3,1,'SE','CO','SECOB','stud87'),('stud88',97.26,'SECOB208',3,1,'SE','CO','SECOB','stud88'),('stud89',63.96,'SECOB209',3,1,'SE','CO','SECOB','stud89'),('stud90',80.55,'SECOB210',3,1,'SE','CO','SECOB','stud90'),('stud91',82.72,'SECOB211',3,1,'SE','CO','SECOB','stud91'),('stud92',86.06,'SECOB212',3,1,'SE','CO','SECOB','stud92'),('stud93',91.55,'SECOB213',3,1,'SE','CO','SECOB','stud93'),('stud94',53.91,'SECOB214',3,1,'SE','CO','SECOB','stud94'),('stud95',77.52,'SECOB215',3,1,'SE','CO','SECOB','stud95'),('stud96',59.07,'SECOB216',3,1,'SE','CO','SECOB','stud96'),('stud97',53.52,'SECOB217',3,1,'SE','CO','SECOB','stud97'),('stud98',69.21,'SECOB218',3,1,'SE','CO','SECOB','stud98'),('stud99',91.24,'SECOB219',3,1,'SE','CO','SECOB','stud99'),('stud100',59.84,'SECOB220',3,1,'SE','CO','SECOB','stud100'),('stud101',84.23,'SECOB221',3,1,'SE','CO','SECOB','stud101'),('stud102',93.95,'SECOB222',3,1,'SE','CO','SECOB','stud102'),('stud103',96.49,'SECOB223',3,1,'SE','CO','SECOB','stud103'),('stud104',65.18,'SECOB224',3,1,'SE','CO','SECOB','stud104'),('stud105',77.03,'SECOB225',3,1,'SE','CO','SECOB','stud105'),('stud106',94.66,'SECOB226',3,1,'SE','CO','SECOB','stud106'),('stud107',75.64,'SECOB227',3,1,'SE','CO','SECOB','stud107'),('stud108',79.08,'SECOB228',3,1,'SE','CO','SECOB','stud108'),('stud109',69.27,'SECOB229',3,1,'SE','CO','SECOB','stud109'),('stud110',67.75,'SECOB230',3,1,'SE','CO','SECOB','stud110'),('stud111',99.58,'SECOB231',3,1,'SE','CO','SECOB','stud111'),('stud112',89.21,'SECOB232',3,1,'SE','CO','SECOB','stud112'),('stud113',88.68,'SECOB233',3,1,'SE','CO','SECOB','stud113'),('stud114',84.18,'SECOB234',3,1,'SE','CO','SECOB','stud114'),('stud115',54.49,'SECOB235',3,1,'SE','CO','SECOB','stud115'),('stud116',90.31,'SECOB236',3,1,'SE','CO','SECOB','stud116'),('stud117',75.44,'SECOB237',3,1,'SE','CO','SECOB','stud117'),('stud118',93.92,'SECOB238',3,1,'SE','CO','SECOB','stud118'),('stud119',77.34,'SECOB239',3,1,'SE','CO','SECOB','stud119'),('stud120',61.16,'SECOB240',3,1,'SE','CO','SECOB','stud120'),('stud121',83.8,'SECOB241',3,1,'SE','CO','SECOB','stud121'),('stud122',73.01,'SECOB242',3,1,'SE','CO','SECOB','stud122'),('stud123',75.38,'SECOB243',3,1,'SE','CO','SECOB','stud123'),('stud124',91.53,'SECOB244',3,1,'SE','CO','SECOB','stud124'),('stud125',52.52,'SECOB245',3,1,'SE','CO','SECOB','stud125'),('stud126',91.25,'SECOB246',3,1,'SE','CO','SECOB','stud126'),('stud127',63.9,'SECOB247',3,1,'SE','CO','SECOB','stud127'),('stud128',97.36,'SECOB248',3,1,'SE','CO','SECOB','stud128'),('stud129',72.8,'SECOB249',3,1,'SE','CO','SECOB','stud129'),('stud130',82.75,'SECOB250',3,1,'SE','CO','SECOB','stud130'),('stud131',67.26,'SECOB251',3,1,'SE','CO','SECOB','stud131'),('stud132',96.99,'SECOB252',3,1,'SE','CO','SECOB','stud132'),('stud133',66.26,'SECOB253',3,1,'SE','CO','SECOB','stud133'),('stud134',73.68,'SECOB254',3,1,'SE','CO','SECOB','stud134'),('stud135',53.74,'SECOB255',3,1,'SE','CO','SECOB','stud135'),('stud136',54.42,'SECOB256',3,1,'SE','CO','SECOB','stud136'),('stud137',99.31,'SECOB257',3,1,'SE','CO','SECOB','stud137'),('stud138',95.81,'SECOB258',3,1,'SE','CO','SECOB','stud138'),('stud139',82.55,'SECOB259',3,1,'SE','CO','SECOB','stud139'),('stud140',55.34,'SECOB260',3,1,'SE','CO','SECOB','stud140'),('stud141',97.46,'SECOB261',3,1,'SE','CO','SECOB','stud141'),('stud142',84.47,'SECOB262',3,1,'SE','CO','SECOB','stud142'),('stud143',71.96,'SECOB263',3,1,'SE','CO','SECOB','stud143'),('stud144',95.83,'SECOB264',3,1,'SE','CO','SECOB','stud144'),('stud145',83.88,'SECOB265',3,1,'SE','CO','SECOB','stud145'),('stud146',98.17,'SECOB266',3,1,'SE','CO','SECOB','stud146'),('stud147',76.37,'SECOB267',3,1,'SE','CO','SECOB','stud147'),('stud148',84.91,'SECOB268',3,1,'SE','CO','SECOB','stud148'),('stud149',65.75,'SECOB269',3,1,'SE','CO','SECOB','stud149'),('stud150',85.15,'SECOB270',3,1,'SE','CO','SECOB','stud150'),('stud151',84.56,'SECOB271',3,1,'SE','CO','SECOB','stud151'),('stud152',58.96,'SECOB272',3,1,'SE','CO','SECOB','stud152'),('stud153',61.78,'SECOB273',3,1,'SE','CO','SECOB','stud153'),('stud154',92.79,'SECOB274',3,1,'SE','CO','SECOB','stud154'),('stud155',66.52,'SECOB275',3,1,'SE','CO','SECOB','stud155'),('stud156',51.37,'SECOB276',3,1,'SE','CO','SECOB','stud156'),('stud157',71.12,'SECOB277',3,1,'SE','CO','SECOB','stud157'),('stud158',63.32,'SECOB278',3,1,'SE','CO','SECOB','stud158'),('stud159',59.34,'SECOB279',3,1,'SE','CO','SECOB','stud159'),('stud160',50.04,'SECOB280',3,1,'SE','CO','SECOB','stud160'),('stud1',70.43,'SECOA101',3,1,'SE','CO','SECOA','stud1'),('stud2',78.2,'SECOA102',3,1,'SE','CO','SECOA','stud2'),('stud3',99.76,'SECOA103',3,1,'SE','CO','SECOA','stud3'),('stud4',83.87,'SECOA104',3,1,'SE','CO','SECOA','stud4'),('stud5',51.05,'SECOA105',3,1,'SE','CO','SECOA','stud5'),('stud6',60.96,'SECOA106',3,1,'SE','CO','SECOA','stud6'),('stud7',52.22,'SECOA107',3,1,'SE','CO','SECOA','stud7'),('stud8',53.75,'SECOA108',3,1,'SE','CO','SECOA','stud8'),('stud9',82.8,'SECOA109',3,1,'SE','CO','SECOA','stud9'),('stud10',73.11,'SECOA110',3,1,'SE','CO','SECOA','stud10'),('stud11',72.7,'SECOA111',3,1,'SE','CO','SECOA','stud11'),('stud12',53.16,'SECOA112',3,1,'SE','CO','SECOA','stud12'),('stud13',74.78,'SECOA113',3,1,'SE','CO','SECOA','stud13'),('stud14',68.13,'SECOA114',3,1,'SE','CO','SECOA','stud14'),('stud15',70.95,'SECOA115',3,1,'SE','CO','SECOA','stud15'),('stud16',59.23,'SECOA116',3,1,'SE','CO','SECOA','stud16'),('stud17',87.25,'SECOA117',3,1,'SE','CO','SECOA','stud17'),('stud18',96.39,'SECOA118',3,1,'SE','CO','SECOA','stud18'),('stud19',87.41,'SECOA119',3,1,'SE','CO','SECOA','stud19'),('stud20',71.57,'SECOA120',3,1,'SE','CO','SECOA','stud20'),('stud21',86.65,'SECOA121',3,1,'SE','CO','SECOA','stud21'),('stud22',86.38,'SECOA122',3,1,'SE','CO','SECOA','stud22'),('stud23',66.32,'SECOA123',3,1,'SE','CO','SECOA','stud23'),('stud24',63.97,'SECOA124',3,1,'SE','CO','SECOA','stud24'),('stud25',84.14,'SECOA125',3,1,'SE','CO','SECOA','stud25'),('stud26',77.83,'SECOA126',3,1,'SE','CO','SECOA','stud26'),('stud27',76.59,'SECOA127',3,1,'SE','CO','SECOA','stud27'),('stud28',54.29,'SECOA128',3,1,'SE','CO','SECOA','stud28'),('stud29',76.71,'SECOA129',3,1,'SE','CO','SECOA','stud29'),('stud30',59.25,'SECOA130',3,1,'SE','CO','SECOA','stud30'),('stud31',88.38,'SECOA131',3,1,'SE','CO','SECOA','stud31'),('stud32',70.88,'SECOA132',3,1,'SE','CO','SECOA','stud32'),('stud33',86.5,'SECOA133',3,1,'SE','CO','SECOA','stud33'),('stud34',57.03,'SECOA134',3,1,'SE','CO','SECOA','stud34'),('stud35',75.32,'SECOA135',3,1,'SE','CO','SECOA','stud35'),('stud36',51.85,'SECOA136',3,1,'SE','CO','SECOA','stud36'),('stud37',64.08,'SECOA137',3,1,'SE','CO','SECOA','stud37'),('stud38',63.65,'SECOA138',3,1,'SE','CO','SECOA','stud38'),('stud39',68.63,'SECOA139',3,1,'SE','CO','SECOA','stud39'),('stud40',63.48,'SECOA140',3,1,'SE','CO','SECOA','stud40'),('stud41',70.21,'SECOA141',3,1,'SE','CO','SECOA','stud41'),('stud42',58.56,'SECOA142',3,1,'SE','CO','SECOA','stud42'),('stud43',77.3,'SECOA143',3,1,'SE','CO','SECOA','stud43'),('stud44',73.41,'SECOA144',3,1,'SE','CO','SECOA','stud44'),('stud45',60.73,'SECOA145',3,1,'SE','CO','SECOA','stud45'),('stud46',60.44,'SECOA146',3,1,'SE','CO','SECOA','stud46'),('stud47',66.29,'SECOA147',3,1,'SE','CO','SECOA','stud47'),('stud48',96.17,'SECOA148',3,1,'SE','CO','SECOA','stud48'),('stud49',65.48,'SECOA149',3,1,'SE','CO','SECOA','stud49'),('stud50',84.01,'SECOA150',3,1,'SE','CO','SECOA','stud50'),('stud51',97.48,'SECOA151',3,1,'SE','CO','SECOA','stud51'),('stud52',78.46,'SECOA152',3,1,'SE','CO','SECOA','stud52'),('stud53',54.86,'SECOA153',3,1,'SE','CO','SECOA','stud53'),('stud54',81.66,'SECOA154',3,1,'SE','CO','SECOA','stud54'),('stud55',57.02,'SECOA155',3,1,'SE','CO','SECOA','stud55'),('stud56',92.98,'SECOA156',3,1,'SE','CO','SECOA','stud56'),('stud57',99,'SECOA157',3,1,'SE','CO','SECOA','stud57'),('stud58',89.22,'SECOA158',3,1,'SE','CO','SECOA','stud58'),('stud59',77.75,'SECOA159',3,1,'SE','CO','SECOA','stud59'),('stud60',51.85,'SECOA160',3,1,'SE','CO','SECOA','stud60'),('stud61',97.43,'SECOA161',3,1,'SE','CO','SECOA','stud61'),('stud62',60.02,'SECOA162',3,1,'SE','CO','SECOA','stud62'),('stud63',95.11,'SECOA163',3,1,'SE','CO','SECOA','stud63'),('stud64',51.55,'SECOA164',3,1,'SE','CO','SECOA','stud64'),('stud65',53.99,'SECOA165',3,1,'SE','CO','SECOA','stud65'),('stud66',65.61,'SECOA166',3,1,'SE','CO','SECOA','stud66'),('stud67',87.24,'SECOA167',3,1,'SE','CO','SECOA','stud67'),('stud68',80.08,'SECOA168',3,1,'SE','CO','SECOA','stud68'),('stud69',53.15,'SECOA169',3,1,'SE','CO','SECOA','stud69'),('stud70',73.74,'SECOA170',3,1,'SE','CO','SECOA','stud70'),('stud71',91.68,'SECOA171',3,1,'SE','CO','SECOA','stud71'),('stud72',64.73,'SECOA172',3,1,'SE','CO','SECOA','stud72'),('stud73',98.02,'SECOA173',3,1,'SE','CO','SECOA','stud73'),('stud74',87.8,'SECOA174',3,1,'SE','CO','SECOA','stud74'),('stud75',77.14,'SECOA175',3,1,'SE','CO','SECOA','stud75'),('stud76',60.5,'SECOA176',3,1,'SE','CO','SECOA','stud76'),('stud77',66.2,'SECOA177',3,1,'SE','CO','SECOA','stud77'),('stud78',67.55,'SECOA178',3,1,'SE','CO','SECOA','stud78'),('stud79',80.46,'SECOA179',3,1,'SE','CO','SECOA','stud79'),('stud80',71.7,'SECOA180',3,1,'SE','CO','SECOA','stud80');
/*!40000 ALTER TABLE `student_acad` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `student_alloc_course`
--
DROP TABLE IF EXISTS `student_alloc_course`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `student_alloc_course` (
`id` int(11) NOT NULL,
`batch_id` varchar(255) DEFAULT NULL,
`pref_no` int(11) DEFAULT NULL,
`course_id` varchar(255) DEFAULT NULL,
`elective_id` varchar(255) DEFAULT NULL,
`student` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKpcg57y2kv98ter16yje3dt9ag` (`course_id`),
KEY `FKftdm1fvamc3ln6hviuxpsn0o1` (`elective_id`),
KEY `FKe81v8tg4bbioqo70jkqs063ww` (`student`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `student_alloc_course`
--
LOCK TABLES `student_alloc_course` WRITE;
/*!40000 ALTER TABLE `student_alloc_course` DISABLE KEYS */;
INSERT INTO `student_alloc_course` VALUES (145,'ME2CO-610103D-1',-1,'610103','610103D','stud848'),(146,'ME2CO-610103D-1',-1,'610103','610103D','stud805'),(147,'ME2CO-610103D-1',-1,'610103','610103D','stud812'),(148,'ME2CO-610103D-1',-1,'610103','610103D','stud809'),(149,'ME2CO-610103A-1',-1,'610103','610103A','stud828'),(150,'ME2CO-610103A-1',-1,'610103','610103A','stud813'),(151,'ME2CO-610103D-1',-1,'610103','610103D','stud846'),(152,'ME2CO-610103A-1',-1,'610103','610103A','stud866'),(153,'ME2CO-610103A-1',-1,'610103','610103A','stud815'),(154,'ME2CO-610103A-1',-1,'610103','610103A','stud803'),(155,'ME2CO-610103D-1',-1,'610103','610103D','stud806'),(156,'ME2CO-610103A-1',-1,'610103','610103A','stud829'),(157,'ME2CO-610103A-1',-1,'610103','610103A','stud877'),(158,'ME2CO-610103A-1',-1,'610103','610103A','stud804'),(159,'ME2CO-610103A-1',-1,'610103','610103A','stud834'),(160,'ME2CO-610103D-1',-1,'610103','610103D','stud865'),(161,'ME2CO-610103D-1',-1,'610103','610103D','stud873'),(162,'ME2CO-610103A-1',-1,'610103','610103A','stud860'),(163,'ME2CO-610103A-1',-1,'610103','610103A','stud822'),(164,'ME2CO-610103A-1',-1,'610103','610103A','stud821'),(165,'ME2CO-610103A-1',-1,'610103','610103A','stud832'),(166,'ME2CO-610103A-1',-1,'610103','610103A','stud872'),(167,'ME2CO-610103A-1',-1,'610103','610103A','stud853'),(168,'ME2CO-610103A-1',-1,'610103','610103A','stud833'),(169,'ME2CO-610103D-1',-1,'610103','610103D','stud808'),(170,'ME2CO-610103D-1',-1,'610103','610103D','stud814'),(171,'ME2CO-610103A-1',-1,'610103','610103A','stud823'),(172,'ME2CO-610103A-1',-1,'610103','610103A','stud868'),(173,'ME2CO-610103A-1',-1,'610103','610103A','stud819'),(174,'ME2CO-610103D-1',-1,'610103','610103D','stud856'),(175,'ME2CO-610103D-1',-1,'610103','610103D','stud862'),(176,'ME2CO-610103D-1',-1,'610103','610103D','stud817'),(177,'ME2CO-610103A-1',-1,'610103','610103A','stud857'),(178,'ME2CO-610103A-1',-1,'610103','610103A','stud843'),(179,'ME2CO-610103D-1',-1,'610103','610103D','stud858'),(180,'ME2CO-610103D-1',-1,'610103','610103D','stud867'),(181,'ME2CO-610103D-1',-1,'610103','610103D','stud859'),(182,'ME2CO-610103A-1',-1,'610103','610103A','stud807'),(183,'ME2CO-610103D-1',-1,'610103','610103D','stud875'),(184,'ME2CO-610103D-1',-1,'610103','610103D','stud878'),(185,'ME2CO-610103D-1',-1,'610103','610103D','stud871'),(186,'ME2CO-610103A-1',-1,'610103','610103A','stud852'),(187,'ME2CO-610103A-1',-1,'610103','610103A','stud802'),(188,'ME2CO-610103A-1',-1,'610103','610103A','stud845'),(189,'ME2CO-610103D-1',-1,'610103','610103D','stud850'),(190,'ME2CO-610103D-1',-1,'610103','610103D','stud847'),(191,'ME2CO-610103D-1',-1,'610103','610103D','stud874'),(192,'ME2CO-610103A-1',-1,'610103','610103A','stud851'),(193,'ME2CO-610103D-1',-1,'610103','610103D','stud830'),(194,'ME2CO-610103A-1',-1,'610103','610103A','stud838'),(195,'ME2CO-610103A-1',-1,'610103','610103A','stud880'),(196,'ME2CO-610103D-1',-1,'610103','610103D','stud879'),(197,'ME2CO-610103A-1',-1,'610103','610103A','stud818'),(198,'ME2CO-610103A-1',-1,'610103','610103A','stud810'),(199,'ME2CO-610103D-1',-1,'610103','610103D','stud869'),(200,'ME2CO-610103A-1',-1,'610103','610103A','stud864'),(201,'ME2CO-610103A-1',-1,'610103','610103A','stud849'),(202,'ME2CO-610103A-1',-1,'610103','610103A','stud844'),(203,'ME2CO-610103D-1',-1,'610103','610103D','stud835'),(204,'ME2CO-610103D-1',-1,'610103','610103D','stud837'),(205,'ME2CO-610103D-1',-1,'610103','610103D','stud855'),(206,'ME2CO-610103D-1',-1,'610103','610103D','stud870'),(207,'ME2CO-610103A-1',-1,'610103','610103A','stud801'),(208,'ME2CO-610103A-1',-1,'610103','610103A','stud826'),(209,'ME2CO-610103D-1',-1,'610103','610103D','stud876'),(210,'ME2CO-610103D-1',-1,'610103','610103D','stud842'),(211,'ME2CO-610103A-1',-1,'610103','610103A','stud840'),(212,'ME2CO-610103D-1',-1,'610103','610103D','stud825'),(213,'ME2CO-610103D-1',-1,'610103','610103D','stud827'),(214,'ME2CO-610103D-1',-1,'610103','610103D','stud841'),(215,'ME2CO-610103A-1',-1,'610103','610103A','stud861'),(216,'ME2CO-610103D-1',-1,'610103','610103D','stud811'),(217,'ME2CO-610103D-1',-1,'610103','610103D','stud836'),(218,'ME2CO-610103D-1',-1,'610103','610103D','stud816'),(219,'ME2CO-610103D-1',-1,'610103','610103D','stud839'),(220,'ME2CO-610103A-1',-1,'610103','610103A','stud831'),(221,'ME2CO-610103A-1',-1,'610103','610103A','stud854'),(222,'ME2CO-610103D-1',-1,'610103','610103D','stud863'),(223,'ME2CO-610103A-1',-1,'610103','610103A','stud824'),(224,'ME2CO-610103D-1',-1,'610103','610103D','stud820'),(225,'ME1CO-510105D-1',4,'510105','510105D','stud743'),(226,'ME1CO-510105D-1',4,'510105','510105D','stud750'),(227,'ME1CO-510105B-1',2,'510105','510105B','stud744'),(228,'ME1CO-510105D-1',4,'510105','510105D','stud774'),(229,'ME1CO-510105B-1',2,'510105','510105B','stud781'),(230,'ME1CO-510105B-1',2,'510105','510105B','stud742'),(231,'ME1CO-510105B-1',2,'510105','510105B','stud777'),(232,'ME1CO-510105D-1',4,'510105','510105D','stud780'),(233,'ME1CO-510105D-1',4,'510105','510105D','stud722'),(234,'ME1CO-510105B-1',2,'510105','510105B','stud771'),(235,'ME1CO-510105D-1',4,'510105','510105D','stud772'),(236,'ME1CO-510105B-1',2,'510105','510105B','stud763'),(237,'ME1CO-510105D-1',4,'510105','510105D','stud730'),(238,'ME1CO-510105D-1',4,'510105','510105D','stud788'),(239,'ME1CO-510105B-1',2,'510105','510105B','stud755'),(240,'ME1CO-510105D-1',4,'510105','510105D','stud751'),(241,'ME1CO-510105B-1',2,'510105','510105B','stud773'),(242,'ME1CO-510105D-1',4,'510105','510105D','stud723'),(243,'ME1CO-510105D-1',4,'510105','510105D','stud753'),(244,'ME1CO-510105B-1',2,'510105','510105B','stud783'),(245,'ME1CO-510105B-1',2,'510105','510105B','stud756'),(246,'ME1CO-510105D-1',4,'510105','510105D','stud764'),(247,'ME1CO-510105D-1',4,'510105','510105D','stud793'),(248,'ME1CO-510105B-1',2,'510105','510105B','stud796'),(249,'ME1CO-510105D-1',4,'510105','510105D','stud776'),(250,'ME1CO-510105B-1',2,'510105','510105B','stud762'),(251,'ME1CO-510105D-1',4,'510105','510105D','stud740'),(252,'ME1CO-510105B-1',2,'510105','510105B','stud726'),(253,'ME1CO-510105D-1',4,'510105','510105D','stud758'),(254,'ME1CO-510105D-1',4,'510105','510105D','stud782'),(255,'ME1CO-510105B-1',2,'510105','510105B','stud786'),(256,'ME1CO-510105B-1',2,'510105','510105B','stud735'),(257,'ME1CO-510105B-1',2,'510105','510105B','stud727'),(258,'ME1CO-510105D-1',4,'510105','510105D','stud790'),(259,'ME1CO-510105B-1',2,'510105','510105B','stud736'),(260,'ME1CO-510105D-1',4,'510105','510105D','stud795'),(261,'ME1CO-510105B-1',2,'510105','510105B','stud749'),(262,'ME1CO-510105B-1',2,'510105','510105B','stud737'),(263,'ME1CO-510105B-1',2,'510105','510105B','stud778'),(264,'ME1CO-510105B-1',2,'510105','510105B','stud779'),(265,'ME1CO-510105B-1',2,'510105','510105B','stud741'),(266,'ME1CO-510105B-1',2,'510105','510105B','stud799'),(267,'ME1CO-510105D-1',4,'510105','510105D','stud785'),(268,'ME1CO-510105B-1',2,'510105','510105B','stud761'),(269,'ME1CO-510105B-1',2,'510105','510105B','stud787'),(270,'ME1CO-510105D-1',4,'510105','510105D','stud794'),(271,'ME1CO-510105D-1',4,'510105','510105D','stud729'),(272,'ME1CO-510105D-1',4,'510105','510105D','stud759'),(273,'ME1CO-510105D-1',4,'510105','510105D','stud748'),(274,'ME1CO-510105D-1',4,'510105','510105D','stud797'),(275,'ME1CO-510105B-1',2,'510105','510105B','stud745'),(276,'ME1CO-510105D-1',4,'510105','510105D','stud768'),(277,'ME1CO-510105D-1',4,'510105','510105D','stud739'),(278,'ME1CO-510105B-1',2,'510105','510105B','stud754'),(279,'ME1CO-510105B-1',2,'510105','510105B','stud725'),(280,'ME1CO-510105D-1',4,'510105','510105D','stud724'),(281,'ME1CO-510105D-1',4,'510105','510105D','stud728'),(282,'ME1CO-510105B-1',2,'510105','510105B','stud733'),(283,'ME1CO-510105D-1',4,'510105','510105D','stud784'),(284,'ME1CO-510105D-1',4,'510105','510105D','stud757'),(285,'ME1CO-510105D-1',4,'510105','510105D','stud789'),(286,'ME1CO-510105D-1',4,'510105','510105D','stud798'),(287,'ME1CO-510105B-1',2,'510105','510105B','stud770'),(288,'ME1CO-510105B-1',2,'510105','510105B','stud800'),(289,'ME1CO-510105D-1',4,'510105','510105D','stud746'),(290,'ME1CO-510105D-1',4,'510105','510105D','stud765'),(291,'ME1CO-510105B-1',2,'510105','510105B','stud775'),(292,'ME1CO-510105B-1',2,'510105','510105B','stud738'),(293,'ME1CO-510105D-1',4,'510105','510105D','stud769'),(294,'ME1CO-510105D-1',4,'510105','510105D','stud792'),(295,'ME1CO-510105B-1',2,'510105','510105B','stud732'),(296,'ME1CO-510105D-1',4,'510105','510105D','stud734'),(297,'ME1CO-510105D-1',4,'510105','510105D','stud752'),(298,'ME1CO-510105B-1',2,'510105','510105B','stud747'),(299,'ME1CO-510105B-1',2,'510105','510105B','stud791'),(300,'ME1CO-510105B-1',2,'510105','510105B','stud767'),(301,'ME1CO-510105D-1',4,'510105','510105D','stud721'),(302,'ME1CO-510105B-1',2,'510105','510105B','stud760'),(303,'ME1CO-510105B-1',2,'510105','510105B','stud766'),(304,'ME1CO-510105B-1',2,'510105','510105B','stud731'),(305,'BECO-410244B-1',2,'410244','410244B','stud589'),(306,'BECO-410244C-1',3,'410244','410244C','stud606'),(307,'BECO-410244C-1',3,'410244','410244C','stud679'),(308,'BECO-410244B-1',2,'410244','410244B','stud523'),(309,'BECO-410244D-1',4,'410244','410244D','stud628'),(310,'BECO-410244D-1',4,'410244','410244D','stud697'),(311,'BECO-410244B-1',2,'410244','410244B','stud495'),(312,'BECO-410244D-1',4,'410244','410244D','stud497'),(313,'BECO-410244B-1',2,'410244','410244B','stud634'),(314,'BECO-410244B-1',2,'410244','410244B','stud665'),(315,'BECO-410244B-1',2,'410244','410244B','stud688'),(316,'BECO-410244C-1',3,'410244','410244C','stud671'),(317,'BECO-410244D-1',4,'410244','410244D','stud483'),(318,'BECO-410244C-1',3,'410244','410244C','stud712'),(319,'BECO-410244D-1',4,'410244','410244D','stud620'),(320,'BECO-410244B-1',2,'410244','410244B','stud693'),(321,'BECO-410244D-1',4,'410244','410244D','stud651'),(322,'BECO-410244D-1',4,'410244','410244D','stud562'),(323,'BECO-410244C-1',3,'410244','410244C','stud500'),(324,'BECO-410244D-1',4,'410244','410244D','stud640'),(325,'BECO-410244D-1',4,'410244','410244D','stud704'),(326,'BECO-410244C-1',3,'410244','410244C','stud530'),(327,'BECO-410244B-1',2,'410244','410244B','stud552'),(328,'BECO-410244C-1',3,'410244','410244C','stud667'),(329,'BECO-410244C-1',3,'410244','410244C','stud707'),(330,'BECO-410244C-1',3,'410244','410244C','stud619'),(331,'BECO-410244D-1',4,'410244','410244D','stud681'),(332,'BECO-410244B-1',2,'410244','410244B','stud666'),(333,'BECO-410244C-1',3,'410244','410244C','stud570'),(334,'BECO-410244C-1',3,'410244','410244C','stud557'),(335,'BECO-410244D-1',4,'410244','410244D','stud510'),(336,'BECO-410244D-1',4,'410244','410244D','stud715'),(337,'BECO-410244D-1',4,'410244','410244D','stud700'),(338,'BECO-410244C-1',3,'410244','410244C','stud660'),(339,'BECO-410244C-1',3,'410244','410244C','stud513'),(340,'BECO-410244C-1',3,'410244','410244C','stud622'),(341,'BECO-410244B-1',2,'410244','410244B','stud646'),(342,'BECO-410244B-1',2,'410244','410244B','stud601'),(343,'BECO-410244D-1',4,'410244','410244D','stud626'),(344,'BECO-410244C-1',3,'410244','410244C','stud662'),(345,'BECO-410244C-1',3,'410244','410244C','stud652'),(346,'BECO-410244C-1',3,'410244','410244C','stud594'),(347,'BECO-410244C-1',3,'410244','410244C','stud567'),(348,'BECO-410244B-1',2,'410244','410244B','stud706'),(349,'BECO-410244D-1',4,'410244','410244D','stud542'),(350,'BECO-410244C-1',3,'410244','410244C','stud618'),(351,'BECO-410244D-1',4,'410244','410244D','stud551'),(352,'BECO-410244B-1',2,'410244','410244B','stud496'),(353,'BECO-410244B-1',2,'410244','410244B','stud588'),(354,'BECO-410244B-1',2,'410244','410244B','stud522'),(355,'BECO-410244B-1',2,'410244','410244B','stud625'),(356,'BECO-410244B-1',2,'410244','410244B','stud565'),(357,'BECO-410244C-1',3,'410244','410244C','stud520'),(358,'BECO-410244D-1',4,'410244','410244D','stud669'),(359,'BECO-410244B-1',2,'410244','410244B','stud677'),(360,'BECO-410244D-1',4,'410244','410244D','stud549'),(361,'BECO-410244B-1',2,'410244','410244B','stud623'),(362,'BECO-410244C-1',3,'410244','410244C','stud534'),(363,'BECO-410244D-1',4,'410244','410244D','stud516'),(364,'BECO-410244D-1',4,'410244','410244D','stud714'),(365,'BECO-410244C-1',3,'410244','410244C','stud650'),(366,'BECO-410244D-1',4,'410244','410244D','stud585'),(367,'BECO-410244B-1',2,'410244','410244B','stud659'),(368,'BECO-410244D-1',4,'410244','410244D','stud687'),(369,'BECO-410244C-1',3,'410244','410244C','stud512'),(370,'BECO-410244C-1',3,'410244','410244C','stud563'),(371,'BECO-410244C-1',3,'410244','410244C','stud511'),(372,'BECO-410244B-1',2,'410244','410244B','stud517'),(373,'BECO-410244C-1',3,'410244','410244C','stud705'),(374,'BECO-410244C-1',3,'410244','410244C','stud649'),(375,'BECO-410244D-1',4,'410244','410244D','stud615'),(376,'BECO-410244B-1',2,'410244','410244B','stud609'),(377,'BECO-410244B-1',2,'410244','410244B','stud494'),(378,'BECO-410244D-1',4,'410244','410244D','stud548'),(379,'BECO-410244D-1',4,'410244','410244D','stud661'),(380,'BECO-410244C-1',3,'410244','410244C','stud572'),(381,'BECO-410244B-1',2,'410244','410244B','stud491'),(382,'BECO-410244B-1',2,'410244','410244B','stud668'),(383,'BECO-410244D-1',4,'410244','410244D','stud683'),(384,'BECO-410244D-1',4,'410244','410244D','stud631'),(385,'BECO-410244B-1',2,'410244','410244B','stud685'),(386,'BECO-410244C-1',3,'410244','410244C','stud498'),(387,'BECO-410244D-1',4,'410244','410244D','stud716'),(388,'BECO-410244D-1',4,'410244','410244D','stud643'),(389,'BECO-410244B-1',2,'410244','410244B','stud608'),(390,'BECO-410244C-1',3,'410244','410244C','stud579'),(391,'BECO-410244D-1',4,'410244','410244D','stud709'),(392,'BECO-410244B-1',2,'410244','410244B','stud537'),(393,'BECO-410244C-1',3,'410244','410244C','stud617'),(394,'BECO-410244B-1',2,'410244','410244B','stud484'),(395,'BECO-410244B-1',2,'410244','410244B','stud605'),(396,'BECO-410244B-1',2,'410244','410244B','stud663'),(397,'BECO-410244B-1',2,'410244','410244B','stud593'),(398,'BECO-410244B-1',2,'410244','410244B','stud528'),(399,'BECO-410244B-1',2,'410244','410244B','stud547'),(400,'BECO-410244C-1',3,'410244','410244C','stud614'),(401,'BECO-410244C-1',3,'410244','410244C','stud518'),(402,'BECO-410244B-1',2,'410244','410244B','stud580'),(403,'BECO-410244C-1',3,'410244','410244C','stud695'),(404,'BECO-410244D-1',4,'410244','410244D','stud641'),(405,'BECO-410244C-1',3,'410244','410244C','stud524'),(406,'BECO-410244B-1',2,'410244','410244B','stud527'),(407,'BECO-410244D-1',4,'410244','410244D','stud610'),(408,'BECO-410244B-1',2,'410244','410244B','stud499'),(409,'BECO-410244C-1',3,'410244','410244C','stud603'),(410,'BECO-410244B-1',2,'410244','410244B','stud559'),(411,'BECO-410244C-1',3,'410244','410244C','stud718'),(412,'BECO-410244C-1',3,'410244','410244C','stud515'),(413,'BECO-410244D-1',4,'410244','410244D','stud490'),(414,'BECO-410244B-1',2,'410244','410244B','stud555'),(415,'BECO-410244D-1',4,'410244','410244D','stud538'),(416,'BECO-410244B-1',2,'410244','410244B','stud699'),(417,'BECO-410244B-1',2,'410244','410244B','stud664'),(418,'BECO-410244C-1',3,'410244','410244C','stud545'),(419,'BECO-410244B-1',2,'410244','410244B','stud560'),(420,'BECO-410244C-1',3,'410244','410244C','stud507'),(421,'BECO-410244D-1',4,'410244','410244D','stud576'),(422,'BECO-410244D-1',4,'410244','410244D','stud506'),(423,'BECO-410244D-1',4,'410244','410244D','stud596'),(424,'BECO-410244D-1',4,'410244','410244D','stud599'),(425,'BECO-410244C-1',3,'410244','410244C','stud690'),(426,'BECO-410244D-1',4,'410244','410244D','stud571'),(427,'BECO-410244D-1',4,'410244','410244D','stud613'),(428,'BECO-410244C-1',3,'410244','410244C','stud637'),(429,'BECO-410244B-1',2,'410244','410244B','stud536'),(430,'BECO-410244B-1',2,'410244','410244B','stud654'),(431,'BECO-410244B-1',2,'410244','410244B','stud632'),(432,'BECO-410244C-1',3,'410244','410244C','stud673'),(433,'BECO-410244B-1',2,'410244','410244B','stud539'),(434,'BECO-410244C-1',3,'410244','410244C','stud526'),(435,'BECO-410244C-1',3,'410244','410244C','stud586'),(436,'BECO-410244C-1',3,'410244','410244C','stud602'),(437,'BECO-410244C-1',3,'410244','410244C','stud481'),(438,'BECO-410244D-1',4,'410244','410244D','stud595'),(439,'BECO-410244B-1',2,'410244','410244B','stud514'),(440,'BECO-410244C-1',3,'410244','410244C','stud561'),(441,'BECO-410244C-1',3,'410244','410244C','stud531'),(442,'BECO-410244C-1',3,'410244','410244C','stud574'),(443,'BECO-410244D-1',4,'410244','410244D','stud656'),(444,'BECO-410244D-1',4,'410244','410244D','stud591'),(445,'BECO-410244C-1',3,'410244','410244C','stud487'),(446,'BECO-410244B-1',2,'410244','410244B','stud590'),(447,'BECO-410244C-1',3,'410244','410244C','stud691'),(448,'BECO-410244D-1',4,'410244','410244D','stud532'),(449,'BECO-410244C-1',3,'410244','410244C','stud676'),(450,'BECO-410244D-1',4,'410244','410244D','stud504'),(451,'BECO-410244D-1',4,'410244','410244D','stud501'),(452,'BECO-410244B-1',2,'410244','410244B','stud644'),(453,'BECO-410244B-1',2,'410244','410244B','stud508'),(454,'BECO-410244D-1',4,'410244','410244D','stud696'),(455,'BECO-410244C-1',3,'410244','410244C','stud692'),(456,'BECO-410244B-1',2,'410244','410244B','stud702'),(457,'BECO-410244C-1',3,'410244','410244C','stud489'),(458,'BECO-410244B-1',2,'410244','410244B','stud592'),(459,'BECO-410244C-1',3,'410244','410244C','stud633'),(460,'BECO-410244B-1',2,'410244','410244B','stud569'),(461,'BECO-410244C-1',3,'410244','410244C','stud648'),(462,'BECO-410244B-1',2,'410244','410244B','stud703'),(463,'BECO-410244C-1',3,'410244','410244C','stud553'),(464,'BECO-410244D-1',4,'410244','410244D','stud655'),(465,'BECO-410244D-1',4,'410244','410244D','stud686'),(466,'BECO-410244B-1',2,'410244','410244B','stud600'),(467,'BECO-410244B-1',2,'410244','410244B','stud616'),(468,'BECO-410244B-1',2,'410244','410244B','stud629'),(469,'BECO-410244D-1',4,'410244','410244D','stud535'),(470,'BECO-410244B-1',2,'410244','410244B','stud521'),(471,'BECO-410244C-1',3,'410244','410244C','stud482'),(472,'BECO-410244D-1',4,'410244','410244D','stud519'),(473,'BECO-410244D-1',4,'410244','410244D','stud635'),(474,'BECO-410244C-1',3,'410244','410244C','stud645'),(475,'BECO-410244D-1',4,'410244','410244D','stud674'),(476,'BECO-410244B-1',2,'410244','410244B','stud694'),(477,'BECO-410244C-1',3,'410244','410244C','stud488'),(478,'BECO-410244B-1',2,'410244','410244B','stud612'),(479,'BECO-410244C-1',3,'410244','410244C','stud584'),(480,'BECO-410244D-1',4,'410244','410244D','stud682'),(481,'BECO-410244D-1',4,'410244','410244D','stud658'),(482,'BECO-410244B-1',2,'410244','410244B','stud636'),(483,'BECO-410244B-1',2,'410244','410244B','stud624'),(484,'BECO-410244C-1',3,'410244','410244C','stud597'),(485,'BECO-410244D-1',4,'410244','410244D','stud642'),(486,'BECO-410244C-1',3,'410244','410244C','stud611'),(487,'BECO-410244D-1',4,'410244','410244D','stud639'),(488,'BECO-410244B-1',2,'410244','410244B','stud525'),(489,'BECO-410244B-1',2,'410244','410244B','stud583'),(490,'BECO-410244B-1',2,'410244','410244B','stud485'),(491,'BECO-410244B-1',2,'410244','410244B','stud486'),(492,'BECO-410244C-1',3,'410244','410244C','stud502'),(493,'BECO-410244D-1',4,'410244','410244D','stud647'),(494,'BECO-410244D-1',4,'410244','410244D','stud684'),(495,'BECO-410244B-1',2,'410244','410244B','stud670'),(496,'BECO-410244C-1',3,'410244','410244C','stud638'),(497,'BECO-410244B-1',2,'410244','410244B','stud630'),(498,'BECO-410244C-1',3,'410244','410244C','stud607'),(499,'BECO-410244D-1',4,'410244','410244D','stud698'),(500,'BECO-410244D-1',4,'410244','410244D','stud541'),(501,'BECO-410244C-1',3,'410244','410244C','stud582'),(502,'BECO-410244D-1',4,'410244','410244D','stud573'),(503,'BECO-410244C-1',3,'410244','410244C','stud505'),(504,'BECO-410244D-1',4,'410244','410244D','stud543'),(505,'BECO-410244B-1',2,'410244','410244B','stud503'),(506,'BECO-410244B-1',2,'410244','410244B','stud578'),(507,'BECO-410244D-1',4,'410244','410244D','stud566'),(508,'BECO-410244C-1',3,'410244','410244C','stud581'),(509,'BECO-410244B-1',2,'410244','410244B','stud564'),(510,'BECO-410244C-1',3,'410244','410244C','stud701'),(511,'BECO-410244C-1',3,'410244','410244C','stud672'),(512,'BECO-410244D-1',4,'410244','410244D','stud713'),(513,'BECO-410244B-1',2,'410244','410244B','stud708'),(514,'BECO-410244D-1',4,'410244','410244D','stud558'),(515,'BECO-410244D-1',4,'410244','410244D','stud598'),(516,'BECO-410244D-1',4,'410244','410244D','stud680'),(517,'BECO-410244B-1',2,'410244','410244B','stud550'),(518,'BECO-410244C-1',3,'410244','410244C','stud587'),(519,'BECO-410244C-1',3,'410244','410244C','stud719'),(520,'BECO-410244D-1',4,'410244','410244D','stud675'),(521,'BECO-410244D-1',4,'410244','410244D','stud575'),(522,'BECO-410244C-1',3,'410244','410244C','stud568'),(523,'BECO-410244B-1',2,'410244','410244B','stud546'),(524,'BECO-410244D-1',4,'410244','410244D','stud689'),(525,'BECO-410244D-1',4,'410244','410244D','stud653'),(526,'BECO-410244D-1',4,'410244','410244D','stud540'),(527,'BECO-410244C-1',3,'410244','410244C','stud710'),(528,'BECO-410244B-1',2,'410244','410244B','stud621'),(529,'BECO-410244B-1',2,'410244','410244B','stud717'),(530,'BECO-410244D-1',4,'410244','410244D','stud678'),(531,'BECO-410244B-1',2,'410244','410244B','stud720'),(532,'BECO-410244C-1',3,'410244','410244C','stud509'),(533,'BECO-410244D-1',4,'410244','410244D','stud492'),(534,'BECO-410244D-1',4,'410244','410244D','stud711'),(535,'BECO-410244B-1',2,'410244','410244B','stud554'),(536,'BECO-410244C-1',3,'410244','410244C','stud533'),(537,'BECO-410244D-1',4,'410244','410244D','stud657'),(538,'BECO-410244C-1',3,'410244','410244C','stud627'),(539,'BECO-410244D-1',4,'410244','410244D','stud544'),(540,'BECO-410244D-1',4,'410244','410244D','stud529'),(541,'BECO-410244C-1',3,'410244','410244C','stud556'),(542,'BECO-410244D-1',4,'410244','410244D','stud604'),(543,'BECO-410244B-1',2,'410244','410244B','stud493'),(544,'BECO-410244B-1',2,'410244','410244B','stud577'),(545,'BECO-410245B-1',2,'410245','410245B','stud486'),(546,'BECO-410245C-1',3,'410245','410245C','stud497'),(547,'BECO-410245C-1',3,'410245','410245C','stud639'),(548,'BECO-410245B-1',2,'410245','410245B','stud623'),(549,'BECO-410245B-1',2,'410245','410245B','stud602'),(550,'BECO-410245B-1',2,'410245','410245B','stud691'),(551,'BECO-410245C-1',3,'410245','410245C','stud591'),(552,'BECO-410245B-1',2,'410245','410245B','stud557'),(553,'BECO-410245C-1',3,'410245','410245C','stud631'),(554,'BECO-410245C-1',3,'410245','410245C','stud675'),(555,'BECO-410245C-1',3,'410245','410245C','stud571'),(556,'BECO-410245C-1',3,'410245','410245C','stud519'),(557,'BECO-410245B-1',2,'410245','410245B','stud568'),(558,'BECO-410245C-1',3,'410245','410245C','stud704'),(559,'BECO-410245B-1',2,'410245','410245B','stud636'),(560,'BECO-410245B-1',2,'410245','410245B','stud593'),(561,'BECO-410245C-1',3,'410245','410245C','stud647'),(562,'BECO-410245B-1',2,'410245','410245B','stud583'),(563,'BECO-410245C-1',3,'410245','410245C','stud541'),(564,'BECO-410245B-1',2,'410245','410245B','stud672'),(565,'BECO-410245B-1',2,'410245','410245B','stud580'),(566,'BECO-410245C-1',3,'410245','410245C','stud700'),(567,'BECO-410245B-1',2,'410245','410245B','stud498'),(568,'BECO-410245B-1',2,'410245','410245B','stud612'),(569,'BECO-410245B-1',2,'410245','410245B','stud664'),(570,'BECO-410245C-1',3,'410245','410245C','stud575'),(571,'BECO-410245B-1',2,'410245','410245B','stud589'),(572,'BECO-410245B-1',2,'410245','410245B','stud611'),(573,'BECO-410245C-1',3,'410245','410245C','stud595'),(574,'BECO-410245B-1',2,'410245','410245B','stud701'),(575,'BECO-410245B-1',2,'410245','410245B','stud590'),(576,'BECO-410245B-1',2,'410245','410245B','stud632'),(577,'BECO-410245B-1',2,'410245','410245B','stud597'),(578,'BECO-410245B-1',2,'410245','410245B','stud616'),(579,'BECO-410245B-1',2,'410245','410245B','stud601'),(580,'BECO-410245C-1',3,'410245','410245C','stud551'),(581,'BECO-410245C-1',3,'410245','410245C','stud540'),(582,'BECO-410245B-1',2,'410245','410245B','stud718'),(583,'BECO-410245B-1',2,'410245','410245B','stud666'),(584,'BECO-410245B-1',2,'410245','410245B','stud536'),(585,'BECO-410245B-1',2,'410245','410245B','stud621'),(586,'BECO-410245C-1',3,'410245','410245C','stud610'),(587,'BECO-410245B-1',2,'410245','410245B','stud547'),(588,'BECO-410245B-1',2,'410245','410245B','stud673'),(589,'BECO-410245B-1',2,'410245','410245B','stud614'),(590,'BECO-410245B-1',2,'410245','410245B','stud708'),(591,'BECO-410245C-1',3,'410245','410245C','stud669'),(592,'BECO-410245B-1',2,'410245','410245B','stud484'),(593,'BECO-410245B-1',2,'410245','410245B','stud648'),(594,'BECO-410245C-1',3,'410245','410245C','stud716'),(595,'BECO-410245B-1',2,'410245','410245B','stud659'),(596,'BECO-410245B-1',2,'410245','410245B','stud511'),(597,'BECO-410245B-1',2,'410245','410245B','stud645'),(598,'BECO-410245B-1',2,'410245','410245B','stud572'),(599,'BECO-410245B-1',2,'410245','410245B','stud652'),(600,'BECO-410245B-1',2,'410245','410245B','stud634'),(601,'BECO-410245B-1',2,'410245','410245B','stud618'),(602,'BECO-410245B-1',2,'410245','410245B','stud485'),(603,'BECO-410245B-1',2,'410245','410245B','stud560'),(604,'BECO-410245B-1',2,'410245','410245B','stud717'),(605,'BECO-410245C-1',3,'410245','410245C','stud640'),(606,'BECO-410245C-1',3,'410245','410245C','stud506'),(607,'BECO-410245C-1',3,'410245','410245C','stud641'),(608,'BECO-410245B-1',2,'410245','410245B','stud488'),(609,'BECO-410245B-1',2,'410245','410245B','stud594'),(610,'BECO-410245B-1',2,'410245','410245B','stud495'),(611,'BECO-410245C-1',3,'410245','410245C','stud501'),(612,'BECO-410245B-1',2,'410245','410245B','stud662'),(613,'BECO-410245B-1',2,'410245','410245B','stud563'),(614,'BECO-410245B-1',2,'410245','410245B','stud503'),(615,'BECO-410245B-1',2,'410245','410245B','stud694'),(616,'BECO-410245B-1',2,'410245','410245B','stud581'),(617,'BECO-410245C-1',3,'410245','410245C','stud711'),(618,'BECO-410245B-1',2,'410245','410245B','stud487'),(619,'BECO-410245B-1',2,'410245','410245B','stud574'),(620,'BECO-410245B-1',2,'410245','410245B','stud627'),(621,'BECO-410245B-1',2,'410245','410245B','stud578'),(622,'BECO-410245C-1',3,'410245','410245C','stud643'),(623,'BECO-410245C-1',3,'410245','410245C','stud535'),(624,'BECO-410245C-1',3,'410245','410245C','stud626'),(625,'BECO-410245B-1',2,'410245','410245B','stud677'),(626,'BECO-410245B-1',2,'410245','410245B','stud671'),(627,'BECO-410245C-1',3,'410245','410245C','stud661'),(628,'BECO-410245C-1',3,'410245','410245C','stud698'),(629,'BECO-410245C-1',3,'410245','410245C','stud655'),(630,'BECO-410245B-1',2,'410245','410245B','stud668'),(631,'BECO-410245B-1',2,'410245','410245B','stud502'),(632,'BECO-410245C-1',3,'410245','410245C','stud658'),(633,'BECO-410245B-1',2,'410245','410245B','stud508'),(634,'BECO-410245B-1',2,'410245','410245B','stud605'),(635,'BECO-410245B-1',2,'410245','410245B','stud607'),(636,'BECO-410245B-1',2,'410245','410245B','stud688'),(637,'BECO-410245B-1',2,'410245','410245B','stud584'),(638,'BECO-410245C-1',3,'410245','410245C','stud657'),(639,'BECO-410245C-1',3,'410245','410245C','stud596'),(640,'BECO-410245B-1',2,'410245','410245B','stud633'),(641,'BECO-410245B-1',2,'410245','410245B','stud555'),(642,'BECO-410245B-1',2,'410245','410245B','stud553'),(643,'BECO-410245B-1',2,'410245','410245B','stud499'),(644,'BECO-410245B-1',2,'410245','410245B','stud670'),(645,'BECO-410245C-1',3,'410245','410245C','stud651'),(646,'BECO-410245B-1',2,'410245','410245B','stud570'),(647,'BECO-410245B-1',2,'410245','410245B','stud559'),(648,'BECO-410245C-1',3,'410245','410245C','stud598'),(649,'BECO-410245C-1',3,'410245','410245C','stud549'),(650,'BECO-410245C-1',3,'410245','410245C','stud642'),(651,'BECO-410245C-1',3,'410245','410245C','stud678'),(652,'BECO-410245C-1',3,'410245','410245C','stud687'),(653,'BECO-410245B-1',2,'410245','410245B','stud719'),(654,'BECO-410245B-1',2,'410245','410245B','stud592'),(655,'BECO-410245B-1',2,'410245','410245B','stud606'),(656,'BECO-410245C-1',3,'410245','410245C','stud714'),(657,'BECO-410245B-1',2,'410245','410245B','stud622'),(658,'BECO-410245C-1',3,'410245','410245C','stud697'),(659,'BECO-410245B-1',2,'410245','410245B','stud644'),(660,'BECO-410245B-1',2,'410245','410245B','stud534'),(661,'BECO-410245B-1',2,'410245','410245B','stud518'),(662,'BECO-410245C-1',3,'410245','410245C','stud585'),(663,'BECO-410245C-1',3,'410245','410245C','stud573'),(664,'BECO-410245C-1',3,'410245','410245C','stud684'),(665,'BECO-410245B-1',2,'410245','410245B','stud609'),(666,'BECO-410245C-1',3,'410245','410245C','stud538'),(667,'BECO-410245B-1',2,'410245','410245B','stud617'),(668,'BECO-410245C-1',3,'410245','410245C','stud562'),(669,'BECO-410245B-1',2,'410245','410245B','stud521'),(670,'BECO-410245B-2',2,'410245','410245B','stud586'),(671,'BECO-410245B-2',2,'410245','410245B','stud561'),(672,'BECO-410245B-2',2,'410245','410245B','stud588'),(673,'BECO-410245B-2',2,'410245','410245B','stud706'),(674,'BECO-410245C-1',3,'410245','410245C','stud696'),(675,'BECO-410245B-2',2,'410245','410245B','stud676'),(676,'BECO-410245C-1',3,'410245','410245C','stud713'),(677,'BECO-410245B-2',2,'410245','410245B','stud665'),(678,'BECO-410245B-2',2,'410245','410245B','stud514'),(679,'BECO-410245C-1',3,'410245','410245C','stud543'),(680,'BECO-410245C-1',3,'410245','410245C','stud492'),(681,'BECO-410245B-2',2,'410245','410245B','stud685'),(682,'BECO-410245B-2',2,'410245','410245B','stud650'),(683,'BECO-410245B-2',2,'410245','410245B','stud531'),(684,'BECO-410245B-2',2,'410245','410245B','stud545'),(685,'BECO-410245B-2',2,'410245','410245B','stud493'),(686,'BECO-410245C-1',3,'410245','410245C','stud709'),(687,'BECO-410245B-2',2,'410245','410245B','stud703'),(688,'BECO-410245B-2',2,'410245','410245B','stud660'),(689,'BECO-410245B-2',2,'410245','410245B','stud637'),(690,'BECO-410245C-1',3,'410245','410245C','stud653'),(691,'BECO-410245B-2',2,'410245','410245B','stud619'),(692,'BECO-410245C-1',3,'410245','410245C','stud674'),(693,'BECO-410245C-1',3,'410245','410245C','stud510'),(694,'BECO-410245B-2',2,'410245','410245B','stud539'),(695,'BECO-410245B-2',2,'410245','410245B','stud630'),(696,'BECO-410245B-2',2,'410245','410245B','stud702'),(697,'BECO-410245B-2',2,'410245','410245B','stud667'),(698,'BECO-410245B-2',2,'410245','410245B','stud520'),(699,'BECO-410245B-2',2,'410245','410245B','stud690'),(700,'BECO-410245C-1',3,'410245','410245C','stud544'),(701,'BECO-410245B-2',2,'410245','410245B','stud710'),(702,'BECO-410245B-2',2,'410245','410245B','stud577'),(703,'BECO-410245C-1',3,'410245','410245C','stud635'),(704,'BECO-410245B-2',2,'410245','410245B','stud494'),(705,'BECO-410245B-2',2,'410245','410245B','stud552'),(706,'BECO-410245C-1',3,'410245','410245C','stud490'),(707,'BECO-410245C-1',3,'410245','410245C','stud681'),(708,'BECO-410245B-2',2,'410245','410245B','stud524'),(709,'BECO-410245B-2',2,'410245','410245B','stud491'),(710,'BECO-410245C-1',3,'410245','410245C','stud680'),(711,'BECO-410245C-1',3,'410245','410245C','stud542'),(712,'BECO-410245B-2',2,'410245','410245B','stud500'),(713,'BECO-410245C-1',3,'410245','410245C','stud483'),(714,'BECO-410245B-2',2,'410245','410245B','stud525'),(715,'BECO-410245B-2',2,'410245','410245B','stud564'),(716,'BECO-410245C-1',3,'410245','410245C','stud628'),(717,'BECO-410245C-1',3,'410245','410245C','stud599'),(718,'BECO-410245B-2',2,'410245','410245B','stud515'),(719,'BECO-410245B-2',2,'410245','410245B','stud705'),(720,'BECO-410245B-2',2,'410245','410245B','stud603'),(721,'BECO-410245B-2',2,'410245','410245B','stud526'),(722,'BECO-410245B-2',2,'410245','410245B','stud699'),(723,'BECO-410245B-2',2,'410245','410245B','stud600'),(724,'BECO-410245B-2',2,'410245','410245B','stud693'),(725,'BECO-410245B-2',2,'410245','410245B','stud496'),(726,'BECO-410245B-2',2,'410245','410245B','stud712'),(727,'BECO-410245C-1',3,'410245','410245C','stud516'),(728,'BECO-410245B-2',2,'410245','410245B','stud513'),(729,'BECO-410245C-1',3,'410245','410245C','stud576'),(730,'BECO-410245B-2',2,'410245','410245B','stud522'),(731,'BECO-410245C-1',3,'410245','410245C','stud613'),(732,'BECO-410245B-2',2,'410245','410245B','stud530'),(733,'BECO-410245C-1',3,'410245','410245C','stud529'),(734,'BECO-410245B-2',2,'410245','410245B','stud509'),(735,'BECO-410245B-2',2,'410245','410245B','stud505'),(736,'BECO-410245B-2',2,'410245','410245B','stud582'),(737,'BECO-410245B-2',2,'410245','410245B','stud554'),(738,'BECO-410245B-2',2,'410245','410245B','stud550'),(739,'BECO-410245B-2',2,'410245','410245B','stud624'),(740,'BECO-410245B-2',2,'410245','410245B','stud481'),(741,'BECO-410245B-2',2,'410245','410245B','stud679'),(742,'BECO-410245C-1',3,'410245','410245C','stud656'),(743,'BECO-410245B-2',2,'410245','410245B','stud528'),(744,'BECO-410245B-2',2,'410245','410245B','stud654'),(745,'BECO-410245B-2',2,'410245','410245B','stud565'),(746,'BECO-410245C-1',3,'410245','410245C','stud682'),(747,'BECO-410245C-1',3,'410245','410245C','stud548'),(748,'BECO-410245C-1',3,'410245','410245C','stud620'),(749,'BECO-410245B-2',2,'410245','410245B','stud546'),(750,'BECO-410245B-2',2,'410245','410245B','stud482'),(751,'BECO-410245B-2',2,'410245','410245B','stud695'),(752,'BECO-410245B-2',2,'410245','410245B','stud608'),(753,'BECO-410245B-2',2,'410245','410245B','stud629'),(754,'BECO-410245B-2',2,'410245','410245B','stud663'),(755,'BECO-410245B-2',2,'410245','410245B','stud625'),(756,'BECO-410245B-2',2,'410245','410245B','stud707'),(757,'BECO-410245B-2',2,'410245','410245B','stud489'),(758,'BECO-410245B-2',2,'410245','410245B','stud507'),(759,'BECO-410245B-2',2,'410245','410245B','stud646'),(760,'BECO-410245B-2',2,'410245','410245B','stud533'),(761,'BECO-410245B-2',2,'410245','410245B','stud556'),(762,'BECO-410245C-1',3,'410245','410245C','stud566'),(763,'BECO-410245C-1',3,'410245','410245C','stud532'),(764,'BECO-410245B-2',2,'410245','410245B','stud587'),(765,'BECO-410245C-1',3,'410245','410245C','stud686'),(766,'BECO-410245B-2',2,'410245','410245B','stud638'),(767,'BECO-410245C-1',3,'410245','410245C','stud689'),(768,'BECO-410245B-2',2,'410245','410245B','stud649'),(769,'BECO-410245B-2',2,'410245','410245B','stud720'),(770,'BECO-410245C-1',3,'410245','410245C','stud558'),(771,'BECO-410245B-2',2,'410245','410245B','stud692'),(772,'BECO-410245B-2',2,'410245','410245B','stud527'),(773,'BECO-410245B-2',2,'410245','410245B','stud512'),(774,'BECO-410245C-1',3,'410245','410245C','stud615'),(775,'BECO-410245C-1',3,'410245','410245C','stud604'),(776,'BECO-410245C-1',3,'410245','410245C','stud715'),(777,'BECO-410245B-2',2,'410245','410245B','stud569'),(778,'BECO-410245C-1',3,'410245','410245C','stud683'),(779,'BECO-410245B-2',2,'410245','410245B','stud567'),(780,'BECO-410245B-2',2,'410245','410245B','stud537'),(781,'BECO-410245B-2',2,'410245','410245B','stud579'),(782,'BECO-410245B-2',2,'410245','410245B','stud517'),(783,'BECO-410245C-1',3,'410245','410245C','stud504'),(784,'BECO-410245B-2',2,'410245','410245B','stud523');
/*!40000 ALTER TABLE `student_alloc_course` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `student_elective_vacancy_pref_counts`
--
DROP TABLE IF EXISTS `student_elective_vacancy_pref_counts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `student_elective_vacancy_pref_counts` (
`elective_id` varchar(255) NOT NULL,
`course_id` varchar(255) DEFAULT NULL,
`pref_count` int(11) DEFAULT NULL,
`vacancy_count` int(11) DEFAULT NULL,
PRIMARY KEY (`elective_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `student_elective_vacancy_pref_counts`
--
LOCK TABLES `student_elective_vacancy_pref_counts` WRITE;
/*!40000 ALTER TABLE `student_elective_vacancy_pref_counts` DISABLE KEYS */;
/*!40000 ALTER TABLE `student_elective_vacancy_pref_counts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `student_pref`
--
DROP TABLE IF EXISTS `student_pref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `student_pref` (
`id` int(11) NOT NULL,
`course_id` varchar(255) DEFAULT NULL,
`pref_no` int(11) DEFAULT NULL,
`user_name` varchar(255) DEFAULT NULL,
`el_pref` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKtfyrubvpucu6wo8wild2mc7ij` (`el_pref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `student_pref`
--
LOCK TABLES `student_pref` WRITE;
/*!40000 ALTER TABLE `student_pref` DISABLE KEYS */;
/*!40000 ALTER TABLE `student_pref` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `time_slots`
--
DROP TABLE IF EXISTS `time_slots`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `time_slots` (
`tid` int(11) NOT NULL,
`activity_name` varchar(255) DEFAULT NULL,
`date` date DEFAULT NULL,
`end_time` time DEFAULT NULL,
`request_id` int(11) DEFAULT NULL,
`start_time` time DEFAULT NULL,
`resource_id` varchar(255) DEFAULT NULL,
`slot_incharge` varchar(255) DEFAULT NULL,
PRIMARY KEY (`tid`),
KEY `FK3gqhxi08xukt08gdj65dwpk5c` (`resource_id`),
KEY `FK6aso216n7jgobbpmh2jh2klcs` (`slot_incharge`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `time_slots`
--
LOCK TABLES `time_slots` WRITE;
/*!40000 ALTER TABLE `time_slots` DISABLE KEYS */;
/*!40000 ALTER TABLE `time_slots` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `time_table`
--
DROP TABLE IF EXISTS `time_table`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `time_table` (
`tid` int(11) NOT NULL,
`activity_name` varchar(255) DEFAULT NULL,
`day` varchar(255) DEFAULT NULL,
`end_time` time DEFAULT NULL,
`start_time` time DEFAULT NULL,
`dept` varchar(255) DEFAULT NULL,
`resource_id` varchar(255) DEFAULT NULL,
`slot_incharge` varchar(255) DEFAULT NULL,
PRIMARY KEY (`tid`),
KEY `FK2y0nyajab5kvheuu8i9n9rib7` (`dept`),
KEY `FKrvol3ayrcy3w83i4mj7bi3lrt` (`resource_id`),
KEY `FKqwm7r1p5t9p0lo2x3lm0mpcd8` (`slot_incharge`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `time_table`
--
LOCK TABLES `time_table` WRITE;
/*!40000 ALTER TABLE `time_table` DISABLE KEYS */;
/*!40000 ALTER TABLE `time_table` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user`
--
DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
`user_name` varchar(255) NOT NULL,
`active` int(11) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`first_name` varchar(255) DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
PRIMARY KEY (`user_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user`
--
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES ('admin',1,'adminpccoe@gmail.com','Admin','Admin','admin'),('fac1',1,'fac1@gmail.com','Rajeswari','Kannan','faculty'),('fac2',1,'fac2@gmail.com','Anuradha','Thakare','faculty'),('fac3',1,'fac351@gmail.com','Swati','Shinde','faculty'),('fac4',1,'fac4@gmail.com','Anagha','Chaudhari','faculty'),('fac5',1,'fac5@gmail.com','Janhavi','Gudsoorkar','faculty'),('fac6',1,'fac6@gmail.com','Govinda','Sambare','faculty'),('fac7',1,'fac7@gmail.com','Reena','Kharat','faculty'),('fac8',1,'fac8@gmail.com','Sonal','Gore','faculty'),('fac9',1,'fac9@gmail.com','Mahalakshmi','Bodireddy','faculty'),('fac10',1,'fac10@gmail.com','Sushma','Vispute','faculty'),('fac11',1,'fac11@gmail.com','Shailaja','Pede','faculty'),('fac12',1,'fac12@gmail.com','Anand','Birajdar','faculty'),('fac13',1,'fac13@gmail.com','Rahul','Patil','faculty'),('fac14',1,'fac14@gmail.com','Priya','Surana','faculty'),('fac15',1,'fac15@gmail.com','Alka','Londhe','faculty'),('fac16',1,'fac16@gmail.com','Harshada','Mhaske','faculty'),('fac17',1,'fac17@gmail.com','Atul','Pawar','faculty'),('fac18',1,'fac18@gmail.com','Shrikant','Kokate','faculty'),('fac19',1,'fac19@gmail.com','Shailesh','Hule','faculty'),('fac20',1,'fac20@gmail.com','Santwana','Gudadhe','faculty'),('fac21',1,'fac21@gmail.com','Pallavi','Dhade','faculty'),('fac22',1,'fac22@gmail.com','Rahul','Pitale','faculty'),('fac23',1,'fac23@gmail.com','Sagar','Salunke','faculty'),('fac24',1,'fac24@gmail.com','Rajesh','Lomte','faculty'),('fac25',1,'fac25@gmail.com','Kapil','Tajane','faculty'),('fac26',1,'fac26@gmail.com','Namrata','Gawande','faculty'),('fac27',1,'fac27@gmail.com','Meghana','Lokhande','faculty'),('fac28',1,'fac28@gmail.com','Archana','Kadam','faculty'),('fac29',1,'fac29@gmail.com','Smita','Khairnar','faculty'),('fac30',1,'fac30@gmail.com','Ketan','Desale','faculty'),('fac31',1,'fac31@gmail.com','Madhura','Kalbhor','faculty'),('fac32',1,'fac32@gmail.com','Swati','Chandurkar','faculty'),('fac34',1,'fac34@gmail.com','Sudeep','Thepade','faculty'),('fac35',1,'fac35@gmail.com','Deepa','Abin','faculty'),('fac36',1,'fac36@gmail.com','Ganesh','Deshmukh','faculty'),('stud1',1,'stud1@gmail.com','Student1','Student1','student'),('stud2',1,'stud2@gmail.com','Student2','Student2','student'),('stud3',1,'stud3@gmail.com','Student3','Student3','student'),('stud4',1,'stud4@gmail.com','Student4','Student4','student'),('stud5',1,'stud5@gmail.com','Student5','Student5','student'),('stud6',1,'stud6@gmail.com','Student6','Student6','student'),('stud7',1,'stud7@gmail.com','Student7','Student7','student'),('stud8',1,'stud8@gmail.com','Student8','Student8','student'),('stud9',1,'stud9@gmail.com','Student9','Student9','student'),('stud10',1,'stud10@gmail.com','Student10','Student10','student'),('stud11',1,'stud11@gmail.com','Student11','Student11','student'),('stud12',1,'stud12@gmail.com','Student12','Student12','student'),('stud13',1,'stud13@gmail.com','Student13','Student13','student'),('stud14',1,'stud14@gmail.com','Student14','Student14','student'),('stud15',1,'stud15@gmail.com','Student15','Student15','student'),('stud16',1,'stud16@gmail.com','Student16','Student16','student'),('stud17',1,'stud17@gmail.com','Student17','Student17','student'),('stud18',1,'stud18@gmail.com','Student18','Student18','student'),('stud19',1,'stud19@gmail.com','Student19','Student19','student'),('stud20',1,'stud20@gmail.com','Student20','Student20','student'),('stud21',1,'stud21@gmail.com','Student21','Student21','student'),('stud22',1,'stud22@gmail.com','Student22','Student22','student'),('stud23',1,'stud23@gmail.com','Student23','Student23','student'),('stud24',1,'stud24@gmail.com','Student24','Student24','student'),('stud25',1,'stud25@gmail.com','Student25','Student25','student'),('stud26',1,'stud26@gmail.com','Student26','Student26','student'),('stud27',1,'stud27@gmail.com','Student27','Student27','student'),('stud28',1,'stud28@gmail.com','Student28','Student28','student'),('stud29',1,'stud29@gmail.com','Student29','Student29','student'),('stud30',1,'stud30@gmail.com','Student30','Student30','student'),('stud31',1,'stud31@gmail.com','Student31','Student31','student'),('stud32',1,'stud32@gmail.com','Student32','Student32','student'),('stud33',1,'stud33@gmail.com','Student33','Student33','student'),('stud34',1,'stud34@gmail.com','Student34','Student34','student'),('stud35',1,'stud35@gmail.com','Student35','Student35','student'),('stud36',1,'stud36@gmail.com','Student36','Student36','student'),('stud37',1,'stud37@gmail.com','Student37','Student37','student'),('stud38',1,'stud38@gmail.com','Student38','Student38','student'),('stud39',1,'stud39@gmail.com','Student39','Student39','student'),('stud40',1,'stud40@gmail.com','Student40','Student40','student'),('stud41',1,'stud41@gmail.com','Student41','Student41','student'),('stud42',1,'stud42@gmail.com','Student42','Student42','student'),('stud43',1,'stud43@gmail.com','Student43','Student43','student'),('stud44',1,'stud44@gmail.com','Student44','Student44','student'),('stud45',1,'stud45@gmail.com','Student45','Student45','student'),('stud46',1,'stud46@gmail.com','Student46','Student46','student'),('stud47',1,'stud47@gmail.com','Student47','Student47','student'),('stud48',1,'stud48@gmail.com','Student48','Student48','student'),('stud49',1,'stud49@gmail.com','Student49','Student49','student'),('stud50',1,'stud50@gmail.com','Student50','Student50','student'),('stud51',1,'stud51@gmail.com','Student51','Student51','student'),('stud52',1,'stud52@gmail.com','Student52','Student52','student'),('stud53',1,'stud53@gmail.com','Student53','Student53','student'),('stud54',1,'stud54@gmail.com','Student54','Student54','student'),('stud55',1,'stud55@gmail.com','Student55','Student55','student'),('stud56',1,'stud56@gmail.com','Student56','Student56','student'),('stud57',1,'stud57@gmail.com','Student57','Student57','student'),('stud58',1,'stud58@gmail.com','Student58','Student58','student'),('stud59',1,'stud59@gmail.com','Student59','Student59','student'),('stud60',1,'stud60@gmail.com','Student60','Student60','student'),('stud61',1,'stud61@gmail.com','Student61','Student61','student'),('stud62',1,'stud62@gmail.com','Student62','Student62','student'),('stud63',1,'stud63@gmail.com','Student63','Student63','student'),('stud64',1,'stud64@gmail.com','Student64','Student64','student'),('stud65',1,'stud65@gmail.com','Student65','Student65','student'),('stud66',1,'stud66@gmail.com','Student66','Student66','student'),('stud67',1,'stud67@gmail.com','Student67','Student67','student'),('stud68',1,'stud68@gmail.com','Student68','Student68','student'),('stud69',1,'stud69@gmail.com','Student69','Student69','student'),('stud70',1,'stud70@gmail.com','Student70','Student70','student'),('stud71',1,'stud71@gmail.com','Student71','Student71','student'),('stud72',1,'stud72@gmail.com','Student72','Student72','student'),('stud73',1,'stud73@gmail.com','Student73','Student73','student'),('stud74',1,'stud74@gmail.com','Student74','Student74','student'),('stud75',1,'stud75@gmail.com','Student75','Student75','student'),('stud76',1,'stud76@gmail.com','Student76','Student76','student'),('stud77',1,'stud77@gmail.com','Student77','Student77','student'),('stud78',1,'stud78@gmail.com','Student78','Student78','student'),('stud79',1,'stud79@gmail.com','Student79','Student79','student'),('stud80',1,'stud80@gmail.com','Student80','Student80','student'),('stud81',1,'stud81@gmail.com','Student81','Student81','student'),('stud82',1,'stud82@gmail.com','Student82','Student82','student'),('stud83',1,'stud83@gmail.com','Student83','Student83','student'),('stud84',1,'stud84@gmail.com','Student84','Student84','student'),('stud85',1,'stud85@gmail.com','Student85','Student85','student'),('stud86',1,'stud86@gmail.com','Student86','Student86','student'),('stud87',1,'stud87@gmail.com','Student87','Student87','student'),('stud88',1,'stud88@gmail.com','Student88','Student88','student'),('stud89',1,'stud89@gmail.com','Student89','Student89','student'),('stud90',1,'stud90@gmail.com','Student90','Student90','student'),('stud91',1,'stud91@gmail.com','Student91','Student91','student'),('stud92',1,'stud92@gmail.com','Student92','Student92','student'),('stud93',1,'stud93@gmail.com','Student93','Student93','student'),('stud94',1,'stud94@gmail.com','Student94','Student94','student'),('stud95',1,'stud95@gmail.com','Student95','Student95','student'),('stud96',1,'stud96@gmail.com','Student96','Student96','student'),('stud97',1,'stud97@gmail.com','Student97','Student97','student'),('stud98',1,'stud98@gmail.com','Student98','Student98','student'),('stud99',1,'stud99@gmail.com','Student99','Student99','student'),('stud100',1,'stud100@gmail.com','Student100','Student100','student'),('stud101',1,'stud101@gmail.com','Student101','Student101','student'),('stud102',1,'stud102@gmail.com','Student102','Student102','student'),('stud103',1,'stud103@gmail.com','Student103','Student103','student'),('stud104',1,'stud104@gmail.com','Student104','Student104','student'),('stud105',1,'stud105@gmail.com','Student105','Student105','student'),('stud106',1,'stud106@gmail.com','Student106','Student106','student'),('stud107',1,'stud107@gmail.com','Student107','Student107','student'),('stud108',1,'stud108@gmail.com','Student108','Student108','student'),('stud109',1,'stud109@gmail.com','Student109','Student109','student'),('stud110',1,'stud110@gmail.com','Student110','Student110','student'),('stud111',1,'stud111@gmail.com','Student111','Student111','student'),('stud112',1,'stud112@gmail.com','Student112','Student112','student'),('stud113',1,'stud113@gmail.com','Student113','Student113','student'),('stud114',1,'stud114@gmail.com','Student114','Student114','student'),('stud115',1,'stud115@gmail.com','Student115','Student115','student'),('stud116',1,'stud116@gmail.com','Student116','Student116','student'),('stud117',1,'stud117@gmail.com','Student117','Student117','student'),('stud118',1,'stud118@gmail.com','Student118','Student118','student'),('stud119',1,'stud119@gmail.com','Student119','Student119','student'),('stud120',1,'stud120@gmail.com','Student120','Student120','student'),('stud121',1,'stud121@gmail.com','Student121','Student121','student'),('stud122',1,'stud122@gmail.com','Student122','Student122','student'),('stud123',1,'stud123@gmail.com','Student123','Student123','student'),('stud124',1,'stud124@gmail.com','Student124','Student124','student'),('stud125',1,'stud125@gmail.com','Student125','Student125','student'),('stud126',1,'stud126@gmail.com','Student126','Student126','student'),('stud127',1,'stud127@gmail.com','Student127','Student127','student'),('stud128',1,'stud128@gmail.com','Student128','Student128','student'),('stud129',1,'stud129@gmail.com','Student129','Student129','student'),('stud130',1,'stud130@gmail.com','Student130','Student130','student'),('stud131',1,'stud131@gmail.com','Student131','Student131','student'),('stud132',1,'stud132@gmail.com','Student132','Student132','student'),('stud133',1,'stud133@gmail.com','Student133','Student133','student'),('stud134',1,'stud134@gmail.com','Student134','Student134','student'),('stud135',1,'stud135@gmail.com','Student135','Student135','student'),('stud136',1,'stud136@gmail.com','Student136','Student136','student'),('stud137',1,'stud137@gmail.com','Student137','Student137','student'),('stud138',1,'stud138@gmail.com','Student138','Student138','student'),('stud139',1,'stud139@gmail.com','Student139','Student139','student'),('stud140',1,'stud140@gmail.com','Student140','Student140','student'),('stud141',1,'stud141@gmail.com','Student141','Student141','student'),('stud142',1,'stud142@gmail.com','Student142','Student142','student'),('stud143',1,'stud143@gmail.com','Student143','Student143','student'),('stud144',1,'stud144@gmail.com','Student144','Student144','student'),('stud145',1,'stud145@gmail.com','Student145','Student145','student'),('stud146',1,'stud146@gmail.com','Student146','Student146','student'),('stud147',1,'stud147@gmail.com','Student147','Student147','student'),('stud148',1,'stud148@gmail.com','Student148','Student148','student'),('stud149',1,'stud149@gmail.com','Student149','Student149','student'),('stud150',1,'stud150@gmail.com','Student150','Student150','student'),('stud151',1,'stud151@gmail.com','Student151','Student151','student'),('stud152',1,'stud152@gmail.com','Student152','Student152','student'),('stud153',1,'stud153@gmail.com','Student153','Student153','student'),('stud154',1,'stud154@gmail.com','Student154','Student154','student'),('stud155',1,'stud155@gmail.com','Student155','Student155','student'),('stud156',1,'stud156@gmail.com','Student156','Student156','student'),('stud157',1,'stud157@gmail.com','Student157','Student157','student'),('stud158',1,'stud158@gmail.com','Student158','Student158','student'),('stud159',1,'stud159@gmail.com','Student159','Student159','student'),('stud160',1,'stud160@gmail.com','Student160','Student160','student'),('stud161',1,'stud161@gmail.com','Student161','Student161','student'),('stud162',1,'stud162@gmail.com','Student162','Student162','student'),('stud163',1,'stud163@gmail.com','Student163','Student163','student'),('stud164',1,'stud164@gmail.com','Student164','Student164','student'),('stud165',1,'stud165@gmail.com','Student165','Student165','student'),('stud166',1,'stud166@gmail.com','Student166','Student166','student'),('stud167',1,'stud167@gmail.com','Student167','Student167','student'),('stud168',1,'stud168@gmail.com','Student168','Student168','student'),('stud169',1,'stud169@gmail.com','Student169','Student169','student'),('stud170',1,'stud170@gmail.com','Student170','Student170','student'),('stud171',1,'stud171@gmail.com','Student171','Student171','student'),('stud172',1,'stud172@gmail.com','Student172','Student172','student'),('stud173',1,'stud173@gmail.com','Student173','Student173','student'),('stud174',1,'stud174@gmail.com','Student174','Student174','student'),('stud175',1,'stud175@gmail.com','Student175','Student175','student'),('stud176',1,'stud176@gmail.com','Student176','Student176','student'),('stud177',1,'stud177@gmail.com','Student177','Student177','student'),('stud178',1,'stud178@gmail.com','Student178','Student178','student'),('stud179',1,'stud179@gmail.com','Student179','Student179','student'),('stud180',1,'stud180@gmail.com','Student180','Student180','student'),('stud181',1,'stud181@gmail.com','Student181','Student181','student'),('stud182',1,'stud182@gmail.com','Student182','Student182','student'),('stud183',1,'stud183@gmail.com','Student183','Student183','student'),('stud184',1,'stud184@gmail.com','Student184','Student184','student'),('stud185',1,'stud185@gmail.com','Student185','Student185','student'),('stud186',1,'stud186@gmail.com','Student186','Student186','student'),('stud187',1,'stud187@gmail.com','Student187','Student187','student'),('stud188',1,'stud188@gmail.com','Student188','Student188','student'),('stud189',1,'stud189@gmail.com','Student189','Student189','student'),('stud190',1,'stud190@gmail.com','Student190','Student190','student'),('stud191',1,'stud191@gmail.com','Student191','Student191','student'),('stud192',1,'stud192@gmail.com','Student192','Student192','student'),('stud193',1,'stud193@gmail.com','Student193','Student193','student'),('stud194',1,'stud194@gmail.com','Student194','Student194','student'),('stud195',1,'stud195@gmail.com','Student195','Student195','student'),('stud196',1,'stud196@gmail.com','Student196','Student196','student'),('stud197',1,'stud197@gmail.com','Student197','Student197','student'),('stud198',1,'stud198@gmail.com','Student198','Student198','student'),('stud199',1,'stud199@gmail.com','Student199','Student199','student'),('stud200',1,'stud200@gmail.com','Student200','Student200','student'),('stud201',1,'stud201@gmail.com','Student201','Student201','student'),('stud202',1,'stud202@gmail.com','Student202','Student202','student'),('stud203',1,'stud203@gmail.com','Student203','Student203','student'),('stud204',1,'stud204@gmail.com','Student204','Student204','student'),('stud205',1,'stud205@gmail.com','Student205','Student205','student'),('stud206',1,'stud206@gmail.com','Student206','Student206','student'),('stud207',1,'stud207@gmail.com','Student207','Student207','student'),('stud208',1,'stud208@gmail.com','Student208','Student208','student'),('stud209',1,'stud209@gmail.com','Student209','Student209','student'),('stud210',1,'stud210@gmail.com','Student210','Student210','student'),('stud211',1,'stud211@gmail.com','Student211','Student211','student'),('stud212',1,'stud212@gmail.com','Student212','Student212','student'),('stud213',1,'stud213@gmail.com','Student213','Student213','student'),('stud214',1,'stud214@gmail.com','Student214','Student214','student'),('stud215',1,'stud215@gmail.com','Student215','Student215','student'),('stud216',1,'stud216@gmail.com','Student216','Student216','student'),('stud217',1,'stud217@gmail.com','Student217','Student217','student'),('stud218',1,'stud218@gmail.com','Student218','Student218','student'),('stud219',1,'stud219@gmail.com','Student219','Student219','student'),('stud220',1,'stud220@gmail.com','Student220','Student220','student'),('stud221',1,'stud221@gmail.com','Student221','Student221','student'),('stud222',1,'stud222@gmail.com','Student222','Student222','student'),('stud223',1,'stud223@gmail.com','Student223','Student223','student'),('stud224',1,'stud224@gmail.com','Student224','Student224','student'),('stud225',1,'stud225@gmail.com','Student225','Student225','student'),('stud226',1,'stud226@gmail.com','Student226','Student226','student'),('stud227',1,'stud227@gmail.com','Student227','Student227','student'),('stud228',1,'stud228@gmail.com','Student228','Student228','student'),('stud229',1,'stud229@gmail.com','Student229','Student229','student'),('stud230',1,'stud230@gmail.com','Student230','Student230','student'),('stud231',1,'stud231@gmail.com','Student231','Student231','student'),('stud232',1,'stud232@gmail.com','Student232','Student232','student'),('stud233',1,'stud233@gmail.com','Student233','Student233','student'),('stud234',1,'stud234@gmail.com','Student234','Student234','student'),('stud235',1,'stud235@gmail.com','Student235','Student235','student'),('stud236',1,'stud236@gmail.com','Student236','Student236','student'),('stud237',1,'stud237@gmail.com','Student237','Student237','student'),('stud238',1,'stud238@gmail.com','Student238','Student238','student'),('stud239',1,'stud239@gmail.com','Student239','Student239','student'),('stud240',1,'stud240@gmail.com','Student240','Student240','student'),('stud241',1,'stud241@gmail.com','Student241','Student241','student'),('stud242',1,'stud242@gmail.com','Student242','Student242','student'),('stud243',1,'stud243@gmail.com','Student243','Student243','student'),('stud244',1,'stud244@gmail.com','Student244','Student244','student'),('stud245',1,'stud245@gmail.com','Student245','Student245','student'),('stud246',1,'stud246@gmail.com','Student246','Student246','student'),('stud247',1,'stud247@gmail.com','Student247','Student247','student'),('stud248',1,'stud248@gmail.com','Student248','Student248','student'),('stud249',1,'stud249@gmail.com','Student249','Student249','student'),('stud250',1,'stud250@gmail.com','Student250','Student250','student'),('stud251',1,'stud251@gmail.com','Student251','Student251','student'),('stud252',1,'stud252@gmail.com','Student252','Student252','student'),('stud253',1,'stud253@gmail.com','Student253','Student253','student'),('stud254',1,'stud254@gmail.com','Student254','Student254','student'),('stud255',1,'stud255@gmail.com','Student255','Student255','student'),('stud256',1,'stud256@gmail.com','Student256','Student256','student'),('stud257',1,'stud257@gmail.com','Student257','Student257','student'),('stud258',1,'stud258@gmail.com','Student258','Student258','student'),('stud259',1,'stud259@gmail.com','Student259','Student259','student'),('stud260',1,'stud260@gmail.com','Student260','Student260','student'),('stud261',1,'stud261@gmail.com','Student261','Student261','student'),('stud262',1,'stud262@gmail.com','Student262','Student262','student'),('stud263',1,'stud263@gmail.com','Student263','Student263','student'),('stud264',1,'stud264@gmail.com','Student264','Student264','student'),('stud265',1,'stud265@gmail.com','Student265','Student265','student'),('stud266',1,'stud266@gmail.com','Student266','Student266','student'),('stud267',1,'stud267@gmail.com','Student267','Student267','student'),('stud268',1,'stud268@gmail.com','Student268','Student268','student'),('stud269',1,'stud269@gmail.com','Student269','Student269','student'),('stud270',1,'stud270@gmail.com','Student270','Student270','student'),('stud271',1,'stud271@gmail.com','Student271','Student271','student'),('stud272',1,'stud272@gmail.com','Student272','Student272','student'),('stud273',1,'stud273@gmail.com','Student273','Student273','student'),('stud274',1,'stud274@gmail.com','Student274','Student274','student'),('stud275',1,'stud275@gmail.com','Student275','Student275','student'),('stud276',1,'stud276@gmail.com','Student276','Student276','student'),('stud277',1,'stud277@gmail.com','Student277','Student277','student'),('stud278',1,'stud278@gmail.com','Student278','Student278','student'),('stud279',1,'stud279@gmail.com','Student279','Student279','student'),('stud280',1,'stud280@gmail.com','Student280','Student280','student'),('stud281',1,'stud281@gmail.com','Student281','Student281','student'),('stud282',1,'stud282@gmail.com','Student282','Student282','student'),('stud283',1,'stud283@gmail.com','Student283','Student283','student'),('stud284',1,'stud284@gmail.com','Student284','Student284','student'),('stud285',1,'stud285@gmail.com','Student285','Student285','student'),('stud286',1,'stud286@gmail.com','Student286','Student286','student'),('stud287',1,'stud287@gmail.com','Student287','Student287','student'),('stud288',1,'stud288@gmail.com','Student288','Student288','student'),('stud289',1,'stud289@gmail.com','Student289','Student289','student'),('stud290',1,'stud290@gmail.com','Student290','Student290','student'),('stud291',1,'stud291@gmail.com','Student291','Student291','student'),('stud292',1,'stud292@gmail.com','Student292','Student292','student'),('stud293',1,'stud293@gmail.com','Student293','Student293','student'),('stud294',1,'stud294@gmail.com','Student294','Student294','student'),('stud295',1,'stud295@gmail.com','Student295','Student295','student'),('stud296',1,'stud296@gmail.com','Student296','Student296','student'),('stud297',1,'stud297@gmail.com','Student297','Student297','student'),('stud298',1,'stud298@gmail.com','Student298','Student298','student'),('stud299',1,'stud299@gmail.com','Student299','Student299','student'),('stud300',1,'stud300@gmail.com','Student300','Student300','student'),('stud301',1,'stud301@gmail.com','Student301','Student301','student'),('stud302',1,'stud302@gmail.com','Student302','Student302','student'),('stud303',1,'stud303@gmail.com','Student303','Student303','student'),('stud304',1,'stud304@gmail.com','Student304','Student304','student'),('stud305',1,'stud305@gmail.com','Student305','Student305','student'),('stud306',1,'stud306@gmail.com','Student306','Student306','student'),('stud307',1,'stud307@gmail.com','Student307','Student307','student'),('stud308',1,'stud308@gmail.com','Student308','Student308','student'),('stud309',1,'stud309@gmail.com','Student309','Student309','student'),('stud310',1,'stud310@gmail.com','Student310','Student310','student'),('stud311',1,'stud311@gmail.com','Student311','Student311','student'),('stud312',1,'stud312@gmail.com','Student312','Student312','student'),('stud313',1,'stud313@gmail.com','Student313','Student313','student'),('stud314',1,'stud314@gmail.com','Student314','Student314','student'),('stud315',1,'stud315@gmail.com','Student315','Student315','student'),('stud316',1,'stud316@gmail.com','Student316','Student316','student'),('stud317',1,'stud317@gmail.com','Student317','Student317','student'),('stud318',1,'stud318@gmail.com','Student318','Student318','student'),('stud319',1,'stud319@gmail.com','Student319','Student319','student'),('stud320',1,'stud320@gmail.com','Student320','Student320','student'),('stud321',1,'stud321@gmail.com','Student321','Student321','student'),('stud322',1,'stud322@gmail.com','Student322','Student322','student'),('stud323',1,'stud323@gmail.com','Student323','Student323','student'),('stud324',1,'stud324@gmail.com','Student324','Student324','student'),('stud325',1,'stud325@gmail.com','Student325','Student325','student'),('stud326',1,'stud326@gmail.com','Student326','Student326','student'),('stud327',1,'stud327@gmail.com','Student327','Student327','student'),('stud328',1,'stud328@gmail.com','Student328','Student328','student'),('stud329',1,'stud329@gmail.com','Student329','Student329','student'),('stud330',1,'stud330@gmail.com','Student330','Student330','student'),('stud331',1,'stud331@gmail.com','Student331','Student331','student'),('stud332',1,'stud332@gmail.com','Student332','Student332','student'),('stud333',1,'stud333@gmail.com','Student333','Student333','student'),('stud334',1,'stud334@gmail.com','Student334','Student334','student'),('stud335',1,'stud335@gmail.com','Student335','Student335','student'),('stud336',1,'stud336@gmail.com','Student336','Student336','student'),('stud337',1,'stud337@gmail.com','Student337','Student337','student'),('stud338',1,'stud338@gmail.com','Student338','Student338','student'),('stud339',1,'stud339@gmail.com','Student339','Student339','student'),('stud340',1,'stud340@gmail.com','Student340','Student340','student'),('stud341',1,'stud341@gmail.com','Student341','Student341','student'),('stud342',1,'stud342@gmail.com','Student342','Student342','student'),('stud343',1,'stud343@gmail.com','Student343','Student343','student'),('stud344',1,'stud344@gmail.com','Student344','Student344','student'),('stud345',1,'stud345@gmail.com','Student345','Student345','student'),('stud346',1,'stud346@gmail.com','Student346','Student346','student'),('stud347',1,'stud347@gmail.com','Student347','Student347','student'),('stud348',1,'stud348@gmail.com','Student348','Student348','student'),('stud349',1,'stud349@gmail.com','Student349','Student349','student'),('stud350',1,'stud350@gmail.com','Student350','Student350','student'),('stud351',1,'stud351@gmail.com','Student351','Student351','student'),('stud352',1,'stud352@gmail.com','Student352','Student352','student'),('stud353',1,'stud353@gmail.com','Student353','Student353','student'),('stud354',1,'stud354@gmail.com','Student354','Student354','student'),('stud355',1,'stud355@gmail.com','Student355','Student355','student'),('stud356',1,'stud356@gmail.com','Student356','Student356','student'),('stud357',1,'stud357@gmail.com','Student357','Student357','student'),('stud358',1,'stud358@gmail.com','Student358','Student358','student'),('stud359',1,'stud359@gmail.com','Student359','Student359','student'),('stud360',1,'stud360@gmail.com','Student360','Student360','student'),('stud361',1,'stud361@gmail.com','Student361','Student361','student'),('stud362',1,'stud362@gmail.com','Student362','Student362','student'),('stud363',1,'stud363@gmail.com','Student363','Student363','student'),('stud364',1,'stud364@gmail.com','Student364','Student364','student'),('stud365',1,'stud365@gmail.com','Student365','Student365','student'),('stud366',1,'stud366@gmail.com','Student366','Student366','student'),('stud367',1,'stud367@gmail.com','Student367','Student367','student'),('stud368',1,'stud368@gmail.com','Student368','Student368','student'),('stud369',1,'stud369@gmail.com','Student369','Student369','student'),('stud370',1,'stud370@gmail.com','Student370','Student370','student'),('stud371',1,'stud371@gmail.com','Student371','Student371','student'),('stud372',1,'stud372@gmail.com','Student372','Student372','student'),('stud373',1,'stud373@gmail.com','Student373','Student373','student'),('stud374',1,'stud374@gmail.com','Student374','Student374','student'),('stud375',1,'stud375@gmail.com','Student375','Student375','student'),('stud376',1,'stud376@gmail.com','Student376','Student376','student'),('stud377',1,'stud377@gmail.com','Student377','Student377','student'),('stud378',1,'stud378@gmail.com','Student378','Student378','student'),('stud379',1,'stud379@gmail.com','Student379','Student379','student'),('stud380',1,'stud380@gmail.com','Student380','Student380','student'),('stud381',1,'stud381@gmail.com','Student381','Student381','student'),('stud382',1,'stud382@gmail.com','Student382','Student382','student'),('stud383',1,'stud383@gmail.com','Student383','Student383','student'),('stud384',1,'stud384@gmail.com','Student384','Student384','student'),('stud385',1,'stud385@gmail.com','Student385','Student385','student'),('stud386',1,'stud386@gmail.com','Student386','Student386','student'),('stud387',1,'stud387@gmail.com','Student387','Student387','student'),('stud388',1,'stud388@gmail.com','Student388','Student388','student'),('stud389',1,'stud389@gmail.com','Student389','Student389','student'),('stud390',1,'stud390@gmail.com','Student390','Student390','student'),('stud391',1,'stud391@gmail.com','Student391','Student391','student'),('stud392',1,'stud392@gmail.com','Student392','Student392','student'),('stud393',1,'stud393@gmail.com','Student393','Student393','student'),('stud394',1,'stud394@gmail.com','Student394','Student394','student'),('stud395',1,'stud395@gmail.com','Student395','Student395','student'),('stud396',1,'stud396@gmail.com','Student396','Student396','student'),('stud397',1,'stud397@gmail.com','Student397','Student397','student'),('stud398',1,'stud398@gmail.com','Student398','Student398','student'),('stud399',1,'stud399@gmail.com','Student399','Student399','student'),('stud400',1,'stud400@gmail.com','Student400','Student400','student'),('stud401',1,'stud401@gmail.com','Student401','Student401','student'),('stud402',1,'stud402@gmail.com','Student402','Student402','student'),('stud403',1,'stud403@gmail.com','Student403','Student403','student'),('stud404',1,'stud404@gmail.com','Student404','Student404','student'),('stud405',1,'stud405@gmail.com','Student405','Student405','student'),('stud406',1,'stud406@gmail.com','Student406','Student406','student'),('stud407',1,'stud407@gmail.com','Student407','Student407','student'),('stud408',1,'stud408@gmail.com','Student408','Student408','student'),('stud409',1,'stud409@gmail.com','Student409','Student409','student'),('stud410',1,'stud410@gmail.com','Student410','Student410','student'),('stud411',1,'stud411@gmail.com','Student411','Student411','student'),('stud412',1,'stud412@gmail.com','Student412','Student412','student'),('stud413',1,'stud413@gmail.com','Student413','Student413','student'),('stud414',1,'stud414@gmail.com','Student414','Student414','student'),('stud415',1,'stud415@gmail.com','Student415','Student415','student'),('stud416',1,'stud416@gmail.com','Student416','Student416','student'),('stud417',1,'stud417@gmail.com','Student417','Student417','student'),('stud418',1,'stud418@gmail.com','Student418','Student418','student'),('stud419',1,'stud419@gmail.com','Student419','Student419','student'),('stud420',1,'stud420@gmail.com','Student420','Student420','student'),('stud421',1,'stud421@gmail.com','Student421','Student421','student'),('stud422',1,'stud422@gmail.com','Student422','Student422','student'),('stud423',1,'stud423@gmail.com','Student423','Student423','student'),('stud424',1,'stud424@gmail.com','Student424','Student424','student'),('stud425',1,'stud425@gmail.com','Student425','Student425','student'),('stud426',1,'stud426@gmail.com','Student426','Student426','student'),('stud427',1,'stud427@gmail.com','Student427','Student427','student'),('stud428',1,'stud428@gmail.com','Student428','Student428','student'),('stud429',1,'stud429@gmail.com','Student429','Student429','student'),('stud430',1,'stud430@gmail.com','Student430','Student430','student'),('stud431',1,'stud431@gmail.com','Student431','Student431','student'),('stud432',1,'stud432@gmail.com','Student432','Student432','student'),('stud433',1,'stud433@gmail.com','Student433','Student433','student'),('stud434',1,'stud434@gmail.com','Student434','Student434','student'),('stud435',1,'stud435@gmail.com','Student435','Student435','student'),('stud436',1,'stud436@gmail.com','Student436','Student436','student'),('stud437',1,'stud437@gmail.com','Student437','Student437','student'),('stud438',1,'stud438@gmail.com','Student438','Student438','student'),('stud439',1,'stud439@gmail.com','Student439','Student439','student'),('stud440',1,'stud440@gmail.com','Student440','Student440','student'),('stud441',1,'stud441@gmail.com','Student441','Student441','student'),('stud442',1,'stud442@gmail.com','Student442','Student442','student'),('stud443',1,'stud443@gmail.com','Student443','Student443','student'),('stud444',1,'stud444@gmail.com','Student444','Student444','student'),('stud445',1,'stud445@gmail.com','Student445','Student445','student'),('stud446',1,'stud446@gmail.com','Student446','Student446','student'),('stud447',1,'stud447@gmail.com','Student447','Student447','student'),('stud448',1,'stud448@gmail.com','Student448','Student448','student'),('stud449',1,'stud449@gmail.com','Student449','Student449','student'),('stud450',1,'stud450@gmail.com','Student450','Student450','student'),('stud451',1,'stud451@gmail.com','Student451','Student451','student'),('stud452',1,'stud452@gmail.com','Student452','Student452','student'),('stud453',1,'stud453@gmail.com','Student453','Student453','student'),('stud454',1,'stud454@gmail.com','Student454','Student454','student'),('stud455',1,'stud455@gmail.com','Student455','Student455','student'),('stud456',1,'stud456@gmail.com','Student456','Student456','student'),('stud457',1,'stud457@gmail.com','Student457','Student457','student'),('stud458',1,'stud458@gmail.com','Student458','Student458','student'),('stud459',1,'stud459@gmail.com','Student459','Student459','student'),('stud460',1,'stud460@gmail.com','Student460','Student460','student'),('stud461',1,'stud461@gmail.com','Student461','Student461','student'),('stud462',1,'stud462@gmail.com','Student462','Student462','student'),('stud463',1,'stud463@gmail.com','Student463','Student463','student'),('stud464',1,'stud464@gmail.com','Student464','Student464','student'),('stud465',1,'stud465@gmail.com','Student465','Student465','student'),('stud466',1,'stud466@gmail.com','Student466','Student466','student'),('stud467',1,'stud467@gmail.com','Student467','Student467','student'),('stud468',1,'stud468@gmail.com','Student468','Student468','student'),('stud469',1,'stud469@gmail.com','Student469','Student469','student'),('stud470',1,'stud470@gmail.com','Student470','Student470','student'),('stud471',1,'stud471@gmail.com','Student471','Student471','student'),('stud472',1,'stud472@gmail.com','Student472','Student472','student'),('stud473',1,'stud473@gmail.com','Student473','Student473','student'),('stud474',1,'stud474@gmail.com','Student474','Student474','student'),('stud475',1,'stud475@gmail.com','Student475','Student475','student'),('stud476',1,'stud476@gmail.com','Student476','Student476','student'),('stud477',1,'stud477@gmail.com','Student477','Student477','student'),('stud478',1,'stud478@gmail.com','Student478','Student478','student'),('stud479',1,'stud479@gmail.com','Student479','Student479','student'),('stud480',1,'stud480@gmail.com','Student480','Student480','student'),('stud481',1,'stud481@gmail.com','Student481','Student481','student'),('stud482',1,'stud482@gmail.com','Student482','Student482','student'),('stud483',1,'stud483@gmail.com','Student483','Student483','student'),('stud484',1,'stud484@gmail.com','Student484','Student484','student'),('stud485',1,'stud485@gmail.com','Student485','Student485','student'),('stud486',1,'stud486@gmail.com','Student486','Student486','student'),('stud487',1,'stud487@gmail.com','Student487','Student487','student'),('stud488',1,'stud488@gmail.com','Student488','Student488','student'),('stud489',1,'stud489@gmail.com','Student489','Student489','student'),('stud490',1,'stud490@gmail.com','Student490','Student490','student'),('stud491',1,'stud491@gmail.com','Student491','Student491','student'),('stud492',1,'stud492@gmail.com','Student492','Student492','student'),('stud493',1,'stud493@gmail.com','Student493','Student493','student'),('stud494',1,'stud494@gmail.com','Student494','Student494','student'),('stud495',1,'stud495@gmail.com','Student495','Student495','student'),('stud496',1,'stud496@gmail.com','Student496','Student496','student'),('stud497',1,'stud497@gmail.com','Student497','Student497','student'),('stud498',1,'stud498@gmail.com','Student498','Student498','student'),('stud499',1,'stud499@gmail.com','Student499','Student499','student'),('stud500',1,'stud500@gmail.com','Student500','Student500','student'),('stud501',1,'stud501@gmail.com','Student501','Student501','student'),('stud502',1,'stud502@gmail.com','Student502','Student502','student'),('stud503',1,'stud503@gmail.com','Student503','Student503','student'),('stud504',1,'stud504@gmail.com','Student504','Student504','student'),('stud505',1,'stud505@gmail.com','Student505','Student505','student'),('stud506',1,'stud506@gmail.com','Student506','Student506','student'),('stud507',1,'stud507@gmail.com','Student507','Student507','student'),('stud508',1,'stud508@gmail.com','Student508','Student508','student'),('stud509',1,'stud509@gmail.com','Student509','Student509','student'),('stud510',1,'stud510@gmail.com','Student510','Student510','student'),('stud511',1,'stud511@gmail.com','Student511','Student511','student'),('stud512',1,'stud512@gmail.com','Student512','Student512','student'),('stud513',1,'stud513@gmail.com','Student513','Student513','student'),('stud514',1,'stud514@gmail.com','Student514','Student514','student'),('stud515',1,'stud515@gmail.com','Student515','Student515','student'),('stud516',1,'stud516@gmail.com','Student516','Student516','student'),('stud517',1,'stud517@gmail.com','Student517','Student517','student'),('stud518',1,'stud518@gmail.com','Student518','Student518','student'),('stud519',1,'stud519@gmail.com','Student519','Student519','student'),('stud520',1,'stud520@gmail.com','Student520','Student520','student'),('stud521',1,'stud521@gmail.com','Student521','Student521','student'),('stud522',1,'stud522@gmail.com','Student522','Student522','student'),('stud523',1,'stud523@gmail.com','Student523','Student523','student'),('stud524',1,'stud524@gmail.com','Student524','Student524','student'),('stud525',1,'stud525@gmail.com','Student525','Student525','student'),('stud526',1,'stud526@gmail.com','Student526','Student526','student'),('stud527',1,'stud527@gmail.com','Student527','Student527','student'),('stud528',1,'stud528@gmail.com','Student528','Student528','student'),('stud529',1,'stud529@gmail.com','Student529','Student529','student'),('stud530',1,'stud530@gmail.com','Student530','Student530','student'),('stud531',1,'stud531@gmail.com','Student531','Student531','student'),('stud532',1,'stud532@gmail.com','Student532','Student532','student'),('stud533',1,'stud533@gmail.com','Student533','Student533','student'),('stud534',1,'stud534@gmail.com','Student534','Student534','student'),('stud535',1,'stud535@gmail.com','Student535','Student535','student'),('stud536',1,'stud536@gmail.com','Student536','Student536','student'),('stud537',1,'stud537@gmail.com','Student537','Student537','student'),('stud538',1,'stud538@gmail.com','Student538','Student538','student'),('stud539',1,'stud539@gmail.com','Student539','Student539','student'),('stud540',1,'stud540@gmail.com','Student540','Student540','student'),('stud541',1,'stud541@gmail.com','Student541','Student541','student'),('stud542',1,'stud542@gmail.com','Student542','Student542','student'),('stud543',1,'stud543@gmail.com','Student543','Student543','student'),('stud544',1,'stud544@gmail.com','Student544','Student544','student'),('stud545',1,'stud545@gmail.com','Student545','Student545','student'),('stud546',1,'stud546@gmail.com','Student546','Student546','student'),('stud547',1,'stud547@gmail.com','Student547','Student547','student'),('stud548',1,'stud548@gmail.com','Student548','Student548','student'),('stud549',1,'stud549@gmail.com','Student549','Student549','student'),('stud550',1,'stud550@gmail.com','Student550','Student550','student'),('stud551',1,'stud551@gmail.com','Student551','Student551','student'),('stud552',1,'stud552@gmail.com','Student552','Student552','student'),('stud553',1,'stud553@gmail.com','Student553','Student553','student'),('stud554',1,'stud554@gmail.com','Student554','Student554','student'),('stud555',1,'stud555@gmail.com','Student555','Student555','student'),('stud556',1,'stud556@gmail.com','Student556','Student556','student'),('stud557',1,'stud557@gmail.com','Student557','Student557','student'),('stud558',1,'stud558@gmail.com','Student558','Student558','student'),('stud559',1,'stud559@gmail.com','Student559','Student559','student'),('stud560',1,'stud560@gmail.com','Student560','Student560','student'),('stud561',1,'stud561@gmail.com','Student561','Student561','student'),('stud562',1,'stud562@gmail.com','Student562','Student562','student'),('stud563',1,'stud563@gmail.com','Student563','Student563','student'),('stud564',1,'stud564@gmail.com','Student564','Student564','student'),('stud565',1,'stud565@gmail.com','Student565','Student565','student'),('stud566',1,'stud566@gmail.com','Student566','Student566','student'),('stud567',1,'stud567@gmail.com','Student567','Student567','student'),('stud568',1,'stud568@gmail.com','Student568','Student568','student'),('stud569',1,'stud569@gmail.com','Student569','Student569','student'),('stud570',1,'stud570@gmail.com','Student570','Student570','student'),('stud571',1,'stud571@gmail.com','Student571','Student571','student'),('stud572',1,'stud572@gmail.com','Student572','Student572','student'),('stud573',1,'stud573@gmail.com','Student573','Student573','student'),('stud574',1,'stud574@gmail.com','Student574','Student574','student'),('stud575',1,'stud575@gmail.com','Student575','Student575','student'),('stud576',1,'stud576@gmail.com','Student576','Student576','student'),('stud577',1,'stud577@gmail.com','Student577','Student577','student'),('stud578',1,'stud578@gmail.com','Student578','Student578','student'),('stud579',1,'stud579@gmail.com','Student579','Student579','student'),('stud580',1,'stud580@gmail.com','Student580','Student580','student'),('stud581',1,'stud581@gmail.com','Student581','Student581','student'),('stud582',1,'stud582@gmail.com','Student582','Student582','student'),('stud583',1,'stud583@gmail.com','Student583','Student583','student'),('stud584',1,'stud584@gmail.com','Student584','Student584','student'),('stud585',1,'stud585@gmail.com','Student585','Student585','student'),('stud586',1,'stud586@gmail.com','Student586','Student586','student'),('stud587',1,'stud587@gmail.com','Student587','Student587','student'),('stud588',1,'stud588@gmail.com','Student588','Student588','student'),('stud589',1,'stud589@gmail.com','Student589','Student589','student'),('stud590',1,'stud590@gmail.com','Student590','Student590','student'),('stud591',1,'stud591@gmail.com','Student591','Student591','student'),('stud592',1,'stud592@gmail.com','Student592','Student592','student'),('stud593',1,'stud593@gmail.com','Student593','Student593','student'),('stud594',1,'stud594@gmail.com','Student594','Student594','student'),('stud595',1,'stud595@gmail.com','Student595','Student595','student'),('stud596',1,'stud596@gmail.com','Student596','Student596','student'),('stud597',1,'stud597@gmail.com','Student597','Student597','student'),('stud598',1,'stud598@gmail.com','Student598','Student598','student'),('stud599',1,'stud599@gmail.com','Student599','Student599','student'),('stud600',1,'stud600@gmail.com','Student600','Student600','student'),('stud601',1,'stud601@gmail.com','Student601','Student601','student'),('stud602',1,'stud602@gmail.com','Student602','Student602','student'),('stud603',1,'stud603@gmail.com','Student603','Student603','student'),('stud604',1,'stud604@gmail.com','Student604','Student604','student'),('stud605',1,'stud605@gmail.com','Student605','Student605','student'),('stud606',1,'stud606@gmail.com','Student606','Student606','student'),('stud607',1,'stud607@gmail.com','Student607','Student607','student'),('stud608',1,'stud608@gmail.com','Student608','Student608','student'),('stud609',1,'stud609@gmail.com','Student609','Student609','student'),('stud610',1,'stud610@gmail.com','Student610','Student610','student'),('stud611',1,'stud611@gmail.com','Student611','Student611','student'),('stud612',1,'stud612@gmail.com','Student612','Student612','student'),('stud613',1,'stud613@gmail.com','Student613','Student613','student'),('stud614',1,'stud614@gmail.com','Student614','Student614','student'),('stud615',1,'stud615@gmail.com','Student615','Student615','student'),('stud616',1,'stud616@gmail.com','Student616','Student616','student'),('stud617',1,'stud617@gmail.com','Student617','Student617','student'),('stud618',1,'stud618@gmail.com','Student618','Student618','student'),('stud619',1,'stud619@gmail.com','Student619','Student619','student'),('stud620',1,'stud620@gmail.com','Student620','Student620','student'),('stud621',1,'stud621@gmail.com','Student621','Student621','student'),('stud622',1,'stud622@gmail.com','Student622','Student622','student'),('stud623',1,'stud623@gmail.com','Student623','Student623','student'),('stud624',1,'stud624@gmail.com','Student624','Student624','student'),('stud625',1,'stud625@gmail.com','Student625','Student625','student'),('stud626',1,'stud626@gmail.com','Student626','Student626','student'),('stud627',1,'stud627@gmail.com','Student627','Student627','student'),('stud628',1,'stud628@gmail.com','Student628','Student628','student'),('stud629',1,'stud629@gmail.com','Student629','Student629','student'),('stud630',1,'stud630@gmail.com','Student630','Student630','student'),('stud631',1,'stud631@gmail.com','Student631','Student631','student'),('stud632',1,'stud632@gmail.com','Student632','Student632','student'),('stud633',1,'stud633@gmail.com','Student633','Student633','student'),('stud634',1,'stud634@gmail.com','Student634','Student634','student'),('stud635',1,'stud635@gmail.com','Student635','Student635','student'),('stud636',1,'stud636@gmail.com','Student636','Student636','student'),('stud637',1,'stud637@gmail.com','Student637','Student637','student'),('stud638',1,'stud638@gmail.com','Student638','Student638','student'),('stud639',1,'stud639@gmail.com','Student639','Student639','student'),('stud640',1,'stud640@gmail.com','Student640','Student640','student'),('stud641',1,'stud641@gmail.com','Student641','Student641','student'),('stud642',1,'stud642@gmail.com','Student642','Student642','student'),('stud643',1,'stud643@gmail.com','Student643','Student643','student'),('stud644',1,'stud644@gmail.com','Student644','Student644','student'),('stud645',1,'stud645@gmail.com','Student645','Student645','student'),('stud646',1,'stud646@gmail.com','Student646','Student646','student'),('stud647',1,'stud647@gmail.com','Student647','Student647','student'),('stud648',1,'stud648@gmail.com','Student648','Student648','student'),('stud649',1,'stud649@gmail.com','Student649','Student649','student'),('stud650',1,'stud650@gmail.com','Student650','Student650','student'),('stud651',1,'stud651@gmail.com','Student651','Student651','student'),('stud652',1,'stud652@gmail.com','Student652','Student652','student'),('stud653',1,'stud653@gmail.com','Student653','Student653','student'),('stud654',1,'stud654@gmail.com','Student654','Student654','student'),('stud655',1,'stud655@gmail.com','Student655','Student655','student'),('stud656',1,'stud656@gmail.com','Student656','Student656','student'),('stud657',1,'stud657@gmail.com','Student657','Student657','student'),('stud658',1,'stud658@gmail.com','Student658','Student658','student'),('stud659',1,'stud659@gmail.com','Student659','Student659','student'),('stud660',1,'stud660@gmail.com','Student660','Student660','student'),('stud661',1,'stud661@gmail.com','Student661','Student661','student'),('stud662',1,'stud662@gmail.com','Student662','Student662','student'),('stud663',1,'stud663@gmail.com','Student663','Student663','student'),('stud664',1,'stud664@gmail.com','Student664','Student664','student'),('stud665',1,'stud665@gmail.com','Student665','Student665','student'),('stud666',1,'stud666@gmail.com','Student666','Student666','student'),('stud667',1,'stud667@gmail.com','Student667','Student667','student'),('stud668',1,'stud668@gmail.com','Student668','Student668','student'),('stud669',1,'stud669@gmail.com','Student669','Student669','student'),('stud670',1,'stud670@gmail.com','Student670','Student670','student'),('stud671',1,'stud671@gmail.com','Student671','Student671','student'),('stud672',1,'stud672@gmail.com','Student672','Student672','student'),('stud673',1,'stud673@gmail.com','Student673','Student673','student'),('stud674',1,'stud674@gmail.com','Student674','Student674','student'),('stud675',1,'stud675@gmail.com','Student675','Student675','student'),('stud676',1,'stud676@gmail.com','Student676','Student676','student'),('stud677',1,'stud677@gmail.com','Student677','Student677','student'),('stud678',1,'stud678@gmail.com','Student678','Student678','student'),('stud679',1,'stud679@gmail.com','Student679','Student679','student'),('stud680',1,'stud680@gmail.com','Student680','Student680','student'),('stud681',1,'stud681@gmail.com','Student681','Student681','student'),('stud682',1,'stud682@gmail.com','Student682','Student682','student'),('stud683',1,'stud683@gmail.com','Student683','Student683','student'),('stud684',1,'stud684@gmail.com','Student684','Student684','student'),('stud685',1,'stud685@gmail.com','Student685','Student685','student'),('stud686',1,'stud686@gmail.com','Student686','Student686','student'),('stud687',1,'stud687@gmail.com','Student687','Student687','student'),('stud688',1,'stud688@gmail.com','Student688','Student688','student'),('stud689',1,'stud689@gmail.com','Student689','Student689','student'),('stud690',1,'stud690@gmail.com','Student690','Student690','student'),('stud691',1,'stud691@gmail.com','Student691','Student691','student'),('stud692',1,'stud692@gmail.com','Student692','Student692','student'),('stud693',1,'stud693@gmail.com','Student693','Student693','student'),('stud694',1,'stud694@gmail.com','Student694','Student694','student'),('stud695',1,'stud695@gmail.com','Student695','Student695','student'),('stud696',1,'stud696@gmail.com','Student696','Student696','student'),('stud697',1,'stud697@gmail.com','Student697','Student697','student'),('stud698',1,'stud698@gmail.com','Student698','Student698','student'),('stud699',1,'stud699@gmail.com','Student699','Student699','student'),('stud700',1,'stud700@gmail.com','Student700','Student700','student'),('stud701',1,'stud701@gmail.com','Student701','Student701','student'),('stud702',1,'stud702@gmail.com','Student702','Student702','student'),('stud703',1,'stud703@gmail.com','Student703','Student703','student'),('stud704',1,'stud704@gmail.com','Student704','Student704','student'),('stud705',1,'stud705@gmail.com','Student705','Student705','student'),('stud706',1,'stud706@gmail.com','Student706','Student706','student'),('stud707',1,'stud707@gmail.com','Student707','Student707','student'),('stud708',1,'stud708@gmail.com','Student708','Student708','student'),('stud709',1,'stud709@gmail.com','Student709','Student709','student'),('stud710',1,'stud710@gmail.com','Student710','Student710','student'),('stud711',1,'stud711@gmail.com','Student711','Student711','student'),('stud712',1,'stud712@gmail.com','Student712','Student712','student'),('stud713',1,'stud713@gmail.com','Student713','Student713','student'),('stud714',1,'stud714@gmail.com','Student714','Student714','student'),('stud715',1,'stud715@gmail.com','Student715','Student715','student'),('stud716',1,'stud716@gmail.com','Student716','Student716','student'),('stud717',1,'stud717@gmail.com','Student717','Student717','student'),('stud718',1,'stud718@gmail.com','Student718','Student718','student'),('stud719',1,'stud719@gmail.com','Student719','Student719','student'),('stud720',1,'stud720@gmail.com','Student720','Student720','student'),('stud721',1,'stud721@gmail.com','Student721','Student721','student'),('stud722',1,'stud722@gmail.com','Student722','Student722','student'),('stud723',1,'stud723@gmail.com','Student723','Student723','student'),('stud724',1,'stud724@gmail.com','Student724','Student724','student'),('stud725',1,'stud725@gmail.com','Student725','Student725','student'),('stud726',1,'stud726@gmail.com','Student726','Student726','student'),('stud727',1,'stud727@gmail.com','Student727','Student727','student'),('stud728',1,'stud728@gmail.com','Student728','Student728','student'),('stud729',1,'stud729@gmail.com','Student729','Student729','student'),('stud730',1,'stud730@gmail.com','Student730','Student730','student'),('stud731',1,'stud731@gmail.com','Student731','Student731','student'),('stud732',1,'stud732@gmail.com','Student732','Student732','student'),('stud733',1,'stud733@gmail.com','Student733','Student733','student'),('stud734',1,'stud734@gmail.com','Student734','Student734','student'),('stud735',1,'stud735@gmail.com','Student735','Student735','student'),('stud736',1,'stud736@gmail.com','Student736','Student736','student'),('stud737',1,'stud737@gmail.com','Student737','Student737','student'),('stud738',1,'stud738@gmail.com','Student738','Student738','student'),('stud739',1,'stud739@gmail.com','Student739','Student739','student'),('stud740',1,'stud740@gmail.com','Student740','Student740','student'),('stud741',1,'stud741@gmail.com','Student741','Student741','student'),('stud742',1,'stud742@gmail.com','Student742','Student742','student'),('stud743',1,'stud743@gmail.com','Student743','Student743','student'),('stud744',1,'stud744@gmail.com','Student744','Student744','student'),('stud745',1,'stud745@gmail.com','Student745','Student745','student'),('stud746',1,'stud746@gmail.com','Student746','Student746','student'),('stud747',1,'stud747@gmail.com','Student747','Student747','student'),('stud748',1,'stud748@gmail.com','Student748','Student748','student'),('stud749',1,'stud749@gmail.com','Student749','Student749','student'),('stud750',1,'stud750@gmail.com','Student750','Student750','student'),('stud751',1,'stud751@gmail.com','Student751','Student751','student'),('stud752',1,'stud752@gmail.com','Student752','Student752','student'),('stud753',1,'stud753@gmail.com','Student753','Student753','student'),('stud754',1,'stud754@gmail.com','Student754','Student754','student'),('stud755',1,'stud755@gmail.com','Student755','Student755','student'),('stud756',1,'stud756@gmail.com','Student756','Student756','student'),('stud757',1,'stud757@gmail.com','Student757','Student757','student'),('stud758',1,'stud758@gmail.com','Student758','Student758','student'),('stud759',1,'stud759@gmail.com','Student759','Student759','student'),('stud760',1,'stud760@gmail.com','Student760','Student760','student'),('stud761',1,'stud761@gmail.com','Student761','Student761','student'),('stud762',1,'stud762@gmail.com','Student762','Student762','student'),('stud763',1,'stud763@gmail.com','Student763','Student763','student'),('stud764',1,'stud764@gmail.com','Student764','Student764','student'),('stud765',1,'stud765@gmail.com','Student765','Student765','student'),('stud766',1,'stud766@gmail.com','Student766','Student766','student'),('stud767',1,'stud767@gmail.com','Student767','Student767','student'),('stud768',1,'stud768@gmail.com','Student768','Student768','student'),('stud769',1,'stud769@gmail.com','Student769','Student769','student'),('stud770',1,'stud770@gmail.com','Student770','Student770','student'),('stud771',1,'stud771@gmail.com','Student771','Student771','student'),('stud772',1,'stud772@gmail.com','Student772','Student772','student'),('stud773',1,'stud773@gmail.com','Student773','Student773','student'),('stud774',1,'stud774@gmail.com','Student774','Student774','student'),('stud775',1,'stud775@gmail.com','Student775','Student775','student'),('stud776',1,'stud776@gmail.com','Student776','Student776','student'),('stud777',1,'stud777@gmail.com','Student777','Student777','student'),('stud778',1,'stud778@gmail.com','Student778','Student778','student'),('stud779',1,'stud779@gmail.com','Student779','Student779','student'),('stud780',1,'stud780@gmail.com','Student780','Student780','student'),('stud781',1,'stud781@gmail.com','Student781','Student781','student'),('stud782',1,'stud782@gmail.com','Student782','Student782','student'),('stud783',1,'stud783@gmail.com','Student783','Student783','student'),('stud784',1,'stud784@gmail.com','Student784','Student784','student'),('stud785',1,'stud785@gmail.com','Student785','Student785','student'),('stud786',1,'stud786@gmail.com','Student786','Student786','student'),('stud787',1,'stud787@gmail.com','Student787','Student787','student'),('stud788',1,'stud788@gmail.com','Student788','Student788','student'),('stud789',1,'stud789@gmail.com','Student789','Student789','student'),('stud790',1,'stud790@gmail.com','Student790','Student790','student'),('stud791',1,'stud791@gmail.com','Student791','Student791','student'),('stud792',1,'stud792@gmail.com','Student792','Student792','student'),('stud793',1,'stud793@gmail.com','Student793','Student793','student'),('stud794',1,'stud794@gmail.com','Student794','Student794','student'),('stud795',1,'stud795@gmail.com','Student795','Student795','student'),('stud796',1,'stud796@gmail.com','Student796','Student796','student'),('stud797',1,'stud797@gmail.com','Student797','Student797','student'),('stud798',1,'stud798@gmail.com','Student798','Student798','student'),('stud799',1,'stud799@gmail.com','Student799','Student799','student'),('stud800',1,'stud800@gmail.com','Student800','Student800','student'),('stud801',1,'stud801@gmail.com','Student801','Student801','student'),('stud802',1,'stud802@gmail.com','Student802','Student802','student'),('stud803',1,'stud803@gmail.com','Student803','Student803','student'),('stud804',1,'stud804@gmail.com','Student804','Student804','student'),('stud805',1,'stud805@gmail.com','Student805','Student805','student'),('stud806',1,'stud806@gmail.com','Student806','Student806','student'),('stud807',1,'stud807@gmail.com','Student807','Student807','student'),('stud808',1,'stud808@gmail.com','Student808','Student808','student'),('stud809',1,'stud809@gmail.com','Student809','Student809','student'),('stud810',1,'stud810@gmail.com','Student810','Student810','student'),('stud811',1,'stud811@gmail.com','Student811','Student811','student'),('stud812',1,'stud812@gmail.com','Student812','Student812','student'),('stud813',1,'stud813@gmail.com','Student813','Student813','student'),('stud814',1,'stud814@gmail.com','Student814','Student814','student'),('stud815',1,'stud815@gmail.com','Student815','Student815','student'),('stud816',1,'stud816@gmail.com','Student816','Student816','student'),('stud817',1,'stud817@gmail.com','Student817','Student817','student'),('stud818',1,'stud818@gmail.com','Student818','Student818','student'),('stud819',1,'stud819@gmail.com','Student819','Student819','student'),('stud820',1,'stud820@gmail.com','Student820','Student820','student'),('stud821',1,'stud821@gmail.com','Student821','Student821','student'),('stud822',1,'stud822@gmail.com','Student822','Student822','student'),('stud823',1,'stud823@gmail.com','Student823','Student823','student'),('stud824',1,'stud824@gmail.com','Student824','Student824','student'),('stud825',1,'stud825@gmail.com','Student825','Student825','student'),('stud826',1,'stud826@gmail.com','Student826','Student826','student'),('stud827',1,'stud827@gmail.com','Student827','Student827','student'),('stud828',1,'stud828@gmail.com','Student828','Student828','student'),('stud829',1,'stud829@gmail.com','Student829','Student829','student'),('stud830',1,'stud830@gmail.com','Student830','Student830','student'),('stud831',1,'stud831@gmail.com','Student831','Student831','student'),('stud832',1,'stud832@gmail.com','Student832','Student832','student'),('stud833',1,'stud833@gmail.com','Student833','Student833','student'),('stud834',1,'stud834@gmail.com','Student834','Student834','student'),('stud835',1,'stud835@gmail.com','Student835','Student835','student'),('stud836',1,'stud836@gmail.com','Student836','Student836','student'),('stud837',1,'stud837@gmail.com','Student837','Student837','student'),('stud838',1,'stud838@gmail.com','Student838','Student838','student'),('stud839',1,'stud839@gmail.com','Student839','Student839','student'),('stud840',1,'stud840@gmail.com','Student840','Student840','student'),('stud841',1,'stud841@gmail.com','Student841','Student841','student'),('stud842',1,'stud842@gmail.com','Student842','Student842','student'),('stud843',1,'stud843@gmail.com','Student843','Student843','student'),('stud844',1,'stud844@gmail.com','Student844','Student844','student'),('stud845',1,'stud845@gmail.com','Student845','Student845','student'),('stud846',1,'stud846@gmail.com','Student846','Student846','student'),('stud847',1,'stud847@gmail.com','Student847','Student847','student'),('stud848',1,'stud848@gmail.com','Student848','Student848','student'),('stud849',1,'stud849@gmail.com','Student849','Student849','student'),('stud850',1,'stud850@gmail.com','Student850','Student850','student'),('stud851',1,'stud851@gmail.com','Student851','Student851','student'),('stud852',1,'stud852@gmail.com','Student852','Student852','student'),('stud853',1,'stud853@gmail.com','Student853','Student853','student'),('stud854',1,'stud854@gmail.com','Student854','Student854','student'),('stud855',1,'stud855@gmail.com','Student855','Student855','student'),('stud856',1,'stud856@gmail.com','Student856','Student856','student'),('stud857',1,'stud857@gmail.com','Student857','Student857','student'),('stud858',1,'stud858@gmail.com','Student858','Student858','student'),('stud859',1,'stud859@gmail.com','Student859','Student859','student'),('stud860',1,'stud860@gmail.com','Student860','Student860','student'),('stud861',1,'stud861@gmail.com','Student861','Student861','student'),('stud862',1,'stud862@gmail.com','Student862','Student862','student'),('stud863',1,'stud863@gmail.com','Student863','Student863','student'),('stud864',1,'stud864@gmail.com','Student864','Student864','student'),('stud865',1,'stud865@gmail.com','Student865','Student865','student'),('stud866',1,'stud866@gmail.com','Student866','Student866','student'),('stud867',1,'stud867@gmail.com','Student867','Student867','student'),('stud868',1,'stud868@gmail.com','Student868','Student868','student'),('stud869',1,'stud869@gmail.com','Student869','Student869','student'),('stud870',1,'stud870@gmail.com','Student870','Student870','student'),('stud871',1,'stud871@gmail.com','Student871','Student871','student'),('stud872',1,'stud872@gmail.com','Student872','Student872','student'),('stud873',1,'stud873@gmail.com','Student873','Student873','student'),('stud874',1,'stud874@gmail.com','Student874','Student874','student'),('stud875',1,'stud875@gmail.com','Student875','Student875','student'),('stud876',1,'stud876@gmail.com','Student876','Student876','student'),('stud877',1,'stud877@gmail.com','Student877','Student877','student'),('stud878',1,'stud878@gmail.com','Student878','Student878','student'),('stud879',1,'stud879@gmail.com','Student879','Student879','student'),('stud880',1,'stud880@gmail.com','Student880','Student880','student');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_role`
--
DROP TABLE IF EXISTS `user_role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_role` (
`user_name` varchar(255) NOT NULL,
`roles_role_id` int(11) NOT NULL,
PRIMARY KEY (`user_name`,`roles_role_id`),
KEY `FK5scdquo6f12cpstqai86x4biw` (`roles_role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_role`
--
LOCK TABLES `user_role` WRITE;
/*!40000 ALTER TABLE `user_role` DISABLE KEYS */;
INSERT INTO `user_role` VALUES ('admin',1),('fac1',2),('fac10',2),('fac11',2),('fac12',2),('fac13',2),('fac14',2),('fac15',2),('fac16',2),('fac17',2),('fac18',2),('fac19',2),('fac2',2),('fac20',2),('fac21',2),('fac22',2),('fac23',2),('fac24',2),('fac25',2),('fac26',2),('fac27',2),('fac28',2),('fac29',2),('fac3',2),('fac30',2),('fac31',2),('fac32',2),('fac34',2),('fac35',2),('fac36',2),('fac4',2),('fac5',2),('fac6',2),('fac7',2),('fac8',2),('fac9',2),('stud1',3),('stud10',3),('stud100',3),('stud101',3),('stud102',3),('stud103',3),('stud104',3),('stud105',3),('stud106',3),('stud107',3),('stud108',3),('stud109',3),('stud11',3),('stud110',3),('stud111',3),('stud112',3),('stud113',3),('stud114',3),('stud115',3),('stud116',3),('stud117',3),('stud118',3),('stud119',3),('stud12',3),('stud120',3),('stud121',3),('stud122',3),('stud123',3),('stud124',3),('stud125',3),('stud126',3),('stud127',3),('stud128',3),('stud129',3),('stud13',3),('stud130',3),('stud131',3),('stud132',3),('stud133',3),('stud134',3),('stud135',3),('stud136',3),('stud137',3),('stud138',3),('stud139',3),('stud14',3),('stud140',3),('stud141',3),('stud142',3),('stud143',3),('stud144',3),('stud145',3),('stud146',3),('stud147',3),('stud148',3),('stud149',3),('stud15',3),('stud150',3),('stud151',3),('stud152',3),('stud153',3),('stud154',3),('stud155',3),('stud156',3),('stud157',3),('stud158',3),('stud159',3),('stud16',3),('stud160',3),('stud161',3),('stud162',3),('stud163',3),('stud164',3),('stud165',3),('stud166',3),('stud167',3),('stud168',3),('stud169',3),('stud17',3),('stud170',3),('stud171',3),('stud172',3),('stud173',3),('stud174',3),('stud175',3),('stud176',3),('stud177',3),('stud178',3),('stud179',3),('stud18',3),('stud180',3),('stud181',3),('stud182',3),('stud183',3),('stud184',3),('stud185',3),('stud186',3),('stud187',3),('stud188',3),('stud189',3),('stud19',3),('stud190',3),('stud191',3),('stud192',3),('stud193',3),('stud194',3),('stud195',3),('stud196',3),('stud197',3),('stud198',3),('stud199',3),('stud2',3),('stud20',3),('stud200',3),('stud201',3),('stud202',3),('stud203',3),('stud204',3),('stud205',3),('stud206',3),('stud207',3),('stud208',3),('stud209',3),('stud21',3),('stud210',3),('stud211',3),('stud212',3),('stud213',3),('stud214',3),('stud215',3),('stud216',3),('stud217',3),('stud218',3),('stud219',3),('stud22',3),('stud220',3),('stud221',3),('stud222',3),('stud223',3),('stud224',3),('stud225',3),('stud226',3),('stud227',3),('stud228',3),('stud229',3),('stud23',3),('stud230',3),('stud231',3),('stud232',3),('stud233',3),('stud234',3),('stud235',3),('stud236',3),('stud237',3),('stud238',3),('stud239',3),('stud24',3),('stud240',3),('stud241',3),('stud242',3),('stud243',3),('stud244',3),('stud245',3),('stud246',3),('stud247',3),('stud248',3),('stud249',3),('stud25',3),('stud250',3),('stud251',3),('stud252',3),('stud253',3),('stud254',3),('stud255',3),('stud256',3),('stud257',3),('stud258',3),('stud259',3),('stud26',3),('stud260',3),('stud261',3),('stud262',3),('stud263',3),('stud264',3),('stud265',3),('stud266',3),('stud267',3),('stud268',3),('stud269',3),('stud27',3),('stud270',3),('stud271',3),('stud272',3),('stud273',3),('stud274',3),('stud275',3),('stud276',3),('stud277',3),('stud278',3),('stud279',3),('stud28',3),('stud280',3),('stud281',3),('stud282',3),('stud283',3),('stud284',3),('stud285',3),('stud286',3),('stud287',3),('stud288',3),('stud289',3),('stud29',3),('stud290',3),('stud291',3),('stud292',3),('stud293',3),('stud294',3),('stud295',3),('stud296',3),('stud297',3),('stud298',3),('stud299',3),('stud3',3),('stud30',3),('stud300',3),('stud301',3),('stud302',3),('stud303',3),('stud304',3),('stud305',3),('stud306',3),('stud307',3),('stud308',3),('stud309',3),('stud31',3),('stud310',3),('stud311',3),('stud312',3),('stud313',3),('stud314',3),('stud315',3),('stud316',3),('stud317',3),('stud318',3),('stud319',3),('stud32',3),('stud320',3),('stud321',3),('stud322',3),('stud323',3),('stud324',3),('stud325',3),('stud326',3),('stud327',3),('stud328',3),('stud329',3),('stud33',3),('stud330',3),('stud331',3),('stud332',3),('stud333',3),('stud334',3),('stud335',3),('stud336',3),('stud337',3),('stud338',3),('stud339',3),('stud34',3),('stud340',3),('stud341',3),('stud342',3),('stud343',3),('stud344',3),('stud345',3),('stud346',3),('stud347',3),('stud348',3),('stud349',3),('stud35',3),('stud350',3),('stud351',3),('stud352',3),('stud353',3),('stud354',3),('stud355',3),('stud356',3),('stud357',3),('stud358',3),('stud359',3),('stud36',3),('stud360',3),('stud361',3),('stud362',3),('stud363',3),('stud364',3),('stud365',3),('stud366',3),('stud367',3),('stud368',3),('stud369',3),('stud37',3),('stud370',3),('stud371',3),('stud372',3),('stud373',3),('stud374',3),('stud375',3),('stud376',3),('stud377',3),('stud378',3),('stud379',3),('stud38',3),('stud380',3),('stud381',3),('stud382',3),('stud383',3),('stud384',3),('stud385',3),('stud386',3),('stud387',3),('stud388',3),('stud389',3),('stud39',3),('stud390',3),('stud391',3),('stud392',3),('stud393',3),('stud394',3),('stud395',3),('stud396',3),('stud397',3),('stud398',3),('stud399',3),('stud4',3),('stud40',3),('stud400',3),('stud401',3),('stud402',3),('stud403',3),('stud404',3),('stud405',3),('stud406',3),('stud407',3),('stud408',3),('stud409',3),('stud41',3),('stud410',3),('stud411',3),('stud412',3),('stud413',3),('stud414',3),('stud415',3),('stud416',3),('stud417',3),('stud418',3),('stud419',3),('stud42',3),('stud420',3),('stud421',3),('stud422',3),('stud423',3),('stud424',3),('stud425',3),('stud426',3),('stud427',3),('stud428',3),('stud429',3),('stud43',3),('stud430',3),('stud431',3),('stud432',3),('stud433',3),('stud434',3),('stud435',3),('stud436',3),('stud437',3),('stud438',3),('stud439',3),('stud44',3),('stud440',3),('stud441',3),('stud442',3),('stud443',3),('stud444',3),('stud445',3),('stud446',3),('stud447',3),('stud448',3),('stud449',3),('stud45',3),('stud450',3),('stud451',3),('stud452',3),('stud453',3),('stud454',3),('stud455',3),('stud456',3),('stud457',3),('stud458',3),('stud459',3),('stud46',3),('stud460',3),('stud461',3),('stud462',3),('stud463',3),('stud464',3),('stud465',3),('stud466',3),('stud467',3),('stud468',3),('stud469',3),('stud47',3),('stud470',3),('stud471',3),('stud472',3),('stud473',3),('stud474',3),('stud475',3),('stud476',3),('stud477',3),('stud478',3),('stud479',3),('stud48',3),('stud480',3),('stud481',3),('stud482',3),('stud483',3),('stud484',3),('stud485',3),('stud486',3),('stud487',3),('stud488',3),('stud489',3),('stud49',3),('stud490',3),('stud491',3),('stud492',3),('stud493',3),('stud494',3),('stud495',3),('stud496',3),('stud497',3),('stud498',3),('stud499',3),('stud5',3),('stud50',3),('stud500',3),('stud501',3),('stud502',3),('stud503',3),('stud504',3),('stud505',3),('stud506',3),('stud507',3),('stud508',3),('stud509',3),('stud51',3),('stud510',3),('stud511',3),('stud512',3),('stud513',3),('stud514',3),('stud515',3),('stud516',3),('stud517',3),('stud518',3),('stud519',3),('stud52',3),('stud520',3),('stud521',3),('stud522',3),('stud523',3),('stud524',3),('stud525',3),('stud526',3),('stud527',3),('stud528',3),('stud529',3),('stud53',3),('stud530',3),('stud531',3),('stud532',3),('stud533',3),('stud534',3),('stud535',3),('stud536',3),('stud537',3),('stud538',3),('stud539',3),('stud54',3),('stud540',3),('stud541',3),('stud542',3),('stud543',3),('stud544',3),('stud545',3),('stud546',3),('stud547',3),('stud548',3),('stud549',3),('stud55',3),('stud550',3),('stud551',3),('stud552',3),('stud553',3),('stud554',3),('stud555',3),('stud556',3),('stud557',3),('stud558',3),('stud559',3),('stud56',3),('stud560',3),('stud561',3),('stud562',3),('stud563',3),('stud564',3),('stud565',3),('stud566',3),('stud567',3),('stud568',3),('stud569',3),('stud57',3),('stud570',3),('stud571',3),('stud572',3),('stud573',3),('stud574',3),('stud575',3),('stud576',3),('stud577',3),('stud578',3),('stud579',3),('stud58',3),('stud580',3),('stud581',3),('stud582',3),('stud583',3),('stud584',3),('stud585',3),('stud586',3),('stud587',3),('stud588',3),('stud589',3),('stud59',3),('stud590',3),('stud591',3),('stud592',3),('stud593',3),('stud594',3),('stud595',3),('stud596',3),('stud597',3),('stud598',3),('stud599',3),('stud6',3),('stud60',3),('stud600',3),('stud601',3),('stud602',3),('stud603',3),('stud604',3),('stud605',3),('stud606',3),('stud607',3),('stud608',3),('stud609',3),('stud61',3),('stud610',3),('stud611',3),('stud612',3),('stud613',3),('stud614',3),('stud615',3),('stud616',3),('stud617',3),('stud618',3),('stud619',3),('stud62',3),('stud620',3),('stud621',3),('stud622',3),('stud623',3),('stud624',3),('stud625',3),('stud626',3),('stud627',3),('stud628',3),('stud629',3),('stud63',3),('stud630',3),('stud631',3),('stud632',3),('stud633',3),('stud634',3),('stud635',3),('stud636',3),('stud637',3),('stud638',3),('stud639',3),('stud64',3),('stud640',3),('stud641',3),('stud642',3),('stud643',3),('stud644',3),('stud645',3),('stud646',3),('stud647',3),('stud648',3),('stud649',3),('stud65',3),('stud650',3),('stud651',3),('stud652',3),('stud653',3),('stud654',3),('stud655',3),('stud656',3),('stud657',3),('stud658',3),('stud659',3),('stud66',3),('stud660',3),('stud661',3),('stud662',3),('stud663',3),('stud664',3),('stud665',3),('stud666',3),('stud667',3),('stud668',3),('stud669',3),('stud67',3),('stud670',3),('stud671',3),('stud672',3),('stud673',3),('stud674',3),('stud675',3),('stud676',3),('stud677',3),('stud678',3),('stud679',3),('stud68',3),('stud680',3),('stud681',3),('stud682',3),('stud683',3),('stud684',3),('stud685',3),('stud686',3),('stud687',3),('stud688',3),('stud689',3),('stud69',3),('stud690',3),('stud691',3),('stud692',3),('stud693',3),('stud694',3),('stud695',3),('stud696',3),('stud697',3),('stud698',3),('stud699',3),('stud7',3),('stud70',3),('stud700',3),('stud701',3),('stud702',3),('stud703',3),('stud704',3),('stud705',3),('stud706',3),('stud707',3),('stud708',3),('stud709',3),('stud71',3),('stud710',3),('stud711',3),('stud712',3),('stud713',3),('stud714',3),('stud715',3),('stud716',3),('stud717',3),('stud718',3),('stud719',3),('stud72',3),('stud720',3),('stud721',3),('stud722',3),('stud723',3),('stud724',3),('stud725',3),('stud726',3),('stud727',3),('stud728',3),('stud729',3),('stud73',3),('stud730',3),('stud731',3),('stud732',3),('stud733',3),('stud734',3),('stud735',3),('stud736',3),('stud737',3),('stud738',3),('stud739',3),('stud74',3),('stud740',3),('stud741',3),('stud742',3),('stud743',3),('stud744',3),('stud745',3),('stud746',3),('stud747',3),('stud748',3),('stud749',3),('stud75',3),('stud750',3),('stud751',3),('stud752',3),('stud753',3),('stud754',3),('stud755',3),('stud756',3),('stud757',3),('stud758',3),('stud759',3),('stud76',3),('stud760',3),('stud761',3),('stud762',3),('stud763',3),('stud764',3),('stud765',3),('stud766',3),('stud767',3),('stud768',3),('stud769',3),('stud77',3),('stud770',3),('stud771',3),('stud772',3),('stud773',3),('stud774',3),('stud775',3),('stud776',3),('stud777',3),('stud778',3),('stud779',3),('stud78',3),('stud780',3),('stud781',3),('stud782',3),('stud783',3),('stud784',3),('stud785',3),('stud786',3),('stud787',3),('stud788',3),('stud789',3),('stud79',3),('stud790',3),('stud791',3),('stud792',3),('stud793',3),('stud794',3),('stud795',3),('stud796',3),('stud797',3),('stud798',3),('stud799',3),('stud8',3),('stud80',3),('stud800',3),('stud801',3),('stud802',3),('stud803',3),('stud804',3),('stud805',3),('stud806',3),('stud807',3),('stud808',3),('stud809',3),('stud81',3),('stud810',3),('stud811',3),('stud812',3),('stud813',3),('stud814',3),('stud815',3),('stud816',3),('stud817',3),('stud818',3),('stud819',3),('stud82',3),('stud820',3),('stud821',3),('stud822',3),('stud823',3),('stud824',3),('stud825',3),('stud826',3),('stud827',3),('stud828',3),('stud829',3),('stud83',3),('stud830',3),('stud831',3),('stud832',3),('stud833',3),('stud834',3),('stud835',3),('stud836',3),('stud837',3),('stud838',3),('stud839',3),('stud84',3),('stud840',3),('stud841',3),('stud842',3),('stud843',3),('stud844',3),('stud845',3),('stud846',3),('stud847',3),('stud848',3),('stud849',3),('stud85',3),('stud850',3),('stud851',3),('stud852',3),('stud853',3),('stud854',3),('stud855',3),('stud856',3),('stud857',3),('stud858',3),('stud859',3),('stud86',3),('stud860',3),('stud861',3),('stud862',3),('stud863',3),('stud864',3),('stud865',3),('stud866',3),('stud867',3),('stud868',3),('stud869',3),('stud87',3),('stud870',3),('stud871',3),('stud872',3),('stud873',3),('stud874',3),('stud875',3),('stud876',3),('stud877',3),('stud878',3),('stud879',3),('stud88',3),('stud880',3),('stud89',3),('stud9',3),('stud90',3),('stud91',3),('stud92',3),('stud93',3),('stud94',3),('stud95',3),('stud96',3),('stud97',3),('stud98',3),('stud99',3);
/*!40000 ALTER TABLE `user_role` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2019-06-08 14:05:17