-- openapi自定义分类
DELETE FROM t_openapi_custom_sort WHERE FID = 1570995796902686720;
INSERT INTO t_openapi_custom_sort(FID,FCREATETIME,FENABLE,FMODIFIERID,FREMARK,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1570995796902686720,{ts'2022-12-08  00:00:00'},'1',1,' ',{ts'2022-12-08  00:00:00'},1570995796902686720,'C',1,'fa_report_query');

DELETE FROM t_openapi_custom_sort_l WHERE FPKID = '2XZGTH860EV2';
INSERT INTO t_openapi_custom_sort_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1570995796902686720,'2XZGTH860EV2','zh_CN','报表查询接口');
DELETE FROM t_openapi_custom_sort_l WHERE FPKID = '2XZGTH860EV3';
INSERT INTO t_openapi_custom_sort_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1570995796902686720,'2XZGTH860EV3','zh_TW','報表查詢接口');

-- lease_contract_customization
DELETE FROM t_openapi_custom_sort WHERE FID = 1571022447938096128;
INSERT INTO t_openapi_custom_sort(FID,FCREATETIME,FENABLE,FMODIFIERID,FREMARK,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1571022447938096128,{ts'2022-12-08  00:00:00'},'1',1449861688919806976,'租赁合同自定义接口分类',{ts'2022-12-08  00:00:00'},1571022447938096128,'C',1449861688919806976,'lease_contract_customization');

DELETE FROM t_openapi_custom_sort_l WHERE FPKID = '2XZLSP=Q9944';
INSERT INTO t_openapi_custom_sort_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1571022447938096128,'2XZLSP=Q9944','zh_CN','租赁合同自定义分类');
DELETE FROM t_openapi_custom_sort_l WHERE FPKID = '2XZLSP=Q9945';
INSERT INTO t_openapi_custom_sort_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1571022447938096128,'2XZLSP=Q9945','zh_TW','租賃合同自定義分類');

UPDATE t_open_apiservice SET fcustomsort = 1571022447938096128
WHERE fid IN (1504967579825915904,1504964689849854976, 1504458601992104960,1504907773966775296);
