--添加消息模版接收人类型->报到联系人
DELETE FROM T_TSRBD_CFGMSGRECVTYPE WHERE FID = 1011;
INSERT INTO T_TSRBD_CFGMSGRECVTYPE(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1011,'1',NULL,' ',' ',1011,'C','T_011','报到联系人',0,{ts'2023-07-17  00:00:00'},'1',1426680676765178880,{ts'2023-07-18  00:00:00'},1,0);
DELETE FROM T_TSRBD_CFGMSGRECVTYPE_L WHERE FPKID = '3EQHDESN8D94';
INSERT INTO T_TSRBD_CFGMSGRECVTYPE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1011,'3EQHDESN8D94','zh_CN',' ',' ','报到联系人');
DELETE FROM T_TSRBD_CFGMSGRECVTYPE_L WHERE FPKID = '3EQHDESN8D95';
--INSERT INTO T_TSRBD_CFGMSGRECVTYPE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1011,'3EQHDESN8D95','zh_TW',' ',' ','報到聯係人');
DELETE FROM T_TSRBD_PUSHMSGSCENE WHERE FPKID = 1731928511091856384;
INSERT INTO T_TSRBD_PUSHMSGSCENE(FID,FBASEDATAID,FPKID) VALUES (1011,1080,1731928511091856384);

