-- 简历元数据 证件信息
DELETE FROM T_TSRBD_MTDOBJ where fid =1569896826767729664;
INSERT INTO T_TSRBD_MTDOBJ(fid,fnumber,fname,fstatus,fcreatorid,fmodifierid,fenable,fcreatetime,fmodifytime,fmasterid,fsimplename,fdescription,findex,fissyspreset,fdisablerid,fdisabledate,flimit,fbtndesc) VALUES(1569896826767729664,'10320_S','证件信息','C',1,1,'1',{ts'2022-12-07 01:04:23'},{ts'2022-12-07 01:04:45'},1569896826767729664,' ',' ',0,'1',0,null,'0',' ');
 DELETE FROM T_TSRBD_MTDOBJ_L where fpkid = '2XU7GAB7CZ6P';
INSERT INTO T_TSRBD_MTDOBJ_L(fid,flocaleid,fpkid,fname,fsimplename,fdescription,fbtndesc) VALUES(1569896826767729664,'zh_CN','2XU7GAB7CZ6P','证件信息',' ',' ',' ');
 DELETE FROM T_TSRBD_MTDOBJ_L where fpkid = '2XU7GAB7CZ6Q';
--INSERT INTO T_TSRBD_MTDOBJ_L(fid,flocaleid,fpkid,fname,fsimplename,fdescription,fbtndesc) VALUES(1569896826767729664,'zh_TW','2XU7GAB7CZ6Q','證件信息',' ',' ',' ');

