INSERT INTO `department` (`deptID`, `deptName`, `departmentDesc`, `deptShow`, `admissionshow`)
VALUES
  (999, 'DEPT999', 'DEPT999', 1, 1);

INSERT INTO `batches` (`batchID`, `batchName`, `batchDesc`, `batchStartYear`, `batchEndYear`, `batchCreateTime`, `deptID`, `semID`, `batchHide`, `totalSemester`, `stream`, `course_type_id`, `universityId`, `studentSortBy`)
VALUES
  (999, 'BATCH999', '', '2016', '2020', '2018-03-19 15:46:28', 1, 4, 0, NULL, '', 1, NULL, 'rollNo');
INSERT INTO `subjects` (`subjectID`, `subjectName`, `subjectDesc`, `deptID`, `syllabusName`, `subjectPriority`, `hdl_deptID`, `subject_type`, `subjectCategory`, `hide`)
VALUES
  (999, 'SUBJECT1', 'SUBJECT1', 999, 'MA102', 1, 999, NULL, NULL, 0);

INSERT INTO `exam` (`examID`, `examName`, `subjectID`, `examTotalMarks`, `examStartTime`, `examEndTime`, `examDate`, `batchID`, `semID`, `examTypeID`, `unixtime_start`, `unixtime_end`, `examCode`, `courseID`, `created_by`, `subbatchID`, `canShow`)
VALUES
  (999, 'EXAM1', 999, 20, '9:00 AM', '10:00 AM', '2018-02-06', 999, 4, 1, NULL, NULL, NULL, NULL, 0, 0, 1);

INSERT INTO `sbs_relation` (`sbsID`, `staffID`, `batchID`, `subjectID`, `semID`, `csID`, `isPseudosubject`) VALUES ('999', '999', '999', '999', '999', '', '');
