/* 新增“数据规则”的编码规则 */
DELETE from t_cr_coderule where fid = '1WGBEGC5VL2M';
INSERT INTO t_cr_coderule(FID, FNUMBER, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FMASTERID, FISUPDATERECOVER, FISNONBREAK, FISCHECKCODE, FISAPPCONDITION, FISAPPORG, FISLOG, FISSERIALNUMBER, FISUNIQUE, FISMODIFIABLE, FISADDVIEW) VALUES ( '1WGBEGC5VL2M','dr_coderule','perm_datarule','-','1','2',' ',' ','1','C', 0,{ts'2021-09-09 18:50:11'},0,{ts'2021-09-09 18:50:11'},'1WGBEGC5VL2M','0','0','0','0','0','0','1','0','0','1');
DELETE from t_cr_coderule_l where fid = '1WGBEGC5VL2M';
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('1WGBEGC5VJ1V','1WGBEGC5VL2M','zh_CN','数据规则方案');
DELETE from t_cr_coderuleentry where fid = '1WGBEGC5VL2M';
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('1WGBEGCN+O16','1WGBEGC5VL2M',0,'1','1',' ','DR',' ',8,1,1,' ','0','1','1','0',' ','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('1WGBEGCN+O17','1WGBEGC5VL2M',1,'16',' ',' ',' ',' ',8,1,1,' ','1','1','1','0','-','1');
/* 新增“业务角色”的编码规则 */
DELETE from t_cr_coderule where fid = '1WGD/TDNCA4F';
INSERT INTO t_cr_coderule(FID, FNUMBER, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FMASTERID, FISUPDATERECOVER, FISNONBREAK, FISCHECKCODE, FISAPPCONDITION, FISAPPORG, FISLOG, FISSERIALNUMBER, FISUNIQUE, FISMODIFIABLE, FISADDVIEW) VALUES ( '1WGD/TDNCA4F','bizrole_coderule','perm_busirole','-','1','2',' ',' ','1','C', 0,{ts'2021-09-09 19:07:10'},0,{ts'2021-09-09 19:07:10'},'1WGD/TDNCA4F','0','0','0','0','0','0','1','0','0','1');
DELETE from t_cr_coderule_l where fid = '1WGD/TDNCA4F';
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('1WGD/TDNCC57','1WGD/TDNCA4F','zh_TW','業務角色編碼規則');
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('1WGD/TDNCC58','1WGD/TDNCA4F','zh_CN','业务角色编码规则');
DELETE from t_cr_coderuleentry where fid = '1WGD/TDNCA4F';
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('1WGD/TE=R7H0','1WGD/TDNCA4F',0,'1','1',' ','BR',' ',8,1,1,' ','0','1','1','0',' ','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('1WGD/TE=R7H1','1WGD/TDNCA4F',1,'16',' ',' ',' ',' ',8,1,1,' ','1','1','1','0','-','1');