--消息模板变量字段修改-Offer通知场景
DELETE FROM T_TSRBD_CFGMSGTEMPFD WHERE FID = 1226094560380239872;
INSERT INTO T_TSRBD_CFGMSGTEMPFD(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1226094560380239872,'1',NULL,' ',' ',1226094560380239872,'C','T_501','拟入职公司',0,{ts'2021-08-19  00:00:00'},'1',1,{ts'2023-07-18  00:00:00'},'pecompany',1,0);
DELETE FROM T_TSRBD_CFGMSGTEMPFD WHERE FID = 1226095335403743232;
INSERT INTO T_TSRBD_CFGMSGTEMPFD(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1226095335403743232,'1',NULL,' ',' ',1226095335403743232,'C','T_502','候选人姓名',0,{ts'2021-08-19  00:00:00'},'1',1,{ts'2023-07-18  00:00:00'},'candidatename',1,0);
DELETE FROM T_TSRBD_CFGMSGTEMPFD WHERE FID = 1226095788162072576;
INSERT INTO T_TSRBD_CFGMSGTEMPFD(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1226095788162072576,'1',NULL,' ',' ',1226095788162072576,'C','T_503','候选人手机号',0,{ts'2021-08-19  00:00:00'},'1',1,{ts'2023-07-18  00:00:00'},'candidatephone',1,0);
DELETE FROM T_TSRBD_CFGMSGTEMPFD WHERE FID = 1226104254675075072;
INSERT INTO T_TSRBD_CFGMSGTEMPFD(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1226104254675075072,'1',NULL,' ',' ',1226104254675075072,'C','T_511','候选人邮箱',0,{ts'2021-08-19  00:00:00'},'1',1,{ts'2023-07-18  00:00:00'},'candidateemail',1,0);
DELETE FROM T_TSRBD_CFGMSGTEMPFD WHERE FID = 1226096436987357184;
INSERT INTO T_TSRBD_CFGMSGTEMPFD(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1226096436987357184,'1',NULL,' ',' ',1226096436987357184,'C','T_504','Offer联系人',0,{ts'2021-08-19  00:00:00'},'1',1,{ts'2023-07-18  00:00:00'},'applicant',1,0);
DELETE FROM T_TSRBD_CFGMSGTEMPFD WHERE FID = 1226096630361538560;
INSERT INTO T_TSRBD_CFGMSGTEMPFD(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1226096630361538560,'1',NULL,' ',' ',1226096630361538560,'C','T_505','Offer联系人电话',0,{ts'2021-08-19  00:00:00'},'1',1,{ts'2023-07-18  00:00:00'},'applyphone',1,0);
DELETE FROM T_TSRBD_CFGMSGTEMPFD WHERE FID = 1226098700435122176;
INSERT INTO T_TSRBD_CFGMSGTEMPFD(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1226098700435122176,'1',NULL,' ',' ',1226098700435122176,'C','T_508','报到联系人姓名',0,{ts'2021-08-19  00:00:00'},'1',1,{ts'2023-07-18  00:00:00'},'contact',1,0);
DELETE FROM T_TSRBD_CFGMSGTEMPFD WHERE FID = 1559695543960130560;
INSERT INTO T_TSRBD_CFGMSGTEMPFD(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1559695543960130560,'1',NULL,' ',' ',1559695543960130560,'C','T_513','报到地址',0,{ts'2022-11-22  00:00:00'},'1',1,{ts'2023-07-18  00:00:00'},'reportaddress',1,0);
DELETE FROM T_TSRBD_CFGMSGTEMPFD WHERE FID = 1728221829711063040;
INSERT INTO T_TSRBD_CFGMSGTEMPFD(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1728221829711063040,'1',NULL,' ',' ',1728221829711063040,'C','T_516','预计入职日期',0,{ts'2023-07-13  00:00:00'},'1',1,{ts'2023-07-18  00:00:00'},'pemploymenttime',1,0);
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL398LHWBNE';
INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226098700435122176,'1UL398LHWBNE','zh_CN',' ',' ','报到联系人姓名');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL398LHWBNF';
--INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226098700435122176,'1UL398LHWBNF','zh_TW',' ',' ','報到聯係人姓名');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '3E9QTXCA8BMY';
INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1728221829711063040,'3E9QTXCA8BMY','zh_CN',' ',' ','预计入职日期');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '3E9QTXCA8BMZ';
--INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1728221829711063040,'3E9QTXCA8BMZ','zh_TW',' ',' ','預計入職日期');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '2WKBDR/Z142T';
INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1559695543960130560,'2WKBDR/Z142T','zh_CN',' ',' ','报到地址');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '2WKBDR/Z142U';
--INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1559695543960130560,'2WKBDR/Z142U','zh_TW',' ',' ','報到地址');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL2URBKSJQ4';
INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226096436987357184,'1UL2URBKSJQ4','zh_CN',' ',' ','Offer联系人');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL2URBKSJQ5';
--INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226096436987357184,'1UL2URBKSJQ5','zh_TW',' ',' ','Offer聯係人');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL2H2072OZ4';
INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226094560380239872,'1UL2H2072OZ4','zh_CN',' ',' ','拟入职公司');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL2H2072OZ5';
--INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226094560380239872,'1UL2H2072OZ5','zh_TW',' ',' ','擬入職公司');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL2MQ=61FX1';
INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226095335403743232,'1UL2MQ=61FX1','zh_CN',' ',' ','候选人姓名');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL2MQ=61FX2';
--INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226095335403743232,'1UL2MQ=61FX2','zh_TW',' ',' ','候選人姓名');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL2Q/ZAU+T2';
INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226095788162072576,'1UL2Q/ZAU+T2','zh_CN',' ',' ','候选人手机号');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL2Q/ZAU+T3';
--INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226095788162072576,'1UL2Q/ZAU+T3','zh_TW',' ',' ','候選人手機號');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL4=Q1YEQ85';
INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226104254675075072,'1UL4=Q1YEQ85','zh_CN',' ',' ','候选人邮箱');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL4=Q1YEQ86';
--INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226104254675075072,'1UL4=Q1YEQ86','zh_TW',' ',' ','候選人郵箱');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL2W5=V0U38';
INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226096630361538560,'1UL2W5=V0U38','zh_CN',' ',' ','Offer联系人电话');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '1UL2W5=V0U39';
--INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226096630361538560,'1UL2W5=V0U39','zh_TW',' ',' ','Offer聯係人電話');
DELETE FROM t_tsrbd_cfgpushscenefd WHERE FPKID = 1559695544144679936;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1559695543960130560,1080,1559695544144679936);
DELETE FROM t_tsrbd_cfgpushscenefd WHERE FPKID = 1226094560380239873;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1226094560380239872,1080,1226094560380239873);
DELETE FROM t_tsrbd_cfgpushscenefd WHERE FPKID = 1226095335403743233;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1226095335403743232,1080,1226095335403743233);
DELETE FROM t_tsrbd_cfgpushscenefd WHERE FPKID = 1226095788162072577;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1226095788162072576,1080,1226095788162072577);
DELETE FROM t_tsrbd_cfgpushscenefd WHERE FPKID = 1226096436987357185;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1226096436987357184,1080,1226096436987357185);
DELETE FROM t_tsrbd_cfgpushscenefd WHERE FPKID = 1226096630361538561;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1226096630361538560,1080,1226096630361538561);
DELETE FROM t_tsrbd_cfgpushscenefd WHERE FPKID = 1226098700435122177;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1226098700435122176,1080,1226098700435122177);
DELETE FROM t_tsrbd_cfgpushscenefd WHERE FPKID = 1226104254675075073;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1226104254675075072,1080,1226104254675075073);
DELETE FROM t_tsrbd_cfgpushscenefd WHERE FPKID = 1728221829753006080;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1728221829711063040,1080,1728221829753006080);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731940434030121984;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226094560380239872,1030,1731940434030121984);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731940434030121985;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226094560380239872,1011,1731940434030121985);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731940607179424768;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226095335403743232,1030,1731940607179424768);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731940607179424769;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226095335403743232,1011,1731940607179424769);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731947644625900544;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226095788162072576,1030,1731947644625900544);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731947644625900545;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226095788162072576,1011,1731947644625900545);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731948000529417216;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226104254675075072,1030,1731948000529417216);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731948000529417217;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226104254675075072,1011,1731948000529417217);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731948283368068096;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226096436987357184,1030,1731948283368068096);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731948283368068097;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226096436987357184,1011,1731948283368068097);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731948493997626368;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226096630361538560,1030,1731948493997626368);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731948493997626369;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226096630361538560,1011,1731948493997626369);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731948878447531008;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226098700435122176,1030,1731948878447531008);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731948878447531009;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1226098700435122176,1011,1731948878447531009);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731949382493864960;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1559695543960130560,1030,1731949382493864960);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731949382493864961;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1559695543960130560,1011,1731949382493864961);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731949594138399744;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1728221829711063040,1030,1731949594138399744);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1731949594138399745;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1728221829711063040,1011,1731949594138399745);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1226101470403815424;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226094560380239872,475773782250774528,1226101470403815424);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1226101470403815425;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226094560380239872,475773159430184960,1226101470403815425);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1226101613303742464;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226095335403743232,475773782250774528,1226101613303742464);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1226101613303742465;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226095335403743232,475773159430184960,1226101613303742465);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731947644625945600;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226095788162072576,475773782250774528,1731947644625945600);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731947644625945601;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226095788162072576,475773159430184960,1731947644625945601);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731948000529372160;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226104254675075072,475773782250774528,1731948000529372160);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731948000529372161;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226104254675075072,475773159430184960,1731948000529372161);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731948283368113152;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226096436987357184,475773782250774528,1731948283368113152);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731948283368113153;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226096436987357184,475773159430184960,1731948283368113153);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731948493997671424;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226096630361538560,475773782250774528,1731948493997671424);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731948493997671425;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226096630361538560,475773159430184960,1731948493997671425);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731948878447576064;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226098700435122176,475773782250774528,1731948878447576064);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731948878447576065;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1226098700435122176,475773159430184960,1731948878447576065);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731949382493819904;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1559695543960130560,475773782250774528,1731949382493819904);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731949382493819905;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1559695543960130560,475773159430184960,1731949382493819905);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731949594138444800;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1728221829711063040,475773782250774528,1731949594138444800);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1731949594138444801;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1728221829711063040,475773159430184960,1731949594138444801);

