--添加Offer通知变量字段
DELETE FROM T_TSRBD_CFGMSGTEMPFD WHERE FID = 1728221494837787648;
INSERT INTO T_TSRBD_CFGMSGTEMPFD(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (1728221494837787648,'1',NULL,' ',' ',1728221494837787648,'C','T_515','Offer 发送日期',0,{ts'2023-07-13  00:00:00'},'1',1426680676765178880,{ts'2023-07-13  00:00:00'},'sendofferdate',1426680676765178880,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',1426680676765178880,{ts'2023-07-13  00:00:00'},'pemploymenttime',1426680676765178880,0);
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '3E9QRGAKO1JU';
INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1728221494837787648,'3E9QRGAKO1JU','zh_CN',' ',' ','Offer 发送日期');
DELETE FROM T_TSRBD_CFGMSGTEMPFD_L WHERE FPKID = '3E9QRGAKO1JV';
--INSERT INTO T_TSRBD_CFGMSGTEMPFD_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1728221494837787648,'3E9QRGAKO1JV','zh_TW',' ',' ','Offer 發送日期');
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_MSGRECEFD WHERE FPKID = 1728221495315982338;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1728221494837787648,1030,1728221495315982338);
DELETE FROM T_TSRBD_MSGRECEFD WHERE FPKID = 1728221829752962050;
INSERT INTO T_TSRBD_MSGRECEFD(FID,FBASEDATAID,FPKID) VALUES (1728221829711063040,1030,1728221829752962050);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1728221495315938305;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1728221494837787648,475773782250774528,1728221495315938305);
DELETE FROM T_TSRBD_MSGCHANNELFD WHERE FPKID = 1728221829753006081;
INSERT INTO T_TSRBD_MSGCHANNELFD(FID,FBASEDATAID,FPKID) VALUES (1728221829711063040,475773782250774528,1728221829753006081);
DELETE FROM T_TSRBD_CFGPUSHSCENEFD WHERE FPKID = 1728221495315938304;
INSERT INTO T_TSRBD_CFGPUSHSCENEFD(FID,FBASEDATAID,FPKID) VALUES (1728221494837787648,1080,1728221495315938304);
DELETE FROM T_TSRBD_CFGPUSHSCENEFD WHERE FPKID = 1728221829753006080;
INSERT INTO T_TSRBD_CFGPUSHSCENEFD(FID,FBASEDATAID,FPKID) VALUES (1728221829711063040,1080,1728221829753006080);


