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',1426680676765178880,{ts'2023-07-04  00:00:00'},'contact',1152829048867618816,0);
DELETE FROM t_tsrbd_cfgmsgtempfd WHERE FID = 1226099719122501632;
INSERT INTO t_tsrbd_cfgmsgtempfd(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1226099719122501632,'1',NULL,' ',' ',1226099719122501632,'C','T_509','报到联系人电话',0,{ts'2021-08-19  00:00:00'},'1',1426680676765178880,{ts'2023-07-04  00:00:00'},'contactphone',1152829048867618816,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 = '1UL3FO345NKC';
INSERT INTO t_tsrbd_cfgmsgtempfd_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226099719122501632,'1UL3FO345NKC','zh_CN',' ',' ','报到联系人电话');
DELETE FROM t_tsrbd_cfgmsgtempfd_L WHERE FPKID = '1UL3FO345NKD';
--INSERT INTO t_tsrbd_cfgmsgtempfd_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226099719122501632,'1UL3FO345NKD','zh_TW',' ',' ','報到聯係人電話');
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 = 1226099719122501633;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1226099719122501632,1080,1226099719122501633);
DELETE FROM t_tsrbd_msgchannelfd WHERE FPKID = 1226098700435122178;
INSERT INTO t_tsrbd_msgchannelfd(FID,FBASEDATAID,FPKID) VALUES (1226098700435122176,475773782250774528,1226098700435122178);
DELETE FROM t_tsrbd_msgchannelfd WHERE FPKID = 1226099719122501634;
INSERT INTO t_tsrbd_msgchannelfd(FID,FBASEDATAID,FPKID) VALUES (1226099719122501632,475773782250774528,1226099719122501634);
DELETE FROM t_tsrbd_msgrecefd WHERE FPKID = 1226098700435111938;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1226098700435122176,1030,1226098700435111938);
DELETE FROM t_tsrbd_msgrecefd WHERE FPKID = 1226099719122511874;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1226099719122501632,1030,1226099719122511874);
DELETE FROM t_tsrbd_cfgmsgtempfd WHERE FID = 1721673807892054016;
INSERT INTO t_tsrbd_cfgmsgtempfd(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1721673807892054016,'0',NULL,' ',' ',1721673807892054016,'C','T_514','报到联系人邮箱',0,{ts'2023-07-04  00:00:00'},'1',1426680676765178880,{ts'2023-07-04  00:00:00'},'contactemail',1426680676765178880,0);
DELETE FROM t_tsrbd_cfgmsgtempfd_L WHERE FPKID = '3DGCBKRQSIT1';
INSERT INTO t_tsrbd_cfgmsgtempfd_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1721673807892054016,'3DGCBKRQSIT1','zh_CN',' ',' ','报到联系人邮箱');
DELETE FROM t_tsrbd_cfgmsgtempfd_L WHERE FPKID = '3DGCBKRQSIT2';
--INSERT INTO t_tsrbd_cfgmsgtempfd_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1721673807892054016,'3DGCBKRQSIT2','zh_TW',' ',' ','報到聯係人郵箱');
DELETE FROM t_tsrbd_cfgpushscenefd WHERE FPKID = 1721673807917219840;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1721673807892054016,1080,1721673807917219840);
DELETE FROM t_tsrbd_msgchannelfd WHERE FPKID = 1721673807917219841;
INSERT INTO t_tsrbd_msgchannelfd(FID,FBASEDATAID,FPKID) VALUES (1721673807892054016,475773782250774528,1721673807917219841);
DELETE FROM t_tsrbd_msgrecefd WHERE FPKID = 1721673807917239298;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1721673807892054016,1030,1721673807917239298);


--Offer通知模版
DELETE FROM T_TSRBD_CFGMSGTEMPLATE WHERE FID = 1020;
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,' ',' ',' ',1020,1080,'5','经过前期数次的沟通与审慎评估，我们很高兴的通知您，我公司已经决定录用您，欢迎您加盟 {拟入职公司} 。您的录用通知书已发送到您的邮箱{候选人邮箱}，请注意查收。

