


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');
