[che_9299]

USE [SRO_VT_SHARD]
GO
TRUNCATE TABLE _SiegeFortressObject
TRUNCATE TABLE _SiegeFortressBattleRecord
TRUNCATE TABLE _SiegeFortressRequest
TRUNCATE TABLE _SiegeFortressStoneState

USE [SRO_VT_SHARD]
GO
DELETE FROM _SiegeFortressStruct
WHERE RefObjID IN (SELECT [ID] FROM _RefObjCommon WITH (NOLOCK) WHERE TypeID1 = 1 AND TypeID2 = 2 AND TypeID3 = 5 AND TypeID4 = 6)
UPDATE _SiegeFortressStruct SET OwnerGuildID=0
UPDATE _SiegeFortress SET GuildID=0, TaxRatio=0, Tax=0, NPCHired=0, TempGuildID=0, Introduction=NULL,
CreatedDungeonTime=NULL, CreatedDungeonCount=NULL, IntroductionModificationPermission=1