Paylaşım Vsro veritabanı temizleme, sıfırlama

USE [SRO_VT_ACCOUNT]

GO

TRUNCATE TABLE [dbo].[TB_User]

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_paygate_trans]

USE [SRO_VT_LOG]

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]

USE [SRO_VT_SHARD]

GO

truncate table _OpenMarket

print 'Temizlendi: _OpenMarket'

truncate table _CharSkill

print 'Temizlendi: _CharSkill'

truncate table _CharSkillMastery

print 'Temizlendi: _CharSkillMastery'

truncate table _GuildMember

print 'Temizlendi: _GuildMember'

truncate table _BlockedWhisperers

print 'Temizlendi: _BlockedWhisperers'

truncate table _Inventory

print 'Temizlendi: _Inventory'

truncate table _InventoryForAvatar

print 'Temizlendi: _InventoryForAvatar'

truncate table _InventoryForLinkedStorage

print 'Temizlendi: _InventoryForLinkedStorage'

truncate table _TrainingCampMember

print 'Temizlendi: _TrainingCampMember'

truncate table _TrainingCampSubMentorHonorPoint

print 'Temizlendi: _TrainingCampSubMentorHonorPoint'

update _TrainingCampHonorRank set CampID = NULL, Rank = NULL

print 'Temizlendi: _TrainingCampHonorRank'

truncate table _TrainingCampBuffStatus

print 'Temizlendi: _TrainingCampBuffStatus'

delete from _TrainingCamp

print 'Temizlendi: _TrainingCamp'

truncate table _StaticAvatar

print 'Temizlendi: _StaticAvatar'

truncate table _User

print 'Temizlendi: _User'

truncate table _Friend

print 'Temizlendi: _Friend'

truncate table _Memo

print 'Temizlendi: _Memo'

truncate table _TimedJob

print 'Temizlendi: _TimedJob'

truncate table _CharTrijobSafeTrade

print 'Temizlendi: _CharTrijobSafeTrade'

delete from _CharTrijob

print 'Temizlendi: _CharTrijob'

truncate table _InvCOS

print 'Temizlendi: _InvCOS'

delete from _CharCOS where ID > 0

print 'Temizlendi: _CharCOS'

delete from _Char where charid > 0

print 'Temizlendi: _Char'

truncate table _Chest

print 'Temizlendi: _Chest'

truncate table _ChestInfo

print 'Temizlendi: _ChestInfo'

truncate table _ItemPool

print 'Temizlendi: _ItemPool'

delete from _Items where ID64 > 0

print 'Temizlendi: _Items'

delete from _AccountJID

print 'Temizlendi: _AccountJID'

update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0

print 'Temizlendi: _AlliedClans'

truncate table _GuildWar

print 'Temizlendi: _GuildWar'

truncate table _CharNameList

print 'Temizlendi: _CharNameList'

truncate table _CharQuest

print 'Temizlendi: _CharQuest'

truncate table _ClientConfig

print 'Temizlendi: _ClientConfig'

truncate table _DeletedChar

print 'Temizlendi: _DeletedChar'

truncate table _SiegeFortressStoneState

print 'Temizlendi: _SiegeFortressStoneState'

truncate table _SiegeFortressRequest

print 'Temizlendi: _SiegeFortressRequest'

truncate table _SiegeFortressObject

print 'Temizlendi: _SiegeFortressObject'

truncate table _SiegeFortressItemForge

print 'Temizlendi: _SiegeFortressItemForge'

truncate table _SiegeFortressBattleRecord

print 'Temizlendi: _SiegeFortressBattleRecord'

update _SiegeFortressStruct SET OwnerGuildID = '0'

print 'Temizlendi: _SiegeFortressStruct'

UPDATE  _SiegeFortress SET GuildID = '0', TaxRatio = '0', Tax = '0', NPCHired = '0', Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL

print 'Temizlendi: _SiegeFortress'

truncate table _CharNickNameList

print 'Temizlendi: _CharNickNameList'

truncate table _GPHistory

print 'Temizlendi: _GPHistory'

truncate table _GuildChest

print 'Temizlendi: _GuildChest'

delete from _Guild where ID > 0

print 'Temizlendi: _Guild'

delete from _AlliedClans where ID > 0

print 'Temizlendi: _AlliedClans'