（此短信为系统发送，请勿回复）',' ','1',{ts'1900-01-01  00:00:00'},1030,'1','<p><p style="text-align: center;"><span style="font-size: 18px;">{拟入职公司} 录用通知书</span></p>
<p> </p>
<p>{候选人姓名}，您好：</p>
<p>      感谢您应聘 {拟入职公司} 。经过前期数次的沟通与审慎评估，我们很高兴地通知您，我公司已经决定录用您，欢迎您加盟 {拟入职公司} 。非常高兴能够与您成为同事。</p>
<p>      具体Offer内容请参见电子Offer的附件，如有疑问请联系 {Offer联系人}（{Offer联系人电话}）。</p>
<p>      如无疑问，请于 {最晚回复Offer Letter日期} 前点击以下电子Offer的链接，仔细阅读Offer信息，并确认是否接受Offer，逾期未回复将视为放弃Offer。</p>
<p>      {查看Offer Letter}</p>
<p>      特别说明：薪资请保密。勿在公司外部及内部进行相关讨论。</p>
<p>      再次感谢您的耐心和配合。</p>
<p>      说明：</p>
<p>       1、薪资请保密。</p>
<p>       2、报到时间：周一至周五   9：00</p>
<p>       3、报到手续办理负责人：{报到联系人姓名}（{报到联系人电话}）</p>
<p>                                                                                                                                                      {拟入职公司}</p>
<p>                                                                                                                                                      人力资源部</p></p>','录用通知书',0,1020,NULL,0,' ',100000,'C',',475773782250774528,475773159430184960,','1020_S','发送Offer(短信验证码登录+不加密附件)',0,' ',0,1,{ts'1900-01-01  00:00:00'},1,1020);
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '2X/TOCIC18I7';
INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1020,'2X/TOCIC18I7','zh_CN',' ',' ','发送Offer(短信验证码登录+不加密附件)');
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '2X/TOCIC18I8';
--INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1020,'2X/TOCIC18I8','zh_TW',' ',' ','發送Offer(短信驗證碼登錄+不加密附件)');
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1563341720962221056;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1020,475773782250774528,1563341720962221056);
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1563341720962221057;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1020,475773159430184960,1563341720962221057);

DELETE FROM T_TSRBD_CFGMSGTEMPLATE WHERE FID = 1030;
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,' ',' ',' ',1030,1080,'5','经过前期数次的沟通与审慎评估，我们很高兴的通知您，我公司已经决定录用您，欢迎您加盟 {拟入职公司} 。您的录用通知书已发送到您的邮箱{候选人邮箱}，请注意查收。录用通知书的访问验证码和文件解压验证码都是：{验证码} 。

（此短信为系统发送，请勿回复）',' ','1',{ts'1900-01-01  00:00:00'},1030,'1','<p><p style="text-align: center;"><span style="font-size: 18px;">{拟入职公司} 录用通知书</span></p>
<p> </p>
<p>{候选人姓名}，您好：</p>
<p>      感谢您应聘 {拟入职公司} 。经过前期数次的沟通与审慎评估，我们很高兴地通知您，我公司已经决定录用您，欢迎您加盟 {拟入职公司} 。非常高兴能够与您成为同事。</p>
<p>      具体Offer内容请参见电子Offer的附件（附件解压验证码见手机号 {候选人手机号} 收到的短信），如有疑问请联系 {Offer联系人}（{Offer联系人电话}）。</p>
<p>      如无疑问，请于 {最晚回复Offer Letter日期} 前点击以下电子Offer的链接，仔细阅读Offer信息，并确认是否接受Offer，逾期未回复将视为放弃Offer。</p>
<p>      {查看Offer Letter}</p>
<p>      特别说明：薪资请保密。勿在公司外部及内部进行相关讨论。</p>
<p>      再次感谢您的耐心和配合。</p>
<p>      说明：</p>
<p>       1、薪资请保密。</p>
<p>       2、报到时间：周一至周五   9：00</p>
<p>       3、报到手续办理负责人：{报到联系人姓名}（{报到联系人电话}）</p>
<p>                                                                                                                                                     {拟入职公司}</p>
<p>                                                                                                                                                      人力资源部</p></p>','录用通知书',0,1030,NULL,0,' ',100000,'C',',475773782250774528,475773159430184960,','1030_S','发送Offer(验证码登录+加密附件)',0,' ',0,1,{ts'1900-01-01  00:00:00'},1,1020);
DELETE FROM T_TSRBD_CFGMSGTEMPLATE WHERE FID = 1040;
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,' ',' ',' ',1040,1080,'5','经过前期数次的沟通与审慎评估，我们很高兴的通知您，我公司已经决定录用您，欢迎您加盟 {拟入职公司} 。您的录用通知书已发送到您的邮箱{候选人邮箱}，请注意查收。录用通知书的访问验证码是：{验证码} 。

