高新区管委会,以5.0标准版为基准,从双汇项目拷贝

sql_20200715_清理数据.sql 1.3KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. truncate table dbo.rep_agent_detail
  2. truncate table dbo.rep_agent_state
  3. truncate table dbo.rep_conference
  4. truncate table dbo.rep_ext_call_in
  5. truncate table dbo.rep_ext_call_out
  6. truncate table dbo.rep_host
  7. truncate table dbo.rep_ivr_call_out
  8. truncate table dbo.rep_transfer
  9. truncate table dbo.rep_trunk_call_in
  10. truncate table dbo.T_Call_Blacklist
  11. truncate table dbo.T_Call_CallRecords
  12. truncate table dbo.T_Call_CallRecordsLD
  13. truncate table dbo.T_Call_LeaveRecord
  14. truncate table dbo.T_Call_PageField
  15. truncate table dbo.T_Call_ZBDH
  16. truncate table dbo.T_Cus_AddressBook
  17. truncate table dbo.T_Cus_Customer
  18. truncate table dbo.T_Msg_List
  19. truncate table dbo.T_QC_IndexRes
  20. truncate table dbo.T_RepositoryCategory
  21. truncate table dbo.T_RepositoryInformation
  22. truncate table dbo.T_Sys_Accessories
  23. truncate table dbo.T_Sys_WorkOffDays
  24. truncate table dbo.T_Sys_WorkTimes
  25. truncate table T_Wo_WorkOrderItem_New
  26. truncate table dbo.telloc_users
  27. drop table dbo.T_Wo_WorkOrder
  28. drop table dbo.T_Wo_WorkOrderItem
  29. drop table dbo.T_Wo_WorkOrderItem_New
  30. drop table dbo.T_Wo_WorkOrderTimeOut
  31. drop table dbo.T_Call_PageField
  32. drop table dbo.T_Call_WorkOrder
  33. drop table dbo.T_Call_TaskTelNum
  34. drop table dbo.T_Cus_ContactPerson
  35. drop table dbo.T_Cus_CustomerBase
  36. drop table dbo.T_Cus_CustomerExpand
  37. drop table dbo.t_kdaccount_gl
  38. drop table dbo.T_Sys_ApplicationsVersion
  39. drop table dbo.T_Sys_EquipmentNumber