--
-- Host: localhost    Database: csschedule_new
-- ------------------------------------------------------


--
-- Table structure for table `courseassignment`
--

CREATE TABLE `courseassignment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `facultyid` int(11) NOT NULL,
  `lastname` varchar(30) DEFAULT NULL,
  `firstname` varchar(30) DEFAULT NULL,
  `course` varchar(20) DEFAULT NULL,
  `section` int(11) DEFAULT NULL,
  `days` varchar(10) DEFAULT NULL,
  `notofferattime` varchar(100) DEFAULT NULL,
  `term` int(11) DEFAULT NULL,
  `type` varchar(10) DEFAULT NULL,
  `department` varchar(20) NOT NULL DEFAULT 'cs',
  `assignedday` varchar(6) DEFAULT NULL,
  `assignedtime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1013 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `courseassignment`
--

INSERT INTO `courseassignment` VALUES (969,1,'Cao','Tina','COMPSCI 162',1,'MW','',NULL,'regular','cs','',''),(970,1,'Cao','Tina','COMPSCI 220',1,'MW,TR','',NULL,'regular','cs','MW','200'),(971,1,'Cao','Tina','COMPSCI 381',1,'MW,TR','',NULL,'regular','cs','',''),(972,1,'Cao','Tina','COMPSCI 382',1,'MW,TR','',NULL,'regular','cs','',''),(973,13,'Dorney','Mark','CY 101',1,'MW,TR','500',NULL,'regular','cs','',''),(974,3,'Gunawardena','Athula','COMPSCI 162',2,'TR','',NULL,'online','cs','',''),(975,3,'Gunawardena','Athula','COMPSCI 162',3,'','',NULL,'online','cs','',''),(976,3,'Gunawardena','Athula','COMPSCI 271',1,'MW','500',NULL,'regular','cs','',''),(977,3,'Gunawardena','Athula','COMPSCI 271',2,'TR','500',NULL,'regular','cs','',''),(978,3,'Gunawardena','Athula','COMPSCI 739',1,'M,T,W,R','930;1100;1230;200;330',NULL,'regular','cs','',''),(979,2,'Gunguly','Arnab','COMPSCI 223',1,'MW','500',NULL,'regular','cs','',''),(980,2,'Gunguly','Arnab','COMPSCI 223',2,'TR','500',NULL,'regular','cs','',''),(981,2,'Gunguly','Arnab','COMPSCI 433',1,'MW,TR','500',NULL,'regular','cs','',''),(982,2,'Gunguly','Arnab','COMPSCI 738',1,'M,T,W,R','930;1100;1230;200;330',NULL,'regular','cs','',''),(983,4,'Ma','Jiehui','COMPSCI 162',4,'MW,TR','',NULL,'regular','cs','',''),(984,4,'Ma','Jiehui','COMPSCI 170',1,'MW,TR','',NULL,'regular','cs','',''),(985,4,'Ma','Jiehui','COMPSCI 172',1,'MW','',NULL,'regular','cs','',''),(986,4,'Ma','Jiehui','COMPSCI 181',1,'MW,TR','',NULL,'regular','cs','',''),(987,5,'Maresso','Brian','COMPSCI 165',1,'MW,TR','',NULL,'regular','cs','',''),(988,5,'Maresso','Brian','COMPSCI 172',2,'MW,TR','',NULL,'regular','cs','',''),(989,5,'Maresso','Brian','COMPSCI 221',1,'MW,TR','',NULL,'regular','cs','',''),(990,5,'Maresso','Brian','COMPSCI 222',1,'MW,TR','',NULL,'regular','cs','',''),(991,5,'Maresso','Brian','COMPSCI 460',1,'MW,TR','',NULL,'regular','cs','',''),(992,6,'Mukherjee','Lopamudra','COMPSCI 215',1,'MW,TR','',NULL,'regular','cs','',''),(993,6,'Mukherjee','Lopamudra','COMPSCI 215',2,'','',NULL,'online','cs','',''),(994,6,'Mukherjee','Lopamudra','COMPSCI 736',1,'','',NULL,'online','cs','',''),(995,7,'Nguyen','Hien','COMPSCI 332',1,'MW,TR','',NULL,'regular','cs','',''),(996,7,'Nguyen','Hien','COMPSCI 366',1,'MW','',NULL,'regular','cs','',''),(997,7,'Nguyen','Hien','COMPSCI 366',2,'TR','500',NULL,'regular','cs','',''),(998,8,'Oster','Zachary','COMPSCI 424',1,'MW,TR','500',NULL,'regular','cs','',''),(999,8,'Oster','Zachary','COMPSCI 434',1,'MW,TR','500',NULL,'regular','cs','',''),(1000,8,'Oster','Zachary','COMPSCI 476',1,'MW,TR','500',NULL,'regular','cs','',''),(1001,8,'Oster','Zachary','COMPSCI 776',1,'M,T,W,R','930;1100;1230;200;330',NULL,'regular','cs','',''),(1002,14,'Ozgur','Ozgur','COMPSCI 412',1,'MW,TR','',NULL,'regular','cs','',''),(1003,10,'Samaranayake','Sobitha','COMPSCI 482',1,'MW,TR','',NULL,'regular','cs','TR','200'),(1004,15,'Schoeneck','Andrew','CY 742',1,'','',NULL,'online','cs','',''),(1005,11,'Sharma','Chandra','COMPSCI 174',1,'MW,TR','',NULL,'regular','cs','',''),(1006,11,'Sharma','Chandra','COMPSCI 174',2,'MW,TR','',NULL,'regular','cs','',''),(1007,11,'Sharma','Chandra','COMPSCI 456',1,'MW,TR','',NULL,'regular','cs','',''),(1008,11,'Sharma','Chandra','CY 752',1,'','',NULL,'online','cs','',''),(1009,9,'Wei','Ruzhen','COMPSCI 353',1,'MW,TR','',NULL,'regular','cs','',''),(1010,9,'Wei','Ruzhen','COMPSCI 740',1,'','',NULL,'online','cs','',''),(1011,12,'Zhou','Jiazhen','COMPSCI 354',1,'MW,TR','',NULL,'regular','cs','',''),(1012,12,'Zhou','Jiazhen','COMPSCI 755',1,'','',NULL,'online','cs','','');

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `course` varchar(12) NOT NULL,
  `title` text DEFAULT NULL,
  `credits` int(1) DEFAULT NULL,
  `semester` char(2) DEFAULT NULL,
  `sections` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` VALUES ('COMPSCI 162','COMPUTER APPLICATIONS',3,'A',3),('COMPSCI 165','INTRODUCTION TO COMPUTATIONAL THINKING',3,'A',0),('COMPSCI 170','Introduction to Python Programming',3,'A',1),('COMPSCI 171','INTRODUCTION TO  PROGRAMMING ',3,'-1',5),('COMPSCI 172','INTRODUCTION TO OBJECT-ORIENTED PROGRAMMING IN JAVA ',3,'A',0),('COMPSCI 174',' INTRODUCTION TO C++ ',3,'A',0),('COMPSCI 180',NULL,3,'A',4),('COMPSCI 181','INTRODUCTION TO DATABASE AND THE WEB',3,'-1',0),('COMPSCI 215',' DISCRETE STRUCTURES',3,'A',0),('COMPSCI 220','CONCEPTS OF PROGRAMMING',3,'A',0),('COMPSCI 221','Intermediate Programming in C#',3,'F',0),('COMPSCI 222','INTERMEDIATE C++ ',3,'A',0),('COMPSCI 223','ADVANCED C++',3,'A',0),('COMPSCI 271','ASSEMBLY PROGRAMMING',3,'A',0),('COMPSCI 310','INTERMEDIATE DATA SCIENCE',3,'A',0),('COMPSCI 320','CONCEPTS OF PROGRAMMING LANGUAGES',3,'F',0),('COMPSCI 322','COMPUTER LANGUAGES AND  COMPILERS',3,'S',0),('COMPSCI 332','INTRODUCTION TO ARTIFICIAL INTELLIGENCE',3,'F',0),('COMPSCI 342','DIGITAL FORENSICS',3,'A',0),('COMPSCI 347','Scientific Computing',3,'SE',0),('COMPSCI 353','Cyber Security',3,'A',0),('COMPSCI 354','INTRUSION DETECTION AND INCIDENT RESPONSE',3,'F',0),('COMPSCI 366','DATABASE MANAGEMENT SYSTEMS',3,'A',0),('COMPSCI 381','JAVASCRIPT AND DHTML ',3,'A',0),('COMPSCI 382','SERVER SIDE SCRIPTING',3,'A',0),('COMPSCI 412','COMPUTER ORGANIZATION AND SYSTEM PROGRAMMING',3,'A',0),('COMPSCI 424','OPERATING SYSTEMS',3,'S',0),('COMPSCI 433','THEORY OF ALGORITHMS',3,'A',0),('COMPSCI 434','THEORY OF COMPUTATION',3,'S',0),('COMPSCI 448',NULL,NULL,'S',0),('COMPSCI 451','TOPICS IN APPLIED COMPUTING',3,'A',0),('COMPSCI 455','NETWORK SECURITY',3,'F',0),('COMPSCI 460','COMPUTER NETWORKING',3,'S',0),('COMPSCI 461','MOBILE COMPUTING ARCHITECTURE',3,'S',0),('COMPSCI 476','Software Engineering',3,'A',0),('COMPSCI 481','WEB SERVER AND UNIX  ADMINISTRATION',3,'F',0),('COMPSCI 482','WEB DATABASE DEVELOPMENT',3,'S',0),('COMPSCI 485','PROJECT',3,'n',0),('COMPSCI 490','WORKSHOP',1,'n',0),('COMPSCI 494','SEMINAR',2,'n',0),('COMPSCI 496','SPECIAL STUDIES',1,'n',0),('COMPSCI 498','INDEPENDENT STUDY IN COMPUTER SCIENCE ',1,'n',0),('COMPSCI 724','OPERATING SYSTEMS IN PRACTICE',3,'SE',0),('COMPSCI 732','MACHINE LEARNING',3,'A',0),('COMPSCI 733','ADVANCED ALGORITHM DESIGN AND ANALYSIS',3,'F',0),('COMPSCI 735','OPTIMIZATION: TECHNIQUES AND APPLICATIONS',3,'SO',0),('COMPSCI 736','IMAGE PROCESSING AND COMPUTER VISION',3,'S',0),('COMPSCI 750','System and Software Security',3,'F',0),('COMPSCI 762','CRYPTOGRAPHY AND CLOUD SECURITY',3,'S',0),('COMPSCI 764','CLOUD COMPUTING',3,'S',0),('COMPSCI 766','ADVANCED DATABASES',3,'F',0),('COMPSCI 767',' BIG DATA AND DATA MINING',3,'S',0),('COMPSCI 776','ADVANCED SOFTWARE ENGINEERING',3,'S',0),('COMPSCI 796','Special Topics - Computer Security',3,'A',0),('CYBER 101','INTRODUCTION TO CYBERSECURITY',3,'A',0),('CYBER 459','Systems Security Engineering',3,'F',0),('CYBER 701','System Fundamentals for Cybersecurity',3,'A',0),('CYBER 754','Cyber 2',3,'F',0),('CYBER 759','Topics in Cybersecurity',3,'F',0);

--
-- Table structure for table `facultyavailability`
--

CREATE TABLE `facultyavailability` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `facultyid` varchar(30) NOT NULL,
  `faculty` varchar(30) NOT NULL,
  `days` varchar(15) NOT NULL,
  `hours` varchar(200) NOT NULL,
  `comments` varchar(200) NOT NULL,
  `department` varchar(15) NOT NULL DEFAULT 'cs',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `facultyavailability`
--

INSERT INTO `facultyavailability` VALUES (31,'1','Cao, Tina','MW,TR,R','MW,TR:930,1100,1230,200,330,500','','cs'),(32,'3','Gunawardena, Athula','MW,TR,R','MW:1100,1230,200,330,500;TR:1100,1230,200,330;M:500;T:500;W:500;R:500','','cs'),(33,'2','Gunguly, Arnab','MW,TR,R','MW:1100,1230,200,330,500;TR:1100,1230,200,330;M:500;T:500;W:500;R:500','','cs'),(34,'4','Ma, Jiehui','MW,TR,R','MW,TR:930,1100,1230,200,330,500','','cs'),(35,'5','Maresso, Brian','MW,TR,R','MW,TR:930,1100,1230,200,330,500','','cs'),(36,'6','Mukherjee, Lopamudra','MW,TR,R','MW:1100,1230,200,330,500;TR:1100,1230,200,330;M:500;T:500;W:500;R:500','','cs'),(37,'7','Nguyen, Hien','MW,TR,R','MW,TR:930,1100,1230,200,330,500','','cs'),(38,'8','Oster, Zachary','MW,TR,R','MW:1100,1230,200,330,500;TR:1100,1230,200,330;M:500;T:500;W:500;R:500','','cs'),(39,'14','Ozgur, Ozgur','MW,TR,R','MW,TR:930,1100,1230,200,330,500','','cs'),(40,'10','Samaranayake, Sobitha','MW,TR,R','TR:930,1100,1230,200,500','','cs'),(41,'15','Schoeneck, Andrew','MW,TR,R','MW,TR:930,1100,1230,200,330,500','','cs'),(42,'11','Sharma, Chandra','MW,TR,R','MW,TR:930,1100,1230,200,330,500','','cs'),(43,'9','Wei, Ruzhen','MW,TR,R','MW,TR:930,1100,1230,200,330,500','','cs'),(44,'12','Zhou, Jiazhen','MW,TR,R','MW,TR:930,1100,1230,200,330,500','','cs'),(45,'13','Dorney, Mark','MW,TR,R','MW,TR:930,1100,1230,200,330,500','','cs');

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `locationid` int(11) NOT NULL AUTO_INCREMENT,
  `location` varchar(20) NOT NULL,
  `course` varchar(20) NOT NULL,
  `capacity` int(11) NOT NULL DEFAULT 35,
  `priority` int(11) NOT NULL DEFAULT 10,
  `block` varchar(100) NOT NULL DEFAULT '-1',
  `hours` varchar(200) DEFAULT NULL,
  `unavailable` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`locationid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` VALUES (1,'MG115','all',35,10,'2','MW:930;MW:1100;MW:1230;MW:200;MW:330;MW:500;TR:930;TR:1100;TR:1230;TR:200;TR:330;TR:500',NULL),(2,'MG125','all',35,10,'-1','MW:930;MW:1100;MW:1230;MW:200;MW:330;MW:500;TR:930;TR:1100;TR:1230;TR:200;TR:330;TR:500',NULL),(3,'MG117','all',35,10,'-1','MW:930;MW:330;MW:500;TR:930;TR:330;TR:500','MW:1100,MW1230,MW:200;TR:1100,TR:1230,TR:200'),(4,'HY210','all',35,10,'-1','MW:930;MW:1100;MW:1230;MW:200;MW:330;MW:500;TR:930;TR:1100;TR:1230;TR:200;TR:330;TR:500',NULL);

--
-- Table structure for table `preferences`
--

CREATE TABLE `preferences` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `faculty` int(11) NOT NULL,
  `courses` varchar(1000) NOT NULL,
  `days` varchar(200) NOT NULL,
  `hours` varchar(300) NOT NULL,
  `cells` varchar(2000) NOT NULL,
  `selection` varchar(1000) DEFAULT NULL,
  `comments` varchar(1000) NOT NULL,
  `term` int(11) NOT NULL,
  `year` int(11) NOT NULL DEFAULT 2020,
  `semester` varchar(12) NOT NULL DEFAULT 'Fall',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `preferences`
--

INSERT INTO `preferences` VALUES (11,10,'[{\"course\":\"COMPSCI 482\",\"location\":\"MG115\",\"format\":\"Traditional\"},{\"course\":\"COMPSCI 382\",\"location\":\"MG115\",\"format\":\"Hybrid\"},{\"course\":\"COMPSCI 381\",\"location\":null,\"format\":\"Online\",\"online\":null}]','[0,2,4]','[0]','[{\"cell\":\"T15\",\"label\":\"T 3:00 - 4:00 pm\"},{\"cell\":\"T16\",\"label\":\"T 4:00 - 5:00 pm\"}]','','this is a test too',0,2020,'Fall'),(12,1,'[{\"course\":\"COMPSCI 162\",\"location\":null,\"format\":\"Online\"},{\"course\":\"COMPSCI 174\",\"location\":\"MG115\",\"format\":\"Traditional\"},{\"course\":\"COMPSCI 381\",\"location\":null,\"format\":\"Traditional\"}]','[]','[0,9,10]','[{\"cell\":\"F9\",\"label\":\"F 9:00 - 10:00 am \"}]','','I am not available to teach at 8:00am and after 5:00pm because I need to drop off and pick up kid at day care. I also prefer to teach CS162 as hybid,  I can also teach CS174 and CS381 in hybrid format.  If scheduling me to teach back to back courses, I prefer to stay in the same classroom.   I prefer to teach on Friday starting from 11:00am so that I will not miss some of the  research talks and colloquium hosted by our department.\n\nSorry for multiple preference schedules that I sent.  This is the final version.',0,2020,'Fall'),(13,162,'[{\"course\":\"COMPSCI 412\",\"location\":\"MG125\",\"format\":\"Hybrid\"},{\"course\":\"COMPSCI 172\",\"location\":\"MG125\",\"format\":\"Hybrid\"},{\"course\":\"COMPSCI 382\",\"location\":\"MG125\",\"format\":\"Hybrid\"}]','[]','[0,1,10]','[]','','',0,2020,'Fall'),(14,4,'[{\"course\":\"COMPSCI 170\",\"location\":\"MG115\",\"format\":\"Hybrid\"},{\"course\":\"COMPSCI 174\",\"location\":\"MG115\",\"format\":\"Hybrid\"},{\"course\":\"COMPSCI 172\",\"location\":\"MG115\",\"format\":\"Hybrid\"},{\"course\":\"COMPSCI 171\",\"location\":\"MG115\",\"format\":\"Hybrid\"},{\"course\":\"COMPSCI 162\",\"location\":\"MG115\",\"format\":\"Hybrid\"}]','[]','[]','[]','','',0,2020,'Fall'),(15,8,'[{\"course\":\"COMPSCI 476\",\"location\":\"HY210\",\"format\":\"Traditional\"},{\"course\":\"COMPSCI 320\",\"location\":\"MG115\",\"format\":\"Traditional\"},{\"course\":\"COMPSCI 481\",\"location\":\"MG125\",\"format\":\"Traditional\"},{\"course\":\"COMPSCI 271\",\"location\":\"MG125\",\"format\":\"Hybrid\"},{\"course\":\"COMPSCI 215\",\"location\":\"MG115\",\"format\":\"Traditional\"}]','[]','[]','[{\"cell\":\"W18\",\"label\":\"W 6:00 - 7:00 pm\"},{\"cell\":\"M18\",\"label\":\"M 6:00 - 7:00 pm\"},{\"cell\":\"R14\",\"label\":\"R 2:00 - 3:00 pm\"},{\"cell\":\"R15\",\"label\":\"R 3:00 - 4:00 pm\"},{\"cell\":\"F14\",\"label\":\"F 2:00 - 3:00 pm\"}]','','Scheduling constraints:  \nUniversity/Community Band, every Mon, starting at 6:30pm; \nchurch choir rehearsal, one Wed per month, 6:00-7:00pm (can teach Wed 5:00-6:15pm if needed); \nCollege Curriculum Committee, every other Thu, 2:00pm to sometimes 4:00pm; \nUniversity Curriculum Committee, every other Fri, 2:15pm until sometimes 4:15pm. \n\nRoom selection:  \nMy room preferences are weak preferences. Feel free to ignore them. COMPSCI 215 and 476 can be taught in a non-lab classroom with no problems. If 476 is taught in a lab classroom, I prefer Hyer 210 because it works best for group meetings during class time. \n\nTeaching format:\n* I&#039;ve taught COMPSCI 271 (both x86 and MIPS assembly) in a hybrid format before during summers, so I can teach it as either traditional or hybrid during the semester. \n* I can move COMPSCI 476 to a hybrid format if needed to free up classroom space, though I prefer fully in-person if possible.\n* At this time, I am not ready to move any of my classes fully on',0,2020,'Fall'),(16,7,'[{\"course\":\"COMPSCI 366\",\"location\":\"MG115\",\"format\":\"Traditional\"},{\"course\":\"COMPSCI 332\",\"location\":\"MG115\",\"format\":\"Traditional\"}]','[]','[0,7,8,9,10]','[]','','I could take 766 too just in case',0,2020,'Fall'),(17,127,'[{\"course\":\"COMPSCI 181\",\"location\":\"MG125\",\"format\":\"Traditional\"}]','[]','[0,1,8,9,10]','[]','','',0,2020,'Fall'),(18,160,'[{\"course\":\"COMPSCI 170\",\"location\":null,\"format\":\"Online\"},{\"course\":\"COMPSCI 310\",\"location\":\"HY210\",\"format\":\"Hybrid\"},{\"course\":\"COMPSCI 180\",\"location\":\"HY210\",\"format\":\"Hybrid\"}]','[4]','[0,9,10]','[]','','',0,2020,'Fall'),(19,2,'[{\"course\":\"COMPSCI 162\",\"location\":null,\"format\":\"Online\"},{\"course\":\"COMPSCI 271\",\"location\":\"MG115\",\"format\":\"Hybrid\"},{\"course\":\"COMPSCI 733\",\"location\":\"MG125\",\"format\":\"Traditional\"}]','[3]','[0,1]','[]','','College Standard Committee    R 3:30-5:00pm',0,2020,'Fall'),(20,14,'[{\"course\":\"COMPSCI 462\",\"location\":\"MG115\",\"format\":\"Traditional\"},{\"course\":\"COMPSCI 764\",\"location\":\"MG125\",\"format\":\"Traditional\"},{\"course\":\"COMPSCI 796\",\"location\":\"MG125\",\"format\":\"Traditional\"}]','[]','[]','[]','','I will create a COMPSCI 796 B course for topics in Advanced System Security.',0,2020,'Fall'),(21,3,'[{\"course\":\"COMPSCI 223\",\"location\":\"MG115\",\"format\":\"Traditional\"},{\"course\":\"COMPSCI 433\",\"location\":\"MG115\",\"format\":\"Traditional\"},{\"course\":\"COMPSCI 796\",\"location\":\"MG115\",\"format\":\"Traditional\"}]','[4]','[0,1,2]','[]','','',0,2020,'Fall'),(22,124,'[{\"course\":\"COMPSCI 381\",\"location\":\"MG115\",\"format\":\"Online\"},{\"course\":\"COMPSCI 382\",\"location\":\"MG115\",\"format\":\"Hybrid\"}]','[0,2,4]','[4,6]','[{\"cell\":\"W16\",\"label\":\"W 4:00 - 5:00 pm\"},{\"cell\":\"R10\",\"label\":\"R 10:00 - 11:00 am \"},{\"cell\":\"R14\",\"label\":\"R 2:00 - 3:00 pm\"}]','','this is a test too',2,2020,'Fall'),(23,106,'[{\"course\":\"COMPSCI 434\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null}]','[]','[0,9,10]','[{\"cell\":\"M14\",\"label\":\"M 2:00 - 3:00 pm\"}]','','       I am happy teaching in whatever room is available, since I do not need students to have access to the Internet or a computer during class.   If someone else would like to teach 434, I can&#039;t think of anything else that I could teach equally well.  ',2,2020,'Fall'),(24,120,'[{\"course\":\"COMPSCI 767\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 310\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 220\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null}]','[]','[0]','[]','','',2,2020,'Fall'),(25,116,'[{\"course\":\"COMPSCI 170\",\"location\":\"MG115\",\"format\":\"Hybrid\",\"online\":null},{\"course\":\"COMPSCI 172\",\"location\":\"MG115\",\"format\":\"Hybrid\",\"online\":null},{\"course\":\"COMPSCI 174\",\"location\":\"MG115\",\"format\":\"Hybrid\",\"online\":null},{\"course\":\"COMPSCI 162\",\"location\":\"MG115\",\"format\":\"Hybrid\",\"online\":null},{\"course\":\"COMPSCI 181\",\"location\":\"MG115\",\"format\":\"Hybrid\",\"online\":null}]','[]','[]','[]','','',2,2020,'Fall'),(26,6,'[{\"course\":\"COMPSCI 732\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 433\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 162\",\"location\":\"MG115\",\"format\":\"Online\",\"online\":null},{\"course\":\"COMPSCI 170\",\"location\":\"MG115\",\"format\":\"Online\",\"online\":null},{\"course\":\"COMPSCI 412\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 215\",\"location\":\"MG125\",\"format\":\"Hybrid\",\"online\":null}]','[]','[]','[]','','',2,2020,'Fall'),(27,161,'[{\"course\":\"COMPSCI 223\",\"location\":\"MG115\",\"format\":\"Hybrid\",\"online\":\"R\"},{\"course\":\"COMPSCI 433\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null}]','[4]','[0,1,2]','[]','','Because of my commute and recent health issues, I will be grateful if I could get a 3 day (MTW) teaching schedule, with the 223 online on Thursday.\nAlso, I was not sure if I am supposed to teach anything other than two sections each of Algorithms and Data Structures; let me know if something else is needed to be taught.',2,2020,'Fall'),(28,150,'[{\"course\":\"COMPSCI 755\",\"location\":null,\"format\":\"Hybrid\",\"online\":null},{\"course\":\"COMPSCI 456\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 460\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 354\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null}]','[4]','[0]','[]','','I will teach 3 courses.',2,2020,'Fall'),(29,159,'[{\"course\":\"COMPSCI 162\",\"location\":null,\"format\":\"Hybrid\",\"online\":\"R\"},{\"course\":\"COMPSCI 162\",\"location\":null,\"format\":\"Online\",\"online\":null},{\"course\":\"COMPSCI 174\",\"location\":null,\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 381\",\"location\":null,\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 180\",\"location\":null,\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 171\",\"location\":null,\"format\":\"Traditional\",\"online\":null}]','[]','[0,9,10]','[]','','I can also teach CS381 and CS174 as hybrid courses.  I can also other courses if our department needed.',2,2020,'Fall'),(30,158,'[{\"course\":\"COMPSCI 476\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 776\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 424\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 322\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 215\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 434\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null}]','[]','[]','[{\"cell\":\"R14\",\"label\":\"R 2:00 - 3:00 pm\"},{\"cell\":\"R15\",\"label\":\"R 3:00 - 4:00 pm\"},{\"cell\":\"R16\",\"label\":\"R 4:00 - 5:00 pm\"},{\"cell\":\"F14\",\"label\":\"F 2:00 - 3:00 pm\"},{\"cell\":\"F15\",\"label\":\"F 3:00 - 4:00 pm\"},{\"cell\":\"F16\",\"label\":\"F 4:00 - 5:00 pm\"},{\"cell\":\"M18\",\"label\":\"M 6:00 - 7:00 pm\"},{\"cell\":\"F17\",\"label\":\"F 5:00 - 6:00 pm\"},{\"cell\":\"F18\",\"label\":\"F 6:00 - 7:00 pm\"}]','','You can give 424 to Haijian if he is interested in teaching it, and I won&#039;t be offended. It&#039;s on my list mostly because I&#039;ve taught it before.    \n\nScheduling constraints: University/Community Band, every Mon, starting at 6:30pm (can teach Mon/Wed 5:00-6:15pm if needed, but would rather not do that); College Curriculum Committee, every other Thu, 2:00pm to sometimes 4:00pm; University Curriculum Committee, every other Fri, 2:15pm until sometimes 4:15pm.    \n\nRoom selection: 476 is best taught in Hyer 210 because it is best for group work. All other room preferences are weak; feel free to ignore them. 215, 424, and 434 can be taught in a non-lab classroom with no problems.    \n\nTeaching format: I can move COMPSCI 476 to a hybrid format if needed to free up classroom space, though I prefer fully in-person. I am not ready to move any of my classes fully online. ',2,2020,'Fall'),(31,127,'[{\"course\":\"COMPSCI 181\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null}]','[]','[0,1,8,9,10]','[]','','I will teach cs 181 if needed but I would prefer teaching all math courses again\nI find it increasingly difficult to view the student lap top screens.\nI have had my glasses prescription changed twice this year without much improvement',2,2020,'Fall'),(32,162,'[{\"course\":\"COMPSCI 172\",\"location\":\"HY210\",\"format\":\"Online\",\"online\":null},{\"course\":\"COMPSCI 172\",\"location\":\"HY210\",\"format\":\"Online\",\"online\":null},{\"course\":\"COMPSCI 412\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 451\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null}]','[4]','[0,1,2,10]','[]','','',2,2020,'Fall'),(33,109,'[{\"course\":\"COMPSCI 162\",\"location\":null,\"format\":\"Online\",\"online\":null},{\"course\":\"COMPSCI 271\",\"location\":\"MG125\",\"format\":\"Hybrid\",\"online\":\"W\"},{\"course\":\"COMPSCI 271\",\"location\":\"MG125\",\"format\":\"Hybrid\",\"online\":\"R\"},{\"course\":\"COMPSCI 222\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 215\",\"location\":null,\"format\":\"Traditional\",\"online\":null}]','[]','[0,1]','[]','','',2,2020,'Fall'),(34,163,'[{\"course\":\"COMPSCI 174\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 222\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 460\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 461\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 332\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 162\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null}]','[4]','[0,1,10]','[]','','',2,2020,'Fall'),(35,124,'[{\"course\":\"COMPSCI 381\",\"location\":\"MG115\",\"format\":\"Online\"},{\"course\":\"COMPSCI 382\",\"location\":\"MG115\",\"format\":\"Hybrid\"}]','[0,2,4]','[4,6]','[{\"cell\":\"W16\",\"label\":\"W 4:00 - 5:00 pm\"},{\"cell\":\"R10\",\"label\":\"R 10:00 - 11:00 am \"},{\"cell\":\"R14\",\"label\":\"R 2:00 - 3:00 pm\"}]','','this is a test too',3,2020,'Fall'),(36,158,'[{\"course\":\"COMPSCI 476\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 320\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 481\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 215\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 271\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null}]','[]','[]','[{\"cell\":\"M18\",\"label\":\"M 6:00 - 7:00 pm\"},{\"cell\":\"T14\",\"label\":\"T 2:00 - 3:00 pm\"},{\"cell\":\"T15\",\"label\":\"T 3:00 - 4:00 pm\"},{\"cell\":\"T16\",\"label\":\"T 4:00 - 5:00 pm\"},{\"cell\":\"R14\",\"label\":\"R 2:00 - 3:00 pm\"},{\"cell\":\"R15\",\"label\":\"R 3:00 - 4:00 pm\"},{\"cell\":\"R16\",\"label\":\"R 4:00 - 5:00 pm\"},{\"cell\":\"F14\",\"label\":\"F 2:00 - 3:00 pm\"},{\"cell\":\"F15\",\"label\":\"F 3:00 - 4:00 pm\"}]','','I may also be teaching CYBER 701 (Systems Fundamentals for Cybersecurity) fully online during Fall 2020.    \n\nScheduling constraints: University/Community Band, every Mon, starting at 6:30pm; Faculty Senate, one Tue per month, 2:00pm to 5:00pm; College Curriculum Committee, every other Thu, 2:00pm to sometimes 4:00pm; University Curriculum Committee, every other Fri, 2:15pm until sometimes 4:15pm.    \n\nRoom selection: 476 is best taught in Hyer 210 because that room is best for group work. All other room preferences are weak; feel free to ignore them. COMPSCI 215 can be taught in a non-lab classroom with no problems, but the others should be taught in a lab (even 476 because of 2-3 weeks of in-class GitHub exercises).    \n\nTeaching format: I can move COMPSCI 476 or 271 to a hybrid format if needed to free up classroom space, though I prefer fully in-person if possible.',3,2020,'Fall'),(37,116,'[{\"course\":\"COMPSCI 170\",\"location\":null,\"format\":\"Hybrid\",\"online\":null},{\"course\":\"COMPSCI 180\",\"location\":null,\"format\":\"Hybrid\",\"online\":null},{\"course\":\"COMPSCI 172\",\"location\":null,\"format\":\"Hybrid\",\"online\":null},{\"course\":\"COMPSCI 174\",\"location\":null,\"format\":\"Hybrid\",\"online\":null},{\"course\":\"COMPSCI 162\",\"location\":null,\"format\":\"Hybrid\",\"online\":null}]','[]','[]','[]','','',3,2020,'Fall'),(38,159,'[{\"course\":\"COMPSCI 162\",\"location\":null,\"format\":\"Online\",\"online\":null},{\"course\":\"COMPSCI 381\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 174\",\"location\":\"MG115\",\"format\":\"Hybrid\",\"online\":\"W\"},{\"course\":\"COMPSCI 180\",\"location\":null,\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 181\",\"location\":null,\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 310\",\"location\":null,\"format\":\"Traditional\",\"online\":null}]','[]','[0,9,10]','[]','','I can teach CS162, and CS381 in hybrid format (no preferred in-class meeting day, any day is fine) as well. I can also teach CS170 (traditional or hybrid), CS220, and CS222 (preferred traditional format). ',3,2020,'Fall'),(39,150,'[{\"course\":\"COMPSCI 750\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 455\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null}]','[]','[]','[]','','Likely we also need to offer Cyber 754 (online) and I would like to teach it.',3,2020,'Fall'),(40,127,'[{\"course\":\"COMPSCI 181\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null}]','[]','[0,1]','[{\"cell\":\"R16\",\"label\":\"R 4:00 - 5:00 pm\"},{\"cell\":\"R17\",\"label\":\"R 5:00 - 6:00 pm\"}]','','',3,2020,'Fall'),(41,109,'[{\"course\":\"COMPSCI 733\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 162\",\"location\":null,\"format\":\"Online\",\"online\":null},{\"course\":\"COMPSCI 271\",\"location\":\"MG125\",\"format\":\"Hybrid\",\"online\":\"W\"},{\"course\":\"COMPSCI 271\",\"location\":\"MG125\",\"format\":\"Hybrid\",\"online\":\"R\"},{\"course\":\"COMPSCI 215\",\"location\":null,\"format\":\"Traditional\",\"online\":null}]','[]','[0,1,2]','[]','','',3,2020,'Fall'),(42,120,'[{\"course\":\"COMPSCI 332\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 366\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 766\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null}]','[4]','[]','[{\"cell\":\"M8\",\"label\":\"M 8:00 - 9:00 am \"},{\"cell\":\"M9\",\"label\":\"M 9:00 - 10:00 am \"},{\"cell\":\"M15\",\"label\":\"M 3:00 - 4:00 pm\"},{\"cell\":\"M16\",\"label\":\"M 4:00 - 5:00 pm\"},{\"cell\":\"M17\",\"label\":\"M 5:00 - 6:00 pm\"},{\"cell\":\"M18\",\"label\":\"M 6:00 - 7:00 pm\"},{\"cell\":\"T8\",\"label\":\"T 8:00 - 9:00 am \"},{\"cell\":\"T9\",\"label\":\"T 9:00 - 10:00 am \"},{\"cell\":\"W8\",\"label\":\"W 8:00 - 9:00 am \"},{\"cell\":\"W9\",\"label\":\"W 9:00 - 10:00 am \"},{\"cell\":\"R8\",\"label\":\"R 8:00 - 9:00 am \"},{\"cell\":\"R9\",\"label\":\"R 9:00 - 10:00 am \"},{\"cell\":\"F8\",\"label\":\"F 8:00 - 9:00 am \"},{\"cell\":\"F9\",\"label\":\"F 9:00 - 10:00 am \"},{\"cell\":\"R15\",\"label\":\"R 3:00 - 4:00 pm\"},{\"cell\":\"R17\",\"label\":\"R 5:00 - 6:00 pm\"},{\"cell\":\"R16\",\"label\":\"R 4:00 - 5:00 pm\"},{\"cell\":\"R18\",\"label\":\"R 6:00 - 7:00 pm\"},{\"cell\":\"W15\",\"label\":\"W 3:00 - 4:00 pm\"},{\"cell\":\"W18\",\"label\":\"W 6:00 - 7:00 pm\"},{\"cell\":\"W17\",\"label\":\"W 5:00 - 6:00 pm\"},{\"cell\":\"W16\",\"label\":\"W 4:00 - 5:00 pm\"}]','','',3,2020,'Fall'),(43,118,'[{\"course\":\"COMPSCI 162\",\"location\":\"MG115\",\"format\":\"Online\",\"online\":null},{\"course\":\"COMPSCI 215\",\"location\":\"MG125\",\"format\":\"Hybrid\",\"online\":\"W\"},{\"course\":\"COMPSCI 433\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 170\",\"location\":\"MG115\",\"format\":\"Online\",\"online\":null},{\"course\":\"COMPSCI 732\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 332\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null}]','[0]','[9,10]','[]','','',3,2020,'Fall'),(44,161,'[{\"course\":\"COMPSCI 223\",\"location\":\"MG115\",\"format\":\"Hybrid\",\"online\":\"R\"},{\"course\":\"COMPSCI 433\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 222\",\"location\":\"MG115\",\"format\":\"Traditional\",\"online\":null}]','[3,4]','[0,1,2]','[]','','Due to my commute, I will prefer if I could teach all the courses between Mon-Wed. The Spring 2020 schedule will work for me in Fall 2020 as well. Sorry for any inconvenience that I am causing.',3,2020,'Fall'),(45,162,'[{\"course\":\"COMPSCI 172\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 172\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 766\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 412\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null}]','[4]','[0,9,10]','[{\"cell\":\"R16\",\"label\":\"R 4:00 - 5:00 pm\"},{\"cell\":\"R15\",\"label\":\"R 3:00 - 4:00 pm\"},{\"cell\":\"M9\",\"label\":\"M 9:00 - 10:00 am \"}]','','',3,2020,'Fall'),(46,160,'[{\"course\":\"COMPSCI 310\",\"location\":\"HY210\",\"format\":\"Online\",\"online\":null},{\"course\":\"COMPSCI 310\",\"location\":\"HY210\",\"format\":\"Hybrid\",\"online\":\"W\"},{\"course\":\"COMPSCI 170\",\"location\":\"HY210\",\"format\":\"Online\",\"online\":null}]','[4]','[0,9,10]','[{\"cell\":\"M11\",\"label\":\"M 11:00am - noon \"},{\"cell\":\"W11\",\"label\":\"W 11:00am - noon \"},{\"cell\":\"F11\",\"label\":\"F 11:00am - noon \"}]','','',3,2020,'Fall'),(47,163,'[{\"course\":\"COMPSCI 174\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 174\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 222\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 455\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 332\",\"location\":\"MG125\",\"format\":\"Traditional\",\"online\":null}]','[]','[]','[{\"cell\":\"T11\",\"label\":\"T 11:00am - noon \"},{\"cell\":\"T12\",\"label\":\"T noon - 1:00 pm\"},{\"cell\":\"T13\",\"label\":\"T 1:00 - 2:00 pm\"},{\"cell\":\"W11\",\"label\":\"W 11:00am - noon \"},{\"cell\":\"W12\",\"label\":\"W noon - 1:00 pm\"},{\"cell\":\"W13\",\"label\":\"W 1:00 - 2:00 pm\"},{\"cell\":\"R11\",\"label\":\"R 11:00am - noon \"},{\"cell\":\"R12\",\"label\":\"R noon - 1:00 pm\"},{\"cell\":\"R13\",\"label\":\"R 1:00 - 2:00 pm\"},{\"cell\":\"M11\",\"label\":\"M 11:00am - noon \"},{\"cell\":\"M12\",\"label\":\"M noon - 1:00 pm\"},{\"cell\":\"M13\",\"label\":\"M 1:00 - 2:00 pm\"}]','','',3,2020,'Fall'),(48,124,'[{\"course\":\"COMPSCI 382\",\"location\":\"MG127\",\"format\":\"Traditional\",\"online\":null},{\"course\":\"COMPSCI 481\",\"location\":\"HY210\",\"format\":\"Traditional\",\"online\":null}]','[0,2,4]','[0,1,10]','[{\"cell\":\"T15\",\"label\":\"T 3:00 - 4:00 pm\"},{\"cell\":\"T16\",\"label\":\"T 4:00 - 5:00 pm\"}]',NULL,'eee',5,2020,'Fall');

--
-- Table structure for table `schedule`
--

CREATE TABLE `schedule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location` varchar(20) NOT NULL,
  `course` varchar(20) NOT NULL,
  `days` varchar(15) NOT NULL,
  `time` varchar(100) NOT NULL,
  `section` int(11) NOT NULL,
  `instructor` varchar(50) NOT NULL,
  `faculty` int(11) NOT NULL,
  `cells` varchar(50) NOT NULL,
  `duration` int(11) NOT NULL,
  `dayString` varchar(6) NOT NULL,
  `start` int(11) NOT NULL,
  `end` int(11) NOT NULL,
  `term` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `schedule`
--

INSERT INTO `schedule` VALUES (2,'MG115','COMPSCI 220','MW','11:00 AM - 12:15 PM',0,'Ganguly, Arnab',161,'M11:W11',75,'101000',1100,1215,3),(3,'HY210','COMPSCI 223','T','12:30 - 01:45PM',0,'Ganguly, Arnab',161,'T12',75,'010000',1230,1345,3),(4,'HY210','COMPSCI 223','T','05:00 PM - 07:30 PM',1,'Ganguly, Arnab',161,'T17',150,'010000',1700,1930,3),(5,'MG115','COMPSCI 433','MW','02:00 PM - 03:15 PM',0,'Ganguly, Arnab',161,'M14:W14',75,'101000',1400,1515,3),(6,'TBA','COMPSCI 162','Online','',0,'Gunawardena, Athula',109,'',0,'000000',0,0,3),(7,'HY210','COMPSCI 271','M','02:00 PM - 03:30 PM',0,'Gunawardena, Athula',109,'M14',75,'100000',1400,1530,3),(8,'MG125','COMPSCI 271','T','11:00 AM - 12:15 PM',1,'Gunawardena, Athula',109,'T11',75,'010000',1100,1215,3),(9,'MG125','COMPSCI 733','W','05:00 PM - 07:30 PM',0,'Gunawardena, Athula',109,'W17',150,'001000',1700,1930,3),(18,'HY210','COMPSCI 332','MW','11:00 AM - 12:15 PM',0,'Mukherjee, Lopamudra',118,'M11:W11',75,'101000',1100,1215,3),(19,'MG125','COMPSCI 732','R','05:00 PM - 07:30 PM',0,'Mukherjee, Lopamudra',118,'R17',150,'000100',1700,1930,3),(20,'MG125','COMPSCI 766','T','05:00 PM - 07:30 PM',0,'Nguyen, Hien',120,'T17',150,'010000',1700,1930,3),(21,'HY210','COMPSCI 366','TR','09:30 AM - 10:45 AM',0,'Nguyen, Hien',120,'T9:R9',115,'010100',930,1045,3),(22,'HY210','COMPSCI 476','MW','03:30 PM - 04:45 PM',0,'Oster, Zachary',158,'M15:W15',75,'101000',1530,1645,3),(23,'TBA','COMPSCI 701','Online','',0,'Oster, Zachary',158,'',0,'000000',0,0,3),(24,'MG115','COMPSCI 320','TR','12:30 PM - 01:45 PM',0,'Oster, Zachary',158,'T12:R12',75,'010100',1230,1345,3),(25,'TBA','COMPSCI 382','Online','02:00 PM - 03:15 PM',0,'Samaranayake, Sobitha',124,'W14',115,'000000',1400,1515,3),(27,'MG125','COMPSCI 174','MW','09:30 AM - 10:45 AM',0,'Sun, Haijian',164,'M9:W9',75,'101000',930,1045,3),(28,'MG115','COMPSCI 174','TR','02:00 PM - 03:15 PM',1,'Sun, Haijian',164,'T14:R14',75,'010100',1400,1515,3),(32,'TBA','COMPSCI 754','Online','',0,'Zhou, Jiazhen',150,'',0,'000000',0,0,3),(33,'MG125','COMPSCI 750','MW','03:30 PM - 04:45 PM',0,'Zhou, Jiazhen',150,'M15:W15',75,'101000',1530,1645,3),(34,'MG125','COMPSCI 455','TR','12:30 PM - 01:45 PM',0,'Zhou, Jiazhen',150,'T12:R12',75,'010100',1230,1345,3),(35,'MG125','COMPSCI 381','TR','09:30 AM - 10:45 AM',0,'Cao, Tina',159,'T9:R9',75,'010100',930,1045,3),(40,'MG115','COMPSCI 353','TR','11:00 AM - 12:15 PM',0,'Ruzhen',150,'T11:R11',75,'010100',1100,1215,3),(41,'HY210','COMPSCI 162','R','R12:30 - 01:45 PM',0,'Cao, Tina',159,'R12',75,'000100',1230,1345,3),(42,'TBA','COMPSCI 162','Online','',0,'Cao, Tina',159,'',0,'000000',0,0,3),(43,'MG115','COMPSCI 162','W','09:30 AM - 10:45 AM',0,'Cao, Tina',159,'W9',75,'001000',930,1045,3),(45,'HY210','COMPSCI 180','R','11:00 AM - 12:15 PM',0,'Kuzoff, Robert',160,'R11',75,'000100',1100,1215,3),(46,'TBA','COMPSCI 310','Online','',0,'Kuzoff, Robert',160,'',0,'000000',0,0,3),(47,'MG125','COMPSCI 170','R','11:00 AM - 12:15 PM',0,'Ma, Jiehui',116,'R11',75,'000100',1100,1215,3),(48,'TBA','COMPSCI 170','Online','',0,'Ma, Jiehui',116,'',0,'000000',0,0,3),(49,'MG115','COMPSCI 172','TR','09:30 AM - 10:45 AM',0,'Ma, Jiehui',116,'T9:R9',75,'010100',930,1045,3),(50,'MG125','COMPSCI 172','MW','02:00 PM - 03:15 PM',1,'Ma, Jiehui',116,'M14:W14',75,'101000',1400,1515,3),(51,'HY210','COMPSCI 215','T','11:00 AM - 12:15 PM',0,'Mukherjee, Lopamudra',118,'T11',75,'010000',1100,1215,3),(52,'MG115','COMPSCI 481','TR','05:00 PM - 06:15 PM',0,'Oster, Zachary',158,'T17:R17',75,'010100',1700,1815,3),(53,'MG125','COMPSCI 181','TR','02:00 PM - 03:15 PM',0,'Siemann, Bob',127,'T14:R14',75,'010100',1400,1515,3),(54,'MG125','COMPSCI 412','MW','11:00 AM - 12:15 PM',0,'Sun, Haijian',164,'M11:W11',75,'101000',1100,1215,3),(55,'MG115','COMPSCI 222','TR','03:30 PM - 04:45 PM',0,'Sun, Haijian',164,'T15:R15',75,'010100',1530,1645,3),(56,'HY210','COMPSCI 764','M','5:00 - 7:30pm',0,'Samaranayake, Sobitha',124,'M17',150,'100000',1700,1930,3);

--
-- Table structure for table `semesterschedule`
--

CREATE TABLE `semesterschedule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location` varchar(20) NOT NULL,
  `course` varchar(20) NOT NULL,
  `days` varchar(15) NOT NULL,
  `displaytime` varchar(100) DEFAULT NULL,
  `time` varchar(100) NOT NULL,
  `section` int(11) NOT NULL,
  `lastname` varchar(30) NOT NULL,
  `firstname` varchar(20) DEFAULT NULL,
  `facultyid` int(11) NOT NULL,
  `cells` varchar(50) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `dayString` varchar(6) DEFAULT NULL,
  `start` int(11) DEFAULT NULL,
  `end` int(11) DEFAULT NULL,
  `term` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1657 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `semesterschedule`
--

INSERT INTO `semesterschedule` VALUES (1621,'MG115','COMPSCI 162','MW','09:30 AM - 10:45 AM','930',1,'Cao','Tina',1,NULL,NULL,NULL,NULL,NULL,NULL),(1622,'HY210','COMPSCI 220','TR','12:30 PM - 01:45 PM','200',1,'Cao','Tina',1,NULL,NULL,NULL,NULL,NULL,NULL),(1623,'MG115','COMPSCI 381','MW','11:00 AM - 12:15 PM','1100',1,'Cao','Tina',1,NULL,NULL,NULL,NULL,NULL,NULL),(1624,'MG115','COMPSCI 382','MW','12:30 PM - 01:45 PM','1230',1,'Cao','Tina',1,NULL,NULL,NULL,NULL,NULL,NULL),(1625,'MG115','COMPSCI 738','M','05:00 PM - 07:30 PM','500',1,'Gunguly','Arnab',2,NULL,NULL,NULL,NULL,NULL,NULL),(1626,'MG115','COMPSCI 433','MW','03:30 PM - 04:45 PM','330',1,'Gunguly','Arnab',2,NULL,NULL,NULL,NULL,NULL,NULL),(1627,'MG115','COMPSCI 223','TR','11:00 AM - 12:15 PM','1100',2,'Gunguly','Arnab',2,NULL,NULL,NULL,NULL,NULL,NULL),(1628,'MG125','COMPSCI 223','MW','11:00 AM - 12:15 PM','1100',1,'Gunguly','Arnab',2,NULL,NULL,NULL,NULL,NULL,NULL),(1629,'MG125','COMPSCI 739','M','05:00 PM - 07:30 PM','500',1,'Gunawardena','Athula',3,NULL,NULL,NULL,NULL,NULL,NULL),(1630,'MG115','COMPSCI 271','TR','12:30 PM - 01:45 PM','1230',2,'Gunawardena','Athula',3,NULL,NULL,NULL,NULL,NULL,NULL),(1631,'MG125','COMPSCI 271','MW','02:00 PM - 03:15 PM','200',1,'Gunawardena','Athula',3,NULL,NULL,NULL,NULL,NULL,NULL),(1632,'MG115','COMPSCI 181','TR','09:30 AM - 10:45 AM','930',1,'Ma','Jiehui',4,NULL,NULL,NULL,NULL,NULL,NULL),(1633,'MG125','COMPSCI 172','MW','09:30 AM - 10:45 AM','930',1,'Ma','Jiehui',4,NULL,NULL,NULL,NULL,NULL,NULL),(1634,'MG115','COMPSCI 170','TR','02:00 PM - 03:15 PM','200',1,'Ma','Jiehui',4,NULL,NULL,NULL,NULL,NULL,NULL),(1635,'MG115','COMPSCI 162','TR','03:30 PM - 04:45 PM','330',4,'Ma','Jiehui',4,NULL,NULL,NULL,NULL,NULL,NULL),(1636,'MG115','COMPSCI 460','TR','05:00 PM - 06:15 PM','500',1,'Maresso','Brian',5,NULL,NULL,NULL,NULL,NULL,NULL),(1637,'MG125','COMPSCI 222','MW','03:30 PM - 04:45 PM','330',1,'Maresso','Brian',5,NULL,NULL,NULL,NULL,NULL,NULL),(1638,'MG125','COMPSCI 221','TR','09:30 AM - 10:45 AM','930',1,'Maresso','Brian',5,NULL,NULL,NULL,NULL,NULL,NULL),(1639,'MG125','COMPSCI 172','TR','11:00 AM - 12:15 PM','1100',2,'Maresso','Brian',5,NULL,NULL,NULL,NULL,NULL,NULL),(1640,'MG125','COMPSCI 165','TR','12:30 PM - 01:45 PM','1230',1,'Maresso','Brian',5,NULL,NULL,NULL,NULL,NULL,NULL),(1641,'MG125','COMPSCI 215','TR','02:00 PM - 03:15 PM','200',1,'Mukherjee','Lopamudra',6,NULL,NULL,NULL,NULL,NULL,NULL),(1642,'MG125','COMPSCI 332','TR','03:30 PM - 04:45 PM','330',1,'Nguyen','Hien',7,NULL,NULL,NULL,NULL,NULL,NULL),(1643,'MG117','COMPSCI 366','MW','09:30 AM - 10:45 AM','930',1,'Nguyen','Hien',7,NULL,NULL,NULL,NULL,NULL,NULL),(1644,'MG117','COMPSCI 366','TR','09:30 AM - 10:45 AM','930',2,'Nguyen','Hien',7,NULL,NULL,NULL,NULL,NULL,NULL),(1645,'MG117','COMPSCI 776','M','05:00 PM - 07:30 PM','500',1,'Oster','Zachary',8,NULL,NULL,NULL,NULL,NULL,NULL),(1646,'MG117','COMPSCI 476','MW','03:30 PM - 04:45 PM','330',1,'Oster','Zachary',8,NULL,NULL,NULL,NULL,NULL,NULL),(1647,'MG117','COMPSCI 434','TR','03:30 PM - 04:45 PM','330',1,'Oster','Zachary',8,NULL,NULL,NULL,NULL,NULL,NULL),(1648,'HY210','COMPSCI 424','MW','11:00 AM - 12:15 PM','1100',1,'Oster','Zachary',8,NULL,NULL,NULL,NULL,NULL,NULL),(1649,'MG125','COMPSCI 353','TR','05:00 PM - 06:15 PM','500',1,'Wei','Ruzhen',9,NULL,NULL,NULL,NULL,NULL,NULL),(1650,'HY210','COMPSCI 482','TR','02:00 PM - 03:15 PM','200',1,'Samaranayake','Sobitha',10,NULL,NULL,NULL,NULL,NULL,NULL),(1651,'MG117','COMPSCI 174','TR','05:00 PM - 06:15 PM','500',1,'Sharma','Chandra',11,NULL,NULL,NULL,NULL,NULL,NULL),(1652,'HY210','COMPSCI 174','MW','09:30 AM - 10:45 AM','930',2,'Sharma','Chandra',11,NULL,NULL,NULL,NULL,NULL,NULL),(1653,'HY210','COMPSCI 456','MW','02:00 PM - 03:15 PM','200',1,'Sharma','Chandra',11,NULL,NULL,NULL,NULL,NULL,NULL),(1654,'HY210','COMPSCI 354','MW','03:30 PM - 04:45 PM','330',1,'Zhou','Jiazhen',12,NULL,NULL,NULL,NULL,NULL,NULL),(1655,'HY210','CY 101','TR','09:30 AM - 10:45 AM','930',1,'Dorney','Mark',13,NULL,NULL,NULL,NULL,NULL,NULL),(1656,'HY210','COMPSCI 412','MW','05:00 PM - 06:15 PM','500',1,'Ozgur','Ozgur',14,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `terms`
--

CREATE TABLE `terms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` int(11) NOT NULL,
  `semester` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `terms`
--

INSERT INTO `terms` VALUES (1,2019,'Fall'),(2,2020,'Spring'),(3,2022,'Spring'),(4,2023,'Spring'),(5,2023,'Fall');

--
-- Table structure for table `timeslots`
--

CREATE TABLE `timeslots` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `days` varchar(100) NOT NULL,
  `time` varchar(100) NOT NULL,
  `dayString` varchar(7) NOT NULL,
  `duration` int(11) NOT NULL DEFAULT -1,
  `timeslots` varchar(100) NOT NULL DEFAULT '-1',
  `start` int(11) NOT NULL,
  `end` int(11) NOT NULL,
  `priority` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `timeslots`
--

INSERT INTO `timeslots` VALUES (1,'MTWR','01:00 PM - 01:50 PM','111100',50,'M13:T13:W13:R13',1300,1350,6),(2,'MTWR','02:00 PM - 02:50 PM','111100',50,'M14:T14:W14:R14',1400,1450,7),(3,'MTWR','03:00 PM - 03:50 PM','111100',50,'M15:T15:W15:R15',1500,1550,8),(4,'MTWR','04:00 PM - 04:50 PM','111100',50,'M16:T16:W16:R16',1600,1650,9),(5,'MTWR','08:00 AM - 08:50 AM','111100',50,'M8:T8:W8:R8',800,850,1),(6,'MTWR','09:00 AM - 09:50 AM','111100',50,'M9:T9:W9:R9',900,950,2),(7,'MTWR','10:00 AM - 10:50 AM','111100',50,'M10:T10:W10:R10',1000,1050,3),(8,'MTWR','11:00 AM - 11:50 AM','111100',50,'M11:T11:W11:R11',1100,1150,4),(9,'MTWR','12:00 PM - 12:50 PM','111100',50,'M12:T12:W12:R12',1200,1250,5),(10,'MTWRF','01:00 PM - 01:50 PM','111110',50,'M13:T13:W13:R13:F13',1300,1350,6),(11,'MTWRF','08:00AM - 08:50AM','111110',50,'M8:T8:W8:R8:F8',800,850,1),(12,'MTWRF','09:00 AM - 09:50 AM','111110',50,'M9:T9:W9:R9:F9',900,950,2),(13,'MTWRF','10:00 AM - 10:50 AM','111110',50,'M10:T10:W10:R10:F10',1000,1050,3),(14,'MTWRF','11:00 AM - 11:50 AM','111110',50,'M11:T11:W11:R11:F11',1100,1150,4),(15,'MTWRF','12:00 - 12:50PM','111110',50,'M12:T12:W12:R12:F12',1200,1250,5),(16,'MW','02:00 PM - 03:15 PM','101000',75,'M14:W14',1400,1515,5),(17,'MTWR','MW 3:30- 4:20, TR 3:30 - 4:45 PM','101000',50,'M15:W15',1530,1645,10),(18,'MW','03:30 PM - 04:45 PM','101000',75,'M15:W15',1530,1645,6),(19,'MW','05:00 PM - 06:15 PM','101000',75,'M17:W17',1700,1815,7),(20,'MW','08:00 AM - 09:15 AM','101000',75,'M8:W8',800,915,1),(21,'MW','09:30 AM - 10:45 AM','101000',75,'M9:W9',930,1045,2),(22,'MW','11:00 AM - 12:15 PM','101000',75,'M11:W11',1100,1215,3),(23,'MW','12:30 PM - 01:45 PM','101000',75,'M12:W12',1230,1345,4),(24,'MWF','01:00 PM - 01:50 PM','101010',50,'M13:W13:F13',1300,1350,6),(25,'MWF','02:00 PM - 02:50 PM','101010',50,'M14:W14:F14',1400,1450,7),(26,'MWF','08:00 AM - 08:50 AM','101010',50,'M8:W8:F8',800,850,1),(27,'MWF','09:00 AM - 09:50 AM','101010',50,'M9:W9:F9',900,950,2),(28,'MWF','10:00 AM - 10:50 AM','101010',50,'M10:W10:F10',1000,1050,3),(29,'MWF','11:00 AM - 11:50 AM','101010',50,'M11:W11:F11',1100,1150,4),(30,'MWF','12:00 - 12:50PM','101010',50,'M12:W12:F12',1200,1250,4),(31,'Online','Online','000000',0,'-1',0,0,0),(32,'R','05:00 PM - 07:30 PM','000100',150,'R17',1700,1930,0),(33,'TR','02:00 PM - 03:15 PM','010100',75,'T14:R14',1400,1515,5),(34,'TR','03:30 PM - 04:45 PM','010100',75,'T15:R15',1530,1645,6),(35,'TR','05:00 PM - 06:15 PM','010100',75,'T17:R17',1700,1815,7),(36,'TR','08:00 AM - 09:15 AM','010100',75,'T8:R8',800,915,1),(37,'TR','09:30 AM - 10:45 AM','010100',75,'T9:R9',930,1045,2),(38,'TR','11:00 AM - 12:15 PM','010100',75,'T11:R11',1100,1215,3),(39,'TR','12:30 PM - 01:45 PM','010100',75,'T12:R12',1230,1345,4),(40,'W','05:00 PM - 07:30 PM','001000',150,'W17',1700,1930,0),(41,'MTWRF','02:00 PM - 02:50 PM','111110',50,'M13:T13:W13:R13:F13',1400,1450,7),(42,'T','05:00 PM - 07:30 PM','0100000',150,'T17',1700,1930,0),(43,'W','02:00 PM - 02:50 PM','001000',50,'W14',1400,1450,0),(44,'M','05:00 PM - 07:30 PM','',150,'M17',1700,1930,10);