-- 简历元数据实体
DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569579449387626496;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569579449387626496,1,{ts'2022-12-06 14:33:29'},1,{ts'2022-12-06 14:41:31'},'tstpm_stdprjexp','6',1118125067318973440,1020,'KD','0',' ');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569580263132935168;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569580263132935168,1,{ts'2022-12-06 14:34:49'},1,{ts'2022-12-06 14:41:48'},'tstpm_stdrelationwork','6',1358772090357958656,1020,'KD','0',' ');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569577863613558784;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569577863613558784,1,{ts'2022-12-06 14:30:26'},1,{ts'2022-12-06 14:42:27'},'tstpm_stdlangabl','6',1118126053039133696,1020,'KD','0',' ');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569578821399654400;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569578821399654400,1,{ts'2022-12-06 14:31:31'},1,{ts'2022-12-06 14:43:15'},'tstpm_stdeduexp','6',1118124543978886144,1020,'KD','0',' ');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569579100966793216;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569579100966793216,1,{ts'2022-12-06 14:32:56'},1,{ts'2022-12-06 14:43:25'},'tstpm_stdworkexp','6',1118124877392499712,1020,'KD','0',' ');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569588779834979328;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569588779834979328,1,{ts'2022-12-06 14:52:20'},1,{ts'2022-12-06 14:52:43'},'tstpm_scsrstdlangabl','6',1118126053039133696,1020,'MK','0',' ');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569588960995357696;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569588960995357696,1,{ts'2022-12-06 14:52:52'},1,{ts'2022-12-06 14:53:04'},'tstpm_scsrstdeduexp','6',1118124543978886144,1020,'MK','0',' ');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569589135050585088;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569589135050585088,1,{ts'2022-12-06 14:53:10'},1,{ts'2022-12-06 14:53:25'},'tstpm_scsrstdworkexp','6',1118124877392499712,1020,'MK','0',' ');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569589303745491968;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569589303745491968,1,{ts'2022-12-06 14:53:32'},1,{ts'2022-12-06 14:53:45'},'tstpm_scsrstdprjexp','6',1118125067318973440,1020,'MK','0',' ');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569581817692992512;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569581817692992512,1,{ts'2022-12-06 14:38:48'},1,{ts'2022-12-07 00:16:19'},'tstpm_srrsmworkrela','5',1358772090357958656,1020,'KD','0','flexpanelcontent_workrela');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569577002212569088;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569577002212569088,1,{ts'2022-12-06 14:23:16'},1,{ts'2022-12-07 00:16:37'},'tstpm_srrsmeduexp','5',1118124543978886144,1020,'KD','0','flexpanelcontent_eduexp');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569579774647513088;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569579774647513088,1,{ts'2022-12-06 14:34:11'},1,{ts'2022-12-07 00:16:50'},'tstpm_srrsmlangabl','5',1118126053039133696,1020,'KD','0','flexpanelcontent_langexp');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569577324284784640;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569577324284784640,1,{ts'2022-12-06 14:29:19'},1,{ts'2022-12-07 00:17:04'},'tstpm_srrsmworkexp','5',1118124877392499712,1020,'KD','0','flexpanelcontent_workexp');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569577564693901312;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569577564693901312,1,{ts'2022-12-06 14:29:57'},1,{ts'2022-12-07 00:17:16'},'tstpm_srrsmprjexp','5',1118125067318973440,1020,'KD','0','flexpanelcontent_prjexp');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569588161166750720;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569588161166750720,1,{ts'2022-12-06 14:51:13'},1,{ts'2022-12-07 00:18:11'},'tstpm_scsrrsmworkexp','5',1118124877392499712,1020,'MK','0','flexpanelcontent_workexp');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569588361897751552;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569588361897751552,1,{ts'2022-12-06 14:51:40'},1,{ts'2022-12-07 00:18:21'},'tstpm_scsrrsmprjexp','5',1118125067318973440,1020,'MK','0','flexpanelcontent_prjexp');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569588499991016448;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569588499991016448,1,{ts'2022-12-06 14:51:58'},1,{ts'2022-12-07 00:18:35'},'tstpm_scsrrsmlangabl','5',1118126053039133696,1020,'MK','0','flexpanelcontent_langexp');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569874714631913472;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569874714631913472,1,{ts'2022-12-07 00:18:43'},1,{ts'2022-12-07 00:20:49'},'tstpm_scsrrsm','5',1118123748571047936,1020,'MK','1',' ');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569587936167506944;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569587936167506944,1,{ts'2022-12-06 14:50:31'},1,{ts'2022-12-07 00:55:26'},'tstpm_scsrrsmeduexp','5',1118124543978886144,1020,'MK','0','flexpanelcontent_eduexp');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569893592607024128;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569893592607024128,1,{ts'2022-12-07 00:57:39'},1,{ts'2022-12-07 00:58:19'},'tstpm_srscarfmrsmeduexp','7',1118124543978886144,1020,'MK','0','flexpanelcontent_eduexp');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569894189422928896;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569894189422928896,1,{ts'2022-12-07 00:58:26'},1,{ts'2022-12-07 00:59:30'},'tstpm_srscarfmrsmlangabl','7',1118126053039133696,1020,'MK','0','flexpanelcontent_langexp');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569895118939415552;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569895118939415552,1,{ts'2022-12-07 01:00:19'},1,{ts'2022-12-07 01:01:21'},'tstpm_srscarfmrsmprjexp','7',1118125067318973440,1020,'MK','0','flexpanelcontent_prjexp');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569897179911349248;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569897179911349248,1,{ts'2022-12-07 01:02:34'},1,{ts'2022-12-07 01:05:27'},'tstpm_srscarfmcertificate','7',1569896826767729664,1020,'MK','0','flexpanelcontent_crt');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569895442840347648;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569895442840347648,1,{ts'2022-12-07 01:01:21'},1,{ts'2022-12-07 01:06:13'},'tstpm_srscarfmrsminterexp','7',1118124715064546304,1020,'MK','0','flexpanelcontent_interexp');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569895729906902016;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569895729906902016,1,{ts'2022-12-07 01:02:00'},1,{ts'2022-12-07 01:06:27'},'tstpm_srscarfmrsmawrhon','7',1118126417633203200,1020,'MK','0','flexpanelcontent_awrhon');
 DELETE FROM T_TSRBD_MTDOBJTABLE where fid =1569894595129566208;
INSERT INTO T_TSRBD_MTDOBJTABLE(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fentitykey,fformtype,fmtdobjid,frecrutypid,fecosystem,fismainentity,fembeddedkey) VALUES(1569894595129566208,1,{ts'2022-12-07 00:59:31'},1,{ts'2022-12-07 01:06:41'},'tstpm_srscarfmrsmworkexp','7',1118124877392499712,1020,'MK','0','flexpanelcontent_workexp');

-- 简历元数据映射
DELETE FROM T_TSRBD_MTDMAP where fid =1569586519759434752;
INSERT INTO T_TSRBD_MTDMAP(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fsourcekey,ftargetkey,fdesc) VALUES(1569586519759434752,1,{ts'2022-12-06 13:58:57'},1,{ts'2022-12-06 14:48:13'},'tstpm_srrsm','tstpm_stdrsm','渠道简历->标准简历');
 DELETE FROM T_TSRBD_MTDMAP where fid =1569586872718503936;
