/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : linxleave_company_2

Target Server Type    : MYSQL
Target Server Version : 50505
File Encoding         : 65001

Date: 2024-04-24 15:50:14
*/


-- ----------------------------
-- Table structure for adjustment
-- ----------------------------
CREATE TABLE `adjustment` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id` int(255) DEFAULT NULL,
  `days` varchar(255) DEFAULT NULL,
  `leave_type` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `action` varchar(255) DEFAULT NULL,
  `createdBy_user_id` int(255) DEFAULT NULL,
  `sent_date` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of adjustment
-- ----------------------------
INSERT INTO `adjustment` VALUES ('1', '67', '1', 'ANNUAL', '[1/ 3/2021] WRONG APPLIED. ', 'ADD', '18', '2021-03-02', null, '11:24 AM', '2021-03-02');
INSERT INTO `adjustment` VALUES ('2', '55', '1', 'ANNUAL', '9/3/2021 WRONG APPLIED DATE. ALREADY WITHDRAW THE APPLY FOR LEAVE ', 'ADD', '18', '2021-03-09', null, '11:16 AM', '2021-03-09');
INSERT INTO `adjustment` VALUES ('3', '49', '1', 'ANNUAL', '19/5/2021 BACK TO WORK ', 'ADD', '18', '2021-05-19', null, '17:13 PM', '2021-05-19');
INSERT INTO `adjustment` VALUES ('4', '32', '1', 'ANNUAL', '19/5/2021 BACK TO WORK ', 'ADD', '18', '2021-05-19', null, '17:20 PM', '2021-05-19');
INSERT INTO `adjustment` VALUES ('5', '47', '1', 'ANNUAL', '19/5/2021 BACK TO WORK ', 'ADD', '18', '2021-05-19', null, '17:20 PM', '2021-05-19');

-- ----------------------------
-- Table structure for announcement
-- ----------------------------
CREATE TABLE `announcement` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `date_from` varchar(255) DEFAULT NULL,
  `date_to` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `createdBy_user_id` varchar(255) DEFAULT NULL,
  `date_update` varchar(255) DEFAULT NULL,
  `time_update` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of announcement
-- ----------------------------
INSERT INTO `announcement` VALUES ('1', 'LUNCH TREAT', '2023-11-21', '2023-12-21', 'EVERYBODY DONT GO OUT OKAY. JUST STAY IN OFFICE! WE EAT LUNCH TOGETHER GETHER ', '', null, '2023-12-14', '17:28 PM');

-- ----------------------------
-- Table structure for apply_date
-- ----------------------------
CREATE TABLE `apply_date` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `apply_leave_id` int(11) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `option_day` varchar(255) DEFAULT NULL,
  `paid_unpaid` varchar(255) DEFAULT NULL,
  `replacement` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `apply_leave_id` (`apply_leave_id`)
) ENGINE=InnoDB AUTO_INCREMENT=770 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of apply_date
-- ----------------------------
INSERT INTO `apply_date` VALUES ('1', '1', '2017-03-22', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('2', '2', '2017-11-27', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('3', '2', '2017-11-28', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('4', '2', '2017-11-29', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('5', '2', '2017-11-30', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('6', '2', '2017-12-01', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('7', '2', '2017-12-04', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('8', '2', '2017-12-05', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('9', '2', '2017-12-06', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('10', '2', '2017-12-07', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('11', '2', '2017-12-08', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('12', '3', '2017-05-19', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('13', '3', '2017-05-22', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('14', '3', '2017-05-23', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('15', '4', '2017-05-30', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('16', '4', '2017-05-31', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('17', '4', '2017-06-05', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('18', '4', '2017-06-06', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('19', '4', '2017-06-07', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('20', '4', '2017-06-08', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('21', '4', '2017-06-09', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('22', '6', '2017-06-23', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('23', '6', '2017-06-28', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('24', '6', '2017-06-29', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('25', '6', '2017-06-30', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('26', '5', '2017-06-12', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('27', '7', '2017-08-09', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('28', '7', '2017-08-10', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('29', '7', '2017-08-11', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('31', '8', '2017-09-19', 'FULL', 'UNPAID', '');
INSERT INTO `apply_date` VALUES ('32', '9', '2017-10-31', 'FULL', 'UNPAID', '');
INSERT INTO `apply_date` VALUES ('33', '9', '2017-11-01', 'FULL', 'UNPAID', '');
INSERT INTO `apply_date` VALUES ('34', '9', '2017-11-02', 'FULL', 'UNPAID', '');
INSERT INTO `apply_date` VALUES ('35', '9', '2017-11-03', 'FULL', 'UNPAID', '');
INSERT INTO `apply_date` VALUES ('36', '10', '2017-11-17', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('37', '11', '2017-11-14', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('38', '12', '2017-12-07', 'AM', 'PAID', '');
INSERT INTO `apply_date` VALUES ('39', '13', '2018-01-25', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('40', '13', '2018-01-26', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('41', '13', '2018-01-29', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('42', '13', '2018-01-30', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('43', '13', '2018-01-31', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('44', '13', '2018-02-01', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('45', '13', '2018-02-02', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('46', '14', '2018-01-05', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('47', '15', '2018-01-30', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('48', '15', '2018-01-31', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('49', '15', '2018-02-01', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('50', '15', '2018-02-02', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('51', '15', '2018-02-05', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('52', '15', '2018-02-06', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('53', '15', '2018-02-07', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('54', '15', '2018-02-08', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('55', '15', '2018-02-09', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('56', '15', '2018-02-12', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('57', '15', '2018-02-13', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('58', '15', '2018-02-14', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('59', '15', '2018-02-15', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('60', '16', '2018-01-19', 'FULL', 'PAID', '');
INSERT INTO `apply_date` VALUES ('61', '17', '2018-01-22', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('62', '18', '2018-02-14', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('63', '19', '2018-02-14', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('64', '20', '2018-02-13', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('65', '20', '2018-02-14', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('66', '21', '2018-02-19', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('67', '22', '2018-02-02', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('68', '23', '2018-03-14', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('69', '23', '2018-03-15', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('70', '23', '2018-03-16', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('71', '23', '2018-03-19', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('72', '24', '2018-03-12', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('74', '26', '2018-03-15', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('75', '27', '2018-02-20', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('76', '28', '2018-03-14', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('77', '28', '2018-03-16', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('78', '29', '2018-03-15', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('79', '30', '2018-04-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('80', '31', '2018-04-13', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('81', '32', '2018-04-16', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('82', '33', '2018-12-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('83', '33', '2018-12-31', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('84', '33', '2019-01-02', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('85', '33', '2019-01-03', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('86', '33', '2019-01-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('87', '33', '2019-01-07', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('88', '34', '2018-04-11', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('89', '35', '2018-04-20', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('90', '36', '2018-04-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('91', '36', '2018-04-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('92', '36', '2018-05-01', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('93', '36', '2018-05-02', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('94', '36', '2018-05-03', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('95', '36', '2018-05-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('96', '37', '2018-04-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('97', '37', '2018-04-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('98', '37', '2018-05-02', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('99', '37', '2018-05-03', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('100', '37', '2018-05-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('101', '38', '2018-04-02', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('102', '38', '2018-04-03', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('103', '39', '2018-05-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('104', '39', '2018-05-31', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('105', '39', '2018-04-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('106', '40', '2018-05-02', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('107', '41', '2018-05-10', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('108', '42', '2018-05-10', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('109', '43', '2018-05-10', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('110', '44', '2018-05-15', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('111', '45', '2018-05-21', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('114', '48', '2018-05-07', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('115', '48', '2018-05-08', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('116', '49', '2018-06-05', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('117', '49', '2018-06-06', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('118', '49', '2018-06-07', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('119', '49', '2018-06-08', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('120', '49', '2018-06-11', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('121', '49', '2018-06-12', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('122', '49', '2018-06-13', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('123', '50', '2018-05-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('124', '51', '2018-05-25', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('125', '52', '2018-05-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('126', '53', '2018-06-07', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('127', '54', '2018-06-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('128', '55', '2018-06-14', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('129', '55', '2018-06-18', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('130', '55', '2018-06-19', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('131', '56', '2018-06-14', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('132', '56', '2018-06-18', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('133', '56', '2018-06-19', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('134', '57', '2018-07-05', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('135', '58', '2018-09-07', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('136', '59', '2018-08-01', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('137', '60', '2018-07-31', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('138', '61', '2018-07-31', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('139', '62', '2018-09-03', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('140', '63', '2018-08-08', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('141', '64', '2018-08-08', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('142', '65', '2018-08-10', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('143', '66', '2018-08-15', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('144', '67', '2018-08-15', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('145', '67', '2018-08-16', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('146', '67', '2018-08-17', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('147', '68', '2018-08-30', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('148', '69', '2018-08-27', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('149', '70', '2018-09-20', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('150', '71', '2018-09-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('151', '71', '2018-09-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('152', '71', '2018-10-01', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('153', '71', '2018-10-02', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('154', '71', '2018-10-03', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('155', '71', '2018-10-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('156', '71', '2018-10-05', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('157', '72', '2018-09-19', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('158', '73', '2018-10-19', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('159', '73', '2018-10-26', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('160', '73', '2018-10-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('161', '74', '2018-10-17', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('162', '75', '2018-10-29', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('163', '76', '2018-10-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('164', '77', '2018-09-12', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('165', '78', '2018-10-10', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('166', '79', '2018-10-31', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('167', '79', '2018-11-02', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('168', '79', '2018-11-01', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('169', '80', '2018-11-16', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('170', '81', '2018-11-26', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('171', '81', '2018-11-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('172', '81', '2018-11-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('173', '82', '2018-12-26', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('174', '82', '2018-12-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('175', '82', '2018-12-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('176', '83', '2018-12-21', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('177', '84', '2018-12-24', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('178', '85', '2018-12-21', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('179', '85', '2018-12-24', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('180', '86', '2018-12-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('181', '87', '2018-12-31', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('182', '88', '2018-12-19', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('183', '88', '2018-12-20', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('184', '88', '2018-12-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('185', '89', '2019-01-02', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('186', '90', '2019-01-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('187', '91', '2019-02-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('188', '91', '2019-02-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('189', '92', '2019-02-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('190', '93', '2019-02-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('191', '93', '2019-02-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('192', '94', '2019-02-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('193', '94', '2019-02-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('194', '94', '2019-02-14', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('195', '94', '2019-02-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('196', '94', '2019-02-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('197', '95', '2019-02-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('198', '95', '2019-02-07', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('199', '95', '2019-02-08', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('200', '96', '2019-02-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('201', '96', '2019-02-07', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('202', '96', '2019-02-08', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('203', '97', '2019-01-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('204', '97', '2019-01-09', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('205', '98', '2019-01-16', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('206', '99', '2019-01-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('207', '100', '2019-02-08', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('208', '101', '2019-02-08', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('209', '102', '2019-02-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('210', '103', '2019-02-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('211', '104', '2019-02-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('212', '105', '2019-01-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('213', '105', '2019-01-29', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('214', '105', '2019-01-30', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('215', '105', '2019-01-31', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('216', '105', '2019-02-01', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('217', '105', '2019-02-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('218', '106', '2019-02-25', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('219', '107', '2019-03-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('220', '107', '2019-03-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('221', '107', '2019-03-06', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('222', '107', '2019-03-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('223', '107', '2019-03-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('224', '108', '2019-02-22', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('225', '108', '2019-02-25', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('226', '109', '2019-03-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('227', '110', '2019-03-01', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('228', '111', '2019-03-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('229', '112', '2019-03-01', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('230', '113', '2019-07-08', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('231', '113', '2019-07-09', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('232', '113', '2019-07-10', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('233', '113', '2019-07-11', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('234', '113', '2019-07-12', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('235', '113', '2019-07-15', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('236', '113', '2019-07-16', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('237', '113', '2019-07-17', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('238', '114', '2019-03-14', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('239', '115', '2019-03-19', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('240', '116', '2019-03-21', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('241', '117', '2019-04-05', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('242', '118', '2019-04-17', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('243', '118', '2019-04-18', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('244', '118', '2019-04-22', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('245', '119', '2019-05-03', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('246', '120', '2019-05-15', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('247', '121', '2019-05-22', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('248', '121', '2019-06-07', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('249', '121', '2019-06-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('250', '122', '2019-06-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('251', '123', '2019-05-17', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('252', '123', '2019-06-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('253', '123', '2019-06-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('254', '124', '2019-06-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('255', '125', '2019-06-07', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('256', '125', '2019-06-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('257', '126', '2019-05-22', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('258', '126', '2019-06-07', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('259', '126', '2019-06-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('260', '127', '2019-06-07', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('261', '127', '2019-06-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('262', '127', '2019-06-10', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('263', '127', '2019-05-31', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('264', '128', '2019-06-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('265', '129', '2019-06-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('266', '130', '2019-06-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('267', '130', '2019-05-31', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('268', '130', '2019-06-10', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('269', '131', '2019-05-22', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('270', '131', '2019-06-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('271', '132', '2019-05-31', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('272', '133', '2019-05-30', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('273', '133', '2019-05-31', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('274', '133', '2019-06-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('275', '134', '2019-05-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('276', '135', '2019-05-28', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('277', '136', '2019-05-30', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('278', '137', '2019-05-31', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('279', '138', '2019-06-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('280', '139', '2019-06-18', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('281', '140', '2019-06-19', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('282', '141', '2019-07-05', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('283', '142', '2019-07-17', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('284', '143', '2019-07-17', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('285', '144', '2019-07-18', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('286', '144', '2019-07-19', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('287', '145', '2019-07-29', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('288', '145', '2019-07-31', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('289', '146', '2019-07-25', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('290', '147', '2019-07-25', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('291', '148', '2019-08-14', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('292', '149', '2019-08-16', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('293', '150', '2019-08-16', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('294', '151', '2019-08-14', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('295', '152', '2019-08-30', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('296', '153', '2019-08-30', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('297', '154', '2019-09-23', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('298', '155', '2019-09-23', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('299', '155', '2019-09-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('300', '156', '2019-09-27', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('301', '157', '2019-10-07', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('302', '158', '2019-10-08', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('303', '159', '2019-10-25', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('304', '160', '2019-10-24', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('305', '161', '2019-11-12', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('306', '161', '2019-11-13', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('307', '162', '2019-11-05', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('308', '163', '2019-11-06', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('309', '164', '2019-11-15', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('310', '165', '2019-11-18', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('311', '165', '2019-11-20', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('312', '165', '2019-11-19', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('313', '166', '2019-11-20', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('314', '166', '2019-11-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('315', '167', '2019-11-19', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('316', '168', '2019-11-25', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('317', '169', '2019-12-13', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('318', '169', '2019-12-16', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('319', '170', '2019-12-13', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('320', '170', '2019-12-16', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('321', '171', '2019-12-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('322', '172', '2019-12-30', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('323', '173', '2020-01-02', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('324', '174', '2020-01-06', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('325', '175', '2019-12-30', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('326', '176', '2020-01-02', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('327', '177', '2020-01-07', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('328', '178', '2020-01-09', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('329', '179', '2020-01-16', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('330', '180', '2020-01-23', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('331', '180', '2020-01-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('332', '181', '2020-01-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('333', '182', '2020-01-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('334', '183', '2020-01-29', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('335', '184', '2020-02-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('336', '185', '2020-02-06', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('337', '186', '2020-02-06', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('338', '187', '2020-02-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('339', '188', '2020-02-07', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('340', '189', '2020-02-06', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('341', '190', '2020-02-12', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('342', '191', '2020-02-20', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('343', '192', '2020-02-13', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('344', '193', '2020-02-25', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('345', '193', '2020-02-19', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('346', '193', '2020-03-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('347', '193', '2020-03-25', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('348', '193', '2020-03-26', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('349', '193', '2020-03-27', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('350', '194', '2020-02-25', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('351', '195', '2020-02-20', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('352', '196', '2020-03-24', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('353', '196', '2020-03-25', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('354', '196', '2020-03-26', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('355', '196', '2020-03-27', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('356', '197', '2020-02-28', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('357', '198', '2020-03-02', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('358', '198', '2020-03-03', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('359', '198', '2020-03-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('360', '199', '2020-03-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('361', '199', '2020-03-06', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('362', '200', '2020-03-13', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('363', '201', '2020-03-20', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('364', '202', '2020-03-18', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('365', '202', '2020-03-19', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('366', '202', '2020-03-20', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('367', '203', '2020-03-23', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('368', '203', '2020-03-24', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('369', '203', '2020-03-25', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('370', '203', '2020-03-25', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('371', '204', '2020-05-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('372', '204', '2020-05-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('373', '204', '2020-05-29', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('374', '205', '2020-05-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('375', '205', '2020-05-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('376', '205', '2020-05-29', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('377', '205', '2020-05-29', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('378', '205', '2020-06-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('379', '205', '2020-06-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('380', '205', '2020-06-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('381', '206', '2020-05-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('382', '206', '2020-05-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('383', '206', '2020-05-29', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('384', '206', '2020-05-29', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('385', '206', '2020-06-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('386', '206', '2020-06-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('387', '206', '2020-06-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('388', '207', '2020-05-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('389', '207', '2020-05-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('390', '207', '2020-05-29', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('391', '207', '2020-06-03', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('392', '207', '2020-06-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('393', '207', '2020-06-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('394', '207', '2020-05-22', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('395', '208', '2020-05-22', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('396', '208', '2020-05-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('397', '208', '2020-05-29', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('398', '208', '2020-06-05', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('399', '208', '2020-06-04', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('400', '208', '2020-06-04', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('401', '208', '2020-06-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('402', '209', '2020-05-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('403', '209', '2020-05-29', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('404', '209', '2020-06-03', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('405', '209', '2020-06-03', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('406', '209', '2020-06-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('407', '209', '2020-06-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('408', '210', '2020-05-29', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('409', '210', '2020-06-05', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('410', '210', '2020-06-04', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('411', '210', '2020-06-04', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('412', '210', '2020-06-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('413', '210', '2020-05-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('414', '211', '2020-05-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('415', '211', '2020-05-29', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('416', '211', '2020-06-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('417', '211', '2020-06-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('418', '211', '2020-06-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('419', '212', '2020-05-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('420', '212', '2020-05-29', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('421', '212', '2020-06-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('422', '212', '2020-06-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('423', '212', '2020-06-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('424', '213', '2020-05-29', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('425', '214', '2020-05-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('426', '215', '2020-06-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('427', '215', '2020-06-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('428', '215', '2020-06-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('429', '216', '2020-06-10', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('430', '217', '2020-06-15', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('431', '218', '2020-06-11', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('432', '219', '2020-06-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('433', '220', '2020-06-16', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('434', '221', '2020-06-25', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('435', '222', '2020-06-25', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('436', '223', '2020-07-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('437', '224', '2020-06-29', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('438', '225', '2020-06-30', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('439', '226', '2020-07-08', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('440', '227', '2020-07-08', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('441', '228', '2020-07-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('442', '229', '2020-07-13', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('443', '230', '2020-07-09', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('444', '231', '2020-08-03', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('445', '232', '2020-07-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('446', '233', '2020-08-05', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('447', '234', '2020-07-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('448', '235', '2020-08-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('449', '236', '2020-07-23', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('450', '237', '2020-07-28', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('451', '238', '2020-07-27', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('452', '239', '2020-07-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('453', '240', '2020-07-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('454', '241', '2020-07-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('455', '242', '2020-08-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('456', '243', '2020-08-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('457', '244', '2020-08-11', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('458', '244', '2020-08-12', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('459', '245', '2020-08-13', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('460', '246', '2020-08-11', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('461', '247', '2020-08-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('462', '248', '2020-08-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('463', '249', '2020-08-27', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('464', '250', '2020-09-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('465', '250', '2020-09-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('466', '250', '2020-09-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('467', '250', '2020-09-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('468', '251', '2020-09-03', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('469', '252', '2020-09-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('470', '253', '2020-09-09', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('471', '253', '2020-09-10', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('472', '253', '2020-09-11', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('473', '254', '2020-09-11', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('474', '255', '2020-09-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('475', '255', '2020-09-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('476', '255', '2020-09-22', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('477', '255', '2020-09-23', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('478', '256', '2020-09-18', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('479', '257', '2020-09-22', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('480', '258', '2020-09-25', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('481', '259', '2020-10-09', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('482', '259', '2020-10-09', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('483', '260', '2020-10-12', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('484', '261', '2020-10-14', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('485', '261', '2020-10-14', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('486', '262', '2020-10-12', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('487', '262', '2020-10-12', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('488', '263', '2020-10-20', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('489', '264', '2020-11-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('490', '264', '2020-11-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('491', '265', '2020-11-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('492', '265', '2020-11-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('493', '266', '2020-11-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('494', '266', '2020-11-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('495', '267', '2020-12-02', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('496', '268', '2020-12-02', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('497', '269', '2020-12-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('498', '270', '2020-12-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('499', '271', '2021-01-14', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('500', '272', '2020-02-24', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('501', '272', '2020-02-25', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('502', '273', '2020-03-02', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('503', '274', '2021-01-25', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('504', '275', '2021-01-25', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('505', '276', '2021-02-15', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('506', '276', '2021-02-16', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('507', '277', '2021-02-16', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('508', '278', '2021-02-19', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('509', '279', '2021-02-19', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('510', '280', '2021-03-01', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('511', '281', '2021-02-22', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('512', '282', '2021-02-22', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('513', '282', '2021-02-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('514', '283', '2021-02-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('515', '284', '2021-03-09', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('516', '285', '2021-03-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('517', '286', '2021-03-09', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('518', '287', '2021-03-09', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('519', '288', '2021-03-11', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('520', '289', '2021-03-12', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('521', '290', '2021-03-12', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('522', '291', '2021-03-17', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('523', '292', '2021-03-19', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('524', '293', '2021-03-19', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('525', '294', '2021-03-24', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('526', '295', '2021-03-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('527', '296', '2021-03-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('528', '297', '2021-03-31', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('529', '298', '2021-04-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('530', '298', '2021-04-06', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('531', '299', '2021-04-16', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('532', '300', '2021-04-16', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('533', '301', '2021-04-26', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('534', '302', '2021-05-17', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('535', '302', '2021-05-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('536', '302', '2021-05-19', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('537', '303', '2021-05-11', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('538', '304', '2021-05-17', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('539', '304', '2021-05-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('540', '304', '2021-05-19', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('541', '305', '2021-05-17', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('542', '305', '2021-05-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('543', '305', '2021-05-19', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('544', '306', '2021-05-18', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('545', '306', '2021-05-17', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('546', '306', '2021-05-17', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('547', '307', '2021-05-17', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('548', '307', '2021-05-19', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('549', '307', '2021-05-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('550', '308', '2021-06-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('551', '308', '2021-06-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('552', '309', '2021-06-11', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('553', '310', '2021-06-11', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('554', '311', '2021-06-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('555', '312', '2021-06-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('556', '313', '2021-06-17', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('557', '314', '2021-06-21', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('558', '315', '2021-06-21', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('559', '316', '2021-06-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('560', '317', '2021-07-02', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('561', '318', '2021-07-05', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('562', '319', '2021-07-12', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('563', '320', '2021-07-13', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('564', '321', '2021-07-16', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('565', '322', '2021-07-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('566', '323', '2021-07-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('567', '324', '2021-07-30', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('568', '325', '2021-08-02', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('569', '326', '2021-08-05', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('570', '327', '2021-08-11', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('571', '327', '2021-08-13', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('572', '328', '2021-08-13', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('573', '329', '2021-08-18', 'PM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('574', '330', '2021-08-20', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('575', '331', '2021-08-20', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('576', '332', '2021-09-10', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('577', '333', '2021-09-10', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('578', '334', '2021-09-15', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('579', '335', '2021-09-15', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('580', '336', '2021-09-23', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('581', '337', '2021-10-06', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('582', '338', '2021-10-06', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('583', '339', '2021-10-06', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('584', '340', '2021-10-13', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('585', '341', '2021-10-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('586', '342', '2021-10-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('587', '343', '2021-10-25', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('588', '344', '2021-10-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('589', '345', '2021-10-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('590', '346', '2021-10-29', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('591', '347', '2021-11-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('592', '348', '2021-09-29', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('593', '349', '2021-11-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('594', '350', '2021-11-04', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('595', '351', '2021-11-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('596', '352', '2021-11-15', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('597', '353', '2021-11-30', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('598', '353', '2021-12-01', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('599', '354', '2021-11-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('600', '355', '2021-11-25', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('601', '356', '2021-12-13', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('602', '356', '2021-12-14', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('603', '356', '2021-12-15', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('604', '357', '2021-12-17', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('605', '358', '2021-12-17', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('606', '359', '2021-12-15', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('607', '360', '2021-12-27', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('608', '361', '2021-12-27', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('609', '362', '2021-12-29', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('610', '363', '2022-01-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('611', '364', '2021-12-30', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('612', '365', '2022-01-06', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('613', '365', '2022-01-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('614', '366', '2022-01-06', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('615', '367', '2022-01-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('616', '368', '2022-01-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('617', '369', '2022-02-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('618', '369', '2022-02-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('619', '370', '2022-01-10', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('620', '371', '2022-01-17', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('621', '372', '2022-01-26', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('622', '372', '2022-01-27', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('623', '372', '2022-01-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('624', '372', '2022-02-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('625', '373', '2022-01-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('626', '373', '2022-02-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('627', '374', '2022-02-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('628', '375', '2022-01-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('629', '376', '2022-02-15', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('630', '377', '2022-02-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('631', '378', '2022-02-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('632', '379', '2022-02-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('633', '380', '2022-02-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('634', '381', '2022-02-16', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('635', '381', '2022-02-18', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('636', '382', '2022-02-18', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('637', '382', '2022-02-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('638', '383', '2022-02-16', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('639', '384', '2022-02-23', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('640', '385', '2022-02-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('641', '386', '2022-03-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('642', '386', '2022-03-22', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('643', '386', '2022-03-23', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('644', '386', '2022-03-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('645', '387', '2022-03-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('646', '388', '2022-04-04', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('647', '389', '2022-03-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('648', '390', '2022-03-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('649', '391', '2022-04-01', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('650', '392', '2022-03-29', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('651', '393', '2022-04-01', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('652', '394', '2022-04-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('653', '395', '2022-04-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('654', '395', '2022-04-29', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('655', '396', '2022-04-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('656', '397', '2022-04-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('657', '398', '2022-04-11', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('658', '399', '2022-04-13', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('659', '400', '2022-05-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('660', '400', '2022-05-06', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('661', '401', '2022-05-05', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('662', '401', '2022-05-06', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('663', '402', '2022-06-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('664', '403', '2022-04-28', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('665', '404', '2022-04-28', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('666', '405', '2022-06-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('667', '406', '2022-05-10', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('668', '407', '2022-06-09', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('669', '407', '2022-06-10', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('670', '407', '2022-06-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('671', '408', '2022-06-23', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('672', '408', '2022-06-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('673', '408', '2022-06-27', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('674', '409', '2022-06-08', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('675', '410', '2022-06-20', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('676', '411', '2022-09-02', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('677', '412', '2022-09-09', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('678', '413', '2022-09-12', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('679', '413', '2022-09-13', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('680', '414', '2022-10-07', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('681', '415', '2022-10-27', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('682', '416', '2022-11-16', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('683', '417', '2022-12-14', 'AM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('684', '418', '2023-04-06', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('685', '419', '2023-04-27', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('686', '419', '2023-04-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('687', '420', '2023-09-26', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('688', '421', '2023-12-11', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('689', '421', '2023-12-12', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('690', '421', '2023-12-15', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('691', '421', '2023-12-14', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('692', '421', '2023-12-13', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('693', '422', '2023-12-13', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('694', '423', '2023-12-22', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('695', '424', '2023-12-26', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('696', '425', '2023-12-26', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('697', '426', '2023-12-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('698', '427', '2023-12-20', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('699', '430', '2023-12-21', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('700', '431', '2023-12-21', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('701', '432', '2023-12-26', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('702', '433', '2023-12-21', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('703', '434', '2023-12-26', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('704', '435', '2023-12-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('705', '436', '2023-12-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('706', '437', '2023-12-29', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('707', '438', '2023-12-20', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('708', '439', '2023-12-21', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('709', '440', '2023-12-19', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('710', '441', '2023-12-18', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('711', '442', '2023-12-18', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('712', '448', '2023-12-28', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('713', '448', '2023-12-27', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('714', '448', '2023-12-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('715', '448', '2023-12-20', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('716', '448', '2023-12-19', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('717', '448', '2023-12-26', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('718', '448', '2023-12-29', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('719', '448', '2023-12-22', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('720', '449', '2023-12-19', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('721', '449', '2023-12-20', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('722', '449', '2023-12-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('723', '449', '2023-12-22', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('724', '450', '2023-12-18', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('725', '450', '2023-12-19', 'AM', 'PAID', null);
INSERT INTO `apply_date` VALUES ('726', '450', '2023-12-19', 'PM', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('727', '450', '2023-12-20', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('728', '451', '2023-12-22', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('729', '452', '2023-12-26', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('730', '453', '2024-01-03', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('731', '454', '2024-01-15', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('732', '455', '2024-02-08', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('733', '455', '2024-02-09', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('734', '455', '2024-02-14', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('735', '456', '2024-02-09', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('736', '457', '2024-01-31', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('737', '458', '2024-02-16', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('738', '459', '2024-02-14', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('739', '460', '2024-02-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('740', '460', '2024-02-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('741', '461', '2024-04-12', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('742', '462', '2024-03-19', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('743', '463', '2024-03-20', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('744', '464', '2024-03-20', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('745', '465', '2024-03-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('746', '466', '2024-03-20', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('747', '467', '2024-03-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('748', '468', '2024-03-22', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('749', '469', '2024-03-23', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('750', '470', '2024-03-20', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('751', '471', '2024-03-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('752', '472', '2024-03-22', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('753', '473', '2024-03-23', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('754', '474', '2024-03-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('755', '475', '2024-03-20', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('756', '476', '2024-03-21', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('757', '477', '2024-03-22', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('758', '478', '2024-03-23', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('759', '479', '2024-03-24', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('760', '480', '2024-03-20', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('761', '481', '2024-04-12', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('762', '482', '2024-03-25', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('763', '483', '2024-03-25', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('764', '484', '2024-03-26', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('765', '485', '2024-03-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('766', '486', '2024-03-28', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('767', '487', '2024-04-09', 'FULL', 'PAID', null);
INSERT INTO `apply_date` VALUES ('768', '487', '2024-04-15', 'FULL', 'UNPAID', null);
INSERT INTO `apply_date` VALUES ('769', '487', '2024-04-16', 'FULL', 'UNPAID', null);

-- ----------------------------
-- Table structure for apply_leave
-- ----------------------------
CREATE TABLE `apply_leave` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `onbehalf` varchar(255) DEFAULT NULL,
  `approval1_id` int(11) DEFAULT 0,
  `approval2_id` int(11) DEFAULT 0,
  `approval3_id` int(11) DEFAULT 0,
  `days` varchar(255) DEFAULT NULL,
  `days_paid` varchar(255) DEFAULT NULL,
  `days_unpaid` varchar(255) DEFAULT NULL,
  `days_replacement` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `leave_type` varchar(255) DEFAULT NULL,
  `previous_leave` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `document` varchar(255) DEFAULT NULL,
  `app_date` varchar(50) DEFAULT NULL,
  `app_time` varchar(255) DEFAULT NULL,
  `reason_app` varchar(255) DEFAULT NULL,
  `sent_date` varchar(50) DEFAULT NULL,
  `createdBy_user_id` varchar(255) DEFAULT NULL,
  `withdraw1_id` int(255) DEFAULT 0,
  `withdraw2_id` int(255) DEFAULT 0,
  `withdraw3_id` int(11) DEFAULT 0,
  `autodeduct` varchar(255) NOT NULL,
  `autounpaid` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `apply_leave_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=488 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of apply_leave
