BEGIN;
INSERT INTO language (phrase, english) VALUES
('employee_report', 'Employees'),
('leave_reports', 'Leave Reports'),
('leave_report', 'Leaves'),
('hrm_id', 'HRM ID'),
('year', 'Year'),
('quota', 'Quota'),
('remaining', 'Remaining'),
('applied', 'Applied'),
('pending', 'Pending'),
('denied', 'Denied');
UPDATE sec_menu_item SET active = 0 WHERE module = 'reports';
INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`, `active`) VALUES
('employee_reports', NULL, 'reports', '0', '0', '1', '2021-10-03 20:00:55.000000', '1'),
('employee_report', 'employee/report', 'reports', '311', '0', '1', '2021-10-03 20:00:55.000000', '1'),
('leave_reports', NULL, 'reports', '0', '0', '1', '2021-10-03 20:00:55.000000', '1'),
('leave_report', 'leave/report', 'reports', '313', '0', '1', '2021-10-03 20:00:55.000000', '1');
COMMIT;