-- 招聘状态
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10110;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10110,'1',NULL,'已发放',1360726499186983936,'C','10110_S','已发放',10030,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10020;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10020,'1',NULL,'进行中',1360736445324608512,'C','10020_S','进行中',10010,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10030;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10030,'1',NULL,'本轮通过',1360736590833402880,'C','10030_S','本轮通过',10010,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10120;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10120,'1',NULL,'发放中',1360726655550635008,'C','10120_S','发放中',10030,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10010;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10010,'1',NULL,'本轮待定',1360724956782019584,'C','10010_S','本轮待定',10010,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10040;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10040,'1',NULL,'本轮淘汰',1360725470055777280,'C','10040_S','本轮淘汰',10010,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10050;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10050,'1',NULL,'本轮待定',1360725681943624704,'C','10050_S','本轮待定',10020,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10060;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10060,'1',NULL,'进行中',1360725812101268480,'C','10060_S','进行中',10020,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10070;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10070,'1',NULL,'本轮通过',1360726010047249408,'C','10070_S','本轮通过',10020,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10080;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10080,'1',NULL,'本轮淘汰',1360726150850036736,'C','10080_S','本轮淘汰',10020,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10090;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10090,'1',NULL,'待发放',1360726351488762880,'C','10090_S','待发放',10030,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10130;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10130,'1',NULL,'待入职',1360726922098654208,'C','10130_S','待入职',10040,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10140;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10140,'1',NULL,'已入职',1360727210180232192,'C','10140_S','已入职',10040,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10150;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10150,'1',NULL,'入职终止',1360727401364997120,'C','10150_S','入职终止',10040,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10160;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10160,'1',NULL,'预置数据',1519623413088390144,'C','10160_S','待录用',10050,{ts'2022-09-28  00:00:00'},'1',1426825907217129472,{ts'2022-09-28  00:00:00'},1426825907217129472,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10170;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10170,'1',NULL,'预置数据',1519623568890009600,'C','10170_S','录用中',10050,{ts'2022-09-28  00:00:00'},'1',1426825907217129472,{ts'2022-09-28  00:00:00'},1426825907217129472,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10180;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10180,'1',NULL,'预置数据',1519623716076525568,'C','10180_S','已录用',10050,{ts'2022-09-28  00:00:00'},'1',1426825907217129472,{ts'2022-09-28  00:00:00'},1426825907217129472,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10190;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10190,'1',NULL,'预置数据',1519623859639162880,'C','10190_S','终止录用',10050,{ts'2022-09-28  00:00:00'},'1',1426825907217129472,{ts'2022-09-28  00:00:00'},1426825907217129472,0);
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2RNC2TLIFFOO';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10160,'2RNC2TLIFFOO','zh_CN','预置数据','待录用');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2RNC2TLIFFOP';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10160,'2RNC2TLIFFOP','zh_TW','預置數據','待錄用');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2RNC3YW1UKY+';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10170,'2RNC3YW1UKY+','zh_CN','预置数据','录用中');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2RNC3YW1UKY/';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10170,'2RNC3YW1UKY/','zh_TW','預置數據','錄用中');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2RNC5/PHT03F';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10180,'2RNC5/PHT03F','zh_CN','预置数据','已录用');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2RNC5/PHT03G';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10180,'2RNC5/PHT03G','zh_TW','預置數據','已錄用');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2RNC61HOOOWV';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10190,'2RNC61HOOOWV','zh_CN','预置数据','终止录用');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2RNC61HOOOWW';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10190,'2RNC61HOOOWW','zh_TW','預置數據','終止錄用');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '25OYACXTLW5M';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10010,'25OYACXTLW5M','zh_CN','本轮待定','本轮待定');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '25OYACXTLW5N';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10010,'25OYACXTLW5N','zh_TW','本輪待定','本輪待定');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942RPLIIND1';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10020,'2942RPLIIND1','zh_CN','进行中','进行中');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942RPLIIND2';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10020,'2942RPLIIND2','zh_TW','進行中','進行中');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942T4VJLGK3';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10030,'2942T4VJLGK3','zh_CN','本轮通过','本轮通过');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942T4VJLGK4';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10030,'2942T4VJLGK4','zh_TW','本輪通過','本輪通過');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942QRLY0HSN';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10050,'2942QRLY0HSN','zh_CN','本轮待定','本轮待定');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942QRLY0HSO';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10050,'2942QRLY0HSO','zh_TW','本輪待定','本輪待定');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942WPVYFHV5';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10110,'2942WPVYFHV5','zh_CN','已发放','已发放');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942WPVYFHV6';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10110,'2942WPVYFHV6','zh_TW','已發放','已發放');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942XV=X0CR4';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10120,'2942XV=X0CR4','zh_CN','发放中','发放中');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942XV=X0CR5';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10120,'2942XV=X0CR5','zh_TW','發放中','發放中');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942P7DJRFUA';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10040,'2942P7DJRFUA','zh_CN','本轮淘汰','本轮淘汰');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942P7DJRFUB';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10040,'2942P7DJRFUB','zh_TW','本輪淘汰','本輪淘汰');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2944R6GZGJG2';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10060,'2944R6GZGJG2','zh_CN','进行中','进行中');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2944R6GZGJG3';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10060,'2944R6GZGJG3','zh_TW','進行中','進行中');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2944S8UPLIYG';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10070,'2944S8UPLIYG','zh_CN','本轮通过','本轮通过');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2944S8UPLIYH';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10070,'2944S8UPLIYH','zh_TW','本輪通過','本輪通過');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942U5W0X2ES';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10080,'2942U5W0X2ES','zh_CN','本轮淘汰','本轮淘汰');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942U5W0X2ET';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10080,'2942U5W0X2ET','zh_TW','本輪淘汰','本輪淘汰');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942VMWU=QXE';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10090,'2942VMWU=QXE','zh_CN','待发放','待发放');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942VMWU=QXF';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10090,'2942VMWU=QXF','zh_TW','待發放','待發放');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '25OX31W67330';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10130,'25OX31W67330','zh_CN','待入职','待入职');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '25OX31W67331';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10130,'25OX31W67331','zh_TW','待入職','待入職');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2943/WY4=UYS';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10140,'2943/WY4=UYS','zh_CN','已入职','已入职');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2943/WY4=UYT';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10140,'2943/WY4=UYT','zh_TW','已入職','已入職');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '29431=97T+I+';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10150,'29431=97T+I+','zh_CN','入职终止','入职终止');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '29431=97T+I/';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10150,'29431=97T+I/','zh_TW','入職終止','入職終止');
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061414232605618176;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10030,10010,1061414232605618176,1);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061414232605618177;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10030,10020,1061414232605618177,2);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061414232605618178;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10030,10030,1061414232605618178,3);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061414232605618179;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10030,10040,1061414232605618179,4);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061414232605618180;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10030,10050,1061414232605618180,5);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061414232605618181;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10030,10060,1061414232605618181,6);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061414232605618182;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10030,10080,1061414232605618182,7);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061414232605618183;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10030,10090,1061414232605618183,8);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061420617493936128;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10070,10010,1061420617493936128,1);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061420617493936129;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10070,10020,1061420617493936129,2);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061420617493936130;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10070,10030,1061420617493936130,3);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061420617493936131;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10070,10040,1061420617493936131,4);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061420617493936132;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10070,10050,1061420617493936132,5);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061420617493936133;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10070,10060,1061420617493936133,6);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061420617493936134;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10070,10080,1061420617493936134,7);
DELETE FROM t_tsrbd_rsnselnewentry WHERE FENTRYID = 1061420617493936135;
INSERT INTO t_tsrbd_rsnselnewentry(FID,FREASONNUMBER,FENTRYID,FSEQ) VALUES (10070,10090,1061420617493936135,8);