INSERT INTO T_TSRBD_MTDMAP(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fsourcekey,ftargetkey,fdesc) VALUES(1569586872718503936,1,{ts'2022-12-06 14:48:44'},1,{ts'2022-12-06 14:48:55'},'tstpm_rsm','tstpm_stdrsm','渠道简历->标准简历');
 DELETE FROM T_TSRBD_MTDMAP where fid =1569587257092912128;
INSERT INTO T_TSRBD_MTDMAP(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fsourcekey,ftargetkey,fdesc) VALUES(1569587257092912128,1,{ts'2022-12-06 14:48:59'},1,{ts'2022-12-06 14:49:41'},'tstpm_srrsmupdate','tstpm_stdrsm','渠道简历->标准简历');
 DELETE FROM T_TSRBD_MTDMAP where fid =1569592602079047680;
INSERT INTO T_TSRBD_MTDMAP(fid,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fsourcekey,ftargetkey,fdesc) VALUES(1569592602079047680,1,{ts'2022-12-06 14:55:51'},1,{ts'2022-12-06 15:00:18'},'tstpm_scsrrsm','tstpm_scsrstdrsm','直通车摩卡-渠道简历->标准简历');
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569586519759433728;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569586519759433728,1,1569577002212569088,1569578821399654400,1118124543978886144,1569586519759434752);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569586519759433729;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569586519759433729,2,1569577324284784640,1569579100966793216,1118124877392499712,1569586519759434752);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569586519759433730;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569586519759433730,3,1569577564693901312,1569579449387626496,1118125067318973440,1569586519759434752);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569586519759433731;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569586519759433731,4,1569579774647513088,1569577863613558784,1118126053039133696,1569586519759434752);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569586519759433732;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569586519759433732,5,1569581817692992512,1569580263132935168,1358772090357958656,1569586519759434752);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569586872718504960;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569586872718504960,1,1569577002212569088,1569578821399654400,1118124543978886144,1569586872718503936);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569586872718504961;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569586872718504961,2,1569577324284784640,1569579100966793216,1118124877392499712,1569586872718503936);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569586872718504962;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569586872718504962,3,1569577564693901312,1569579449387626496,1118125067318973440,1569586872718503936);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569586872718504963;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569586872718504963,4,1569579774647513088,1569577863613558784,1118126053039133696,1569586872718503936);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569586872718504964;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569586872718504964,5,1569581817692992512,1569580263132935168,1358772090357958656,1569586872718503936);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569587257092911104;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569587257092911104,1,1569577002212569088,1569578821399654400,1118124543978886144,1569587257092912128);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569587257092911105;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569587257092911105,2,1569577324284784640,1569579100966793216,1118124877392499712,1569587257092912128);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569587257092911106;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569587257092911106,3,1569577564693901312,1569579449387626496,1118125067318973440,1569587257092912128);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569587257092911107;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569587257092911107,4,1569579774647513088,1569577863613558784,1118126053039133696,1569587257092912128);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569587257092911108;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569587257092911108,5,1569581817692992512,1569580263132935168,1358772090357958656,1569587257092912128);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569592602079048704;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569592602079048704,1,1569587936167506944,1569588960995357696,1118124543978886144,1569592602079047680);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569592602079048705;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569592602079048705,2,1569588161166750720,1569589135050585088,1118124877392499712,1569592602079047680);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569592602079048706;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569592602079048706,3,1569588361897751552,1569589303745491968,1118125067318973440,1569592602079047680);
 DELETE FROM T_TSRBD_MAPENTRY where fentryid =1569592602079048707;
INSERT INTO T_TSRBD_MAPENTRY(fentryid,fseq,fsourceentryid,ftargetentryid,fmtdobjid,fid) VALUES(1569592602079048707,4,1569588499991016448,1569588779834979328,1118126053039133696,1569592602079047680);

-- 焦煤历史数据处理
update t_tsrbd_rqmtproc set FAPPLICABLEAPP = 1020 where FGROUPID = 1030;

