SELECT @group_id := max(report_group_id) + 1 from ohrm_report_group;
INSERT INTO `ohrm_report_group` (`report_group_id`, `name`, `core_sql`) VALUES 
        (@group_id, 'vacancy_succession', '');

SELECT @report_id := max(report_id) + 1 from ohrm_report;
INSERT INTO `ohrm_report` (`report_id`, `name`, `report_group_id`, `use_filter_field`, `type`) VALUES 
(@report_id, 'License Expiry Report', @group_id, 1, 'ADVANCED_REPORTS');
