--删除错误编码规则
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '18ZPNVDQ+WVY';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '18ZPNVDQ+WVZ';
DELETE FROM T_CR_CodeRule WHERE FID = '18ZPNVD1M+IB';
DELETE FROM T_CR_CodeRule_l WHERE FPKID = '18ZPNVD1HYA3';
DELETE FROM T_CR_CodeRule_l WHERE FPKID = '18ZPNVD1HYA2';

DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '19468RIUZ72K';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '19468RIUZ72L';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '19468RIUZ72M';
DELETE FROM T_CR_CodeRule WHERE FID = '19468RI/AGBZ';
DELETE FROM T_CR_CodeRule_l WHERE FPKID = '19468RI/EF6Z';
DELETE FROM T_CR_CodeRule_l WHERE FPKID = '19468RI/EF6Y';

--PMM 商品管理编码规则
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '1=UY5HOQZZ1C';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('1=UY5HLKOUHY',1,'1',' ','0','1=UY5HOQZZ1C','1',1,'1',0,'1',8,'CP',' ','1','0',' ',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '1=UY5HOQZZ1D';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('1=UY5HLKOUHY',1,'16','-','0','1=UY5HOQZZ1D','1',1,' ',1,'1',8,' ',' ','1','1',' ',' '); 


DELETE FROM T_CR_CodeRule WHERE FID = '1=UY5HLKOUHY';
INSERT INTO T_CR_CodeRule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FENABLE,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','1=UY5HLKOUHY','0','0',{ts'2020-12-29  15:46:39'},'pmm_prodmanage','0','1','0','1','0','1=UY5HLKOUHY','1','-','0','C','1=UY4PCPA65H',' ',0,'0',{ts'2020-12-29  15:46:39'},0); 

DELETE FROM T_CR_CodeRule_l WHERE FPKID = '1=UY5HLKPL47';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1=UY5HLKOUHY','1=UY5HLKPL47','zh_CN','商品管理'); 

--上架审批编码规则
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '1=UYA/953GOT';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('1=UYA/8LC+IQ',1,'1',' ','0','1=UYA/953GOT','1',1,'1',0,'1',8,'CJ',' ','1','0',' ',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '1=UYA/953GOU';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('1=UYA/8LC+IQ',1,'2','-','0','1=UYA/953GOU','1',1,' ',1,'1',8,'yyMMdd',' ','1','1','createtime',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '1=UYA/953GOV';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FSETTINGVALUE,FADDSTYLE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('1=UYA/8LC+IQ',1,'16','-','0','1=UYA/953GOV','1',1,' ',2,'1',4,' ',' ','1','1',' ',' '); 


DELETE FROM T_CR_CodeRule WHERE FID = '1=UYA/8LC+IQ';
INSERT INTO T_CR_CodeRule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FENABLE,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','1=UYA/8LC+IQ','0','0',{ts'2020-12-29  15:48:09'},'pmm_prodaudit','0','1','0','1','0','1=UYA/8LC+IQ','1','-','0','C','1=UY9J9DLDAT',' ',0,'0',{ts'2020-12-29  15:48:09'},0); 

DELETE FROM T_CR_CodeRule_l WHERE FPKID = '1=UYA/8P/5BI';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1=UYA/8LC+IQ','1=UYA/8P/5BI','zh_CN','上架审批'); 



