delete from t_lic_group_version_l where fentryid = (select fentryid from t_lic_group_version where fid = 612 and fversion = '7.0'); 
delete from t_lic_group_version where fid = 612 and fversion = '7.0' ; 
delete from t_lic_group where fid = 612 or fnumber = 'PRO_MMC_PC'; 
delete from t_lic_group_l where fid = 612 ; 
insert into t_lic_group (fid,fnumber,ftype,fgroupdes) values (612,'PRO_MMC_PC','2',' '); 
insert into t_lic_group_version (fid,fentryid,fnameversion,fgroupdesversion,fversion) values (612,2042762410988931073,'产品选配',' ','7.0'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4DXOCR2J/8Y2',612,'GLang','产品选配'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4DXOCR2J/9LB',2042762410988931073,'GLang','产品选配'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4DXOCR2J/8Y3',612,'zh_CN','产品选配'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4DXOCR2J/9LC',2042762410988931073,'zh_CN','产品选配'); 
update t_lic_group_version_l set fgroupdesversion = ' ' where flocaleid = 'zh_CN' and fentryid = 2042762410988931073; 
UPDATE t_lic_module SET fname = '产品选配', fgroupid = 612 WHERE fnumber = 'MMC_PC'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 371, 'MMC_PC', '产品选配', 612 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'MMC_PC' ); 
UPDATE t_lic_module_version SET fnameversion = '产品选配' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'MMC_PC' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042762410988930052, '产品选配', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'MMC_PC' 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_PC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXOCR2J/9LD', 'GLang', '产品选配' FROM t_lic_module m WHERE m.fnumber = 'MMC_PC' 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_PC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXOCR2J/8Y5', 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_PC' 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_PC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXOCR2J/9LE', 'zh_CN', '产品选配' FROM t_lic_module m WHERE m.fnumber = 'MMC_PC' 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_PC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXOCR2J/8Y6', 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_PC' AND lmvl.fentryid IS NULL; 
