/*
================================================================================
档案代号:gcp_file
档案名称:触发器信息档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gcp_file
(
gcp01       varchar2(15) NOT NULL,   /*表名                                   */
gcp02       varchar2(30),            /*触发器名                               */
gcp03       varchar2(100),           /*触发器说明                             */
gcp04       varchar2(100),           /*其他参数                               */
gcp05       varchar2(1),             /*已经建立                               */
gcp06       varchar2(30),            /*触发器全称                             */
gcp07       varchar2(1)              /*是否共用                               */
);

create unique index gcp_pk on gcp_file (gcp01);
alter table gcp_file add  constraint gcp_pk primary key  (gcp01) enable validate;
grant select on gcp_file to public;
grant index on gcp_file to public;
grant update on gcp_file to public;
grant delete on gcp_file to public;
grant insert on gcp_file to public;