-- 渠道账号删除旧的编码规则
DELETE FROM T_CR_CODERULE WHERE FID = '1UHFM5EJEVYQ';
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '1UHFM5EJF1BJ';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1VJBOA8P7Q9P';
DELETE FROM t_cr_maxserial WHERE FID = '1UHFMDF62AX0';

-- 渠道账号新增编码规则
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,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',' ',1221142642000194560,'0',{ts'2021-12-15  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_coderule_l WHERE FPKID = '232/2Z2N8P11';
--INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('232/2Z2JM34+','232/2Z2N8P11','zh_TW','編碼規則');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '232/ISY1L00V';
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','232/ISY1L00V',1,'1',' ',0,6,'1',' ',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '232/ISY1L00W';
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','232/ISY1L00W',1,'1','1',1,8,'1','N',' ','1',' ','1',' ');
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);

--消息跟踪新增编码规则
DELETE FROM T_CR_CODERULE WHERE FID = '251600AHCE=1';
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','251600AHCE=1','0',NULL,'0',{ts'2022-01-06  00:00:00'},'tsrbd_msgtrack','1','0','0','1',NULL,'0','251600AHCE=1','-','1',NULL,'0','C','2515V5C2I66P',' ',0,'0',{ts'2022-01-06  00:00:00'},0); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '251600AL+LQ8';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('251600AHCE=1','251600AL+LQ8','zh_CN','消息跟踪记录'); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '251600CBWQ4A';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('251600AHCE=1',1,'1',' ','0','251600CBWQ4A',1,'1',' ',0,8,'1','M',' ','1',' ','0',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '251600CBWQ4B';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('251600AHCE=1',1,'9',' ','0','251600CBWQ4B',1,'1',' ',1,8,'1','yyyyMMdd',' ','1',' ','0',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '251600CBWQ4C';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('251600AHCE=1',1,'16','-','0','251600CBWQ4C',1,'1',' ',2,6,'1',' ',' ','1',' ','1',' '); 


