新野县12345_后端

清理工单sql.txt 2.5KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081
  1. truncate table dbo.rep_agent_detail
  2. truncate table dbo.rep_agent_state
  3. truncate table dbo.rep_agentState_Detail
  4. truncate table dbo.rep_agentState_Duration
  5. truncate table dbo.rep_conference
  6. truncate table dbo.rep_ext_call_in
  7. truncate table dbo.rep_ext_call_out
  8. truncate table dbo.rep_host
  9. truncate table dbo.rep_transfer
  10. truncate table dbo.rep_trunk_call_in
  11. truncate table dbo.T_Bus_Additional
  12. truncate table dbo.T_Bus_AssignedInfo
  13. truncate table dbo.T_Bus_AssignedItemInfo
  14. truncate table dbo.T_Bus_DelayTime
  15. truncate table dbo.T_Bus_Feedback
  16. truncate table dbo.T_Bus_NoticeCriticism
  17. truncate table dbo.T_Bus_Operation
  18. truncate table dbo.T_Bus_RemindRecord
  19. truncate table dbo.T_Bus_SubmitSuper
  20. truncate table dbo.T_Bus_UserWorkOrder
  21. truncate table dbo.T_Bus_VisitResult
  22. truncate table dbo.T_Bus_VisitResultRecords
  23. truncate table dbo.T_Bus_WorkOrder
  24. truncate table dbo.T_Bus_WorkOrder_GovernmentServiceWO_Map
  25. truncate table dbo.T_Call_Blacklist
  26. truncate table dbo.T_Call_CallRecords
  27. truncate table dbo.T_Call_LeaveRecord
  28. truncate table dbo.T_Call_RecordSet
  29. truncate table dbo.T_Call_TaskTelNum
  30. truncate table dbo.T_Client_Applications
  31. truncate table dbo.T_Client_Article
  32. truncate table dbo.T_Client_FAQ
  33. truncate table dbo.T_Client_UserFeedback
  34. truncate table dbo.T_Client_UserGrade
  35. delete dbo.T_CTI_Task where TaskID>0
  36. truncate table dbo.T_CTI_TaskCategory
  37. truncate table dbo.T_CTI_TaskVoiceTemp
  38. truncate table dbo.T_Cus_AddressBook
  39. truncate table dbo.T_Cus_CustomerBase
  40. truncate table dbo.T_Email_EmailList
  41. truncate table dbo.T_Email_EmailMessage_Map
  42. truncate table dbo.T_Email_SendEmail
  43. truncate table dbo.T_Msg_Chat
  44. truncate table dbo.T_Msg_Chat_Map
  45. truncate table dbo.T_Msg_NoticeInfo
  46. truncate table dbo.T_RepositoryAudit
  47. truncate table dbo.T_RepositoryCategory
  48. truncate table dbo.T_RepositoryInformation
  49. truncate table dbo.T_RepositoryLog
  50. truncate table dbo.T_SMS_InternalMessages
  51. truncate table dbo.T_SMS_RecvSMS
  52. truncate table dbo.T_SMS_SendSMSTask
  53. truncate table dbo.T_SMS_SentSMS
  54. truncate table dbo.T_Sms_SmsModel
  55. truncate table dbo.T_Sys_Accessories
  56. truncate table dbo.T_Sys_Class
  57. truncate table dbo.T_Sys_GroupClass
  58. truncate table dbo.T_Sys_Group
  59. truncate table dbo.T_Sys_LoginLogs
  60. truncate table dbo.T_Sys_UserClass
  61. truncate table dbo.T_Sys_UserGroup
  62. truncate table dbo.T_Sys_Users
  63. truncate table dbo.T_Sys_WorkTimes
  64. delete dbo.T_Sys_UserAccount where F_UserCode !='8000'
  65. truncate table dbo.T_Web_News
  66. truncate table dbo.T_Web_Link
  67. truncate table dbo.T_Web_SurveyResult
  68. truncate table dbo.T_Web_WorkAccountSearch
  69. truncate table dbo.T_Web_WorkRelease