-- 全部为已审核状态
update t_org_org set fstatus = 'C' where fstatus != 'C';
update t_org_org set fenable = '1' where fenable = ' ';
update t_org_structure set fstatus = 'C' where fstatus != 'C';
update t_org_structure set fenable = '1' where fenable = ' ';

update t_sec_user set fstatus = 'C' where fstatus != 'C';
update t_sec_user set fenable = '1' where fenable = ' ';

-- 勾选是否业务组织
update t_org_org o set fisbizorg = '1' where EXISTS (SELECT 1 from t_org_structure where o.FID = FORGID AND fviewid not in (1));