SET FOREIGN_KEY_CHECKS=0; SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; DROP TABLE IF EXISTS `acad_program`; CREATE TABLE `acad_program` ( `id` bigint(20) NOT NULL, `acadProgCode` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `acadProgTitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `programDesc` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `currStatus` char(4) COLLATE utf8mb4_unicode_ci NOT NULL, `statusDate` date NOT NULL, `deptCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `schoolCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `acadYearCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `startDate` date NOT NULL, `endDate` date DEFAULT NULL, `degreeCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ccdCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `majorCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `minorCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `specCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `acadLevelCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cipCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `locationCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `approvedDate` date NOT NULL, `approvedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `acad_year`; CREATE TABLE `acad_year` ( `id` bigint(20) NOT NULL, `acadYearCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `acadYearDesc` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `activity_log`; CREATE TABLE `activity_log` ( `id` bigint(20) NOT NULL, `action` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL, `process` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `record` text COLLATE utf8mb4_unicode_ci, `uname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime NOT NULL, `expires_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `address`; CREATE TABLE `address` ( `id` bigint(20) NOT NULL, `personID` bigint(20) NOT NULL, `address1` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `address2` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `city` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL, `state` char(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `zip` char(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` char(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addressType` char(4) COLLATE utf8mb4_unicode_ci NOT NULL, `startDate` date NOT NULL, `endDate` date DEFAULT NULL, `addressStatus` char(4) COLLATE utf8mb4_unicode_ci NOT NULL, `phone1` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone2` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ext1` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ext2` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phoneType1` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phoneType2` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addDate` date NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `application`; CREATE TABLE `application` ( `id` bigint(20) NOT NULL, `personID` bigint(20) NOT NULL, `acadProgCode` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `startTerm` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `admitStatus` char(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `exam` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `PSAT_Verbal` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `PSAT_Math` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `SAT_Verbal` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `SAT_Math` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ACT_English` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ACT_Math` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `applStatus` enum('Pending','Under Review','Accepted','Not Accepted') COLLATE utf8mb4_unicode_ci NOT NULL, `applDate` date NOT NULL, `appl_comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `staff_comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addDate` date NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `assignment`; CREATE TABLE `assignment` ( `id` bigint(20) NOT NULL, `courseSecID` bigint(20) DEFAULT NULL, `facID` bigint(20) NOT NULL, `shortName` char(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dueDate` date DEFAULT NULL, `addDate` date NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `billing_table`; CREATE TABLE `billing_table` ( `id` int(11) NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` decimal(10,2) NOT NULL DEFAULT '0.00', `status` enum('A','I') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'A', `addDate` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `building`; CREATE TABLE `building` ( `id` int(11) NOT NULL, `buildingCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `buildingName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `locationCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `ccd`; CREATE TABLE `ccd` ( `id` int(11) NOT NULL, `ccdCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `ccdName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `addDate` date NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `cip`; CREATE TABLE `cip` ( `id` int(11) NOT NULL, `cipCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `cipName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `country`; CREATE TABLE `country` ( `id` int(5) NOT NULL, `iso2` char(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `short_name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `long_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `iso3` char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `numcode` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `un_member` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `calling_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cctld` char(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `course`; CREATE TABLE `course` ( `courseID` bigint(20) NOT NULL, `courseNumber` int(8) NOT NULL, `courseCode` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `subjectCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deptCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `courseDesc` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `creditType` char(6) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'I', `minCredit` decimal(4,1) NOT NULL DEFAULT '0.0', `maxCredit` decimal(4,1) NOT NULL DEFAULT '0.0', `increCredit` decimal(4,1) NOT NULL DEFAULT '0.0', `courseLevelCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `acadLevelCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `courseShortTitle` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL, `courseLongTitle` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `preReq` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `allowAudit` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `allowWaitlist` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `minEnroll` int(3) DEFAULT NULL, `seatCap` int(3) DEFAULT NULL, `startDate` date NOT NULL, `endDate` date DEFAULT NULL, `currStatus` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL, `statusDate` date DEFAULT NULL, `approvedDate` date DEFAULT NULL, `approvedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `course_sec`; CREATE TABLE `course_sec` ( `courseSecID` bigint(20) NOT NULL, `sectionNumber` char(8) COLLATE utf8mb4_unicode_ci NOT NULL, `courseSecCode` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `courseSection` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `buildingCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `roomCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `locationCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `courseLevelCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `acadLevelCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deptCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `facID` bigint(20) DEFAULT NULL, `termCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `courseID` bigint(20) NOT NULL, `courseCode` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `preReqs` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `secShortTitle` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL, `startDate` date NOT NULL, `endDate` date NOT NULL, `startTime` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `endTime` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dotw` varchar(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `minCredit` decimal(4,1) NOT NULL DEFAULT '0.0', `maxCredit` decimal(4,1) NOT NULL DEFAULT '0.0', `increCredit` decimal(4,1) NOT NULL DEFAULT '0.0', `ceu` decimal(4,1) NOT NULL DEFAULT '0.0', `instructorMethod` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `instructorLoad` decimal(4,1) NOT NULL DEFAULT '0.0', `contactHours` decimal(4,1) NOT NULL DEFAULT '0.0', `webReg` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1', `courseFee` decimal(10,2) NOT NULL DEFAULT '0.00', `labFee` decimal(10,2) NOT NULL DEFAULT '0.00', `materialFee` decimal(10,2) NOT NULL DEFAULT '0.00', `secType` enum('ONL','HB','ONC') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ONC', `currStatus` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL, `statusDate` date NOT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `approvedDate` date NOT NULL, `approvedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `currency_code`; CREATE TABLE `currency_code` ( `id` int(11) NOT NULL, `country_currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `currency_code` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `code_2000` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL, `arial_unicode_ms` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL, `unicode_decimal` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, `unicode_hex` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `degree`; CREATE TABLE `degree` ( `id` int(11) NOT NULL, `degreeCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `degreeName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `department`; CREATE TABLE `department` ( `id` int(11) NOT NULL, `deptTypeCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `deptCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `deptName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `deptEmail` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deptPhone` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deptDesc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `email_hold`; CREATE TABLE `email_hold` ( `id` bigint(20) NOT NULL, `personID` bigint(20) NOT NULL, `queryID` int(11) NOT NULL, `fromName` varchar(118) COLLATE utf8mb4_unicode_ci NOT NULL, `fromEmail` varchar(118) COLLATE utf8mb4_unicode_ci NOT NULL, `subject` varchar(118) COLLATE utf8mb4_unicode_ci NOT NULL, `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `processed` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `dateTime` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `email_queue`; CREATE TABLE `email_queue` ( `id` bigint(20) NOT NULL, `holdID` bigint(20) NOT NULL, `personID` bigint(20) NOT NULL, `fromName` varchar(118) COLLATE utf8mb4_unicode_ci NOT NULL, `fromEmail` varchar(118) COLLATE utf8mb4_unicode_ci NOT NULL, `uname` varchar(118) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(118) COLLATE utf8mb4_unicode_ci NOT NULL, `fname` varchar(118) COLLATE utf8mb4_unicode_ci NOT NULL, `lname` varchar(118) COLLATE utf8mb4_unicode_ci NOT NULL, `subject` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `sent` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `sentDate` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `email_template`; CREATE TABLE `email_template` ( `id` int(11) NOT NULL, `deptCode` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_key` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_value` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `error`; CREATE TABLE `error` ( `id` bigint(20) NOT NULL, `type` int(10) NOT NULL, `time` int(10) NOT NULL, `string` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `file` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `line` int(10) NOT NULL, `addDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `event`; CREATE TABLE `event` ( `eventID` bigint(20) NOT NULL, `eventType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `catID` int(11) DEFAULT NULL, `requestor` bigint(20) NOT NULL, `roomCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `termCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `weekday` tinyint(4) DEFAULT NULL, `startDate` date DEFAULT NULL, `startTime` time DEFAULT NULL, `endTime` time DEFAULT NULL, `repeats` tinyint(4) DEFAULT NULL, `repeatFreq` tinyint(4) DEFAULT NULL, `status` enum('A','I') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'A', `addDate` date NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `event_category`; CREATE TABLE `event_category` ( `catID` int(11) NOT NULL, `cat_name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `bgcolor` char(22) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '#' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `event_meta`; CREATE TABLE `event_meta` ( `eventMetaID` bigint(20) NOT NULL, `eventID` bigint(20) NOT NULL, `roomCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `requestor` bigint(20) NOT NULL, `start` datetime DEFAULT NULL, `end` datetime DEFAULT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addDate` date NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `event_request`; CREATE TABLE `event_request` ( `requestID` bigint(20) NOT NULL, `eventType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `catID` int(11) DEFAULT NULL, `requestor` bigint(20) NOT NULL, `roomCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `termCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `weekday` tinyint(4) NOT NULL, `startDate` date NOT NULL, `endDate` date DEFAULT NULL, `startTime` time NOT NULL, `endTime` time NOT NULL, `repeats` tinyint(4) DEFAULT NULL, `repeatFreq` tinyint(4) DEFAULT NULL, `addDate` date NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `external_course`; CREATE TABLE `external_course` ( `id` bigint(20) NOT NULL, `courseTitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `instCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `courseName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `term` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `credits` decimal(4,2) NOT NULL, `currStatus` enum('A','I','P','O') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'A', `statusDate` date NOT NULL, `minGrade` char(6) COLLATE utf8mb4_unicode_ci NOT NULL, `comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `startDate` date NOT NULL, `endDate` date DEFAULT NULL, `addDate` date NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `gl_account`; CREATE TABLE `gl_account` ( `glacctID` int(11) NOT NULL, `gl_acct_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `gl_acct_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `gl_acct_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `gl_acct_memo` mediumtext COLLATE utf8mb4_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `gl_journal_entry`; CREATE TABLE `gl_journal_entry` ( `jeID` int(11) NOT NULL, `gl_jentry_date` date NOT NULL, `gl_jentry_manual_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gl_jentry_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gl_jentry_description` mediumtext COLLATE utf8mb4_unicode_ci, `gl_jentry_personID` bigint(20) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `gl_transaction`; CREATE TABLE `gl_transaction` ( `trID` int(11) NOT NULL, `jeID` int(11) DEFAULT NULL, `accountID` int(11) DEFAULT NULL, `gl_trans_date` date DEFAULT NULL, `gl_trans_memo` mediumtext COLLATE utf8mb4_unicode_ci, `gl_trans_debit` decimal(10,2) DEFAULT NULL, `gl_trans_credit` decimal(10,2) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `gradebook`; CREATE TABLE `gradebook` ( `id` bigint(20) NOT NULL, `assignID` bigint(20) NOT NULL, `courseSecID` bigint(20) DEFAULT NULL, `facID` bigint(20) NOT NULL, `stuID` bigint(20) NOT NULL, `grade` char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addDate` date NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `grade_scale`; CREATE TABLE `grade_scale` ( `id` int(11) NOT NULL, `grade` char(6) COLLATE utf8mb4_unicode_ci NOT NULL, `percent` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL, `points` decimal(6,2) NOT NULL, `count_in_gpa` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1', `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `graduation_hold`; CREATE TABLE `graduation_hold` ( `id` bigint(20) NOT NULL, `queryID` int(11) NOT NULL, `gradDate` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `hiatus`; CREATE TABLE `hiatus` ( `id` bigint(20) NOT NULL, `stuID` bigint(20) NOT NULL, `code` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `startDate` date NOT NULL, `endDate` date DEFAULT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addDate` date NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `institution`; CREATE TABLE `institution` ( `id` int(11) NOT NULL, `fice_ceeb` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `instType` char(10) COLLATE utf8mb4_unicode_ci NOT NULL, `instName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `city` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `state` char(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` char(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `institution_attended`; CREATE TABLE `institution_attended` ( `id` bigint(20) NOT NULL, `fice_ceeb` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `personID` bigint(20) NOT NULL, `fromDate` date NOT NULL, `toDate` date NOT NULL, `major` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `degree_awarded` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `degree_conferred_date` date NOT NULL, `GPA` decimal(6,4) DEFAULT NULL, `addDate` date NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `job`; CREATE TABLE `job` ( `id` int(11) NOT NULL, `pay_grade` int(11) NOT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `hourly_wage` decimal(10,2) DEFAULT NULL, `weekly_hours` int(6) DEFAULT NULL, `attachment` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addDate` date NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `job_status`; CREATE TABLE `job_status` ( `id` int(11) NOT NULL, `typeCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `location`; CREATE TABLE `location` ( `id` int(11) NOT NULL, `locationCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `locationName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `major`; CREATE TABLE `major` ( `id` int(11) NOT NULL, `majorCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `majorName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `met_link`; CREATE TABLE `met_link` ( `id` int(11) NOT NULL, `link_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `link_src` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL, `sort` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `met_news`; CREATE TABLE `met_news` ( `id` int(11) NOT NULL, `news_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `news_slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `news_content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('draft','publish') COLLATE utf8mb4_unicode_ci NOT NULL, `addedBy` bigint(20) NOT NULL, `addDate` date NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `met_page`; CREATE TABLE `met_page` ( `id` int(11) NOT NULL, `page_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `page_slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `page_content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('draft','publish') COLLATE utf8mb4_unicode_ci NOT NULL, `sort` tinyint(4) NOT NULL, `addedBy` bigint(20) NOT NULL, `addDate` date NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `migrations`; CREATE TABLE `migrations` ( `version` bigint(20) UNSIGNED ZEROFILL NOT NULL, `migration_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `breakpoint` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `minor`; CREATE TABLE `minor` ( `id` int(11) NOT NULL, `minorCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `minorName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `options_meta`; CREATE TABLE `options_meta` ( `meta_id` int(11) NOT NULL, `meta_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `meta_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `payment`; CREATE TABLE `payment` ( `id` bigint(20) NOT NULL, `stuID` bigint(20) NOT NULL, `termCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `amount` decimal(10,2) NOT NULL DEFAULT '0.00', `checkNum` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paypal_txnID` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paypal_payment_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paypal_txn_fee` decimal(6,2) NOT NULL DEFAULT '0.00', `paymentTypeID` int(11) NOT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paymentDate` date NOT NULL, `postedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `payment_type`; CREATE TABLE `payment_type` ( `id` int(11) NOT NULL, `type` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `pay_grade`; CREATE TABLE `pay_grade` ( `id` int(11) NOT NULL, `grade` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `minimum_salary` decimal(10,2) NOT NULL, `maximum_salary` decimal(10,2) NOT NULL, `addDate` date NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `permission`; CREATE TABLE `permission` ( `id` bigint(20) UNSIGNED NOT NULL, `permKey` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL, `permName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `person`; CREATE TABLE `person` ( `personID` bigint(20) NOT NULL, `altID` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uname` char(80) COLLATE utf8mb4_unicode_ci NOT NULL, `prefix` char(6) COLLATE utf8mb4_unicode_ci NOT NULL, `personType` char(8) COLLATE utf8mb4_unicode_ci NOT NULL, `fname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `lname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `mname` char(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `ssn` int(9) DEFAULT NULL, `dob` date DEFAULT NULL, `veteran` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL, `ethnicity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gender` enum('M','F') COLLATE utf8mb4_unicode_ci NOT NULL, `emergency_contact` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `emergency_contact_phone` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `photo` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('A','I') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'A', `auth_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `approvedDate` datetime NOT NULL, `approvedBy` bigint(20) DEFAULT NULL, `LastLogin` datetime DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `person_perms`; CREATE TABLE `person_perms` ( `id` bigint(20) UNSIGNED NOT NULL, `personID` bigint(20) NOT NULL, `permission` text COLLATE utf8mb4_unicode_ci NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `person_roles`; CREATE TABLE `person_roles` ( `id` int(11) NOT NULL, `personID` bigint(20) NOT NULL, `roleID` bigint(20) NOT NULL, `addDate` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `plugin`; CREATE TABLE `plugin` ( `id` int(11) NOT NULL, `location` text COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `refund`; CREATE TABLE `refund` ( `id` bigint(20) NOT NULL, `stuID` bigint(20) NOT NULL, `termCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `amount` decimal(10,2) NOT NULL DEFAULT '0.00', `comment` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `refundDate` date NOT NULL, `postedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `restriction`; CREATE TABLE `restriction` ( `id` bigint(20) NOT NULL, `personID` bigint(20) NOT NULL, `code` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `severity` tinyint(4) DEFAULT NULL, `startDate` date NOT NULL, `endDate` date DEFAULT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addDate` date NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `restriction_code`; CREATE TABLE `restriction_code` ( `id` int(11) NOT NULL, `code` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `deptCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `role`; CREATE TABLE `role` ( `id` bigint(20) UNSIGNED NOT NULL, `roleName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `permission` longtext COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `role_perms`; CREATE TABLE `role_perms` ( `id` bigint(20) UNSIGNED NOT NULL, `roleID` bigint(20) NOT NULL, `permID` bigint(20) NOT NULL, `value` tinyint(4) NOT NULL DEFAULT '0', `addDate` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `room`; CREATE TABLE `room` ( `id` int(11) NOT NULL, `roomCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `buildingCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `roomNumber` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `roomCap` tinyint(4) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `saved_query`; CREATE TABLE `saved_query` ( `id` bigint(20) NOT NULL, `personID` bigint(20) NOT NULL, `savedQueryName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `savedQuery` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `purgeQuery` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `shared` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `createdDate` date NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `school`; CREATE TABLE `school` ( `id` int(11) NOT NULL, `schoolCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `schoolName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `buildingCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `screen`; CREATE TABLE `screen` ( `id` int(11) NOT NULL, `code` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `relativeURL` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `semester`; CREATE TABLE `semester` ( `id` bigint(20) NOT NULL, `acadYearCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `semCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `semName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `semStartDate` date DEFAULT NULL, `semEndDate` date DEFAULT NULL, `active` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `specialization`; CREATE TABLE `specialization` ( `id` int(11) NOT NULL, `specCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `specName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `staff`; CREATE TABLE `staff` ( `id` bigint(20) NOT NULL, `staffID` bigint(20) NOT NULL, `schoolCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `buildingCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `officeCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `office_phone` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deptCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('A','I') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'A', `addDate` date NOT NULL, `approvedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `staff_meta`; CREATE TABLE `staff_meta` ( `id` bigint(20) NOT NULL, `jobStatusCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `jobID` int(11) DEFAULT NULL, `staffID` bigint(20) NOT NULL, `supervisorID` bigint(20) DEFAULT NULL, `staffType` char(8) COLLATE utf8mb4_unicode_ci NOT NULL, `hireDate` date DEFAULT NULL, `startDate` date DEFAULT NULL, `endDate` date DEFAULT NULL, `addDate` date DEFAULT NULL, `approvedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `state`; CREATE TABLE `state` ( `id` int(11) UNSIGNED NOT NULL, `code` char(4) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `student`; CREATE TABLE `student` ( `id` bigint(20) NOT NULL, `stuID` bigint(20) NOT NULL, `status` enum('A','I') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'A', `tags` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addDate` datetime NOT NULL, `approvedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `student_load_rule`; CREATE TABLE `student_load_rule` ( `id` int(11) NOT NULL, `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL, `min_cred` double(4,1) NOT NULL, `max_cred` double(4,1) NOT NULL, `term` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `acadLevelCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `active` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `stu_acad_cred`; CREATE TABLE `stu_acad_cred` ( `id` bigint(20) NOT NULL, `stuID` bigint(20) NOT NULL, `courseID` bigint(20) DEFAULT NULL, `courseSecID` bigint(20) DEFAULT NULL, `courseCode` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `courseSecCode` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sectionNumber` char(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `courseSection` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `termCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reportingTerm` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subjectCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deptCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `shortTitle` char(60) COLLATE utf8mb4_unicode_ci NOT NULL, `longTitle` char(80) COLLATE utf8mb4_unicode_ci NOT NULL, `compCred` decimal(4,1) NOT NULL DEFAULT '0.00', `gradePoints` decimal(4,2) NOT NULL DEFAULT '0.00', `attCred` decimal(4,1) NOT NULL DEFAULT '0.00', `ceu` decimal(4,1) NOT NULL DEFAULT '0.0', `status` enum('A','N','D','W','C') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'A', `statusDate` date NOT NULL, `statusTime` char(10) COLLATE utf8mb4_unicode_ci NOT NULL, `acadLevelCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `courseLevelCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `grade` char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `creditType` char(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'I', `startDate` date NOT NULL, `endDate` date DEFAULT NULL, `addedBy` bigint(20) NOT NULL, `addDate` date DEFAULT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `stu_acad_level`; CREATE TABLE `stu_acad_level` ( `id` bigint(20) NOT NULL, `stuID` bigint(20) NOT NULL, `acadProgCode` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `acadLevelCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addDate` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `stu_acct_bill`; CREATE TABLE `stu_acct_bill` ( `id` bigint(20) NOT NULL, `billID` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `stuID` bigint(20) NOT NULL, `termCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `authCode` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `stu_comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `staff_comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `balanceDue` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1', `postedBy` bigint(20) NOT NULL, `billingDate` date NOT NULL, `billTimeStamp` datetime NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `stu_acct_fee`; CREATE TABLE `stu_acct_fee` ( `id` bigint(20) NOT NULL, `billID` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `stuID` bigint(20) NOT NULL, `termCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` decimal(10,2) NOT NULL, `feeDate` date NOT NULL, `feeTimeStamp` datetime NOT NULL, `postedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `stu_acct_pp`; CREATE TABLE `stu_acct_pp` ( `id` bigint(20) NOT NULL, `stuID` bigint(20) NOT NULL, `termCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payFrequency` enum('1','7','14','30','365') COLLATE utf8mb4_unicode_ci NOT NULL, `amount` decimal(10,2) NOT NULL, `startDate` date NOT NULL, `endDate` date DEFAULT NULL, `comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addDate` date NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `stu_acct_tuition`; CREATE TABLE `stu_acct_tuition` ( `id` bigint(20) NOT NULL, `stuID` bigint(20) NOT NULL, `termCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `total` decimal(10,2) NOT NULL, `postedBy` bigint(20) NOT NULL, `tuitionTimeStamp` datetime NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `stu_course_sec`; CREATE TABLE `stu_course_sec` ( `id` bigint(20) NOT NULL, `stuID` bigint(20) NOT NULL, `courseSecID` bigint(20) DEFAULT NULL, `courseSecCode` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `courseSection` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `termCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `courseCredits` decimal(4,1) NOT NULL DEFAULT '0.0', `ceu` decimal(4,1) NOT NULL DEFAULT '0.0', `regDate` date DEFAULT NULL, `regTime` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('A','N','D','W','C') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'A', `statusDate` date NOT NULL, `statusTime` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `addedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `stu_program`; CREATE TABLE `stu_program` ( `id` bigint(20) NOT NULL, `stuID` bigint(20) NOT NULL, `advisorID` bigint(20) DEFAULT NULL, `catYearCode` char(22) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `acadProgCode` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `currStatus` char(4) COLLATE utf8mb4_unicode_ci NOT NULL, `eligible_to_graduate` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `antGradDate` char(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `graduationDate` date DEFAULT NULL, `statusDate` date NOT NULL, `startDate` date NOT NULL, `endDate` date DEFAULT NULL, `comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `approvedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `stu_rgn_cart`; CREATE TABLE `stu_rgn_cart` ( `stuID` bigint(20) NOT NULL, `courseSecID` bigint(20) NOT NULL, `deleteDate` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `stu_term`; CREATE TABLE `stu_term` ( `stuID` bigint(20) NOT NULL, `termCode` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL, `termCredits` double(6,1) NOT NULL DEFAULT '0.0', `addDateTime` datetime NOT NULL, `acadLevelCode` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `stu_term_gpa`; CREATE TABLE `stu_term_gpa` ( `stuID` bigint(20) NOT NULL, `termCode` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL, `acadLevelCode` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, `attCred` double(4,1) NOT NULL DEFAULT '0.0', `compCred` double(4,1) NOT NULL DEFAULT '0.0', `gradePoints` double(4,1) NOT NULL DEFAULT '0.0', `termGPA` double(4,2) NOT NULL DEFAULT '0.00', `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `stu_term_load`; CREATE TABLE `stu_term_load` ( `stuID` bigint(20) NOT NULL, `termCode` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL, `stuLoad` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL, `acadLevelCode` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `subject`; CREATE TABLE `subject` ( `id` int(11) NOT NULL, `subjectCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `subjectName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `term`; CREATE TABLE `term` ( `id` bigint(20) NOT NULL, `semCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `termCode` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `termName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `reportingTerm` char(22) COLLATE utf8mb4_unicode_ci NOT NULL, `dropAddEndDate` date DEFAULT NULL, `termStartDate` date DEFAULT NULL, `termEndDate` date DEFAULT NULL, `active` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `timesheet`; CREATE TABLE `timesheet` ( `id` bigint(20) NOT NULL, `employeeID` bigint(20) NOT NULL, `jobID` int(11) NOT NULL, `workWeek` date DEFAULT NULL, `startDateTime` datetime NOT NULL, `endDateTime` datetime NOT NULL, `note` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('P','R','A') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'P', `addDate` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `addedBy` bigint(20) NOT NULL, `approvedBy` bigint(20) NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `transfer_credit`; CREATE TABLE `transfer_credit` ( `id` bigint(20) NOT NULL, `equivID` bigint(20) NOT NULL, `stacID` bigint(20) NOT NULL, `addedBy` bigint(20) NOT NULL, `addDate` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `transfer_equivalent`; CREATE TABLE `transfer_equivalent` ( `id` bigint(20) NOT NULL, `extrID` bigint(20) NOT NULL, `courseID` bigint(20) NOT NULL, `startDate` date NOT NULL, `endDate` date DEFAULT NULL, `grade` char(6) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addedBy` bigint(20) NOT NULL, `addDate` date NOT NULL, `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; ALTER TABLE `acad_program` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `acadProgCode` (`acadProgCode`), ADD KEY `acad_program_deptCode` (`deptCode`), ADD KEY `acad_program_locationCode` (`locationCode`), ADD KEY `acad_program_schoolCode` (`schoolCode`), ADD KEY `acad_program_acadYearCode` (`acadYearCode`), ADD KEY `acad_program_degreeCode` (`degreeCode`), ADD KEY `acad_program_ccdCode` (`ccdCode`), ADD KEY `acad_program_majorCode` (`majorCode`), ADD KEY `acad_program_minorCode` (`minorCode`), ADD KEY `acad_program_specCode` (`specCode`), ADD KEY `acad_program_cipCode` (`cipCode`), ADD KEY `acad_program_acadLevelCode` (`acadLevelCode`), ADD KEY `acad_program_approvedBy` (`approvedBy`); ALTER TABLE `acad_year` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `acadYearCode` (`acadYearCode`); ALTER TABLE `activity_log` ADD PRIMARY KEY (`id`); ALTER TABLE `address` ADD PRIMARY KEY (`id`), ADD KEY `address_personID` (`personID`), ADD KEY `address_addedBy` (`addedBy`); ALTER TABLE `application` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personID` (`personID`,`acadProgCode`), ADD KEY `application_acadProgCode` (`acadProgCode`), ADD KEY `application_startTerm` (`startTerm`), ADD KEY `application_addedBy` (`addedBy`); ALTER TABLE `assignment` ADD PRIMARY KEY (`id`), ADD KEY `assignID` (`id`,`courseSecID`), ADD KEY `assignment_courseSecID` (`courseSecID`), ADD KEY `assignment_facID` (`facID`), ADD KEY `assignment_staffID` (`addedBy`); ALTER TABLE `billing_table` ADD PRIMARY KEY (`id`); ALTER TABLE `building` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `buildingCode` (`buildingCode`), ADD KEY `building_locationCode` (`locationCode`); ALTER TABLE `ccd` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `ccdCode` (`ccdCode`); ALTER TABLE `cip` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `cipCode` (`cipCode`); ALTER TABLE `country` ADD PRIMARY KEY (`id`); ALTER TABLE `course` ADD PRIMARY KEY (`courseID`), ADD KEY `courseCode` (`courseCode`,`courseLevelCode`), ADD KEY `course_subjectCode` (`subjectCode`), ADD KEY `course_deptCode` (`deptCode`), ADD KEY `course_courseLevelCode` (`courseLevelCode`), ADD KEY `course_acadLevelCode` (`acadLevelCode`), ADD KEY `course_approvedBy` (`approvedBy`); ALTER TABLE `course_sec` ADD PRIMARY KEY (`courseSecID`), ADD UNIQUE KEY `courseSection` (`courseSection`), ADD KEY `course_sec_buildingCode` (`buildingCode`), ADD KEY `course_sec_roomCode` (`roomCode`), ADD KEY `course_sec_locationCode` (`locationCode`), ADD KEY `course_sec_deptCode` (`deptCode`), ADD KEY `course_sec_termCode` (`termCode`), ADD KEY `course_sec_courseLevelCode` (`courseLevelCode`), ADD KEY `course_sec_acadLevelCode` (`acadLevelCode`), ADD KEY `course_sec_courseID` (`courseID`), ADD KEY `course_sec_approvedBy` (`approvedBy`), ADD KEY `courseSecCode` (`courseSecCode`,`currStatus`,`facID`,`courseCode`); ALTER TABLE `currency_code` ADD PRIMARY KEY (`id`); ALTER TABLE `degree` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `degreeCode` (`degreeCode`); ALTER TABLE `department` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `deptCode` (`deptCode`); ALTER TABLE `email_hold` ADD PRIMARY KEY (`id`); ALTER TABLE `email_queue` ADD PRIMARY KEY (`id`); ALTER TABLE `email_template` ADD PRIMARY KEY (`id`), ADD KEY `deptCode` (`deptCode`); ALTER TABLE `error` ADD PRIMARY KEY (`id`); ALTER TABLE `event` ADD PRIMARY KEY (`eventID`), ADD UNIQUE KEY `roomCode` (`roomCode`,`termCode`,`title`,`weekday`,`startDate`,`startTime`,`endTime`), ADD KEY `event_catID` (`catID`), ADD KEY `event_requestor` (`requestor`), ADD KEY `event_termCode` (`termCode`), ADD KEY `event_addedBy` (`addedBy`); ALTER TABLE `event_category` ADD PRIMARY KEY (`catID`); ALTER TABLE `event_meta` ADD PRIMARY KEY (`eventMetaID`), ADD UNIQUE KEY `eventID` (`eventID`,`roomCode`,`start`,`end`,`title`), ADD KEY `event_meta_roomCode` (`roomCode`), ADD KEY `event_meta_requestor` (`requestor`), ADD KEY `event_meta_addedBy` (`addedBy`); ALTER TABLE `event_request` ADD PRIMARY KEY (`requestID`), ADD UNIQUE KEY `roomCode` (`roomCode`,`termCode`,`title`,`weekday`,`startDate`,`startTime`,`endTime`), ADD KEY `event_request_requestor` (`requestor`), ADD KEY `event_request_termCode` (`termCode`); ALTER TABLE `external_course` ADD PRIMARY KEY (`id`), ADD KEY `external_course_instCode` (`instCode`), ADD KEY `external_course_addedBy` (`addedBy`); ALTER TABLE `gl_account` ADD PRIMARY KEY (`glacctID`), ADD UNIQUE KEY `gl_acct_number` (`gl_acct_number`); ALTER TABLE `gl_journal_entry` ADD PRIMARY KEY (`jeID`); ALTER TABLE `gl_transaction` ADD PRIMARY KEY (`trID`), ADD KEY `gl_transaction_jeID` (`jeID`); ALTER TABLE `gradebook` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `assignID` (`assignID`,`facID`,`stuID`), ADD KEY `gradebook_courseSecID` (`courseSecID`), ADD KEY `gradebook_facID` (`facID`), ADD KEY `gradebook_stuID` (`stuID`), ADD KEY `gradebook_addedBy` (`addedBy`); ALTER TABLE `grade_scale` ADD PRIMARY KEY (`id`); ALTER TABLE `graduation_hold` ADD PRIMARY KEY (`id`); ALTER TABLE `hiatus` ADD PRIMARY KEY (`id`), ADD KEY `hiatus_stuID` (`stuID`), ADD KEY `hiatus_addedBy` (`addedBy`) USING BTREE; ALTER TABLE `institution` ADD PRIMARY KEY (`id`), ADD KEY `fice_ceeb` (`fice_ceeb`); ALTER TABLE `institution_attended` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `fice_ceeb` (`fice_ceeb`,`personID`), ADD KEY `institution_attended_personID` (`personID`), ADD KEY `institution_attended_addedBy` (`addedBy`); ALTER TABLE `job` ADD PRIMARY KEY (`id`), ADD KEY `job_addedBy` (`addedBy`); ALTER TABLE `job_status` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `typeCode` (`typeCode`); ALTER TABLE `location` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `locationCode` (`locationCode`); ALTER TABLE `major` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `majorCode` (`majorCode`); ALTER TABLE `met_link` ADD PRIMARY KEY (`id`); ALTER TABLE `met_news` ADD PRIMARY KEY (`id`), ADD KEY `addedBy` (`addedBy`); ALTER TABLE `met_page` ADD PRIMARY KEY (`id`), ADD KEY `addedBy` (`addedBy`); ALTER TABLE `migrations` ADD PRIMARY KEY (`version`); ALTER TABLE `minor` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `minorCode` (`minorCode`); ALTER TABLE `options_meta` ADD PRIMARY KEY (`meta_id`), ADD UNIQUE KEY `meta_key` (`meta_key`); ALTER TABLE `payment` ADD PRIMARY KEY (`id`), ADD KEY `payment_postedBy` (`postedBy`), ADD KEY `payment_stuID` (`stuID`), ADD KEY `payment_termCode` (`termCode`); ALTER TABLE `payment_type` ADD PRIMARY KEY (`id`); ALTER TABLE `pay_grade` ADD PRIMARY KEY (`id`), ADD KEY `addedBy` (`addedBy`); ALTER TABLE `permission` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `permKey` (`permKey`); ALTER TABLE `person` ADD PRIMARY KEY (`personID`), ADD UNIQUE KEY `uname` (`uname`), ADD KEY `personType` (`personType`), ADD KEY `person_approvedBy` (`approvedBy`); ALTER TABLE `person_perms` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personID` (`personID`); ALTER TABLE `person_roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personID` (`personID`,`roleID`); ALTER TABLE `plugin` ADD PRIMARY KEY (`id`); ALTER TABLE `refund` ADD PRIMARY KEY (`id`), ADD KEY `refund_personID` (`postedBy`), ADD KEY `refund_stuID` (`stuID`), ADD KEY `refund_termCode` (`termCode`); ALTER TABLE `restriction` ADD PRIMARY KEY (`id`), ADD KEY `restriction_personID` (`personID`), ADD KEY `restriction_code` (`code`), ADD KEY `restriction_staffID` (`addedBy`); ALTER TABLE `restriction_code` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `code` (`code`), ADD KEY `restriction_code_deptCode` (`deptCode`); ALTER TABLE `role` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `roleName` (`roleName`); ALTER TABLE `role_perms` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `roleID` (`roleID`,`permID`); ALTER TABLE `room` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `roomCode` (`roomCode`), ADD KEY `room_buildingCode` (`buildingCode`); ALTER TABLE `saved_query` ADD PRIMARY KEY (`id`), ADD KEY `saved_query_personID` (`personID`); ALTER TABLE `school` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `schoolCode` (`schoolCode`), ADD KEY `school_buildingCode` (`buildingCode`); ALTER TABLE `screen` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `code` (`code`); ALTER TABLE `semester` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `semCode` (`semCode`), ADD KEY `semester_acadYearCode` (`acadYearCode`); ALTER TABLE `specialization` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `specCode` (`specCode`); ALTER TABLE `staff` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `staffID` (`staffID`), ADD KEY `staff_schoolCode` (`schoolCode`), ADD KEY `staff_buildingCode` (`buildingCode`), ADD KEY `staff_officeCode` (`officeCode`), ADD KEY `staff_deptCode` (`deptCode`), ADD KEY `staff_approvedBy` (`approvedBy`); ALTER TABLE `staff_meta` ADD PRIMARY KEY (`id`), ADD KEY `staff_meta_staffID` (`staffID`), ADD KEY `staff_meta_supervisorID` (`supervisorID`), ADD KEY `staff_meta_jobStatusCode` (`jobStatusCode`), ADD KEY `staff_meta_jobID` (`jobID`), ADD KEY `staff_meta_approvedBy` (`approvedBy`); ALTER TABLE `state` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `code` (`code`); ALTER TABLE `student` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `stuID` (`stuID`), ADD KEY `status` (`status`), ADD KEY `student_approvedBy` (`approvedBy`); ALTER TABLE `student_load_rule` ADD PRIMARY KEY (`id`); ALTER TABLE `stu_acad_cred` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `stuID` (`stuID`,`courseSecID`), ADD KEY `status` (`status`,`courseCode`), ADD KEY `stu_acad_cred_courseID` (`courseID`), ADD KEY `stu_acad_cred_courseSecID` (`courseSecID`), ADD KEY `stu_acad_cred_courseSecCode` (`courseSecCode`), ADD KEY `stu_acad_cred_courseSection` (`courseSection`), ADD KEY `stu_acad_cred_termCode` (`termCode`), ADD KEY `stu_acad_cred_subjectCode` (`subjectCode`), ADD KEY `stu_acad_cred_deptCode` (`deptCode`), ADD KEY `stu_acad_cred_acadLevelCode` (`acadLevelCode`), ADD KEY `stu_acad_cred_courseLevelCode` (`courseLevelCode`), ADD KEY `stu_acad_cred_addedBy` (`addedBy`); ALTER TABLE `stu_acad_level` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `stuID` (`stuID`,`acadProgCode`), ADD KEY `stu_acad_level_acadProgCode` (`acadProgCode`), ADD KEY `stu_acad_level_acadLevelCode` (`acadLevelCode`); ALTER TABLE `stu_acct_bill` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `billID` (`billID`), ADD KEY `stu_acct_bill_stuID` (`stuID`), ADD KEY `stu_acct_bill_termCode` (`termCode`), ADD KEY `stu_acct_bill_postedBy` (`postedBy`); ALTER TABLE `stu_acct_fee` ADD PRIMARY KEY (`id`), ADD KEY `stu_acct_fee_billID` (`billID`), ADD KEY `stu_acct_fee_postedBy` (`postedBy`), ADD KEY `stu_acct_fee_stuID` (`stuID`), ADD KEY `stu_acct_fee_termCode` (`termCode`); ALTER TABLE `stu_acct_pp` ADD PRIMARY KEY (`id`), ADD KEY `stu_acct_pp_stuID` (`stuID`), ADD KEY `stu_acct_pp_termCode` (`termCode`), ADD KEY `stu_acct_pp_addedBy` (`addedBy`); ALTER TABLE `stu_acct_tuition` ADD PRIMARY KEY (`id`), ADD KEY `stu_acct_tuition_postedBy` (`postedBy`), ADD KEY `stu_acct_tuition_stuID` (`stuID`), ADD KEY `stu_acct_tuition_termCode` (`termCode`); ALTER TABLE `stu_course_sec` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `stuID` (`stuID`,`courseSecID`), ADD KEY `status` (`status`), ADD KEY `stu_course_sec_courseSecID` (`courseSecID`), ADD KEY `stu_course_sec_courseSecCode` (`courseSecCode`), ADD KEY `stu_course_sec_courseSection` (`courseSection`), ADD KEY `stu_course_sec_termCode` (`termCode`), ADD KEY `stu_course_sec_addedBy` (`addedBy`); ALTER TABLE `stu_program` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `stuID` (`stuID`,`acadProgCode`), ADD KEY `currStatus` (`currStatus`), ADD KEY `stu_program_acadProgCode` (`acadProgCode`), ADD KEY `stu_program_approvedBy` (`approvedBy`), ADD KEY `stu_program_advisorID` (`advisorID`), ADD KEY `stu_program_catYearCode` (`catYearCode`); ALTER TABLE `stu_rgn_cart` ADD UNIQUE KEY `stuID` (`stuID`,`courseSecID`); ALTER TABLE `stu_term` ADD UNIQUE KEY `stuTerm` (`stuID`,`termCode`,`acadLevelCode`), ADD KEY `termCode` (`termCode`); ALTER TABLE `stu_term_gpa` ADD UNIQUE KEY `stu_term_gpa_unique` (`stuID`,`termCode`,`acadLevelCode`), ADD KEY `termCode` (`termCode`); ALTER TABLE `stu_term_load` ADD UNIQUE KEY `stuTermLoad` (`stuID`,`termCode`,`acadLevelCode`), ADD KEY `student_load` (`stuLoad`), ADD KEY `termID` (`termCode`); ALTER TABLE `subject` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `subjectCode` (`subjectCode`); ALTER TABLE `term` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `termCode` (`termCode`), ADD KEY `semCode` (`semCode`); ALTER TABLE `timesheet` ADD PRIMARY KEY (`id`), ADD KEY `timesheet_employeeID` (`employeeID`), ADD KEY `timesheet_addedBy` (`addedBy`); ALTER TABLE `transfer_credit` ADD PRIMARY KEY (`id`), ADD KEY `transfer_credit_equivID` (`equivID`), ADD KEY `transfer_credit_stacID` (`stacID`), ADD KEY `transfer_credit_addedBy` (`addedBy`); ALTER TABLE `transfer_equivalent` ADD PRIMARY KEY (`id`), ADD KEY `transfer_equivalent_extrID` (`extrID`), ADD KEY `transfer_equivalent_courseID` (`courseID`), ADD KEY `transfer_equivalent_addedBy` (`addedBy`); ALTER TABLE `acad_program` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `acad_year` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `activity_log` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `address` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `application` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `assignment` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `billing_table` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `building` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `ccd` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `cip` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `country` MODIFY `id` int(5) NOT NULL AUTO_INCREMENT; ALTER TABLE `course` MODIFY `courseID` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `course_sec` MODIFY `courseSecID` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `currency_code` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `degree` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `department` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `email_hold` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `email_queue` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `email_template` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `error` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `event` MODIFY `eventID` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `event_category` MODIFY `catID` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `event_meta` MODIFY `eventMetaID` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `event_request` MODIFY `requestID` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `external_course` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `gl_account` MODIFY `glacctID` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `gl_journal_entry` MODIFY `jeID` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `gl_transaction` MODIFY `trID` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `gradebook` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `grade_scale` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `graduation_hold` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `hiatus` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `institution` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `institution_attended` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `job` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `job_status` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `location` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `major` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `met_link` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `met_news` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `met_page` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `minor` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `options_meta` MODIFY `meta_id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `payment` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `payment_type` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `pay_grade` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `permission` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `person` MODIFY `personID` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `person_perms` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `person_roles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `plugin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `refund` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `restriction` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `restriction_code` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `role` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `role_perms` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `room` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `saved_query` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `school` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `screen` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `semester` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `specialization` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `staff` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `staff_meta` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `state` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `student` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `student_load_rule` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `stu_acad_cred` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `stu_acad_level` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `stu_acct_bill` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `stu_acct_fee` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `stu_acct_pp` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `stu_acct_tuition` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `stu_course_sec` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `stu_program` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `subject` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `term` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `timesheet` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `transfer_credit` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `transfer_equivalent` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; SET FOREIGN_KEY_CHECKS=1;