DELETE FROM T_OPEN_APISERVICE WHERE FID = 786185899649008640;
INSERT INTO T_OPEN_APISERVICE(FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FMASTERID,FCONTENTTYPE,FCREATETIME,FENABLE,FREQTYPE,FDISABLERID,FBIZOBJECT,FALLOWGUEST,FID,FDISABLEDATE,FURL,FSTATUS,FNUMBER,FREPTYPE,FMESSAGETYPE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID) VALUES ('2',' ',' ',786185899649008640,'0',{ts'2018-08-8  18:08:08'},'1',0,null,' ','0',786185899649008640,null,' ','C','getAttDownloadUrl',0,null,1,'[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.bos.service.webapi.AttachmentWebApiPlugin","Enabled":true,"rowKey":null}]',{ts'2018-08-8  18:08:08'},'18XSXYEL8//U','/app/sys/getAttDownloadUrl','0',1); 

-- 添加预置API的名称
DELETE FROM t_open_apiservice_l WHERE fpkid = '0JR+9UOH0L1J';
DELETE FROM t_open_apiservice_l WHERE fpkid = '0JR+9UOH0L1K';
DELETE FROM t_open_apiservice_l WHERE fpkid = '0JR+9UOH0L1L';
INSERT INTO t_open_apiservice_l(FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES ('0JR+9UOH0L1J', 786185899649008640, 'en_US', 'getAttDownloadUrl', 'getAttDownloadUrl');
INSERT INTO t_open_apiservice_l(FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES ('0JR+9UOH0L1K', 786185899649008640, 'zh_CN', '获取附件下载URL', '获取附件下载URL');
INSERT INTO t_open_apiservice_l(FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES ('0JR+9UOH0L1L', 786185899649008640, 'zh_TW', '獲取附件下載URL', '獲取附件下載URL');


DELETE FROM T_OPEN_APISERVICE WHERE FID = 820303251923550208;
INSERT INTO T_OPEN_APISERVICE(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FDISABLEDATE,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FNUMBER,FREPTYPE,FMESSAGETYPE,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FDISABLERID,FBIZOBJECT) VALUES (820303251923550208,'2',' ',' ',null,' ',820303251923550208,'C','0','getConvertRuleIdsByAppNumber',0,null,{ts'2018-08-8  18:08:08'},'1',1,'[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.bos.service.metadata.openapi.QueryConvertRuleIdApiPlugin","Enabled":true,"rowKey":null}]',{ts'2018-08-8  18:08:08'},'W3NF+MX967M','/app/open/getConvertRuleIdsByAppNumber','0',1,0,null,' '); 
DELETE FROM T_OPEN_APISERVICE WHERE FID = 820304087462461440;
INSERT INTO T_OPEN_APISERVICE(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FDISABLEDATE,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FNUMBER,FREPTYPE,FMESSAGETYPE,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FDISABLERID,FBIZOBJECT) VALUES (820304087462461440,'2',' ',' ',null,' ',820304087462461440,'C','0','getWriteBackRuleIdsByAppNumber',0,null,{ts'2018-08-8  18:08:08'},'1',1,'[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.bos.service.metadata.openapi.QueryWriteBackRuleIdApiPlugin","Enabled":true,"rowKey":null}]',{ts'2018-08-8  18:08:08'},'W3NF+MX967M','/app/open/getWriteBackRuleIdsByAppNumber','0',1,0,null,' '); 

DELETE FROM t_open_apiservice WHERE FID = 804329710380169216;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FDISABLEDATE,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FNUMBER,FREPTYPE,FMESSAGETYPE,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FDISABLERID,FBIZOBJECT) VALUES (804329710380169216,'2',' ',' ',null,' ',804329710380169216,'C','0','getBotpMetaLFile',0,null,{ts'2018-08-8  18:08:08'},'1',1,'[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.bos.service.metadata.openapi.BotpMetaLFilePlugin","Enabled":true,"rowKey":null}]',{ts'2018-08-8  18:08:08'},'W3NF+MX967M','/app/open/getBotpMetaLFile','0',1,0,null,' '); 
DELETE FROM t_open_apiservice WHERE FID = 804327120280015872;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FDISABLEDATE,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FNUMBER,FREPTYPE,FMESSAGETYPE,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FDISABLERID,FBIZOBJECT) VALUES (804327120280015872,'2',' ',' ',null,' ',804327120280015872,'C','0','updateBotpMetaL',0,null,{ts'2018-08-8  18:08:08'},'1',1,'[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.bos.service.metadata.openapi.BotpMetaLWriterPlugin","Enabled":true,"rowKey":null}]',{ts'2018-08-8  18:08:08'},'W3NF+MX967M','/app/open/updateBotpMetaL','1',1,0,null,' '); 
DELETE FROM t_open_apiservice WHERE FID = 804325358982706176;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FDISABLEDATE,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FNUMBER,FREPTYPE,FMESSAGETYPE,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FDISABLERID,FBIZOBJECT) VALUES (804325358982706176,'2',' ',' ',null,' ',804325358982706176,'C','0','loadBotpMetaLData',0,null,{ts'2018-08-8  18:08:08'},'1',1,'[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.bos.service.metadata.openapi.BotpMetaLReaderPlugin","Enabled":true,"rowKey":null}]',{ts'2018-08-8  18:08:08'},'W3NF+MX967M','/app/open/loadBotpMetaLData','0',1,0,null,' '); 

