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`, `isBlockedFromLibrary`, `libraryBlockReason`)
VALUES
  (1, 'staff1', 'e10adc3949ba59abbe56e057f20f883e', 'staffName1', 'test@test.com', '0000-00-00 00:00:00', 'female', '1985-08-17', 'staffAddress', '0000', '2018-03-20 19:07:58', 1, 0, 0, 1, 0, NULL, NULL, NULL, '203', 0, 0, 0, 1, 1, '', '2010-11-04', NULL, NULL, NULL, 3, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
  (2, 'staff2', 'e10adc3949ba59abbe56e057f20f883e', 'staffName2', 'test@test.com', '0000-00-00 00:00:00', 'female', '1981-02-19', 'staffAddress', '0000', '2018-03-20 19:07:58', 1, 0, 0, 12, 0, NULL, NULL, '../staffdocs/ASI/228/images//myphoto966478852.jpg', '228', 9, 0, 0, 1, 1, '', '2006-01-03', NULL, NULL, 50, 1, 'O+', 0, '', '', 0, '', '', '', NULL, 0, NULL),
  (3, 'staff3', 'e10adc3949ba59abbe56e057f20f883e', 'staffName3', 'test@test.com', '0000-00-00 00:00:00', 'female', '1974-11-04', 'staffAddress', '0000', '2018-03-20 19:07:58', 1, 0, 0, 12, 0, NULL, NULL, '../staffsphoto/ASI//59q0kf59p8.jpg', '380', 0, 0, 0, 1, 0, '', '2017-07-19', NULL, NULL, 12, 2, '-', 0, '', '', 0, '', '', '', NULL, 0, NULL),
  (4, 'staff4', 'e10adc3949ba59abbe56e057f20f883e', 'staffName4', 'test@test.com', '0000-00-00 00:00:00', 'male', '1987-09-16', 'staffAddress', '0000', '2018-03-20 19:07:58', 1, 0, 0, 12, 0, NULL, NULL, '../staffdocs/ASI/394/images//myphoto260210674.jpg', '394', 0, 0, 0, 1, 0, '', '2017-07-25', NULL, NULL, 13, 2, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
  (5, 'staff5', 'e10adc3949ba59abbe56e057f20f883e', 'staffName5', 'test@test.com', '0000-00-00 00:00:00', 'female', '1975-05-10', 'staffAddress', '0000', '2018-03-20 19:07:58', 1, 1, 0, 8, 0, NULL, NULL, '', '490', 12, 29, 0, 0, 0, '', '2018-01-01', NULL, NULL, 1, 1, '-', 0, '', '', 0, '', '', '', NULL, 0, NULL),
  (6, 'staff6', 'e10adc3949ba59abbe56e057f20f883e', 'staffName6', 'user@linways.com', '0000-00-00 00:00:00', 'male', '1983-07-15', 'staffAddress', '0000', '2018-03-20 19:07:58', 1, 0, 0, 12, 0, NULL, NULL, '../staffsphoto/ASI//j1j91becrj.jpg', '57', 6, 0, 0, 1, 0, '', '2008-07-01', NULL, NULL, 2, 2, 'B+', 0, '', '', 0, '', '', '', NULL, 0, NULL);

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`, `libraryBlockReason`, `joiningSemId`)
VALUES
  (1, 'student1', 'e10adc3949ba59abbe56e057f20f883e', '0000-00-00 00:00:00', 'studentName1', 'test@test.com', '', NULL, 'studentaddress', '0000', '0000-00-00 00:00:00', '2018-03-20 19:06:57', 1, 2, 0, 0, '../studentsphoto/ASI//wgsb18aw25.jpg', '', '', '', 0, 0, 'Hindu', '', '2015/06/6814', '01', 'Surname', 'studentFather', 'studentMother', '2018-07-24', 0, 0, 2, '9747943384', 'e10adc3949ba59abbe56e057f20f883e', '', 0, NULL, '', '', NULL, NULL, '', 0, 1, '', '', '999102115066814', 0, 0, NULL, NULL, NULL, NULL, NULL),
  (2, 'student2', 'e10adc3949ba59abbe56e057f20f883e', '0000-00-00 00:00:00', 'studentName2', 'test@test.com', '', NULL, 'studentaddress', '0000', '0000-00-00 00:00:00', '2018-03-20 19:06:57', 1, 2, 0, 0, '../studentsphoto/ASI//3bqfaykm81.jpg', '', '', '', 0, 0, '', '', '2015/06/6866', '02', 'Surname', 'studentFather', 'studentMother', '2018-07-24', 0, 0, 0, '9447465916', 'e10adc3949ba59abbe56e057f20f883e', '', 0, NULL, '', '', NULL, NULL, '', 0, 0, '', '', '999102115066866', 0, 0, NULL, NULL, NULL, NULL, NULL),
  (3, 'student3', 'e10adc3949ba59abbe56e057f20f883e', '0000-00-00 00:00:00', 'studentName3', 'user@linways.com', '', NULL, 'studentaddress', '0000', '0000-00-00 00:00:00', '2018-03-20 19:06:57', 1, 2, 0, 0, '../studentsphoto/ASI//kanws3v867.jpg', '', '', '', 0, 0, '', '', '2015/06/6699', '03', 'Surname', 'studentFather', 'studentMother', '2018-07-24', 0, 0, 0, '9447642800', 'e10adc3949ba59abbe56e057f20f883e', '', 0, NULL, '', '', NULL, NULL, '', 0, 0, '', '', '999102115066699', 0, 0, NULL, NULL, NULL, NULL, NULL),
  (4, 'student4', 'e10adc3949ba59abbe56e057f20f883e', '0000-00-00 00:00:00', 'studentName4', 'test@test.com', '', NULL, 'studentaddress', '0000', '0000-00-00 00:00:00', '2018-03-20 19:06:57', 1, 2, 0, 0, '../studentsphoto/ASI//b6hod99osd.jpg', '', '', '', 0, 0, '', '', '2015/06/6711', '05', 'Surname', 'studentFather', 'studentMother', '2018-07-24', 0, 0, 0, '9539236355', 'e10adc3949ba59abbe56e057f20f883e', '', 0, NULL, '', '', NULL, NULL, '', 0, 0, '', '', '999102115066711', 0, 0, NULL, NULL, NULL, NULL, NULL),
  (5, 'student5', 'e10adc3949ba59abbe56e057f20f883e', '0000-00-00 00:00:00', 'studentName5', 'test@test.com', '', NULL, 'studentaddress', '0000', '0000-00-00 00:00:00', '2018-03-20 19:06:57', 1, 2, 0, 0, '../studentsphoto/ASI//kb42vf8a66.jpg', '', '', '', 0, 0, '', '', '2015/06/6712', '06', 'Surname', 'studentFather', 'studentMother', '2018-07-24', 0, 0, 0, '9497506914', 'e10adc3949ba59abbe56e057f20f883e', '', 0, NULL, '', '', NULL, NULL, '', 0, 0, '', '', '999102115066712', 0, 0, NULL, NULL, NULL, NULL, NULL),
  (6, 'student6', 'e10adc3949ba59abbe56e057f20f883e', '0000-00-00 00:00:00', 'studentName6', 'test@test.com', '', NULL, 'studentaddress', '0000', '0000-00-00 00:00:00', '2018-03-20 19:06:57', 1, 2, 0, 0, '../studentsphoto/ASI//u3np83f3zt.jpg', '', '', '', 0, 1, '', '', '2015/06/6668', '08', 'Surname', 'studentFather', 'studentMother', '2018-07-24', 0, 0, 0, '9539709419', 'e10adc3949ba59abbe56e057f20f883e', '', 0, NULL, '', '', NULL, NULL, '', 0, 0, '', '', '999102115066668', 0, 0, NULL, NULL, NULL, NULL, NULL);
