#清理错误的组织id
update jc_sys_data_perm set org_id =null where role_id is not null or user_id is not null;

delete 
FROM
 jc_sys_data_perm 
WHERE
	data_type IN ( 2, 3 ) 
	AND data_id IN ( SELECT channel_id FROM jc_channel WHERE deleted_flag = 1 );
delete 
FROM
 jc_sys_data_perm 
WHERE
	data_type IN ( 2, 3 ) 
	AND data_id not IN ( SELECT channel_id FROM jc_channel );

delete FROM jc_sys_data_perm where org_id  in  ( SELECT id FROM jc_sys_org WHERE deleted_flag = 1 );

delete FROM jc_sys_data_perm where org_id not in  ( SELECT id FROM jc_sys_org  );

delete FROM jc_sys_data_perm where role_id  in  ( SELECT id FROM jc_sys_role WHERE deleted_flag = 1 );
delete FROM jc_sys_data_perm where role_id not in  ( SELECT id FROM jc_sys_role  );
delete FROM jc_sys_data_perm where role_id  in  ( SELECT id FROM jc_sys_role WHERE deleted_flag = 1 );
delete FROM jc_sys_data_perm where user_id  not in  ( SELECT id FROM jc_sys_user );
delete FROM jc_sys_data_perm where user_id  in  ( SELECT id FROM jc_sys_user WHERE deleted_flag = 1 );
delete FROM jc_sys_data_perm where user_id not in  ( SELECT id FROM jc_sys_user  );

delete FROM jc_sys_perm_cfg  where org_id  in  ( SELECT id FROM jc_sys_org WHERE deleted_flag = 1 );
delete FROM jc_sys_perm_cfg  where org_id not in  ( SELECT id FROM jc_sys_org  );
delete FROM jc_sys_perm_cfg  where role_id  in  ( SELECT id FROM jc_sys_role WHERE deleted_flag = 1 );
delete FROM jc_sys_perm_cfg  where role_id not in  ( SELECT id FROM jc_sys_role  );
delete FROM jc_sys_perm_cfg  where user_id  not in  ( SELECT id FROM jc_sys_user );
delete FROM jc_sys_perm_cfg  where user_id  in  ( SELECT id FROM jc_sys_user WHERE deleted_flag = 1 );

#清理错误栏目
update jc_channel set deleted_flag =1 where site_id  in(select id from jc_site where is_delete =1);

delete FROM jc_sys_data_perm where data_type in(2,3) and data_id  in  ( SELECT channel_id FROM jc_channel where deleted_flag =1 );
delete FROM jc_sys_data_perm where data_type=1 and data_id  in  ( SELECT id FROM jc_site where deleted_flag =1 );
delete from jc_tr_menu_api where menu_management_id not in(select id from jc_sys_menu);
delete from jc_tr_menu_api where api_body_information_id not in(select id from jc_sys_api);

delete from jc_tr_org_menu where menu_id not in(select id from jc_sys_menu);
delete from  jc_tr_role_menu where menu_id not in(select id from jc_sys_menu);
delete from   jc_tr_user_menu where menu_id not in(select id from jc_sys_menu);