（此短信为系统发送，请勿回复）',' ','1',{ts'1900-01-01  00:00:00'},1030,'1','<p><p style="text-align: center;"><span style="font-size: 18px;">{拟入职公司} 录用通知书</span></p>
<p> </p>
<p>{候选人姓名}，您好：</p>
<p>      感谢您应聘 {拟入职公司} 。经过前期数次的沟通与审慎评估，我们很高兴地通知您，我公司已经决定录用您，欢迎您加盟 {拟入职公司} 。非常高兴能够与您成为同事。</p>
<p>      具体Offer内容请参见电子Offer的附件，如有疑问请联系 {Offer联系人}（{Offer联系人电话}）。</p>
<p>      如无疑问，请于 {最晚回复Offer Letter日期} 前点击以下电子Offer的链接，仔细阅读Offer信息，并确认是否接受Offer，逾期未回复将视为放弃Offer。</p>
<p>      {查看Offer Letter}</p>
<p>      特别说明：薪资请保密。勿在公司外部及内部进行相关讨论。</p>
<p>      再次感谢您的耐心和配合。</p>
<p>      说明：</p>
<p>       1、薪资请保密。</p>
<p>       2、报到时间：周一至周五   9：00</p>
<p>       3、报到手续办理负责人：{报到联系人姓名}（{报到联系人电话}）</p>
<p>                                                                                                                                                      {拟入职公司}</p>
<p>                                                                                                                                                      人力资源部</p></p>','录用通知书',0,1040,NULL,0,' ',100000,'C',',475773782250774528,475773159430184960,','1040_S','发送Offer(验证码登录+不加密附件)',0,' ',0,1,{ts'1900-01-01  00:00:00'},1,1020);
DELETE FROM T_TSRBD_CFGMSGTEMPLATE WHERE FID = 1050;
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,' ',' ',' ',1050,1080,'5','经过前期数次的沟通与审慎评估，我们很高兴的通知您，我公司已经决定录用您，欢迎您加盟 {拟入职公司} 。您的录用通知书已发送到您的邮箱{候选人邮箱}，请注意查收。录用通知书文件解压验证码都是：{验证码} 。

（此短信为系统发送，请勿回复）',' ','1',{ts'1900-01-01  00:00:00'},1030,'1','<p><p style="text-align: center;"><span style="font-size: 18px;">{拟入职公司} 录用通知书</span></p>
<p> </p>
<p>{候选人姓名}，您好：</p>
<p>      感谢您应聘 {拟入职公司} 。经过前期数次的沟通与审慎评估，我们很高兴地通知您，我公司已经决定录用您，欢迎您加盟 {拟入职公司} 。非常高兴能够与您成为同事。</p>
<p>      具体Offer内容请参见电子Offer的附件（附件解压验证码见手机号 {候选人手机号} 收到的短信），如有疑问请联系 {Offer联系人}（{Offer联系人电话}）。</p>
<p>      如无疑问，请于 {最晚回复Offer Letter日期} 前点击以下电子Offer的链接，仔细阅读Offer信息，并确认是否接受Offer，逾期未回复将视为放弃Offer。</p>
<p>      {查看Offer Letter}</p>
<p>      特别说明：薪资请保密。勿在公司外部及内部进行相关讨论。</p>
<p>      再次感谢您的耐心和配合。</p>
<p>      说明：</p>
<p>       1、薪资请保密。</p>
<p>       2、报到时间：周一至周五   9：00</p>
<p>       3、报到手续办理负责人：{报到联系人姓名}（{报到联系人电话}）</p>
<p>                                                                                                                                                     {拟入职公司}</p>
<p>                                                                                                                                                      人力资源部</p></p>','录用通知书',0,1050,NULL,0,' ',100000,'C',',475773782250774528,475773159430184960,','1050_S','发送Offer(短信验证码登录+加密附件)',0,' ',0,1,{ts'1900-01-01  00:00:00'},1,1020);
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '2X/SS7VZ3AJN';
INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1030,'2X/SS7VZ3AJN','zh_CN',' ',' ','发送Offer(验证码登录+加密附件)');
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '2X/SS7VZ3AJO';
--INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1030,'2X/SS7VZ3AJO','zh_TW',' ',' ','發送Offer(驗證碼登錄+加密附件)');
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '2X/T6KCTGH80';
INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1040,'2X/T6KCTGH80','zh_CN',' ',' ','发送Offer(验证码登录+不加密附件)');
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '2X/T6KCTGH81';
--INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1040,'2X/T6KCTGH81','zh_TW',' ',' ','發送Offer(驗證碼登錄+不加密附件)');
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '2X/TBQDMVTD1';
INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1050,'2X/TBQDMVTD1','zh_CN',' ',' ','发送Offer(短信验证码登录+加密附件)');
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '2X/TBQDMVTD2';
--INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1050,'2X/TBQDMVTD2','zh_TW',' ',' ','發送Offer(短信驗證碼登錄+加密附件)');
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1563338700157371392;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1030,475773782250774528,1563338700157371392);
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1563338700157371393;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1030,475773159430184960,1563338700157371393);
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1563339141221991424;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1040,475773782250774528,1563339141221991424);
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1563339141221991425;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1040,475773159430184960,1563339141221991425);
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1563340993594409984;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1050,475773782250774528,1563340993594409984);
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1563340993594409985;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1050,475773159430184960,1563340993594409985);