-- 招聘流程
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,FAPPLICABLEAPP,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',13466739,1020,{ts'2022-11-22  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,FAPPLICABLEAPP,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',13466739,1010,{ts'2022-11-22  00:00:00'},1426825907217129472,0);
DELETE FROM t_tsrbd_rqmtproc WHERE FID = 1559499227313233920;
INSERT INTO t_tsrbd_rqmtproc(FID,FISSYSPRESET,FUSEORGID,FCREATEORGID,FDISABLEDATE,FISDEFAULT,FMASTERID,FORGID,FRECRUSCENEID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FAPPLICABLEAPP,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1559499227313233920,'1',100000,100000,NULL,'0',1559499227313233920,100000,0,'C','5','1030_S','社会招聘Offer入职流程',1020,{ts'2022-11-22  00:00:00'},'1',13466739,1030,{ts'2022-11-22  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_rqmtproc WHERE FID = 1559546385307558912;
INSERT INTO t_tsrbd_rqmtproc(FID,FISSYSPRESET,FUSEORGID,FCREATEORGID,FDISABLEDATE,FISDEFAULT,FMASTERID,FORGID,FRECRUSCENEID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FAPPLICABLEAPP,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1559546385307558912,'1',100000,100000,NULL,'0',1559546385307558912,100000,0,'C','5','1040_S','社会招聘预入职流程',1020,{ts'2022-11-22  00:00:00'},'1',13466739,1030,{ts'2022-11-22  00:00:00'},13466739,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_rqmtproc_L WHERE FPKID = '2WJDQ6=4Z4EW';
INSERT INTO t_tsrbd_rqmtproc_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1559499227313233920,'2WJDQ6=4Z4EW','zh_CN','Offer、入职集成模式的预置流程','社会招聘Offer入职流程');
DELETE FROM t_tsrbd_rqmtproc_L WHERE FPKID = '2WJDQ6=4Z4EX';
--INSERT INTO t_tsrbd_rqmtproc_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1559499227313233920,'2WJDQ6=4Z4EX','zh_TW','Offer、入職集成模式的預置流程','社會招聘Offer入職流程');
DELETE FROM t_tsrbd_rqmtproc_L WHERE FPKID = '2WJMIU86W/3W';
INSERT INTO t_tsrbd_rqmtproc_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1559546385307558912,'2WJMIU86W/3W','zh_CN','入职集成模式的预置流程','社会招聘预入职流程');
DELETE FROM t_tsrbd_rqmtproc_L WHERE FPKID = '2WJMIU86W/3X';
--INSERT INTO t_tsrbd_rqmtproc_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1559546385307558912,'2WJMIU86W/3X','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_rqmtprocentity WHERE FENTRYID = 1559499227313233921;
INSERT INTO t_tsrbd_rqmtprocentity(FID,FENTRYID,FSEQ,FRQMTSTGID) VALUES (1559499227313233920,1559499227313233921,1,10030);
DELETE FROM t_tsrbd_rqmtprocentity WHERE FENTRYID = 1559499227313233922;
INSERT INTO t_tsrbd_rqmtprocentity(FID,FENTRYID,FSEQ,FRQMTSTGID) VALUES (1559499227313233920,1559499227313233922,2,10040);
DELETE FROM t_tsrbd_rqmtprocentity WHERE FENTRYID = 1559546385341113344;
INSERT INTO t_tsrbd_rqmtprocentity(FID,FENTRYID,FSEQ,FRQMTSTGID) VALUES (1559546385307558912,1559546385341113344,1,10040);
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 = 1559499227321623552;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1559499227321623552,1559499227313233921,1,'0',10090,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1559499227321623553;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1559499227321623553,1559499227313233921,2,'0',10110,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1559499227321623554;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1559499227321623554,1559499227313233921,3,'0',10120,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1559499227321623555;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1559499227321623555,1559499227313233922,1,'0',10130,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1559499227321623556;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1559499227321623556,1559499227313233922,2,'0',10140,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1559499227321623557;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1559499227321623557,1559499227313233922,3,'0',10150,'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_rqmtprocsubent WHERE FDETAILID = 1559546385341112322;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1559546385341112322,1559546385341113344,1,'0',10130,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1559546385341112323;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1559546385341112323,1559546385341113344,2,'0',10140,'0');
DELETE FROM t_tsrbd_rqmtprocsubent WHERE FDETAILID = 1559546385341112324;
INSERT INTO t_tsrbd_rqmtprocsubent(FDETAILID,FENTRYID,FSEQ,FISOVER,FJOBSTATUS,FISREASON) VALUES (1559546385341112324,1559546385341113344,3,'0',10150,'0');
