-- 修改商机项目编码规则
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '3ZUDCIMX0P7J';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '3ZUDCIMX0P7K';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '3ZUDCIMX0P7L';
DELETE FROM T_CR_CodeRule WHERE FID = '3YVA=Q9RUZXL';
DELETE FROM T_CR_CodeRule_l WHERE FID = '3YVA=Q9RUZXL' and FLOCALEID = 'zh_CN';
DELETE FROM T_CR_CodeRule_l WHERE FID = '3YVA=Q9RUZXL' and FLOCALEID = 'zh_TW';


DELETE FROM T_CR_CodeRule WHERE FID = '3YVA=Q9RUZXL';
INSERT INTO T_CR_CodeRule(FFILTERCONDITION,FISMATCHCODERULE,FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FISCHECKNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID,FCONDITIONDESC) VALUES ('{"filterRow":[{"id":"3YWF+9Q5KL2S","leftBracket":"","compareType":"67","fieldName":"remark","rightBracket":"","logic":"0","value":[{"id":"3YWF+9Q97/ZJ","value":"#!#@启用商机项目编码@#!#"}],"baseDataIds":[]}],"forList":false}','0',' ','2','1','0','3YVA=Q9RUZXL','0','0',{ts'2024-02-29  00:00:00'},'pmpd_project','1','0','1','1','0','0','3YVA=Q9RUZXL','1','-','0','C','3YV=Z0XPWFYT',' ','1',1895588229168499712,'1',{ts'2024-04-01  00:00:00'},0,' '); 

DELETE FROM T_CR_CodeRule_L WHERE FPKID = '3YVA=Q9RUZ8B';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3YVA=Q9RUZXL','3YVA=Q9RUZ8B','zh_CN','商机项目编码规则'); 
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '3ZUDCIKGRXWG';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3YVA=Q9RUZXL','3ZUDCIKGRXWG','zh_TW','商機項目編碼規則'); 


DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '4/OW0FSBP36A';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3YVA=Q9RUZXL',1,'1',' ','0','4/OW0FSBP36A',1,'1','1',0,8,'1','BXM','1',' ',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '4/OW0FSBP36B';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3YVA=Q9RUZXL',1,'9','-','1','4/OW0FSBP36B',1,'1',' ',1,8,'1','yyyyMMdd','1',' ',' ','1',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '4/OW0FSBP36C';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3YVA=Q9RUZXL',1,'16','-','0','4/OW0FSBP36C',1,'1',' ',2,3,'1',' ','1',' ',' ','1',' '); 
