احسن طريقه تمسح بيها ال DB من غي Error خالص

[[Dev] Arshivel]

بسم الله الرحمن الرحيم

نبدء على بركه الله

1_

use [sro_vt_account]
go
truncate table [dbo].[tb_user]
truncate table [dbo].[tb_user_bak]
truncate table [dbo].[sk_charrenamelog]
truncate table [dbo].[_punishment]
truncate table [dbo].[_servicemanagerlog]
truncate table [dbo].[test_hn]
truncate table [dbo].[_blockeduser]
truncate table [dbo].[_casgmchatlog]
truncate table [dbo].[_notice]
truncate table [dbo].[_smclog]
truncate table [dbo].[quaysoepoint]
truncate table [dbo].[sk_item_guardlog]
truncate table [dbo].[sk_itemsalelog]
truncate table [dbo].[sk_packageitemsalelog]
truncate table [dbo].[sk_pk_updatelog]
truncate table [dbo].[sk_resetskilllog]
truncate table [dbo].[sk_silk]
truncate table [dbo].[sk_silkbuylist]
truncate table [dbo].[sk_silkgoods]
truncate table [dbo].[sk_subtractsilk_vas]
truncate table [dbo].[sr_shardcharnames]
truncate table [dbo].[tb_net2e]
truncate table [dbo].[tb_net2e_bak]
truncate table [dbo].[tb_paygate_trans]
truncate table [dbo].[_privilegedip]

2_

use [sro_vt_shard]
go
truncate table _openmarket
print 'cleaned _openmarket'
truncate table _charskill
print 'cleaned _charskill'
truncate table _charskillmastery
print 'cleaned _charskillmastery'
truncate table _guildmember
print 'cleaned _guildmember'
truncate table _blockedwhisperers
print 'cleaned _blockedwhisperers'
truncate table _inventory
print 'cleaned _inventory'
truncate table _inventoryforavatar
print 'cleaned _inventoryforavatar'
truncate table _inventoryforlinkedstorage
print 'cleaned _inventoryforlinkedstorage'
truncate table _trainingcampmember
print 'cleaned _trainingcampmember'
truncate table _trainingcampsubmentorhonorpoint
print 'cleaned _trainingcampsubmentorhonorpoint'
update _trainingcamphonorrank set campid = null, rank = null
print 'cleaned _trainingcamphonorrank'
truncate table _trainingcampbuffstatus
print 'cleaned _trainingcampbuffstatus'
delete from _trainingcamp
print 'cleaned _trainingcamp'
truncate table _staticavatar
print 'cleaned _staticavatar'
truncate table _user
print 'cleaned _user'
truncate table _friend
print 'cleaned _friend'
truncate table _memo
print 'cleaned _memo'
truncate table _timedjob
print 'cleaned _timedjob'
truncate table _chartrijobsafetrade
print 'cleaned _chartrijobsafetrade'
delete from _chartrijob
print 'cleaned _chartrijob'
truncate table _invcos
print 'cleaned _invcos'
delete from _charcos where id > 0
print 'cleaned _charcos'
delete from _char where charid > 0
print 'cleaned _char'
truncate table _chest
print 'cleaned _chest'
truncate table _chestinfo
print 'cleaned _chestinfo'
truncate table _itempool
print 'cleaned _itempool'
delete from _items where id64 > 0
print 'cleaned _items'
delete from _accountjid
print 'cleaned _accountjid'
update _alliedclans set ally1 = 0, ally2 = 0, ally3 = 0, ally4 = 0, ally5 = 0, ally6 = 0, ally7 = 0, ally8 = 0
print 'cleaned _alliedclans'
truncate table _guildwar
print 'cleaned _guildwar'
truncate table _charnamelist
print 'cleaned _charnamelist'
truncate table _charquest
print 'cleaned _charquest'
truncate table _clientconfig
print 'cleaned _clientconfig'
truncate table _deletedchar
print 'cleaned _deletedchar'
truncate table _siegefortressstonestate
print 'cleaned _siegefortressstonestate'
truncate table _siegefortressrequest
print 'cleaned _siegefortressrequest'
truncate table _siegefortressobject
print 'cleaned _siegefortressobject'
truncate table _siegefortressitemforge
print 'cleaned _siegefortressitemforge'
truncate table _siegefortressbattlerecord
print 'cleaned _siegefortressbattlerecord'
update _siegefortressstruct set ownerguildid = '0'
print 'cleaned _siegefortressstruct'
update _siegefortress set guildid = '0', taxratio = '0', tax = '0', npchired = '0', introduction = null, createddungeontime = null, createddungeoncount = null
print 'cleaned _siegefortress'
truncate table _charnicknamelist
print 'cleaned _charnicknamelist'
truncate table _gphistory
print 'cleaned _gphistory'
truncate table _guildchest
print 'cleaned _guildchest'
delete from _guild where id > 0
print 'cleaned _guild'
delete from _alliedclans where id > 0
print 'cleaned _alliedclans'

3_

use [log_db]
go
truncate table [dbo].[_logcashitem]
truncate table [dbo].[_logeventchar]
truncate table [dbo].[_logeventitem]
truncate table [dbo].[_logeventsiegefortress]
truncate table [dbo].[_logschedule]
truncate table [dbo].[_logserverevent]

سلموز