XYX12345_Api/数据库/清理工单...

truncate table dbo.rep_agent_detail
truncate table dbo.rep_agent_state
truncate table dbo.rep_agentState_Detail
truncate table dbo.rep_agentState_Duration
truncate table dbo.rep_conference
truncate table dbo.rep_ext_call_in
truncate table dbo.rep_ext_call_out
truncate table dbo.rep_host
truncate table dbo.rep_transfer
truncate table dbo.rep_trunk_call_in

truncate table dbo.T_Bus_Additional
truncate table dbo.T_Bus_AssignedInfo
truncate table dbo.T_Bus_AssignedItemInfo
truncate table dbo.T_Bus_DelayTime
truncate table dbo.T_Bus_Feedback
truncate table dbo.T_Bus_NoticeCriticism
truncate table dbo.T_Bus_Operation
truncate table dbo.T_Bus_RemindRecord
truncate table dbo.T_Bus_SubmitSuper
truncate table dbo.T_Bus_UserWorkOrder
truncate table dbo.T_Bus_VisitResult
truncate table dbo.T_Bus_VisitResultRecords
truncate table dbo.T_Bus_WorkOrder
truncate table dbo.T_Bus_WorkOrder_GovernmentServiceWO_Map

truncate table dbo.T_Call_Blacklist
truncate table dbo.T_Call_CallRecords
truncate table dbo.T_Call_LeaveRecord
truncate table dbo.T_Call_RecordSet
truncate table dbo.T_Call_TaskTelNum

truncate table dbo.T_Client_Applications
truncate table dbo.T_Client_Article
truncate table dbo.T_Client_FAQ
truncate table dbo.T_Client_UserFeedback
truncate table dbo.T_Client_UserGrade

delete dbo.T_CTI_Task where TaskID>0
truncate table dbo.T_CTI_TaskCategory
truncate table dbo.T_CTI_TaskVoiceTemp

truncate table dbo.T_Cus_AddressBook
truncate table dbo.T_Cus_CustomerBase

truncate table dbo.T_Email_EmailList
truncate table dbo.T_Email_EmailMessage_Map
truncate table dbo.T_Email_SendEmail

truncate table dbo.T_Msg_Chat
truncate table dbo.T_Msg_Chat_Map
truncate table dbo.T_Msg_NoticeInfo

truncate table dbo.T_RepositoryAudit
truncate table dbo.T_RepositoryCategory
truncate table dbo.T_RepositoryInformation
truncate table dbo.T_RepositoryLog

truncate table dbo.T_SMS_InternalMessages
truncate table dbo.T_SMS_RecvSMS
truncate table dbo.T_SMS_SendSMSTask
truncate table dbo.T_SMS_SentSMS
truncate table dbo.T_Sms_SmsModel

truncate table dbo.T_Sys_Accessories
truncate table dbo.T_Sys_Class
truncate table dbo.T_Sys_GroupClass
truncate table dbo.T_Sys_Group
truncate table dbo.T_Sys_LoginLogs
truncate table dbo.T_Sys_UserClass
truncate table dbo.T_Sys_UserGroup
truncate table dbo.T_Sys_Users
truncate table dbo.T_Sys_WorkTimes

delete dbo.T_Sys_UserAccount where F_UserCode !='8000'

truncate table dbo.T_Web_News
truncate table dbo.T_Web_Link
truncate table dbo.T_Web_SurveyResult
truncate table dbo.T_Web_WorkAccountSearch
truncate table dbo.T_Web_WorkRelease