Reset Database

[elitonfarol9]

Hello, I'm going to make this script available to reset the database, this is useless, but it will serve someone, redefine the PS_GameLog, PS_GameData, PS_UserData, PS_ChatLog.

 Spoiler

TRUNCATE TABLE [PS_GameData].[dbo].[_CreatedChars];
TRUNCATE TABLE [PS_GameData].[dbo].[_DeletedChars];
TRUNCATE TABLE [PS_GameData].[dbo].[_GuildDetailsBack];
TRUNCATE TABLE [PS_GameData].[dbo].[_GuildRankPoint];
TRUNCATE TABLE [PS_GameData].[dbo].[_GuildsBack];
TRUNCATE TABLE [PS_GameData].[dbo].[BanChars];
TRUNCATE TABLE [PS_GameData].[dbo].[CharApplySkills];
TRUNCATE TABLE [PS_GameData].[dbo].[CharBacks];
TRUNCATE TABLE [PS_GameData].[dbo].[CharEvents];
TRUNCATE TABLE [PS_GameData].[dbo].[CharItems];
TRUNCATE TABLE [PS_GameData].[dbo].[CharQuests];
TRUNCATE TABLE [PS_GameData].[dbo].[CharQuickSlotBacks];
TRUNCATE TABLE [PS_GameData].[dbo].[CharQuickSlots];
TRUNCATE TABLE [PS_GameData].[dbo].[CharRenameLog];
TRUNCATE TABLE [PS_GameData].[dbo].[Chars];
TRUNCATE TABLE [PS_GameData].[dbo].[CharSavePoint];
TRUNCATE TABLE [PS_GameData].[dbo].[CharSavePointBack];
TRUNCATE TABLE [PS_GameData].[dbo].[CharSkillBacks];
TRUNCATE TABLE [PS_GameData].[dbo].[CharSkills];
TRUNCATE TABLE [PS_GameData].[dbo].[ConsiderBank];
TRUNCATE TABLE [PS_GameData].[dbo].[ConsiderInven];
TRUNCATE TABLE [PS_GameData].[dbo].[EventLog_CharSkill1];
TRUNCATE TABLE [PS_GameData].[dbo].[EventLog_CharSkill2];
TRUNCATE TABLE [PS_GameData].[dbo].[EventLog_CharStat];
TRUNCATE TABLE [PS_GameData].[dbo].[FriendChars];
TRUNCATE TABLE [PS_GameData].[dbo].[GuildChars];
TRUNCATE TABLE [PS_GameData].[dbo].[GuildDetails];
TRUNCATE TABLE [PS_GameData].[dbo].[GuildNpcLv];
TRUNCATE TABLE [PS_GameData].[dbo].[GuildRankLog];
TRUNCATE TABLE [PS_GameData].[dbo].[GuildRankLog2];
TRUNCATE TABLE [PS_GameData].[dbo].[Guilds];
TRUNCATE TABLE [PS_GameData].[dbo].[GuildStoredItems];
TRUNCATE TABLE [PS_GameData].[dbo].[HackLog];
TRUNCATE TABLE [PS_GameData].[dbo].[Keeps];
TRUNCATE TABLE [PS_GameData].[dbo].[Market];
TRUNCATE TABLE [PS_GameData].[dbo].[MarketCharConcern];
TRUNCATE TABLE [PS_GameData].[dbo].[MarketCharResultItems];
TRUNCATE TABLE [PS_GameData].[dbo].[MarketCharResultItems_DelLog];
TRUNCATE TABLE [PS_GameData].[dbo].[MarketCharResultMoney];
TRUNCATE TABLE [PS_GameData].[dbo].[MarketCharResultMoney_DelLog];
TRUNCATE TABLE [PS_GameData].[dbo].[MarketItems];
TRUNCATE TABLE [PS_GameData].[dbo].[MarketItems_DelLog];
TRUNCATE TABLE [PS_GameData].[dbo].[PointErrorLog];
TRUNCATE TABLE [PS_GameData].[dbo].[PointGiftNotify];
TRUNCATE TABLE [PS_GameData].[dbo].[PointLog];
TRUNCATE TABLE [PS_GameData].[dbo].[ProductLog];
TRUNCATE TABLE [PS_GameData].[dbo].[QuestAward];
TRUNCATE TABLE [PS_GameData].[dbo].[TmpGuildEtin];
TRUNCATE TABLE [PS_GameData].[dbo].[UserMaxGrow];
TRUNCATE TABLE [PS_GameData].[dbo].[UserStoredItems];
TRUNCATE TABLE [PS_GameData].[dbo].[UserStoredMoney];
TRUNCATE TABLE [PS_GameData].[dbo].[UserStoredPointItems];
TRUNCATE TABLE [PS_UserData].[dbo].[UserBlockLog];
TRUNCATE TABLE [PS_UserData].[dbo].[UserLeaveLog];
TRUNCATE TABLE [PS_UserData].[dbo].[UserLoginLog];
TRUNCATE TABLE [PS_UserData].[dbo].[UserPauseLog];
TRUNCATE TABLE [PS_UserData].[dbo].[UserPointChargeLog];
TRUNCATE TABLE [PS_UserData].[dbo].[Users_Block];
TRUNCATE TABLE [PS_UserData].[dbo].[Users_Block];
TRUNCATE TABLE [PS_UserData].[dbo].[Users_BlockLog];
TRUNCATE TABLE [PS_UserData].[dbo].[Users_Deleted];
TRUNCATE TABLE [PS_UserData].[dbo].[Users_Detail];
TRUNCATE TABLE [PS_UserData].[dbo].[Users_Master];
TRUNCATE TABLE [PS_UserData].[dbo].[Users_Updatelog];
TRUNCATE TABLE [PS_ChatLog].[dbo].[ChatLog];
TRUNCATE TABLE [PS_GameLog].[dbo].[ActionLog];

Just run into your database as a new query

If this has already been released here, please let me know

[XareL]

yeah this is will work but i'm suggest this script because easy and small

USE [PS_GameData] /* Select db for delete all tables */
GO
EXEC sp_MSForEachTable "TRUNCATE TABLE ?"
GO