DELETE FROM T_TSRBD_CFGMSGTEMPLATE WHERE FID = 1060;
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,' ',' ',' ',1060,1080,'5','经过前期数次的沟通与审慎评估，我们很高兴的通知您，我公司已经决定录用您，欢迎您加盟 {拟入职公司} 。您的录用通知书已发送到您的邮箱{候选人邮箱}，请注意查收。录用通知书解压验证码都是：{验证码} 。

（此短信为系统发送，请勿回复）',' ','2',{ts'1900-01-01  00:00:00'},1030,'1','<p><p style="text-align: center;"><span style="font-size: 18px;">{拟入职公司} 录用通知书</span></p>
<p> </p>
<p>{候选人姓名}，您好：</p>
<p>      感谢您应聘 {拟入职公司} 。经过前期数次的沟通与审慎评估，我们很高兴地通知您，我公司已经决定录用您，欢迎您加盟 {拟入职公司} 。非常高兴能够与您成为同事。</p>
<p>      具体Offer Letter参见邮件附件，请联系 {Offer联系人}（{Offer联系人电话}）获取附件解密验证码。</p>
<p>      请仔细阅读Offer Letter内容，并于 {最晚回复Offer Letter日期} 前进行回复，若逾期未回复将视您为主动放弃Offer Letter。</p>
<p>      特别说明：薪资请保密。勿在公司外部及内部进行相关讨论。</p>
<p>      再次感谢您的耐心和配合。</p>
<p>      说明：</p>
<p>       1、薪资请保密。</p>
<p>       2、报到时间：周一至周五   9：00</p>
<p>       3、报到手续办理负责人：{报到联系人姓名}（{报到联系人电话}）</p>
<p>                                                                                                                                                      {拟入职公司}</p>
<p>                                                                                                                                                      人力资源部</p></p>','录用通知书',0,1060,NULL,0,' ',100000,'C',',475773782250774528,475773159430184960,','1060_S','发送Offer(Offer Letter作为邮件附件发送)',0,' ',0,1,{ts'1900-01-01  00:00:00'},1,1020);
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '2X/YV4YHLKFP';
INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1060,'2X/YV4YHLKFP','ZH_CN',' ',' ','发送OFFER(OFFER LETTER作为邮件附件发送)');
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '2X/YV4YHLKFQ';
INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1060,'2X/YV4YHLKFQ','ZH_TW',' ',' ','發送OFFER(OFFER LETTER作為郵件附件發送)');
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1563369411413296128;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1060,475773782250774528,1563369411413296128);
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1563369411413296129;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1060,475773159430184960,1563369411413296129);

