-- 面试官类型编码规则(tsrbd_interviewtype)
DELETE FROM T_CR_CODERULE WHERE FID = '2HYV0Y=72ADV';
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','2HYV0Y=72ADV','0',NULL,'0',{ts'2022-06-11  00:00:00'},'tsrbd_interviewtype','1','0','0','1',NULL,'0','2HYV0Y=72ADV',' ','1',NULL,'0','C','2HYUWY3927KB',' ','0',1160905940313110528,'0',{ts'2022-06-11  00:00:00'},0); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '2HYV0Y=71X8Q';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2HYV0Y=72ADV','2HYV0Y=71X8Q','zh_CN','面试官类型编码'); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '2HYV0Y=71X8P';
--INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2HYV0Y=72ADV','2HYV0Y=71X8P','zh_TW','麵試官類型編碼'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2HYV0YASQCOK';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2HYV0Y=72ADV',1,'1',' ','0','2HYV0YASQCOK',1,'1','1',0,8,'1','T',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2HYV0YASQCOL';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2HYV0Y=72ADV',1,'16',' ','0','2HYV0YASQCOL',1,'1',' ',1,3,'1',' ',' ','1',' ','0',' '); 
DELETE FROM t_cr_maxserial WHERE FID = '2HYV21NRCYSU';
INSERT INTO t_cr_maxserial(FID,FINITSERIAL,FSEQSEGMENTENTRYID,FMAXSERIAL,FCREATETIME,FMODIFIERID,FCODERULEID,FMODIFYTIME,FSORTITEMVALUE,FCREATORID) VALUES ('2HYV21NRCYSU',0,' ',0,{ts'2022-06-11  00:00:00'},1160905940313110528,'2HYV0Y=72ADV',{ts'2022-06-11  00:00:00'},' ',1160905940313110528); 

-- 面试官资质编码规则(tsrbd_interviewqualify)
DELETE FROM T_CR_CODERULE WHERE FID = '2J2XFA28WPOC';
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','2J2XFA28WPOC','0',NULL,'0',{ts'2022-06-24  00:00:00'},'tsrbd_interviewqualify','1','0','0','0',NULL,'0','2J2XFA28WPOC','-','1',NULL,'0','C','2J2X7CY9+YXU',' ','0',1160905940313110528,'0',{ts'2022-06-24  00:00:00'},0); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '2J2XFA28WQBN';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2J2XFA28WPOC','2J2XFA28WQBN','zh_CN','面试官资质编码规则'); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '2J2XFA28WQBM';
--INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2J2XFA28WPOC','2J2XFA28WQBM','zh_TW','麵試官資質編碼規則'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2J2XFA470EQ4';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2J2XFA28WPOC',1,'1',' ','0','2J2XFA470EQ4',1,'1','1',0,8,'1','IN',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2J2XFA470EQ5';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2J2XFA28WPOC',1,'9','-','0','2J2XFA470EQ5',1,'1',' ',1,8,'1','yyMMdd',' ','1',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2J2XFA470EQ6';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2J2XFA28WPOC',1,'10','-','0','2J2XFA470EQ6',1,'1',' ',2,8,'1',' ',' ','1',' ','1',' '); 


--自动化规则编码规则
DELETE FROM T_CR_CodeRule WHERE FID = '2JJTUHZ9LAP9';
INSERT INTO T_CR_CodeRule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','2JJTUHZ9LAP9','0','1',{ts'2022-06-29  00:00:00'},'tsrbd_autorules','1','0','0','1','0','2JJTUHZ9LAP9','1',' ','0','C','2JJTLEQ9Z7XJ',' ','0',1426825907217129472,'0',{ts'2022-06-29  00:00:00'},0);
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '2JJTUHZ9LBCI';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2JJTUHZ9LAP9','2JJTUHZ9LBCI','zh_CN','自动化规则');
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2JJTUI+381EW';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2JJTUHZ9LAP9',1,'1',' ','0','2JJTUI+381EW',1,'1','1',0,8,'1','RCE','1',' ',' ','0',' ');
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2JJTUI+381EX';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2JJTUHZ9LAP9',1,'9',' ','0','2JJTUI+381EX',1,'1',' ',1,8,'1','yyyyMMdd','1',' ',' ','0',' ');
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2JJTUI+381EY';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2JJTUHZ9LAP9',1,'16',' ','0','2JJTUI+381EY',1,'1',' ',2,4,'1',' ','1',' ',' ','0',' ');

DELETE FROM T_CR_CodeRule WHERE FID = '2JJUCG/FUJL7';
INSERT INTO T_CR_CodeRule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','2JJUCG/FUJL7','0','1',{ts'2022-06-29  00:00:00'},'tsrbd_ruleconfig','1','0','0','1','0','2JJUCG/FUJL7','1',' ','0','C','2JJTVIPJ0AD=',' ','0',1426825907217129472,'0',{ts'2022-06-29  00:00:00'},0);
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '2JJUCG/FUK9G';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2JJUCG/FUJL7','2JJUCG/FUK9G','zh_CN','规则设置');
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2JJUCG/XZMJS';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2JJUCG/FUJL7',1,'1',' ','0','2JJUCG/XZMJS',1,'1','1',0,8,'1','REC_Rule','1',' ',' ','0',' ');
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2JJUCG/XZMJT';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2JJUCG/FUJL7',1,'9',' ','0','2JJUCG/XZMJT',1,'1',' ',1,8,'1','yyyyMMdd','1',' ',' ','0',' ');
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '2JJUCG/XZMJU';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2JJUCG/FUJL7',1,'16',' ','0','2JJUCG/XZMJU',1,'1',' ',2,4,'1',' ','1',' ',' ','0',' ');



