/* ================================================================================ 档案代号:mlj_file 档案名称:javamail参数维护作业 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table mlj_file ( mlj01 varchar2(20) NOT NULL, /*程式代号 */ /*程式代号(program code) */ mlj02 varchar2(1), /*XML档档名 */ /*XML档档名(1)固定(.xml)(2)变动($pid.xml)*/ mlj03 varchar2(30), /*MAIL SERVER IP */ mlj04 varchar2(5), /*MAIL SERVER Port */ mlj05 varchar2(10), /*MAIL SERVER User */ mlj06 varchar2(20), /*MAIL SERVER User Password */ mlj07 varchar2(1), /*是否启动Javamail */ mljuser varchar2(10), /*资料所有者 */ mljgrup varchar2(10), /*资料所有部门 */ mljmodu varchar2(10), /*资料修改者 */ mljdate date, /*最近修改日 */ mlj08 varchar2(1), /*是否检查认证 */ mlj09 varchar2(1), /*No Use */ mlj10 varchar2(1) /*No Use */ ); create unique index mlj_pk on mlj_file (mlj01); alter table mlj_file add constraint mlj_pk primary key (mlj01) enable validate; grant select on mlj_file to public; grant index on mlj_file to public; grant update on mlj_file to public; grant delete on mlj_file to public; grant insert on mlj_file to public; |