USE [MuOnline];
GO

-- 1. Borra GUILD/CLANES y relaciones
DELETE FROM GuildMember;
DELETE FROM Guild;
DELETE FROM WarehouseGuild;

-- 2. Borra PERSONAJES
DELETE FROM Character;

-- 2.1. Borra relaciones de cuentas con personajes (muy importante)
DELETE FROM AccountCharacter;

-- 3. Borra ALMACENES Y EXTENDIDOS
DELETE FROM Warehouse;
DELETE FROM ExtWarehouse;

-- 4. Borra inventarios de cash shop
DELETE FROM CashShopData;
DELETE FROM CashShopInventory;
DELETE FROM CashShopPeriodicItem;

-- 5. Borra logs de items, logs de créditos, lucky coins, jewel bank, item bank, gifts, etc.
DELETE FROM ItemLog;
DELETE FROM LOG_CREDITOS;
DELETE FROM LuckyCoin;
DELETE FROM LuckyItem;
DELETE FROM CustomJewelBank;
DELETE FROM CustomItemBank;
DELETE FROM CustomGift;

-- 6. Borra amigos y correspondencia
DELETE FROM T_FriendList;
DELETE FROM T_FriendMail;
DELETE FROM T_FriendMain;
DELETE FROM T_PetItem_Info;
DELETE FROM T_WaitFriend;

-- 7. Borra datos de opción (configuraciones personales), skill trees, master skills
DELETE FROM OptionData;
DELETE FROM MasterSkillTree;

-- 8. Borra rankings (todos)
DELETE FROM RankingBattleRoyale;
DELETE FROM RankingBloodCastle;
DELETE FROM RankingChaosCastle;
DELETE FROM RankingDevilSquare;
DELETE FROM RankingDuel;
DELETE FROM RankingGvG;
DELETE FROM RankingIllusionTemple;
DELETE FROM RankingKingGuild;
DELETE FROM RankingKingPlayer;
DELETE FROM RankingPvpChampionship;
DELETE FROM RankingTvT;

-- 9. Borra quest personales y logs de eventos de personaje
DELETE FROM QuestWorld;
DELETE FROM QuestKillCount;
DELETE FROM CustomQuest;
DELETE FROM CustomNpcQuest;

-- 10. Borra custom, offline, command delay, store, flag, gift, skin, etc.
DELETE FROM CustomAttack;
DELETE FROM CustomAttackOffline;
DELETE FROM CustomCommandDelay;
DELETE FROM CustomFlag;
DELETE FROM CustomGift;
DELETE FROM CustomStore;
DELETE FROM CustomStoreOffline;
DELETE FROM CustomSkin;
DELETE FROM CustomLuckyWheel;

-- 11. Borra información de eventos y castillos
DELETE FROM EventAuction;
DELETE FROM EventAuctionReward;
DELETE FROM EventEntryCount;
DELETE FROM EventLeoTheHelper;
DELETE FROM EventSantaClaus;
DELETE FROM MuCastle_DATA;
DELETE FROM MuCastle_MONEY_STATISTICS;
DELETE FROM MuCastle_NPC;
DELETE FROM MuCastle_REG_SIEGE;
DELETE FROM MuCastle_SIEGE_GUILDLIST;

-- 12. Borra información de Gens, gremory, helper, mary, MK, etc.
DELETE FROM Gens_DuPriAn;
DELETE FROM Gens_Rank;
DELETE FROM Gens_Reward;
DELETE FROM Gens_Varnert;
DELETE FROM GremoryCase;
DELETE FROM HelperData;
-- Si la tabla 'Mary' no existe, puedes omitir esta línea
-- DELETE FROM Mary;
DELETE FROM MK_Server;

-- 13. Borra shop/market
DELETE FROM PShopItemValue;

-- 14. Borra usuarios/cuentas (elimina todas, incluidas admin y GM)
DELETE FROM MEMB_INFO;

-- 15. Borra logs y estadísticas de conexiones
DELETE FROM MEMB_STAT;

-- ¡Listo!