//查询对应枚举编码的数据
select b.enumcode,b.enumname from iuap_metadata_service.aa_enum_type a join iuap_metadata_service.aa_enum_item b on a.id=b.typeid where a.enumtype=‘DM035’
//插入需要预制的枚举值
select * from iuap_metadata_service.aa_enum_item b where b.enumname =‘委托研发’
//查询其中一条有的生产sql
select * from iuap_metadata_service.aa_enum_item b where b.enumname =‘与境外机构合作’
1836477644359860258
select * from iuap_metadata_service.aa_enum_type where enumtype=‘DM035’
INSERT INTO iuap_metadata_service
.aa_enum_item
(id
, enumcode
, localid
, enumname
, pubts
, ideleted
, enumindex
, icon
, enumname_resid
, info
, typeid
, tenant_id
, ytenant_id
, cDataRule
) VALUES (1836477644359860233, ‘08’, ‘zh_CN’, ‘委托研发’, ‘2023-08-26 17:22:06’, 0, 7, NULL, NULL, NULL, 1836477644359860258, ‘0’, ‘0’, NULL);
INSERT INTO iuap_metadata_service
.aa_enum_item
(id
, enumcode
, localid
, enumname
, pubts
, ideleted
, enumindex
, icon
, enumname_resid
, info
, typeid
, tenant_id
, ytenant_id
, cDataRule
) VALUES (1836477644359860244, ‘09’, ‘zh_CN’, ‘集中研发’, ‘2023-08-26 17:22:06’, 0, 7, NULL, NULL, NULL, 1836477644359860258, ‘0’, ‘0’, NULL);
//预制的参数得为0
update iuap_metadata_service.aa_enum_item set tenant_id=0,ytenant_id=0 where enumname=‘委托研发’ and id =‘1836477644359860233’