/*
================================================================================
档案代号:gch_file
档案名称:V-Point Express 资料库详细设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gch_file
(
gch01       varchar2(10) NOT NULL,   /*TIPTOP 营运中心                        */
gch02       varchar2(1) NOT NULL,    /*Express 站台设定                       */
gch03       varchar2(15) NOT NULL,   /*Express 站台 IP 位址                   */
gch04       varchar2(10) NOT NULL,   /*Express 站台名称                       */
gch05       varchar2(1) NOT NULL,    /*Express 资料库                         */
gch06       varchar2(15) NOT NULL,   /*V-Point Express 站台资料库             */
gch07       varchar2(6) NOT NULL,    /*V-Point Express 资料库 IP              */
gch08       varchar2(10) NOT NULL,   /*V-Point Express 资料库 Port            */
gch09       varchar2(20) NOT NULL,   /*V-Point Express 资料库名称/SID         */
gch10       varchar2(20) NOT NULL,   /*V-Point Express 资料库密码             */
gch11       varchar2(255),           /*Express SOAP Services 连接网址         */
gch12       varchar2(20),            /*Express 系统帐号                       */
gch13       varchar2(20)             /*Express 系统密码                       */
);

create unique index gch_pk on gch_file (gch01,gch02,gch03,gch04,gch05,gch06,gch07,gch08,gch09,gch10);
alter table gch_file add  constraint gch_pk primary key  
(gch01,gch02,gch03,gch04,gch05,gch06,gch07,gch08,gch09,gch10) enable validate;
grant select on gch_file to public;
grant index on gch_file to public;
grant update on gch_file to public;
grant delete on gch_file to public;
grant insert on gch_file to public;