-- MySQL dump 10.13  Distrib 5.7.20, for Linux (x86_64)
--
-- Host: localhost    Database: AbOut_Test
-- ------------------------------------------------------
-- Server version	5.7.20

/*!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 `AssessOutcome`
--

DROP TABLE IF EXISTS `AssessOutcome`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AssessOutcome` (
  `assessId` int(11) NOT NULL,
  `oAbbrev` char(6) NOT NULL,
  PRIMARY KEY (`assessId`,`oAbbrev`),
  KEY `assessment_idx` (`assessId`),
  KEY `outcome_idx` (`oAbbrev`),
  CONSTRAINT `assessOutAssessment` FOREIGN KEY (`assessId`) REFERENCES `Assessment` (`assessId`) ON UPDATE CASCADE,
  CONSTRAINT `assessOutOutcome` FOREIGN KEY (`oAbbrev`) REFERENCES `Outcome` (`oAbbrev`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `AssessOutcome`
--

LOCK TABLES `AssessOutcome` WRITE;
/*!40000 ALTER TABLE `AssessOutcome` DISABLE KEYS */;
INSERT INTO `AssessOutcome` VALUES (1231,'EAC a'),(1231,'EAC b'),(1231,'EAC c'),(1232,'EAC 1'),(1232,'EAC 2'),(1232,'EAC 3'),(1232,'EAC 4'),(1232,'EAC d'),(1232,'EAC e'),(1232,'EAC f'),(1232,'EAC g'),(1232,'EAC h'),(1232,'EAC i'),(1232,'EAC j'),(1232,'EAC k'),(1233,'CAC a'),(1233,'CAC b'),(1233,'CAC c'),(1234,'CAC d'),(1234,'CAC e'),(1234,'CAC f'),(1234,'CAC g'),(1234,'CAC h'),(1234,'CAC i'),(1234,'CAC j'),(1234,'CAC k'),(1235,'CAC a'),(1235,'EAC a'),(1236,'CAC b'),(1236,'EAC b'),(1237,'CAC c'),(1237,'CAC d'),(1237,'CAC e'),(1237,'CAC f'),(1237,'EAC c'),(1237,'EAC d'),(1237,'EAC e'),(1237,'EAC f'),(1238,'CAC a'),(1238,'EAC a'),(1239,'CAC k'),(1239,'EAC k'),(1241,'CAC b'),(1241,'EAC b'),(1242,'CAC c'),(1242,'CAC d'),(1242,'CAC e'),(1242,'CAC f'),(1242,'EAC c'),(1242,'EAC d'),(1242,'EAC e'),(1242,'EAC f'),(1243,'CAC a'),(1243,'CAC b'),(1243,'CAC c'),(1244,'CAC d'),(1244,'CAC e'),(1244,'CAC f'),(1244,'CAC g'),(1244,'CAC h'),(1244,'CAC i'),(1244,'CAC j'),(1244,'CAC k'),(1245,'CAC a'),(1245,'EAC a'),(1246,'CAC k'),(1246,'EAC k'),(1247,'EAC a'),(1247,'EAC b'),(1247,'EAC c'),(1248,'EAC 1'),(1248,'EAC 2'),(1248,'EAC 3'),(1248,'EAC 4'),(1248,'EAC d'),(1248,'EAC e'),(1248,'EAC f'),(1248,'EAC g'),(1248,'EAC h'),(1248,'EAC i'),(1248,'EAC j'),(1248,'EAC k'),(1249,'CAC a'),(1249,'EAC a'),(1250,'EAC a'),(1250,'EAC b'),(1250,'EAC c'),(1251,'EAC 1'),(1251,'EAC 2'),(1251,'EAC 3'),(1251,'EAC 4'),(1251,'EAC d'),(1251,'EAC e'),(1251,'EAC f'),(1251,'EAC g'),(1251,'EAC h'),(1251,'EAC i'),(1251,'EAC j'),(1251,'EAC k'),(1252,'CAC a'),(1252,'CAC b'),(1252,'CAC c'),(1253,'CAC d'),(1253,'CAC e'),(1253,'CAC f'),(1253,'CAC g'),(1253,'CAC h'),(1253,'CAC i'),(1253,'CAC j'),(1253,'CAC k'),(1254,'CAC a'),(1254,'EAC a'),(1255,'CAC b'),(1255,'EAC b'),(1256,'CAC c'),(1256,'CAC d'),(1256,'CAC e'),(1256,'CAC f'),(1256,'EAC c'),(1256,'EAC d'),(1256,'EAC e'),(1256,'EAC f'),(1257,'CAC a'),(1257,'EAC a'),(1258,'EAC a'),(1258,'EAC b'),(1258,'EAC c'),(1259,'EAC 1'),(1259,'EAC 2'),(1259,'EAC 3'),(1259,'EAC 4'),(1259,'EAC d'),(1259,'EAC e'),(1259,'EAC f'),(1259,'EAC g'),(1259,'EAC h'),(1259,'EAC i'),(1259,'EAC j'),(1259,'EAC k'),(1260,'CAC a'),(1260,'CAC b'),(1260,'CAC c'),(1261,'CAC d'),(1261,'CAC e'),(1261,'CAC f'),(1261,'CAC g'),(1261,'CAC h'),(1261,'CAC i'),(1261,'CAC j'),(1261,'CAC k'),(1262,'CAC a'),(1262,'EAC a'),(1263,'CAC b'),(1263,'EAC b'),(1264,'CAC c'),(1264,'CAC d'),(1264,'CAC e'),(1264,'CAC f'),(1264,'EAC c'),(1264,'EAC d'),(1264,'EAC e'),(1264,'EAC f'),(1265,'CAC a'),(1265,'EAC a'),(1266,'CAC a'),(1266,'EAC a'),(1267,'EAC a'),(1267,'EAC b'),(1267,'EAC c'),(1268,'EAC 1'),(1268,'EAC 2'),(1268,'EAC 3'),(1268,'EAC 4'),(1268,'EAC d'),(1268,'EAC e'),(1268,'EAC f'),(1268,'EAC g'),(1268,'EAC h'),(1268,'EAC i'),(1268,'EAC j'),(1268,'EAC k'),(1269,'CAC a'),(1269,'CAC b'),(1269,'CAC c'),(1270,'CAC d'),(1270,'CAC e'),(1270,'CAC f'),(1270,'CAC g'),(1270,'CAC h'),(1270,'CAC i'),(1270,'CAC j'),(1270,'CAC k'),(1271,'CAC a'),(1271,'EAC a'),(1272,'CAC b'),(1272,'EAC b'),(1273,'CAC c'),(1273,'CAC d'),(1273,'CAC e'),(1273,'CAC f'),(1273,'EAC c'),(1273,'EAC d'),(1273,'EAC e'),(1273,'EAC f'),(1274,'CAC a'),(1274,'EAC a');
/*!40000 ALTER TABLE `AssessOutcome` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Assessment`
--

DROP TABLE IF EXISTS `Assessment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Assessment` (
  `assessId` int(11) NOT NULL AUTO_INCREMENT,
  `offeringId` int(11) NOT NULL,
  `description` varchar(200) DEFAULT NULL,
  `maxPoints` int(11) NOT NULL DEFAULT '100',
  PRIMARY KEY (`assessId`),
  UNIQUE KEY `unique_fields` (`offeringId`,`description`,`maxPoints`) USING BTREE,
  KEY `offering_idx` (`offeringId`),
  CONSTRAINT `offering` FOREIGN KEY (`offeringId`) REFERENCES `Offering` (`offeringId`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1275 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Assessment`
--

LOCK TABLES `Assessment` WRITE;
/*!40000 ALTER TABLE `Assessment` DISABLE KEYS */;
INSERT INTO `Assessment` VALUES (1242,230,'Essay',100),(1241,230,'Exam  2, questions 17, 18 & 19',100),(1249,230,'Final, question 9',10),(1232,231,'Essay',100),(1231,231,'Final, question 13',20),(1234,232,'Exam 2, question 4',40),(1233,232,'Final, question 1',10),(1236,233,'Exam  2, questions 17, 18 & 19',30),(1235,233,'Final, overview essays',100),(1237,233,'Final, question 13',50),(1238,234,'Resume',100),(1239,235,'Essay',100),(1248,236,'Essays',100),(1247,236,'Exam  3, question 5',10),(1244,237,'Final, overview essays',100),(1243,237,'Final, question 8',100),(1245,238,'Cover letter',100),(1246,239,'Presentation',100),(1250,240,'Final, overview essays',100),(1251,240,'Final, question 9',10),(1252,241,'Final, question 1',10),(1253,241,'Final, question 10',20),(1255,242,'Exam 1, question 10',10),(1254,242,'Exam 2, question 4',10),(1256,242,'Final, question 9',20),(1257,243,'Resume',100),(1258,244,'Exam  2, questions 17, 18 & 19',30),(1259,244,'Programming Assignment 2',100),(1261,245,'Final, overview essays',100),(1260,245,'Programming Assignment 2',100),(1264,246,'Final, question 13',10),(1263,246,'Final, question 8',10),(1262,246,'Final, question 9',10),(1265,247,'Resume',100),(1266,248,'Cover letter',50),(1268,249,'Exam 2, essay questions 2 & 3',10),(1267,249,'Final, question 9',10),(1269,250,'Exam 2, question 4',10),(1270,250,'Final, question 8',10),(1272,251,'Exam 2, essay questions 2 & 3',10),(1271,251,'Final, question 8',10),(1273,251,'Program 10',100),(1274,252,'Career Paper',100);
/*!40000 ALTER TABLE `Assessment` 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` (
  `cAbbrev` char(10) NOT NULL,
  `cName` varchar(80) NOT NULL,
  `csFlag` tinyint(1) DEFAULT '0',
  `seFlag` tinyint(1) DEFAULT NULL,
  `beginSem` int(11) NOT NULL,
  `endSem` int(11) DEFAULT NULL,
  PRIMARY KEY (`cAbbrev`),
  KEY `beginSemester_idx` (`beginSem`),
  KEY `endSemester_idx` (`endSem`),
  CONSTRAINT `courseBeginSemester` FOREIGN KEY (`beginSem`) REFERENCES `Semester` (`semesterId`) ON UPDATE CASCADE,
  CONSTRAINT `courseEndSemester` FOREIGN KEY (`endSem`) REFERENCES `Semester` (`semesterId`) ON UPDATE CASCADE
) ENGINE=InnoDB 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 ('CSCI 110','Programming with Visual Basic I',1,1,1,NULL),('CSCI 135','Fundamentals of Computer Science I',1,1,1,NULL),('CSCI 136','Fundamentals of Computer Science II',1,1,1,NULL),('CSCI 194','Freshman Seminar',1,1,1,NULL),('CSCI 246','Discrete Structures',1,1,1,4),('CSCI 347','Data Mining',1,1,4,NULL),('CSCI 438','Theory of Computation',1,0,1,NULL),('CSCI 441','Computer Graphics',1,0,1,NULL),('ESOF 326','Software Maintenance',0,1,1,NULL),('ESOF 328','Requirements and Specifications',0,1,1,NULL);
/*!40000 ALTER TABLE `Course` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CourseOutcome`
--

DROP TABLE IF EXISTS `CourseOutcome`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CourseOutcome` (
  `cAbbrev` char(10) NOT NULL,
  `oAbbrev` char(6) NOT NULL,
  PRIMARY KEY (`cAbbrev`,`oAbbrev`),
  KEY `course_idx` (`cAbbrev`),
  KEY `outcome_idx` (`oAbbrev`),
  CONSTRAINT `course` FOREIGN KEY (`cAbbrev`) REFERENCES `Course` (`cAbbrev`) ON UPDATE CASCADE,
  CONSTRAINT `outcome` FOREIGN KEY (`oAbbrev`) REFERENCES `Outcome` (`oAbbrev`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `CourseOutcome`
--

LOCK TABLES `CourseOutcome` WRITE;
/*!40000 ALTER TABLE `CourseOutcome` DISABLE KEYS */;
INSERT INTO `CourseOutcome` VALUES ('CSCI 110','CAC a'),('CSCI 135','CAC a'),('CSCI 136','CAC a'),('CSCI 194','CAC a'),('CSCI 438','CAC a'),('CSCI 441','CAC a'),('CSCI 135','CAC b'),('CSCI 136','CAC b'),('CSCI 438','CAC b'),('CSCI 441','CAC b'),('CSCI 135','CAC c'),('CSCI 136','CAC c'),('CSCI 438','CAC c'),('CSCI 441','CAC c'),('CSCI 135','CAC d'),('CSCI 136','CAC d'),('CSCI 438','CAC d'),('CSCI 441','CAC d'),('CSCI 135','CAC e'),('CSCI 136','CAC e'),('CSCI 438','CAC e'),('CSCI 441','CAC e'),('CSCI 135','CAC f'),('CSCI 136','CAC f'),('CSCI 438','CAC f'),('CSCI 441','CAC f'),('CSCI 438','CAC g'),('CSCI 441','CAC g'),('CSCI 438','CAC h'),('CSCI 441','CAC h'),('CSCI 438','CAC i'),('CSCI 441','CAC i'),('CSCI 438','CAC j'),('CSCI 441','CAC j'),('CSCI 246','CAC k'),('CSCI 347','CAC k'),('CSCI 438','CAC k'),('CSCI 441','CAC k'),('ESOF 326','EAC 1'),('ESOF 328','EAC 1'),('ESOF 326','EAC 2'),('ESOF 328','EAC 2'),('ESOF 326','EAC 3'),('ESOF 328','EAC 3'),('ESOF 326','EAC 4'),('ESOF 328','EAC 4'),('CSCI 135','EAC a'),('CSCI 136','EAC a'),('CSCI 194','EAC a'),('ESOF 326','EAC a'),('ESOF 328','EAC a'),('CSCI 135','EAC b'),('CSCI 136','EAC b'),('ESOF 326','EAC b'),('ESOF 328','EAC b'),('CSCI 135','EAC c'),('CSCI 136','EAC c'),('ESOF 326','EAC c'),('ESOF 328','EAC c'),('CSCI 135','EAC d'),('CSCI 136','EAC d'),('ESOF 326','EAC d'),('ESOF 328','EAC d'),('CSCI 135','EAC e'),('CSCI 136','EAC e'),('ESOF 326','EAC e'),('ESOF 328','EAC e'),('CSCI 135','EAC f'),('CSCI 136','EAC f'),('ESOF 326','EAC f'),('ESOF 328','EAC f'),('ESOF 326','EAC g'),('ESOF 328','EAC g'),('ESOF 326','EAC h'),('ESOF 328','EAC h'),('ESOF 326','EAC i'),('ESOF 328','EAC i'),('ESOF 326','EAC j'),('ESOF 328','EAC j'),('CSCI 246','EAC k'),('CSCI 347','EAC k'),('ESOF 326','EAC k'),('ESOF 328','EAC k');
/*!40000 ALTER TABLE `CourseOutcome` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CoursePrefix`
--

DROP TABLE IF EXISTS `CoursePrefix`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CoursePrefix` (
  `cPrefix` char(6) NOT NULL,
  PRIMARY KEY (`cPrefix`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `CoursePrefix`
--

LOCK TABLES `CoursePrefix` WRITE;
/*!40000 ALTER TABLE `CoursePrefix` DISABLE KEYS */;
INSERT INTO `CoursePrefix` VALUES ('COMX'),('CSCI'),('ESOF');
/*!40000 ALTER TABLE `CoursePrefix` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `DefaultSemester`
--

DROP TABLE IF EXISTS `DefaultSemester`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DefaultSemester` (
  `semesterId` int(11) NOT NULL,
  PRIMARY KEY (`semesterId`),
  CONSTRAINT `semester` FOREIGN KEY (`semesterId`) REFERENCES `Semester` (`semesterId`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DefaultSemester`
--

LOCK TABLES `DefaultSemester` WRITE;
/*!40000 ALTER TABLE `DefaultSemester` DISABLE KEYS */;
INSERT INTO `DefaultSemester` VALUES (1);
/*!40000 ALTER TABLE `DefaultSemester` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `OffOutcome`
--

DROP TABLE IF EXISTS `OffOutcome`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `OffOutcome` (
  `offeringId` int(11) NOT NULL,
  `oAbbrev` char(6) NOT NULL,
  PRIMARY KEY (`offeringId`,`oAbbrev`),
  KEY `offering_idx` (`offeringId`),
  KEY `outcome_idx` (`oAbbrev`),
  CONSTRAINT `offOutOffering` FOREIGN KEY (`offeringId`) REFERENCES `Offering` (`offeringId`) ON UPDATE CASCADE,
  CONSTRAINT `offOutOutcome` FOREIGN KEY (`oAbbrev`) REFERENCES `Outcome` (`oAbbrev`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `OffOutcome`
--

LOCK TABLES `OffOutcome` WRITE;
/*!40000 ALTER TABLE `OffOutcome` DISABLE KEYS */;
INSERT INTO `OffOutcome` VALUES (230,'CAC a'),(230,'CAC b'),(230,'CAC c'),(230,'CAC d'),(230,'CAC e'),(230,'CAC f'),(230,'EAC a'),(230,'EAC b'),(230,'EAC c'),(230,'EAC d'),(230,'EAC e'),(230,'EAC f'),(231,'EAC 1'),(231,'EAC 2'),(231,'EAC 3'),(231,'EAC 4'),(231,'EAC a'),(231,'EAC b'),(231,'EAC c'),(231,'EAC d'),(231,'EAC e'),(231,'EAC f'),(231,'EAC g'),(231,'EAC h'),(231,'EAC i'),(231,'EAC j'),(231,'EAC k'),(232,'CAC a'),(232,'CAC b'),(232,'CAC c'),(232,'CAC d'),(232,'CAC e'),(232,'CAC f'),(232,'CAC g'),(232,'CAC h'),(232,'CAC i'),(232,'CAC j'),(232,'CAC k'),(233,'CAC a'),(233,'CAC b'),(233,'CAC c'),(233,'CAC d'),(233,'CAC e'),(233,'CAC f'),(233,'EAC a'),(233,'EAC b'),(233,'EAC c'),(233,'EAC d'),(233,'EAC e'),(233,'EAC f'),(234,'CAC a'),(234,'EAC a'),(235,'CAC k'),(235,'EAC k'),(236,'EAC 1'),(236,'EAC 2'),(236,'EAC 3'),(236,'EAC 4'),(236,'EAC a'),(236,'EAC b'),(236,'EAC c'),(236,'EAC d'),(236,'EAC e'),(236,'EAC f'),(236,'EAC g'),(236,'EAC h'),(236,'EAC i'),(236,'EAC j'),(236,'EAC k'),(237,'CAC a'),(237,'CAC b'),(237,'CAC c'),(237,'CAC d'),(237,'CAC e'),(237,'CAC f'),(237,'CAC g'),(237,'CAC h'),(237,'CAC i'),(237,'CAC j'),(237,'CAC k'),(238,'CAC a'),(238,'EAC a'),(239,'CAC k'),(239,'EAC k'),(240,'EAC 1'),(240,'EAC 2'),(240,'EAC 3'),(240,'EAC 4'),(240,'EAC a'),(240,'EAC b'),(240,'EAC c'),(240,'EAC d'),(240,'EAC e'),(240,'EAC f'),(240,'EAC g'),(240,'EAC h'),(240,'EAC i'),(240,'EAC j'),(240,'EAC k'),(241,'CAC a'),(241,'CAC b'),(241,'CAC c'),(241,'CAC d'),(241,'CAC e'),(241,'CAC f'),(241,'CAC g'),(241,'CAC h'),(241,'CAC i'),(241,'CAC j'),(241,'CAC k'),(242,'CAC a'),(242,'CAC b'),(242,'CAC c'),(242,'CAC d'),(242,'CAC e'),(242,'CAC f'),(242,'EAC a'),(242,'EAC b'),(242,'EAC c'),(242,'EAC d'),(242,'EAC e'),(242,'EAC f'),(243,'CAC a'),(243,'EAC a'),(244,'EAC 1'),(244,'EAC 2'),(244,'EAC 3'),(244,'EAC 4'),(244,'EAC a'),(244,'EAC b'),(244,'EAC c'),(244,'EAC d'),(244,'EAC e'),(244,'EAC f'),(244,'EAC g'),(244,'EAC h'),(244,'EAC i'),(244,'EAC j'),(244,'EAC k'),(245,'CAC a'),(245,'CAC b'),(245,'CAC c'),(245,'CAC d'),(245,'CAC e'),(245,'CAC f'),(245,'CAC g'),(245,'CAC h'),(245,'CAC i'),(245,'CAC j'),(245,'CAC k'),(246,'CAC a'),(246,'CAC b'),(246,'CAC c'),(246,'CAC d'),(246,'CAC e'),(246,'CAC f'),(246,'EAC a'),(246,'EAC b'),(246,'EAC c'),(246,'EAC d'),(246,'EAC e'),(246,'EAC f'),(247,'CAC a'),(247,'EAC a'),(248,'CAC a'),(248,'EAC a'),(249,'EAC 1'),(249,'EAC 2'),(249,'EAC 3'),(249,'EAC 4'),(249,'EAC a'),(249,'EAC b'),(249,'EAC c'),(249,'EAC d'),(249,'EAC e'),(249,'EAC f'),(249,'EAC g'),(249,'EAC h'),(249,'EAC i'),(249,'EAC j'),(249,'EAC k'),(250,'CAC a'),(250,'CAC b'),(250,'CAC c'),(250,'CAC d'),(250,'CAC e'),(250,'CAC f'),(250,'CAC g'),(250,'CAC h'),(250,'CAC i'),(250,'CAC j'),(250,'CAC k'),(251,'CAC a'),(251,'CAC b'),(251,'CAC c'),(251,'CAC d'),(251,'CAC e'),(251,'CAC f'),(251,'EAC a'),(251,'EAC b'),(251,'EAC c'),(251,'EAC d'),(251,'EAC e'),(251,'EAC f'),(252,'CAC a'),(252,'EAC a');
/*!40000 ALTER TABLE `OffOutcome` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Offering`
--

DROP TABLE IF EXISTS `Offering`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Offering` (
  `offeringId` int(11) NOT NULL AUTO_INCREMENT,
  `cAbbrev` char(10) NOT NULL,
  `semesterId` int(11) NOT NULL,
  `sectionNo` char(2) NOT NULL DEFAULT '01',
  `userId` int(11) DEFAULT NULL,
  `fName` varchar(50) NOT NULL,
  PRIMARY KEY (`offeringId`),
  KEY `user_idx` (`userId`),
  KEY `course_idx` (`cAbbrev`),
  KEY `semester_idx` (`semesterId`),
  CONSTRAINT `offeringCourse` FOREIGN KEY (`cAbbrev`) REFERENCES `Course` (`cAbbrev`) ON UPDATE CASCADE,
  CONSTRAINT `offeringSemester` FOREIGN KEY (`semesterId`) REFERENCES `Semester` (`semesterId`) ON UPDATE CASCADE,
  CONSTRAINT `offeringUser` FOREIGN KEY (`userId`) REFERENCES `User` (`userId`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=253 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Offering`
--

LOCK TABLES `Offering` WRITE;
/*!40000 ALTER TABLE `Offering` DISABLE KEYS */;
INSERT INTO `Offering` VALUES (230,'CSCI 136',2,'01',1,'Celia Schahczenski'),(231,'ESOF 326',1,'01',34,'Michael Fryer'),(232,'CSCI 438',1,'01',30,'Lucas Stout'),(233,'CSCI 135',1,'01',32,'Chris Oneill'),(234,'CSCI 194',1,'01',37,'Carson Fiechtner'),(235,'CSCI 246',1,'01',6,'Frank Ackerman'),(236,'ESOF 328',2,'01',39,'Jordan Yates'),(237,'CSCI 441',2,'01',6,'Frank Ackerman'),(238,'CSCI 194',2,'01',38,'Zachariah Valenzuela'),(239,'CSCI 246',2,'01',6,'Frank Ackerman'),(240,'ESOF 326',4,'01',34,'Michael Fryer'),(241,'CSCI 438',4,'01',30,'Lucas Stout'),(242,'CSCI 135',4,'01',32,'Chris Oneill'),(243,'CSCI 194',4,'01',37,'Carson Fiechtner'),(244,'ESOF 328',5,'01',33,'Joe Beaudry'),(245,'CSCI 441',5,'01',39,'Jordan Yates'),(246,'CSCI 136',5,'01',33,'Joe Beaudry'),(247,'CSCI 194',5,'01',1,'Celia Schahczenski'),(248,'CSCI 194',6,'01',33,'Joe Beaudry'),(249,'ESOF 326',7,'01',41,'Greg Marlowe'),(250,'CSCI 438',7,'01',30,'Lucas Stout'),(251,'CSCI 135',7,'01',37,'Carson Fiechtner'),(252,'CSCI 194',7,'01',44,'Greg Marlowe');
/*!40000 ALTER TABLE `Offering` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Outcome`
--

DROP TABLE IF EXISTS `Outcome`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Outcome` (
  `oAbbrev` char(6) NOT NULL,
  `oText` varchar(500) DEFAULT NULL,
  `pAbbrev` char(10) NOT NULL,
  `beginSem` int(11) NOT NULL,
  `endSem` int(11) DEFAULT NULL,
  PRIMARY KEY (`oAbbrev`),
  KEY `beginSemester_idx` (`beginSem`),
  KEY `endSemester_idx` (`endSem`),
  KEY `program_idx` (`pAbbrev`),
  CONSTRAINT `beginSemester` FOREIGN KEY (`beginSem`) REFERENCES `Semester` (`semesterId`) ON UPDATE CASCADE,
  CONSTRAINT `endSemester` FOREIGN KEY (`endSem`) REFERENCES `Semester` (`semesterId`) ON UPDATE CASCADE,
  CONSTRAINT `program` FOREIGN KEY (`pAbbrev`) REFERENCES `Program` (`pAbbrev`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Outcome`
--

LOCK TABLES `Outcome` WRITE;
/*!40000 ALTER TABLE `Outcome` DISABLE KEYS */;
INSERT INTO `Outcome` VALUES ('CAC a','An ability to apply knowledge of computing and mathematics appropriate to the discipline','CS',1,NULL),('CAC b','An ability to analyze a problem, and identify and define the computing requirements appropriate to its solutions','CS',1,NULL),('CAC c','An ability to design, implement, and evaluate a computer-based system, process, component, or program to meet desired needs','CS',1,NULL),('CAC d','An ability to function effectively on teams to accomplish a common goal','CS',1,NULL),('CAC e','An understanding of professional, ethical, legal, security and social issues and responsibilities','CS',1,NULL),('CAC f','An ability to communicate effectively with a range of audiences','CS',1,NULL),('CAC g','An ability to analyze the local and global impact of computing on individuals, organizations and society','CS',1,NULL),('CAC h','Recognition of the need for and an ability to engage in continuing professional development','CS',1,NULL),('CAC i','An ability to use current techniques, skills and tools necessary for computing practices','CS',1,NULL),('CAC j','An ability to apply mathematical foundations, algorithmic principles and computer science theory in the modeling and design of computer-based systems in a way that demonstrates comprehension of the tradeoffs involved in design choices.','CS',1,NULL),('CAC k','An ability to apply design and development principles in the construction of software systems of varying complexity','CS',1,NULL),('EAC 1','The ability to analyze, design, verify, validate, implement, apply and maintain software systems','SE',1,NULL),('EAC 2','The ability to appropriately apply discrete mathematics, probability and statistics, and relevant topics in computer science and supporting disciplines to complex software systems','SE',1,NULL),('EAC 3','The ability to work in one or more significant application domains','SE',1,NULL),('EAC 4','The ability to manage the development of software systems','SE',1,NULL),('EAC a','An ability to apply knowledge of mathematics, science and engineering','SE',1,NULL),('EAC b','An ability to design and conduct experiments, as well as to analyze and interpret data','SE',1,NULL),('EAC c','An ability to design a system, component, or process to meet desired needs within realistic constraints such as economic, environmental, social, political, ethical, health and safety, manufacturabilit','SE',1,NULL),('EAC d','An ability to function on multidisciplinary teams','SE',1,NULL),('EAC e','An ability to identify, formulate and solve engineering problems','SE',1,NULL),('EAC f','An understanding of professional and ethical responsibility','SE',1,NULL),('EAC g','An ability to communicate effectively','SE',1,NULL),('EAC h','The broad education necessary to understand the impact of engineering solutions in a global, economic, environmental and societal context','SE',1,NULL),('EAC i','A recognition of the need for and an ability to engage in life-long learning','SE',1,NULL),('EAC j','A knowledge of contemporary issues','SE',1,NULL),('EAC k','An ability to use the techniques, skills and modern engineering tools necessary for engineering practice','SE',1,NULL);
/*!40000 ALTER TABLE `Outcome` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `OutcomePrefix`
--

DROP TABLE IF EXISTS `OutcomePrefix`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `OutcomePrefix` (
  `oPrefix` char(3) NOT NULL,
  PRIMARY KEY (`oPrefix`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `OutcomePrefix`
--

LOCK TABLES `OutcomePrefix` WRITE;
/*!40000 ALTER TABLE `OutcomePrefix` DISABLE KEYS */;
INSERT INTO `OutcomePrefix` VALUES ('CAC'),('EAC');
/*!40000 ALTER TABLE `OutcomePrefix` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Prefix`
--

DROP TABLE IF EXISTS `Prefix`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Prefix` (
  `prefix` char(6) NOT NULL,
  PRIMARY KEY (`prefix`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Prefix`
--

LOCK TABLES `Prefix` WRITE;
/*!40000 ALTER TABLE `Prefix` DISABLE KEYS */;
INSERT INTO `Prefix` VALUES ('COMX'),('CSCI'),('ESOF');
/*!40000 ALTER TABLE `Prefix` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Program`
--

DROP TABLE IF EXISTS `Program`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Program` (
  `pAbbrev` char(10) NOT NULL,
  PRIMARY KEY (`pAbbrev`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Program`
--

LOCK TABLES `Program` WRITE;
/*!40000 ALTER TABLE `Program` DISABLE KEYS */;
INSERT INTO `Program` VALUES ('CS'),('SE');
/*!40000 ALTER TABLE `Program` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Score`
--

DROP TABLE IF EXISTS `Score`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Score` (
  `assessId` int(11) NOT NULL,
  `studentId` int(11) NOT NULL,
  `score` decimal(8,2) DEFAULT NULL,
  PRIMARY KEY (`assessId`,`studentId`),
  KEY `student_idx` (`studentId`),
  CONSTRAINT `scoreAssessment` FOREIGN KEY (`assessId`) REFERENCES `Assessment` (`assessId`) ON UPDATE CASCADE,
  CONSTRAINT `scoreStudent` FOREIGN KEY (`studentId`) REFERENCES `Student` (`studentId`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Score`
--

LOCK TABLES `Score` WRITE;
/*!40000 ALTER TABLE `Score` DISABLE KEYS */;
INSERT INTO `Score` VALUES (1231,2451,10.00),(1231,2452,12.00),(1231,2453,0.00),(1231,2454,13.00),(1232,2451,100.00),(1232,2452,82.00),(1232,2453,70.00),(1232,2454,75.00),(1233,2455,0.00),(1233,2456,6.00),(1233,2457,6.00),(1233,2458,5.00),(1234,2455,28.00),(1234,2456,38.00),(1234,2457,28.00),(1234,2458,30.00),(1235,2459,65.00),(1235,2460,65.00),(1235,2461,65.00),(1235,2462,65.00),(1236,2459,10.00),(1236,2460,15.00),(1236,2461,30.00),(1236,2462,27.00),(1237,2459,45.00),(1237,2460,49.00),(1237,2461,50.00),(1237,2462,45.00),(1238,2463,0.00),(1238,2464,69.00),(1238,2465,69.00),(1238,2466,55.00),(1239,2467,100.00),(1239,2468,100.00),(1239,2469,100.00),(1239,2470,100.00),(1241,2447,60.00),(1241,2448,80.00),(1241,2449,75.00),(1241,2450,55.00),(1242,2447,78.00),(1242,2448,95.00),(1242,2449,100.00),(1242,2450,75.00),(1243,2475,69.00),(1243,2476,69.00),(1243,2477,69.00),(1243,2478,69.00),(1244,2475,90.00),(1244,2476,70.00),(1244,2477,100.00),(1244,2478,95.00),(1245,2479,0.00),(1245,2480,0.00),(1245,2481,0.00),(1245,2482,0.00),(1245,2483,0.00),(1245,2484,0.00),(1245,2485,0.00),(1245,2486,0.00),(1245,2487,0.00),(1245,2488,0.00),(1245,2489,0.00),(1245,2490,0.00),(1245,2491,0.00),(1245,2492,0.00),(1245,2493,0.00),(1245,2494,0.00),(1245,2495,0.00),(1245,2496,0.00),(1245,2497,0.00),(1245,2498,0.00),(1246,2499,85.00),(1246,2500,70.00),(1246,2501,95.00),(1246,2502,90.00),(1247,2471,0.00),(1247,2472,4.00),(1247,2473,6.00),(1247,2474,5.00),(1248,2471,75.00),(1248,2472,70.00),(1248,2473,88.00),(1248,2474,100.00),(1249,2447,6.00),(1249,2448,5.00),(1249,2449,6.50),(1249,2450,6.90),(1250,2503,68.00),(1250,2504,69.00),(1250,2505,69.00),(1250,2506,69.00),(1251,2503,10.00),(1251,2504,8.00),(1251,2505,8.00),(1251,2506,10.00),(1252,2551,5.00),(1252,2552,6.00),(1252,2553,6.00),(1252,2554,5.00),(1253,2551,20.00),(1253,2552,17.00),(1253,2553,18.00),(1253,2554,20.00),(1254,2507,2.00),(1254,2508,1.00),(1254,2509,5.00),(1254,2510,2.00),(1255,2507,5.00),(1255,2508,10.00),(1255,2509,10.00),(1255,2510,5.00),(1256,2507,20.00),(1256,2508,20.00),(1256,2509,20.00),(1256,2510,20.00),(1257,2511,60.00),(1257,2512,55.00),(1257,2513,69.00),(1257,2514,60.00),(1258,2515,12.00),(1258,2516,10.00),(1258,2517,20.00),(1258,2518,20.00),(1259,2515,85.00),(1259,2516,70.00),(1259,2517,100.00),(1259,2518,100.00),(1260,2519,55.00),(1260,2520,65.00),(1260,2521,65.00),(1260,2522,60.00),(1261,2519,88.00),(1261,2520,92.00),(1261,2521,75.00),(1261,2522,70.00),(1262,2523,5.00),(1262,2524,6.00),(1262,2525,6.00),(1262,2526,5.00),(1263,2523,5.00),(1263,2524,6.00),(1263,2525,9.00),(1263,2526,10.00),(1264,2523,8.00),(1264,2524,10.00),(1264,2525,10.00),(1264,2526,9.00),(1265,2527,69.00),(1265,2528,22.00),(1265,2529,55.00),(1265,2530,65.00),(1266,2531,48.00),(1266,2532,45.00),(1266,2533,50.00),(1266,2534,50.00),(1267,2535,5.00),(1267,2536,5.00),(1267,2537,6.00),(1267,2538,6.00),(1268,2535,9.00),(1268,2536,10.00),(1268,2537,9.00),(1268,2538,8.00),(1269,2539,5.00),(1269,2540,6.00),(1269,2541,6.00),(1269,2542,6.00),(1270,2539,8.00),(1270,2540,9.00),(1270,2541,7.00),(1270,2542,8.00),(1271,2543,5.00),(1271,2544,6.00),(1271,2545,6.00),(1271,2546,5.00),(1272,2543,5.00),(1272,2544,7.00),(1272,2545,10.00),(1272,2546,6.00),(1273,2543,95.00),(1273,2544,100.00),(1273,2545,90.00),(1273,2546,70.00),(1274,2547,52.00),(1274,2548,33.00),(1274,2549,55.00),(1274,2550,67.00);
/*!40000 ALTER TABLE `Score` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Semester`
--

DROP TABLE IF EXISTS `Semester`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Semester` (
  `semesterId` int(11) NOT NULL AUTO_INCREMENT,
  `semester` char(12) NOT NULL,
  PRIMARY KEY (`semesterId`),
  UNIQUE KEY `semester_UNIQUE` (`semester`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Semester`
--

LOCK TABLES `Semester` WRITE;
/*!40000 ALTER TABLE `Semester` DISABLE KEYS */;
INSERT INTO `Semester` VALUES (1,'Fall 2015'),(4,'Fall 2016'),(7,'Fall 2017'),(2,'Spring 2016'),(5,'Spring 2017'),(8,'Spring 2018'),(3,'Summer 2016'),(6,'Summer 2017');
/*!40000 ALTER TABLE `Semester` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Student`
--

DROP TABLE IF EXISTS `Student`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Student` (
  `studentId` int(11) NOT NULL AUTO_INCREMENT,
  `sName` char(50) NOT NULL,
  `offeringId` int(11) NOT NULL,
  PRIMARY KEY (`studentId`),
  KEY `offering_idx` (`offeringId`),
  CONSTRAINT `studentOffering` FOREIGN KEY (`offeringId`) REFERENCES `Offering` (`offeringId`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2555 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Student`
--

LOCK TABLES `Student` WRITE;
/*!40000 ALTER TABLE `Student` DISABLE KEYS */;
INSERT INTO `Student` VALUES (2447,'Eli Rose',230),(2448,'Sheryl Duggins',230),(2449,'Clara Wisner',230),(2450,'David Hughell',230),(2451,'Eli Rose',231),(2452,'Sheryl Duggins',231),(2453,'Clara Wisner',231),(2454,'David Hughell',231),(2455,'Eli Rose',232),(2456,'Sheryl Duggins',232),(2457,'Clara Wisner',232),(2458,'David Hughell',232),(2459,'Eli Rose',233),(2460,'Sheryl Duggins',233),(2461,'Clara Wisner',233),(2462,'David Hughell',233),(2463,'Eli Rose',234),(2464,'Sheryl Duggins',234),(2465,'Clara Wisner',234),(2466,'David Hughell',234),(2467,'Eli Rose',235),(2468,'Sheryl Duggins',235),(2469,'Clara Wisner',235),(2470,'David Hughell',235),(2471,'Eli Rose',236),(2472,'Sheryl Duggins',236),(2473,'Clara Wisner',236),(2474,'David Hughell',236),(2475,'Eli Rose',237),(2476,'Sheryl Duggins',237),(2477,'Clara Wisner',237),(2478,'David Hughell',237),(2479,'Eli Rose',238),(2480,'Sheryl Duggins',238),(2481,'Clara Wisner',238),(2482,'David Hughell',238),(2483,'Eli Rose',238),(2484,'Sheryl Duggins',238),(2485,'Clara Wisner',238),(2486,'David Hughell',238),(2487,'Eli Rose',238),(2488,'Sheryl Duggins',238),(2489,'Clara Wisner',238),(2490,'David Hughell',238),(2491,'Eli Rose',238),(2492,'Sheryl Duggins',238),(2493,'Clara Wisner',238),(2494,'David Hughell',238),(2495,'Eli Rose',238),(2496,'Sheryl Duggins',238),(2497,'Clara Wisner',238),(2498,'David Hughell',238),(2499,'Eli Rose',239),(2500,'Sheryl Duggins',239),(2501,'Clara Wisner',239),(2502,'David Hughell',239),(2503,'Eli Rose',240),(2504,'Sheryl Duggins',240),(2505,'Clara Wisner',240),(2506,'David Hughell',240),(2507,'Eli Rose',242),(2508,'Sheryl Duggins',242),(2509,'Clara Wisner',242),(2510,'David Hughell',242),(2511,'Eli Rose',243),(2512,'Sheryl Duggins',243),(2513,'Clara Wisner',243),(2514,'David Hughell',243),(2515,'Eli Rose',244),(2516,'Sheryl Duggins',244),(2517,'Clara Wisner',244),(2518,'David Hughell',244),(2519,'Eli Rose',245),(2520,'Sheryl Duggins',245),(2521,'Clara Wisner',245),(2522,'David Hughell',245),(2523,'Eli Rose',246),(2524,'Sheryl Duggins',246),(2525,'Clara Wisner',246),(2526,'David Hughell',246),(2527,'Eli Rose',247),(2528,'Sheryl Duggins',247),(2529,'Clara Wisner',247),(2530,'David Hughell',247),(2531,'Eli Rose',248),(2532,'Sheryl Duggins',248),(2533,'Clara Wisner',248),(2534,'David Hughell',248),(2535,'Eli Rose',249),(2536,'Sheryl Duggins',249),(2537,'Clara Wisner',249),(2538,'David Hughell',249),(2539,'Eli Rose',250),(2540,'Sheryl Duggins',250),(2541,'Clara Wisner',250),(2542,'David Hughell',250),(2543,'Eli Rose',251),(2544,'Sheryl Duggins',251),(2545,'Clara Wisner',251),(2546,'David Hughell',251),(2547,'Eli Rose',252),(2548,'Sheryl Duggins',252),(2549,'Clara Wisner',252),(2550,'David Hughell',252),(2551,'Eli Rose',241),(2552,'Sheryl Duggins',241),(2553,'Clara Wisner',241),(2554,'David Hughell',241);
/*!40000 ALTER TABLE `Student` 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` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `usernameCAS` varchar(50) NOT NULL,
  `uName` varchar(50) NOT NULL,
  `activeFlag` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`userId`),
  UNIQUE KEY `usernameCAS_UNIQUE` (`usernameCAS`),
  UNIQUE KEY `uName_UNIQUE` (`uName`)
) ENGINE=InnoDB AUTO_INCREMENT=46 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 (1,'cschahczenski','Celia Schahczenski',1),(2,'twindham','Tami Windham',1),(3,'jbraun','Jeff Braun',1),(4,'mvandyne','Michele VanDyne',1),(6,'fackerman','Frank Ackerman',1),(13,'PCurtiss','Phillip Curtiss',1),(14,'BDonoven','Brent Donoven',1),(29,'TMiller','Terra Miller',0),(30,'LStout','Lucas Stout',1),(32,'coneill1','Chris Oneill',1),(33,'JBeaudry','Joe Beaudry',1),(34,'MFryer','Michael Fryer',1),(36,'plippert','Payson Lippert',0),(37,'cfiechtner','Carson Fiechtner',1),(38,'ZValenzuela','Zachariah Valenzuela',0),(39,'jyates','Jordan Yates',1),(41,'gmarlowe','Greg Marlowe',1),(45,'tfricks','Tyler Fricks',0);
/*!40000 ALTER TABLE `User` 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 2018-02-26 16:18:16
