SET @next_user_role_type_id = (SELECT max(id)+1 FROM ohrm_user_role_type);
INSERT INTO ohrm_user_role_type (`id`, `name`) VALUES (@next_user_role_type_id, 'Guest');

INSERT INTO `ohrm_user_role` (`name`, `display_name`, `is_assignable`, `is_predefined`, `is_editable`, `type_id`, `deletable`) VALUES
 ('Guest', 'Guest', 0, 1, 0, @next_user_role_type_id, 0);
SET @guest_user_role_id = (SELECT LAST_INSERT_ID());
