20.11.23大额转账转用大额组件 · 通宝+平台

alter table T_SPECIAL_RECHARGE add "OUT_ORDER" VARCHAR2(200 BYTE) DEFAULT 0 ; COMMENT ON COLUMN T_SPECIAL_RECHARGE.OUT_ORDER IS '大额组件订单号'; create sequence seq_addres_config_id increment by 1 start with 1 nomaxvalue nominvalue nocache; CREATE TABLE "TONGBAO"."T_ADDRESS_CONFIG" ( "ID" NUMBER(20,0), "IP" VARCHAR2(2000 BYTE), "WITH_PARAMETERS" VARCHAR2(2000 BYTE), "TITLE" VARCHAR2(2000 BYTE), "DESCRIBE" VARCHAR2(2000 BYTE), "USERID" VARCHAR2(2000 BYTE), "USERNAME" VARCHAR2(20 BYTE), "DATETIME" VARCHAR2(20 BYTE), "UPDATETIME" VARCHAR2(20 BYTE), "STATUS" VARCHAR2(20 BYTE), "TYPE" VARCHAR2(20 BYTE) DEFAULT 1, "IDENTIFYING" VARCHAR2(2000 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_ADDRESS_CONFIG"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_ADDRESS_CONFIG"."IP" IS '地址'; COMMENT ON COLUMN "TONGBAO"."T_ADDRESS_CONFIG"."WITH_PARAMETERS" IS '附带参数'; COMMENT ON COLUMN "TONGBAO"."T_ADDRESS_CONFIG"."TITLE" IS '标题'; COMMENT ON COLUMN "TONGBAO"."T_ADDRESS_CONFIG"."DESCRIBE" IS '描述'; COMMENT ON COLUMN "TONGBAO"."T_ADDRESS_CONFIG"."USERID" IS '管理员ID'; COMMENT ON COLUMN "TONGBAO"."T_ADDRESS_CONFIG"."USERNAME" IS '管理员姓名'; COMMENT ON COLUMN "TONGBAO"."T_ADDRESS_CONFIG"."DATETIME" IS '添加时间'; COMMENT ON COLUMN "TONGBAO"."T_ADDRESS_CONFIG"."UPDATETIME" IS '修改时间'; COMMENT ON COLUMN "TONGBAO"."T_ADDRESS_CONFIG"."STATUS" IS '状态:1:正常,2禁用'; COMMENT ON COLUMN "TONGBAO"."T_ADDRESS_CONFIG"."TYPE" IS '类型1;默认值'; COMMENT ON COLUMN "TONGBAO"."T_ADDRESS_CONFIG"."IDENTIFYING" IS '标识'; Insertinto TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (1,'ccbde23d6f0f8cae5326c8b8fd6544f2',null,'大额组件生成签名sign','大额组件，秘钥:md5(jyzz2019),用于生成签名sign','8','qiweiwei','1606207031','1606207031','1','1','LA_KEY'); Insertinto TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (2,'7a0afa8bfaa73f0f064d46e1',null,'3des加密','大额组件 3des加密所需得key','8','qiweiwei','1606207067','1606207067','1','1','LA_DESKEY'); Insertinto TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (3,'1.0',null,'版本','大额组件版本','8','qiweiwei','1606207102','1606207102','1','1','LA_VERSION'); Insertinto TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (4,'jyzz2019',null,'数据加密参数','大额组件，数据加密参数 ','8','qiweiwei','1606207136','1606207136','1','1','LA_SIGN_KEY'); Insertinto TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (5,'https://paycenter.9617777.com/large_transfers/#/detail?',null,'跳转地址','大额组件跳转地址','8','qiweiwei','1606207175','1606207175','1','1','LA_SKIP_ORDER_URL'); Insertinto TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (6,'ky51LRYxEU',null,'品牌','大额汇款组件品牌id','8','qiweiwei','1606206871','1606206871','1','1','LA_APPID'); Insertinto TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (7,'265',null,'店铺ID','大额组件店铺ID ','8','qiweiwei','1606206919','1606206919','1','1','LA_STOREID'); Insertinto TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (8,'https://tongbao.9617777.com/buyinglarge/laCallbackUrl',null,'回调地址','大额组件回调地址','8','qiweiwei','1606207206','1606207206','1','1','LA_CALLBACK_URL'); Insertinto TONGBAO.T_ADDRESS_CONFIG (ID,IP,WITH_PARAMETERS,TITLE,DESCRIBE,USERID,USERNAME,DATETIME,UPDATETIME,STATUS,TYPE,IDENTIFYING) values (9,'https://tongbao.9617777.com/buyinglarge/encryptionOrder',null,'校验信息接口','大额组件校验信息接口地址','8','qiweiwei','1606207260','1606207260','1','1','LA_PREPARE_URL');