/*
================================================================================
档案代号:mlk_file
档案名称:javamail预设收件人
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table mlk_file
(
mlk01       varchar2(20) NOT NULL,   /*程式代号                               */
                                     /*程式代号(program code)                 */
mlk02       number(5) NOT NULL,      /*序号                                   */
mlk03       varchar2(1),             /*1:收件者 2: 副本 3: 密件副本           */
mlk04       varchar2(80),            /*MAIL  address                          */
mlk05       varchar2(40),            /*姓名                                   */
mlk06       varchar2(255)            /*备注                                   */
);

create unique index mlk_pk on mlk_file (mlk01,mlk02);
alter table mlk_file add  constraint mlk_pk primary key  (mlk01,mlk02) enable validate;
grant select on mlk_file to public;
grant index on mlk_file to public;
grant update on mlk_file to public;
grant delete on mlk_file to public;
grant insert on mlk_file to public;