


DELETE FROM t_src_pattern WHERE FID = 1467373963029174272;
INSERT INTO t_src_pattern(FBITINDEX,FBASESCORE,FRANKTYPE,FUSEORGID,FISSYSPRESET,FCREATEORGID,FSUPPLIERNUM2,FISDEFAULT,FVIETYPE,FMASTERID,FCALCRATIO,FCTRLSTRATEGY,FCREATETIME,FSCOREPARA,FENABLE,FRATIOTYPE,FREMARK,FCALCANALY,FID,FLASTUPDATETIME,FSCOREFORMULA,FPROJECTD,FMATCHFIELD,FCALCRANK,FSCOREPARA2,FSOURCEDATAID,FLASTUPDATEUSERID,FORGID,FISNONNEGATIVE,FSTATUS,FSUPPLIERNUM,FNUMBER,FSOURCEBITINDEX,FVALUEFIELD,FRULEASSESS,FCALCTOTAL,FMODIFIERID,FSUMTYPE,FMODIFYTIME,FWINRULEID,FCREATORID,FAVGTYPE) VALUES (0,100.000000,'3',0,'1',0,4,'0','A',1467373963029174272,' ','5',{ts'2022-07-18  00:00:00'},1.000000,'1','1',' ',' ',1467373963029174272,{ts'2022-07-18  00:00:00'},'2',0,2,' ',2.00,0,2744157,0,'1','C',5,'SYS017',0,'locprice',' ',' ',2744157,'3',{ts'2022-07-18  00:00:00'},0,2744157,'1'); 

DELETE FROM t_src_pattern_l WHERE FPKID = '2L80HZHYM27S';
INSERT INTO t_src_pattern_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1467373963029174272,'2L80HZHYM27S','zh_CN','标的平均价偏差方案'); 
DELETE FROM t_src_pattern_l WHERE FPKID = '2L80HZHYM27T';
INSERT INTO t_src_pattern_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1467373963029174272,'2L80HZHYM27T','zh_TW','標的平均價偏差方案'); 
