/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_table.sql **/

-- 描述：定义数据源API
DELETE FROM T_OPEN_APISERVICE WHERE FID = 1388957228475639808;
INSERT INTO T_OPEN_APISERVICE(FAPISERVICETYPE,FCUSTOMMETHOD,FISFAILCONTINUE,FADDEDINFO,FAPIDEFTYPE,FOPERATION,FISKSQL,FINPUTPARAM,FMASTERID,FORDER_BY_HIDE,FCONTENTTYPE,FSELECTPARAM,FMUSTPARAM,FCREATETIME,FMETHODNAME,FENABLE,ISFAILCONTINUE,FREQTYPE,FDISABLERID,FBIZOBJECT,FALLOWGUEST,FISVID,FID,FVERSION,FADDEDINFO_TAG,FNAMESPACE,FDISABLEDATE,FURL,FSAVEOPERATION,FSTATUS,FOUTPUTPARAM,FFILTERPARAM,FCU_LIMIT_TAC,FNUMBER,FREPTYPE,FCUSTOMSORT,FMESSAGETYPE,FISDYOBJRESULT,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCLASSNAME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID) VALUES ('2',' ','1',' ','0',' ','0',' ',1388957228475639808,' ','0','name,createorg,modifytime',' ',{ts'2022-04-01  00:00:00'},' ','1','1',NULL,NULL,' ','0',' ',1388957228475639808,' ',NULL,' ',NULL,NULL,NULL,'C',' ',' ',0,'bgupdatedatasource',NULL,0,NULL,'0',13466739,'[{"FPK":"","Type":0,"Description":"预算MC数据源更新配置","RowKey":0,"ClassName":"kd.epm.eb.service.openapi.datasource.EPMDataSourceApi","DisplayName":"","Enabled":true,"BizAppId":"","Inherit":false}]',{ts'2022-04-01  00:00:00'},' ','/V0B8OWYDBZL','/app/bgbd/bgupdatedatasource','1',13466739); 


DELETE FROM T_OPEN_APISERVICE_L WHERE FPKID = '2BLBOJPNNOTR';
INSERT INTO T_OPEN_APISERVICE_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (1388957228475639808,' ','2BLBOJPNNOTR','zh_CN','预算MC更新数据源配置'); 
DELETE FROM T_OPEN_APISERVICE_L WHERE FPKID = '2BLBOJPNNOTS';
INSERT INTO T_OPEN_APISERVICE_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (1388957228475639808,' ','2BLBOJPNNOTS','zh_TW','預算MC更新數據源配置'); 


DELETE FROM T_OPEN_APIHEADERENTRY WHERE FENTRYID = 1388957228517582848;
INSERT INTO T_OPEN_APIHEADERENTRY(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERVALUE,FHEADERDES) VALUES (1388957228475639808,'Content-Type',1388957228517582848,1,'application/json','内容格式'); 
DELETE FROM T_OPEN_APIHEADERENTRY WHERE FENTRYID = 1388957228517582849;
INSERT INTO T_OPEN_APIHEADERENTRY(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERVALUE,FHEADERDES) VALUES (1388957228475639808,'accesstoken',1388957228517582849,2,'获取的accesstoken值','请求令牌'); 


DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1393301334643471360;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1388957228475639808,'1','String',0,' ',' ',1393301334643471360,1,'serveraddress'); 
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1393301425559203840;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1388957228475639808,'1','String',0,' ',' ',1393301425559203840,2,'port'); 
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1393301473550428160;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1388957228475639808,'1','String',0,' ',' ',1393301473550428160,3,'username'); 
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1393301520962840576;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1388957228475639808,'1','String',0,' ',' ',1393301520962840576,4,'password'); 
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1393301567788052480;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1388957228475639808,'1','Long',0,' ',' ',1393301567788052480,5,'userId'); 


DELETE FROM T_OPEN_APIRESPENTRY WHERE FENTRYID = 1388956127026245632;
INSERT INTO T_OPEN_APIRESPENTRY(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1388957228475639808,'success_s','1','Boolean',1388956127026245632,1,' ',' '); 
DELETE FROM T_OPEN_APIRESPENTRY WHERE FENTRYID = 1388956266293913600;
INSERT INTO T_OPEN_APIRESPENTRY(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1388957228475639808,'data','0','Object',1388956266293913600,2,' ',' '); 
DELETE FROM T_OPEN_APIRESPENTRY WHERE FENTRYID = 1388956372770515968;
INSERT INTO T_OPEN_APIRESPENTRY(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1388957228475639808,'message','0','String',1388956372770515968,3,' ',' '); 
DELETE FROM T_OPEN_APIRESPENTRY WHERE FENTRYID = 1388956427548125184;
INSERT INTO T_OPEN_APIRESPENTRY(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1388957228475639808,'errorCode','0','String',1388956427548125184,4,' ',' '); 



/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_table.sql **/