--清理同步组织及用户数据 DELETE from sys_user WHERE is_sync = 1; DELETE from sys_dept WHERE is_sync = 1 and id not in(1206912151121952770,24); DELETE from sys_user_role_relation where USERID not in(SELECT id from sys_user); --清理业务数据sql delete from call_call_record; delete from call_case; delete from call_case_delay; delete from call_case_report; delete from call_case_urge; #delete from call_customer; delete from call_process_detail; #delete from call_sound; delete from call_supervise; delete from call_urge;