delete from t_lic_group_version_l where fentryid = (select fentryid from t_lic_group_version where fid = 401 and fversion = '7.0'); 
delete from t_lic_group_version where fid = 401 and fversion = '7.0' ; 
delete from t_lic_group where fid = 401 or fnumber = 'PRO'; 
delete from t_lic_group_l where fid = 401 ; 
insert into t_lic_group (fid,fnumber,ftype,fgroupdes) values (401,'PRO','1',' '); 
insert into t_lic_group_version (fid,fentryid,fnameversion,fgroupdesversion,fversion) values (401,2042747401084864513,'财务+供应链+制造分组',' ','7.0'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4DXLKCD8U2Q2',401,'GLang','财务+供应链+制造分组'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4DXLKCD8U3DB',2042747401084864513,'GLang','财务+供应链+制造分组'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4DXLKCD8U2Q3',401,'zh_CN','财务+供应链+制造分组'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4DXLKCD8U3DC',2042747401084864513,'zh_CN','财务+供应链+制造分组'); 
update t_lic_group_version_l set fgroupdesversion = ' ' where flocaleid = 'zh_CN' and fentryid = 2042747401084864513; 
UPDATE t_lic_module SET fname = '实际成本', fgroupid = 401 WHERE fnumber = 'ACA'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 110, 'ACA', '实际成本', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'ACA' ); 
UPDATE t_lic_module_version SET fnameversion = '实际成本' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'ACA' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401084863492, '实际成本', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'ACA' 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 = 'ACA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDBFIKT', 'GLang', '实际成本' FROM t_lic_module m WHERE m.fnumber = 'ACA' 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 = 'ACA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDBFHXJ', 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 = 'ACA' 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 = 'ACA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDBFIKU', 'zh_CN', '实际成本' FROM t_lic_module m WHERE m.fnumber = 'ACA' 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 = 'ACA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDBFHXK', 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 = 'ACA' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '账户管理', fgroupid = 401 WHERE fnumber = 'AM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 111, 'AM', '账户管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'AM' ); 
UPDATE t_lic_module_version SET fnameversion = '账户管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'AM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401093253122, '账户管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'AM' 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 = 'AM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDBFHXL', 'GLang', '账户管理' FROM t_lic_module m WHERE m.fnumber = 'AM' 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 = 'AM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDBFIKW', 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 = 'AM' 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 = 'AM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDBFHXM', 'zh_CN', '账户管理' FROM t_lic_module m WHERE m.fnumber = 'AM' 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 = 'AM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDBFIKX', 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 = 'AM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '应付', fgroupid = 401 WHERE fnumber = 'AP'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 112, 'AP', '应付', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'AP' ); 
UPDATE t_lic_module_version SET fnameversion = '应付' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'AP' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401093252100, '应付', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'AP' 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 = 'AP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDBFIKY', 'GLang', '应付' FROM t_lic_module m WHERE m.fnumber = 'AP' 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 = 'AP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDBFHXO', 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 = 'AP' 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 = 'AP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDBFIKZ', 'zh_CN', '应付' FROM t_lic_module m WHERE m.fnumber = 'AP' 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 = 'AP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDBFHXP', 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 = 'AP' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '应收', fgroupid = 401 WHERE fnumber = 'AR'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 113, 'AR', '应收', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'AR' ); 
UPDATE t_lic_module_version SET fnameversion = '应收' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'AR' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401093253127, '应收', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'AR' 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 = 'AR'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDBFHXQ', 'GLang', '应收' FROM t_lic_module m WHERE m.fnumber = 'AR' 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 = 'AR')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDBFIL/', 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 = 'AR' 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 = 'AR'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDBFHXR', 'zh_CN', '应收' FROM t_lic_module m WHERE m.fnumber = 'AR' 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 = 'AR')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDBFIL0', 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 = 'AR' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '发债管理', fgroupid = 401 WHERE fnumber = 'BDIM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 114, 'BDIM', '发债管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'BDIM' ); 
UPDATE t_lic_module_version SET fnameversion = '发债管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'BDIM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401093252105, '发债管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'BDIM' 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 = 'BDIM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDBFIL1', 'GLang', '发债管理' FROM t_lic_module m WHERE m.fnumber = 'BDIM' 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 = 'BDIM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDBFHXT', 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 = 'BDIM' 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 = 'BDIM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDBFIL2', 'zh_CN', '发债管理' FROM t_lic_module m WHERE m.fnumber = 'BDIM' 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 = 'BDIM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDBFHXU', 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 = 'BDIM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '预算控制', fgroupid = 401 WHERE fnumber = 'BGC'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 115, 'BGC', '预算控制', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'BGC' ); 
UPDATE t_lic_module_version SET fnameversion = '预算控制' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'BGC' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401093253132, '预算控制', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'BGC' 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 = 'BGC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDBFHXV', 'GLang', '预算控制' FROM t_lic_module m WHERE m.fnumber = 'BGC' 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 = 'BGC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDBFIL4', 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 = 'BGC' 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 = 'BGC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDBFHXW', 'zh_CN', '预算控制' FROM t_lic_module m WHERE m.fnumber = 'BGC' 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 = 'BGC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDBFIL5', 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 = 'BGC' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '全面预算', fgroupid = 401 WHERE fnumber = 'BGM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 116, 'BGM', '全面预算', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'BGM' ); 
UPDATE t_lic_module_version SET fnameversion = '全面预算' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'BGM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401101640704, '全面预算', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'BGM' 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 = 'BGM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDF1YSA', 'GLang', '全面预算' FROM t_lic_module m WHERE m.fnumber = 'BGM' 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 = 'BGM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDF1Y32', 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 = 'BGM' 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 = 'BGM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDF1YSB', 'zh_CN', '全面预算' FROM t_lic_module m WHERE m.fnumber = 'BGM' 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 = 'BGM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDF1Y33', 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 = 'BGM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '预算体系', fgroupid = 401 WHERE fnumber = 'BGMD'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 117, 'BGMD', '预算体系', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'BGMD' ); 
UPDATE t_lic_module_version SET fnameversion = '预算体系' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'BGMD' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401101641730, '预算体系', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'BGMD' 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 = 'BGMD'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDF1Y34', 'GLang', '预算体系' FROM t_lic_module m WHERE m.fnumber = 'BGMD' 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 = 'BGMD')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDF1YSD', 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 = 'BGMD' 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 = 'BGMD'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDF1Y35', 'zh_CN', '预算体系' FROM t_lic_module m WHERE m.fnumber = 'BGMD' 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 = 'BGMD')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDF1YSE', 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 = 'BGMD' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '成本分析与决策', fgroupid = 401 WHERE fnumber = 'CAD'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 118, 'CAD', '成本分析与决策', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'CAD' ); 
UPDATE t_lic_module_version SET fnameversion = '成本分析与决策' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'CAD' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401101640709, '成本分析与决策', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'CAD' 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 = 'CAD'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDF1YSF', 'GLang', '成本分析与决策' FROM t_lic_module m WHERE m.fnumber = 'CAD' 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 = 'CAD')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDF1Y37', 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 = 'CAD' 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 = 'CAD'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDF1YSG', 'zh_CN', '成本分析与决策' FROM t_lic_module m WHERE m.fnumber = 'CAD' 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 = 'CAD')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDF1Y38', 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 = 'CAD' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '存货核算', fgroupid = 401 WHERE fnumber = 'CAL'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 119, 'CAL', '存货核算', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'CAL' ); 
UPDATE t_lic_module_version SET fnameversion = '存货核算' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'CAL' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401101641735, '存货核算', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'CAL' 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 = 'CAL'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDF1Y39', 'GLang', '存货核算' FROM t_lic_module m WHERE m.fnumber = 'CAL' 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 = 'CAL')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDF1YSI', 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 = 'CAL' 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 = 'CAL'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDF1Y3=', 'zh_CN', '存货核算' FROM t_lic_module m WHERE m.fnumber = 'CAL' 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 = 'CAL')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDF1YSJ', 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 = 'CAL' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '出纳', fgroupid = 401 WHERE fnumber = 'CAS'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 120, 'CAS', '出纳', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'CAS' ); 
UPDATE t_lic_module_version SET fnameversion = '出纳' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'CAS' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401101640714, '出纳', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'CAS' 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 = 'CAS'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDF1YSK', 'GLang', '出纳' FROM t_lic_module m WHERE m.fnumber = 'CAS' 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 = 'CAS')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDF1Y3B', 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 = 'CAS' 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 = 'CAS'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDF1YSL', 'zh_CN', '出纳' FROM t_lic_module m WHERE m.fnumber = 'CAS' 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 = 'CAS')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDF1Y3C', 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 = 'CAS' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '信用管理', fgroupid = 401 WHERE fnumber = 'CCM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 121, 'CCM', '信用管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'CCM' ); 
UPDATE t_lic_module_version SET fnameversion = '信用管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'CCM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401101641740, '信用管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'CCM' 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 = 'CCM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDF1Y3D', 'GLang', '信用管理' FROM t_lic_module m WHERE m.fnumber = 'CCM' 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 = 'CCM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDIPBZU', 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 = 'CCM' 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 = 'CCM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDIPB=K', 'zh_CN', '信用管理' FROM t_lic_module m WHERE m.fnumber = 'CCM' 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 = 'CCM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDIPBZV', 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 = 'CCM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '票据管理', fgroupid = 401 WHERE fnumber = 'CDM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 122, 'CDM', '票据管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'CDM' ); 
UPDATE t_lic_module_version SET fnameversion = '票据管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'CDM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401110029313, '票据管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'CDM' 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 = 'CDM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDIPBZW', 'GLang', '票据管理' FROM t_lic_module m WHERE m.fnumber = 'CDM' 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 = 'CDM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDIPB=M', 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 = 'CDM' 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 = 'CDM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDIPBZX', 'zh_CN', '票据管理' FROM t_lic_module m WHERE m.fnumber = 'CDM' 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 = 'CDM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDIPB=N', 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 = 'CDM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '贷款管理', fgroupid = 401 WHERE fnumber = 'CFM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 123, 'CFM', '贷款管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'CFM' ); 
UPDATE t_lic_module_version SET fnameversion = '贷款管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'CFM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401110030340, '贷款管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'CFM' 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 = 'CFM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDIPB=O', 'GLang', '贷款管理' FROM t_lic_module m WHERE m.fnumber = 'CFM' 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 = 'CFM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDIPBZZ', 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 = 'CFM' 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 = 'CFM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDIPB=P', 'zh_CN', '贷款管理' FROM t_lic_module m WHERE m.fnumber = 'CFM' 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 = 'CFM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDIPC++', 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 = 'CFM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '投资理财', fgroupid = 401 WHERE fnumber = 'CIM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 124, 'CIM', '投资理财', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'CIM' ); 
UPDATE t_lic_module_version SET fnameversion = '投资理财' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'CIM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401110029318, '投资理财', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'CIM' 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 = 'CIM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDIPC+/', 'GLang', '投资理财' FROM t_lic_module m WHERE m.fnumber = 'CIM' 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 = 'CIM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDIPB=R', 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 = 'CIM' 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 = 'CIM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDIPC+0', 'zh_CN', '投资理财' FROM t_lic_module m WHERE m.fnumber = 'CIM' 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 = 'CIM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDIPB=S', 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 = 'CIM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '合并报表', fgroupid = 401 WHERE fnumber = 'CM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 125, 'CM', '合并报表', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'CM' ); 
UPDATE t_lic_module_version SET fnameversion = '合并报表' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'CM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401110030345, '合并报表', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'CM' 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 = 'CM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDIPB=T', 'GLang', '合并报表' FROM t_lic_module m WHERE m.fnumber = 'CM' 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 = 'CM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDIPC+2', 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 = 'CM' 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 = 'CM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDIPB=U', 'zh_CN', '合并报表' FROM t_lic_module m WHERE m.fnumber = 'CM' 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 = 'CM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDIPC+3', 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 = 'CM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '合同管理', fgroupid = 401 WHERE fnumber = 'CONM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 127, 'CONM', '合同管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'CONM' ); 
UPDATE t_lic_module_version SET fnameversion = '合同管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'CONM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401110029323, '合同管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'CONM' 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 = 'CONM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDIPC+4', 'GLang', '合同管理' FROM t_lic_module m WHERE m.fnumber = 'CONM' 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 = 'CONM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDIPB=W', 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 = 'CONM' 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 = 'CONM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDIPC+5', 'zh_CN', '合同管理' FROM t_lic_module m WHERE m.fnumber = 'CONM' 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 = 'CONM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDIPB=X', 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 = 'CONM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '费用预算', fgroupid = 401 WHERE fnumber = 'EB'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 128, 'EB', '费用预算', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'EB' ); 
UPDATE t_lic_module_version SET fnameversion = '费用预算' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'EB' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401110030350, '费用预算', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'EB' 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 = 'EB'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDIPB=Y', 'GLang', '费用预算' FROM t_lic_module m WHERE m.fnumber = 'EB' 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 = 'EB')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDMAS5B', 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 = 'EB' 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 = 'EB'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDMARH2', 'zh_CN', '费用预算' FROM t_lic_module m WHERE m.fnumber = 'EB' 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 = 'EB')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDMAS5C', 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 = 'EB' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '对标分析', fgroupid = 401 WHERE fnumber = 'EBA'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 129, 'EBA', '对标分析', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'EBA' ); 
UPDATE t_lic_module_version SET fnameversion = '对标分析' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'EBA' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401118417921, '对标分析', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'EBA' 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 = 'EBA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDMAS5D', 'GLang', '对标分析' FROM t_lic_module m WHERE m.fnumber = 'EBA' 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 = 'EBA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDMARH4', 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 = 'EBA' 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 = 'EBA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDMAS5E', 'zh_CN', '对标分析' FROM t_lic_module m WHERE m.fnumber = 'EBA' 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 = 'EBA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDMARH5', 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 = 'EBA' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '服务成本核算', fgroupid = 401 WHERE fnumber = 'ECA'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 130, 'ECA', '服务成本核算', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'ECA' ); 
UPDATE t_lic_module_version SET fnameversion = '服务成本核算' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'ECA' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401118418948, '服务成本核算', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'ECA' 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 = 'ECA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDMARH6', 'GLang', '服务成本核算' FROM t_lic_module m WHERE m.fnumber = 'ECA' 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 = 'ECA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDMAS5G', 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 = 'ECA' 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 = 'ECA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDMARH7', 'zh_CN', '服务成本核算' FROM t_lic_module m WHERE m.fnumber = 'ECA' 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 = 'ECA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDMAS5H', 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 = 'ECA' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '会计事件库', fgroupid = 401 WHERE fnumber = 'EDAH'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 131, 'EDAH', '会计事件库', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'EDAH' ); 
UPDATE t_lic_module_version SET fnameversion = '会计事件库' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'EDAH' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401118417926, '会计事件库', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'EDAH' 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 = 'EDAH'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDMAS5I', 'GLang', '会计事件库' FROM t_lic_module m WHERE m.fnumber = 'EDAH' 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 = 'EDAH')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDMARH9', 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 = 'EDAH' 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 = 'EDAH'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDMAS5J', 'zh_CN', '会计事件库' FROM t_lic_module m WHERE m.fnumber = 'EDAH' 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 = 'EDAH')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDMARH=', 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 = 'EDAH' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '费用核算', fgroupid = 401 WHERE fnumber = 'EM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 132, 'EM', '费用核算', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'EM' ); 
UPDATE t_lic_module_version SET fnameversion = '费用核算' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'EM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401118418953, '费用核算', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'EM' 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 = 'EM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDMARHA', 'GLang', '费用核算' FROM t_lic_module m WHERE m.fnumber = 'EM' 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 = 'EM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDMAS5L', 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 = 'EM' 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 = 'EM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDMARHB', 'zh_CN', '费用核算' FROM t_lic_module m WHERE m.fnumber = 'EM' 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 = 'EM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDMAS5M', 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 = 'EM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '管理报告', fgroupid = 401 WHERE fnumber = 'EMR'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 133, 'EMR', '管理报告', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'EMR' ); 
UPDATE t_lic_module_version SET fnameversion = '管理报告' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'EMR' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401118417931, '管理报告', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'EMR' 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 = 'EMR'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDMAS5N', 'GLang', '管理报告' FROM t_lic_module m WHERE m.fnumber = 'EMR' 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 = 'EMR')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDMARHD', 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 = 'EMR' 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 = 'EMR'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDMAS5O', 'zh_CN', '管理报告' FROM t_lic_module m WHERE m.fnumber = 'EMR' 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 = 'EMR')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDMARHE', 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 = 'EMR' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = 'EPM数据管理', fgroupid = 401 WHERE fnumber = 'EPDM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 134, 'EPDM', 'EPM数据管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'EPDM' ); 
UPDATE t_lic_module_version SET fnameversion = 'EPM数据管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'EPDM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401118418958, 'EPM数据管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'EPDM' AND NOT EXISTS ( SELECT 1 FROM t_lic_module_version lmv WHERE lm.fid = lmv.fid ); 
UPDATE t_lic_module_l SET fname = 'EPM数据管理' WHERE flocaleid = 'GLang' AND fid IN (SELECT fid FROM t_lic_module WHERE fnumber = 'EPDM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDMARHF', 'GLang', 'EPM数据管理' FROM t_lic_module m WHERE m.fnumber = 'EPDM' 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 = 'EPM数据管理' WHERE flocaleid = 'GLang' AND fentryid IN ( SELECT fentryid FROM t_lic_module_version WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'EPDM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDMAS5Q', v.fentryid, 'GLang', 'EPM数据管理' 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 = 'EPDM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module_l SET fname = 'EPM数据管理' WHERE flocaleid = 'zh_CN' AND fid IN (SELECT fid FROM t_lic_module WHERE fnumber = 'EPDM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDMARHG', 'zh_CN', 'EPM数据管理' FROM t_lic_module m WHERE m.fnumber = 'EPDM' 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 = 'EPM数据管理' 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 = 'EPDM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDPZ6BV', v.fentryid, 'zh_CN', 'EPM数据管理' 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 = 'EPDM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = 'EPM客户端', fgroupid = 401 WHERE fnumber = 'EPMC'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 135, 'EPMC', 'EPM客户端', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'EPMC' ); 
UPDATE t_lic_module_version SET fnameversion = 'EPM客户端' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'EPMC' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401126806528, 'EPM客户端', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'EPMC' AND NOT EXISTS ( SELECT 1 FROM t_lic_module_version lmv WHERE lm.fid = lmv.fid ); 
UPDATE t_lic_module_l SET fname = 'EPM客户端' WHERE flocaleid = 'GLang' AND fid IN (SELECT fid FROM t_lic_module WHERE fnumber = 'EPMC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDPZ6BW', 'GLang', 'EPM客户端' FROM t_lic_module m WHERE m.fnumber = 'EPMC' 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 = 'EPM客户端' WHERE flocaleid = 'GLang' AND fentryid IN ( SELECT fentryid FROM t_lic_module_version WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'EPMC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDPZ5OM', v.fentryid, 'GLang', 'EPM客户端' 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 = 'EPMC' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module_l SET fname = 'EPM客户端' WHERE flocaleid = 'zh_CN' AND fid IN (SELECT fid FROM t_lic_module WHERE fnumber = 'EPMC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDPZ6BX', 'zh_CN', 'EPM客户端' FROM t_lic_module m WHERE m.fnumber = 'EPMC' 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 = 'EPM客户端' 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 = 'EPMC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDPZ5ON', v.fentryid, 'zh_CN', 'EPM客户端' 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 = 'EPMC' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = 'EPM凭证池', fgroupid = 401 WHERE fnumber = 'EPML'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 136, 'EPML', 'EPM凭证池', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'EPML' ); 
UPDATE t_lic_module_version SET fnameversion = 'EPM凭证池' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'EPML' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401126807555, 'EPM凭证池', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'EPML' AND NOT EXISTS ( SELECT 1 FROM t_lic_module_version lmv WHERE lm.fid = lmv.fid ); 
UPDATE t_lic_module_l SET fname = 'EPM凭证池' WHERE flocaleid = 'GLang' AND fid IN (SELECT fid FROM t_lic_module WHERE fnumber = 'EPML'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDPZ5OO', 'GLang', 'EPM凭证池' FROM t_lic_module m WHERE m.fnumber = 'EPML' 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 = 'EPM凭证池' WHERE flocaleid = 'GLang' AND fentryid IN ( SELECT fentryid FROM t_lic_module_version WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'EPML')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDPZ6BZ', v.fentryid, 'GLang', 'EPM凭证池' 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 = 'EPML' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module_l SET fname = 'EPM凭证池' WHERE flocaleid = 'zh_CN' AND fid IN (SELECT fid FROM t_lic_module WHERE fnumber = 'EPML'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDPZ5OP', 'zh_CN', 'EPM凭证池' FROM t_lic_module m WHERE m.fnumber = 'EPML' 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 = 'EPM凭证池' 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 = 'EPML')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDPZ6C+', v.fentryid, 'zh_CN', 'EPM凭证池' 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 = 'EPML' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '电子凭证池', fgroupid = 401 WHERE fnumber = 'EVP'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 137, 'EVP', '电子凭证池', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'EVP' ); 
UPDATE t_lic_module_version SET fnameversion = '电子凭证池' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'EVP' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401126806533, '电子凭证池', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'EVP' 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 = 'EVP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDPZ6C/', 'GLang', '电子凭证池' FROM t_lic_module m WHERE m.fnumber = 'EVP' 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 = 'EVP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDPZ5OR', 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 = 'EVP' 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 = 'EVP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDPZ6C0', 'zh_CN', '电子凭证池' FROM t_lic_module m WHERE m.fnumber = 'EVP' 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 = 'EVP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDPZ5OS', 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 = 'EVP' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '固定资产', fgroupid = 401 WHERE fnumber = 'FA'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 138, 'FA', '固定资产', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'FA' ); 
UPDATE t_lic_module_version SET fnameversion = '固定资产' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'FA' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401126807560, '固定资产', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'FA' 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 = 'FA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDPZ5OT', 'GLang', '固定资产' FROM t_lic_module m WHERE m.fnumber = 'FA' 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 = 'FA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDPZ6C2', 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 = 'FA' 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 = 'FA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDPZ5OU', 'zh_CN', '固定资产' FROM t_lic_module m WHERE m.fnumber = 'FA' 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 = 'FA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDPZ6C3', 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 = 'FA' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '财务分析基础服务', fgroupid = 401 WHERE fnumber = 'FAF'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 139, 'FAF', '财务分析基础服务', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'FAF' ); 
UPDATE t_lic_module_version SET fnameversion = '财务分析基础服务' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'FAF' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401126806538, '财务分析基础服务', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'FAF' 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 = 'FAF'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDPZ6C4', 'GLang', '财务分析基础服务' FROM t_lic_module m WHERE m.fnumber = 'FAF' 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 = 'FAF')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDPZ5OW', 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 = 'FAF' 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 = 'FAF'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDPZ6C5', 'zh_CN', '财务分析基础服务' FROM t_lic_module m WHERE m.fnumber = 'FAF' 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 = 'FAF')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDPZ5OX', 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 = 'FAF' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '企业绩效分析', fgroupid = 401 WHERE fnumber = 'FAR'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 140, 'FAR', '企业绩效分析', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'FAR' ); 
UPDATE t_lic_module_version SET fnameversion = '企业绩效分析' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'FAR' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401126807565, '企业绩效分析', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'FAR' 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 = 'FAR'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDPZ5OY', 'GLang', '企业绩效分析' FROM t_lic_module m WHERE m.fnumber = 'FAR' 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 = 'FAR')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDPZ6C7', 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 = 'FAR' 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 = 'FAR'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDTKKW3', 'zh_CN', '企业绩效分析' FROM t_lic_module m WHERE m.fnumber = 'FAR' 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 = 'FAR')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDTKLJC', 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 = 'FAR' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '资金调度', fgroupid = 401 WHERE fnumber = 'FCA'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 141, 'FCA', '资金调度', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'FCA' ); 
UPDATE t_lic_module_version SET fnameversion = '资金调度' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'FCA' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401135195137, '资金调度', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'FCA' 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 = 'FCA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDTKLJD', 'GLang', '资金调度' FROM t_lic_module m WHERE m.fnumber = 'FCA' 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 = 'FCA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDTKKW5', 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 = 'FCA' 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 = 'FCA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDTKLJE', 'zh_CN', '资金调度' FROM t_lic_module m WHERE m.fnumber = 'FCA' 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 = 'FCA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDTKKW6', 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 = 'FCA' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '披露管理', fgroupid = 401 WHERE fnumber = 'FIDM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 142, 'FIDM', '披露管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'FIDM' ); 
UPDATE t_lic_module_version SET fnameversion = '披露管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'FIDM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401135196163, '披露管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'FIDM' 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 = 'FIDM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDTKKW7', 'GLang', '披露管理' FROM t_lic_module m WHERE m.fnumber = 'FIDM' 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 = 'FIDM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDTKLJG', 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 = 'FIDM' 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 = 'FIDM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDTKKW8', 'zh_CN', '披露管理' FROM t_lic_module m WHERE m.fnumber = 'FIDM' 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 = 'FIDM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDTKLJH', 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 = 'FIDM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '资金计划', fgroupid = 401 WHERE fnumber = 'FPM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 143, 'FPM', '资金计划', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'FPM' ); 
UPDATE t_lic_module_version SET fnameversion = '资金计划' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'FPM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401135195142, '资金计划', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'FPM' 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 = 'FPM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDTKLJI', 'GLang', '资金计划' FROM t_lic_module m WHERE m.fnumber = 'FPM' 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 = 'FPM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDTKKW=', 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 = 'FPM' 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 = 'FPM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDTKLJJ', 'zh_CN', '资金计划' FROM t_lic_module m WHERE m.fnumber = 'FPM' 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 = 'FPM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDTKKWA', 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 = 'FPM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '财务报账', fgroupid = 401 WHERE fnumber = 'FR'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 144, 'FR', '财务报账', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'FR' ); 
UPDATE t_lic_module_version SET fnameversion = '财务报账' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'FR' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401135196168, '财务报账', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'FR' 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 = 'FR'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDTKKWB', 'GLang', '财务报账' FROM t_lic_module m WHERE m.fnumber = 'FR' 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 = 'FR')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDTKLJL', 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 = 'FR' 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 = 'FR'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDTKKWC', 'zh_CN', '财务报账' FROM t_lic_module m WHERE m.fnumber = 'FR' 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 = 'FR')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDTKLJM', 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 = 'FR' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '财务报表分析', fgroupid = 401 WHERE fnumber = 'FSA'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 145, 'FSA', '财务报表分析', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'FSA' ); 
UPDATE t_lic_module_version SET fnameversion = '财务报表分析' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'FSA' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401135195147, '财务报表分析', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'FSA' 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 = 'FSA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDTKLJN', 'GLang', '财务报表分析' FROM t_lic_module m WHERE m.fnumber = 'FSA' 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 = 'FSA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDTKKWE', 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 = 'FSA' 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 = 'FSA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDTKLJO', 'zh_CN', '财务报表分析' FROM t_lic_module m WHERE m.fnumber = 'FSA' 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 = 'FSA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDTKKWF', 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 = 'FSA' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '总账', fgroupid = 401 WHERE fnumber = 'GL'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 146, 'GL', '总账', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'GL' ); 
UPDATE t_lic_module_version SET fnameversion = '总账' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'GL' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401135196173, '总账', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'GL' 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 = 'GL'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDTKKWG', 'GLang', '总账' FROM t_lic_module m WHERE m.fnumber = 'GL' 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 = 'GL')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDX7/QW', 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 = 'GL' 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 = 'GL'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDX7/1M', 'zh_CN', '总账' FROM t_lic_module m WHERE m.fnumber = 'GL' 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 = 'GL')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDX7/QX', 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 = 'GL' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '担保管理', fgroupid = 401 WHERE fnumber = 'GM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 147, 'GM', '担保管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'GM' ); 
UPDATE t_lic_module_version SET fnameversion = '担保管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'GM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401143583745, '担保管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'GM' 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 = 'GM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDX7/QY', 'GLang', '担保管理' FROM t_lic_module m WHERE m.fnumber = 'GM' 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 = 'GM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDX7/1O', 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 = 'GM' 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 = 'GM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDX7/QZ', 'zh_CN', '担保管理' FROM t_lic_module m WHERE m.fnumber = 'GM' 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 = 'GM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDX7/1P', 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 = 'GM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '内部交易对账', fgroupid = 401 WHERE fnumber = 'ICT'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 148, 'ICT', '内部交易对账', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'ICT' ); 
UPDATE t_lic_module_version SET fnameversion = '内部交易对账' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'ICT' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401143584772, '内部交易对账', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'ICT' 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 = 'ICT'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDX7/1Q', 'GLang', '内部交易对账' FROM t_lic_module m WHERE m.fnumber = 'ICT' 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 = 'ICT')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDX7/R/', 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 = 'ICT' 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 = 'ICT'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDX7/1R', 'zh_CN', '内部交易对账' FROM t_lic_module m WHERE m.fnumber = 'ICT' 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 = 'ICT')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDX7/R0', 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 = 'ICT' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '内部金融', fgroupid = 401 WHERE fnumber = 'IFM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 149, 'IFM', '内部金融', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'IFM' ); 
UPDATE t_lic_module_version SET fnameversion = '内部金融' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'IFM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401143583750, '内部金融', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'IFM' 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 = 'IFM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDX7/R1', 'GLang', '内部金融' FROM t_lic_module m WHERE m.fnumber = 'IFM' 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 = 'IFM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDX7/1T', 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 = 'IFM' 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 = 'IFM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDX7/R2', 'zh_CN', '内部金融' FROM t_lic_module m WHERE m.fnumber = 'IFM' 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 = 'IFM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDX7/1U', 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 = 'IFM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '库存管理', fgroupid = 401 WHERE fnumber = 'IM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 150, 'IM', '库存管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'IM' ); 
UPDATE t_lic_module_version SET fnameversion = '库存管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'IM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401143584777, '库存管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'IM' 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 = 'IM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDX7/1V', 'GLang', '库存管理' FROM t_lic_module m WHERE m.fnumber = 'IM' 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 = 'IM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDX7/R4', 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 = 'IM' 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 = 'IM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDX7/1W', 'zh_CN', '库存管理' FROM t_lic_module m WHERE m.fnumber = 'IM' 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 = 'IM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDX7/R5', 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 = 'IM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '库存计划', fgroupid = 401 WHERE fnumber = 'INVP'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 151, 'INVP', '库存计划', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'INVP' ); 
UPDATE t_lic_module_version SET fnameversion = '库存计划' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'INVP' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401143583755, '库存计划', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'INVP' 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 = 'INVP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCDX7/R6', 'GLang', '库存计划' FROM t_lic_module m WHERE m.fnumber = 'INVP' 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 = 'INVP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCDX7/1Y', 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 = 'INVP' 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 = 'INVP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE+UEYD', 'zh_CN', '库存计划' FROM t_lic_module m WHERE m.fnumber = 'INVP' 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 = 'INVP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE+UE94', 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 = 'INVP' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '组织间结算', fgroupid = 401 WHERE fnumber = 'ISM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 152, 'ISM', '组织间结算', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'ISM' ); 
UPDATE t_lic_module_version SET fnameversion = '组织间结算' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'ISM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401151973377, '组织间结算', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'ISM' 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 = 'ISM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE+UE95', 'GLang', '组织间结算' FROM t_lic_module m WHERE m.fnumber = 'ISM' 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 = 'ISM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE+UEYF', 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 = 'ISM' 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 = 'ISM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE+UE96', 'zh_CN', '组织间结算' FROM t_lic_module m WHERE m.fnumber = 'ISM' 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 = 'ISM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE+UEYG', 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 = 'ISM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '信用证', fgroupid = 401 WHERE fnumber = 'LC'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 153, 'LC', '信用证', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'LC' ); 
UPDATE t_lic_module_version SET fnameversion = '信用证' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'LC' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401151972355, '信用证', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'LC' 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 = 'LC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE+UEYH', 'GLang', '信用证' FROM t_lic_module m WHERE m.fnumber = 'LC' 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 = 'LC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE+UE98', 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 = 'LC' 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 = 'LC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE+UEYI', 'zh_CN', '信用证' FROM t_lic_module m WHERE m.fnumber = 'LC' 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 = 'LC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE+UE99', 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 = 'LC' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '需求管理', fgroupid = 401 WHERE fnumber = 'MDS'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 154, 'MDS', '需求管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'MDS' ); 
UPDATE t_lic_module_version SET fnameversion = '需求管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'MDS' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401151973382, '需求管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'MDS' 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 = 'MDS'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE+UE9=', 'GLang', '需求管理' FROM t_lic_module m WHERE m.fnumber = 'MDS' 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 = 'MDS')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE+UEYK', 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 = 'MDS' 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 = 'MDS'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE+UE9A', 'zh_CN', '需求管理' FROM t_lic_module m WHERE m.fnumber = 'MDS' 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 = 'MDS')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE+UEYL', 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 = 'MDS' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '资金监控', fgroupid = 401 WHERE fnumber = 'MON'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 155, 'MON', '资金监控', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'MON' ); 
UPDATE t_lic_module_version SET fnameversion = '资金监控' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'MON' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401151972360, '资金监控', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'MON' 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 = 'MON'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE+UEYM', 'GLang', '资金监控' FROM t_lic_module m WHERE m.fnumber = 'MON' 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 = 'MON')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE+UE9C', 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 = 'MON' 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 = 'MON'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE+UEYN', 'zh_CN', '资金监控' FROM t_lic_module m WHERE m.fnumber = 'MON' 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 = 'MON')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE+UE9D', 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 = 'MON' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '主生产计划', fgroupid = 401 WHERE fnumber = 'MPS'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 156, 'MPS', '主生产计划', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'MPS' ); 
UPDATE t_lic_module_version SET fnameversion = '主生产计划' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'MPS' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401151973387, '主生产计划', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'MPS' 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 = 'MPS'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE+UE9E', 'GLang', '主生产计划' FROM t_lic_module m WHERE m.fnumber = 'MPS' 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 = 'MPS')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE+UEYP', 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 = 'MPS' 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 = 'MPS'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE+UE9F', 'zh_CN', '主生产计划' FROM t_lic_module m WHERE m.fnumber = 'MPS' 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 = 'MPS')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE+UEYQ', 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 = 'MPS' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '物料需求计划', fgroupid = 401 WHERE fnumber = 'MRP'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 157, 'MRP', '物料需求计划', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'MRP' ); 
UPDATE t_lic_module_version SET fnameversion = '物料需求计划' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'MRP' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401151972365, '物料需求计划', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'MRP' 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 = 'MRP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FV3X', 'GLang', '物料需求计划' FROM t_lic_module m WHERE m.fnumber = 'MRP' 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 = 'MRP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FUFN', 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 = 'MRP' 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 = 'MRP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FV3Y', 'zh_CN', '物料需求计划' FROM t_lic_module m WHERE m.fnumber = 'MRP' 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 = 'MRP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FUFO', 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 = 'MRP' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '委外管理', fgroupid = 401 WHERE fnumber = 'OM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 158, 'OM', '委外管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'OM' ); 
UPDATE t_lic_module_version SET fnameversion = '委外管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'OM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401160361986, '委外管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'OM' 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 = 'OM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FUFQ', 'GLang', '委外管理' FROM t_lic_module m WHERE m.fnumber = 'OM' 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 = 'OM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FV4/', 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 = 'OM' 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 = 'OM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FUFR', 'zh_CN', '委外管理' FROM t_lic_module m WHERE m.fnumber = 'OM' 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 = 'OM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FV40', 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 = 'OM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '工序委外管理', fgroupid = 401 WHERE fnumber = 'OPM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 159, 'OPM', '工序委外管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'OPM' ); 
UPDATE t_lic_module_version SET fnameversion = '工序委外管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'OPM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401160360965, '工序委外管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'OPM' 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 = 'OPM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FV41', 'GLang', '工序委外管理' FROM t_lic_module m WHERE m.fnumber = 'OPM' 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 = 'OPM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FUFT', 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 = 'OPM' 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 = 'OPM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FV42', 'zh_CN', '工序委外管理' FROM t_lic_module m WHERE m.fnumber = 'OPM' 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 = 'OPM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FUFU', 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 = 'OPM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '盈利能力分析', fgroupid = 401 WHERE fnumber = 'PA'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 160, 'PA', '盈利能力分析', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'PA' ); 
UPDATE t_lic_module_version SET fnameversion = '盈利能力分析' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'PA' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401160361992, '盈利能力分析', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'PA' 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 = 'PA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FUFV', 'GLang', '盈利能力分析' FROM t_lic_module m WHERE m.fnumber = 'PA' 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 = 'PA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FV44', 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 = 'PA' 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 = 'PA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FUFW', 'zh_CN', '盈利能力分析' FROM t_lic_module m WHERE m.fnumber = 'PA' 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 = 'PA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FV45', 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 = 'PA' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '采购合同', fgroupid = 401 WHERE fnumber = 'PCM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 161, 'PCM', '采购合同', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'PCM' ); 
UPDATE t_lic_module_version SET fnameversion = '采购合同' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'PCM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401160360970, '采购合同', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'PCM' 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 = 'PCM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FV46', 'GLang', '采购合同' FROM t_lic_module m WHERE m.fnumber = 'PCM' 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 = 'PCM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FUFY', 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 = 'PCM' 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 = 'PCM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FV47', 'zh_CN', '采购合同' FROM t_lic_module m WHERE m.fnumber = 'PCM' 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 = 'PCM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FUFZ', 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 = 'PCM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '产品数据管理', fgroupid = 401 WHERE fnumber = 'PDM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 162, 'PDM', '产品数据管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'PDM' ); 
UPDATE t_lic_module_version SET fnameversion = '产品数据管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'PDM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401160361997, '产品数据管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'PDM' 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 = 'PDM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FUG/', 'GLang', '产品数据管理' FROM t_lic_module m WHERE m.fnumber = 'PDM' 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 = 'PDM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FV4=', 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 = 'PDM' 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 = 'PDM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FUG0', 'zh_CN', '产品数据管理' FROM t_lic_module m WHERE m.fnumber = 'PDM' 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 = 'PDM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FV4A', 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 = 'PDM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '采购管理', fgroupid = 401 WHERE fnumber = 'PM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 163, 'PM', '采购管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'PM' ); 
UPDATE t_lic_module_version SET fnameversion = '采购管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'PM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401160360976, '采购管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'PM' 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 = 'PM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FV4B', 'GLang', '采购管理' FROM t_lic_module m WHERE m.fnumber = 'PM' 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 = 'PM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FUG2', 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 = 'PM' 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 = 'PM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FV4C', 'zh_CN', '采购管理' FROM t_lic_module m WHERE m.fnumber = 'PM' 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 = 'PM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FUG3', 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 = 'PM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '采购价格', fgroupid = 401 WHERE fnumber = 'PMP'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 164, 'PMP', '采购价格', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'PMP' ); 
UPDATE t_lic_module_version SET fnameversion = '采购价格' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'PMP' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401160362003, '采购价格', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'PMP' 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 = 'PMP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FUG4', 'GLang', '采购价格' FROM t_lic_module m WHERE m.fnumber = 'PMP' 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 = 'PMP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FV4E', 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 = 'PMP' 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 = 'PMP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE2FUG5', 'zh_CN', '采购价格' FROM t_lic_module m WHERE m.fnumber = 'PMP' 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 = 'PMP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE2FV4F', 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 = 'PMP' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '项目策划', fgroupid = 401 WHERE fnumber = 'PMPD'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 165, 'PMPD', '项目策划', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'PMPD' ); 
UPDATE t_lic_module_version SET fnameversion = '项目策划' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'PMPD' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401168749568, '项目策划', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'PMPD' 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 = 'PMPD'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE629AE', 'GLang', '项目策划' FROM t_lic_module m WHERE m.fnumber = 'PMPD' 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 = 'PMPD')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE628N6', 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 = 'PMPD' 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 = 'PMPD'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE629AF', 'zh_CN', '项目策划' FROM t_lic_module m WHERE m.fnumber = 'PMPD' 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 = 'PMPD')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE628N7', 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 = 'PMPD' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '销售价格', fgroupid = 401 WHERE fnumber = 'PMS'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 166, 'PMS', '销售价格', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'PMS' ); 
UPDATE t_lic_module_version SET fnameversion = '销售价格' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'PMS' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401168750594, '销售价格', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'PMS' 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 = 'PMS'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE628N8', 'GLang', '销售价格' FROM t_lic_module m WHERE m.fnumber = 'PMS' 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 = 'PMS')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE629AH', 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 = 'PMS' 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 = 'PMS'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE628N9', 'zh_CN', '销售价格' FROM t_lic_module m WHERE m.fnumber = 'PMS' 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 = 'PMS')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE629AI', 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 = 'PMS' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '项目任务与进度计划', fgroupid = 401 WHERE fnumber = 'PMTS'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 167, 'PMTS', '项目任务与进度计划', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'PMTS' ); 
UPDATE t_lic_module_version SET fnameversion = '项目任务与进度计划' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'PMTS' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401168749573, '项目任务与进度计划', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'PMTS' 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 = 'PMTS'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE629AJ', 'GLang', '项目任务与进度计划' FROM t_lic_module m WHERE m.fnumber = 'PMTS' 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 = 'PMTS')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE628NA', 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 = 'PMTS' 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 = 'PMTS'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE629AK', 'zh_CN', '项目任务与进度计划' FROM t_lic_module m WHERE m.fnumber = 'PMTS' 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 = 'PMTS')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE628NB', 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 = 'PMTS' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '生产管理', fgroupid = 401 WHERE fnumber = 'POM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 168, 'POM', '生产管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'POM' ); 
UPDATE t_lic_module_version SET fnameversion = '生产管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'POM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401168750599, '生产管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'POM' 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 = 'POM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE628ND', 'GLang', '生产管理' FROM t_lic_module m WHERE m.fnumber = 'POM' 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 = 'POM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE629AN', 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 = 'POM' 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 = 'POM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE628NE', 'zh_CN', '生产管理' FROM t_lic_module m WHERE m.fnumber = 'POM' 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 = 'POM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE629AO', 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 = 'POM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '付款排程', fgroupid = 401 WHERE fnumber = 'PSD'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 169, 'PSD', '付款排程', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'PSD' ); 
UPDATE t_lic_module_version SET fnameversion = '付款排程' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'PSD' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401168749579, '付款排程', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'PSD' 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 = 'PSD'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE629AP', 'GLang', '付款排程' FROM t_lic_module m WHERE m.fnumber = 'PSD' 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 = 'PSD')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE628NG', 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 = 'PSD' 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 = 'PSD'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE629AQ', 'zh_CN', '付款排程' FROM t_lic_module m WHERE m.fnumber = 'PSD' 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 = 'PSD')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE628NH', 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 = 'PSD' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '销售检验', fgroupid = 401 WHERE fnumber = 'QCAS'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 170, 'QCAS', '销售检验', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'QCAS' ); 
UPDATE t_lic_module_version SET fnameversion = '销售检验' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'QCAS' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401168750605, '销售检验', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'QCAS' 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 = 'QCAS'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE628NJ', 'GLang', '销售检验' FROM t_lic_module m WHERE m.fnumber = 'QCAS' 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 = 'QCAS')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE629AT', 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 = 'QCAS' 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 = 'QCAS'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE628NK', 'zh_CN', '销售检验' FROM t_lic_module m WHERE m.fnumber = 'QCAS' 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 = 'QCAS')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE629AU', 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 = 'QCAS' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '在库检验', fgroupid = 401 WHERE fnumber = 'QCNP'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 171, 'QCNP', '在库检验', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'QCNP' ); 
UPDATE t_lic_module_version SET fnameversion = '在库检验' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'QCNP' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401168749585, '在库检验', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'QCNP' 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 = 'QCNP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE629AW', 'GLang', '在库检验' FROM t_lic_module m WHERE m.fnumber = 'QCNP' 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 = 'QCNP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE628NN', 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 = 'QCNP' 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 = 'QCNP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE629AX', 'zh_CN', '在库检验' FROM t_lic_module m WHERE m.fnumber = 'QCNP' 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 = 'QCNP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE628NO', 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 = 'QCNP' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '来料检验', fgroupid = 401 WHERE fnumber = 'QCP'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 172, 'QCP', '来料检验', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'QCP' ); 
UPDATE t_lic_module_version SET fnameversion = '来料检验' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'QCP' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401168750612, '来料检验', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'QCP' 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 = 'QCP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE628NQ', 'GLang', '来料检验' FROM t_lic_module m WHERE m.fnumber = 'QCP' 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 = 'QCP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE629B+', 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 = 'QCP' 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 = 'QCP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE628NR', 'zh_CN', '来料检验' FROM t_lic_module m WHERE m.fnumber = 'QCP' 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 = 'QCP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE629B/', 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 = 'QCP' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '生产检验', fgroupid = 401 WHERE fnumber = 'QCPP'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 173, 'QCPP', '生产检验', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'QCPP' ); 
UPDATE t_lic_module_version SET fnameversion = '生产检验' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'QCPP' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401168749592, '生产检验', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'QCPP' 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 = 'QCPP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE629B1', 'GLang', '生产检验' FROM t_lic_module m WHERE m.fnumber = 'QCPP' 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 = 'QCPP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE628NU', 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 = 'QCPP' 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 = 'QCPP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE629B2', 'zh_CN', '生产检验' FROM t_lic_module m WHERE m.fnumber = 'QCPP' 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 = 'QCPP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE628NV', 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 = 'QCPP' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '质量改善管理', fgroupid = 401 WHERE fnumber = 'QCQI'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 174, 'QCQI', '质量改善管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'QCQI' ); 
UPDATE t_lic_module_version SET fnameversion = '质量改善管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'QCQI' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401168750619, '质量改善管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'QCQI' 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 = 'QCQI'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE628NW', 'GLang', '质量改善管理' FROM t_lic_module m WHERE m.fnumber = 'QCQI' 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 = 'QCQI')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE629B4', 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 = 'QCQI' 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 = 'QCQI'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE628NX', 'zh_CN', '质量改善管理' FROM t_lic_module m WHERE m.fnumber = 'QCQI' 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 = 'QCQI')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE629B5', 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 = 'QCQI' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '财务报表', fgroupid = 401 WHERE fnumber = 'RPT'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 175, 'RPT', '财务报表', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'RPT' ); 
UPDATE t_lic_module_version SET fnameversion = '财务报表' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'RPT' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401168749598, '财务报表', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'RPT' 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 = 'RPT'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE629B6', 'GLang', '财务报表' FROM t_lic_module m WHERE m.fnumber = 'RPT' 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 = 'RPT')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9PNUO', 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 = 'RPT' 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 = 'RPT'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9POHY', 'zh_CN', '财务报表' FROM t_lic_module m WHERE m.fnumber = 'RPT' 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 = 'RPT')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9PNUP', 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 = 'RPT' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '财务风险管理', fgroupid = 401 WHERE fnumber = 'RSA'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 176, 'RSA', '财务风险管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'RSA' ); 
UPDATE t_lic_module_version SET fnameversion = '财务风险管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'RSA' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401177139201, '财务风险管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'RSA' 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 = 'RSA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9PNUQ', 'GLang', '财务风险管理' FROM t_lic_module m WHERE m.fnumber = 'RSA' 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 = 'RSA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9POI+', 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 = 'RSA' 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 = 'RSA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9PNUR', 'zh_CN', '财务风险管理' FROM t_lic_module m WHERE m.fnumber = 'RSA' 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 = 'RSA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9POI/', 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 = 'RSA' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '标准成本', fgroupid = 401 WHERE fnumber = 'SCA'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 177, 'SCA', '标准成本', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'SCA' ); 
UPDATE t_lic_module_version SET fnameversion = '标准成本' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'SCA' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401177138180, '标准成本', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'SCA' 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 = 'SCA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9POI0', 'GLang', '标准成本' FROM t_lic_module m WHERE m.fnumber = 'SCA' 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 = 'SCA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9PNUT', 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 = 'SCA' 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 = 'SCA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9POI1', 'zh_CN', '标准成本' FROM t_lic_module m WHERE m.fnumber = 'SCA' 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 = 'SCA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9PNUU', 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 = 'SCA' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '委外采购', fgroupid = 401 WHERE fnumber = 'SCTM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 178, 'SCTM', '委外采购', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'SCTM' ); 
UPDATE t_lic_module_version SET fnameversion = '委外采购' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'SCTM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401177139206, '委外采购', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'SCTM' 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 = 'SCTM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9PNUV', 'GLang', '委外采购' FROM t_lic_module m WHERE m.fnumber = 'SCTM' 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 = 'SCTM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9POI3', 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 = 'SCTM' 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 = 'SCTM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9PNUW', 'zh_CN', '委外采购' FROM t_lic_module m WHERE m.fnumber = 'SCTM' 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 = 'SCTM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9POI4', 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 = 'SCTM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '车间管理', fgroupid = 401 WHERE fnumber = 'SFC'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 179, 'SFC', '车间管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'SFC' ); 
UPDATE t_lic_module_version SET fnameversion = '车间管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'SFC' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401177138185, '车间管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'SFC' 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 = 'SFC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9POI6', 'GLang', '车间管理' FROM t_lic_module m WHERE m.fnumber = 'SFC' 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 = 'SFC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9PNUZ', 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 = 'SFC' 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 = 'SFC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9POI7', 'zh_CN', '车间管理' FROM t_lic_module m WHERE m.fnumber = 'SFC' 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 = 'SFC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9PNV+', 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 = 'SFC' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '销售管理', fgroupid = 401 WHERE fnumber = 'SM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 180, 'SM', '销售管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'SM' ); 
UPDATE t_lic_module_version SET fnameversion = '销售管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'SM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401177139212, '销售管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'SM' 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 = 'SM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9PNV/', 'GLang', '销售管理' FROM t_lic_module m WHERE m.fnumber = 'SM' 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 = 'SM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9POI9', 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 = 'SM' 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 = 'SM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9PNV0', 'zh_CN', '销售管理' FROM t_lic_module m WHERE m.fnumber = 'SM' 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 = 'SM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9POI=', 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 = 'SM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '财务共享运营管理', fgroupid = 401 WHERE fnumber = 'SOM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 181, 'SOM', '财务共享运营管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'SOM' ); 
UPDATE t_lic_module_version SET fnameversion = '财务共享运营管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'SOM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401177138191, '财务共享运营管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'SOM' 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 = 'SOM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9POIB', 'GLang', '财务共享运营管理' FROM t_lic_module m WHERE m.fnumber = 'SOM' 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 = 'SOM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9PNV3', 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 = 'SOM' 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 = 'SOM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9POIC', 'zh_CN', '财务共享运营管理' FROM t_lic_module m WHERE m.fnumber = 'SOM' 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 = 'SOM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9PNV4', 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 = 'SOM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '财务共享任务中心', fgroupid = 401 WHERE fnumber = 'SSC'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 182, 'SSC', '财务共享任务中心', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'SSC' ); 
UPDATE t_lic_module_version SET fnameversion = '财务共享任务中心' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'SSC' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401177139218, '财务共享任务中心', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'SSC' 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 = 'SSC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9PNV6', 'GLang', '财务共享任务中心' FROM t_lic_module m WHERE m.fnumber = 'SSC' 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 = 'SSC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9POIF', 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 = 'SSC' 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 = 'SSC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9PNV7', 'zh_CN', '财务共享任务中心' FROM t_lic_module m WHERE m.fnumber = 'SSC' 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 = 'SSC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9POIG', 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 = 'SSC' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '资金决策分析', fgroupid = 401 WHERE fnumber = 'TDA'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 183, 'TDA', '资金决策分析', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'TDA' ); 
UPDATE t_lic_module_version SET fnameversion = '资金决策分析' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'TDA' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401177138198, '资金决策分析', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'TDA' 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 = 'TDA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9POIH', 'GLang', '资金决策分析' FROM t_lic_module m WHERE m.fnumber = 'TDA' 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 = 'TDA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9PNV9', 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 = 'TDA' 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 = 'TDA'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9POII', 'zh_CN', '资金决策分析' FROM t_lic_module m WHERE m.fnumber = 'TDA' 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 = 'TDA')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9PNV=', 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 = 'TDA' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '金融交易管理', fgroupid = 401 WHERE fnumber = 'TM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 184, 'TM', '金融交易管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'TM' ); 
UPDATE t_lic_module_version SET fnameversion = '金融交易管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'TM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401177139224, '金融交易管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'TM' 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 = 'TM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9PNVA', 'GLang', '金融交易管理' FROM t_lic_module m WHERE m.fnumber = 'TM' 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 = 'TM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9POIK', 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 = 'TM' 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 = 'TM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9PNVB', 'zh_CN', '金融交易管理' FROM t_lic_module m WHERE m.fnumber = 'TM' 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 = 'TM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9POIL', 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 = 'TM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '金融机构关系管理', fgroupid = 401 WHERE fnumber = 'TMBRM'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 185, 'TMBRM', '金融机构关系管理', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'TMBRM' ); 
UPDATE t_lic_module_version SET fnameversion = '金融机构关系管理' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'TMBRM' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401177138203, '金融机构关系管理', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'TMBRM' 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 = 'TMBRM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9POIM', 'GLang', '金融机构关系管理' FROM t_lic_module m WHERE m.fnumber = 'TMBRM' 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 = 'TMBRM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9PNVD', 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 = 'TMBRM' 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 = 'TMBRM'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9POIN', 'zh_CN', '金融机构关系管理' FROM t_lic_module m WHERE m.fnumber = 'TMBRM' 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 = 'TMBRM')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9PNVE', 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 = 'TMBRM' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = 'VMI采购', fgroupid = 401 WHERE fnumber = 'VMI'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 186, 'VMI', 'VMI采购', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'VMI' ); 
UPDATE t_lic_module_version SET fnameversion = 'VMI采购' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'VMI' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401177139229, 'VMI采购', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'VMI' AND NOT EXISTS ( SELECT 1 FROM t_lic_module_version lmv WHERE lm.fid = lmv.fid ); 
UPDATE t_lic_module_l SET fname = 'VMI采购' WHERE flocaleid = 'GLang' AND fid IN (SELECT fid FROM t_lic_module WHERE fnumber = 'VMI'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9PNVF', 'GLang', 'VMI采购' FROM t_lic_module m WHERE m.fnumber = 'VMI' 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 = 'VMI采购' WHERE flocaleid = 'GLang' AND fentryid IN ( SELECT fentryid FROM t_lic_module_version WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'VMI')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCE9POIP', v.fentryid, 'GLang', 'VMI采购' 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 = 'VMI' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module_l SET fname = 'VMI采购' WHERE flocaleid = 'zh_CN' AND fid IN (SELECT fid FROM t_lic_module WHERE fnumber = 'VMI'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCE9PNVG', 'zh_CN', 'VMI采购' FROM t_lic_module m WHERE m.fnumber = 'VMI' 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 = 'VMI采购' 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 = 'VMI')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCECB2PF', v.fentryid, 'zh_CN', 'VMI采购' 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 = 'VMI' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '流程生产', fgroupid = 401 WHERE fnumber = 'PROP'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 187, 'PROP', '流程生产', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'PROP' ); 
UPDATE t_lic_module_version SET fnameversion = '流程生产' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'PROP' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401185526784, '流程生产', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'PROP' 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 = 'PROP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCECB2PG', 'GLang', '流程生产' FROM t_lic_module m WHERE m.fnumber = 'PROP' 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 = 'PROP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCECB207', 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 = 'PROP' 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 = 'PROP'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCECB2PH', 'zh_CN', '流程生产' FROM t_lic_module m WHERE m.fnumber = 'PROP' 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 = 'PROP')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCECB208', 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 = 'PROP' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '融资租赁', fgroupid = 401 WHERE fnumber = 'FL'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 188, 'FL', '融资租赁', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'FL' ); 
UPDATE t_lic_module_version SET fnameversion = '融资租赁' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'FL' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401185527811, '融资租赁', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'FL' 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 = 'FL'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCECB209', 'GLang', '融资租赁' FROM t_lic_module m WHERE m.fnumber = 'FL' 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 = 'FL')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCECB2PJ', 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 = 'FL' 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 = 'FL'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCECB20=', 'zh_CN', '融资租赁' FROM t_lic_module m WHERE m.fnumber = 'FL' 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 = 'FL')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCECB2PK', 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 = 'FL' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '供应链移动应用', fgroupid = 401 WHERE fnumber = 'PRO_MOB_SCMC'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 2026326496116851712, 'PRO_MOB_SCMC', '供应链移动应用', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'PRO_MOB_SCMC' ); 
UPDATE t_lic_module_version SET fnameversion = '供应链移动应用' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'PRO_MOB_SCMC' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401185526789, '供应链移动应用', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'PRO_MOB_SCMC' 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 = 'PRO_MOB_SCMC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCECB2PM', 'GLang', '供应链移动应用' FROM t_lic_module m WHERE m.fnumber = 'PRO_MOB_SCMC' 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 = 'PRO_MOB_SCMC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCECB20C', 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 = 'PRO_MOB_SCMC' 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 = 'PRO_MOB_SCMC'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCECB2PN', 'zh_CN', '供应链移动应用' FROM t_lic_module m WHERE m.fnumber = 'PRO_MOB_SCMC' 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 = 'PRO_MOB_SCMC')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCECB20D', 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 = 'PRO_MOB_SCMC' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module SET fname = '共享洞察移动应用', fgroupid = 401 WHERE fnumber = 'SSC_MOB'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 2026894979540190208, 'SSC_MOB', '共享洞察移动应用', 401 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'SSC_MOB' ); 
UPDATE t_lic_module_version SET fnameversion = '共享洞察移动应用' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'SSC_MOB' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2042747401185527817, '共享洞察移动应用', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'SSC_MOB' 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 = 'SSC_MOB'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCECB20F', 'GLang', '共享洞察移动应用' FROM t_lic_module m WHERE m.fnumber = 'SSC_MOB' 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 = 'SSC_MOB')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCECB2PQ', 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 = 'SSC_MOB' 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 = 'SSC_MOB'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4DXLKCECB20G', 'zh_CN', '共享洞察移动应用' FROM t_lic_module m WHERE m.fnumber = 'SSC_MOB' 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 = 'SSC_MOB')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4DXLKCECB2PR', 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 = 'SSC_MOB' AND lmvl.fentryid IS NULL; 