-- 招聘环节 调整对应状态的顺序
DELETE FROM t_tsrbd_recrustgnew WHERE FID = 10010;
INSERT INTO t_tsrbd_recrustgnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10010,'1',NULL,'HR专员/部门经理/招聘助理筛选简历',10010,'C','10010_S',' ',1010,{ts'2021-01-04  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,1);
DELETE FROM t_tsrbd_recrustgnew WHERE FID = 10020;
INSERT INTO t_tsrbd_recrustgnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10020,'1',NULL,'候选人参加面试',10020,'C','10020_S',' ',1020,{ts'2021-01-04  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,1);
DELETE FROM t_tsrbd_recrustgnew WHERE FID = 10030;
INSERT INTO t_tsrbd_recrustgnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10030,'1',NULL,'Offer商谈及发送',10030,'C','10030_S',' ',1030,{ts'2021-01-04  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,1);
DELETE FROM t_tsrbd_recrustgnew WHERE FID = 10040;
INSERT INTO t_tsrbd_recrustgnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10040,'1',NULL,'入职',10040,'C','10040_S',' ',1040,{ts'2022-01-13  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustgnew WHERE FID = 10050;
INSERT INTO t_tsrbd_recrustgnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10050,'1',NULL,'预置数据',1519623209983413248,'C','10050_S','录用',1050,{ts'2022-09-28  00:00:00'},'1',1426825907217129472,{ts'2022-09-28  00:00:00'},1426825907217129472,0);
DELETE FROM t_tsrbd_recrustgnew_L WHERE FPKID = '25OX+B3WP=JB';
INSERT INTO t_tsrbd_recrustgnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10040,'25OX+B3WP=JB','zh_CN','入职','入职');
DELETE FROM t_tsrbd_recrustgnew_L WHERE FPKID = '25OX+B3WP=JC';
--INSERT INTO t_tsrbd_recrustgnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10040,'25OX+B3WP=JC','zh_TW','入職','入職');
DELETE FROM t_tsrbd_recrustgnew_L WHERE FPKID = '1AC5=LWRN/K6';
--INSERT INTO t_tsrbd_recrustgnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10030,'1AC5=LWRN/K6','zh_TW','Offer商談及發送','Offer');
DELETE FROM t_tsrbd_recrustgnew_L WHERE FPKID = '1AC27FT877VD';
INSERT INTO t_tsrbd_recrustgnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10010,'1AC27FT877VD','zh_CN','HR专员/部门经理/招聘助理筛选简历','简历筛选');
DELETE FROM t_tsrbd_recrustgnew_L WHERE FPKID = '1AC27FT877VE';
--INSERT INTO t_tsrbd_recrustgnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10010,'1AC27FT877VE','zh_TW','HR專員/部門經理/招聘助理篩選簡曆','簡曆篩选');
DELETE FROM t_tsrbd_recrustgnew_L WHERE FPKID = '1AC4M3FOQJ01';
INSERT INTO t_tsrbd_recrustgnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10020,'1AC4M3FOQJ01','zh_CN','候选人参加面试','面试');
DELETE FROM t_tsrbd_recrustgnew_L WHERE FPKID = '1AC4M3FOQJ02';
--INSERT INTO t_tsrbd_recrustgnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10020,'1AC4M3FOQJ02','zh_TW','候選人參加麵試','麵試');
DELETE FROM t_tsrbd_recrustgnew_L WHERE FPKID = '1AC5=LWRN/K5';
INSERT INTO t_tsrbd_recrustgnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10030,'1AC5=LWRN/K5','zh_CN','Offer商谈及发送','Offer');
DELETE FROM t_tsrbd_recrustgnew_L WHERE FPKID = '2RNC1AWACACR';
INSERT INTO t_tsrbd_recrustgnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10050,'2RNC1AWACACR','zh_CN','预置数据','录用');
DELETE FROM t_tsrbd_recrustgnew_L WHERE FPKID = '2RNC1AWACACS';
--INSERT INTO t_tsrbd_recrustgnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10050,'2RNC1AWACACS','zh_TW','預置數據','錄用');
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 1504945790064286720;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10050,10160,1504945790064286720,1);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 1504945943659698176;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10050,10170,1504945943659698176,2);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 1504946101088704512;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10050,10180,1504946101088704512,3);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 1504946250221377536;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10050,10190,1504946250221377536,4);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10060;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10020,10050,10060,1);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10070;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10020,10060,10070,2);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10050;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10020,10070,10050,3);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10140;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10020,10080,10140,4);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10100;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10030,10090,10100,1);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10080;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10030,10120,10080,3);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10040;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10010,10010,10040,1);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10020;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10010,10020,10020,2);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10010;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10010,10030,10010,3);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10030;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10010,10040,10030,4);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10090;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10030,10110,10090,2);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10110;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10040,10130,10110,1);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10120;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10040,10140,10120,2);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10130;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10040,10150,10130,3);

