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