CREATE table T_SSO_AUTH_CODE 
(	
	CODE_ID NUMERIC NOT NULL COMMENT '권한코드 (h2_user_info.usr_lv)', 
	CODE_NM VARCHAR(60) NOT NULL COMMENT '권한명', 
	DESCRIPTION VARCHAR(200) COMMENT '설명', 
	EXPOSURE NUMERIC DEFAULT 0 COMMENT '사용여부', 
	ROLE_LEVEL NUMERIC DEFAULT 0 COMMENT '권한레벨'
);

INSERT INTO h2_bbs.t_sso_auth_code (CODE_ID,CODE_NM,DESCRIPTION,EXPOSURE,ROLE_LEVEL) VALUES 
(1,'ROLE_ADMIN','관리자',1,0)
,(2,'ROLE_MIDDLE_ADMIN','중간관리자',1,1)
,(3,'ROLE_MANAGE','국제협력담당관',1,2)
,(4,'ROLE_LEADER','국제범규팀장',1,3)
,(6,'ROLE_USER','사용자(쓰기)',1,4)
,(7,'ROLE_READ_USER','사용자',1,5)
,(8,'ROLE_DISABLE','이용중지',1,99)
;