-- 招聘环节类型
DELETE FROM t_tsrbd_recrustgtyp WHERE FID = 1010;
INSERT INTO t_tsrbd_recrustgtyp(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1010,'1',NULL,' ','HR专员/部门经理/招聘助理筛选简历',1031163333195096064,'C','1010_S','筛选',1,{ts'2020-11-23  00:00:00'},'1',1426825907217129472,{ts'2022-09-02  00:00:00'},100,0);
DELETE FROM t_tsrbd_recrustgtyp WHERE FID = 1020;
INSERT INTO t_tsrbd_recrustgtyp(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1020,'1',NULL,' ','候选人参加面试',1031169687288832000,'C','1020_S','面试',2,{ts'2020-11-23  00:00:00'},'1',1426825907217129472,{ts'2022-09-02  00:00:00'},100,0);
DELETE FROM t_tsrbd_recrustgtyp WHERE FID = 1030;
INSERT INTO t_tsrbd_recrustgtyp(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1030,'1',NULL,' ','Offer商谈及发送',1031171453837401088,'C','1030_S','Offer',3,{ts'2020-11-23  00:00:00'},'1',1426825907217129472,{ts'2022-09-02  00:00:00'},100,0);
DELETE FROM t_tsrbd_recrustgtyp WHERE FID = 1040;
INSERT INTO t_tsrbd_recrustgtyp(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1040,'1',NULL,' ','候选人办理入职',1031171592845025280,'C','1040_S','入职',4,{ts'2020-11-23  00:00:00'},'1',1426825907217129472,{ts'2022-09-02  00:00:00'},100,0);
DELETE FROM t_tsrbd_recrustgtyp WHERE FID = 1050;
INSERT INTO t_tsrbd_recrustgtyp(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1050,'1',NULL,' ','员工录用',1500727106689063936,'C','1050_S','录用',5,{ts'2022-09-02  00:00:00'},'1',1426825907217129472,{ts'2022-09-02  00:00:00'},1426825907217129472,0);
DELETE FROM t_tsrbd_recrustgtyp WHERE FID = 1060;
INSERT INTO t_tsrbd_recrustgtyp(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1060,'1',NULL,' ','员工进行调动',1500727315288579072,'C','1060_S','调动',6,{ts'2022-09-02  00:00:00'},'1',1426825907217129472,{ts'2022-09-02  00:00:00'},1426825907217129472,0);
DELETE FROM t_tsrbd_recrustgtyp_L WHERE FPKID = '17N7LVI3SPGL';
--INSERT INTO t_tsrbd_recrustgtyp_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1040,'17N7LVI3SPGL','zh_TW',' ','候選人參加麵試','麵試');
DELETE FROM t_tsrbd_recrustgtyp_L WHERE FPKID = '17N6EM9XFEO5';
INSERT INTO t_tsrbd_recrustgtyp_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1010,'17N6EM9XFEO5','zh_CN',' ','HR专员/部门经理/招聘助理筛选简历','筛选');
DELETE FROM t_tsrbd_recrustgtyp_L WHERE FPKID = '17N6EM9XFEO6';
--INSERT INTO t_tsrbd_recrustgtyp_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1010,'17N6EM9XFEO6','zh_TW',' ','HR專員/部門經理/招聘助理篩選簡曆','篩選');
DELETE FROM t_tsrbd_recrustgtyp_L WHERE FPKID = '17N7HNDPUMD/';
INSERT INTO t_tsrbd_recrustgtyp_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1020,'17N7HNDPUMD/','zh_CN',' ','候选人参加笔试考试','面试');
DELETE FROM t_tsrbd_recrustgtyp_L WHERE FPKID = '17N7HNDPUMD0';
--INSERT INTO t_tsrbd_recrustgtyp_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1020,'17N7HNDPUMD0','zh_TW',' ','候選人參加筆試考試','面试');
DELETE FROM t_tsrbd_recrustgtyp_L WHERE FPKID = '17N7KQJYNRHZ';
INSERT INTO t_tsrbd_recrustgtyp_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1030,'17N7KQJYNRHZ','zh_CN',' ','候选人参加测评','Offer');
DELETE FROM t_tsrbd_recrustgtyp_L WHERE FPKID = '17N7KQJYNRI+';
--INSERT INTO t_tsrbd_recrustgtyp_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1030,'17N7KQJYNRI+','zh_TW',' ','候選人參加測評','Offer');
DELETE FROM t_tsrbd_recrustgtyp_L WHERE FPKID = '17N7LVI3SPGK';
INSERT INTO t_tsrbd_recrustgtyp_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1040,'17N7LVI3SPGK','zh_CN',' ','候选人参加面试','入职');
DELETE FROM t_tsrbd_recrustgtyp_L WHERE FPKID = '17N7V8IADGCC';
INSERT INTO t_tsrbd_recrustgtyp_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1050,'17N7V8IADGCC','zh_CN',' ','员工录用','录用');
DELETE FROM t_tsrbd_recrustgtyp_L WHERE FPKID = '17N7V8IADGCD';
--INSERT INTO t_tsrbd_recrustgtyp_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1050,'17N7V8IADGCD','zh_TW',' ','員工錄用','錄用');
DELETE FROM t_tsrbd_recrustgtyp_L WHERE FPKID = '17N7WAR/0/U6';
INSERT INTO t_tsrbd_recrustgtyp_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1060,'17N7WAR/0/U6','zh_CN',' ','员工进行调动','调动');
DELETE FROM t_tsrbd_recrustgtyp_L WHERE FPKID = '17N7WAR/0/U7';
--INSERT INTO t_tsrbd_recrustgtyp_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1060,'17N7WAR/0/U7','zh_TW',' ','員工進行調動','調動');
DELETE FROM t_tsrbd_recrutyp WHERE FPKID = 1500739144215713792;
INSERT INTO t_tsrbd_recrutyp(FID,FBASEDATAID,FPKID) VALUES (1010,1010,1500739144215713792);
DELETE FROM t_tsrbd_recrutyp WHERE FPKID = 1500739144215713793;
INSERT INTO t_tsrbd_recrutyp(FID,FBASEDATAID,FPKID) VALUES (1010,1020,1500739144215713793);
DELETE FROM t_tsrbd_recrutyp WHERE FPKID = 1500739144215713794;
INSERT INTO t_tsrbd_recrutyp(FID,FBASEDATAID,FPKID) VALUES (1010,1030,1500739144215713794);
DELETE FROM t_tsrbd_recrutyp WHERE FPKID = 1500739227153882112;
INSERT INTO t_tsrbd_recrutyp(FID,FBASEDATAID,FPKID) VALUES (1020,1010,1500739227153882112);
DELETE FROM t_tsrbd_recrutyp WHERE FPKID = 1500739227153882113;
INSERT INTO t_tsrbd_recrutyp(FID,FBASEDATAID,FPKID) VALUES (1020,1020,1500739227153882113);
DELETE FROM t_tsrbd_recrutyp WHERE FPKID = 1500739227153882114;
INSERT INTO t_tsrbd_recrutyp(FID,FBASEDATAID,FPKID) VALUES (1020,1030,1500739227153882114);
DELETE FROM t_tsrbd_recrutyp WHERE FPKID = 1500739310259820544;
INSERT INTO t_tsrbd_recrutyp(FID,FBASEDATAID,FPKID) VALUES (1030,1010,1500739310259820544);
DELETE FROM t_tsrbd_recrutyp WHERE FPKID = 1500739310259820545;
INSERT INTO t_tsrbd_recrutyp(FID,FBASEDATAID,FPKID) VALUES (1030,1020,1500739310259820545);
DELETE FROM t_tsrbd_recrutyp WHERE FPKID = 1500739403440478208;
INSERT INTO t_tsrbd_recrutyp(FID,FBASEDATAID,FPKID) VALUES (1040,1010,1500739403440478208);
DELETE FROM t_tsrbd_recrutyp WHERE FPKID = 1500739403440478209;
INSERT INTO t_tsrbd_recrutyp(FID,FBASEDATAID,FPKID) VALUES (1040,1020,1500739403440478209);
DELETE FROM t_tsrbd_recrutyp WHERE FPKID = 1500740219618483200;
INSERT INTO t_tsrbd_recrutyp(FID,FBASEDATAID,FPKID) VALUES (1050,1030,1500740219618483200);
DELETE FROM t_tsrbd_recrutyp WHERE FPKID = 1500740364716235776;
INSERT INTO t_tsrbd_recrutyp(FID,FBASEDATAID,FPKID) VALUES (1060,1030,1500740364716235776);

