SET @audittrail_module_id := (SELECT `id` FROM `ohrm_audittrail_module` WHERE `name` = 'Recruitment');
SET @recruitment_candidate_audit_trail_section := (SELECT `id` FROM `ohrm_audittrail_section` WHERE `name` = 'JobVacancy' AND `module_id` = @audittrail_module_id);
INSERT INTO `ohrm_audittrail_section_actions` (`section_id`, `action`, `description`) VALUES (@recruitment_candidate_audit_trail_section, 'DELETE CANDIDATES', 'Delete Candidates');
INSERT INTO `ohrm_event_listener` (`id`, `event`, `listener_class`, `enabled`, `position`) VALUES (NULL, 'recruitment.delete_candidate', 'RecruitmentDeleteCandidateListener', '1', '84');