--银行类别-运营商机构编号 更新历史数据
--运营机构(10)：招商银行 工商银行 农业银行 中国银行 建设银行 财付通 网商银行 邮储银行 交通银行 兴业银行
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1030844001362' WHERE FID = 544782186595789011;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1010211000012' WHERE FID = 544782186595789003;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1010311000014' WHERE FID = 544782186595789004;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1010411000013' WHERE FID = 544782186595789005;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1010511003703' WHERE FID = 544782186595789006;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1302533000018' WHERE FID = 544782186595789158;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1040311005293' WHERE FID = 544782186595789008;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1030131001288' WHERE FID = 544782186595789007;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1030935001347' WHERE FID = 544782186595789016;
--合作银行(29)：重庆银行 资和信 北京银行 成都农商银行 城银清算 光大银行 广发银行 杭州银行 河北农信 华融湘江银行 江苏农信 江苏银行 泸州银行 民生银行 南京银行 宁波银行 农信银资金清算中心 平安银行 浦发银行 青岛银行 上海银行
--深圳农商银行 四川农信 苏州农商银行 苏州银行 西安银行 长沙银行 浙商银行 中信银行
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1093150000010' WHERE FID = 544782186595789115;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1080211000028' WHERE FID = 544782186595789021;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1258851000018' WHERE FID = 544782186595790187;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1030311000455' WHERE FID = 544782186595789010;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1030644021075' WHERE FID = 544782186595789017;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1092033000015' WHERE FID = 544782186595789066;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C3123013000012' WHERE FID = 544782186595790515;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1136043000016' WHERE FID = 544782186595789101;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C3240632000017' WHERE FID = 544782186595790829;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1086832000010' WHERE FID = 544782186595789062;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1079151000012' WHERE FID = 544782186595789121;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1030511000483' WHERE FID = 544782186595789013;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1086932000011' WHERE FID = 544782186595789063;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1092133000016' WHERE FID = 544782186595789148;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1030744001296' WHERE FID = 544782186595789015;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1031031001312' WHERE FID = 544782186595789012;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1088237000013' WHERE FID = 544782186595789153;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1091231000013' WHERE FID = 544782186595789061;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1109644000036' WHERE FID = 544782186595790483;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C3215651000019' WHERE FID = 544782186595791108;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1115332000018' WHERE FID = 544782186595789064;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1091161000033' WHERE FID = 544782186595789135;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1086243000029' WHERE FID = 544782186595789102;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1031633000292' WHERE FID = 544782186595789019;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONCODE = 'C1030211000389' WHERE FID = 544782186595789009;
--结算方式-数币钱包
DELETE FROM T_BD_SettlementType WHERE FID = 1871122303736339456;
INSERT INTO T_BD_SettlementType(FID,FISAGENCYPERSONPAY,FCREATEORGID,FISDEFAULT,FDISABLEDATE,FDESCRIPTION,FORGID,FMASTERID,FSTATUS,FISLINKAGEPAYMENT,FNUMBER,FISPERSONPAY,FNAME,FPAYTHROUGHBE,FDPAYMENTCHANNEL,FENABLE,FPAYMENTCHANNEL,FSETTLEMENTTYPE,FISSYSTEM,FDISABLERID) VALUES (1871122303736339456,'0',NULL,'0',NULL,' ',NULL,1871122303736339456,'C','0','JSFS15_S','0','数币钱包','0',' ','1',' ','15',NULL,0); 
