SET @config_admin_role_id = (SELECT `id` FROM ohrm_user_role WHERE `name` = 'ConfigAdmin');

INSERT INTO `ohrm_data_group` (`name`, `description`, `can_read`, `can_create`, `can_update`, `can_delete`) VALUES
('admin_oauth_register', 'Admin - Oauth Register', 1, 1, 1, 1);
SET @admin_oauth_register_data_group_id := (SELECT LAST_INSERT_ID());

INSERT INTO `ohrm_user_role_data_group` (`user_role_id`, `data_group_id`, `can_read`, `can_create`, `can_update`, `can_delete`, `self`) VALUES
(@config_admin_role_id, @admin_oauth_register_data_group_id, 1, 1, 1, 1, 0);

ALTER TABLE `ohrm_oauth_client` CONVERT TO CHARACTER SET utf8;
