-- 招聘类型预制数据修改
DELETE FROM t_hbss_recrutyp WHERE FID = 1010;
INSERT INTO t_hbss_recrutyp(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FRECRUITMENTCATEGORY,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1010,'1',NULL,' ','面向应届毕业生进行的招聘活动',1010,'C','1010_S','校园招聘','校园招聘',0,{ts'2020-11-23  00:00:00'},100,'1',{ts'2020-11-23  00:00:00'},100,0);
DELETE FROM t_hbss_recrutyp WHERE FID = 1020;
INSERT INTO t_hbss_recrutyp(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FRECRUITMENTCATEGORY,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1020,'1',NULL,' ','面向社会进行公开招聘',1020,'C','1020_S','社会招聘',' 社会招聘',0,{ts'2020-11-23  00:00:00'},100,'1',{ts'2020-11-23  00:00:00'},100,0);
DELETE FROM t_hbss_recrutyp WHERE FID = 1030;
INSERT INTO t_hbss_recrutyp(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FRECRUITMENTCATEGORY,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1030,'1',NULL,' ','面向企业内部进行招聘',1030,'C','1030_S','内部招聘',' 内部招聘',0,{ts'2020-11-23  00:00:00'},100,'1',{ts'2020-11-23  00:00:00'},100,0);
DELETE FROM t_hbss_recrutyp WHERE FID = 1040;
DELETE FROM t_hbss_recrutyp WHERE FID = 1050;


DELETE FROM t_hbss_recrutyp_l WHERE FPKID = '17MV+=MQ0G2=';
INSERT INTO t_hbss_recrutyp_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME,FRECRUITMENTCATEGORY) VALUES (1010,'17MV+=MQ0G2=','zh_CN',' ','面向应届毕业生进行的招聘活动','校园招聘','校园招聘');
DELETE FROM t_hbss_recrutyp_l WHERE FPKID = '17MV/R+2N660';
INSERT INTO t_hbss_recrutyp_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME,FRECRUITMENTCATEGORY) VALUES (1020,'17MV/R+2N660','zh_CN',' ','面向社会进行公开招聘','社会招聘','社会招聘');
DELETE FROM t_hbss_recrutyp_l WHERE FPKID = '17MV1AQ17BYU';
INSERT INTO t_hbss_recrutyp_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME,FRECRUITMENTCATEGORY) VALUES (1030,'17MV1AQ17BYU','zh_CN',' ','面向企业内部进行招聘','内部招聘','内部招聘');
DELETE FROM t_hbss_recrutyp_l WHERE FPKID = '17MV2V1DCDCP';
DELETE FROM t_hbss_recrutyp_l WHERE FPKID = '17MV41OYULQL';

/*招聘场景预制数据*/
-- 新增预制招聘场景
DELETE FROM t_hbss_recruscene WHERE FID = 1010;
INSERT INTO t_hbss_recruscene(FID,FCREATETIME,FISSYSPRESET,FMODIFIERID,FENABLE,FMODIFYTIME,FDESCRIPTION,FMASTERID,FSTATUS,FCREATORID,FNUMBER,FNAME) VALUES (1010,{ts'2021-10-27  00:00:00'},'1',1220312411685349376,'1',{ts'2021-10-27  00:00:00'},'系统预置',1276076608779884544,'C',1220312411685349376,'1010_S','实习生');
DELETE FROM t_hbss_recruscene WHERE FID = 1020;
INSERT INTO t_hbss_recruscene(FID,FCREATETIME,FISSYSPRESET,FMODIFIERID,FENABLE,FMODIFYTIME,FDESCRIPTION,FMASTERID,FSTATUS,FCREATORID,FNUMBER,FNAME) VALUES (1020,{ts'2021-10-27  00:00:00'},'1',1220312411685349376,'1',{ts'2021-10-27  00:00:00'},'系统预置',1276076821959580672,'C',1220312411685349376,'1020_S','应届生');
DELETE FROM t_hbss_recruscene WHERE FID = 1030;
INSERT INTO t_hbss_recruscene(FID,FCREATETIME,FISSYSPRESET,FMODIFIERID,FENABLE,FMODIFYTIME,FDESCRIPTION,FMASTERID,FSTATUS,FCREATORID,FNUMBER,FNAME) VALUES (1030,{ts'2021-10-27  00:00:00'},'1',1220312411685349376,'1',{ts'2021-10-27  00:00:00'},'系统预置',1276077015316994048,'C',1220312411685349376,'1030_S','普通招聘');
DELETE FROM t_hbss_recruscene WHERE FID = 1040;
INSERT INTO t_hbss_recruscene(FID,FCREATETIME,FISSYSPRESET,FMODIFIERID,FENABLE,FMODIFYTIME,FDESCRIPTION,FMASTERID,FSTATUS,FCREATORID,FNUMBER,FNAME) VALUES (1040,{ts'2021-10-27  00:00:00'},'1',1220312411685349376,'1',{ts'2021-10-27  00:00:00'},'系统预置',1276077210612177920,'C',1220312411685349376,'1040_S','高端人才');

