-- 所有的offer状态先置为0
update t_tsrbd_offerstatus set FINDEX  = 0 where FISSYSPRESET ='1';
-- 待申请
update t_tsrbd_offerstatus set FINDEX  = 10 where fid = 1010010;
-- 申请中
update t_tsrbd_offerstatus set FINDEX  = 20 where fid = 1010020;
-- 申请终止
update t_tsrbd_offerstatus set FINDEX  = 30 where fid = 1010040;
-- 待生成
update t_tsrbd_offerstatus set FINDEX  = 40 where fid = 1020050;
-- 待发送
update t_tsrbd_offerstatus set FINDEX  = 50 where fid = 1020010;
--逾期未发送
update t_tsrbd_offerstatus set FINDEX  = 60 where fid = 1020020;
--待回复
update t_tsrbd_offerstatus set FINDEX  = 70 where fid = 1040010;
-- 逾期未回复
update t_tsrbd_offerstatus set FINDEX  = 80 where fid = 1040020;
-- 已接受
update t_tsrbd_offerstatus set FINDEX  = 90 where fid = 1040030;
-- 已拒绝
update t_tsrbd_offerstatus set FINDEX  = 100 where fid = 1040040;
-- 已废弃
update t_tsrbd_offerstatus set FINDEX  = 110 where fid = 1010050;

--offer配置
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":"1","letteraudit":"1","noreplayouttime":"false","refuseoffer":"false","outvalidtime":"false","lettervalidswitch":"2","lastsendday":7,"validday":60,"lastreplayday":5}',0,' ','tsrbd_offerconfig',' ',0,{ts'2022-03-01  00:00:00'},' ',0,{ts'2022-03-01  00:00:00'},0,0);

--验证码绑定到letter对象
DELETE FROM t_tsrbd_msgfield WHERE FID = 1287628358061927424;
INSERT INTO t_tsrbd_msgfield(FID,FDISABLEDATE,FFIELDPOOLID,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FBIZRANGE,FCREATETIME,FENABLE,FMODIFIERID,FBIZFIELD,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1287628358061927424,NULL,1287612296545207296,1287628358061927424,'C','T-20211112-02018','验证码',1330385865343538176,',1,',{ts'2021-11-12  00:00:00'},'1',1164453183364274176,'verifycode',{ts'2022-02-25  00:00:00'},1164988236288777216,0);
