-- SET @form_type_data_group_id := (SELECT id from ohrm_data_group WHERE name = 'request_desk_form_types');
-- SET @request_form_types_data_group_id := (SELECT id from ohrm_data_group WHERE name = 'request_form_types');
--  INSERT INTO `ohrm_user_role_type_data_group` (`user_role_type_id`, `data_group_id`, `can_read`, `can_create`, `can_update`, `can_delete`) VALUES
--  (1, @form_type_data_group_id, 1, 0, 0, 0);
-- INSERT INTO `ohrm_user_role_type_data_group` (`user_role_type_id`, `data_group_id`, `can_read`, `can_create`, `can_update`, `can_delete`) VALUES
--  (1, @request_form_types_data_group_id, 1, 1, 1, 1);

SET @report_data_group_id := (SELECT id from ohrm_data_group WHERE name = 'request_information_report');
SET @admin_id := (SELECT id FROM ohrm_user_role where name = 'Admin');
INSERT INTO `ohrm_user_role_type_data_group` (`user_role_type_id`, `data_group_id`, `can_read`, `can_create`, `can_update`, `can_delete`) VALUES(@admin_id, @report_data_group_id, 1, 0, 0, 0);

UPDATE `ohrm_menu_item` SET `uisref` = 'pim.employees.profile.jnbs-contact_details' WHERE `menu_title` = 'Contact Details';
UPDATE `ohrm_menu_item` SET `uisref` = 'pim.employees.profile.jnbs-emergency_contact' WHERE `menu_title` = 'Emergency Contacts';
UPDATE `ohrm_menu_item` SET `uisref` = 'pim.employees.profile.jnbs-personal_details' WHERE `menu_title` = 'Personal Details';
UPDATE `ohrm_menu_item` SET `uisref` = 'pim.employees.profile.jnbs-qualifications' WHERE `menu_title` = 'Qualifications' and menu_category='pim_left_menu';
UPDATE `ohrm_menu_item` SET `uisref` = 'pim.employees.profile.jnbs-job' WHERE `menu_title` = 'Job' and menu_category='pim_left_menu';