-- 新增招聘场景多语言
DELETE FROM t_hbss_recruscene_l WHERE FPKID = '2+QJEE+X4O0H';
INSERT INTO t_hbss_recruscene_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010,'2+QJEE+X4O0H','zh_CN','系统预置','实习生');
DELETE FROM t_hbss_recruscene_l WHERE FPKID = '2+QJEE+X4O0I';
INSERT INTO t_hbss_recruscene_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010,'2+QJEE+X4O0I','zh_TW','係統預置','實習生');
DELETE FROM t_hbss_recruscene_l WHERE FPKID = '2+QJFZKKULN0';
INSERT INTO t_hbss_recruscene_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020,'2+QJFZKKULN0','zh_CN','系统预置','应届生');
DELETE FROM t_hbss_recruscene_l WHERE FPKID = '2+QJFZKKULN1';
INSERT INTO t_hbss_recruscene_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020,'2+QJFZKKULN1','zh_TW','係統預置','應屆生');
DELETE FROM t_hbss_recruscene_l WHERE FPKID = '2+QJHCINUWKT';
INSERT INTO t_hbss_recruscene_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1030,'2+QJHCINUWKT','zh_CN','系统预置','普通招聘');
DELETE FROM t_hbss_recruscene_l WHERE FPKID = '2+QJHCINUWKU';
INSERT INTO t_hbss_recruscene_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1030,'2+QJHCINUWKU','zh_TW','係統預置','普通招聘');
DELETE FROM t_hbss_recruscene_l WHERE FPKID = '2+QJIT07G0OI';
INSERT INTO t_hbss_recruscene_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1040,'2+QJIT07G0OI','zh_CN','系统预置','高端人才');
DELETE FROM t_hbss_recruscene_l WHERE FPKID = '2+QJIT07G0OJ';
INSERT INTO t_hbss_recruscene_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1040,'2+QJIT07G0OJ','zh_TW','係統預置','高端人才');


-- 新增招聘场景与招聘类型关系中间表数据
DELETE FROM t_hbss_recruscnmultyp WHERE FPKID = 1276076608796661760;
INSERT INTO t_hbss_recruscnmultyp(FID,FBASEDATAID,FPKID) VALUES (1010,1010,1276076608796661760);
DELETE FROM t_hbss_recruscnmultyp WHERE FPKID = 1276076608796661761;
INSERT INTO t_hbss_recruscnmultyp(FID,FBASEDATAID,FPKID) VALUES (1010,1020,1276076608796661761);
DELETE FROM t_hbss_recruscnmultyp WHERE FPKID = 1276076608796661762;
INSERT INTO t_hbss_recruscnmultyp(FID,FBASEDATAID,FPKID) VALUES (1010,1030,1276076608796661762);

DELETE FROM t_hbss_recruscnmultyp WHERE FPKID = 1276076821967969280;
INSERT INTO t_hbss_recruscnmultyp(FID,FBASEDATAID,FPKID) VALUES (1020,1010,1276076821967969280);
DELETE FROM t_hbss_recruscnmultyp WHERE FPKID = 1276076821967969281;
INSERT INTO t_hbss_recruscnmultyp(FID,FBASEDATAID,FPKID) VALUES (1020,1020,1276076821967969281);
DELETE FROM t_hbss_recruscnmultyp WHERE FPKID = 1276076821967969282;
INSERT INTO t_hbss_recruscnmultyp(FID,FBASEDATAID,FPKID) VALUES (1020,1030,1276076821967969282);

DELETE FROM t_hbss_recruscnmultyp WHERE FPKID = 1276077015325382656;
INSERT INTO t_hbss_recruscnmultyp(FID,FBASEDATAID,FPKID) VALUES (1030,1020,1276077015325382656);
DELETE FROM t_hbss_recruscnmultyp WHERE FPKID = 1276077015325382657;
INSERT INTO t_hbss_recruscnmultyp(FID,FBASEDATAID,FPKID) VALUES (1030,1030,1276077015325382657);

DELETE FROM t_hbss_recruscnmultyp WHERE FPKID = 1276077210620566528;
INSERT INTO t_hbss_recruscnmultyp(FID,FBASEDATAID,FPKID) VALUES (1040,1020,1276077210620566528);
DELETE FROM t_hbss_recruscnmultyp WHERE FPKID = 1276077210620566529;
INSERT INTO t_hbss_recruscnmultyp(FID,FBASEDATAID,FPKID) VALUES (1040,1030,1276077210620566529);



 -- 中台基础资料列表预制数据
DELETE FROM t_hbss_basedatalist WHERE FID = 2880;
INSERT INTO t_hbss_basedatalist(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FPAGEKEY,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (2880,'1',NULL,' ','  ',2880,'C','2880_S','招聘场景',0,{ts'2022-01-25  00:00:00'},'hbss_recruscene',1,'1',{ts'2022-01-25  00:00:00'},1,0);

DELETE FROM t_hbss_basedatalist_l WHERE FPKID = '26QA0NVZMTWH';
INSERT INTO t_hbss_basedatalist_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (2880,'26QA0NVZMTWH','zh_CN',' ','  ','招聘场景');
DELETE FROM t_hbss_basedatalist_l WHERE FPKID = '26QA0NVZMTWI';
INSERT INTO t_hbss_basedatalist_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (2880,'26QA0NVZMTWI','zh_TW',' ','  ','招聘場景');
