-- 订阅任职经历、职业信息、试用期的修订
DELETE FROM t_hrcs_msgsubscriber WHERE FID = 1946590417252255744;
INSERT INTO t_hrcs_msgsubscriber(FISSYSPRESET,FSUBSTATUS,FDESCRIPTION,FMASTERID,FMSGSUBNO,FMSGPUBLISHERID,FCREATETIME,FENABLE,FCONSUMERCLOUD,FSUBSCRIBEBDID,FCONSUMERMETHOD,FDISABLERID,FID,FSUBERID,FDISABLEDATE,FSIMPLENAME,FSUBTIME,FISNONORIGINAL,FSTATUS,FNUMBER,FNAME,FINDEX,FACTIONID,FCONSUMERSERVICE,FMODIFIERID,FMODIFYTIME,FCONSUMERAPP,FACTIONTYPEID,FCREATORID) VALUES ('1','1','薪酬人员信息修订预置订阅',1946590417252255744,'MS20240509005044',1929804826368166912,{ts'2024-05-09  00:00:00'},'1','/U+QDTL900//',107010,'consumerSaveMsg',0,1946590417252255744,1632628417327399936,NULL,' ',{ts'2024-05-09  00:00:00'},'0','C','MS20240509005044','任职经历修订',0,1929790259239996416,'IHPDIEmployeeReviseService',1,{ts'2024-05-10  00:00:00'},'0NXW1VOPH+QV',1929789824022237184,1); 
DELETE FROM t_hrcs_msgsubscriber WHERE FID = 1950658936642330624;
INSERT INTO t_hrcs_msgsubscriber(FISSYSPRESET,FSUBSTATUS,FDESCRIPTION,FMASTERID,FMSGSUBNO,FMSGPUBLISHERID,FCREATETIME,FENABLE,FCONSUMERCLOUD,FSUBSCRIBEBDID,FCONSUMERMETHOD,FDISABLERID,FID,FSUBERID,FDISABLEDATE,FSIMPLENAME,FSUBTIME,FISNONORIGINAL,FSTATUS,FNUMBER,FNAME,FINDEX,FACTIONID,FCONSUMERSERVICE,FMODIFIERID,FMODIFYTIME,FCONSUMERAPP,FACTIONTYPEID,FCREATORID) VALUES ('1','1','薪酬人员信息修订预置订阅',1950658936642330624,'MS20240515006001',1929805593699306496,{ts'2024-05-15  00:00:00'},'1','/U+QDTL900//',107010,'consumerSaveMsg',0,1950658936642330624,1632628417327399936,NULL,' ',{ts'2024-05-15  00:00:00'},'0','C','MS20240515006001','试用期修订',0,1929790510537526272,'IHPDIEmployeeReviseService',1,{ts'2024-05-27  00:00:00'},'0NXW1VOPH+QV',1929789824022237184,1); 
DELETE FROM t_hrcs_msgsubscriber WHERE FID = 1950659125989990400;
INSERT INTO t_hrcs_msgsubscriber(FISSYSPRESET,FSUBSTATUS,FDESCRIPTION,FMASTERID,FMSGSUBNO,FMSGPUBLISHERID,FCREATETIME,FENABLE,FCONSUMERCLOUD,FSUBSCRIBEBDID,FCONSUMERMETHOD,FDISABLERID,FID,FSUBERID,FDISABLEDATE,FSIMPLENAME,FSUBTIME,FISNONORIGINAL,FSTATUS,FNUMBER,FNAME,FINDEX,FACTIONID,FCONSUMERSERVICE,FMODIFIERID,FMODIFYTIME,FCONSUMERAPP,FACTIONTYPEID,FCREATORID) VALUES ('1','1','薪酬人员信息修订预置订阅',1950659125989990400,'MS20240515006002',1929803433423032320,{ts'2024-05-15  00:00:00'},'1','/U+QDTL900//',107010,'consumerSaveMsg',0,1950659125989990400,1632628417327399936,NULL,' ',{ts'2024-05-15  00:00:00'},'0','C','MS20240515006002','职业信息修订',0,1929790108270218240,'IHPDIEmployeeReviseService',1,{ts'2024-05-27  00:00:00'},'0NXW1VOPH+QV',1929789824022237184,1); 

DELETE FROM t_hrcs_msgsubscriber_L WHERE FPKID = '43LE8=UCJXB/';
INSERT INTO t_hrcs_msgsubscriber_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1950658936642330624,'43LE8=UCJXB/','zh_CN',' ','薪酬人员信息修订预置订阅','试用期修订'); 
DELETE FROM t_hrcs_msgsubscriber_L WHERE FPKID = '432Y121DPD18';
INSERT INTO t_hrcs_msgsubscriber_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1946590417252255744,'432Y121DPD18','zh_CN',' ','薪酬人员信息修订预置订阅','任职经历修订'); 
DELETE FROM t_hrcs_msgsubscriber_L WHERE FPKID = '43LE9OM9AD+=';
INSERT INTO t_hrcs_msgsubscriber_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1950659125989990400,'43LE9OM9AD+=','zh_CN',' ','薪酬人员信息修订预置订阅','职业信息修订'); 

-- 业务事件发布 增加算发薪管理业务类型的订阅
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1929803433548861446;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1929803433423032320,107010,1929803433548861446); 
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1929804826384944134;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1929804826368166912,107010,1929804826384944134); 
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1929805593716083718;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1929805593699306496,107010,1929805593716083718);