CREATE TABLE h2_bbs.T_SSO_HIERARCHY_ROLES(
			PARENTS_ROLE VARCHAR(50) not null,
			CHILDREN_ROLE VARCHAR(50) );

INSERT INTO T_SSO_HIERARCHY_ROLES (PARENTS_ROLE,CHILDREN_ROLE) VALUES 
('ANONYMOUS_USER','IS_AUTHENTICATED_ANONYMOUSLY')
,('IS_AUTHENTICATED_ANONYMOUSLY','IS_AUTHENTICATED_REMEMBERED')
,('IS_AUTHENTICATED_REMEMBERED','IS_AUTHENTICATED_FULLY')
,('IS_AUTHENTICATED_FULLY','ROLE_RESTRICTED')
,('ROLE_RESTRICTED','ROLE_USER')
,('ROLE_USER','FA_USER_14')
,('FA_USER_14','FA_USER_13')
,('FA_USER_13','FA_USER_12')
,('FA_USER_12','FA_USER_11')
,('FA_USER_11','FA_USER_10')
;
INSERT INTO T_SSO_HIERARCHY_ROLES (PARENTS_ROLE,CHILDREN_ROLE) VALUES 
('FA_USER_10','FA_USER_9')
,('FA_USER_9','FA_USER_8')
,('FA_USER_8','FA_USER_7')
,('FA_USER_7','FA_USER_6')
,('FA_USER_6','FA_USER_5')
,('FA_USER_5','FA_USER_4')
,('FA_USER_4','FA_USER_3')
,('FA_USER_3','FA_USER_2')
,('FA_USER_2','FA_USER_1')
,('FA_USER_1','FA_USER_0')
;
INSERT INTO T_SSO_HIERARCHY_ROLES (PARENTS_ROLE,CHILDREN_ROLE) VALUES 
('FA_USER_0','ROLE_MANAGER')
,('ROLE_USER','NFA_USER')
,('NFA_USER','ROLE_MANAGER')
,('ROLE_MANAGER','ROLE_ADMIN')
;