-- 招聘流程 调整了招聘状态顺序
DELETE FROM t_tsrbd_rqmtproc WHERE FID = 1020;
INSERT INTO t_tsrbd_rqmtproc(FID,FISSYSPRESET,FUSEORGID,FCREATEORGID,FDISABLEDATE,FISDEFAULT,FMASTERID,FORGID,FRECRUSCENEID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1020,'1',100000,100000,NULL,'1',1519459871655727104,100000,0,'C','5','1020_S','内部招聘流程',1030,{ts'2022-09-28  00:00:00'},'1',1426825907217129472,{ts'2022-09-30  00:00:00'},1426825907217129472,0);
DELETE FROM t_tsrbd_rqmtproc WHERE FID = 1010;
INSERT INTO t_tsrbd_rqmtproc(FID,FISSYSPRESET,FUSEORGID,FCREATEORGID,FDISABLEDATE,FISDEFAULT,FMASTERID,FORGID,FRECRUSCENEID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1010,'1',100000,100000,NULL,'1',1519455359322820608,100000,0,'C','5','1010_S','社会招聘流程',1020,{ts'2022-09-28  00:00:00'},'1',1426825907217129472,{ts'2022-10-10  00:00:00'},1426825907217129472,0);
DELETE FROM t_tsrbd_rqmtproc_L WHERE FPKID = '2RMJP74Y=P30';
INSERT INTO t_tsrbd_rqmtproc_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010,'2RMJP74Y=P30','zh_CN','适用于社会招聘的流程','社会招聘流程');
DELETE FROM t_tsrbd_rqmtproc_L WHERE FPKID = '2RMJP74Y=P31';
--INSERT INTO t_tsrbd_rqmtproc_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010,'2RMJP74Y=P31','zh_TW','適用於社會招聘的流程','社會招聘流程');
DELETE FROM t_tsrbd_rqmtproc_L WHERE FPKID = '2RMKJ2CPI5T1';
INSERT INTO t_tsrbd_rqmtproc_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020,'2RMKJ2CPI5T1','zh_CN','适用于内部招聘的流程','内部招聘流程');
DELETE FROM t_tsrbd_rqmtproc_L WHERE FPKID = '2RMKJ2CPI5T2';
--INSERT INTO t_tsrbd_rqmtproc_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020,'2RMKJ2CPI5T2','zh_TW','適用於內部招聘的流程','內部招聘流程');
DELETE FROM t_tsrbd_rqmtprocentity WHERE FENTRYID = 1519455359842914304;
INSERT INTO t_tsrbd_rqmtprocentity(FID,FENTRYID,FSEQ,FRQMTSTGID) VALUES (1010,1519455359842914304,1,10010);
DELETE FROM t_tsrbd_rqmtprocentity WHERE FENTRYID = 1519455359842914305;
INSERT INTO t_tsrbd_rqmtprocentity(FID,FENTRYID,FSEQ,FRQMTSTGID) VALUES (1010,1519455359842914305,2,10020);
DELETE FROM t_tsrbd_rqmtprocentity WHERE FENTRYID = 1519455359842914306;
INSERT INTO t_tsrbd_rqmtprocentity(FID,FENTRYID,FSEQ,FRQMTSTGID) VALUES (1010,1519455359842914306,3,10030);
DELETE FROM t_tsrbd_rqmtprocentity WHERE FENTRYID = 1519455359842914307;
INSERT INTO t_tsrbd_rqmtprocentity(FID,FENTRYID,FSEQ,FRQMTSTGID) VALUES (1010,1519455359842914307,4,10040);
DELETE FROM t_tsrbd_rqmtprocentity WHERE FENTRYID = 1519459871664115712;
INSERT INTO t_tsrbd_rqmtprocentity(FID,FENTRYID,FSEQ,FRQMTSTGID) VALUES (1020,1519459871664115712,1,10010);
DELETE FROM t_tsrbd_rqmtprocentity WHERE FENTRYID = 1519459871664115713;
INSERT INTO t_tsrbd_rqmtprocentity(FID,FENTRYID,FSEQ,FRQMTSTGID) VALUES (1020,1519459871664115713,2,10020);
DELETE FROM t_tsrbd_rqmtprocentity WHERE FENTRYID = 1519459871664115714;
INSERT INTO t_tsrbd_rqmtprocentity(FID,FENTRYID,FSEQ,FRQMTSTGID) VALUES (1020,1519459871664115714,3,10050);
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915330;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915330,1519455359842914304,1,'0',10010,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915331;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915331,1519455359842914304,2,'0',10020,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915332;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915332,1519455359842914304,3,'0',10030,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915333;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915333,1519455359842914304,4,'0',10040,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915339;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915339,1519455359842914306,2,'0',10110,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915341;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915341,1519455359842914307,1,'0',10130,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915342;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915342,1519455359842914307,2,'0',10140,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915343;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915343,1519455359842914307,3,'0',10150,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519459871664116738;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519459871664116738,1519459871664115712,1,'0',10010,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519459871664116739;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519459871664116739,1519459871664115712,2,'0',10020,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519459871664116740;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519459871664116740,1519459871664115712,3,'0',10030,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519459871664116741;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519459871664116741,1519459871664115712,4,'0',10040,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519459871664116746;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519459871664116746,1519459871664115714,1,'0',10160,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519459871664116747;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519459871664116747,1519459871664115714,2,'0',10170,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519459871664116748;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519459871664116748,1519459871664115714,3,'0',10180,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519459871664116749;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519459871664116749,1519459871664115714,4,'0',10190,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915334;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915334,1519455359842914305,4,'0',10080,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915335;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915335,1519455359842914305,3,'0',10070,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915336;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915336,1519455359842914305,1,'0',10050,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915337;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915337,1519455359842914305,2,'0',10060,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915338;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915338,1519455359842914306,3,'0',10120,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519455359842915340;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519455359842915340,1519455359842914306,1,'0',10090,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519459871664116742;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519459871664116742,1519459871664115713,4,'0',10080,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519459871664116743;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519459871664116743,1519459871664115713,3,'0',10070,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519459871664116744;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519459871664116744,1519459871664115713,1,'0',10050,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1519459871664116745;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1519459871664116745,1519459871664115713,2,'0',10060,'0');

--清除招聘状态多语言历史预置数据
delete from t_tsrbd_recrustatnew_l t where t.fpkid = '2RNC2TLIFFOO';
delete from t_tsrbd_recrustatnew_l t where t.fpkid = '2PV0N7H4ZJYI';
delete from t_tsrbd_recrustatnew_l t where t.fpkid = '2PV0OB8X/AUL';
delete from t_tsrbd_recrustatnew_l t where t.fpkid = '2PV0OB8X/AUM';

delete from t_tsrbd_recrustatnew_l t where t.fpkid = '2PV0PH+GV1G5';
delete from t_tsrbd_recrustatnew_l t where t.fpkid = '2PV0PH+GV1G6';
delete from t_tsrbd_recrustatnew_l t where t.fpkid = '2PV0QKC3J5KK';
delete from t_tsrbd_recrustatnew_l t where t.fpkid = '2PV0QKC3J5KJ';
