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');