--报到通知书预置模版
DELETE FROM T_TSRBD_CFGMSGTEMPLATE WHERE FID = 1731957583046005760;
INSERT INTO T_TSRBD_CFGMSGTEMPLATE(FBITINDEX,FRECRUTYPLIST,FISSYSPRESET,FUSEORGID,FCREATEORGID,FINTVCATEGORYLIST,FINTVMETHODLIST,FDESCRIPTION,FMASTERID,FMSGPUSHSCENEID,FCTRLSTRATEGY,FSMSTEMPLATE,FEMAILRICHTEXT,FSENDTYPE,FCREATETIME,FMSGRECEIVERID,FENABLE,FEMAILRICHTEXT_TAG,FEMAILTHEME,FDISABLERID,FID,FDISABLEDATE,FSOURCEDATAID,FSIMPLENAME,FORGID,FSTATUS,FMSGCHANNELLIST,FNUMBER,FNAME,FINDEX,FYZJTEMPLATE,FSOURCEBITINDEX,FMODIFIERID,FMODIFYTIME,FCREATORID,FRECRUTYPEID) VALUES (0,' ','1',100000,100000,' ',' ',' ',1731957583046005760,1080,'5','候选人{候选人姓名}已经完成全部招聘流程，预计将于{预计入职日期}到{报到地址}报到，请您协助办理入职手续，谢谢。如有疑问请联系 {Offer联系人}（{Offer联系人电话}）。',' ','2',{ts'2023-07-18  00:00:00'},1011,'1',' ','报到通知书',0,1731957583046005760,NULL,0,' ',100000,'C',',475773782250774528,475773159430184960,','T643','报到通知书',0,' ',0,1,{ts'2023-07-18  00:00:00'},1,1020);
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '3EQMU9VJ0SZ9';
INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1731957583046005760,'3EQMU9VJ0SZ9','zh_CN',' ',' ','报到通知书');
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '3EQMU9VJ0SZ=';
--INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1731957583046005760,'3EQMU9VJ0SZ=','zh_TW',' ',' ','報到通知書');
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1731972936497124352;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1731957583046005760,475773782250774528,1731972936497124352);
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1731972936497124353;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1731957583046005760,475773159430184960,1731972936497124353);
