SQL queries: Reset database

[Bolo]

Reset database without deleting any accounts.

DELETE CHARACTERS & ITEMS

Code Select Expand

USE MuOnline;
GO

-- Character inventories
DELETE FROM Inventory;

-- Warehouse
DELETE FROM Warehouse;

-- Extended warehouse (if exists)
IF OBJECT_ID('ExtWarehouse') IS NOT NULL
    DELETE FROM ExtWarehouse;

-- Characters
DELETE FROM Character;

-- Skills
DELETE FROM Magic;

-- Master skills (S21)
IF OBJECT_ID('MasterSkillTree') IS NOT NULL
    DELETE FROM MasterSkillTree;

-- Quest data
DELETE FROM QuestMu;
DELETE FROM QuestWorld;

GUILDS RESET

Code Select Expand

DELETE FROM GuildMember;
DELETE FROM Guild;
DELETE FROM Alliance;

EVENT DATA RESET

Code Select Expand

-- Blood Castle
IF OBJECT_ID('T_BC_MEMBER_SCORE') IS NOT NULL
    DELETE FROM T_BC_MEMBER_SCORE;

-- Devil Square
IF OBJECT_ID('T_DS_MEMBER_SCORE') IS NOT NULL
    DELETE FROM T_DS_MEMBER_SCORE;

-- Chaos Castle
IF OBJECT_ID('T_CC_MEMBER_SCORE') IS NOT NULL
    DELETE FROM T_CC_MEMBER_SCORE;

-- Illusion Temple
IF OBJECT_ID('T_IT_MEMBER_SCORE') IS NOT NULL
    DELETE FROM T_IT_MEMBER_SCORE;

CASTLE SIEGE RESET

Code Select Expand

DELETE FROM MuCastle_DATA;
DELETE FROM MuCastle_NPC;
DELETE FROM MuCastle_REG_SIEGE;
DELETE FROM MuCastle_SIEGE_GUILDLIST;
DELETE FROM MuCastle_STATE;

RANKINGS

Code Select Expand

USE MuRanking;
GO

DELETE FROM Ranking;
DELETE FROM RankingReset;
DELETE FROM RankingMaster;

If rankings are stored in MuOnline:

Code Select Expand

DELETE FROM Ranking;

CASH SHOP

Code Select Expand

USE MuCashShop;
GO

DELETE FROM CashShopInventory;
DELETE FROM CashShopData;


Before applying these queries, please test them on the beta/test version of MuOnline. Once verified, and then you can applied to the official version.