UPDATE t_lic_module SET fname = '收付款认领', fgroupid = 2 WHERE fnumber = 'RPC';
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 2046342208986285056, 'RPC', '收付款认领', 2 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'RPC' ); 
UPDATE t_lic_module_version SET fnameversion = '收付款认领' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'RPC' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2046636922671203355, '收付款认领', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'RPC' 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 = 'RPC');
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4ED8A8LNCC5L', 'GLang', '收付款认领' FROM t_lic_module m WHERE m.fnumber = 'RPC' 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 = 'RPC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4ED8A8LR+RO3', 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 = 'RPC' 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 = 'RPC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4ED8A8LR+SBC', 'zh_CN', '收付款认领' FROM t_lic_module m WHERE m.fnumber = 'RPC' 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 = 'RPC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4ED8A8LR+RO4', 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 = 'RPC' AND lmvl.fentryid IS NULL; 

UPDATE t_lic_module SET fname = '资金洞察移动应用', fgroupid = 401 WHERE fnumber = 'TAI';
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 2046377408181045248, 'TAI', '资金洞察移动应用', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'TAI' );
UPDATE t_lic_module_version SET fnameversion = '资金洞察移动应用' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'TAI' ) AND fversion = '7.0';
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2046636922746701830, '资金洞察移动应用', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'TAI' 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 = 'TAI');
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4ED8A8MH/27E', 'GLang', '资金洞察移动应用' FROM t_lic_module m WHERE m.fnumber = 'TAI' 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 = 'TAI')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4ED8A8MH/2WO', 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 = 'TAI' 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 = 'TAI'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4ED8A8MH/27F', 'zh_CN', '资金洞察移动应用' FROM t_lic_module m WHERE m.fnumber = 'TAI' 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 = 'TAI')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4ED8A8MH/2WP', 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 = 'TAI' AND lmvl.fentryid IS NULL; 
