egovframe / 메뉴 및 기능추가

--1.프로그램 추가

insert into lettnprogrmlist values ('SftGridSetup','/sft/cmm/','SFT공통테스트1','SFT공통테스트1','/sft/cmm/sftCmm.do');//SftGridSetup

 

--2.메뉴추가 

insert into lettnmenuinfo values ('GRID항목설정','SftGridSetup','5020400','5020000','3','GRID항목설정','/','/');//SftGridSetup

 

--3.롤정보

insert into LETTNROLEINFO(ROLE_CODE,ROLE_NM,ROLE_PTTRN,ROLE_DC,ROLE_TY,ROLE_SORT,ROLE_CREAT_DE) values ('sft-cmm','sft-cmm','/sft/cmm/.*.do.*','sft-cmm','url','2','20160303' );

 

--4. 권한별 롤

insert into LETTNAUTHORROLERELATE(AUTHOR_CODE,ROLE_CODE,CREAT_DT) values ('ROLE_ADMIN','sft-cmm',now());

 

--5.메뉴생성목록

insert into LETTNMENUCREATDTLS(MENU_NO,AUTHOR_CODE,MAPNG_CREAT_ID) values (5020400,'ROLE_ADMIN',null);