-- 消息模板
DELETE
FROM t_tsrbd_cfgmsgtemplate
WHERE FID = 1140;
INSERT INTO t_tsrbd_cfgmsgtemplate(FBITINDEX, FRECRUTYPLIST, FISSYSPRESET, FUSEORGID, FCREATEORGID, FINTVCATEGORYLIST,
                                   FINTVMETHODLIST, FDESCRIPTION, FMASTERID, FMSGPUSHSCENEID, FCTRLSTRATEGY,
                                   FSMSTEMPLATE, FEMAILRICHTEXT, FCREATETIME,
                                   FMSGRECEIVERID, FENABLE, FEMAILRICHTEXT_TAG, FEMAILTHEME, FDISABLERID, FID,
                                   FDISABLEDATE, FSOURCEDATAID, FSIMPLENAME, FORGID,
                                   FMSGCHANNELLIST, FSTATUS, FNUMBER, FNAME, FINDEX, FYZJTEMPLATE, FSOURCEBITINDEX,
                                   FMODIFIERID, FMODIFYTIME, FCREATORID,
                                   FRECRUTYPEID)
VALUES (0, ' ', '1', 100000, 100000, ' ', ' ', ' ', 1140, 1140, '5',
        '{候选人姓名}，您好：恭喜您通过简历筛选，已为您安排笔试，详细信息如下，职位名称：{职位名称}；笔试时间：；笔试地点：；备注：请携带证件/材料', ' ', {ts '1900-01-01  00:00:00'},
        1030, '1', '
<p>{候选人姓名}，您好：</p>
<p>    恭喜您通过简历筛选，已为您安排笔试，详细信息如下</p>
<p>        职位名称：{职位名称}</p>
<p>        笔试时间：</p>
<p>        笔试地点：</p>
<p>    备注：请携带证件/材料</p>'
           , '笔试邀约通知', 0, 1140, NULL, 0, ' ', 100000, ',475773782250774528,475773159430184960,', 'C', '1140_S', '笔试邀约',
        0, ' ', 0, 13466739,
        {ts '1900-01-01  00:00:00'}, 1, 0);