------
DELETE FROM t_open_apiservice WHERE FID = 662889010259035136;
INSERT INTO t_open_apiservice (FID, FNUMBER, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FENABLE, FDISABLERID, FDISABLEDATE, FMESSAGETYPE, FBIZOBJECT, FAPPID, FSTATUS, FURLFORMAT, FURL, FHTTPMETHOD, FCONTENTTYPE, FREQTYPE, FREPTYPE, FPLUGIN, FAPISERVICETYPE, FOPERATION, FCUSTOMMETHOD, FMASTERID) VALUES (662889010259035136, 'getAppInfoById', 1, {ts'2018-08-8  18:08:08'}, 1, {ts'2018-08-8  18:08:08'}, '1', NULL, NULL, NULL, ' ', '83bfebc800003dac', 'C', '/app/devportal/getAppInfoById', ' ', '0', '0', 0, 0, '[{\"FPK\":\"o9DM6XWi\",\"Type\":1,\"_Type_\":\"Plugin\",\"RowKey\":1,\"ClassName\":\"kingdee.dev.devportal.scriptdemo.bos_devp_webapi_custom\",\"Enabled\":true,\"BizAppId\":\"83bfebc800003dac\"}]', '2', ' ', ' ', 662889010259035136);
DELETE FROM t_open_apiservice WHERE FID = 662984301725352960;
INSERT INTO t_open_apiservice (FID, FNUMBER, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FENABLE, FDISABLERID, FDISABLEDATE, FMESSAGETYPE, FBIZOBJECT, FAPPID, FSTATUS, FURLFORMAT, FURL, FHTTPMETHOD, FCONTENTTYPE, FREQTYPE, FREPTYPE, FPLUGIN, FAPISERVICETYPE, FOPERATION, FCUSTOMMETHOD, FMASTERID) VALUES (662984301725352960, 'AIdemo', 1, {ts'2018-08-8  18:08:08'}, 1, {ts'2018-08-8  18:08:08'}, '1', NULL, NULL, NULL, ' ', '83bfebc800003dac', 'C', '/ai/do', ' ', '1', '0', 0, 0, '[{\"FPK\":\"hJRhF9w3\",\"Type\":1,\"_Type_\":\"Plugin\",\"RowKey\":1,\"ClassName\":\"kingdee.dev.devportal.scriptdemo.bos_devp_webapi_ai\",\"Enabled\":true,\"BizAppId\":\"83bfebc800003dac\"}]', '1', ' ', ' ', 662984301725352960);


-- 添加预置API的名称
DELETE FROM t_open_apiservice_l WHERE fpkid = '0TMRNJYI0RUN';
DELETE FROM t_open_apiservice_l WHERE fpkid = '0T+C51GL8DYM';
DELETE FROM t_open_apiservice_l WHERE fpkid = '0TPLMKPE7LHH';
INSERT INTO t_open_apiservice_l(FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES ('0TMRNJYI0RUN', 786185899649008640, 'en_US', 'im', 'im');
INSERT INTO t_open_apiservice_l(FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES ('0T+C51GL8DYM', 786185899649008640, 'zh_CN', 'im', '获取附件下载URL');
INSERT INTO t_open_apiservice_l(FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES ('0TPLMKPE7LHH', 786185899649008640, 'zh_TW', 'im', '獲取附件下載URL');
