--外汇即期
update t_tm_trade set fcategory='1',fvariety='外汇',ftype='1' where fprotecttypeid=937486862912605184;
--外汇远期
update t_tm_trade set fcategory='1',fvariety='外汇',ftype='2' where fprotecttypeid=937487193708953600;
--外汇掉期
update t_tm_trade set fcategory='1',fvariety='外汇',ftype='3' where fprotecttypeid=937487388609891328;
--外汇期权
update t_tm_trade set fcategory='1',fvariety='外汇',ftype='4' where fprotecttypeid=941773368233832448;
--利率互换
update t_tm_trade set fcategory='1',fvariety='利率',ftype='3' where fprotecttypeid=952722152971330560;
--远期利率协议
update t_tm_trade set fcategory='1',fvariety='利率',ftype='2' where fprotecttypeid=941771935417643008;

--插入外汇对应的多语言交易品种
delete from t_tm_trade_l where fid in(select fid from t_tm_trade where fprotecttypeid in(937486862912605184,937487193708953600,937487388609891328,941773368233832448));
insert into t_tm_trade_l (fpkid,fid,flocaleid,fvariety) select substring(concat('',fid),2,18),fid,'zh_CN','外汇' from t_tm_trade where fprotecttypeid in(937486862912605184,937487193708953600,937487388609891328,941773368233832448);
--插入利率对应的多语言交易品种
delete from t_tm_trade_l where fid in(select fid from t_tm_trade where fprotecttypeid in(952722152971330560,941771935417643008));
insert into t_tm_trade_l (fpkid,fid,flocaleid,fvariety) select substring(concat('',fid),2,18),fid,'zh_CN','利率' from t_tm_trade where fprotecttypeid in(952722152971330560,941771935417643008);

--期权组合
update t_tm_optioncomb  set fcategory='1',fvariety='外汇',ftype='5' where fassettype='tm_forex_options_l';
--插入期权组合对应的多语言交易品种
delete from t_tm_optioncomb_l where fid in( select fid from t_tm_optioncomb where fassettype='tm_forex_options_l');
insert into t_tm_optioncomb_l (fpkid,fid,flocaleid,fvariety) select substring(concat('',fid),2,18),fid,'zh_CN','外汇' from t_tm_optioncomb where fassettype='tm_forex_options_l';

--组合交易-用程序写
