/*==============================================================*/
/* Table: PUBFLOWPAR            流量控制参数                    */
/*=============================================================*/
create table PUBFLOWPAR 
(
   REG_ID               VARCHAR2(20)          not null,
   --域名
   NOD_ID               VARCHAR2(6)           not null,
   --节点名
   TX_COD               VARCHAR2(6)           default ' ' not null,
   --交易码
   SYS_CNL              VARCHAR2(10)          default '999999' not null,
   --系统渠道
   BUS_CNL              VARCHAR2(10)          not null,
   --业务渠道
   MAX_FLOW             NUMBER(5)             default 0   not null,
   --最大流量
   STS                  VARCHAR2(1)           default '0' not null,
   --状态 0生效 1无效
   TM_SMP               VARCHAR2(14)          default ' ' not null,
   --时间戳
   RMK                  VARCHAR2(100)         default ' ' not null,
   --备注
   constraint PUBFLOWPAR_PK primary key (REG_ID,NOD_ID,SYS_CNL,BUS_CNL)
);

insert into PUBFLOWPAR (REG_ID, NOD_ID, TX_COD, SYS_CNL, BUS_CNL, MAX_FLOW, STS, TM_SMP, RMK)
values ('PAY_REG01', 'PAY', ' ', '999999', 'PAB', 20, '0', ' ', ' ');
insert into PUBFLOWPAR (REG_ID, NOD_ID, TX_COD, SYS_CNL, BUS_CNL, MAX_FLOW, STS, TM_SMP, RMK)
values ('PAY_REG01', 'PAY', ' ', '999999', 'CCB', 20, '0', ' ', ' ');
insert into PUBFLOWPAR (REG_ID, NOD_ID, TX_COD, SYS_CNL, BUS_CNL, MAX_FLOW, STS, TM_SMP, RMK)
values ('PAY_REG01', 'PAY', ' ', '999999', 'EBPPP', 20, '0', ' ', ' ');
insert into PUBFLOWPAR (REG_ID, NOD_ID, TX_COD, SYS_CNL, BUS_CNL, MAX_FLOW, STS, TM_SMP, RMK)
values ('PAY_REG01', 'PAY', ' ', '999999', 'CMBC', 20, '0', ' ', ' ');