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, 0, '', '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, '', '228', 9, 0, 0, 1, 0, '', '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, '', '380', 0, 0, 0, 1, 0, '', '2017-07-19', NULL, NULL, 12, 2, '-', 0, '', '', 0, '', '', '', NULL, 0, NULL);


INSERT INTO `staffAttn_shiftException` (`shiftExceptionID`, `staffID`, `actualIntime`, `actualOuttime`, `exceptionDate`)
VALUES
  (1, 2, '10:00:00', '17:00:00', '2019-03-08');

INSERT INTO `staffAttn_shiftDetails` (`shiftDetailID`, `staffID`, `actualIntime`, `actualOuttime`, `fromDate`, `toDate`)
VALUES
  (1, 2, '09:00:00', '16:00:00', '2019-01-01', '2030-12-31'),
  (2, 3, '09:00:00', '16:00:00', '2019-01-01', '2030-12-31');
