Newer
Older
casic-callcenter-xz / casic-web / doc / sql / clear.sql
liwenhao on 2 Mar 2023 536 bytes 徐州呼叫中心代码提交
--清理同步组织及用户数据
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;