/*
================================================================================
档案代号:zak_file
档案名称:定义设定查询的sql
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zak_file
(
zak01       varchar2(80) NOT NULL,   /*查询单ID                               */
zak02       varchar2(2000),          /*SQL命令                                */
zak03       varchar2(2000),          /*table 列表                             */
zak04       varchar2(2000),          /*Field 列表                             */
zak05       varchar2(2000),          /*where 条件                             */
zak06       varchar2(1),             /*SQL是否由Wizard产生                    */
zak07       varchar2(1) NOT NULL,    /*客制码                                 */
zak08       varchar2(255)            /*No Use                                 */
);

create unique index zak_pk on zak_file (zak01,zak07);
alter table zak_file add  constraint zak_pk primary key  (zak01,zak07) enable validate;
grant select on zak_file to public;
grant index on zak_file to public;
grant update on zak_file to public;
grant delete on zak_file to public;
grant insert on zak_file to public;