delete from t_lic_group_version_l where fentryid = (select fentryid from t_lic_group_version where fid = 2026183729222894592 and fversion = '7.0'); 
delete from t_lic_group_version where fid = 2026183729222894592 and fversion = '7.0' ; 
delete from t_lic_group where fid = 2026183729222894592 or fnumber = 'AI_GAIR'; 
delete from t_lic_group_l where fid = 2026183729222894592 ; 
insert into t_lic_group (fid,fnumber,ftype,fgroupdes) values (2026183729222894592,'AI_GAIR','1',' '); 
insert into t_lic_group_version (fid,fentryid,fnameversion,fgroupdesversion,fversion) values (2026183729222894592,2031852970215474177,'AI开发平台运行时',' ','7.0'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4CKE+UNT2RCQ',2026183729222894592,'zh_TW','AI開發平台運行時'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4CKE+UNT2QPG',2031852970215474177,'zh_TW','AI開發平台運行時'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4CKE+UNT2RCR',2026183729222894592,'GLang','AI开发平台运行时'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4CKE+UNT2QPH',2031852970215474177,'GLang','AI开发平台运行时'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4CKE+UNT2RCS',2026183729222894592,'zh_CN','AI开发平台运行时'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4CKE+UNT2QPI',2031852970215474177,'zh_CN','AI开发平台运行时'); 
update t_lic_group_version_l set fgroupdesversion = ' ' where flocaleid = 'zh_TW' and fentryid = 2031852970215474177; 
update t_lic_group_version_l set fgroupdesversion = ' ' where flocaleid = 'zh_CN' and fentryid = 2031852970215474177; 
delete from t_lic_group_version_l where fentryid = (select fentryid from t_lic_group_version where fid = 2031850972862744576 and fversion = '7.0'); 
delete from t_lic_group_version where fid = 2031850972862744576 and fversion = '7.0' ; 
delete from t_lic_group where fid = 2031850972862744576 or fnumber = 'AI_GAID'; 
delete from t_lic_group_l where fid = 2031850972862744576 ; 
insert into t_lic_group (fid,fnumber,ftype,fgroupdes) values (2031850972862744576,'AI_GAID','2',' '); 
insert into t_lic_group_version (fid,fentryid,fnameversion,fgroupdesversion,fversion) values (2031850972862744576,2031852970215475205,'AI开发平台设计器',' ','7.0'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4CKE+UNT2QPJ',2031850972862744576,'zh_TW','AI開發平台設計器'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4CKE+UNT2RCU',2031852970215475205,'zh_TW','AI開發平台設計器'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4CKE+UNT2QPK',2031850972862744576,'GLang','AI开发平台设计器'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4CKE+UNT2RCV',2031852970215475205,'GLang','AI开发平台设计器'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4CKE+UNT2QPL',2031850972862744576,'zh_CN','AI开发平台设计器'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4CKE+UNT2RCW',2031852970215475205,'zh_CN','AI开发平台设计器'); 
update t_lic_group_version_l set fgroupdesversion = ' ' where flocaleid = 'zh_TW' and fentryid = 2031852970215475205; 
update t_lic_group_version_l set fgroupdesversion = ' ' where flocaleid = 'zh_CN' and fentryid = 2031852970215475205; 
delete from t_lic_group_version_l where fentryid = (select fentryid from t_lic_group_version where fid = 2031851994100271104 and fversion = '7.0'); 
delete from t_lic_group_version where fid = 2031851994100271104 and fversion = '7.0' ; 
delete from t_lic_group where fid = 2031851994100271104 or fnumber = 'PRO_OPEN_API'; 
delete from t_lic_group_l where fid = 2031851994100271104 ; 
insert into t_lic_group (fid,fnumber,ftype,fgroupdes) values (2031851994100271104,'PRO_OPEN_API','2',' '); 
insert into t_lic_group_version (fid,fentryid,fnameversion,fgroupdesversion,fversion) values (2031851994100271104,2031852970215474184,'OpenAPI-公有云流量版',' ','7.0'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4CKE+UNT2RCX',2031851994100271104,'zh_TW','OpenAPI-公有雲流量版'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4CKE+UNT2QPN',2031852970215474184,'zh_TW','OpenAPI-公有雲流量版'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4CKE+UNT2RCY',2031851994100271104,'GLang','OpenAPI-公有云流量版'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4CKE+UNT2QPO',2031852970215474184,'GLang','OpenAPI-公有云流量版'); 
insert into t_lic_group_l (fpkid,fid,flocaleid,fname) values ('4CKE+UNT2RCZ',2031851994100271104,'zh_CN','OpenAPI-公有云流量版'); 
insert into t_lic_group_version_l (fpkid,fentryid,flocaleid,fnameversion) values ('4CKE+UNT2QPP',2031852970215474184,'zh_CN','OpenAPI-公有云流量版'); 
update t_lic_group_version_l set fgroupdesversion = ' ' where flocaleid = 'zh_TW' and fentryid = 2031852970215474184; 
update t_lic_group_version_l set fgroupdesversion = ' ' where flocaleid = 'zh_CN' and fentryid = 2031852970215474184; 
UPDATE t_lic_module SET fname = 'OpenAPI', fgroupid = 2031851994100271104 WHERE fnumber = 'API'; 
INSERT INTO t_lic_module (fid, fnumber, fname, fgroupid) SELECT 2031852649913254912, 'API', 'OpenAPI', 2031851994100271104 WHERE NOT EXISTS ( SELECT 1 FROM t_lic_module WHERE fnumber = 'API' ); 
UPDATE t_lic_module_version SET fnameversion = 'OpenAPI' WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'API' ) AND fversion = '7.0'; 
INSERT INTO t_lic_module_version (fid, fentryid, fnameversion, fversion) SELECT lm.fid, 2031852970215475212, 'OpenAPI', '7.0' FROM t_lic_module lm WHERE lm.fnumber = 'API' AND NOT EXISTS ( SELECT 1 FROM t_lic_module_version lmv WHERE lm.fid = lmv.fid ); 
UPDATE t_lic_module_l SET fname = 'OpenAPI' WHERE flocaleid = 'zh_TW' AND fid IN (SELECT fid FROM t_lic_module WHERE fnumber = 'API'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4CKE+UNT2QPQ', 'zh_TW', 'OpenAPI' FROM t_lic_module m WHERE m.fnumber = 'API' AND NOT EXISTS (SELECT 1 FROM t_lic_module_l ml WHERE ml.fid = m.fid AND ml.flocaleid = 'zh_TW'); 
UPDATE t_lic_module_version_l SET fnameversion = 'OpenAPI' WHERE flocaleid = 'zh_TW' AND fentryid IN ( SELECT fentryid FROM t_lic_module_version WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'API')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4CKE+UNT2RD/', v.fentryid, 'zh_TW', 'OpenAPI' 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_TW' WHERE m.fnumber = 'API' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module_l SET fname = 'OpenAPI' WHERE flocaleid = 'GLang' AND fid IN (SELECT fid FROM t_lic_module WHERE fnumber = 'API'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4CKE+UNT2QPR', 'GLang', 'OpenAPI' FROM t_lic_module m WHERE m.fnumber = 'API' 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 = 'OpenAPI' WHERE flocaleid = 'GLang' AND fentryid IN ( SELECT fentryid FROM t_lic_module_version WHERE fid IN ( SELECT fid FROM t_lic_module WHERE fnumber = 'API')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4CKE+UNT2RD0', v.fentryid, 'GLang', 'OpenAPI' 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 = 'API' AND lmvl.fentryid IS NULL; 
UPDATE t_lic_module_l SET fname = 'OpenAPI' WHERE flocaleid = 'zh_CN' AND fid IN (SELECT fid FROM t_lic_module WHERE fnumber = 'API'); 
INSERT INTO t_lic_module_l (fid, fpkid, flocaleid, fname) SELECT m.fid, '4CKE+UNT2QPS', 'zh_CN', 'OpenAPI' FROM t_lic_module m WHERE m.fnumber = 'API' 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 = 'OpenAPI' 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 = 'API')); 
INSERT INTO t_lic_module_version_l (fpkid, fentryid, flocaleid, fnameversion) SELECT '4CKE+UNT2RD1', v.fentryid, 'zh_CN', 'OpenAPI' 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 = 'API' AND lmvl.fentryid IS NULL; 
