新野县12345_后端

sql_20191206_新野清理语句.sql 1.1KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. truncate table rep_agent_detail
  2. truncate table rep_agent_state
  3. truncate table rep_agentState_Detail
  4. truncate table rep_agentState_Duration
  5. truncate table rep_conference
  6. truncate table rep_ext_call_in
  7. truncate table rep_ext_call_out
  8. truncate table rep_host
  9. truncate table rep_transfer
  10. truncate table rep_trunk_call_in
  11. update stat_callid set value=1 where id=1
  12. truncate table T_Bus_AssignedInfo
  13. truncate table T_Bus_AssignedItemInfo
  14. truncate table T_Bus_DelayTime
  15. truncate table T_Bus_Feedback
  16. truncate table T_Bus_Operation
  17. truncate table T_Bus_RemindRecord
  18. truncate table T_Bus_SubmitSuper
  19. truncate table T_Bus_VisitResult
  20. truncate table T_Bus_VisitResultRecords
  21. truncate table T_Bus_WorkOrder
  22. truncate table T_Call_Blacklist
  23. truncate table T_Call_CallRecords
  24. truncate table T_Call_LeaveRecord
  25. truncate table T_Call_RecordSet
  26. truncate table T_Call_TaskTelNum
  27. truncate table T_Email_EmailMessage_Map
  28. truncate table T_Msg_Chat
  29. truncate table T_Msg_Chat_Map
  30. truncate table T_SMS_InternalMessages
  31. truncate table T_Sys_Accessories
  32. truncate table T_Sys_LoginLogs
  33. truncate table T_Sys_MobileData
  34. truncate table T_Cus_AddressBook
  35. truncate table T_Cus_CustomerBase