-- 外部系统API组增加晨光对账

DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1378994177429215232;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1378993209568402432,1022438122593456128,1378994177429215232,5,'kd.scm.common.helper.apiconnector.apihandle.CheckOrderHandleProcessor','1','6'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1310262887066926080;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1310262221430880256,1022438122593456128,1310262887066926080,4,'kd.scm.common.helper.apiconnector.apihandle.CheckOrderHandleProcessor','1','4'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1063735503733443584;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1063005263444882432,1022438122593456128,1063735503733443584,3,'kd.scm.common.helper.apiconnector.apihandle.CheckOrderHandleProcessor','1','5'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1022438122627010561;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (985474683329577984,1022438122593456128,1022438122627010561,2,'kd.scm.common.helper.apiconnector.apihandle.CheckOrderHandleProcessor','1','3'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1022438122627010560;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (985460029018604544,1022438122593456128,1022438122627010560,1,'kd.scm.common.helper.apiconnector.apihandle.CheckOrderHandleProcessor','1','2'); 

DELETE FROM t_mal_extapiset WHERE FID = 1022438122593456128;
INSERT INTO t_mal_extapiset(FID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FDESCRIPTION,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1022438122593456128,{ts'2020-11-11  00:00:00'},1072504830670407680,'1','1',{ts'2022-03-18  00:00:00'},'电商对账接口组',1022438122593456128,'C',13466739,'SRM_EC_CHECKORDER'); 

DELETE FROM t_mal_extapiset_l WHERE FPKID = '16KD52SBSO24';
INSERT INTO t_mal_extapiset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1022438122593456128,'16KD52SBSO24','zh_CN','电商对账接口组'); 
DELETE FROM t_mal_extapiset_l WHERE FPKID = '16KD52SBSO25';
INSERT INTO t_mal_extapiset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1022438122593456128,'16KD52SBSO25','zh_TW','電商對賬接口組'); 



-- 外部系统API增加晨光对账
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1378993209593568256;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1378993209568402432,'0',1378993209593568256,'string',1,'1','startDate',' ','开始日期yyyy-MM-dd HH:mm:ss'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1378993209593568257;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1378993209568402432,'0',1378993209593568257,'string',2,'1','endDate',' ','开始日期yyyy-MM-dd HH:mm:ss'); 


DELETE FROM t_mal_extsys_api WHERE FID = 1378993209568402432;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FISDEBUG,FCREATORID) VALUES (1378993209568402432,'isc_metadata_schema','0','晨光订单对账数据查询',1378993209568402432,'C',1937423517605452304,'/api/restful/order/signstatus_ck','SRM_CG_ORDER_signstatus_ck',1150541456767723520,{ts'2022-03-18  00:00:00'},1072504830670407680,'1','1',{ts'2022-03-18  00:00:00'},'0',1072504830670407680); 

DELETE FROM t_mal_extsys_api_l WHERE FPKID = '2ACLYXXYBI6C';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1378993209568402432,'2ACLYXXYBI6C','zh_CN','晨光订单对账数据查询'); 