魔兽世界AZ端MySQL数据库查询清理开服命令

-- 完整的 acore_auth 清理脚本
USE acore_auth;

-- 关闭外键约束
SET FOREIGN_KEY_CHECKS = 0;

-- 清除所有账号相关数据
DELETE FROM account_banned;
DELETE FROM account_muted;
DELETE FROM account_access;
DELETE FROM secret_digest;
DELETE FROM realmcharacters;
DELETE FROM account;

-- 重置自增ID
ALTER TABLE account AUTO_INCREMENT = 1;
ALTER TABLE account_access AUTO_INCREMENT = 1;
ALTER TABLE account_banned AUTO_INCREMENT = 1;
ALTER TABLE account_muted AUTO_INCREMENT = 1;

-- 恢复外键约束
SET FOREIGN_KEY_CHECKS = 1;

-- 验证清理结果
SELECT COUNT(*) FROM account;
SELECT COUNT(*) FROM account_access;

-- 完整的 acore_characters 清理脚本
USE acore_characters;

-- 关闭外键约束
SET FOREIGN_KEY_CHECKS = 0;

-- 1. 清除社交和团队相关数据
DELETE FROM guild_bank_item;
DELETE FROM guild_bank_log;
DELETE FROM guild_bank_tab;
DELETE FROM guild_eventlog;
DELETE FROM guild_member;
DELETE FROM guild_rank;
DELETE FROM guild;

DELETE FROM arena_team_member;
DELETE FROM arena_team_stats;
DELETE FROM arena_team;

-- 2. 清除交易和邮件数据
DELETE FROM mail_items;
DELETE FROM mail;
DELETE FROM auctionhouse;
DELETE FROM item_instance;

-- 3. 清除角色扩展数据
DELETE FROM character_achievement_offline_updates;
DELETE FROM character_achievement;
DELETE FROM character_account_data;
DELETE FROM character_armory_stats;
DELETE FROM character_battleground_data;
DELETE FROM character_battleground_stats;
DELETE FROM character_homebind;
DELETE FROM character_instance;
DELETE FROM character_inventory;
DELETE FROM character_pet;
DELETE FROM character_queststatus_rewarded;
DELETE FROM character_queststatus;
DELETE FROM character_reputation;
DELETE FROM character_skills;
DELETE FROM character_social;
DELETE FROM character_spell_cooldown;
DELETE FROM character_spell;
DELETE FROM character_stats;
DELETE FROM character_talent;
DELETE FROM character_titles;
DELETE FROM character_voidstorage;
DELETE FROM character_archaeology_project;
DELETE FROM character_archaeology_artifact;

-- 4. 清除核心角色数据
DELETE FROM characters;

-- 5. 清除账号相关角色数据
DELETE FROM account_instance_times;
DELETE FROM account_data;
DELETE FROM account_tutorial;

-- 6. 清除其他辅助数据
DELETE FROM addons;
DELETE FROM bugreport;
DELETE FROM battleground_deserters;
DELETE FROM calendar_invites;
DELETE FROM calendar_events;
DELETE FROM channels_rights;
DELETE FROM channels_bans;
DELETE FROM channels;

-- 7. 重置自增ID
ALTER TABLE characters AUTO_INCREMENT = 1;
ALTER TABLE guild AUTO_INCREMENT = 1;
ALTER TABLE arena_team AUTO_INCREMENT = 1;
ALTER TABLE mail AUTO_INCREMENT = 1;
ALTER TABLE auctionhouse AUTO_INCREMENT = 1;
ALTER TABLE item_instance AUTO_INCREMENT = 1;

-- 恢复外键约束
SET FOREIGN_KEY_CHECKS = 1;

-- 验证清理结果
SELECT COUNT(*) FROM characters;
SELECT COUNT(*) FROM guild;
SELECT COUNT(*) FROM arena_team;

注意事项

1. 备份数据 ：在执行清除命令前，务必先备份整个数据库

2. 外键约束 ：清除数据时必须先关闭外键约束，否则会因关联关系导致清除失败

3. 清除顺序 ：建议按照从依赖表到被依赖表的顺序清除，避免数据残留

4. 重置自增ID ：清除数据后，建议重置自增ID，让新角色从ID=1开始

5. 谨慎操作 ：清除命令不可逆，务必确认后再执行

6. 测试环境 ：建议先在测试环境中测试清除脚本，确认无误后再在生产环境执行

7. 账号关联 ：清除角色数据后，建议同时清理对应的认证数据库中的账号数据，保持数据一致性

部分表说明

characters 核心角色表，存储角色的基本信息

character_inventory 角色背包和装备

character_queststatus 角色任务状态

character_skills 角色技能

character_spell 角色法术

guild 公会信息

arena_team 竞技场队伍

mail 邮件系统

auctionhouse 拍卖行