/*分析方案编码编码规则 added by qiheng_chen at 2019-7-31 */
DELETE FROM t_cr_coderule where FID = '03TIVUMD4VHF';
DELETE FROM t_cr_coderule_l where FID = '03TIVUMD4VHF';
DELETE FROM t_cr_coderuleentry where FID = '03TIVUMD4VHF';

INSERT INTO t_cr_coderule (FID, FNUMBER, FRULETYPE, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FMASTERID, FISUPDATERECOVER)  
     VALUES ('03TIVUMD4VHF', ' ', ' ', 'bcm_analyticssoluentry', '-', '1', '1', ' ', ' ', '1', 'C', '1', {ts'2018-10-09 21:13:37'}, '1', {ts'2019-01-21 15:17:47'}, 0, NULL, '03TIVUMD4VHF', '0');
INSERT INTO t_cr_coderule_l (FPKID, FID, FLOCALEID, FNAME) 
     VALUES ('03TIVUMD4VHJ', '03TIVUMD4VHF', 'zh_CN', '分析方案编码');
INSERT INTO t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE)
     VALUES ('03TIW/Z/AGNW', '03TIVUMD4VHF', '0', '1', '1', ' ', 'FX', ' ', '8', '1', '1', ' ', '0', '1', '1', '0', '0', '1');
INSERT INTO t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE)
     VALUES ('03TIW/Z/AGNX', '03TIVUMD4VHF', '1', '2', '1', 'createtime', 'yyyyMMdd', ' ', '8', '1', '1', ' ', '1', '1', '1', '1', '0', '1');
INSERT INTO t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE)
     VALUES ('03TIW/Z/AGNY', '03TIVUMD4VHF', '2', '16', '1', ' ', ' ', ' ', '4', '1', '1', ' ', '1', '1', '1', '0', '0', '1');