/*
================================================================================
档案代号:gco_file
档案名称:触发器模板定义档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gco_file
(
gco01       varchar2(15) NOT NULL,   /*表名                                   */
gco02       varchar2(1000),          /*所有栏位名称                           */
gco03       varchar2(3000),          /*所有新值                               */
gco04       varchar2(3000),          /*所有旧值                               */
gco05       varchar2(20),            /*用户                                   */
gco06       varchar2(10),            /*操作类型                               */
gco07       date                     /*操作日期                               */
);

create unique index gco_pk on gco_file (gco01);
alter table gco_file add  constraint gco_pk primary key  (gco01) enable validate;
grant select on gco_file to public;
grant index on gco_file to public;
grant update on gco_file to public;
grant delete on gco_file to public;
grant insert on gco_file to public;