DELETE FROM t_tsrbd_msgtemptype WHERE FID = 1010;
INSERT INTO t_tsrbd_msgtemptype(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1010,'0',NULL,' ',' ',1560422088479617024,'C','1010_S','Offer Letter模板',0,{ts'2022-11-23  00:00:00'},'1',275188253840125501,{ts'2022-11-23  00:00:00'},275188253840125501,0); 
DELETE FROM t_tsrbd_msgtemptype_L WHERE FPKID = '2WNUBIXZ7LP4';
INSERT INTO t_tsrbd_msgtemptype_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1010,'2WNUBIXZ7LP4','zh_CN',' ',' ','Offer Letter模板'); 
DELETE FROM t_tsrbd_msgtemptype_L WHERE FPKID = '2WNUBIXZ7LP5';
--INSERT INTO t_tsrbd_msgtemptype_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1010,'2WNUBIXZ7LP5','zh_TW',' ',' ','Offer Letter模板'); 


DELETE FROM t_tsrbd_msgtempfldscm WHERE FID = 1010;
INSERT INTO t_tsrbd_msgtempfldscm(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPTYPE,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FSALARYDETTYPE,FCREATORID,FDISABLERID) VALUES (1010,'0',NULL,' ','Offer Letter模板可以选择薪酬定薪的薪酬标准项目或招聘定薪的通用薪酬项目相关字段',1010,'C','P001','Offer Letter模板可选字段方案',1010,0,{ts'2022-11-24  00:00:00'},'1',275188253840125501,{ts'2022-12-01  00:00:00'},'2',275188253840125501,0); 
DELETE FROM t_tsrbd_msgtempfldscm_L WHERE FPKID = '2WR96FPODBNK';
INSERT INTO t_tsrbd_msgtempfldscm_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1010,'2WR96FPODBNK','zh_CN',' ','Offer Letter模板可以选择薪酬定薪的薪酬标准项目或招聘定薪的通用薪酬项目相关字段','Offer Letter模板可选字段方案'); 
DELETE FROM t_tsrbd_msgtempfldscm_L WHERE FPKID = '2WR96FPODBNL';
--INSERT INTO t_tsrbd_msgtempfldscm_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1010,'2WR96FPODBNL','zh_TW',' ','Offer Letter模板可以選擇薪酬定薪的薪酬標準項目或招聘定薪的通用薪酬項目相關字段','Offer Letter模板可選字段方案'); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1561139765099636736;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0',1561139765099636736,1287622177201357824,1); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1561139765099636737;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0',1561139765099636737,1287621990068268032,2); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1561139765099636738;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0',1561139765099636738,1287621766990038016,3); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1561139765099636739;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0',1561139765099636739,1287621548601017344,4); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1561139765099636742;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0',1561139765099636742,1287620997461060608,5); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1561139765099636743;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0',1561139765099636743,1287620793148146688,6); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1561139765099636744;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0',1561139765099636744,1287620633789760512,7); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1561139765099636745;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0',1561139765099636745,1287620475698031616,8); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1561139765099636746;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0',1561139765099636746,1315255962348565504,9); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1561139765099636747;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0',1561139765099636747,1287620263524992000,10); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1561139765099636748;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0',1561139765099636748,1287620140925463552,11); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1561139765099636749;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0',1561139765099636749,1287619924272907264,12); 


DELETE FROM t_tsrbd_bizconfigdata WHERE FID = 1320971100091381760;
INSERT INTO t_tsrbd_bizconfigdata(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FDATA,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1320971100091381760,'0',NULL,' ',' ','{"audit":"2","letteraudit":"2","noreplayouttime":"false","refuseoffer":"false","outvalidtime":"false","lettervalidswitch":"2","validday":60,"lastreplayday":5,"lastsendday":7,"salarydettype":"2","sendtype":"1","logintype":"1"}',0,' ','tsrbd_offerconfig',' ',0,{ts'2022-03-01  00:00:00'},' ',0,{ts'2022-03-01  00:00:00'},0,0); 
