DELETE FROM t_hrcs_msgpublisher WHERE FID = 1650767020008055808;
INSERT INTO t_hrcs_msgpublisher(FISSYSPRESET,FSUBSTATUS,FDESCRIPTION,FMASTERID,FPUBLISHBDID,FPUBERID,FCREATETIME,FOFFLINEDATE,FENABLE,FACTIONCLOUD,FISSUBSCRIBE,FPUBLISHDATE,FDISABLERID,FID,FMSGPROBOID,FDISABLEDATE,FSIMPLENAME,FSTATUS,FUSESTATUS,FMSGPUBNO,FNUMBER,FNAME,FINDEX,FACTIONID,FMSGTAG,FMODIFIERID,FMODIFYTIME,FACTIONTYPEID,FACTIONAPP,FCREATORID,FPUBSTATUS) VALUES ('1','1','签约公司变更,发送消息',1650767020008055808,108010,1275333883381954560,{ts'2023-03-28  00:00:00'},NULL,'1','0PEIU203SX4Y','2',{ts'2023-03-28  00:00:00'},0,1650767020008055808,0,NULL,' ','C',' ','MP20230328001046','MP20230328001046','签约公司变更',0,105100,' ',1,{ts'2023-03-28  00:00:00'},105100,'XYRL3+A8Z+Z',1,'P');

DELETE FROM t_hrcs_msgpublisher_l WHERE FPKID = '35RNQ096HGPY';
INSERT INTO t_hrcs_msgpublisher_l(FID,FPKID,FLOCALEID,FMSGTAG,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1650767020008055808,'35RNQ096HGPY','zh_CN',' ',' ','签约公司变更,发送消息','签约公司变更'); 
DELETE FROM t_hrcs_msgpublisher_l WHERE FPKID = '35RNQ096HGPZ';
INSERT INTO t_hrcs_msgpublisher_l(FID,FPKID,FLOCALEID,FMSGTAG,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1650767020008055808,'35RNQ096HGPZ','zh_TW',' ',' ','簽約公司變更,發送消息','簽約公司變更'); 

DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1650804581241806848;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1650767020008055808,103010,1650804581241806848); 
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1650804581241806849;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1650767020008055808,108010,1650804581241806849); 

DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1650774020578144256;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1650767020008055808,1650774020578144256,'P','IHBSSSignCompanyService','0','[{"type":"long","key":"eventId"}]','签约公司查询API','{"data":{"code":"int","data":"Map<Long, DynamicObject>","errMsg":"String"},"resultType":"java.util.Map"}','签约公司查询API','API20230328002041',1650771313842889728,'A','java.util.Map','0PEIU203SX4Y','XYRL3+A8Z+Z',1,'IHBSSSignCompanyService',0,' ','2',' '); 

DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '35RP00RQXQ++';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1650774020578144256,'35RP00RQXQ++','zh_CN','签约公司查询API','签约公司查询API'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '35RPFTV4P58I';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1650774020578144256,'35RPFTV4P58I','zh_TW','簽約公司查詢API','簽約公司查詢API'); 

DELETE FROM t_hrcs_apisource WHERE FID = 1650771313842889728;
INSERT INTO t_hrcs_apisource(FTYPE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FMASTERID,FPUBERID,FCREATETIME,FENABLE,FKEY,FPARAM,FDISABLERID,FID,FVERSION,FOUTPUTPARAMTYPE,FDISABLEDATE,FSIMPLENAME,FISNONORIGINAL,FSTATUS,FOUTPUTPARAM,FMAINENTITY,FNUMBER,FNAME,FINDEX,FSERVICEID,FMETHODID,FMODIFIERID,FBIZAPPID,FMODIFYTIME,FBIZCLOUDID,FCREATORID) VALUES ('2','1','[{"type":"long","key":"eventId"}]','签约公司查询API',1650771313842889728,1275333883381954560,{ts'2023-03-28  00:00:00'},'1','getSignCompanyByEventId',' ',0,1650771313842889728,0,'java.util.Map',NULL,' ','0','C','{"data":{"code":"int","data":"Map<Long, DynamicObject>","errMsg":"String"},"resultType":"java.util.Map"}',' ','API20230328002041','签约公司查询API',0,'IHBSSSignCompanyService','IHBSSSignCompanyService',1,'XYRL3+A8Z+Z',{ts'2023-03-31  00:00:00'},'0PEIU203SX4Y',1); 

DELETE FROM t_hrcs_apisource_l WHERE FPKID = '35ROIAJ/A2RA';
INSERT INTO t_hrcs_apisource_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1650771313842889728,'35ROIAJ/A2RA','zh_CN',' ','签约公司查询API','签约公司查询API'); 
DELETE FROM t_hrcs_apisource_l WHERE FPKID = '35ROIAJ/A2RB';
INSERT INTO t_hrcs_apisource_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1650771313842889728,'35ROIAJ/A2RB','zh_TW',' ','簽約公司查詢API','簽約公司查詢API'); 

DELETE FROM t_hrcs_apisource_a WHERE FID = 1650771313842889728;
INSERT INTO t_hrcs_apisource_a(FID,FAPIXML,FNUMBER) VALUES (1650771313842889728,' ',' '); 

DELETE FROM t_hbss_actiontype WHERE FID = 105100;
INSERT INTO t_hbss_actiontype(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FBUSINESSDOMAINID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (105100,'1',NULL,' ','签约公司变更',105100,108010,'C','105100_S','签约公司变更',0,{ts'2023-03-28  00:00:00'},1,'1',{ts'2023-03-28  00:00:00'},1,0); 

DELETE FROM t_hbss_actiontype_l WHERE FPKID = '35RMEEMKM27O';
INSERT INTO t_hbss_actiontype_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (105100,'35RMEEMKM27O','zh_CN',' ','签约公司变更','签约公司变更'); 
DELETE FROM t_hbss_actiontype_l WHERE FPKID = '35RMEEMKM27P';
INSERT INTO t_hbss_actiontype_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (105100,'35RMEEMKM27P','zh_TW',' ','簽約公司變更','簽約公司變更'); 

DELETE FROM t_hbss_action WHERE FID = 105100;
INSERT INTO t_hbss_action(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FACTIONTYPEID,FCREATORID,FDISABLERID) VALUES (105100,'1',NULL,' ','签约公司变更',105100,'C','105100_S','签约公司变更',0,{ts'2023-03-28  00:00:00'},1,'1',{ts'2023-03-28  00:00:00'},105100,1,0); 

DELETE FROM t_hbss_action_l WHERE FPKID = '35RMKW53=02S';
INSERT INTO t_hbss_action_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (105100,'35RMKW53=02S','zh_CN',' ','签约公司变更','签约公司变更'); 
DELETE FROM t_hbss_action_l WHERE FPKID = '35RMKW56XF==';
INSERT INTO t_hbss_action_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (105100,'35RMKW56XF==','zh_TW',' ','簽約公司變更','簽約公司變更'); 

 
