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