SET @admin_module_id = (SELECT `id` FROM ohrm_module WHERE `name` = 'admin');
SET @admin_menu_id = (SELECT `id` FROM ohrm_menu_item WHERE `menu_title` = 'Admin');
SET @admin_configurations_menu_id = (SELECT `id` FROM ohrm_menu_item WHERE `menu_title` = 'Configuration' AND `parent_id` = @admin_menu_id);
INSERT INTO ohrm_screen (`name`, `module_id`, `action_url`) VALUES
('Export Configuration', @admin_module_id, 'exportConfiguration');
SET @export_configuration_screen_id = (SELECT `id` FROM ohrm_screen WHERE `action_url` = 'exportConfiguration');
INSERT INTO ohrm_menu_item (`menu_title`, `screen_id`, `parent_id`, `level`, `order_hint`, `uisref`, `status`) VALUES
('Export', @export_configuration_screen_id, @admin_configurations_menu_id,3, 300, NULL , 1);
INSERT INTO `ohrm_data_group` (`name`, `description`, `can_read`, `can_create`, `can_update`, `can_delete`) VALUES
('export_configuration', 'Admin - Export Configuration', 1, 0, 0, 0);
INSERT INTO ohrm_screen (`name`, `module_id`, `action_url`) VALUES
('Import Configuration', @admin_module_id, 'importConfiguration');
SET @import_configuration_screen_id = (SELECT `id` FROM ohrm_screen WHERE `action_url` = 'importConfiguration');
INSERT INTO ohrm_menu_item (`menu_title`, `screen_id`, `parent_id`, `level`, `order_hint`, `uisref`, `status`) VALUES
('Import', @import_configuration_screen_id, @admin_configurations_menu_id,3, 400, NULL , 1);
INSERT INTO `ohrm_data_group` (`name`, `description`, `can_read`, `can_create`, `can_update`, `can_delete`) VALUES
('import_configuration', 'Admin - Import Configuration', 1, 1, 1, 1);