DELETE FROM t_cr_coderule WHERE FID = '1NMV3//MG9BN';

DELETE FROM t_cr_coderule_l WHERE FPKID = '1NMV3//MG19K';

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1NMV3/0ULNVA';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1NMV3/0ULNVB';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1NMV3/0ULNVC';

DELETE FROM t_cr_coderule WHERE FID = '2MN52Y5DMCKA';
INSERT INTO t_cr_coderule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FISADDVIEW,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FMODIFIERID,FISUPDATERECOVER,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('2MN52Y5DMCKA','1','-',' ',NULL,'2','0','2MN52Y5DMCKA','C','2MN4U3X7W6RC',NULL,' ',{ts'2022-08-03  00:00:00'},'tm_forex_options',1223933865899341824,'0','1',{ts'2022-08-03  00:00:00'},0,NULL);

DELETE FROM t_cr_coderule_l WHERE FPKID = '2MN52Y5DK=SJ';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2MN52Y5DMCKA','2MN52Y5DK=SJ','zh_CN','外汇期权');

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2MN52Y6EHYOZ';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2MN52Y5DMCKA',1,'1',' ','0','2MN52Y6EHYOZ',1,'1','1',0,'1',8,'FOREX','1',' ',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2MN52Y6EHYP+';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2MN52Y5DMCKA',1,'9','-','0','2MN52Y6EHYP+',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ',' ','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2MN52Y6EHYP/';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2MN52Y5DMCKA',1,'10','-','0','2MN52Y6EHYP/',1,'1',' ',2,'1',8,' ','1',' ',' ','1',' ');