/**tsrbd_channelcontract coderule preinsdata export**/
DELETE FROM T_CR_CODERULE WHERE FID = '29OHZZ=A1IA0';
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','29OHZZ=A1IA0','0',NULL,'0',{ts'2022-02-27  00:00:00'},'tsrbd_channelcontract','1','0','0','1',NULL,'0','29OHZZ=A1IA0','-','1',NULL,'0','C','29OHVHVJKU0V',' ','1',1315779753986258944,'0',{ts'2022-02-27  00:00:00'},0); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '29OHZZ=A1GZI';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('29OHZZ=A1IA0','29OHZZ=A1GZI','zh_CN','渠道合同'); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '29OI1QJGLJ=Z';
--INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('29OHZZ=A1IA0','29OI1QJGLJ=Z','zh_TW','渠道合同'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '29OI1QK7LX6K';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('29OHZZ=A1IA0',1,'1',' ','0','29OI1QK7LX6K',1,'1','1',0,8,'1','M',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '29OI1QK7LX6L';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('29OHZZ=A1IA0',1,'16',' ','0','29OI1QK7LX6L',1,'1',' ',1,6,'1',' ',' ','1',' ','0',' '); 
DELETE FROM t_cr_maxserial WHERE FID = '29OI+78KCBE1';
INSERT INTO t_cr_maxserial(FID,FINITSERIAL,FSEQSEGMENTENTRYID,FMAXSERIAL,FCREATETIME,FMODIFIERID,FCODERULEID,FMODIFYTIME,FSORTITEMVALUE,FCREATORID) VALUES ('29OI+78KCBE1',0,' ',0,{ts'2022-02-27  00:00:00'},0,'29OHZZ=A1IA0',{ts'2022-02-27  00:00:00'},' ',1315779753986258944);


/**tsrbd_channelcontact coderule preinsdata export**/
DELETE FROM T_CR_CODERULE WHERE FID = '29HKN6Z/7+MS';
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','29HKN6Z/7+MS','0',NULL,'0',{ts'2022-02-25  00:00:00'},'tsrbd_channelcontact','1','0','0','1',NULL,'0','29HKN6Z/7+MS','-','1',NULL,'0','C','29HK=F2NGTYF',' ',0,'0',{ts'2022-02-25  00:00:00'},13466739);
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '29HKN7/1+3W1';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('29HKN6Z/7+MS',1,'1',' ','0','29HKN7/1+3W1',1,'1','1',0,8,'1','P',' ','1',' ','0',' ');
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '29HKN7/1+3W2';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('29HKN6Z/7+MS',1,'16',' ','0','29HKN7/1+3W2',1,'1',' ',1,4,'1',' ',' ','1',' ','0',' ');
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '29HKN6Z2UEHJ';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('29HKN6Z/7+MS','29HKN6Z2UEHJ','zh_CN','渠道联系人');

/**tsrbd_channelaccount coderule preinsdata export**/
DELETE FROM T_CR_CODERULE WHERE FID = '232/2Z2JM34+';
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','232/2Z2JM34+','0',NULL,'1',{ts'2021-12-15  00:00:00'},'tsrbd_channelaccount','1','0','0','1',NULL,'0','232/2Z2JM34+',' ','1',NULL,'0','C','231Z=UC+1PUR',' ','0',1316762402657684480,'0',{ts'2022-02-28  00:00:00'},0); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '232/2Z2N8P12';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('232/2Z2JM34+','232/2Z2N8P12','zh_CN','编码规则'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '29SEAT6P8M2I';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('232/2Z2JM34+',1,'1',' ','0','29SEAT6P8M2I',1,'1','1',0,8,'1','N',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '29SEAT6P8M2J';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('232/2Z2JM34+',1,'16',' ','0','29SEAT6P8M2J',1,'1',' ',1,6,'1',' ',' ','1',' ','0',' '); 
DELETE FROM t_cr_maxserial WHERE FID = '232/JQA4P590';
INSERT INTO t_cr_maxserial(FID,FINITSERIAL,FSEQSEGMENTENTRYID,FMAXSERIAL,FCREATETIME,FMODIFIERID,FCODERULEID,FMODIFYTIME,FSORTITEMVALUE,FCREATORID) VALUES ('232/JQA4P590',0,' ',0,{ts'2021-12-15  00:00:00'},0,'232/2Z2JM34+',{ts'2021-12-15  00:00:00'},' ',1221142642000194560); 


