/*联动映射编码规则 added by 徐亮 at 2019-5-21 */
DELETE FROM t_cr_coderule where FID = '/ZGEOYYL6XJN';
DELETE FROM t_cr_coderule_l where FID = '/ZGEOYYL6XJN';
DELETE FROM t_cr_coderuleentry where FID = '/ZGEOYYL6XJN';

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 ('/ZGEOYYL6XJN', ' ', ' ', 'bcm_linkagemapping', '-', '1', '1', ' ', ' ', '1', 'C', '1', {ts'2018-10-09 21:13:37'}, '1', {ts'2019-01-21 15:17:47'}, 0, NULL, '/ZGEOYYL6XJN', '0');
INSERT INTO t_cr_coderule_l (FPKID, FID, FLOCALEID, FNAME) 
     VALUES ('/ZGEOYYL6XJP', '/ZGEOYYL6XJN', '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 ('/ZGEOZ+27JMW', '/ZGEOYYL6XJN', '0', '2', '1', 'modifytime', 'yyMM', ' ', '8', '1', '1', ' ', '1', '1', '1', '1', ' ', '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 ('/ZGEOZ+27JMX', '/ZGEOYYL6XJN', '1', '16', '1', ' ', ' ', ' ', '6', '1', '1', ' ', '1', '1', '1', '0', '-', '1');