admin
acore_auth表
-- 完整的 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表
-- 完整的 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 拍卖行