找回密碼
 立即註冊
搜索
查看: 87|回復: 1

開新服時清除sql數據

[複製鏈接]

193

主題

107

回帖

1223

積分

管理員

積分
1223
發表於 2025-8-9 18:42:56 | 顯示全部樓層 |閱讀模式
DELETE FROM  `每日道具产出记录`;
DELETE FROM  `william_xuanchuan`;
DELETE FROM  `board`;
DELETE FROM  `letter`;
DELETE FROM  `lottery`;
DELETE FROM  `character_adena_trade`;
DELETE FROM  `character_bless_guaranteed`;
DELETE FROM  `character_buddys`;
DELETE FROM  `character_buff`;
DELETE FROM  `character_config`;
DELETE FROM  `character_convert_guaranteed`;
DELETE FROM  `character_drop_limit`;
DELETE FROM  `character_elf_warehouse`;
DELETE FROM  `character_enchant_guaranteed`;
DELETE FROM  `character_item_log`;
DELETE FROM  `character_items`;
DELETE FROM  `character_make_guaranteed`;
DELETE FROM  `character_maptimer`;
DELETE FROM  `character_nurse_setting`;
DELETE FROM  `character_quests`;
DELETE FROM  `character_redeem_items`;
DELETE FROM  `character_sell_limit`;
DELETE FROM  `character_setings`;
DELETE FROM  `character_shop`;
DELETE FROM  `character_shop_limit`;
DELETE FROM  `character_shop_pice`;
DELETE FROM  `character_shouchang`;
DELETE FROM  `character_skills`;
DELETE FROM  `character_teleport`;
DELETE FROM  `character_trade`;
DELETE FROM  `character_warehouse`;
DELETE FROM  `characters`;
DELETE FROM  `clan_alliance`;
DELETE FROM  `clan_data`;
DELETE FROM  `clan_emblem`;
DELETE FROM  `clan_grade_warehouse`;
DELETE FROM  `clan_warehouse`;
DELETE FROM  `clan_warehouse_history`;
DELETE FROM `race_ticket`;
DELETE FROM `race_ticket_pet`;
DELETE FROM `race_victory_pet`;
DELETE FROM `shop_user`;
DELETE FROM `shop_user_tw`;
DELETE FROM `mail`;
DELETE FROM `accounts`;
DELETE FROM `ban_ip`;
DELETE FROM `ban_mac`;
DELETE FROM `inn_key`;


10

主題

39

回帖

293

積分

中級會員

積分
293
發表於 2025-8-10 15:35:05 | 顯示全部樓層
可以再增加
DELETE FROM `william_value_log`;
您需要登錄後才可以回帖 登錄 | 立即註冊

本版積分規則

Archiver|手機版|小黑屋|天堂技術論壇

GMT+8, 2025-8-31 18:15 , Processed in 0.084689 second(s), 20 queries .

Powered by Discuz! X3.5

© 2001-2025 Discuz! Team.

快速回復 返回頂部 返回列表