
DELETE FROM T_LIC_GROUP   WHERE FID = 661 OR FNUMBER = 'FEA_REESAL';
DELETE FROM T_LIC_GROUP_L WHERE FID = 661;
INSERT INTO T_LIC_GROUP  (FID, fNUMBER, FTYPE, FSTATUS, FGROUPDES)    VALUES (661,'FEA_REESAL','2','0','6');
INSERT INTO T_LIC_GROUP_L(FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION) VALUES ('1425A0D8973E',661, 'zh_CN','地产营销管理-企业版',' ');
INSERT INTO T_LIC_GROUP_L(FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION) VALUES ('E6B440E74D4B',661, 'zh_TW','地產營銷管理-企業版',' ');


UPDATE t_lic_module   set  fname = '地产营销管理-旗舰版' WHERE fnumber = 'REGSAL_LP';
UPDATE t_lic_module_L set  FNAME = '地产营销管理-旗舰版' WHERE FID in (select fid from t_lic_module where fnumber = 'REGSAL_LP') AND FLOCALEID = 'zh_CN';
UPDATE t_lic_module_L set  FNAME = '地產營銷管理-旗艦版' WHERE FID in (select fid from t_lic_module where fnumber =  'REGSAL_LP') AND FLOCALEID = 'zh_TW';


UPDATE t_lic_module   set  fname = '冶金实际成本' WHERE fnumber = 'ICM';
UPDATE t_lic_module_L set  FNAME = '冶金实际成本' WHERE FID in (select fid from t_lic_module where fnumber = 'ICM') AND FLOCALEID = 'zh_CN';
UPDATE t_lic_module_L set  FNAME = '冶金實際成本' WHERE FID in (select fid from t_lic_module where fnumber =  'ICM') AND FLOCALEID = 'zh_TW';

UPDATE t_lic_module   set  fname = '冶金日成本' WHERE fnumber = 'STDL';
UPDATE t_lic_module_L set  FNAME = '冶金日成本' WHERE FID in (select fid from t_lic_module where fnumber = 'STDL') AND FLOCALEID = 'zh_CN';
UPDATE t_lic_module_L set  FNAME = '冶金日成本' WHERE FID in (select fid from t_lic_module where fnumber =  'STDL') AND FLOCALEID = 'zh_TW';

UPDATE t_lic_module   set  fname = '冶金生产管理' WHERE fnumber = 'STMM';
UPDATE t_lic_module_L set  FNAME = '冶金生产管理' WHERE FID in (select fid from t_lic_module where fnumber = 'STMM') AND FLOCALEID = 'zh_CN';
UPDATE t_lic_module_L set  FNAME = '冶金生產管理' WHERE FID in (select fid from t_lic_module where fnumber =  'STMM') AND FLOCALEID = 'zh_TW';
