/*
================================================================================
档案代号:vlc_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vlc_file
(
vlc01       varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/
vlc02       varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/
vlc03       date,                    /*执行日期                               */
vlc04       varchar2(8),             /*执行时间                               */
vlc05       varchar2(10),            /*产生资料                               */
vlc06       varchar2(80),            /*讯息一                                 */
vlc07       varchar2(80)             /*讯息二                                 */
);

create        index vlc_02 on vlc_file (vlc01,vlc02);
grant select on vlc_file to public;
grant index on vlc_file to public;
grant update on vlc_file to public;
grant delete on vlc_file to public;
grant insert on vlc_file to public;