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

INSERT INTO `staffaccounts` (`staffID`, `staffAccount`, `staffPassword`, `staffName`, `staffEmail`, `staffLastLogin`, `staffGender`, `staffBirthday`, `staffAddress`, `staffPhone`, `staffCreateDate`, `deptID`, `isHOD`, `isPrincipal`, `qualificationID`, `specializationID`, `yearOfPassing`, `instituteName`, `myImage`, `staffCode`, `qualificationID2`, `qualificationID3`, `qualificationID4`, `isFaculty`, `isResigned`, `other_designation`, `dateOfJoining`, `designationID`, `sectionID`, `list_order`, `academicDesignationID`, `bloodGroup`, `staffLock`, `aictCode`, `panNumber`, `aadharNumber`, `bankName`, `bankAccountNumber`, `ifscCode`, `rejoiningDate`, `areaOfSpecialization`, `dateOfPromotion`, `natureOfAssociation`)
VALUES
  (999, 'staff1', 'e10adc3949ba59abbe56e057f20f883e', 'staffName1', 'test999@test.com', '0000-00-00 00:00:00', 'male', '1970-01-01', 'staffAddress', '0000', '2017-09-17 22:01:14', 999, 0, 9, 1, 0, NULL, NULL, '', '1', 0, 0, 0, 0, 0, '', '2007-03-14', NULL, NULL, NULL, 1, 'AB-', 0, '', '', 0, '', '', '', NULL, NULL, NULL, NULL);

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 `studentaccount` (`studentID`, `studentAccount`, `studentPassword`, `studentLastLogin`, `studentName`, `studentEmail`, `studentGender`, `studentBirthday`, `studentAddress`, `studentPhone`, `studentLastupdate`, `studentCreateTime`, `deptID`, `batchID`, `student_lock`, `is_online`, `myImage`, `category`, `bloodGroup`, `admissionType`, `lateral`, `NRI`, `religion_bkp`, `community`, `admissionNo`, `rollNo`, `studentSurname`, `studentFather`, `studentMother`, `studentJoindate`, `sslc`, `plustwo`, `hosteller`, `parentPhone`, `parentPassword`, `regNo`, `feewaiverScheme`, `quotaID`, `studentLastName`, `homeTown`, `experience`, `yearOfPassing`, `qualification`, `tcIssued`, `transport`, `exitType`, `rfId`, `bankSID`, `ugPercentage`, `isBlockedFromLibrary`, `religion`, `casteID`, `fee_reservations_id`)
VALUES
  (999, 'student1', 'e10adc3949ba59abbe56e057f20f883e', '0000-00-00 00:00:00', 'studentName1', 'test1@test.com', NULL, NULL, 'studentaddress', '0000', '0000-00-00 00:00:00', '2018-03-20 19:06:57', 999, 999, 0, 0, '../studentsphoto/ASI//wgsb18aw25.jpg', NULL, NULL, NULL, 0, 0, 'Hindu', NULL, '2015/06/6814', '01', 'Surname', 'studentFather', 'studentMother', '0000-00-00', 0, 0, 2, '9496884377', 'e10adc3949ba59abbe56e057f20f883e', '', 0, NULL, '', '', NULL, NULL, '', 0, 1, NULL, NULL, '999102115066814', NULL, 0, 1, NULL, NULL);
INSERT INTO `adminaccount` (`adminID`, `adminAccount`, `adminPassword`, `adminLogin`, `adminName`, `adminEmail`, `adminGender`, `adminBirthday`, `adminAddress`, `adminPhone`, `adminExpire`, `adminDate`, `GroupID`, `admintypeID`, `isSupportAdmin`)
VALUES
  (999, 'superadmin', '21232f297a57a5a743894a0e4a801fc3', '0000-00-00 00:00:00', 'admin', 'admin@email.com', 'male', '2016-07-18', '', '000000000', '0000-00-00', '2018-07-05 14:07:59', 0, 1, 0);
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', '', '');
