delete from t_lic_group_version_l where fentryid = (select fentryid from t_lic_group_version where fid = 610 and fversion = '7.0'); 
delete from t_lic_group_version where fid = 610 and fversion = '7.0' ; 
delete from t_lic_group where fid = 610 or fnumber = 'PRO_QMC_MOBQC'; 
delete from t_lic_group_l where fid = 610 ; 
insert into t_lic_group (fid,fnumber,ftype,fgroupdes) values (610,'PRO_QMC_MOBQC','2',' '); 
insert into t_lic_group_version (fid,fentryid,fnameversion,fgroupdesversion,fversion) values (610,2042762672814163969,'质量云轻应用',' ','7.0'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4DXOENHGOBH8',610,'GLang','质量云轻应用'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4DXOENHGOC5H',2042762672814163969,'GLang','质量云轻应用'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4DXOENHGOBH9',610,'zh_CN','质量云轻应用'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4DXOENHGOC5I',2042762672814163969,'zh_CN','质量云轻应用'); 
update t_lic_group_version_l set fgroupdesversion = ' ' where flocaleid = 'zh_CN' and fentryid = 2042762672814163969; 
UPDATE t_lic_module SET fname = '质量云轻应用', fgroupid = 610 WHERE fnumber = 'QMC_MOBQC'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 369, 'QMC_MOBQC', '质量云轻应用', 610 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'QMC_MOBQC' ); 
UPDATE t_lic_module_version SET fnameversion = '质量云轻应用' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'QMC_MOBQC' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042762672814162948, '质量云轻应用', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'QMC_MOBQC' 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 = 'QMC_MOBQC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXOENHGOC5J', 'GLang', '质量云轻应用' FROM t_lic_module m WHERE m.fnumber = 'QMC_MOBQC' 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 = 'QMC_MOBQC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXOENHGOBHA', 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 = 'QMC_MOBQC' 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 = 'QMC_MOBQC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXOENHGOC5K', 'zh_CN', '质量云轻应用' FROM t_lic_module m WHERE m.fnumber = 'QMC_MOBQC' 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 = 'QMC_MOBQC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXOENHGOBHB', 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 = 'QMC_MOBQC' AND lmvl.fentryid IS NULL; 
