DELETE FROM t_tsrbd_recrursn WHERE FID = 1070010;
INSERT INTO t_tsrbd_recrursn(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) 
VALUES (1070010,'1',NULL,'原岗位替换',1070,'C','1070010_S','原岗位替换',1070,{ts'2021-09-18  00:00:00'},'1',13466739,{ts'2021-09-18  00:00:00'},13466739,0); 
DELETE FROM t_tsrbd_recrursn WHERE FID = 1070020;
INSERT INTO t_tsrbd_recrursn(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) 
VALUES (1070020,'1',NULL,'缺编补充',1070,'C','1070020_S','缺编补充',1070,{ts'2021-09-18  00:00:00'},'1',13466739,{ts'2021-09-18  00:00:00'},13466739,0); 
DELETE FROM t_tsrbd_recrursn WHERE FID = 1070030;
INSERT INTO t_tsrbd_recrursn(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) 
VALUES (1070030,'1',NULL,'编制新增',1070,'C','1070030_S','编制新增',1070,{ts'2021-09-18  00:00:00'},'1',13466739,{ts'2021-09-18  00:00:00'},13466739,0); 
DELETE FROM t_tsrbd_recrursntyp WHERE FID = 1070;
INSERT INTO t_tsrbd_recrursntyp(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) 
VALUES (1070,'1',NULL,'招聘需求新增的原因',1070,'C','1070_S','新增需求原因',0,{ts'2021-09-18  00:00:00'},'1',100,{ts'2021-09-18  00:00:00'},100,0);



DELETE FROM T_TSRBD_RECRURSN_L WHERE FPKID = '26XV=Q=ZGGDO';
INSERT INTO T_TSRBD_RECRURSN_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1070010,'26XV=Q=ZGGDO','zh_CN','原岗位替换','原岗位替换');

DELETE FROM T_TSRBD_RECRURSN_L WHERE FPKID = '26XV=Q=ZGGDP';
INSERT INTO T_TSRBD_RECRURSN_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1070010,'26XV=Q=ZGGDP','zh_CN','原崗位替換','原崗位替換');


