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',275188253840125501,{ts'2022-11-22  00:00:00'},'reportaddress',275188253840125501,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',275188253840125501,{ts'2022-12-01  00:00:00'},'applicant',1152829048867618816,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',275188253840125501,{ts'2022-12-01  00:00:00'},'applyphone',1152829048867618816,0); 
DELETE FROM t_tsrbd_cfgmsgtempfd WHERE FID = 1226106456760182784;
INSERT INTO t_tsrbd_cfgmsgtempfd(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1226106456760182784,'1',NULL,' ',' ',1226106456760182784,'C','T_512','验证码',0,{ts'2021-08-19  00:00:00'},'1',1152829048867618816,{ts'2021-12-03  00:00:00'},'verifycode',1152829048867618816,0); 
DELETE FROM t_tsrbd_cfgmsgtempfd WHERE FID = 1226097968227074048;
INSERT INTO t_tsrbd_cfgmsgtempfd(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1226097968227074048,'1',NULL,' ',' ',1226097968227074048,'C','T_507','查看Offer Letter',0,{ts'2021-08-19  00:00:00'},'1',1152829048867618816,{ts'2021-12-03  00:00:00'},'offerurl',1152829048867618816,0); 
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',1152829048867618816,{ts'2021-12-03  00:00:00'},'pecompany',1152829048867618816,0); 
DELETE FROM t_tsrbd_cfgmsgtempfd WHERE FID = 1226100873663408128;
INSERT INTO t_tsrbd_cfgmsgtempfd(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1226100873663408128,'1',NULL,' ',' ',1226100873663408128,'C','T_510','工作地点详细地址',0,{ts'2021-08-19  00:00:00'},'1',1152829048867618816,{ts'2021-12-03  00:00:00'},'placework',1152829048867618816,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',1152829048867618816,{ts'2021-12-03  00:00:00'},'candidateemail',1152829048867618816,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',1152829048867618816,{ts'2021-12-03  00:00:00'},'candidatephone',1152829048867618816,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',1152829048867618816,{ts'2021-12-03  00:00:00'},'candidatename',1152829048867618816,0); 
DELETE FROM t_tsrbd_cfgmsgtempfd WHERE FID = 1226097447755900928;
INSERT INTO t_tsrbd_cfgmsgtempfd(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1226097447755900928,'1',NULL,' ',' ',1226097447755900928,'C','T_506','最晚回复Offer Letter日期',0,{ts'2021-08-19  00:00:00'},'1',1152829048867618816,{ts'2021-12-03  00:00:00'},'lastreplytime',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',1152829048867618816,{ts'2021-12-03  00:00:00'},'contactphone',1152829048867618816,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',275188253840125501,{ts'2022-12-01  00:00:00'},'contact',1152829048867618816,0); 
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 = '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 = '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 = '1UL303LIQ58Y';
INSERT INTO t_tsrbd_cfgmsgtempfd_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226097447755900928,'1UL303LIQ58Y','zh_CN',' ',' ','最晚回复Offer Letter日期'); 
DELETE FROM t_tsrbd_cfgmsgtempfd_L WHERE FPKID = '1UL303LIQ58Z';
--INSERT INTO t_tsrbd_cfgmsgtempfd_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226097447755900928,'1UL303LIQ58Z','zh_TW',' ',' ','最晚回複Offer Letter日期'); 
DELETE FROM t_tsrbd_cfgmsgtempfd_L WHERE FPKID = '1UL33XI25QXY';
INSERT INTO t_tsrbd_cfgmsgtempfd_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226097968227074048,'1UL33XI25QXY','zh_CN',' ',' ','查看Offer Letter'); 
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_cfgmsgtempfd_L WHERE FPKID = '1UL3O27KN3ZU';
INSERT INTO t_tsrbd_cfgmsgtempfd_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226100873663408128,'1UL3O27KN3ZU','zh_CN',' ',' ','工作地点详细地址'); 
DELETE FROM t_tsrbd_cfgmsgtempfd_L WHERE FPKID = '1UL3O27KN3ZV';
--INSERT INTO t_tsrbd_cfgmsgtempfd_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226100873663408128,'1UL3O27KN3ZV','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 = '1UL4PRWUQLH3';
INSERT INTO t_tsrbd_cfgmsgtempfd_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226106456760182784,'1UL4PRWUQLH3','zh_CN',' ',' ','验证码'); 
DELETE FROM t_tsrbd_cfgmsgtempfd_L WHERE FPKID = '1UL4PRWUQLH4';
--INSERT INTO t_tsrbd_cfgmsgtempfd_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226106456760182784,'1UL4PRWUQLH4','zh_TW',' ',' ','驗證碼'); 
DELETE FROM t_tsrbd_cfgmsgtempfd_L WHERE FPKID = '1UL33XI25QXZ';
--INSERT INTO t_tsrbd_cfgmsgtempfd_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1226097968227074048,'1UL33XI25QXZ','zh_TW',' ',' ','查看Offer Letter'); 
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 = 1226097447764289536;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1226097447755900928,1080,1226097447764289536); 
DELETE FROM t_tsrbd_cfgpushscenefd WHERE FPKID = 1226097968227074049;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1226097968227074048,1080,1226097968227074049); 
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_cfgpushscenefd WHERE FPKID = 1226100873671796736;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1226100873663408128,1080,1226100873671796736); 
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 = 1226106456768571392;
INSERT INTO t_tsrbd_cfgpushscenefd(FID,FBASEDATAID,FPKID) VALUES (1226106456760182784,1080,1226106456768571392); 
DELETE FROM t_tsrbd_msgchannelfd WHERE FPKID = 1559695544144679937;
INSERT INTO t_tsrbd_msgchannelfd(FID,FBASEDATAID,FPKID) VALUES (1559695543960130560,475773782250774528,1559695544144679937); 
DELETE FROM t_tsrbd_msgchannelfd WHERE FPKID = 1226095788162072578;
INSERT INTO t_tsrbd_msgchannelfd(FID,FBASEDATAID,FPKID) VALUES (1226095788162072576,475773782250774528,1226095788162072578); 
DELETE FROM t_tsrbd_msgchannelfd WHERE FPKID = 1226096436987357186;
INSERT INTO t_tsrbd_msgchannelfd(FID,FBASEDATAID,FPKID) VALUES (1226096436987357184,475773782250774528,1226096436987357186); 
DELETE FROM t_tsrbd_msgchannelfd WHERE FPKID = 1226096630361538562;
INSERT INTO t_tsrbd_msgchannelfd(FID,FBASEDATAID,FPKID) VALUES (1226096630361538560,475773782250774528,1226096630361538562); 
DELETE FROM t_tsrbd_msgchannelfd WHERE FPKID = 1226097447764289537;
INSERT INTO t_tsrbd_msgchannelfd(FID,FBASEDATAID,FPKID) VALUES (1226097447755900928,475773782250774528,1226097447764289537); 
DELETE FROM t_tsrbd_msgchannelfd WHERE FPKID = 1226097968227074050;
INSERT INTO t_tsrbd_msgchannelfd(FID,FBASEDATAID,FPKID) VALUES (1226097968227074048,475773782250774528,1226097968227074050); 
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_msgchannelfd WHERE FPKID = 1226100873671796737;
INSERT INTO t_tsrbd_msgchannelfd(FID,FBASEDATAID,FPKID) VALUES (1226100873663408128,475773782250774528,1226100873671796737); 
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 = 1226104254675075074;
INSERT INTO t_tsrbd_msgchannelfd(FID,FBASEDATAID,FPKID) VALUES (1226104254675075072,475773159430184960,1226104254675075074); 
DELETE FROM t_tsrbd_msgchannelfd WHERE FPKID = 1226106456768571393;
INSERT INTO t_tsrbd_msgchannelfd(FID,FBASEDATAID,FPKID) VALUES (1226106456760182784,475773159430184960,1226106456768571393); 
DELETE FROM t_tsrbd_msgrecefd WHERE FPKID = 1559695544144635906;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1559695543960130560,1030,1559695544144635906); 
DELETE FROM t_tsrbd_msgrecefd WHERE FPKID = 1226094560380250114;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1226094560380239872,1030,1226094560380250114); 
DELETE FROM t_tsrbd_msgrecefd WHERE FPKID = 1226095335403732994;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1226095335403743232,1030,1226095335403732994); 
DELETE FROM t_tsrbd_msgrecefd WHERE FPKID = 1226095788162082818;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1226095788162072576,1030,1226095788162082818); 
DELETE FROM t_tsrbd_msgrecefd WHERE FPKID = 1226096436987346946;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1226096436987357184,1030,1226096436987346946); 
DELETE FROM t_tsrbd_msgrecefd WHERE FPKID = 1226096630361548802;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1226096630361538560,1030,1226096630361548802); 
DELETE FROM t_tsrbd_msgrecefd WHERE FPKID = 1226097447764279298;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1226097447755900928,1030,1226097447764279298); 
DELETE FROM t_tsrbd_msgrecefd WHERE FPKID = 1226097968227084290;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1226097968227074048,1030,1226097968227084290); 
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_msgrecefd WHERE FPKID = 1226100873671786498;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1226100873663408128,1030,1226100873671786498); 
DELETE FROM t_tsrbd_msgrecefd WHERE FPKID = 1226104254675085314;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1226104254675075072,1030,1226104254675085314); 
DELETE FROM t_tsrbd_msgrecefd WHERE FPKID = 1226106456768561154;
INSERT INTO t_tsrbd_msgrecefd(FID,FBASEDATAID,FPKID) VALUES (1226106456760182784,1030,1226106456768561154); 




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'2022-11-27  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,275188253840125501,{ts'2022-11-28  00:00:00'},275188253840125501,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'2022-11-27  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,275188253840125501,{ts'2022-11-27  00:00:00'},275188253840125501,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'2022-11-27  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,275188253840125501,{ts'2022-11-27  00:00:00'},275188253840125501,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'2022-11-27  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,275188253840125501,{ts'2022-11-27  00:00:00'},275188253840125501,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'2022-11-28  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日期 前进行回复，若逾期未回复将视您为主动放弃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,275188253840125501,{ts'2022-11-28  00:00:00'},275188253840125501,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); 


