VMSCommServer/VMS-FTP-INFO.SQL

phvmslocal
local12#$!

phvmscenter
center12#$!


port: 50021

passive-mode: true

port-range: 8000~8020

TB_VMS_SYMB_LIB.SYMB_IMAG_TYPE	VARCHAR(7)	Y		심벌 이미지 유형 ==> 크기확인
TB_VMS_SYMB_LIB.IMAG_SIZE				NUMBER(10)	Y		이미지 사이즈 ==> 크기작으면 늘려주어야 함	

SYMB_TYPE	7	N	VARCHAR(5)	Y		심벌 유형(SBT0:일반심벌이미지,SBT1:소통정보배경,SBT2:소통정보이미지,SBT3:동영상,SBT4:대기환경등급)
5000, 5999

-- 동영상 파일 유형
avi, mpeg, mkv, mp4

동영상 파일 (*.avi;*.mpeg;*.mpg;*.mkv;*.mp4)|*.avi;*.mpeg;*.mpg;*.mkv;*.mp4
Video Files|*.AVI;*.MP4;*.MPG;*.MPEG


-- VMS FTP 정보
insert into TB_CMMN_CLSF_CD (CMMN_CLSF_CD, MSG_TYPE_CD, CMMN_CLSF_KOR_NM, CMMN_CLSF_ENGL_NM, USE_SYST_CD, RMRK, USE_YN) values ('VMFTP', null, 'VMS FTP 정보', 'VMS FTP 정보', '공통', null, 'Y');
insert into TB_CMMN_CD (CMMN_CD, CMMN_CLSF_CD, CMMN_CD_KOR_NM, CMMN_CD_ENGL_NM, CMMN_CD_ABBR, RMRK, ATRB1, ATRB2, USE_YN) values ('1', 'VMFTP', '115.91.94.42', '', null, null, null, null, 'Y');
insert into TB_CMMN_CD (CMMN_CD, CMMN_CLSF_CD, CMMN_CD_KOR_NM, CMMN_CD_ENGL_NM, CMMN_CD_ABBR, RMRK, ATRB1, ATRB2, USE_YN) values ('2', 'VMFTP', '50021', '', null, null, null, null, 'Y');
insert into TB_CMMN_CD (CMMN_CD, CMMN_CLSF_CD, CMMN_CD_KOR_NM, CMMN_CD_ENGL_NM, CMMN_CD_ABBR, RMRK, ATRB1, ATRB2, USE_YN) values ('3', 'VMFTP', '1', '', null, null, null, null, 'Y');
insert into TB_CMMN_CD (CMMN_CD, CMMN_CLSF_CD, CMMN_CD_KOR_NM, CMMN_CD_ENGL_NM, CMMN_CD_ABBR, RMRK, ATRB1, ATRB2, USE_YN) values ('4', 'VMFTP', 'phvmscenter', '', null, null, null, null, 'Y');
insert into TB_CMMN_CD (CMMN_CD, CMMN_CLSF_CD, CMMN_CD_KOR_NM, CMMN_CD_ENGL_NM, CMMN_CD_ABBR, RMRK, ATRB1, ATRB2, USE_YN) values ('5', 'VMFTP', 'center12#$!', '', null, null, null, null, 'Y');
commit;

-- VMS 폼 관련 테이블 수정
INSERT INTO TB_VMS_FORM_TYPE(VMS_FORM_TYPE_CD, VMS_FORM_TYPE_NM, EDTN_CD, USE_YN) VALUES(70, '동영상', 'EDI0', 'Y');
COMMIT;

INSERT INTO TB_VMS_FORM_OBJECT_TYPE(VMS_FORM_TYPE_CD, VMS_FORM_OBJECT_TYPE_CD, VMS_FORM_OBJECT_TYPE_NM, USE_YN) VALUES(70, 200, '동영상', 'Y');
COMMIT;

ALTER TABLE TB_VMS_DSPL_PRST ADD VMS_DSPL_MSG_INFO VARCHAR(100);
COMMENT ON TABLE TB_VMS_DSPL_PRST IS 'VMS 표출 현재';
COMMENT ON COLUMN TB_VMS_DSPL_PRST.VMS_DSPL_MSG_INFO IS 'VMS 메시지 표출 정보';


ITS_OP.exe
VmsOprMain.exe
VmsCommServer.exe

VideoVMS.inf 파일 업데이트