/* 人员预制编码规则 */
delete from t_cr_coderule_l where FID = '/T5+FNAAJ925';
INSERT INTO t_cr_coderule_l (FPKID, FID, FLOCALEID, FNAME) (SELECT TOP 1  '/T5+FNAE4IUS', '/T5+FNAAJ925', 'zh_CN', '人员预置编码规则' FROM t_cr_coderule_l WHERE NOT EXISTS (SELECT 1 FROM t_cr_coderule WHERE FBIZOBJECTID ='bos_user'));
INSERT INTO t_cr_coderule_l (FPKID, FID, FLOCALEID, FNAME) (SELECT TOP 1  '/T5+FNAE4IUR', '/T5+FNAAJ925', 'zh_TW', '人員預置編碼規則' FROM t_cr_coderule_l WHERE NOT EXISTS (SELECT 1 FROM t_cr_coderule WHERE FBIZOBJECTID ='bos_user'));

delete from t_cr_coderuleentry where FID = '/T5+FNAAJ925';
INSERT INTO t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) (SELECT TOP 1  '/T5//LMF/2Y7', '/T5+FNAAJ925', '0', '16', '1', ' ', ' ', ' ', '8', '1', '1', ' ', '0', '1', '1', '0', '', '1' FROM t_cr_coderuleentry WHERE NOT EXISTS (SELECT 1 FROM t_cr_coderule WHERE FBIZOBJECTID ='bos_user'));

delete from t_cr_coderule where FID = '/T5+FNAAJ925';
INSERT INTO t_cr_coderule (FID, FNUMBER, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FMASTERID, FISUPDATERECOVER) (SELECT TOP 1  '/T5+FNAAJ925', ' ', 'bos_user', '-', '1', '3', ' ', ' ', '1', 'C', 1, CURDATE(), 1, CURDATE(), '/T5+FNAAJ925', '0' FROM t_cr_coderule WHERE NOT EXISTS (SELECT 1 FROM t_cr_coderule WHERE FBIZOBJECTID ='bos_user'));