/* 增加网银子账户编码规则 */

DELETE FROM t_cr_coderule WHERE FID = '0AQR1AXCXYTB';
INSERT INTO t_cr_coderule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('0AQR1AXCXYTB','1','-',' ',null,'2','0AQR1AXCXYTB','C',' ',null,' ',{ts'2019-10-28  15:37:57'},'bd_netbankacct','1','0',13466739,{ts'2019-10-28  15:37:57'},13466739,null); 

DELETE FROM t_cr_coderule_L WHERE FPKID = '0AQR1AY3XJ1P';
INSERT INTO t_cr_coderule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0AQR1AXCXYTB','0AQR1AY3XJ1P','zh_CN','网银子帐户编码规则'); 
DELETE FROM t_cr_coderule_L WHERE FPKID = '0AQR1AY3XJ1O';
INSERT INTO t_cr_coderule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0AQR1AXCXYTB','0AQR1AY3XJ1O','zh_TW','網銀子帳戶編碼規則'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0AQR1B18C2YN';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0AQR1AXCXYTB',1,'1',' ','0','0AQR1B18C2YN','1',1,' ',0,'1',8,'ZZH','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0AQR1B18C2YO';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0AQR1AXCXYTB',1,'16',' ','0','0AQR1B18C2YO','1',1,'1',1,'1',3,' ','1',' ',' ','0',' '); 
