delete from t_lic_group_version_l where fentryid = (select fentryid from t_lic_group_version where fid = 673 and fversion = '7.0'); 
delete from t_lic_group_version where fid = 673 and fversion = '7.0' ; 
delete from t_lic_group where fid = 673 or fnumber = 'PRO_MMC_ECE'; 
delete from t_lic_group_l where fid = 673 ; 
insert into t_lic_group (fid,fnumber,ftype,fgroupdes) values (673,'PRO_MMC_ECE','2',' '); 
insert into t_lic_group_version (fid,fentryid,fnameversion,fgroupdesversion,fversion) values (673,2042758623867962369,'工程变更评估',' ','7.0'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4DXNO4U+6ZZD',673,'GLang','工程变更评估'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4DXNO4U+6Z=4',2042758623867962369,'GLang','工程变更评估'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4DXNO4U+6ZZE',673,'zh_CN','工程变更评估'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4DXNO4U+6Z=5',2042758623867962369,'zh_CN','工程变更评估'); 
update t_lic_group_version_l set fgroupdesversion = ' ' where flocaleid = 'zh_CN' and fentryid = 2042758623867962369; 
UPDATE t_lic_module SET fname = '工程变更评估', fgroupid = 673 WHERE fnumber = 'MMC_ECE'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 438, 'MMC_ECE', '工程变更评估', 673 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'MMC_ECE' ); 
UPDATE t_lic_module_version SET fnameversion = '工程变更评估' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'MMC_ECE' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042758623867963396, '工程变更评估', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'MMC_ECE' AND NOT EXISTS ( SELECT 1 FROM t_lic_module_version lmv WHERE lm.fid = lmv.fid ); 
UPDATE t_lic_module_l SET fname = '工程变更评估' WHERE flocaleid = 'GLang' AND fid IN (SELECT fid FROM t_lic_module WHERE fnumber = 'MMC_ECE'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXNO4U+6Z=6', 'GLang', '工程变更评估' FROM t_lic_module m WHERE m.fnumber = 'MMC_ECE' AND NOT EXISTS (SELECT 1 FROM t_lic_module_l ml WHERE ml.fid = m.fid AND ml.flocaleid = 'GLang'); 
UPDATE t_lic_module_version_l SET fnameversion = '工程变更评估' WHERE flocaleid = 'GLang' AND fentryid IN ( SELECT fentryid FROM t_lic_module_version WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'MMC_ECE')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXNO4U+6ZZG', v.fentryid, 'GLang', '工程变更评估' FROM t_lic_module_version v JOIN t_lic_module m ON v.fid = m.fid LEFT JOIN t_lic_module_version_l lmvl ON v.fentryid = lmvl.fentryid AND lmvl.flocaleid = 'GLang' WHERE m.fnumber = 'MMC_ECE' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module_l SET fname = '工程变更评估' WHERE flocaleid = 'zh_CN' AND fid IN (SELECT fid FROM t_lic_module WHERE fnumber = 'MMC_ECE'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXNO4U1UCGL', 'zh_CN', '工程变更评估' FROM t_lic_module m WHERE m.fnumber = 'MMC_ECE' AND NOT EXISTS (SELECT 1 FROM t_lic_module_l ml WHERE ml.fid = m.fid AND ml.flocaleid = 'zh_CN'); 
UPDATE t_lic_module_version_l SET fnameversion = '工程变更评估' WHERE flocaleid = 'zh_CN' AND fentryid IN ( SELECT fentryid FROM t_lic_module_version WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'MMC_ECE')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXNO4U1UD4V', v.fentryid, 'zh_CN', '工程变更评估' FROM t_lic_module_version v JOIN t_lic_module m ON v.fid = m.fid LEFT JOIN t_lic_module_version_l lmvl ON v.fentryid = lmvl.fentryid AND lmvl.flocaleid = 'zh_CN' WHERE m.fnumber = 'MMC_ECE' AND lmvl.fentryid IS NULL; 
