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