/*
================================================================================
档案代号: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;