-- 编码规则 --
DELETE FROM T_CR_CODERULE WHERE FID = '20+190TLH0JT';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','20+190TLH0JT','0',NULL,'0',{ts'2021-11-10  00:00:00'},'tsrbd_individuallabel','1','0','0','1',NULL,'0','20+190TLH0JT','-','1',NULL,'0','C','20+173F=5/W8',' ',0,'0',{ts'2021-11-10  00:00:00'},1165011567415139328);
DELETE FROM T_CR_CODERULE WHERE FID = '20+1B83AQBM9';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','20+1B83AQBM9','0',NULL,'0',{ts'2021-11-10  00:00:00'},'tsrbd_publiclabel','1','0','0','1',NULL,'0','20+1B83AQBM9','-','1',NULL,'0','C','20+1A51M0YLX',' ',0,'0',{ts'2021-11-10  00:00:00'},1165011567415139328);

DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '20+190V+W9FH';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('20+190TLH0JT',1,'1',' ','0','20+190V+W9FH',1,'1','1',0,8,'1','IL',' ','1',' ','0',' ');
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '20+190V+W9FI';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('20+190TLH0JT',1,'16','-','0','20+190V+W9FI',1,'1',' ',1,6,'1',' ',' ','1',' ','1',' ');
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '20+1B83WGUSB';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('20+1B83AQBM9',1,'1',' ','0','20+1B83WGUSB',1,'1','1',0,8,'1','PL',' ','1',' ','0',' ');
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '20+1B83WGUSC';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('20+1B83AQBM9',1,'16','-','0','20+1B83WGUSC',1,'1',' ',1,6,'1',' ',' ','1',' ','1',' ');

DELETE FROM T_CR_CODERULE_L WHERE FPKID = '20+190TLH/WJ';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('20+190TLH0JT','20+190TLH/WJ','zh_CN','个人标签');
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '20+1B83EBR4I';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('20+1B83AQBM9','20+1B83EBR4I','zh_CN','公共标签');

/**tsrbd_commcon coderule preinsdata export**/
DELETE FROM T_CR_CODERULE WHERE FID = '2/J3G22LJNOJ';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','2/J3G22LJNOJ','0',NULL,'1',{ts'2021-11-05  00:00:00'},'tsrbd_commcon','1','0','0','1',NULL,'0','2/J3G22LJNOJ','-','1',NULL,'0','C','2/J3DD1DIW7N',' ','1',0,'1',{ts'2021-11-05  00:00:00'},0); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '2/J3G22LK57+';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2/J3G22LJNOJ','2/J3G22LK57+','zh_CN','沟通结论'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2/J3G235A4UM';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2/J3G22LJNOJ',1002,'16',' ','0','2/J3G235A4UM',1,'1',' ',0,4,'1',' ',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2/J3G235A4UN';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2/J3G22LJNOJ',1,'1','_','0','2/J3G235A4UN',1,'1','1',1,8,'1','S',' ','1',' ','1',' '); 
DELETE FROM t_cr_maxserial WHERE FID = '2/J3GRONA8W+';
INSERT INTO t_cr_maxserial(FID,FINITSERIAL,FSEQSEGMENTENTRYID,FMAXSERIAL,FCREATETIME,FMODIFIERID,FCODERULEID,FMODIFYTIME,FSORTITEMVALUE,FCREATORID) VALUES ('2/J3GRONA8W+',0,' ',0,{ts'2021-11-05  00:00:00'},0,'2/J3G22LJNOJ',{ts'2021-11-05  00:00:00'},' ',1201458362378652672); 

/**tsrbd_commtheme coderule preinsdata export**/
DELETE FROM T_CR_CODERULE WHERE FID = '2/J3PL23K664';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','2/J3PL23K664','0',NULL,'1',{ts'2021-11-05  00:00:00'},'tsrbd_commtheme','1','0','0','1',NULL,'0','2/J3PL23K664','-','1',NULL,'0','C','2/J3O520HAGX',' ','1',0,'1',{ts'2021-11-05  00:00:00'},0);
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '2/J3PL23KOPK';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2/J3PL23K664','2/J3PL23KOPK','zh_CN','沟通主题'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2/J3PL2OAOB7';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2/J3PL23K664',1005,'16',' ','0','2/J3PL2OAOB7',1,'1',' ',0,4,'1',' ',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2/J3PL2OAOB8';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2/J3PL23K664',1,'1','_','0','2/J3PL2OAOB8',1,'1','1',1,8,'1','S',' ','1',' ','1',' '); 
DELETE FROM t_cr_maxserial WHERE FID = '2/J3Q=10H76M';
INSERT INTO t_cr_maxserial(FID,FINITSERIAL,FSEQSEGMENTENTRYID,FMAXSERIAL,FCREATETIME,FMODIFIERID,FCODERULEID,FMODIFYTIME,FSORTITEMVALUE,FCREATORID) VALUES ('2/J3Q=10H76M',0,' ',0,{ts'2021-11-05  00:00:00'},0,'2/J3PL23K664',{ts'2021-11-05  00:00:00'},' ',1201458362378652672);

DELETE FROM T_CR_CODERULE WHERE FID = '24YXQMW7ATB6';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','24YXQMW7ATB6','0',NULL,'0',{ts'2022-01-05  00:00:00'},'tsrbd_intvertype','1','0','0','1',NULL,'0','24YXQMW7ATB6',' ','1',NULL,'0','C','24YXO9QTVVSO',' ',0,'0',{ts'2022-01-05  00:00:00'},13466739);
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '24YXQMY1V36F';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('24YXQMW7ATB6',1,'1',' ','0','24YXQMY1V36F',1,'1','1',0,8,'1','T',' ','1',' ','0',' ');
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '24YXQMY1V36G';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('24YXQMW7ATB6',1,'16',' ','0','24YXQMY1V36G',1,'1',' ',1,3,'1',' ',' ','1',' ','0',' ');
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '24YXQMW=Z666';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('24YXQMW7ATB6','24YXQMW=Z666','zh_CN','面试官类型');


DELETE FROM T_CR_CODERULE WHERE FID = '24YXUWP2WR5E';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','24YXUWP2WR5E','0',NULL,'0',{ts'2022-01-05  00:00:00'},'tsrbd_intverlevel','1','0','0','1',NULL,'0','24YXUWP2WR5E',' ','1',NULL,'0','C','24YXR50OXXHM',' ',0,'0',{ts'2022-01-05  00:00:00'},13466739);
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '24YXUWQH=+13';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('24YXUWP2WR5E',1,'1',' ','0','24YXUWQH=+13',1,'1','1',0,8,'1','L',' ','1',' ','0',' ');
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '24YXUWQH=+14';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('24YXUWP2WR5E',1,'16',' ','0','24YXUWQH=+14',1,'1',' ',1,3,'1',' ',' ','1',' ','0',' ');
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '24YXUWP2WPTX';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('24YXUWP2WR5E','24YXUWP2WPTX','zh_CN','面试官等级');
