--商品分类编码规则 雷莉敏 #2021-09-27
DELETE FROM T_CR_CODERULE WHERE FID = '1XP==7FJHZUA';
INSERT INTO T_CR_CODERULE(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FISADDVIEW,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FISSERIALNUMBER,FCREATORID,FDISABLERID) VALUES ('1XP==7FJHZUA','-','1',' ','2',NULL,'1','1XP==7FJHZUA','C','1XP=6ZW424Y7',NULL,' ','1',{ts'2021-09-23  00:00:00'},'mdr_item_class','1',206687,'0',{ts'2021-10-08  00:00:00'},'1',0,NULL); 


DELETE FROM T_CR_CODERULE_L WHERE FPKID = '1XP==7FJJJRY';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1XP==7FJHZUA','1XP==7FJJJRY','zh_CN','商品分类编码规则'); 

DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '1XP=M5DB7YHW';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1XP==7FJHZUA',1,'1',' ','0','1XP=M5DB7YHW',1,'1','1',0,8,'1','IC',' ','1',' ','0',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '1XP=M5DB7YHX';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1XP==7FJHZUA',1,'16','-','0','1XP=M5DB7YHX',1,'1',' ',1,6,'1',' ',' ','1',' ','1',' '); 



