-- 新增显示
update t_cr_coderule set FISADDVIEW = '1' where FAPPMODE = '2' or FAPPMODE = '3';

-- 允许修改
update t_cr_coderule set FISMODIFIABLE = '1' where FAPPMODE = '3';

-- 断号回收
update t_cr_coderule set FISNONBREAK = '1' where FAPPMODE = '1';

-- 流水号开关
update t_cr_coderule set FISSERIALNUMBER = '1';

-- 校验码开关
update t_cr_coderule set FISCHECKCODE = '1' where fid in (select tmp.a from (select FID as a, MAX(to_number(FATTRIBUTETYPE)) as b from T_CR_CODERULEENTRY  GROUP BY FID) as tmp  where tmp.b = '128');

-- 适用条件开关
update t_cr_coderule set FISAPPCONDITION = '1' where fid in (select fid from T_CR_APPCONDITION);

-- 受控组织
update t_cr_coderule set FISAPPORG = '1' where fid in (select fid from T_CR_APPORG);