-- ----------------------------
INSERT INTO `apply_leave` VALUES ('166', '53', 'DEFAULT', '0', '0', '0', '2', '0', '2', null, 'KURSUS', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2019-11-18', '53', '0', '0', '0', 'YES', '1');
INSERT INTO `apply_leave` VALUES ('198', '53', 'DEFAULT', '0', '0', '0', '3', '3', '0', null, 'WIFE\'S BIRTH DELIVERY', 'PATERNITY', null, 'APPROVED', 'Array', null, null, null, '2020-03-09', '53', '0', '0', '0', 'YES', '1');
INSERT INTO `apply_leave` VALUES ('199', '53', 'DEFAULT', '0', '0', '0', '2', '0', '2', null, 'WIFE\'S BIRTH DELIVERY', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2020-03-09', '53', '0', '0', '0', 'YES', '1');
INSERT INTO `apply_leave` VALUES ('212', '53', 'DEFAULT', '0', '0', '0', '5', '0', '5', null, 'HARI RAYA CELEBRATION.', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2020-05-18', '53', '0', '0', '0', 'YES', '1');
INSERT INTO `apply_leave` VALUES ('307', '53', 'DEFAULT', '0', '0', '0', '3', '0', '3', null, 'RAYA', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2021-05-10', '53', '0', '0', '0', 'YES', '1');
INSERT INTO `apply_leave` VALUES ('420', '100', 'DEFAULT', '18', '0', '0', '1', '1', '0', null, 'PERSONAL MATTERS', 'ANNUAL', null, 'APPROVED', 'Array', '2023-09-18', '10:59 AM', '', '2023-09-18', '100', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('421', '107', 'DEFAULT', '0', '0', '0', '5', '3', '2', null, 'GRADUATION CEREMONY', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2023-12-05', '107', '0', '0', '0', 'YES', '1');
INSERT INTO `apply_leave` VALUES ('422', '102', 'DEFAULT', '18', '0', '0', '0.5', '0.5', '0', null, 'APPOINTMENT CLINIC', 'ANNUAL', null, 'APPROVED', 'Array', '2023-12-13', '16:20 PM', '', '2023-12-05', '102', '0', '0', '0', 'YES', '1');
INSERT INTO `apply_leave` VALUES ('423', '102', 'DEFAULT', '18', '0', '0', '1', '1', '0', null, 'APPOINTMENT DAUGHTER CLINIC ', 'ANNUAL', null, 'APPROVED', 'Array', '2023-12-06', '12:20 PM', '', '2023-12-06', '102', '0', '0', '0', 'YES', '1');
INSERT INTO `apply_leave` VALUES ('450', '85', 'DEFAULT', '0', '0', '0', '3', '2', '1', null, 'TESTING', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2023-12-15', '85', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('451', '100', 'DEFAULT', '0', '0', '0', '1', '1', '0', null, 'PERSONAL MATTERS', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2023-12-15', '100', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('452', '108', 'DEFAULT', '0', '0', '0', '1', '1', '0', null, 'CHRISTMAS CELEBRATION & FLY BACK TO KUCHING', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2023-12-18', '108', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('453', '102', 'DEFAULT', '0', '0', '0', '1', '0', '1', null, 'APPOINTMENT CLINIC', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2024-01-02', '102', '0', '0', '0', 'YES', '1');
INSERT INTO `apply_leave` VALUES ('454', '102', 'DEFAULT', '0', '0', '0', '1', '0', '1', null, 'APPOINTMENT DAUGHTER CLINIC', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2024-01-02', '102', '0', '0', '0', 'YES', '1');
INSERT INTO `apply_leave` VALUES ('455', '107', 'DEFAULT', '0', '0', '0', '3', '0', '3', null, 'CHINESE NEW YEAR', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2024-01-30', '107', '0', '0', '0', 'YES', '1');
INSERT INTO `apply_leave` VALUES ('456', '101', 'DEFAULT', '0', '0', '0', '1', '0', '1', null, 'TAKE ANNUAL LEAVE', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2024-01-30', '101', '0', '0', '0', 'YES', '1');
INSERT INTO `apply_leave` VALUES ('457', '109', 'DEFAULT', '0', '0', '0', '1', '1', '0', null, 'UNIVERSITY DEAN\'S LIST CEREMONY', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2024-01-30', '109', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('458', '101', 'DEFAULT', '0', '0', '0', '1', '0', '1', null, 'TAKE ANNUAL LEAVE', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2024-01-30', '101', '0', '0', '0', 'YES', '1');
INSERT INTO `apply_leave` VALUES ('459', '100', 'DEFAULT', '0', '0', '0', '1', '1', '0', null, 'CNY LEAVE', 'CARRY FORWARD', null, 'APPROVED', 'Array', null, null, null, '2024-02-05', '100', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('460', '102', 'DEFAULT', '0', '0', '0', '2', '0', '2', null, 'APPOINTMENT CLINIC ', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2024-02-16', '102', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('461', '104', 'DEFAULT', '18', '0', '0', '1', '1', '0', null, 'ANNUAL_LEAVE', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-27', '14:35 PM', '', '2024-03-14', '104', '0', '0', '0', '', '');
INSERT INTO `apply_leave` VALUES ('462', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '11:47 AM', '', '2024-03-18', '18', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('463', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '14:01 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('464', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '14:05 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('465', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '14:05 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('466', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '14:30 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('467', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '14:31 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('468', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '14:31 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('469', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '14:31 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('470', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST ', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '16:34 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('471', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '16:35 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('472', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '16:35 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('473', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '16:35 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('474', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '16:35 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('475', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '16:46 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('476', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'POST BDAY TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '16:47 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('477', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '16:47 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('478', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '16:47 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('479', '111', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-18', '16:47 PM', '', '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('480', '111', 'DEFAULT', '0', '0', '0', '1', '0', '1', null, 'BIRTHDAY', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2024-03-18', '111', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('481', '107', 'DEFAULT', '18', '0', '0', '1', '1', '0', null, 'BACK TO MIRI', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-27', '14:36 PM', '', '2024-03-27', '107', '0', '0', '0', '', '');
INSERT INTO `apply_leave` VALUES ('482', '112', 'DEFAULT', '18', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', '2024-03-27', '14:47 PM', 'TEST', '2024-03-27', '112', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('483', '112', 'DEFAULT', '0', '0', '0', '1', '0', '1', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2024-03-27', '112', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('484', '112', 'DEFAULT', '0', '0', '0', '1', '-1', '2', null, 'TEST', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2024-03-27', '112', '0', '0', '0', 'YES', '');
INSERT INTO `apply_leave` VALUES ('485', '112', 'DEFAULT', '18', '0', '0', '1', '-2', '3', null, 'TEST', 'ANNUAL', null, 'REJECTED', 'Array', '2024-03-27', '14:50 PM', 'TEST', '2024-03-27', '112', '0', '0', '0', '', '');
INSERT INTO `apply_leave` VALUES ('486', '112', 'DEFAULT', '18', '0', '0', '1', '-2', '3', null, 'TEST', 'ANNUAL', null, 'REJECTED', 'Array', '2024-03-27', '14:57 PM', 'TEST', '2024-03-27', '112', '0', '0', '0', '', '');
INSERT INTO `apply_leave` VALUES ('487', '102', 'DEFAULT', '0', '0', '0', '3', '1', '2', null, 'OBSERVANCE OF HARI RAYA', 'ANNUAL', null, 'APPROVED', 'Array', null, null, null, '2024-04-08', '102', '0', '0', '0', 'YES', '');

-- ----------------------------
-- Table structure for approved_by
-- ----------------------------
CREATE TABLE `approved_by` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `approval1_id` int(11) DEFAULT NULL,
  `approval2_id` varchar(255) DEFAULT NULL,
  `approval3_id` varchar(255) DEFAULT NULL,
  `approval_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=108 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of approved_by
-- ----------------------------
INSERT INTO `approved_by` VALUES ('42', '51', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('47', '56', '19', '18', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('4', '18', '0', '0', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('5', '19', '0', '0', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('41', '50', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('46', '55', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('18', '32', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('44', '53', '18', '', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('40', '49', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('48', '57', '19', '18', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('33', '44', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('56', '65', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('38', '47', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('50', '59', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('55', '64', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('53', '62', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('97', '104', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('58', '67', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('59', '68', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('60', '69', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('61', '70', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('62', '71', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('63', '72', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('64', '73', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('65', '74', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('66', '75', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('67', '76', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('68', '77', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('69', '78', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('70', '79', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('72', '81', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('73', '82', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('74', '83', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('75', '84', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('76', '85', '18', '', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('78', '87', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('79', '88', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('80', '89', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('81', '90', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('82', '91', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('83', '92', '18', '19', null, 'EITHER');
INSERT INTO `approved_by` VALUES ('84', '93', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('94', '101', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('87', '94', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('98', '105', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('95', '102', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('93', '100', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('99', '106', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('100', '107', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('101', '108', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('102', '18', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('104', '109', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('106', '111', '18', null, null, 'EITHER');
INSERT INTO `approved_by` VALUES ('107', '112', '18', null, null, 'EITHER');

-- ----------------------------
-- Table structure for branch
-- ----------------------------
CREATE TABLE `branch` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `company_id` int(255) DEFAULT NULL,
  `branch_code` varchar(255) DEFAULT NULL,
  `branch` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `date_update` varchar(255) DEFAULT NULL,
  `time_update` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of branch
-- ----------------------------

-- ----------------------------
-- Table structure for company_picture
-- ----------------------------
CREATE TABLE `company_picture` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `user_id` int(100) DEFAULT NULL,
  `company_photo` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of company_picture
-- ----------------------------

-- ----------------------------
-- Table structure for company_profile
-- ----------------------------
CREATE TABLE `company_profile` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) DEFAULT NULL,
  `reg_no` varchar(255) DEFAULT NULL,
  `dob` varchar(255) DEFAULT NULL,
  `company_address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `phone_code` varchar(100) DEFAULT NULL,
  `phone_no` varchar(255) DEFAULT NULL,
  `fax_code` varchar(100) DEFAULT NULL,
  `fax_no` varchar(255) DEFAULT NULL,
  `person_in_charge` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `second_email` varchar(255) DEFAULT NULL,
  `website_address` varchar(255) DEFAULT NULL,
  `company_photo` varchar(255) DEFAULT NULL,
  `date_update` varchar(255) DEFAULT NULL,
  `time_update` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of company_profile
-- ----------------------------
INSERT INTO `company_profile` VALUES ('1', 'SOFTWORLD SOFTWARE SDN BHD', '', null, '1ST FLOOR, LOT, 182, JALAN SONG THIAN CHEOK, 93100 KUCHING, SARAWAK, MALAYSIA', 'KUCHING', 'SARAWAK', 'MALAYSIA', '082', '507070', '', '', 'raymond@softworld.com.my', 'raymond@softworld.com.my', '', '', 'logosw.png', '2017-12-12', '14:44 PM');
INSERT INTO `company_profile` VALUES ('2', 'LinxPet Company', null, null, 'LOT 374, BLOCK, 10, Lorong Palm, 93400 Kuching, Sarawak', 'KUCHING', 'SARAWAK', 'MALAYSIA', '013', '2090520', null, null, 'raymond@softworld.com.my', 'raymond@softworld.com.my', null, null, null, null, null);

-- ----------------------------
-- Table structure for dashboard_duty
-- ----------------------------
CREATE TABLE `dashboard_duty` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_user` varchar(255) NOT NULL,
  `onduty` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of dashboard_duty
-- ----------------------------

-- ----------------------------
-- Table structure for dashboard_leave
-- ----------------------------
CREATE TABLE `dashboard_leave` (
  `id` int(11) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `department` varchar(255) NOT NULL,
  `mindate` varchar(255) NOT NULL,
  `maxdate` varchar(255) NOT NULL,
  `days` varchar(255) NOT NULL,
  `leave_type` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of dashboard_leave
-- ----------------------------

-- ----------------------------
-- Table structure for defaults
-- ----------------------------
CREATE TABLE `defaults` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of defaults
-- ----------------------------
INSERT INTO `defaults` VALUES ('1', 'annual', '12', '0');
INSERT INTO `defaults` VALUES ('2', 'maternity', '60', '0');
INSERT INTO `defaults` VALUES ('3', 'paternity', '3', '0');
INSERT INTO `defaults` VALUES ('4', 'sick', '10', '0');
INSERT INTO `defaults` VALUES ('5', 'hospitalization', '60', '0');
INSERT INTO `defaults` VALUES ('6', 'carry forward', '3', '0');

-- ----------------------------
-- Table structure for department
-- ----------------------------
CREATE TABLE `department` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `depart_id` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `remarks` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES ('1', null, '', 'PROGRAMMING', null, '');
INSERT INTO `department` VALUES ('2', null, '', 'DESIGNING', null, '');
INSERT INTO `department` VALUES ('3', null, '', 'ADMINSTRATION', null, '');
INSERT INTO `department` VALUES ('4', null, '', 'ACCOUNTANCY', null, '');
INSERT INTO `department` VALUES ('5', null, '', 'SALES & MARKETING', '', 'SELLING');
INSERT INTO `department` VALUES ('13', null, '', 'HR DEPARTMENT', null, 'HUMAN RESOURCE STUFFS');
INSERT INTO `department` VALUES ('14', null, null, 'IT TECHNCIAN', null, 'TECHNICIAN');

-- ----------------------------
-- Table structure for entitlement_basis
-- ----------------------------
CREATE TABLE `entitlement_basis` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eb_name` varchar(255) DEFAULT NULL,
  `eb_value` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of entitlement_basis
-- ----------------------------

-- ----------------------------
-- Table structure for history
-- ----------------------------
CREATE TABLE `history` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `apply_leave_id` varchar(255) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `action` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `notified` tinyint(1) DEFAULT NULL,
  `mobile` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=700 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of history
-- ----------------------------
INSERT INTO `history` VALUES ('1', '1', '15', 'APPLIED', '2017-03-13', '15:20 PM', 'ATTEND FINAL PROJECT AS A PANEL AT POLY', '0', '');
INSERT INTO `history` VALUES ('2', '1', '18', 'APPROVED', '2017-03-13', '16:36 PM', 'Ok, goodluck', '0', '');
INSERT INTO `history` VALUES ('3', '2', '17', 'APPLIED', '09:17 AM', '2017-05-04', 'FAMILY TRIP', '0', '');
INSERT INTO `history` VALUES ('4', '2', '18', 'PENDING EITHER 1', '09:33 AM', '2017-05-04', 'ENJOY UR TRIP.', '0', '');
INSERT INTO `history` VALUES ('5', '3', '20', 'APPLIED', '17:06 PM', '2017-05-08', 'GO SIBU WITH MY MOM', '0', '');
INSERT INTO `history` VALUES ('6', '4', '21', 'APPLIED', '17:27 PM', '2017-05-19', 'GAWAI HOLIDAY', '0', '');
INSERT INTO `history` VALUES ('16', '7', '15', 'APPLIED', '09:04 AM', '2017-07-17', 'TRAVEL', '0', '');
INSERT INTO `history` VALUES ('8', '4', '18', 'APPROVED', '10:24 AM', '2017-05-29', '', '0', '');
INSERT INTO `history` VALUES ('9', '5', '21', 'APPLIED', '2017-06-12', '14:29 PM', 'Motorbike problem. Motorbike repairing should be done at 15:00PM(Today).', '0', '');
INSERT INTO `history` VALUES ('10', '5', '18', 'APPROVED', '13:54 PM', '2017-06-13', '', '0', '');
INSERT INTO `history` VALUES ('11', '3', '18', 'APPROVED', '15:09 PM', '2017-06-16', '', '0', '');
INSERT INTO `history` VALUES ('12', '6', '16', 'APPLIED', '11:40 AM', '2017-06-19', 'CUTI HARI RAYA', '0', '');
INSERT INTO `history` VALUES ('13', '6', '18', 'PENDING EITHER 1', '15:05 PM', '2017-06-19', '', '0', '');
INSERT INTO `history` VALUES ('14', '6', '19', 'APPROVED', '10:11 AM', '2017-06-29', '', '0', '');
INSERT INTO `history` VALUES ('15', '2', '19', 'APPROVED', '10:11 AM', '2017-06-29', '', '0', '');
INSERT INTO `history` VALUES ('17', '7', '18', 'APPROVED', '00:17 AM', '2017-07-18', 'ENJOY YOUR TRIP', '0', '');
INSERT INTO `history` VALUES ('18', '8', '23', 'APPLIED', '15:58 PM', '2017-09-18', 'VISIT FAMILY', '0', '');
INSERT INTO `history` VALUES ('19', '8', '19', 'APPROVED', '10:21 AM', '2017-09-19', '', '0', '');
INSERT INTO `history` VALUES ('20', '9', '23', 'APPLIED', '14:33 PM', '2017-09-29', 'TRAVELLING', '0', '');
INSERT INTO `history` VALUES ('21', '10', '22', 'APPLIED', '09:56 AM', '2017-11-08', 'COLLEGE ACTIVITY', '0', '');
INSERT INTO `history` VALUES ('22', '11', '22', 'APPLIED', '00:28 AM', '2017-11-14', 'Not feeling well.', '0', 'YES');
INSERT INTO `history` VALUES ('23', '12', '15', 'APPLIED', '08:03 AM', '2017-12-04', 'BRING SISTER ATTEND EXAM', '0', '');
INSERT INTO `history` VALUES ('24', '12', '18', 'APPROVED', '08:26 AM', '2017-12-04', 'GOODLUCK TO UR SISTER', '0', '');
INSERT INTO `history` VALUES ('25', '13', '22', 'APPLIED', '08:54 AM', '2018-01-04', 'GOING TO KL', '0', '');
INSERT INTO `history` VALUES ('26', '14', '28', 'APPLIED', '14:42 PM', '2018-01-04', 'GOING TO UNIMAS (EXAM)', '0', '');
INSERT INTO `history` VALUES ('27', '15', '28', 'APPLIED', '14:44 PM', '2018-01-04', 'GOING FOR UMRAH', '0', '');
INSERT INTO `history` VALUES ('28', '16', '31', 'APPLIED', '11:03 AM', '2018-01-23', 'SA TESTING', '0', '');
INSERT INTO `history` VALUES ('29', '16', '30', 'APPROVED', '11:04 AM', '2018-01-23', 'APPROVE SA', '0', '');
INSERT INTO `history` VALUES ('30', '16', '22', 'APPLIED', '12:49 PM', '2018-01-23', 'ATTEND A WEDDING', '0', '');
INSERT INTO `history` VALUES ('31', '17', '28', 'APPLIED', '11:00 AM', '2018-01-24', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('32', '18', '25', 'APPLIED', '10:33 AM', '2018-02-09', 'CHINESE NEW YEAR CELEBRATION', null, null);
INSERT INTO `history` VALUES ('33', '19', '26', 'APPLIED', '10:34 AM', '2018-02-09', 'EARLIER PREPARATION FOR CHINESE NEW YEAR', null, null);
INSERT INTO `history` VALUES ('34', '20', '17', 'APPLIED', '10:35 AM', '2018-02-09', 'CHINESE NEW YEAR', null, null);
INSERT INTO `history` VALUES ('35', '21', '28', 'APPLIED', '13:37 PM', '2018-02-20', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('36', '21', '18', 'APPROVED', '13:59 PM', '2018-02-20', 'OK', null, null);
INSERT INTO `history` VALUES ('37', '22', '27', 'APPLIED', '15:33 PM', '2018-02-28', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('38', '23', '27', 'APPLIED', '15:34 PM', '2018-02-28', 'TRAVELLING FOR FAMILY EVENT', null, null);
INSERT INTO `history` VALUES ('39', '24', '25', 'APPLIED', '11:32 AM', '2018-03-13', 'MEDICAL CHECKUP.', null, null);
INSERT INTO `history` VALUES ('40', '25', '26', 'APPLIED', '03:58 AM', '2018-03-16', 'High fever. Sorethroat infection ', null, 'YES');
INSERT INTO `history` VALUES ('41', '26', '26', 'APPLIED', '03:59 AM', '2018-03-16', 'High fever. Sorethroat infection ', null, 'YES');
INSERT INTO `history` VALUES ('42', '27', '17', 'APPLIED', '11:07 AM', '2018-03-16', 'FEVER', null, null);
INSERT INTO `history` VALUES ('43', '28', '25', 'APPLIED', '09:02 AM', '2018-03-19', 'APPOINTMENT WITH DOC ON 14/3 AND ONE DAY REST AFTER SURGERY 16/3', null, null);
INSERT INTO `history` VALUES ('44', '29', '25', 'APPLIED', '09:06 AM', '2018-03-19', 'SURGERY', null, null);
INSERT INTO `history` VALUES ('45', '30', '26', 'APPLIED', '10:17 AM', '2018-04-12', 'HOLIDAY', null, null);
INSERT INTO `history` VALUES ('46', '31', '28', 'APPLIED', '11:25 AM', '2018-04-13', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('47', '32', '28', 'APPLIED', '10:26 AM', '2018-04-16', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('48', '33', '15', 'APPLIED', '14:18 PM', '2018-04-17', 'TRAVEL TO JAPAN', null, null);
INSERT INTO `history` VALUES ('49', '34', '22', 'APPLIED', '16:02 PM', '2018-04-17', 'NOT FEELING WELL', null, null);
INSERT INTO `history` VALUES ('50', '35', '15', 'APPLIED', '02:35 AM', '2018-04-19', 'Bring Sister Go Exam', null, 'YES');
INSERT INTO `history` VALUES ('51', '36', '24', 'APPLIED', '09:32 AM', '2018-04-19', 'TRAVELILNG', null, null);
INSERT INTO `history` VALUES ('52', '36', '24', 'WITHDRAWN', '09:34 AM', '2018-04-19', null, null, null);
INSERT INTO `history` VALUES ('53', '37', '24', 'APPLIED', '09:52 AM', '2018-04-19', 'TRAVELLING', null, null);
INSERT INTO `history` VALUES ('54', '38', '25', 'APPLIED', '09:15 AM', '2018-04-24', 'MEDICAL CHECKUP', null, null);
INSERT INTO `history` VALUES ('55', '39', '17', 'APPLIED', '08:42 AM', '2018-04-25', 'JUST WANNA HAVE A REST!', null, null);
INSERT INTO `history` VALUES ('56', '40', '25', 'APPLIED', '13:09 PM', '2018-05-07', 'MEDICAL CHECKUP', null, null);
INSERT INTO `history` VALUES ('57', '41', '25', 'APPLIED', '17:25 PM', '2018-05-07', 'BRING MOM TO HOSPITAL', null, null);
INSERT INTO `history` VALUES ('58', '42', '17', 'APPLIED', '08:48 AM', '2018-05-11', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('59', '42', '18', 'APPROVED', '10:58 AM', '2018-05-11', '', null, null);
INSERT INTO `history` VALUES ('60', '43', '22', 'APPLIED', '11:11 AM', '2018-05-11', 'LEAVE', null, null);
INSERT INTO `history` VALUES ('61', '44', '15', 'APPLIED', '12:33 PM', '2018-05-14', 'PERSONAL PROBLEM', null, null);
INSERT INTO `history` VALUES ('62', '45', '22', 'APPLIED', '09:17 AM', '2018-05-20', 'Final exam', null, 'YES');
INSERT INTO `history` VALUES ('63', '46', '22', 'APPLIED', '09:18 AM', '2018-05-20', 'Final exam', null, 'YES');
INSERT INTO `history` VALUES ('64', '47', '22', 'APPLIED', '09:18 AM', '2018-05-20', 'Final exam', null, 'YES');
INSERT INTO `history` VALUES ('65', '48', '28', 'APPLIED', '09:12 AM', '2018-05-21', 'STUDY MATTER', null, null);
INSERT INTO `history` VALUES ('66', '49', '25', 'APPLIED', '09:22 AM', '2018-05-21', 'TRAVELLING', null, null);
INSERT INTO `history` VALUES ('67', '50', '26', 'APPLIED', '09:25 AM', '2018-05-21', 'FAMILY MATTERS. ', null, null);
INSERT INTO `history` VALUES ('68', '51', '22', 'APPLIED', '10:06 AM', '2018-05-23', 'EXAM', null, null);
INSERT INTO `history` VALUES ('69', '52', '28', 'APPLIED', '11:28 AM', '2018-05-24', 'GOING TO UNIMAS (EXAM)', null, null);
INSERT INTO `history` VALUES ('70', '53', '15', 'APPLIED', '07:37 AM', '2018-06-04', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('71', '54', '22', 'APPLIED', '09:04 AM', '2018-06-06', 'UNPAID LEAVE.  ', null, null);
INSERT INTO `history` VALUES ('72', '55', '22', 'APPLIED', '09:42 AM', '2018-06-11', 'RAYA EID\'S', null, null);
INSERT INTO `history` VALUES ('73', '55', '18', 'APPROVED', '10:20 AM', '2018-06-11', 'ENJOY YOUR RAYA', null, null);
INSERT INTO `history` VALUES ('74', '56', '24', 'APPLIED', '10:11 AM', '2018-06-13', 'RAYA', null, null);
INSERT INTO `history` VALUES ('75', '57', '26', 'APPLIED', '10:26 AM', '2018-07-05', 'HALF DAY LEAVE FOR MEDICAL CHECKUP', null, null);
INSERT INTO `history` VALUES ('76', '58', '17', 'APPLIED', '08:39 AM', '2018-07-25', 'HOLIDAY', null, null);
INSERT INTO `history` VALUES ('77', '58', '18', 'APPROVED', '09:55 AM', '2018-07-25', '', null, null);
INSERT INTO `history` VALUES ('78', '59', '28', 'APPLIED', '17:32 PM', '2018-07-27', 'EXAM AT UNIMAS', null, null);
INSERT INTO `history` VALUES ('79', '60', '25', 'APPLIED', '09:00 AM', '2018-08-01', 'MEDICAL CHECKUP', null, null);
INSERT INTO `history` VALUES ('80', '61', '26', 'APPLIED', '11:28 AM', '2018-08-01', 'HIGH FEVER', null, null);
INSERT INTO `history` VALUES ('81', '62', '17', 'APPLIED', '08:49 AM', '2018-08-06', 'FAMILY MATTERS', null, null);
INSERT INTO `history` VALUES ('82', '63', '26', 'APPLIED', '08:58 AM', '2018-08-09', 'FAMILY MATTERS', null, null);
INSERT INTO `history` VALUES ('83', '64', '25', 'APPLIED', '09:04 AM', '2018-08-09', 'MEDICAL CHECKUP', null, null);
INSERT INTO `history` VALUES ('84', '65', '28', 'APPLIED', '13:19 PM', '2018-08-11', 'EMERGENCY LEAVE', null, null);
INSERT INTO `history` VALUES ('85', '66', '26', 'APPLIED', '11:11 AM', '2018-08-14', 'SETTLING PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('86', '67', '28', 'APPLIED', '11:13 AM', '2018-08-14', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('87', '66', '18', 'APPROVED', '11:36 AM', '2018-08-14', '', null, null);
INSERT INTO `history` VALUES ('88', '66', '26', 'PENDING WITHDRAWAL', '11:07 AM', '2018-08-15', '', null, null);
INSERT INTO `history` VALUES ('89', '68', '26', 'APPLIED', '12:02 PM', '2018-08-29', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('90', '69', '25', 'APPLIED', '12:03 PM', '2018-08-29', 'EMERGENCY LEAVE', null, null);
INSERT INTO `history` VALUES ('91', '70', '22', 'APPLIED', '13:31 PM', '2018-09-18', 'APPOINTMENT AT CLINIC.\r\n-UNPAID LEAVE-', null, null);
INSERT INTO `history` VALUES ('92', '71', '26', 'APPLIED', '09:01 AM', '2018-09-20', 'CLEARING FINAL BATCH OF LEAVE APPLICATIONS', null, null);
INSERT INTO `history` VALUES ('93', '70', '22', 'WITHDRAWN', '09:04 AM', '2018-09-20', null, null, null);
INSERT INTO `history` VALUES ('94', '72', '22', 'APPLIED', '09:05 AM', '2018-09-20', 'TO CLINIC', null, null);
INSERT INTO `history` VALUES ('95', '71', '18', 'APPROVED', '14:32 PM', '2018-09-20', '', null, null);
INSERT INTO `history` VALUES ('96', '66', '18', 'WITHDRAWN', '14:33 PM', '2018-09-20', '', null, 'YES');
INSERT INTO `history` VALUES ('97', '72', '18', 'APPROVED', '14:34 PM', '2018-09-20', '', null, 'YES');
INSERT INTO `history` VALUES ('98', '10', '18', 'APPROVED', '11:50 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('99', '11', '18', 'APPROVED', '11:50 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('100', '13', '18', 'APPROVED', '11:50 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('101', '18', '18', 'APPROVED', '11:51 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('102', '19', '18', 'APPROVED', '11:51 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('103', '20', '18', 'APPROVED', '11:51 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('104', '24', '18', 'APPROVED', '11:51 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('105', '26', '18', 'APPROVED', '11:51 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('106', '27', '18', 'APPROVED', '11:51 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('107', '28', '18', 'APPROVED', '11:51 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('108', '29', '18', 'APPROVED', '11:52 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('109', '30', '18', 'APPROVED', '11:52 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('110', '34', '18', 'APPROVED', '11:52 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('111', '37', '18', 'APPROVED', '11:53 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('112', '38', '18', 'APPROVED', '11:53 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('113', '39', '18', 'APPROVED', '11:53 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('114', '40', '18', 'APPROVED', '11:53 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('115', '41', '18', 'APPROVED', '11:53 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('116', '43', '18', 'APPROVED', '11:53 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('117', '45', '18', 'APPROVED', '11:53 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('118', '49', '18', 'APPROVED', '11:54 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('119', '50', '18', 'APPROVED', '11:54 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('120', '51', '18', 'APPROVED', '11:54 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('121', '54', '18', 'APPROVED', '11:54 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('122', '56', '18', 'APPROVED', '11:55 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('123', '57', '18', 'APPROVED', '11:55 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('124', '60', '18', 'APPROVED', '11:55 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('125', '61', '18', 'APPROVED', '11:55 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('126', '62', '18', 'APPROVED', '11:55 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('127', '63', '18', 'APPROVED', '11:55 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('128', '64', '18', 'APPROVED', '11:56 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('129', '68', '18', 'APPROVED', '11:56 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('130', '69', '18', 'APPROVED', '11:57 AM', '2018-10-17', '', null, null);
INSERT INTO `history` VALUES ('131', '73', '32', 'APPLIED', '13:19 PM', '2018-10-17', '19/10 - COLLECTING ROBES (UNPAID LEAVE)\r\n26/10 - REHEARSAL (UNPAID LEAVE)\r\n30/10 - CONVOCATION DAY (UNPAID LEAVE)', null, null);
INSERT INTO `history` VALUES ('132', '73', '18', 'APPROVED', '11:36 AM', '2018-10-18', '', null, null);
INSERT INTO `history` VALUES ('133', '74', '38', 'APPLIED', '18:13 PM', '2018-10-19', 'GO CLINIC (EAR INFECTION)', null, null);
INSERT INTO `history` VALUES ('134', '74', '18', 'APPROVED', '09:15 AM', '2018-10-22', '', null, null);
INSERT INTO `history` VALUES ('135', '75', '17', 'APPLIED', '11:12 AM', '2018-10-22', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('136', '75', '18', 'APPROVED', '12:14 PM', '2018-10-22', '', null, null);
INSERT INTO `history` VALUES ('137', '76', '35', 'APPLIED', '17:28 PM', '2018-10-24', 'CONVOCATION', null, null);
INSERT INTO `history` VALUES ('138', '76', '18', 'APPROVED', '17:53 PM', '2018-10-24', 'CONGRATE', null, null);
INSERT INTO `history` VALUES ('139', '77', '25', 'APPLIED', '10:00 AM', '2018-10-25', 'MEDICAL CHECKUP', null, null);
INSERT INTO `history` VALUES ('140', '78', '25', 'APPLIED', '10:00 AM', '2018-10-25', 'MEDICAL CHECKUP', null, null);
INSERT INTO `history` VALUES ('141', '77', '18', 'APPROVED', '10:55 AM', '2018-10-25', '', null, null);
INSERT INTO `history` VALUES ('142', '78', '18', 'APPROVED', '10:55 AM', '2018-10-25', '', null, null);
INSERT INTO `history` VALUES ('143', '79', '40', 'APPLIED', '15:11 PM', '2018-10-30', 'HEADING TO PLKN CAMP AT SEMATAN AS A VIDEOGRAPHER.', null, null);
INSERT INTO `history` VALUES ('144', '80', '36', 'APPLIED', '17:06 PM', '2018-11-15', 'GOING BACK TO COLLEGE FOR ATTENDING INDUSTRIAL TRAINING PRESENTATION', null, null);
INSERT INTO `history` VALUES ('145', '80', '18', 'APPROVED', '17:39 PM', '2018-11-15', '', null, null);
INSERT INTO `history` VALUES ('146', '81', '32', 'APPLIED', '07:01 AM', '2018-11-30', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('147', '82', '17', 'APPLIED', '08:21 AM', '2018-12-10', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('148', '82', '18', 'APPROVED', '09:45 AM', '2018-12-10', 'ENJOY YOUR HOLIDAY', null, null);
INSERT INTO `history` VALUES ('149', '83', '35', 'APPLIED', '08:44 AM', '2018-12-13', 'GO BACK SIBU', null, null);
INSERT INTO `history` VALUES ('150', '84', '35', 'APPLIED', '08:44 AM', '2018-12-13', 'GO BACK SIBU', null, null);
INSERT INTO `history` VALUES ('151', '84', '35', 'WITHDRAWN', '14:58 PM', '2018-12-13', null, null, null);
INSERT INTO `history` VALUES ('152', '83', '35', 'WITHDRAWN', '14:58 PM', '2018-12-13', null, null, null);
INSERT INTO `history` VALUES ('153', '85', '35', 'APPLIED', '14:59 PM', '2018-12-13', 'GO BACK SIBU', null, null);
INSERT INTO `history` VALUES ('154', '86', '36', 'APPLIED', '14:12 PM', '2018-12-19', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('155', '85', '18', 'APPROVED', '11:31 AM', '2018-12-21', '', null, null);
INSERT INTO `history` VALUES ('156', '87', '17', 'APPLIED', '08:30 AM', '2018-12-24', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('157', '88', '22', 'APPLIED', '10:35 AM', '2018-12-24', 'FEVER', null, null);
INSERT INTO `history` VALUES ('158', '89', '39', 'APPLIED', '09:40 AM', '2018-12-31', 'TEST', null, null);
INSERT INTO `history` VALUES ('159', '89', '39', 'WITHDRAWN', '09:41 AM', '2018-12-31', null, null, null);
INSERT INTO `history` VALUES ('160', '90', '39', 'APPLIED', '09:45 AM', '2018-12-31', 'TEST', null, null);
INSERT INTO `history` VALUES ('161', '90', '39', 'WITHDRAWN', '09:46 AM', '2018-12-31', null, null, null);
INSERT INTO `history` VALUES ('162', '91', '42', 'APPLIED', '15:26 PM', '2018-12-31', 'CHINESE NEW YEAR BREAK', null, null);
INSERT INTO `history` VALUES ('163', '92', '39', 'APPLIED', '16:19 PM', '2018-12-31', 'TEST', null, null);
INSERT INTO `history` VALUES ('164', '92', '39', 'WITHDRAWN', '16:20 PM', '2018-12-31', null, null, null);
INSERT INTO `history` VALUES ('165', '93', '39', 'APPLIED', '16:21 PM', '2018-12-31', 'TEST', null, null);
INSERT INTO `history` VALUES ('166', '93', '39', 'WITHDRAWN', '16:24 PM', '2018-12-31', null, null, null);
INSERT INTO `history` VALUES ('167', '94', '39', 'APPLIED', '16:49 PM', '2018-12-31', 'TEST', null, null);
INSERT INTO `history` VALUES ('168', '94', '39', 'WITHDRAWN', '16:51 PM', '2018-12-31', null, null, null);
INSERT INTO `history` VALUES ('169', '95', '17', 'APPLIED', '08:55 AM', '2019-01-04', 'CHINESE NEW YEAR HOLIDAY', null, null);
INSERT INTO `history` VALUES ('170', '96', '35', 'APPLIED', '08:54 AM', '2019-01-09', 'CHINESE NEW YEAR', null, null);
INSERT INTO `history` VALUES ('171', '97', '22', 'APPLIED', '11:22 AM', '2019-01-09', '4/1 - FINALS', null, null);
INSERT INTO `history` VALUES ('172', '98', '17', 'APPLIED', '08:31 AM', '2019-01-15', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('173', '98', '18', 'APPROVED', '18:37 PM', '2019-01-15', '', null, null);
INSERT INTO `history` VALUES ('174', '99', '39', 'APPLIED', '15:04 PM', '2019-01-17', 'NEED TO SETTLE EPF,SOCSO, AND WORKING PERMIT MATTER.', null, null);
INSERT INTO `history` VALUES ('175', '94', '39', 'PENDING WITHDRAWAL', '09:13 AM', '2019-01-21', 'THIS IS FOR TESTING ONLY..', null, null);
INSERT INTO `history` VALUES ('176', '93', '39', 'PENDING WITHDRAWAL', '09:13 AM', '2019-01-21', 'THIS IS FOR TESTING ONLY..', null, null);
INSERT INTO `history` VALUES ('177', '92', '39', 'PENDING WITHDRAWAL', '09:13 AM', '2019-01-21', 'THIS IS FOR TESTING ONLY..', null, null);
INSERT INTO `history` VALUES ('178', '90', '39', 'PENDING WITHDRAWAL', '09:13 AM', '2019-01-21', 'THIS IS FOR TESTING ONLY..', null, null);
INSERT INTO `history` VALUES ('179', '89', '39', 'PENDING WITHDRAWAL', '09:13 AM', '2019-01-21', 'THIS IS FOR TESTING ONLY..', null, null);
INSERT INTO `history` VALUES ('180', '96', '35', 'WITHDRAWN', '10:06 AM', '2019-01-21', null, null, null);
INSERT INTO `history` VALUES ('181', '100', '35', 'APPLIED', '10:15 AM', '2019-01-21', 'CHINESE NEW YEAR', null, null);
INSERT INTO `history` VALUES ('182', '95', '17', 'WITHDRAWN', '10:16 AM', '2019-01-21', null, null, null);
INSERT INTO `history` VALUES ('183', '101', '17', 'APPLIED', '10:16 AM', '2019-01-21', 'CHINESE NEW YEAR', null, null);
INSERT INTO `history` VALUES ('184', '101', '18', 'APPROVED', '10:43 AM', '2019-01-21', 'HAVE A HAPPY CNY', null, null);
INSERT INTO `history` VALUES ('185', '100', '18', 'APPROVED', '10:44 AM', '2019-01-21', 'ENJOY UR CNY\r\n', null, null);
INSERT INTO `history` VALUES ('186', '91', '42', 'WITHDRAWN', '13:34 PM', '2019-01-21', null, null, null);
INSERT INTO `history` VALUES ('187', '102', '42', 'APPLIED', '13:33 PM', '2019-01-22', 'CHINESE NEW YEAR HOLIDAY', null, null);
INSERT INTO `history` VALUES ('188', '102', '18', 'APPROVED', '14:57 PM', '2019-01-22', '', null, null);
INSERT INTO `history` VALUES ('189', '103', '43', 'APPLIED', '20:52 PM', '2019-01-22', 'CNY', null, null);
INSERT INTO `history` VALUES ('190', '103', '18', 'APPROVED', '10:15 AM', '2019-01-23', '', null, null);
INSERT INTO `history` VALUES ('191', '104', '36', 'APPLIED', '12:29 PM', '2019-01-23', 'FAMILY MATTERS', null, null);
INSERT INTO `history` VALUES ('192', '105', '40', 'APPLIED', '15:59 PM', '2019-01-25', 'FAMILTY TRIP VACATION', null, null);
INSERT INTO `history` VALUES ('193', '106', '36', 'APPLIED', '14:40 PM', '2019-02-14', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('194', '107', '36', 'APPLIED', '14:41 PM', '2019-02-14', 'FAMILY TRIP', null, null);
INSERT INTO `history` VALUES ('195', '106', '18', 'APPROVED', '14:55 PM', '2019-02-14', '', null, null);
INSERT INTO `history` VALUES ('196', '108', '40', 'APPLIED', '17:27 PM', '2019-02-21', 'GOING TO KL', null, null);
INSERT INTO `history` VALUES ('197', '109', '17', 'APPLIED', '08:32 AM', '2019-02-25', 'FAMILY MATTERS', null, null);
INSERT INTO `history` VALUES ('198', '110', '43', 'APPLIED', '08:44 AM', '2019-02-25', 'PERSON REASON', null, null);
INSERT INTO `history` VALUES ('199', '109', '18', 'APPROVED', '09:28 AM', '2019-02-25', '', null, null);
INSERT INTO `history` VALUES ('200', '111', '22', 'APPLIED', '11:36 AM', '2019-02-26', 'GO TO HOSPITAL', null, null);
INSERT INTO `history` VALUES ('201', '111', '18', 'APPROVED', '15:13 PM', '2019-02-26', '', null, null);
INSERT INTO `history` VALUES ('202', '110', '43', 'WITHDRAWN', '15:43 PM', '2019-02-26', null, null, null);
INSERT INTO `history` VALUES ('203', '112', '43', 'APPLIED', '15:44 PM', '2019-02-26', 'PERSONAL REASON', null, null);
INSERT INTO `history` VALUES ('204', '112', '18', 'APPROVED', '16:39 PM', '2019-02-26', '', null, null);
INSERT INTO `history` VALUES ('205', '113', '35', 'APPLIED', '13:23 PM', '2019-02-28', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('206', '113', '18', 'APPROVED', '15:27 PM', '2019-02-28', 'TRAVELLING?', null, null);
INSERT INTO `history` VALUES ('207', '114', '22', 'APPLIED', '10:30 AM', '2019-03-13', 'GO TO COLLEGE\r\n', null, null);
INSERT INTO `history` VALUES ('208', '114', '18', 'APPROVED', '11:31 AM', '2019-03-13', '', null, null);
INSERT INTO `history` VALUES ('209', '114', '22', 'PENDING WITHDRAWAL', '11:31 AM', '2019-03-15', '', null, null);
INSERT INTO `history` VALUES ('210', '115', '43', 'APPLIED', '08:32 AM', '2019-03-19', 'STOMACH PAIN', null, null);
INSERT INTO `history` VALUES ('211', '116', '22', 'APPLIED', '09:14 AM', '2019-03-21', 'GOING TO HOSPITAL', null, null);
INSERT INTO `history` VALUES ('212', '117', '22', 'APPLIED', '12:08 PM', '2019-04-01', 'COLLEGE EVENT (FOR ASSIGNMENT)', null, null);
INSERT INTO `history` VALUES ('213', '118', '22', 'APPLIED', '12:11 PM', '2019-04-01', 'RECEIVED AWARD IN KL (FOR COLLEGE)', null, null);
INSERT INTO `history` VALUES ('214', '119', '32', 'APPLIED', '08:58 AM', '2019-05-02', 'AL', null, null);
INSERT INTO `history` VALUES ('215', '119', '18', 'APPROVED', '09:12 AM', '2019-05-02', '', null, null);
INSERT INTO `history` VALUES ('216', '120', '17', 'APPLIED', '08:17 AM', '2019-05-08', 'FAMILY MATTERS', null, null);
INSERT INTO `history` VALUES ('217', '120', '18', 'APPROVED', '08:29 AM', '2019-05-08', '', null, null);
INSERT INTO `history` VALUES ('218', '120', '17', 'PENDING WITHDRAWAL', '08:46 AM', '2019-05-14', '', null, null);
INSERT INTO `history` VALUES ('219', '121', '17', 'APPLIED', '08:56 AM', '2019-05-14', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('220', '122', '42', 'APPLIED', '10:25 AM', '2019-05-14', 'PERSONAL REASON', null, null);
INSERT INTO `history` VALUES ('221', '122', '18', 'APPROVED', '10:41 AM', '2019-05-14', '', null, null);
INSERT INTO `history` VALUES ('222', '120', '18', 'WITHDRAWN', '12:18 PM', '2019-05-14', '', null, null);
INSERT INTO `history` VALUES ('223', '121', '18', 'APPROVED', '12:18 PM', '2019-05-14', '', null, null);
INSERT INTO `history` VALUES ('224', '123', '36', 'APPLIED', '16:07 PM', '2019-05-15', 'GOING BACK TO COLLEGE AND PERSONAL MATTERS', null, null);
INSERT INTO `history` VALUES ('225', '124', '42', 'APPLIED', '14:24 PM', '2019-05-16', 'PERSONAL REASON', null, null);
INSERT INTO `history` VALUES ('226', '125', '35', 'APPLIED', '14:36 PM', '2019-05-16', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('227', '126', '22', 'APPLIED', '14:38 PM', '2019-05-16', 'GO TO COLLEGE & RAYA', null, null);
INSERT INTO `history` VALUES ('228', '127', '32', 'APPLIED', '14:52 PM', '2019-05-16', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('229', '128', '43', 'APPLIED', '19:08 PM', '2019-05-16', 'GO BACK TO HOMETOWN', null, null);
INSERT INTO `history` VALUES ('230', '129', '43', 'APPLIED', '19:12 PM', '2019-05-16', 'GO BACK TO HOMETOWN', null, null);
INSERT INTO `history` VALUES ('231', '127', '32', 'WITHDRAWN', '10:48 AM', '2019-05-17', null, null, null);
INSERT INTO `history` VALUES ('232', '130', '32', 'APPLIED', '10:51 AM', '2019-05-17', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('233', '126', '22', 'WITHDRAWN', '10:55 AM', '2019-05-17', null, null, null);
INSERT INTO `history` VALUES ('234', '131', '22', 'APPLIED', '10:55 AM', '2019-05-17', '22/5 - GO TO COLLEGE\r\n4/6 - RAYA', null, null);
INSERT INTO `history` VALUES ('235', '123', '18', 'APPROVED', '11:28 AM', '2019-05-17', '', null, null);
INSERT INTO `history` VALUES ('236', '124', '18', 'APPROVED', '11:29 AM', '2019-05-17', '', null, null);
INSERT INTO `history` VALUES ('237', '128', '18', 'APPROVED', '11:29 AM', '2019-05-17', '', null, null);
INSERT INTO `history` VALUES ('238', '129', '18', 'APPROVED', '11:30 AM', '2019-05-17', '', null, null);
INSERT INTO `history` VALUES ('239', '125', '18', 'APPROVED', '11:30 AM', '2019-05-17', '', null, null);
INSERT INTO `history` VALUES ('240', '130', '18', 'APPROVED', '11:31 AM', '2019-05-17', '', null, null);
INSERT INTO `history` VALUES ('241', '131', '18', 'APPROVED', '11:32 AM', '2019-05-17', '', null, null);
INSERT INTO `history` VALUES ('242', '132', '22', 'APPLIED', '09:11 AM', '2019-05-21', 'RAYA', null, null);
INSERT INTO `history` VALUES ('243', '132', '18', 'APPROVED', '13:23 PM', '2019-05-22', '', null, null);
INSERT INTO `history` VALUES ('244', '133', '39', 'APPLIED', '15:32 PM', '2019-05-24', 'HOLIDAY', null, null);
INSERT INTO `history` VALUES ('245', '134', '36', 'APPLIED', '16:18 PM', '2019-05-27', 'PERSONAL MATTERS', null, null);
INSERT INTO `history` VALUES ('246', '134', '36', 'WITHDRAWN', '16:51 PM', '2019-05-27', null, null, null);
INSERT INTO `history` VALUES ('247', '135', '36', 'APPLIED', '16:53 PM', '2019-05-27', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('248', '133', '18', 'APPROVED', '21:17 PM', '2019-05-27', '', null, null);
INSERT INTO `history` VALUES ('249', '135', '18', 'APPROVED', '11:02 AM', '2019-05-28', '', null, null);
INSERT INTO `history` VALUES ('250', '136', '43', 'APPLIED', '07:32 AM', '2019-05-30', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('251', '137', '43', 'APPLIED', '07:34 AM', '2019-05-30', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('252', '138', '42', 'APPLIED', '09:38 AM', '2019-06-13', 'PERSONAL REASON', null, null);
INSERT INTO `history` VALUES ('253', '138', '18', 'APPROVED', '11:06 AM', '2019-06-17', '', null, null);
INSERT INTO `history` VALUES ('254', '139', '17', 'APPLIED', '14:18 PM', '2019-06-18', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('255', '140', '22', 'APPLIED', '12:25 PM', '2019-06-19', 'EMERGENCY LEAVE', null, null);
INSERT INTO `history` VALUES ('256', '120', '17', 'PENDING WITHDRAWAL', '10:02 AM', '2019-06-21', 'ALRDY WITHDRAWN, SYSTEM ERROR', null, null);
INSERT INTO `history` VALUES ('257', '95', '17', 'PENDING WITHDRAWAL', '10:03 AM', '2019-06-21', 'LAST TIME ALREADY WITHDARWN, SYSTEM ERROR', null, null);
INSERT INTO `history` VALUES ('258', '141', '32', 'APPLIED', '08:29 AM', '2019-07-01', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('259', '141', '18', 'APPROVED', '10:22 AM', '2019-07-01', '', null, null);
INSERT INTO `history` VALUES ('260', '120', '18', 'WITHDRAWN', '10:23 AM', '2019-07-01', '', null, null);
INSERT INTO `history` VALUES ('261', '142', '17', 'APPLIED', '08:37 AM', '2019-07-15', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('262', '143', '42', 'APPLIED', '14:34 PM', '2019-07-15', 'PERSONAL REASON', null, null);
INSERT INTO `history` VALUES ('263', '142', '18', 'APPROVED', '14:38 PM', '2019-07-15', '', null, null);
INSERT INTO `history` VALUES ('264', '143', '18', 'APPROVED', '14:38 PM', '2019-07-15', '', null, null);
INSERT INTO `history` VALUES ('265', '144', '44', 'APPLIED', '14:32 PM', '2019-07-16', 'PRESENTATION WITH MY LECTURER\r\nVACATION WITH FAMILY', null, null);
INSERT INTO `history` VALUES ('266', '145', '36', 'APPLIED', '15:55 PM', '2019-07-18', 'PERSONAL MATTERS', null, null);
INSERT INTO `history` VALUES ('267', '146', '32', 'APPLIED', '08:13 AM', '2019-07-23', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('268', '147', '35', 'APPLIED', '08:27 AM', '2019-07-23', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('269', '148', '22', 'APPLIED', '15:21 PM', '2019-08-13', 'GO TO COLLEGE (SEMINAR)', null, null);
INSERT INTO `history` VALUES ('270', '148', '18', 'APPROVED', '17:28 PM', '2019-08-13', '', null, null);
INSERT INTO `history` VALUES ('271', '149', '32', 'APPLIED', '08:05 AM', '2019-08-14', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('272', '150', '47', 'APPLIED', '08:07 AM', '2019-08-14', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('273', '151', '48', 'APPLIED', '09:52 AM', '2019-08-14', 'UNPAID LEAVE', null, null);
INSERT INTO `history` VALUES ('274', '152', '48', 'APPLIED', '08:43 AM', '2019-08-29', 'SEE DOCTOR', null, null);
INSERT INTO `history` VALUES ('275', '152', '48', 'WITHDRAWN', '08:43 AM', '2019-08-29', null, null, null);
INSERT INTO `history` VALUES ('276', '153', '48', 'APPLIED', '08:44 AM', '2019-08-29', 'SEE DOCTOR', null, null);
INSERT INTO `history` VALUES ('277', '154', '22', 'APPLIED', '10:33 AM', '2019-09-18', 'CLINIC APPOINTMENT', null, null);
INSERT INTO `history` VALUES ('278', '155', '47', 'APPLIED', '16:09 PM', '2019-09-18', 'PRESENTATION', null, null);
INSERT INTO `history` VALUES ('279', '155', '18', 'APPROVED', '10:31 AM', '2019-09-23', '', null, null);
INSERT INTO `history` VALUES ('280', '154', '18', 'APPROVED', '10:31 AM', '2019-09-23', '', null, null);
INSERT INTO `history` VALUES ('281', '156', '22', 'APPLIED', '09:50 AM', '2019-09-24', 'TO ATTEND COLLEGE PROJECT FOR ASSIGNMENT', null, null);
INSERT INTO `history` VALUES ('282', '157', '32', 'APPLIED', '08:33 AM', '2019-10-03', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('283', '157', '18', 'APPROVED', '10:24 AM', '2019-10-03', '', null, null);
INSERT INTO `history` VALUES ('284', '158', '49', 'APPLIED', '16:17 PM', '2019-10-07', 'REPAIR MOTORCYCLE,\r\n(UNPAID LEAVE)', null, null);
INSERT INTO `history` VALUES ('285', '158', '18', 'APPROVED', '21:55 PM', '2019-10-07', '', null, null);
INSERT INTO `history` VALUES ('286', '159', '32', 'APPLIED', '08:09 AM', '2019-10-24', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('287', '160', '22', 'APPLIED', '09:46 AM', '2019-10-25', 'SICK LEAVE', null, null);
INSERT INTO `history` VALUES ('288', '161', '44', 'APPLIED', '09:06 AM', '2019-11-01', 'COLLEGE', null, null);
INSERT INTO `history` VALUES ('289', '162', '32', 'APPLIED', '17:18 PM', '2019-11-01', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('290', '163', '47', 'APPLIED', '17:21 PM', '2019-11-01', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('291', '161', '18', 'APPROVED', '11:13 AM', '2019-11-06', '', null, null);
INSERT INTO `history` VALUES ('292', '163', '18', 'APPROVED', '11:14 AM', '2019-11-06', '', null, null);
INSERT INTO `history` VALUES ('293', '164', '22', 'APPLIED', '10:06 AM', '2019-11-11', 'COLLEGE', null, null);
INSERT INTO `history` VALUES ('294', '165', '50', 'APPLIED', '14:09 PM', '2019-11-13', 'GRADUATION CEREMONY ', null, null);
INSERT INTO `history` VALUES ('295', '166', '53', 'APPLIED', '09:01 AM', '2019-11-18', 'KURSUS', null, null);
INSERT INTO `history` VALUES ('296', '167', '49', 'APPLIED', '14:01 PM', '2019-11-18', 'GO TO BENGKEL ', null, null);
INSERT INTO `history` VALUES ('297', '168', '32', 'APPLIED', '17:02 PM', '2019-11-22', 'ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('298', '168', '18', 'APPROVED', '11:41 AM', '2019-11-25', '', null, 'YES');
INSERT INTO `history` VALUES ('299', '169', '32', 'APPLIED', '08:19 AM', '2019-12-09', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('300', '170', '47', 'APPLIED', '08:21 AM', '2019-12-09', 'FAMLIY MATTER', null, null);
INSERT INTO `history` VALUES ('301', '171', '44', 'APPLIED', '09:12 AM', '2019-12-16', 'APPOINTMENT WITH UNIVERSITY', null, null);
INSERT INTO `history` VALUES ('302', '171', '18', 'APPROVED', '09:58 AM', '2019-12-16', 'OK', null, null);
INSERT INTO `history` VALUES ('303', '172', '54', 'APPLIED', '16:25 PM', '2019-12-26', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('304', '173', '54', 'APPLIED', '16:27 PM', '2019-12-26', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('305', '173', '18', 'APPROVED', '21:05 PM', '2019-12-30', '', null, null);
INSERT INTO `history` VALUES ('306', '172', '18', 'APPROVED', '21:05 PM', '2019-12-30', '', null, null);
INSERT INTO `history` VALUES ('307', '174', '55', 'APPLIED', '14:00 PM', '2020-01-07', 'ATTENDING INTERNSHIP PRESENTATION AT I-CATS', null, null);
INSERT INTO `history` VALUES ('308', '175', '56', 'APPLIED', '14:57 PM', '2020-01-07', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('309', '176', '56', 'APPLIED', '14:59 PM', '2020-01-07', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('310', '177', '56', 'APPLIED', '15:01 PM', '2020-01-07', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('311', '178', '55', 'APPLIED', '12:27 PM', '2020-01-09', 'HELPED MY BROTHER BECAUSE HIS CAR BROKE DOWN IN THE MIDDLE OF THE ROAD', null, null);
INSERT INTO `history` VALUES ('312', '179', '55', 'APPLIED', '09:48 AM', '2020-01-17', 'WAS FEELING UNWELL SO WENT TO CLINIC FOR CHECK UP', null, null);
INSERT INTO `history` VALUES ('313', '180', '57', 'APPLIED', '16:37 PM', '2020-01-20', 'NEED GO BACK UNIVERSITY TO PAY THE PAYMENT OF SEMESTER  TUITION FEE AND REGISTRATION ON 23/01/2020.\r\nON 24/01/2020, PERSONAL REASON HAVE AN APPOINTMENT WITH SUBJECT LECTURER ABOUT EXAMINATION. ', null, null);
INSERT INTO `history` VALUES ('314', '181', '32', 'APPLIED', '07:50 AM', '2020-01-22', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('315', '182', '47', 'APPLIED', '08:51 AM', '2020-01-22', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('316', '183', '55', 'APPLIED', '12:57 PM', '2020-01-29', 'LOOK FOR COMPONENTS FOR WORK AND BRING CAR TO REPAIR', null, null);
INSERT INTO `history` VALUES ('317', '184', '56', 'APPLIED', '11:19 AM', '2020-02-05', 'MC ', null, null);
INSERT INTO `history` VALUES ('318', '185', '49', 'APPLIED', '13:44 PM', '2020-02-06', 'HOME ISSUE', null, null);
INSERT INTO `history` VALUES ('319', '186', '57', 'APPLIED', '11:23 AM', '2020-02-07', 'GO TO MAKING POLICE REPORT DUE TO CELL PHONE HAS BEEN SNATCHED.', null, null);
INSERT INTO `history` VALUES ('320', '187', '55', 'APPLIED', '17:22 PM', '2020-02-07', 'WAS UNWELL', null, null);
INSERT INTO `history` VALUES ('321', '188', '55', 'APPLIED', '17:25 PM', '2020-02-07', 'STUCKED IN TRAFFIC JAM AND CAUSED ME TO BE VERY LATE FOR WORK', null, null);
INSERT INTO `history` VALUES ('322', '189', '64', 'APPLIED', '14:09 PM', '2020-02-10', 'DO POLICE REPORT DUE TO SNATCHING CASE EARLIER THE MORNING AS WITNESS.', null, null);
INSERT INTO `history` VALUES ('323', '190', '64', 'APPLIED', '14:28 PM', '2020-02-11', 'HOSPITAL APPOINTMENT FOR TAKING BLOOD. (HOSPITAL RAJAH CHARLES BROOKE MEMORIAL)', null, null);
INSERT INTO `history` VALUES ('324', '191', '64', 'APPLIED', '14:30 PM', '2020-02-11', 'DOCTOR APPOINTMENT AT HOSPITAL RAJAH CHARLES BROOKE MEMORIAL.', null, null);
INSERT INTO `history` VALUES ('325', '192', '55', 'APPLIED', '12:53 PM', '2020-02-13', 'WENT TO CLINIC FOR SINUS PAIN BUT NO MC BECAUSE NO MEDICATION WAS NEEDED YET', null, null);
INSERT INTO `history` VALUES ('326', '193', '32', 'APPLIED', '10:09 AM', '2020-02-20', '19/02 & 25/02 - PERSONAL MATTER\r\n24/03 - 27/03 - GOING TO KL', null, null);
INSERT INTO `history` VALUES ('327', '194', '49', 'APPLIED', '10:10 AM', '2020-02-20', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('328', '195', '55', 'APPLIED', '10:20 AM', '2020-02-20', 'GOING TO ICATS FOR LI ENDORSEMENT AND TAKING RESULT SLIPS AND LETTER OF COMPLETION.', null, null);
INSERT INTO `history` VALUES ('329', '196', '47', 'APPLIED', '11:52 AM', '2020-02-24', 'CONVOCATION', null, null);
INSERT INTO `history` VALUES ('330', '194', '18', 'APPROVED', '11:14 AM', '2020-02-25', '', null, null);
INSERT INTO `history` VALUES ('331', '196', '18', 'APPROVED', '15:23 PM', '2020-02-25', '', null, null);
INSERT INTO `history` VALUES ('332', '197', '44', 'APPLIED', '10:38 AM', '2020-02-28', 'SUBMIT BANK DOCUMENTS', null, null);
INSERT INTO `history` VALUES ('333', '198', '53', 'APPLIED', '09:39 AM', '2020-03-09', 'WIFE\'S BIRTH DELIVERY', null, null);
INSERT INTO `history` VALUES ('334', '199', '53', 'APPLIED', '09:40 AM', '2020-03-09', 'WIFE\'S BIRTH DELIVERY', null, null);
INSERT INTO `history` VALUES ('335', '200', '59', 'APPLIED', '14:11 PM', '2020-03-12', 'SICK LEAVE TO CARE FOR MY MOTHER. MY MOM WAS HOSPITALIZED AND UNDERGO SURGERY DUE TO HARMFUL BACTERIA INFECTION IN SARAWAK GENERAL HOSPITAL. I HAVE TO TAKE CARE OF HER SINCE THAT PERIOD OTHER FAMILY MEMBERS IN CHARGE TAKING CARE OF HER.', null, null);
INSERT INTO `history` VALUES ('336', '201', '57', 'APPLIED', '09:57 AM', '2020-03-16', 'TRAVEL TO MIRI ATTEND MY BROTHER WEDDING WITH FAMILY', null, null);
INSERT INTO `history` VALUES ('337', '202', '50', 'APPLIED', '15:01 PM', '2020-03-17', 'CORONA VIRUS', null, null);
INSERT INTO `history` VALUES ('338', '203', '50', 'APPLIED', '15:03 PM', '2020-03-17', 'CORONA VIRUS', null, null);
INSERT INTO `history` VALUES ('339', '200', '59', 'PENDING WITHDRAWAL', '16:44 PM', '2020-03-17', '', null, null);
INSERT INTO `history` VALUES ('340', '204', '49', 'APPLIED', '10:40 AM', '2020-05-12', 'AIDILFITRI AT LIMBANG SARAWAK', null, null);
INSERT INTO `history` VALUES ('341', '205', '32', 'APPLIED', '08:10 AM', '2020-05-15', 'RAYA', null, null);
INSERT INTO `history` VALUES ('342', '206', '47', 'APPLIED', '08:19 AM', '2020-05-15', 'RAYA', null, null);
INSERT INTO `history` VALUES ('343', '204', '49', 'WITHDRAWN', '08:30 AM', '2020-05-15', null, null, null);
INSERT INTO `history` VALUES ('344', '207', '49', 'APPLIED', '08:38 AM', '2020-05-15', 'RAYA AT LIMBANG', null, null);
INSERT INTO `history` VALUES ('345', '205', '32', 'WITHDRAWN', '09:24 AM', '2020-05-15', null, null, null);
INSERT INTO `history` VALUES ('346', '206', '47', 'WITHDRAWN', '09:25 AM', '2020-05-15', null, null, null);
INSERT INTO `history` VALUES ('347', '207', '49', 'WITHDRAWN', '09:27 AM', '2020-05-15', null, null, null);
INSERT INTO `history` VALUES ('348', '208', '49', 'APPLIED', '09:27 AM', '2020-05-15', 'RAYA AT LIMBANG', null, null);
INSERT INTO `history` VALUES ('349', '209', '32', 'APPLIED', '09:39 AM', '2020-05-15', 'RAYA', null, null);
INSERT INTO `history` VALUES ('350', '210', '47', 'APPLIED', '09:39 AM', '2020-05-15', 'RAYA', null, null);
INSERT INTO `history` VALUES ('351', '211', '56', 'APPLIED', '14:05 PM', '2020-05-15', 'HARI RAYA CELEBRATION.', null, null);
INSERT INTO `history` VALUES ('352', '212', '53', 'APPLIED', '08:44 AM', '2020-05-18', 'HARI RAYA CELEBRATION.', null, null);
INSERT INTO `history` VALUES ('353', '211', '56', 'WITHDRAWN', '12:43 PM', '2020-05-29', null, null, null);
INSERT INTO `history` VALUES ('354', '213', '55', 'APPLIED', '13:12 PM', '2020-05-29', 'WENT TO SEARCH AND BUY MATERIALS FOR WORK', null, null);
INSERT INTO `history` VALUES ('355', '214', '56', 'APPLIED', '16:27 PM', '2020-06-01', 'HARI RAYA CELEBRATION', null, null);
INSERT INTO `history` VALUES ('356', '215', '55', 'APPLIED', '18:36 PM', '2020-06-01', 'EXTEND GAWAI HOLIDAY', null, null);
INSERT INTO `history` VALUES ('357', '216', '44', 'APPLIED', '15:05 PM', '2020-06-09', 'SUBMITTING DOCUMENTS', null, null);
INSERT INTO `history` VALUES ('358', '217', '69', 'APPLIED', '09:10 AM', '2020-06-12', 'GOVERNMENT DENTAL APPOINTMENT', null, null);
INSERT INTO `history` VALUES ('359', '218', '64', 'APPLIED', '09:34 AM', '2020-06-15', 'HOSPITAL APPOINTMENT', null, null);
INSERT INTO `history` VALUES ('360', '219', '64', 'APPLIED', '09:41 AM', '2020-06-15', 'DOCTOR APPOINTMENT AT HOSPITAL RAJAH CHARLES BROOKE MEMORIAL.', null, null);
INSERT INTO `history` VALUES ('361', '220', '55', 'APPLIED', '13:56 PM', '2020-06-16', 'BODY ACHE', null, null);
INSERT INTO `history` VALUES ('362', '214', '56', 'PENDING WITHDRAWAL', '11:34 AM', '2020-06-17', '', null, null);
INSERT INTO `history` VALUES ('363', '211', '56', 'PENDING WITHDRAWAL', '11:35 AM', '2020-06-17', '', null, null);
INSERT INTO `history` VALUES ('364', '221', '57', 'APPLIED', '08:31 AM', '2020-06-22', 'HOSPITAL\'S APPOINTMENT', null, null);
INSERT INTO `history` VALUES ('365', '222', '55', 'APPLIED', '08:48 AM', '2020-06-26', 'HEADACHE AND NAUSEA', null, null);
INSERT INTO `history` VALUES ('366', '223', '62', 'APPLIED', '09:47 AM', '2020-06-30', 'SISTER\'S WEDDING', null, null);
INSERT INTO `history` VALUES ('367', '224', '55', 'APPLIED', '13:23 PM', '2020-06-30', 'SEND CAR TO WORKSHOP DUE TO GEARBOX ISSUE', null, null);
INSERT INTO `history` VALUES ('368', '225', '55', 'APPLIED', '13:25 PM', '2020-06-30', 'TAKE CAR FROM WORKSHOP', null, null);
INSERT INTO `history` VALUES ('369', '226', '32', 'APPLIED', '16:09 PM', '2020-07-01', 'PERSONAL  MATTER', null, null);
INSERT INTO `history` VALUES ('370', '227', '49', 'APPLIED', '09:43 AM', '2020-07-03', 'REPAIR MOTORCYCLE', null, null);
INSERT INTO `history` VALUES ('371', '228', '64', 'APPLIED', '13:41 PM', '2020-07-06', 'HOSPITAL APPOINTMENT', null, null);
INSERT INTO `history` VALUES ('372', '229', '56', 'APPLIED', '08:54 AM', '2020-07-09', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('373', '230', '55', 'APPLIED', '13:27 PM', '2020-07-09', 'HAD TO SEND COUSIN FOR CHECK UP APPOINTMENT', null, null);
INSERT INTO `history` VALUES ('374', '231', '49', 'APPLIED', '15:28 PM', '2020-07-23', 'GO TO UNIMAS TO RETURN COLLEGE AND TAKE ALL BELONGINGS FROM COLLEGE STORE.  BECAUSE IN THE PKPP PHASE, COLLEGE DOES NOT ALLOW RETURN KEY AND TAKE BELONGINGS FROM STORE ON PUBLICK HOLIDAY AND SATURDAY AND SUNDAY', null, null);
INSERT INTO `history` VALUES ('375', '232', '56', 'APPLIED', '15:35 PM', '2020-07-23', 'PERSONAL MATTER - MEETING WITH WEDDING PLANNER', null, null);
INSERT INTO `history` VALUES ('376', '233', '56', 'APPLIED', '15:37 PM', '2020-07-23', 'PERSONAL MATTER - GO TO JAIS SAMARAHAN', null, null);
INSERT INTO `history` VALUES ('377', '233', '56', 'WITHDRAWN', '15:43 PM', '2020-07-23', null, null, null);
INSERT INTO `history` VALUES ('378', '232', '56', 'WITHDRAWN', '15:43 PM', '2020-07-23', null, null, null);
INSERT INTO `history` VALUES ('379', '234', '56', 'APPLIED', '15:47 PM', '2020-07-23', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('380', '235', '56', 'APPLIED', '15:48 PM', '2020-07-23', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('381', '236', '55', 'APPLIED', '15:57 PM', '2020-07-23', 'DIARRHEA', null, null);
INSERT INTO `history` VALUES ('382', '237', '55', 'APPLIED', '08:50 AM', '2020-07-27', 'GOING TO PKB TO CLEAR CONFUSION AND FALSE ACCUSATION', null, null);
INSERT INTO `history` VALUES ('383', '238', '55', 'APPLIED', '08:51 AM', '2020-07-27', 'GOING TO PKB TO CLEAR CONFUSION AND FALSE ACCUSATION', null, null);
INSERT INTO `history` VALUES ('384', '237', '55', 'WITHDRAWN', '09:00 AM', '2020-07-27', null, null, null);
INSERT INTO `history` VALUES ('385', '239', '32', 'APPLIED', '08:22 AM', '2020-07-28', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('386', '240', '47', 'APPLIED', '08:25 AM', '2020-07-28', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('387', '231', '49', 'WITHDRAWN', '12:42 PM', '2020-07-28', null, null, null);
INSERT INTO `history` VALUES ('388', '241', '49', 'APPLIED', '12:44 PM', '2020-07-28', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('389', '242', '64', 'APPLIED', '13:44 PM', '2020-08-03', 'HOSPITAL APPOINTMENT - CHECK UP', null, null);
INSERT INTO `history` VALUES ('390', '235', '56', 'PENDING WITHDRAWAL', '09:42 AM', '2020-08-05', '', null, null);
INSERT INTO `history` VALUES ('391', '233', '56', 'PENDING WITHDRAWAL', '09:21 AM', '2020-08-06', 'I AM COMING TO WORK', null, null);
INSERT INTO `history` VALUES ('392', '232', '56', 'PENDING WITHDRAWAL', '09:21 AM', '2020-08-06', 'DUPLICATE APPLICATION', null, null);
INSERT INTO `history` VALUES ('393', '243', '55', 'APPLIED', '10:51 AM', '2020-08-06', 'EMERGENCY FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('394', '244', '57', 'APPLIED', '08:52 AM', '2020-08-10', 'FAMILY\'S MATTER ', null, null);
INSERT INTO `history` VALUES ('395', '245', '55', 'APPLIED', '11:08 AM', '2020-08-17', 'TONSILLITIS AND SEVERE HEADACHE', null, null);
INSERT INTO `history` VALUES ('396', '246', '55', 'APPLIED', '11:09 AM', '2020-08-17', 'TONSILLITIS AND SEVERE HEADACHE', null, null);
INSERT INTO `history` VALUES ('397', '247', '64', 'APPLIED', '14:52 PM', '2020-08-17', 'HOSPITAL APPOINTMENT ', null, null);
INSERT INTO `history` VALUES ('398', '248', '70', 'APPLIED', '09:48 AM', '2020-08-18', 'CAR SERVICE ', null, null);
INSERT INTO `history` VALUES ('399', '248', '18', 'APPROVED', '11:00 AM', '2020-08-18', '', null, null);
INSERT INTO `history` VALUES ('400', '249', '56', 'APPLIED', '11:34 AM', '2020-08-24', 'INTERVIEW IN MORNING AND CAR SERVICE IN AFTERNOON.', null, null);
INSERT INTO `history` VALUES ('401', '250', '71', 'APPLIED', '14:18 PM', '2020-08-28', 'HAVE TO RESCHEDULE BACK MY FLIGHT BACK TO UNIVERSITY TO GET IMPORTANT BELONGINGS I NEED NEXT MONTH AS MY FLIGHT ON 5TH-10TH AUGUST WAS CANCELLED BY AIR ASIA', null, null);
INSERT INTO `history` VALUES ('402', '251', '70', 'APPLIED', '11:37 AM', '2020-09-03', 'SICK ', null, null);
INSERT INTO `history` VALUES ('403', '251', '18', 'APPROVED', '12:07 PM', '2020-09-03', '', null, null);
INSERT INTO `history` VALUES ('404', '252', '55', 'APPLIED', '17:15 PM', '2020-09-04', 'SEVERE HEADACHE', null, null);
INSERT INTO `history` VALUES ('405', '253', '72', 'APPLIED', '12:08 PM', '2020-09-14', 'HAD TO GO THROUGH QUARANTINED FOR THREE DAYS AFTER LANDING AT SARAWAK', null, null);
INSERT INTO `history` VALUES ('406', '254', '55', 'APPLIED', '10:46 AM', '2020-09-15', 'CAR BROKE', null, null);
INSERT INTO `history` VALUES ('407', '255', '56', 'APPLIED', '16:36 PM', '2020-09-17', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('408', '256', '55', 'APPLIED', '09:17 AM', '2020-09-18', 'EMERGENCY FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('409', '257', '72', 'APPLIED', '08:58 AM', '2020-09-21', 'MUET SPEAKING EXAM FOR SESSSION 2 STUDENTS ON 11.AM AT SMK WIRA PENRISSEN', null, null);
INSERT INTO `history` VALUES ('410', '258', '75', 'APPLIED', '16:50 PM', '2020-09-24', 'FIX CARS BREAK(CHANGE BREAK MASTER PUMP AND CARS WHEEL PUMP), PAY ROADTAX, OPEN BANK ACCOUNT.', null, null);
INSERT INTO `history` VALUES ('411', '259', '75', 'APPLIED', '09:39 AM', '2020-10-08', 'PERSONAL ISSUE', null, null);
INSERT INTO `history` VALUES ('412', '259', '75', 'WITHDRAWN', '16:24 PM', '2020-10-08', null, null, null);
INSERT INTO `history` VALUES ('413', '260', '44', 'APPLIED', '21:26 PM', '2020-10-08', 'FAMILY BUSINESS', null, null);
INSERT INTO `history` VALUES ('414', '261', '75', 'APPLIED', '11:32 AM', '2020-10-09', 'PERSONAL ISSUE, AND ALSO NEED TO SETTLE FAMILY STUFF.', null, null);
INSERT INTO `history` VALUES ('415', '261', '75', 'WITHDRAWN', '17:25 PM', '2020-10-09', null, null, null);
INSERT INTO `history` VALUES ('416', '262', '75', 'APPLIED', '17:25 PM', '2020-10-09', 'PERSONAL ISSUE AND FAMILY ISSUE', null, null);
INSERT INTO `history` VALUES ('417', '263', '72', 'APPLIED', '09:06 AM', '2020-10-20', 'I\'M FEELING A LITTLE BIT OF HIGH FEVER TODAY ', null, null);
INSERT INTO `history` VALUES ('418', '264', '49', 'APPLIED', '10:12 AM', '2020-11-11', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('419', '264', '18', 'APPROVED', '10:26 AM', '2020-11-11', '', null, null);
INSERT INTO `history` VALUES ('420', '265', '47', 'APPLIED', '08:48 AM', '2020-11-19', 'FAMILY MATTER/ISSUE', null, null);
INSERT INTO `history` VALUES ('421', '266', '32', 'APPLIED', '08:50 AM', '2020-11-19', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('422', '265', '18', 'APPROVED', '10:31 AM', '2020-11-19', '', null, null);
INSERT INTO `history` VALUES ('423', '266', '18', 'APPROVED', '10:32 AM', '2020-11-19', '', null, null);
INSERT INTO `history` VALUES ('424', '267', '44', 'APPLIED', '10:54 AM', '2020-11-24', 'FAMILY GATHERING', null, null);
INSERT INTO `history` VALUES ('425', '267', '18', 'APPROVED', '11:13 AM', '2020-11-24', '', null, null);
INSERT INTO `history` VALUES ('426', '268', '70', 'APPLIED', '10:00 AM', '2020-12-01', 'FAMILY MATTERS. ', null, null);
INSERT INTO `history` VALUES ('427', '268', '18', 'APPROVED', '10:06 AM', '2020-12-01', '', null, null);
INSERT INTO `history` VALUES ('428', '269', '68', 'APPLIED', '07:32 AM', '2020-12-23', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('429', '270', '67', 'APPLIED', '07:34 AM', '2020-12-23', 'FAMILY MATTERS', null, null);
INSERT INTO `history` VALUES ('430', '271', '47', 'APPLIED', '19:47 PM', '2021-01-13', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('431', '272', '44', 'APPLIED', '13:21 PM', '2021-01-14', 'ERRANDS', null, null);
INSERT INTO `history` VALUES ('432', '273', '44', 'APPLIED', '13:22 PM', '2021-01-14', 'ERRAND', null, null);
INSERT INTO `history` VALUES ('433', '274', '49', 'APPLIED', '09:29 AM', '2021-01-25', 'URUS PAYMENT PTPTN WITH BANK', null, null);
INSERT INTO `history` VALUES ('434', '275', '47', 'APPLIED', '09:29 AM', '2021-01-25', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('435', '276', '70', 'APPLIED', '11:12 AM', '2021-02-08', 'CNY', null, null);
INSERT INTO `history` VALUES ('436', '277', '32', 'APPLIED', '15:08 PM', '2021-02-11', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('437', '278', '44', 'APPLIED', '20:13 PM', '2021-02-15', 'UNIVERSITY ERRANDS', null, null);
INSERT INTO `history` VALUES ('438', '277', '18', 'APPROVED', '09:48 AM', '2021-02-16', 'OK', null, null);
INSERT INTO `history` VALUES ('439', '278', '18', 'APPROVED', '11:33 AM', '2021-02-16', '', null, null);
INSERT INTO `history` VALUES ('440', '279', '68', 'APPLIED', '13:02 PM', '2021-02-19', 'EMERGENCY FLOOD', null, null);
INSERT INTO `history` VALUES ('441', '280', '67', 'APPLIED', '10:58 AM', '2021-02-21', 'ATTEND TO PERSONAL MATTERS', null, null);
INSERT INTO `history` VALUES ('442', '280', '67', 'WITHDRAWN', '10:59 AM', '2021-02-21', null, null, null);
INSERT INTO `history` VALUES ('443', '281', '67', 'APPLIED', '11:00 AM', '2021-02-21', 'ATTEND TO PERSONAL MATTERS', null, null);
INSERT INTO `history` VALUES ('444', '282', '68', 'APPLIED', '14:49 PM', '2021-02-21', 'PERSONAL ISSUE', null, null);
INSERT INTO `history` VALUES ('445', '283', '67', 'APPLIED', '16:32 PM', '2021-02-21', 'ATTENDING PERSONAL MATTERS', null, null);
INSERT INTO `history` VALUES ('446', '284', '55', 'APPLIED', '10:45 AM', '2021-03-01', 'ATTENDING CONVOCATION/GRADUATION', null, null);
INSERT INTO `history` VALUES ('447', '285', '55', 'APPLIED', '08:49 AM', '2021-03-03', 'ATTENDING CONVOCATION/GRADUATION', null, null);
INSERT INTO `history` VALUES ('448', '286', '49', 'APPLIED', '16:30 PM', '2021-03-05', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('449', '287', '47', 'APPLIED', '16:31 PM', '2021-03-05', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('450', '284', '55', 'PENDING WITHDRAWAL', '09:51 AM', '2021-03-09', 'RECEIVING TRANSCRIPT IS POSTPONED TO ANOTHER DATE', null, null);
INSERT INTO `history` VALUES ('451', '288', '70', 'APPLIED', '11:28 AM', '2021-03-09', 'PERSONAL MATTER. ', null, null);
INSERT INTO `history` VALUES ('452', '289', '68', 'APPLIED', '13:35 PM', '2021-03-11', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('453', '290', '67', 'APPLIED', '13:39 PM', '2021-03-11', 'ATTEND TO PERSONAL MATTERS', null, null);
INSERT INTO `history` VALUES ('454', '291', '68', 'APPLIED', '20:51 PM', '2021-03-16', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('455', '292', '67', 'APPLIED', '08:34 AM', '2021-03-19', 'MEDICAL APPOINTMENT AND RENEW LICENSE', null, null);
INSERT INTO `history` VALUES ('456', '293', '68', 'APPLIED', '08:36 AM', '2021-03-19', 'RENEW DRIVING LICENSE AND GO PTPTN', null, null);
INSERT INTO `history` VALUES ('457', '294', '70', 'APPLIED', '16:19 PM', '2021-03-22', 'CAR SERVICE APPOINTMENT ', null, null);
INSERT INTO `history` VALUES ('458', '295', '68', 'APPLIED', '14:16 PM', '2021-03-23', 'ATTEND TO PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('459', '296', '67', 'APPLIED', '14:18 PM', '2021-03-23', 'ATTEND TO PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('460', '297', '55', 'APPLIED', '10:10 AM', '2021-03-30', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('461', '298', '32', 'APPLIED', '07:49 AM', '2021-03-31', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('462', '299', '70', 'APPLIED', '17:18 PM', '2021-04-13', 'PERSONAL  BUSINESS. ', null, null);
INSERT INTO `history` VALUES ('463', '299', '70', 'WITHDRAWN', '09:30 AM', '2021-04-15', null, null, null);
INSERT INTO `history` VALUES ('464', '300', '70', 'APPLIED', '09:30 AM', '2021-04-15', 'FAMILY MATTER ', null, null);
INSERT INTO `history` VALUES ('465', '300', '18', 'APPROVED', '09:32 AM', '2021-04-15', 'OK', null, null);
INSERT INTO `history` VALUES ('466', '301', '78', 'APPLIED', '10:54 AM', '2021-04-20', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('467', '302', '49', 'APPLIED', '09:04 AM', '2021-05-03', 'RAYA', null, null);
INSERT INTO `history` VALUES ('468', '303', '78', 'APPLIED', '09:19 AM', '2021-05-03', 'CUTI RAYA', null, null);
INSERT INTO `history` VALUES ('469', '304', '32', 'APPLIED', '09:22 AM', '2021-05-03', 'RAYA', null, null);
INSERT INTO `history` VALUES ('470', '305', '47', 'APPLIED', '09:22 AM', '2021-05-03', 'RAYA', null, null);
INSERT INTO `history` VALUES ('471', '306', '78', 'APPLIED', '09:27 AM', '2021-05-07', 'CUTI RAYA ', null, null);
INSERT INTO `history` VALUES ('472', '307', '53', 'APPLIED', '10:53 AM', '2021-05-10', 'RAYA', null, null);
INSERT INTO `history` VALUES ('473', '308', '84', 'APPLIED', '15:08 PM', '2021-05-24', 'CUTI GAWAI', null, null);
INSERT INTO `history` VALUES ('474', '309', '32', 'APPLIED', '15:54 PM', '2021-06-10', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('475', '310', '47', 'APPLIED', '15:56 PM', '2021-06-10', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('476', '311', '32', 'APPLIED', '07:18 AM', '2021-06-17', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('477', '312', '47', 'APPLIED', '07:20 AM', '2021-06-17', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('478', '313', '79', 'APPLIED', '07:22 AM', '2021-06-17', 'SICK', null, null);
INSERT INTO `history` VALUES ('479', '314', '79', 'APPLIED', '08:04 AM', '2021-06-21', 'SICK', null, null);
INSERT INTO `history` VALUES ('480', '315', '70', 'APPLIED', '09:56 AM', '2021-06-21', 'EMERGENCY CAR SERVICE ', null, null);
INSERT INTO `history` VALUES ('481', '316', '47', 'APPLIED', '16:22 PM', '2021-06-23', 'PERSONAL MATTER \r\n', null, null);
INSERT INTO `history` VALUES ('482', '317', '70', 'APPLIED', '13:47 PM', '2021-07-01', 'CAR SERVICE ', null, null);
INSERT INTO `history` VALUES ('483', '318', '78', 'APPLIED', '09:56 AM', '2021-07-05', 'VAKSIN', null, null);
INSERT INTO `history` VALUES ('484', '319', '70', 'APPLIED', '11:29 AM', '2021-07-12', 'VACCINATION DOSE 1 ', null, null);
INSERT INTO `history` VALUES ('485', '320', '49', 'APPLIED', '12:50 PM', '2021-07-12', 'MENGURUS FILE2 AKAD NIKAH DI JABATAN AGAMA ISLAM SAAWAK.', null, null);
INSERT INTO `history` VALUES ('486', '320', '18', 'APPROVED', '12:55 PM', '2021-07-12', '', null, null);
INSERT INTO `history` VALUES ('487', '321', '79', 'APPLIED', '13:47 PM', '2021-07-12', 'PERSONAL ISSUES', null, null);
INSERT INTO `history` VALUES ('488', '321', '79', 'WITHDRAWN', '09:05 AM', '2021-07-13', null, null, null);
INSERT INTO `history` VALUES ('489', '322', '32', 'APPLIED', '08:59 AM', '2021-07-19', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('490', '323', '79', 'APPLIED', '09:00 AM', '2021-07-26', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('491', '324', '55', 'APPLIED', '08:54 AM', '2021-07-30', 'GOING FOR VACCINATION - 2ND DOSE', null, null);
INSERT INTO `history` VALUES ('492', '325', '70', 'APPLIED', '08:35 AM', '2021-08-02', 'VACCINE 2ND DOSE', null, null);
INSERT INTO `history` VALUES ('493', '326', '49', 'APPLIED', '17:22 PM', '2021-08-04', 'APPOINTMENT JABATAN AGAMA ISLAM', null, null);
INSERT INTO `history` VALUES ('494', '327', '32', 'APPLIED', '07:55 AM', '2021-08-09', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('495', '328', '47', 'APPLIED', '08:33 AM', '2021-08-12', 'SEND MY FATHER TO VACCINATION', null, null);
INSERT INTO `history` VALUES ('496', '329', '87', 'APPLIED', '09:52 AM', '2021-08-17', 'TO SETTLE DOWN IMPORTANT THINGS.', null, null);
INSERT INTO `history` VALUES ('497', '330', '32', 'APPLIED', '10:45 AM', '2021-08-18', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('498', '331', '47', 'APPLIED', '10:45 AM', '2021-08-18', 'SEND MY MOTHER FOR VACCINATION ', null, null);
INSERT INTO `history` VALUES ('499', '332', '32', 'APPLIED', '22:42 PM', '2021-09-09', '-', null, null);
INSERT INTO `history` VALUES ('500', '333', '47', 'APPLIED', '03:28 AM', '2021-09-10', 'SICK', null, null);
INSERT INTO `history` VALUES ('501', '334', '49', 'APPLIED', '04:43 AM', '2021-09-15', 'GOING TO HOSPITAL WITH MOTHER', null, null);
INSERT INTO `history` VALUES ('502', '335', '79', 'APPLIED', '07:01 AM', '2021-09-15', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('503', '336', '86', 'APPLIED', '16:44 PM', '2021-09-24', 'STOMACHACHE FROM BAD FOOD.', null, null);
INSERT INTO `history` VALUES ('504', '337', '47', 'APPLIED', '07:20 AM', '2021-10-05', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('505', '338', '32', 'APPLIED', '07:45 AM', '2021-10-05', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('506', '339', '79', 'APPLIED', '17:05 PM', '2021-10-05', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('507', '340', '32', 'APPLIED', '10:34 AM', '2021-10-12', 'CAR SERVICE', null, null);
INSERT INTO `history` VALUES ('508', '341', '32', 'APPLIED', '16:43 PM', '2021-10-19', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('509', '342', '47', 'APPLIED', '19:33 PM', '2021-10-19', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('510', '343', '49', 'APPLIED', '18:27 PM', '2021-10-24', 'TAKLIMAT PPM, KPDP & PAPM (SPRM)', null, null);
INSERT INTO `history` VALUES ('511', '344', '32', 'APPLIED', '15:34 PM', '2021-10-26', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('512', '345', '47', 'APPLIED', '15:36 PM', '2021-10-26', 'EMERGENCY/FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('513', '346', '49', 'APPLIED', '05:08 AM', '2021-10-29', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('514', '347', '70', 'APPLIED', '11:23 AM', '2021-11-02', 'CAR SERVICES AND FAMILY MATTER . ', null, null);
INSERT INTO `history` VALUES ('515', '348', '70', 'APPLIED', '11:31 AM', '2021-11-02', 'SWAB TEST ', null, null);
INSERT INTO `history` VALUES ('516', '349', '49', 'APPLIED', '21:37 PM', '2021-11-03', 'GO TO CLINIC', null, null);
INSERT INTO `history` VALUES ('517', '350', '86', 'APPLIED', '10:31 AM', '2021-11-05', 'ATTENDING MY AUNT\'S FUNERAL SERVICE', null, null);
INSERT INTO `history` VALUES ('518', '351', '79', 'APPLIED', '11:01 AM', '2021-11-08', 'PERSONAL MATTER ', null, null);
INSERT INTO `history` VALUES ('519', '352', '79', 'APPLIED', '08:29 AM', '2021-11-15', 'SICK', null, null);
INSERT INTO `history` VALUES ('520', '353', '47', 'APPLIED', '08:34 AM', '2021-11-17', 'KURSUS KAHWIN', null, null);
INSERT INTO `history` VALUES ('521', '354', '70', 'APPLIED', '11:24 AM', '2021-11-23', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('522', '355', '79', 'APPLIED', '09:30 AM', '2021-11-25', 'SICK', null, null);
INSERT INTO `history` VALUES ('523', '356', '49', 'APPLIED', '10:14 AM', '2021-12-10', 'EMERGENCY FAMILY MATTER IN HOMETOWN', null, null);
INSERT INTO `history` VALUES ('524', '357', '32', 'APPLIED', '08:29 AM', '2021-12-13', 'BOOSTER SHOT & PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('525', '358', '47', 'APPLIED', '08:36 AM', '2021-12-13', 'BOOSTER SHOT  AND GOT APPOINMENT AT MAJLIS ISLAM SARAWAK', null, null);
INSERT INTO `history` VALUES ('526', '359', '66', 'APPLIED', '08:53 AM', '2021-12-14', 'TAKING BOOSTER VACCINATION', null, null);
INSERT INTO `history` VALUES ('527', '359', '18', 'APPROVED', '09:13 AM', '2021-12-14', 'OK..TAKE CARE', null, null);
INSERT INTO `history` VALUES ('528', '360', '47', 'APPLIED', '08:13 AM', '2021-12-24', 'APPOINTMENT AT MAJLIS ISLAM SARAWAK', null, null);
INSERT INTO `history` VALUES ('529', '361', '49', 'APPLIED', '14:45 PM', '2021-12-24', 'KWSP AND HOUSE LOAN APPOINTMENT WITH BANK', null, null);
INSERT INTO `history` VALUES ('530', '362', '70', 'APPLIED', '14:06 PM', '2021-12-28', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('531', '363', '47', 'APPLIED', '12:24 PM', '2021-12-29', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('532', '364', '79', 'APPLIED', '07:50 AM', '2021-12-30', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('533', '365', '32', 'APPLIED', '07:24 AM', '2022-01-03', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('534', '366', '47', 'APPLIED', '09:06 AM', '2022-01-03', 'SEND FATHER TO VACCINATION', null, null);
INSERT INTO `history` VALUES ('535', '367', '70', 'APPLIED', '10:25 AM', '2022-01-05', 'FAMILY MATTER ', null, null);
INSERT INTO `history` VALUES ('536', '368', '79', 'APPLIED', '17:05 PM', '2022-01-06', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('537', '369', '86', 'APPLIED', '08:55 AM', '2022-01-10', 'WILLL NOT BE IN KUCHING', null, null);
INSERT INTO `history` VALUES ('538', '370', '81', 'APPLIED', '20:15 PM', '2022-01-10', '-ATTENDS BOOSTER DOSE APPOINTMENT AND DO EPF ACCOUNT', null, null);
INSERT INTO `history` VALUES ('539', '371', '66', 'APPLIED', '12:21 PM', '2022-01-14', 'GO BACK SIBU', null, null);
INSERT INTO `history` VALUES ('540', '371', '18', 'APPROVED', '13:02 PM', '2022-01-14', '', null, null);
INSERT INTO `history` VALUES ('541', '372', '81', 'APPLIED', '20:11 PM', '2022-01-20', 'BACK TO HOMETOWN ', null, null);
INSERT INTO `history` VALUES ('542', '373', '79', 'APPLIED', '08:50 AM', '2022-01-21', 'CHINESE NEW YEAR', null, null);
INSERT INTO `history` VALUES ('543', '369', '86', 'WITHDRAWN', '11:54 AM', '2022-01-26', null, null, null);
INSERT INTO `history` VALUES ('544', '374', '86', 'APPLIED', '11:55 AM', '2022-01-26', 'NOT IN KUCHING', null, null);
INSERT INTO `history` VALUES ('545', '375', '66', 'APPLIED', '14:14 PM', '2022-01-26', 'CNY - GO BACK HOMETOWN', null, null);
INSERT INTO `history` VALUES ('546', '376', '66', 'APPLIED', '14:15 PM', '2022-01-26', 'GRADUATION DAY UNIMAS', null, null);
INSERT INTO `history` VALUES ('547', '377', '70', 'APPLIED', '15:31 PM', '2022-01-27', 'CNY ', null, null);
INSERT INTO `history` VALUES ('548', '378', '66', 'APPLIED', '08:28 AM', '2022-02-04', 'BACK TO UNIMAS', null, null);
INSERT INTO `history` VALUES ('549', '379', '47', 'APPLIED', '09:05 AM', '2022-02-07', 'GETTING ENGAGED', null, null);
INSERT INTO `history` VALUES ('550', '380', '81', 'APPLIED', '08:56 AM', '2022-02-11', 'CONVOCATION', null, null);
INSERT INTO `history` VALUES ('551', '381', '32', 'APPLIED', '08:57 AM', '2022-02-11', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('552', '382', '86', 'APPLIED', '16:47 PM', '2022-02-11', 'WILL NOT BE IN KUCHING. NEED TO GO TO MIRI', null, null);
INSERT INTO `history` VALUES ('553', '369', '86', 'PENDING WITHDRAWAL', '16:49 PM', '2022-02-11', 'WRONG APPLICATION', null, null);
INSERT INTO `history` VALUES ('554', '383', '47', 'APPLIED', '10:19 AM', '2022-02-14', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('555', '384', '79', 'APPLIED', '09:32 AM', '2022-02-22', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('556', '385', '49', 'APPLIED', '11:02 AM', '2022-02-23', 'GO TO HOSPITAL WITH MOTHER IN LAW', null, null);
INSERT INTO `history` VALUES ('557', '386', '66', 'APPLIED', '09:12 AM', '2022-03-01', 'PERSONAL MATTER ', null, null);
INSERT INTO `history` VALUES ('558', '387', '81', 'APPLIED', '15:16 PM', '2022-03-04', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('559', '388', '66', 'APPLIED', '15:19 PM', '2022-03-04', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('560', '389', '47', 'APPLIED', '16:20 PM', '2022-03-04', 'FAMLIY MATTER', null, null);
INSERT INTO `history` VALUES ('561', '390', '70', 'APPLIED', '08:52 AM', '2022-03-18', 'BROTHER\'S GRADUATION ', null, null);
INSERT INTO `history` VALUES ('562', '390', '70', 'WITHDRAWN', '08:27 AM', '2022-03-24', null, null, null);
INSERT INTO `history` VALUES ('563', '391', '70', 'APPLIED', '13:18 PM', '2022-03-24', 'PERSONAL MATTER \r\n', null, null);
INSERT INTO `history` VALUES ('564', '392', '49', 'APPLIED', '20:41 PM', '2022-03-27', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('565', '391', '70', 'WITHDRAWN', '09:11 AM', '2022-03-28', null, null, null);
INSERT INTO `history` VALUES ('566', '393', '70', 'APPLIED', '15:34 PM', '2022-03-31', 'FAMILY MATTER', null, null);
INSERT INTO `history` VALUES ('567', '394', '32', 'APPLIED', '07:52 AM', '2022-04-04', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('568', '395', '49', 'APPLIED', '08:38 AM', '2022-04-04', 'FLIGHT BACK HOME LIMBANG', null, null);
INSERT INTO `history` VALUES ('569', '396', '32', 'APPLIED', '06:49 AM', '2022-04-06', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('570', '397', '47', 'APPLIED', '19:41 PM', '2022-04-07', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('571', '398', '32', 'APPLIED', '07:46 AM', '2022-04-10', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('572', '399', '47', 'APPLIED', '10:55 AM', '2022-04-12', 'SEND MOTHER TO CLINIC APPOINTMENT', null, null);
INSERT INTO `history` VALUES ('573', '400', '47', 'APPLIED', '09:00 AM', '2022-04-21', 'GOING BACK TO HOMETOWN FOR RAYA', null, null);
INSERT INTO `history` VALUES ('574', '401', '32', 'APPLIED', '10:45 AM', '2022-04-21', 'BALIK KAMPUNG FOR RAYA', null, null);
INSERT INTO `history` VALUES ('575', '402', '86', 'APPLIED', '11:28 AM', '2022-04-21', 'GOING TO JOHOR FOR SISTER\'S WEDDING.', null, null);
INSERT INTO `history` VALUES ('576', '402', '18', 'APPROVED', '08:19 AM', '2022-04-22', '', null, null);
INSERT INTO `history` VALUES ('577', '403', '32', 'APPLIED', '12:10 PM', '2022-04-26', 'PERSONAL MATTER', null, null);
INSERT INTO `history` VALUES ('578', '404', '47', 'APPLIED', '12:18 PM', '2022-04-26', 'GOING TO BANK', null, null);
INSERT INTO `history` VALUES ('579', '405', '86', 'APPLIED', '08:46 AM', '2022-04-28', 'STILL AT JOHOR FOR SISTER\'S POST WEDDING DINNER', null, null);
INSERT INTO `history` VALUES ('580', '405', '18', 'APPROVED', '09:37 AM', '2022-04-28', '', null, null);
INSERT INTO `history` VALUES ('581', '406', '70', 'APPLIED', '14:36 PM', '2022-05-09', 'PERSONAL MATTER . ', null, null);
INSERT INTO `history` VALUES ('582', '406', '70', 'PENDING WITHDRAWAL', '11:12 AM', '2022-05-11', 'SICK LEAVE ', null, null);
INSERT INTO `history` VALUES ('583', '390', '70', 'PENDING WITHDRAWAL', '11:18 AM', '2022-05-11', 'COVID WFH', null, null);
INSERT INTO `history` VALUES ('584', '407', '70', 'APPLIED', '11:27 AM', '2022-05-11', 'FAMILY MATTER ', null, null);
INSERT INTO `history` VALUES ('585', '408', '66', 'APPLIED', '01:32 AM', '2022-05-28', 'PERSONAL MATTERS', null, null);
INSERT INTO `history` VALUES ('586', '409', '92', 'APPLIED', '11:11 AM', '2022-06-07', 'PERSONAL REASON', null, null);
INSERT INTO `history` VALUES ('587', '410', '92', 'APPLIED', '10:39 AM', '2022-06-17', 'PERSONAL REASON', null, null);
INSERT INTO `history` VALUES ('588', '411', '92', 'APPLIED', '15:20 PM', '2022-08-31', 'PERSONAL REASON', null, null);
INSERT INTO `history` VALUES ('589', '412', '86', 'APPLIED', '11:47 AM', '2022-09-07', 'NEED TO ATTEND A WEDDING', null, null);
INSERT INTO `history` VALUES ('590', '413', '92', 'APPLIED', '11:57 AM', '2022-09-09', 'PERSONAL REASON', null, null);
INSERT INTO `history` VALUES ('591', '414', '86', 'APPLIED', '10:08 AM', '2022-09-19', 'GOING TO PENANG ON THE 6TH OF OCT', null, null);
INSERT INTO `history` VALUES ('592', '369', '86', 'PENDING WITHDRAWAL', '12:40 PM', '2022-10-24', '', null, null);
INSERT INTO `history` VALUES ('593', '415', '86', 'APPLIED', '08:38 AM', '2022-10-27', 'NOT FEELING WELL', null, null);
INSERT INTO `history` VALUES ('594', '416', '86', 'APPLIED', '09:45 AM', '2022-11-17', 'NOT FEELING WELL', null, null);
INSERT INTO `history` VALUES ('595', '417', '86', 'APPLIED', '13:46 PM', '2022-12-14', 'EMERGENCY LEAVE', null, null);
INSERT INTO `history` VALUES ('596', '418', '86', 'APPLIED', '14:51 PM', '2023-02-20', 'WILL NOT BE IN KUCHING. GOING TO KL', null, null);
INSERT INTO `history` VALUES ('597', '418', '18', 'APPROVED', '14:33 PM', '2023-03-02', '', null, 'YES');
INSERT INTO `history` VALUES ('598', '419', '86', 'APPLIED', '16:59 PM', '2023-04-26', 'CLEARING OUT REMAINING LEAVES', null, null);
INSERT INTO `history` VALUES ('599', '420', '100', 'APPLIED', '10:57 AM', '2023-09-18', 'PERSONAL MATTERS', null, null);
INSERT INTO `history` VALUES ('600', '420', '18', 'APPROVED', '10:59 AM', '2023-09-18', '', null, null);
INSERT INTO `history` VALUES ('601', '421', '107', 'APPLIED', '16:55 PM', '2023-12-05', 'GRADUATION CEREMONY', null, null);
INSERT INTO `history` VALUES ('602', '422', '102', 'APPLIED', '17:28 PM', '2023-12-05', 'APPOINTMENT CLINIC', null, null);
INSERT INTO `history` VALUES ('603', '423', '102', 'APPLIED', '08:32 AM', '2023-12-06', 'APPOINTMENT DAUGHTER CLINIC ', null, null);
INSERT INTO `history` VALUES ('604', '423', '18', 'APPROVED', '12:20 PM', '2023-12-06', '', null, null);
INSERT INTO `history` VALUES ('605', '424', '53', 'APPLIED', '14:45 PM', '2023-12-06', 'TEST', null, null);
INSERT INTO `history` VALUES ('606', '425', '53', 'APPLIED', '14:50 PM', '2023-12-06', 'TEST', null, null);
INSERT INTO `history` VALUES ('607', '426', '53', 'APPLIED', '15:21 PM', '2023-12-06', 'TEST3', null, null);
INSERT INTO `history` VALUES ('608', '427', '53', 'APPLIED', '15:31 PM', '2023-12-06', 'TEST 3', null, null);
INSERT INTO `history` VALUES ('609', '427', '18', 'REJECTED', '15:47 PM', '2023-12-06', 'TEST 3 HEHE', null, null);
INSERT INTO `history` VALUES ('610', '426', '18', 'REJECTED', '15:48 PM', '2023-12-06', 'TEST333', null, null);
INSERT INTO `history` VALUES ('611', '425', '18', 'REJECTED', '15:50 PM', '2023-12-06', 'TESTING', null, null);
INSERT INTO `history` VALUES ('612', '', '108', 'APPLIED', '17:38 PM', '2023-12-07', '', null, null);
INSERT INTO `history` VALUES ('613', '', '108', 'APPLIED', '17:43 PM', '2023-12-07', 'TESTING', null, null);
INSERT INTO `history` VALUES ('614', '430', '108', 'APPLIED', '17:45 PM', '2023-12-07', 'TESTING', null, null);
INSERT INTO `history` VALUES ('615', '430', '18', 'REJECTED', '09:18 AM', '2023-12-08', '', null, null);
INSERT INTO `history` VALUES ('616', '429', '108', 'WITHDRAWN', '09:57 AM', '2023-12-08', null, null, null);
INSERT INTO `history` VALUES ('617', '431', '108', 'APPLIED', '11:56 AM', '2023-12-11', 'TESTING GMAIL 2', null, null);
INSERT INTO `history` VALUES ('618', '432', '108', 'APPLIED', '12:01 PM', '2023-12-11', 'TESTING GMAIL 3', null, null);
INSERT INTO `history` VALUES ('619', '433', '108', 'APPLIED', '12:03 PM', '2023-12-11', 'TESING GMAIL 1', null, null);
INSERT INTO `history` VALUES ('620', '434', '108', 'APPLIED', '12:05 PM', '2023-12-11', 'TESTING GMAIL 2', null, null);
INSERT INTO `history` VALUES ('621', '435', '108', 'APPLIED', '13:17 PM', '2023-12-11', 'TESTING GMAIL 3', null, null);
INSERT INTO `history` VALUES ('622', '436', '108', 'APPLIED', '13:18 PM', '2023-12-11', 'TESTING GMAIL 4', null, null);
INSERT INTO `history` VALUES ('623', '437', '108', 'APPLIED', '13:29 PM', '2023-12-11', 'TESTING GMAIL 5', null, null);
INSERT INTO `history` VALUES ('624', '438', '108', 'APPLIED', '13:30 PM', '2023-12-11', 'TESTING GMAIL 6', null, null);
INSERT INTO `history` VALUES ('625', '439', '102', 'APPLIED', '14:29 PM', '2023-12-11', 'CLINIC', null, null);
INSERT INTO `history` VALUES ('626', '440', '108', 'APPLIED', '15:27 PM', '2023-12-11', 'TESTING GMAIL WITH ATTACHMENT', null, null);
INSERT INTO `history` VALUES ('627', '441', '108', 'APPLIED', '15:29 PM', '2023-12-11', 'TESTING GMAIL WITH PICTURE', null, null);
INSERT INTO `history` VALUES ('628', '433', '18', 'REJECTED', '15:39 PM', '2023-12-11', 'TESTING GMAIL', null, null);
INSERT INTO `history` VALUES ('629', '434', '18', 'REJECTED', '15:43 PM', '2023-12-11', 'TESTING GMAIL 2', null, null);
INSERT INTO `history` VALUES ('630', '435', '18', 'REJECTED', '15:55 PM', '2023-12-11', 'TESTING GMAIL 3', null, null);
INSERT INTO `history` VALUES ('631', '439', '18', 'REJECTED', '16:13 PM', '2023-12-11', '', null, null);
INSERT INTO `history` VALUES ('632', '442', '102', 'APPLIED', '16:17 PM', '2023-12-11', 'HOS', null, null);
INSERT INTO `history` VALUES ('633', '442', '18', 'APPROVED', '16:37 PM', '2023-12-11', '', null, null);
INSERT INTO `history` VALUES ('634', '422', '18', 'APPROVED', '16:20 PM', '2023-12-13', '', null, null);
INSERT INTO `history` VALUES ('635', '448', '85', 'APPLIED', '15:05 PM', '2023-12-14', 'TESTING', null, null);
INSERT INTO `history` VALUES ('636', '448', '18', 'REJECTED', '15:09 PM', '2023-12-14', 'TESTING', null, null);
INSERT INTO `history` VALUES ('637', '449', '85', 'APPLIED', '15:14 PM', '2023-12-14', 'TESTING', null, null);
INSERT INTO `history` VALUES ('638', '449', '18', 'APPROVED', '10:19 AM', '2023-12-15', '', null, null);
INSERT INTO `history` VALUES ('639', '450', '85', 'APPLIED', '11:51 AM', '2023-12-15', 'TESTING', null, null);
INSERT INTO `history` VALUES ('640', '451', '100', 'APPLIED', '16:51 PM', '2023-12-15', 'PERSONAL MATTERS', null, null);
INSERT INTO `history` VALUES ('641', '452', '108', 'APPLIED', '15:54 PM', '2023-12-18', 'CHRISTMAS CELEBRATION & FLY BACK TO KUCHING', null, null);
INSERT INTO `history` VALUES ('642', '453', '102', 'APPLIED', '08:53 AM', '2024-01-02', 'APPOINTMENT CLINIC', null, null);
INSERT INTO `history` VALUES ('643', '454', '102', 'APPLIED', '08:55 AM', '2024-01-02', 'APPOINTMENT DAUGHTER CLINIC', null, null);
INSERT INTO `history` VALUES ('644', '455', '107', 'APPLIED', '16:39 PM', '2024-01-30', 'CHINESE NEW YEAR', null, null);
INSERT INTO `history` VALUES ('645', '456', '101', 'APPLIED', '16:53 PM', '2024-01-30', 'TAKE ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('646', '457', '109', 'APPLIED', '16:53 PM', '2024-01-30', 'UNIVERSITY DEAN\'S LIST CEREMONY', null, null);
INSERT INTO `history` VALUES ('647', '458', '101', 'APPLIED', '16:54 PM', '2024-01-30', 'TAKE ANNUAL LEAVE', null, null);
INSERT INTO `history` VALUES ('648', '459', '100', 'APPLIED', '11:12 AM', '2024-02-05', 'CNY LEAVE', null, null);
INSERT INTO `history` VALUES ('649', '460', '102', 'APPLIED', '10:04 AM', '2024-02-16', 'APPOINTMENT CLINIC ', null, null);
INSERT INTO `history` VALUES ('650', '461', '104', 'APPLIED', '17:10 PM', '2024-03-14', 'ANNUAL_LEAVE', null, null);
INSERT INTO `history` VALUES ('651', '462', '111', 'APPLIED', '11:46 AM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('652', '462', '18', 'APPROVED', '11:47 AM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('653', '463', '111', 'APPLIED', '12:09 PM', '2024-03-18', 'TEST TEST', null, null);
INSERT INTO `history` VALUES ('654', '463', '18', 'REJECTED', '14:01 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('655', '464', '111', 'APPLIED', '14:02 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('656', '465', '111', 'APPLIED', '14:04 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('657', '464', '18', 'REJECTED', '14:05 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('658', '465', '18', 'REJECTED', '14:05 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('659', '466', '111', 'APPLIED', '14:06 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('660', '467', '111', 'APPLIED', '14:12 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('661', '468', '111', 'APPLIED', '14:20 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('662', '469', '111', 'APPLIED', '14:30 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('663', '466', '18', 'REJECTED', '14:30 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('664', '467', '18', 'REJECTED', '14:31 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('665', '469', '18', 'REJECTED', '14:31 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('666', '468', '18', 'REJECTED', '14:31 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('667', '470', '111', 'APPLIED', '14:57 PM', '2024-03-18', 'TEST ', null, null);
INSERT INTO `history` VALUES ('668', '471', '111', 'APPLIED', '15:01 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('669', '472', '111', 'APPLIED', '15:04 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('670', '473', '111', 'APPLIED', '15:33 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('671', '474', '111', 'APPLIED', '16:31 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('672', '470', '18', 'REJECTED', '16:34 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('673', '471', '18', 'REJECTED', '16:35 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('674', '472', '18', 'REJECTED', '16:35 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('675', '473', '18', 'REJECTED', '16:35 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('676', '474', '18', 'REJECTED', '16:35 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('677', '475', '111', 'APPLIED', '16:35 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('678', '476', '111', 'APPLIED', '16:37 PM', '2024-03-18', 'POST BDAY TEST', null, null);
INSERT INTO `history` VALUES ('679', '477', '111', 'APPLIED', '16:39 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('680', '478', '111', 'APPLIED', '16:43 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('681', '479', '111', 'APPLIED', '16:45 PM', '2024-03-18', 'TEST', null, null);
INSERT INTO `history` VALUES ('682', '475', '18', 'REJECTED', '16:46 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('683', '476', '18', 'REJECTED', '16:47 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('684', '477', '18', 'REJECTED', '16:47 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('685', '478', '18', 'REJECTED', '16:47 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('686', '479', '18', 'REJECTED', '16:47 PM', '2024-03-18', '', null, null);
INSERT INTO `history` VALUES ('687', '480', '111', 'APPLIED', '16:48 PM', '2024-03-18', 'BIRTHDAY', null, null);
INSERT INTO `history` VALUES ('688', '481', '107', 'APPLIED', '13:05 PM', '2024-03-27', 'BACK TO MIRI', null, null);
INSERT INTO `history` VALUES ('689', '461', '18', 'APPROVED', '14:35 PM', '2024-03-27', '', null, null);
INSERT INTO `history` VALUES ('690', '481', '18', 'APPROVED', '14:36 PM', '2024-03-27', '', null, null);
INSERT INTO `history` VALUES ('691', '482', '112', 'APPLIED', '14:45 PM', '2024-03-27', 'TEST', null, null);
INSERT INTO `history` VALUES ('692', '482', '18', 'REJECTED', '14:47 PM', '2024-03-27', 'TEST', null, null);
INSERT INTO `history` VALUES ('693', '483', '112', 'APPLIED', '14:47 PM', '2024-03-27', 'TEST', null, null);
INSERT INTO `history` VALUES ('694', '484', '112', 'APPLIED', '14:48 PM', '2024-03-27', 'TEST', null, null);
INSERT INTO `history` VALUES ('695', '485', '112', 'APPLIED', '14:49 PM', '2024-03-27', 'TEST', null, null);
INSERT INTO `history` VALUES ('696', '485', '18', 'REJECTED', '14:50 PM', '2024-03-27', 'TEST', null, null);
INSERT INTO `history` VALUES ('697', '486', '112', 'APPLIED', '14:53 PM', '2024-03-27', 'TEST', null, null);
INSERT INTO `history` VALUES ('698', '486', '18', 'REJECTED', '14:57 PM', '2024-03-27', 'TEST', null, null);
INSERT INTO `history` VALUES ('699', '487', '102', 'APPLIED', '11:12 AM', '2024-04-08', 'OBSERVANCE OF HARI RAYA', null, null);

-- ----------------------------
-- Table structure for holiday
-- ----------------------------
CREATE TABLE `holiday` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `date_from` varchar(30) DEFAULT NULL,
  `day_from` varchar(30) DEFAULT NULL,
  `date_to` varchar(30) DEFAULT NULL,
  `day_to` varchar(30) DEFAULT NULL,
  `day` int(11) DEFAULT NULL,
  `remarks` varchar(200) DEFAULT NULL,
  `date_update` varchar(255) DEFAULT NULL,
  `time_update` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of holiday
-- ----------------------------
INSERT INTO `holiday` VALUES ('46', 'NEW YEAR\'S DAY', '2024-01-01', null, '2024-01-01', null, null, '', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('45', 'CHINESE NEW YEAR', '2024-02-10', null, '2024-02-11', null, null, 'CHINESE NEW YEAR HOLIDAY', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('44', 'GOOD FRIDAY ', '2024-03-29', null, '2024-03-29', null, null, '', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('43', 'HARI RAYA AIDILFITRI ', '2024-04-10', null, '2024-04-11', null, null, 'HARI RAYA AIDILFITRI HOLIDAY', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('42', 'LABOUR DAY', '2024-05-01', null, '2024-05-01', null, null, 'LABOUR DAY HOLIDAY', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('41', 'WESAK DAY', '2024-05-22', null, '2024-05-22', null, null, 'WESAK DAY HOLIDAY', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('39', 'HARI GAWAI', '2024-06-01', null, '2024-06-02', null, null, 'HARI GAWAI HOLIDAY', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('40', 'AGONG\'S BIRTHDAY', '2024-06-03', null, '2024-06-03', null, null, ' ', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('37', 'HARI GAWAI HOLIDAY', '2024-06-04', null, '2024-06-04', null, null, 'HARI GAWAI HOLIDAY', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('38', 'HARI RAYA HAJI', '2024-06-17', null, '2024-06-17', null, null, 'HARI RAYA HAJI HOLIDAY', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('36', 'AWAL MUHARRAM', '2024-07-07', null, '2024-07-07', null, null, '', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('35', 'SARAWAK DAY', '2024-07-22', null, '2024-07-22', null, null, '', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('34', 'MERDEKA DAY', '2024-08-31', null, '2024-08-31', null, null, '', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('33', 'PROPHET MUHAMMAD\'S BIRTHDAY', '2024-09-16', null, '2024-09-16', null, null, '', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('32', 'MALAYSIA DAY', '2024-09-16', null, '2024-09-16', null, null, 'MALAYSIA DAY HOLIDAY', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('31', 'SARAWAK GOVERNOR\'S BIRTHDAY ', '2024-10-12', null, '2024-10-12', null, null, '', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('47', 'CHRISTMAS DAY', '2024-12-25', null, '2024-12-25', null, null, '', '2023-12-06', '10:11 AM');
INSERT INTO `holiday` VALUES ('48', 'CHRISTMAS DAY HOLIDAY', '2023-12-25', null, '2023-12-25', null, null, '', '2023-12-06', '10:11 AM');

-- ----------------------------
-- Table structure for increment
-- ----------------------------
CREATE TABLE `increment` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `leave_type` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `default_entitlement` int(255) DEFAULT NULL,
  `morethanyear` int(255) DEFAULT NULL,
  `leave_entitlement` varchar(255) DEFAULT NULL,
  `createdBy_user_id` varchar(255) DEFAULT NULL,
  `date_update` varchar(255) DEFAULT NULL,
  `time_update` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of increment
-- ----------------------------

-- ----------------------------
-- Table structure for isseen
-- ----------------------------
CREATE TABLE `isseen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seen_apply_id` int(11) DEFAULT NULL,
  `seen_approval1_id` int(11) DEFAULT NULL,
  `seen_approval2_id` int(11) DEFAULT NULL,
  `seen_staff_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of isseen
-- ----------------------------

-- ----------------------------
-- Table structure for leave_planner
-- ----------------------------
CREATE TABLE `leave_planner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `sent_date` varchar(255) DEFAULT NULL,
  `leave_type` varchar(255) DEFAULT NULL,
  `days` varchar(255) DEFAULT NULL,
  `days_paid` varchar(255) DEFAULT NULL,
  `days_unpaid` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `document` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of leave_planner
-- ----------------------------
INSERT INTO `leave_planner` VALUES ('1', '81', '2023-01-04', 'ANNUAL', '2', '0', '2', 'VAC', '', 'PENDING');

-- ----------------------------
-- Table structure for leave_setting
-- ----------------------------
CREATE TABLE `leave_setting` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `company_id` int(100) DEFAULT NULL,
  `entitlement` varchar(255) DEFAULT NULL,
  `rounding` varchar(255) DEFAULT NULL,
  `year_start` varchar(255) DEFAULT NULL,
  `carry_forward` varchar(100) DEFAULT NULL,
  `max_carry` int(100) DEFAULT NULL,
  `expired` varchar(100) DEFAULT NULL,
  `half_day` varchar(100) DEFAULT NULL,
  `date_update` varchar(255) DEFAULT NULL,
  `time_update` varchar(255) DEFAULT NULL,
  `expired_carryForward` varchar(255) DEFAULT NULL,
  `start_date` varchar(255) DEFAULT NULL,
  `reset` varchar(100) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `autodeduct` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of leave_setting
-- ----------------------------
INSERT INTO `leave_setting` VALUES ('1', '1', 'ACCRUAL', 'UP', 'JANUARY', 'YES', '3', '12', 'YES', '2020-01-22', '09:50 AM', '2019-01', '2018-01', '', '', 'YES');

-- ----------------------------
-- Table structure for leave_type
-- ----------------------------
CREATE TABLE `leave_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) DEFAULT NULL,
  `lt_type` varchar(25) DEFAULT NULL,
  `lt_type2` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of leave_type
-- ----------------------------

-- ----------------------------
-- Table structure for planner_date
-- ----------------------------
CREATE TABLE `planner_date` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `planner_id` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `paid_unpaid` varchar(255) DEFAULT NULL,
  `option_day` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of planner_date
-- ----------------------------
INSERT INTO `planner_date` VALUES ('1', '1', '2023-01-24', 'UNPAID', 'FULL');
INSERT INTO `planner_date` VALUES ('2', '1', '2023-01-25', 'UNPAID', 'FULL');

-- ----------------------------
-- Table structure for position
-- ----------------------------
CREATE TABLE `position` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `name` varchar(1000) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `remarks` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of position
-- ----------------------------
INSERT INTO `position` VALUES ('1', 'MANAGING DIRECTOR', 'DIRECTING', 'DIRECTOR');
INSERT INTO `position` VALUES ('3', 'PROGRAMMER', 'PROGRAMMING', '');
INSERT INTO `position` VALUES ('4', 'DESIGNER', 'DESIGNING', '');
INSERT INTO `position` VALUES ('5', 'ADMINISTRATOR', 'ADMINISTRATION', '');
INSERT INTO `position` VALUES ('6', 'ACC CUM HR DIRECTOR', 'DIRECTOR', 'DIRECTOR');
INSERT INTO `position` VALUES ('7', 'SALES & MARKETING EXECUTIVE', '', '');
INSERT INTO `position` VALUES ('8', 'HUMAN RESOURCE', '', '');
INSERT INTO `position` VALUES ('9', 'ACCOUNTANT', '', '');
INSERT INTO `position` VALUES ('34', 'MANAGER', '', '');
INSERT INTO `position` VALUES ('35', 'TECHNICIAN', '', '');

-- ----------------------------
-- Table structure for replacement
-- ----------------------------
CREATE TABLE `replacement` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id` int(255) DEFAULT NULL,
  `days` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `document` varchar(255) DEFAULT NULL,
  `createdBy_user_id` int(255) DEFAULT NULL,
  `sent_date` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of replacement
-- ----------------------------

-- ----------------------------
-- Table structure for replacement_date
-- ----------------------------
CREATE TABLE `replacement_date` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `replacement_leave_id` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of replacement_date
-- ----------------------------

-- ----------------------------
-- Table structure for rounding
-- ----------------------------
CREATE TABLE `rounding` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `down` int(11) DEFAULT NULL,
  `near` int(11) DEFAULT NULL,
  `full` int(11) DEFAULT NULL,
  `half` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of rounding
-- ----------------------------

-- ----------------------------
-- Table structure for salut
-- ----------------------------
CREATE TABLE `salut` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `salut_type` varchar(20) DEFAULT NULL,
  `salut_gender` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of salut
-- ----------------------------

-- ----------------------------
-- Table structure for user
-- ----------------------------
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` varchar(100) DEFAULT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  `ic_no` varchar(255) DEFAULT NULL,
  `dob` varchar(255) DEFAULT NULL,
  `contact_no` varchar(255) DEFAULT NULL,
  `marital_status` varchar(255) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `salut` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '', 'admin', '', '', '', '', '', '', '', null);
INSERT INTO `user` VALUES ('18', '', 'RAYMOND HO', '830416135797', '1983-04-16', '', 'MARRIED', 'MALE', 'MR', 'FIRST FLOOR, LOT 182, SECTION 51, KTLD , JALAN SONG THIAN CHEOK', 'raymond@softworld.com.my');
INSERT INTO `user` VALUES ('53', '', 'MOHAMMAD FADZILLAH BIN BUJANG', '880321525499', '1988-03-21', '0138200094', 'MARRIED', 'MALE', 'MR', 'KCH SWK', 'f4213@yahoo.com');
INSERT INTO `user` VALUES ('66', '', 'ALICE TANG SU WEI', '971114135846', '1997-11-14', '', 'SINGLE', 'FEMALE', 'MISS', '', 'alicetsw11@gmail.com');
INSERT INTO `user` VALUES ('85', '22', 'TEST ACCOUNT', '11111', '1993-11-03', '0142883390', 'SINGLE', 'MALE', 'MR', '112, GREEN HEIGHTS, LORONG LAPANGAN TERBANG 4, 93250 KUCHING, SARAWAK', 'mansonkho@yahoo.com');
INSERT INTO `user` VALUES ('86', '', 'FAUSTINO NG YEN CHIUN', '940215135317', '1994-02-15', '0168941530', 'SINGLE', 'MALE', 'MR', '8A LORONG 17C, JALAN KAPOR, 93150 KUCHING SARAWAK.', 'faustino_ng@hotmail.com');
INSERT INTO `user` VALUES ('100', 'SW0002', 'RAYMOND LAI KIAT FUNG', '001221131341', '2000-12-21', '014392 5075', 'SINGLE', 'MALE', 'MR', 'NO 156, \r\nTAMAN EMAS, \r\nBATU 9, JALAN PENRISSEN\r\n93250 KUCHING, SARAWAK.', 'raymond.lai@softworld.com.my');
INSERT INTO `user` VALUES ('101', 'SW003', 'BANABAS LAU SIE LUNG', '920622135359', '1992-06-22', '018276 8937', 'SINGLE', 'MALE', 'MR', '121F, BLOK LINGGA, FLAT KMC, \r\nJALAN BAN HOCK, \r\n93100 KUCHING, SARAWAK.', 'banabas.lau@softworld.com.my');
INSERT INTO `user` VALUES ('102', '19', 'JULIANA BINTI JUNIDI', '981021135504', '1998-10-21', '0138223590', 'MARRIED', 'FEMALE', 'MADAM', '548C LOT 7927 KAMPUNG BINTAWA HILIR PETRA JAYA 93050 KUCHING, SARAWAK.', 'yanajobli21@gmail.com');
INSERT INTO `user` VALUES ('104', '20', 'KHO CHIN KING', '980809135687', '1998-08-09', '0128868859', 'SINGLE', 'MALE', 'MR', 'LOT 3976, LORONG 8, JALAN KEPAYANG,93150,KUCHING,SARAWAK', 'kingchannel9889@gmail.com');
INSERT INTO `user` VALUES ('107', '', 'DAPHNE YONG ZHI XUAN', '000411131022', '2000-04-11', '01116204208', 'SINGLE', 'FEMALE', 'MISS', '', 'daphneyong11@gmail.com');
INSERT INTO `user` VALUES ('108', '21', 'MANSON KHO KAIZHI', '', '1993-11-03', '0142883390', 'SINGLE', 'MALE', 'MR', '112, GREEN HEIGHTS, LORONG LAPANGAN TERBANG 4, 93250 KUCHING, SARAWAK', 'mansonkho@gmail.com');
INSERT INTO `user` VALUES ('109', '14', 'RONAN KUEK JOO PERN', '030601130773', '2003-06-01', '', 'SINGLE', 'MALE', 'MR', '', 'ronankuek@gmail.com');
INSERT INTO `user` VALUES ('111', '', 'ERIC TEST', '', '1970-01-01', '', 'SINGLE', 'MALE', 'MR', '', 'ericgom200302@gmail.com');
INSERT INTO `user` VALUES ('112', '', 'ERIC TEST', '', '1970-01-01', '', 'SINGLE', 'MALE', 'MR', '', 'ericleongom17@gmail.com');

-- ----------------------------
-- Table structure for user_access_type
-- ----------------------------
CREATE TABLE `user_access_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of user_access_type
-- ----------------------------
INSERT INTO `user_access_type` VALUES ('1', 'ADMINISTRATOR');
INSERT INTO `user_access_type` VALUES ('2', 'APPROVAL');
INSERT INTO `user_access_type` VALUES ('3', 'STAFF');

-- ----------------------------
-- Table structure for user_emergency_details
-- ----------------------------
CREATE TABLE `user_emergency_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `relationship` varchar(255) DEFAULT NULL,
  `contact_no` varchar(100) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=119 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of user_emergency_details
-- ----------------------------
INSERT INTO `user_emergency_details` VALUES ('56', '51', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('61', '56', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('18', '18', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('19', '19', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('60', '55', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('32', '32', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('55', '50', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('58', '53', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('54', '49', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('62', '57', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('47', '44', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('52', '47', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('64', '59', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('69', '64', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('67', '62', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('71', '67', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('72', '68', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('73', '69', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('74', '71', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('75', '72', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('76', '73', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('77', '74', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('78', '75', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('79', '76', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('80', '77', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('81', '78', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('82', '79', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('84', '81', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('85', '82', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('86', '83', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('87', '84', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('88', '85', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('90', '87', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('91', '88', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('92', '89', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('93', '90', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('94', '91', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('95', '92', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('96', '93', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('107', '102', 'MUHAMMAD NURUL ALIMIN BIN ABDULLAH', 'HUSBAND', '01116058554', '', 'NO 28 JALAN RUBBER BARAT 93400 KUCHING SARAWAK');
INSERT INTO `user_emergency_details` VALUES ('99', '94', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('106', '101', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('105', '100', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('109', '104', 'ANG FUI AI', 'MOTHER', '01110548766', '', 'LOT 3976, LORONG 8, JALAN KEPAYANG,93150,KUCHING,SARAWAK');
INSERT INTO `user_emergency_details` VALUES ('110', '105', 'ANG FUI AI', 'MOTHER', '01110548766', '', 'LOT 3976, LORONG 8, JALAN KEPAYANG,93150,KUCHING,SARAWAK');
INSERT INTO `user_emergency_details` VALUES ('111', '106', 'ANG FUI AI', 'MOTHER', '01110548766', '', 'LOT 3976, LORONG 8, JALAN KEPAYANG,93150,KUCHING,SARAWAK');
INSERT INTO `user_emergency_details` VALUES ('112', '107', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('113', '108', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('115', '109', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('117', '111', '', '', '', '', '');
INSERT INTO `user_emergency_details` VALUES ('118', '112', '', '', '', '', '');

-- ----------------------------
-- Table structure for user_employment_history
-- ----------------------------
CREATE TABLE `user_employment_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(255) NOT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `joined_date` varchar(255) DEFAULT NULL,
  `joined_dateto` varchar(255) DEFAULT NULL,
  `specialization` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `position_level` varchar(255) DEFAULT NULL,
  `jobscope_description` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=117 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of user_employment_history
-- ----------------------------
INSERT INTO `user_employment_history` VALUES ('54', '51', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('59', '56', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('16', '18', '', '', '1970-01-01', '1970-01-01', '', '', '', '', '', '');
INSERT INTO `user_employment_history` VALUES ('17', '19', '', '', '1970-01-01', '1970-01-01', '', '', '', '', '', '');
INSERT INTO `user_employment_history` VALUES ('58', '55', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('30', '32', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('53', '50', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('56', '53', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('60', '57', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('45', '44', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('52', '49', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('50', '47', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('110', '107', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('62', '59', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('67', '64', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('65', '62', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('69', '67', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('70', '68', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('71', '69', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('72', '71', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('73', '72', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('74', '73', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('75', '74', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('76', '75', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('77', '76', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('78', '77', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('79', '78', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('80', '79', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('108', '105', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('82', '81', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('83', '82', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('84', '83', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('85', '84', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('86', '85', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('88', '87', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('89', '88', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('90', '89', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('91', '90', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('92', '91', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('93', '92', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('94', '93', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('111', '108', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('97', '94', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('109', '106', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('107', '104', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('113', '109', '', '', '', '', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('103', '100', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('115', '111', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');
INSERT INTO `user_employment_history` VALUES ('116', '112', '', '', '1970-01-01', '1970-01-01', '', '', null, '', '', '');

-- ----------------------------
-- Table structure for user_finance
-- ----------------------------
CREATE TABLE `user_finance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `bank` varchar(255) DEFAULT NULL,
  `bank_acc_no` varchar(255) DEFAULT NULL,
  `epf_no` varchar(255) DEFAULT NULL,
  `payslip_by` varchar(255) DEFAULT NULL,
  `basic_salary` varchar(255) DEFAULT NULL,
  `epf_contribution` varchar(255) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=119 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of user_finance
-- ----------------------------
INSERT INTO `user_finance` VALUES ('56', '51', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('61', '56', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('18', '18', '', '', '', '', '', '0');
INSERT INTO `user_finance` VALUES ('19', '19', '', '', '', '', '', '0');
INSERT INTO `user_finance` VALUES ('60', '55', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('32', '32', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('55', '50', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('58', '53', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('54', '49', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('62', '57', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('47', '44', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('52', '47', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('64', '59', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('69', '64', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('67', '62', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('71', '67', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('72', '68', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('73', '69', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('74', '71', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('75', '72', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('76', '73', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('77', '74', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('78', '75', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('79', '76', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('80', '77', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('81', '78', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('82', '79', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('84', '81', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('85', '82', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('86', '83', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('87', '84', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('88', '85', '', '', '', '', '300', '');
INSERT INTO `user_finance` VALUES ('90', '87', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('91', '88', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('92', '89', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('93', '90', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('94', '91', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('95', '92', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('96', '93', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('106', '101', 'AMBANK', '8881044292366', '23354613', '', '2500', '11');
INSERT INTO `user_finance` VALUES ('99', '94', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('105', '100', 'PUBLIC BANK', '6487707330', '22374058', '', '2500', '11');
INSERT INTO `user_finance` VALUES ('107', '102', '', '', '', '', '', '0');
INSERT INTO `user_finance` VALUES ('109', '104', 'CIMB', '70 7719238 6', '', '', '2300', '');
INSERT INTO `user_finance` VALUES ('110', '105', 'CIMB', '70 7719238 6', '', '', '2300', '');
INSERT INTO `user_finance` VALUES ('111', '106', 'CIMB', '70 7719238 6', '', '', '2300', '');
INSERT INTO `user_finance` VALUES ('112', '107', '', '', '', '', '2600', '');
INSERT INTO `user_finance` VALUES ('113', '108', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('115', '109', 'CIMB', '7636903820', '', '', '2100', '');
INSERT INTO `user_finance` VALUES ('117', '111', '', '', '', '', '', '');
INSERT INTO `user_finance` VALUES ('118', '112', '', '', '', '', '', '');

-- ----------------------------
-- Table structure for user_job_details
-- ----------------------------
CREATE TABLE `user_job_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `branch` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `group_emp` varchar(1000) DEFAULT NULL,
  `date_of_joining` varchar(255) DEFAULT NULL,
  `allow_leave_date` varchar(255) DEFAULT NULL,
  `date_left` varchar(255) DEFAULT NULL,
  `employee_type` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `skype_contact` varchar(255) DEFAULT NULL,
  `amount` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=120 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of user_job_details
-- ----------------------------
INSERT INTO `user_job_details` VALUES ('69', '64', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2020-01-29', '2020-01-29', '1970-01-01', 'INTERN', 'chesterchen29@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('64', '59', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2020-01-29', '2020-01-29', '1970-01-01', 'INTERN', 'yagamisung@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('18', '18', 'SOFTWORLD SOFTWARE SDN BHD', '', 'MANAGING DIRECTOR', 'PROGRAMMING', '', '2015-05-05', '2015-05-05', '1970-01-01', '', 'raymond@softworld.com.my', '', null);
INSERT INTO `user_job_details` VALUES ('19', '19', 'SOFTWORLD SOFTWARE SDN BHD', '', 'ACC CUM HR DIRECTOR', 'ADMINSTRATION', '', '2015-05-05', '2015-09-06', '1970-01-01', '', 'jessiengo@softworld.com.my', '', null);
INSERT INTO `user_job_details` VALUES ('55', '50', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2019-07-01', '2019-07-01', '2020-04-11', 'FULL TIME', 'chiuntai29@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('60', '55', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2020-01-02', '2020-01-02', '1970-01-01', 'FULL TIME', 'calvinkhung@softworld.com.my', null, null);
INSERT INTO `user_job_details` VALUES ('32', '32', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2018-06-04', '2018-06-04', '1970-01-01', 'FULL TIME', 'ramizah.amalina@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('58', '53', 'SOFTWORLD SOFTWARE SDN BHD', '', 'TECHNICIAN', 'IT TECHNCIAN', null, '2019-09-17', '2019-09-17', '1970-01-01', 'FULL TIME', 'f4213@yahoo.com', null, null);
INSERT INTO `user_job_details` VALUES ('56', '51', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2019-08-19', '2019-08-19', '2020-03-01', 'INTERN', 'karrinrianeykennedy@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('61', '56', 'SOFTWORLD SOFTWARE SDN BHD', '', 'ADMINISTRATOR', 'ADMINSTRATION', null, '2019-12-13', '2019-12-13', '2020-09-18', 'FULL TIME', 'niza@softworld.com.my', null, null);
INSERT INTO `user_job_details` VALUES ('62', '57', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2020-01-20', '2020-01-20', '1970-01-01', 'INTERN', 'kuehsiawkhern@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('47', '44', 'SOFTWORLD SOFTWARE SDN BHD', '', 'DESIGNER', 'DESIGNING', null, '2019-04-08', '2019-04-08', '1970-01-01', 'INTERN', 'tarotcrescent@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('54', '49', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2019-07-23', '2019-07-23', '1970-01-01', 'FULL TIME', 'zulhaimie67@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('52', '47', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2019-07-15', '2019-07-15', '1970-01-01', 'FULL TIME', 'afiqruzainiofficial@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('67', '62', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2020-01-29', '2020-01-29', '1970-01-01', 'INTERN', 'fun.9609@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('71', '67', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2020-02-24', '2020-02-24', '1970-01-01', 'INTERN', 'isaacjana.work@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('72', '68', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2020-02-24', '2020-02-24', '1970-01-01', 'INTERN', 'mansondisen97@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('73', '69', 'SOFTWORLD SOFTWARE SDN BHD', '', 'DESIGNER', 'DESIGNING', null, '2020-05-18', '2020-05-18', '1970-01-01', 'INTERN', 'meg.cxy@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('74', '71', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2020-08-17', '2020-08-17', '1970-01-01', 'INTERN', 'melleans00@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('75', '72', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2020-08-17', '2020-08-17', '1970-01-01', 'INTERN', 'melleans00@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('76', '73', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2020-08-17', '2020-08-17', '1970-01-01', 'INTERN', 'melleans00@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('77', '74', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2020-09-01', '2020-09-01', '1970-01-01', '', 'death_piece96@hotmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('78', '75', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2020-09-01', '2020-09-01', '1970-01-01', '', 'death_piece96@hotmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('79', '76', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2020-12-10', '2020-12-10', '1970-01-01', '', 'linghowaun@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('80', '77', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2020-12-10', '2020-12-10', '1970-01-01', '', 'linghowaun@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('81', '78', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2021-03-01', '2021-03-01', '1970-01-01', '', 'othmannurfarisha@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('82', '79', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2020-12-29', '2020-12-29', '1970-01-01', '', 'henry991999@hotmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('110', '104', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2023-11-01', '2023-11-01', '1970-01-01', 'FULL TIME', 'kingchannel9889@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('84', '70', 'SOFTWORLD SOFTWARE SDN BHD', '', 'ADMINSTRATION', 'ADMINSTRATION', '', '2019-12-13', '2019-12-13', '2020-09-18', 'FULL TIME', 'katherinephang1996@gmail.com', '', '');
INSERT INTO `user_job_details` VALUES ('85', '81', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2021-03-08', '2021-05-26', '1970-01-01', '', 'regas@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('86', '82', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2021-03-08', '2021-05-26', '1970-01-01', '', 'annatasiayii0712@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('87', '83', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2021-03-01', '2021-03-01', '1970-01-01', '', 'leesufah20@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('88', '84', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2021-03-08', '2021-03-08', '1970-01-01', '', 'ardillesjuti@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('89', '85', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'HR DEPARTMENT', null, '2023-05-01', '2023-05-01', '1970-01-01', 'FULL TIME', 'mansonkho@yahoo.com', null, null);
INSERT INTO `user_job_details` VALUES ('91', '87', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2021-08-04', '2021-08-04', '1970-01-01', '', 'afifjazimin6@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('92', '88', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2021-08-04', '2021-08-04', '1970-01-01', '', 'afifjazimin6@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('93', '89', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2021-08-04', '2021-08-04', '1970-01-01', '', 'afifjazimin6@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('94', '90', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2022-02-28', '2022-02-28', '1970-01-01', '', 'irene.chu@softworld.com.my', null, null);
INSERT INTO `user_job_details` VALUES ('95', '91', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2022-02-28', '2022-02-28', '1970-01-01', '', 'irene.chu@softworld.com.my', null, null);
INSERT INTO `user_job_details` VALUES ('96', '92', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2022-02-28', '2022-02-28', '1970-01-01', '', 'irene.chu@softworld.com.my', null, null);
INSERT INTO `user_job_details` VALUES ('97', '93', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2022-06-07', '2022-06-07', '1970-01-01', '', 'phoebesim98@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('111', '105', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2023-11-01', '2023-11-01', '1970-01-01', 'FULL TIME', 'kingchannel9889@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('108', '102', 'SOFTWORLD SOFTWARE SDN BHD', '', 'ADMINISTRATOR', 'ADMINSTRATION', null, '2023-10-17', '2023-12-01', '1970-01-01', 'FULL TIME', 'yanajobli21@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('107', '101', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2023-01-09', '2023-04-09', '1970-01-01', 'FULL TIME', 'banabas.lau@softworld.com.my', null, null);
INSERT INTO `user_job_details` VALUES ('106', '100', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2023-03-01', '2023-06-01', '1970-01-01', 'FULL TIME', 'raymond.lai@softworld.com.my', null, null);
INSERT INTO `user_job_details` VALUES ('112', '106', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2023-11-01', '2023-11-01', '1970-01-01', 'FULL TIME', 'kingchannel9889@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('113', '107', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2023-09-11', '2023-09-11', '1970-01-01', 'FULL TIME', 'daphneyong11@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('114', '108', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2023-08-28', '2023-11-28', '1970-01-01', 'FULL TIME', 'mansonkho@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('116', '109', 'SOFTWORLD SOFTWARE SDN BHD', '', 'PROGRAMMER', 'PROGRAMMING', null, '2023-12-18', '2023-12-27', '1970-01-01', 'FULL TIME', 'ronankuek@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('118', '111', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2024-03-20', '2024-03-12', '1970-01-01', '', 'ericgom200302@gmail.com', null, null);
INSERT INTO `user_job_details` VALUES ('119', '112', 'SOFTWORLD SOFTWARE SDN BHD', '', '', '', null, '2024-03-27', '2024-03-27', '1970-01-01', '', 'ericleongom17@gmail.com', null, null);

-- ----------------------------
-- Table structure for user_leave
-- ----------------------------
CREATE TABLE `user_leave` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `leave_year` varchar(100) DEFAULT NULL,
  `annual_le` varchar(255) DEFAULT '0',
  `sick_le` varchar(255) DEFAULT '0',
  `annual_taken` varchar(255) DEFAULT '0',
  `sick_taken` varchar(255) DEFAULT '0',
  `maternity_le` varchar(255) DEFAULT '0',
  `maternity_taken` varchar(255) DEFAULT '0',
  `paternity_le` varchar(255) DEFAULT '0',
  `paternity_taken` varchar(255) DEFAULT '0',
  `hospitalization_le` varchar(255) DEFAULT '0',
  `hospitalization_taken` varchar(255) DEFAULT '0',
  `carry_forward_le` varchar(255) DEFAULT '0',
  `carry_forward_taken` varchar(255) DEFAULT '0',
  `unpaid_taken` varchar(255) DEFAULT '0',
  `unpaid_leave_le` varchar(255) DEFAULT '0',
  `unpaid_leave_taken` varchar(255) DEFAULT '0',
  `special_leave_le` varchar(255) DEFAULT '0',
  `special_leave_taken` varchar(255) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=147 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of user_leave
-- ----------------------------
INSERT INTO `user_leave` VALUES ('79', '44', '2020', '12', '10', '4', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('17', '18', '2024', '14', '14', '', '', '0', '', '3', '', '60', '', '', '', '', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('18', '19', '2017', '14', '14', '', '', '60', '', '0', '', '60', '', '', '', '', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('68', '50', '2019', '8', '0', '1', '0', '0', '0', '0', '0', '60', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('69', '51', '2019', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('76', '32', '2020', '13', '10', '7', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('31', '18', '2024', '14', '14', '', '', '0', '', '3', '', '60', '', '', '', '', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('32', '19', '2018', '14', '14', '', '', '60', '', '0', '', '60', '', '', '', '', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('39', '32', '2018', '13', '14', '6.5', '0', '0', '0', '0', '0', '60', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('77', '50', '2020', '12', '10', '4', '0', '0', '0', '0', '0', '60', '0', '3', '3', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('73', '55', '2020', '1', '10', '5', '1', '0', '0', '0', '0', '0', '0', '0', '0', '19', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('74', '56', '2020', '0', '10', '3', '1', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('71', '53', '2019', '0', '14', '0', '0', '0', '0', '0', '0', '60', '0', '0', '0', '2', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('65', '19', '2019', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('75', '57', '2020', '0', '0', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('78', '47', '2020', '13', '10', '6', '0', '0', '0', '0', '0', '60', '0', '3', '0', '3', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('57', '32', '2019', '13', '10', '7.5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('80', '49', '2020', '11', '10', '5', '0', '0', '0', '0', '0', '60', '0', '0', '0', '1.5', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('59', '44', '2019', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('64', '47', '2019', '13', '14', '1', '0', '0', '0', '0', '0', '60', '0', '0', '0', '4', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('67', '49', '2019', '11', '14', '2', '0', '0', '0', '0', '0', '60', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('89', '53', '2020', '0', '10', '0', '0', '0', '0', '3', '3', '0', '0', '0', '0', '3', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('82', '59', '2020', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('133', '107', '2024', '12', '10', '2', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('87', '64', '2020', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('85', '62', '2020', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('90', '67', '2020', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('91', '18', '2024', '14', '10', '0', '0', '0', '0', '3', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('92', '19', '2020', '14', '10', '0', '0', '0', '0', '40', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('93', '68', '2020', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('94', '69', '2020', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('95', '71', '2020', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('96', '72', '2020', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('97', '73', '2020', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('98', '74', '2020', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('99', '75', '2020', '12', '10', '3', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('100', '76', '2021', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('101', '77', '2021', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('102', '78', '2021', '12', '10', '6', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('103', '79', '2021', '12', '10', '8', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('105', '81', '2021', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('106', '82', '2021', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('107', '83', '2021', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('108', '84', '2021', '12', '10', '2', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('109', '85', '2021', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('111', '87', '2021', '12', '10', '1', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('112', '88', '2021', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('113', '89', '2021', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('114', '90', '2022', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('115', '91', '2022', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('116', '92', '2022', '12', '10', '5', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('117', '93', '2022', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('128', '102', '2023', '12', '10', '1.5', '0', '0', '0', '0', '0', '60', '1', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('130', '104', '2024', '12', '10', '1', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('131', '105', '2023', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('132', '106', '2023', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('127', '101', '2024', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('126', '100', '2023', '12', '10', '2', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('134', '108', '2023', '12', '10', '1', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('135', '18', '2024', '14', '10', '0', '0', '0', '0', '0', '0', '60', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('136', '85', '2023', '2', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('140', '100', '2024', '12', '10', '0', '0', '0', '0', '0', '0', '60', '0', '3', '1', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('141', '102', '2024', '14', '14', '4', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('142', '53', '2024', '12', '10', '0', '0', '0', '0', '3', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('143', '109', '2024', '12', '10', '1', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('145', '111', '2024', '12', '10', '1', '0', '0', '0', '0', '0', '60', '0', '3', '0', '1', '0', '0', '0', '0');
INSERT INTO `user_leave` VALUES ('146', '112', '2024', '12', '10', '2', '0', '0', '0', '0', '0', '60', '0', '3', '0', '0', '0', '0', '0', '0');

-- ----------------------------
-- Table structure for user_picture
-- ----------------------------
CREATE TABLE `user_picture` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `profile_picture` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=121 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of user_picture
-- ----------------------------
INSERT INTO `user_picture` VALUES ('56', '51', '');
INSERT INTO `user_picture` VALUES ('61', '56', '');
INSERT INTO `user_picture` VALUES ('18', '18', '');
INSERT INTO `user_picture` VALUES ('19', '19', '');
INSERT INTO `user_picture` VALUES ('60', '55', '');
INSERT INTO `user_picture` VALUES ('32', '32', '');
INSERT INTO `user_picture` VALUES ('55', '50', '');
INSERT INTO `user_picture` VALUES ('58', '53', '');
INSERT INTO `user_picture` VALUES ('54', '49', '');
INSERT INTO `user_picture` VALUES ('62', '57', '');
INSERT INTO `user_picture` VALUES ('47', '44', '');
INSERT INTO `user_picture` VALUES ('70', '65', '');
INSERT INTO `user_picture` VALUES ('52', '47', '');
INSERT INTO `user_picture` VALUES ('64', '59', '');
INSERT INTO `user_picture` VALUES ('69', '64', '');
INSERT INTO `user_picture` VALUES ('67', '62', '');
INSERT INTO `user_picture` VALUES ('114', '107', '');
INSERT INTO `user_picture` VALUES ('72', '67', '');
INSERT INTO `user_picture` VALUES ('73', '68', '');
INSERT INTO `user_picture` VALUES ('74', '69', '');
INSERT INTO `user_picture` VALUES ('75', '70', '');
INSERT INTO `user_picture` VALUES ('76', '71', '');
INSERT INTO `user_picture` VALUES ('77', '72', '');
INSERT INTO `user_picture` VALUES ('78', '73', '');
INSERT INTO `user_picture` VALUES ('79', '74', '');
INSERT INTO `user_picture` VALUES ('80', '75', '');
INSERT INTO `user_picture` VALUES ('81', '76', '');
INSERT INTO `user_picture` VALUES ('82', '77', '');
INSERT INTO `user_picture` VALUES ('83', '78', '');
INSERT INTO `user_picture` VALUES ('84', '79', '');
INSERT INTO `user_picture` VALUES ('112', '105', '');
INSERT INTO `user_picture` VALUES ('86', '81', '');
INSERT INTO `user_picture` VALUES ('87', '82', '');
INSERT INTO `user_picture` VALUES ('88', '83', '');
INSERT INTO `user_picture` VALUES ('89', '84', '');
INSERT INTO `user_picture` VALUES ('90', '85', '');
INSERT INTO `user_picture` VALUES ('92', '87', '');
INSERT INTO `user_picture` VALUES ('93', '88', '');
INSERT INTO `user_picture` VALUES ('94', '89', '');
INSERT INTO `user_picture` VALUES ('95', '90', '');
INSERT INTO `user_picture` VALUES ('96', '91', '');
INSERT INTO `user_picture` VALUES ('97', '92', '');
INSERT INTO `user_picture` VALUES ('98', '93', '');
INSERT INTO `user_picture` VALUES ('109', '102', '');
INSERT INTO `user_picture` VALUES ('101', '94', '');
INSERT INTO `user_picture` VALUES ('113', '106', '');
INSERT INTO `user_picture` VALUES ('111', '104', '');
INSERT INTO `user_picture` VALUES ('108', '101', '');
INSERT INTO `user_picture` VALUES ('107', '100', '');
INSERT INTO `user_picture` VALUES ('115', '108', '');
INSERT INTO `user_picture` VALUES ('117', '109', '');
INSERT INTO `user_picture` VALUES ('119', '111', '');
INSERT INTO `user_picture` VALUES ('120', '112', '');

-- ----------------------------
-- Table structure for working_days
-- ----------------------------
CREATE TABLE `working_days` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_id` int(11) DEFAULT NULL,
  `branch_id` int(255) DEFAULT NULL,
  `workday_id` int(11) DEFAULT NULL,
  `day_name` varchar(15) DEFAULT NULL,
  `work_from` varchar(15) DEFAULT NULL,
  `work_to` varchar(15) DEFAULT NULL,
  `lunch_from` varchar(15) DEFAULT NULL,
  `lunch_to` varchar(15) DEFAULT NULL,
  `day_type` varchar(15) DEFAULT NULL,
  `date_update` varchar(255) DEFAULT NULL,
  `time_update` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=128 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of working_days
-- ----------------------------
INSERT INTO `working_days` VALUES ('1', '1', '1', '1', 'MONDAY', '08:30', '17:30', '12:00', '13:00', 'FULL', '2023-11-30', '09:39 AM');
INSERT INTO `working_days` VALUES ('2', '1', '1', '2', 'TUESDAY', '08:30', '17:30', '12:00', '13:00', 'FULL', '2023-11-30', '09:39 AM');
INSERT INTO `working_days` VALUES ('3', '1', '1', '3', 'WEDNESDAY', '08:30', '17:30', '12:00', '13:00', 'FULL', '2023-11-30', '09:39 AM');
INSERT INTO `working_days` VALUES ('4', '1', '1', '4', 'THURSDAY', '08:30', '17:30', '12:00', '13:00', 'FULL', '2023-11-30', '09:39 AM');
INSERT INTO `working_days` VALUES ('5', '1', '1', '5', 'FRIDAY', '08:30', '17:30', '12:00', '13:00', 'FULL', '2023-11-30', '09:39 AM');
INSERT INTO `working_days` VALUES ('6', '1', '1', '6', 'SATURDAY', '', '', '', '', 'OFF', '2023-11-30', '09:39 AM');
INSERT INTO `working_days` VALUES ('7', '1', '1', '7', 'SUNDAY', '', '', '', '', 'OFF', '2023-11-30', '09:39 AM');
