TRUNCATE WIPE DATABASE LOUIS V34

[PowerNet]

Esto lo arme en base a los Files Louis, ya que muchos nos complicamos la vida al querer reiniciar todo y no esta todo como queremos.
Espero que les sirva...
Creo que ya todos saben poner la función "TRUNCATE" en nuestro SQL.
Esto se hace siempre haciendo una nueva consulta en el sql.

Code Select Expand

Delete from Character
TRUNCATE TABLE "AccountCharacter"
TRUNCATE TABLE "BlockHardwareID"
TRUNCATE TABLE "BlockIP"
TRUNCATE TABLE "CashLog"
TRUNCATE TABLE "CashShopData"
TRUNCATE TABLE "CashShopInventory"
TRUNCATE TABLE "CashShopPeriodicItem"
TRUNCATE TABLE "CustomAttack"
TRUNCATE TABLE "CustomAttackOffline"
TRUNCATE TABLE "CustomBattlePassData"
TRUNCATE TABLE "CustomBattlePassReward"
TRUNCATE TABLE "CustomCommandDelay"
TRUNCATE TABLE "CustomDailyReward"
TRUNCATE TABLE "CustomFlag"
TRUNCATE TABLE "CustomGift"
TRUNCATE TABLE "CustomItemBank"
TRUNCATE TABLE "CustomJewelBank"
TRUNCATE TABLE "CustomLuckyWheel"
TRUNCATE TABLE "CustomNpcQuest"
TRUNCATE TABLE "CustomQuest"
TRUNCATE TABLE "CustomSkin"
TRUNCATE TABLE "CustomStore"
TRUNCATE TABLE "CustomStoreOffline"
TRUNCATE TABLE "EventAuction"
TRUNCATE TABLE "EventAuctionReward"
TRUNCATE TABLE "EventEntryCount"
TRUNCATE TABLE "EventLeoTheHelper"
TRUNCATE TABLE "EventSantaClaus"
TRUNCATE TABLE "ExtWarehouse"
TRUNCATE TABLE "GameServerInfo"
TRUNCATE TABLE "Gens_Duprian"
TRUNCATE TABLE "Gens_Reward"
TRUNCATE TABLE "Gens_Varnert"
TRUNCATE TABLE "Gens_Rank"
TRUNCATE TABLE "GremoryCase"
TRUNCATE TABLE "Guild"
TRUNCATE TABLE "GuildMember"
TRUNCATE TABLE "HelperData"
TRUNCATE TABLE "ItemLog"
TRUNCATE TABLE "LOG_CREDITOS"
TRUNCATE TABLE "LuckyCoin"
TRUNCATE TABLE "LuckyItem"
TRUNCATE TABLE "Marry"
TRUNCATE TABLE "MasterSkillTree"
TRUNCATE TABLE "MEMB_INFO"
TRUNCATE TABLE "MEMB_STAT"
TRUNCATE TABLE "MK_Server"
TRUNCATE TABLE "OptionData"
TRUNCATE TABLE "PShopItemValue"
TRUNCATE TABLE "QuestKillCount"
TRUNCATE TABLE "QuestWorld"
TRUNCATE TABLE "RankingBattleRoyale"
TRUNCATE TABLE "RankingBloodCastle"
TRUNCATE TABLE "RankingCastleSiegeKills"
TRUNCATE TABLE "RankingCastleSiegeTime"
TRUNCATE TABLE "RankingChaosCastle"
TRUNCATE TABLE "RankingDevilSquare"
TRUNCATE TABLE "RankingDuel"
TRUNCATE TABLE "RankingGvG"
TRUNCATE TABLE "RankingIllusionTemple"
TRUNCATE TABLE "RankingKingGuild"
TRUNCATE TABLE "RankingKingPlayer"
TRUNCATE TABLE "RankingPvpChampionship"
TRUNCATE TABLE "RankingTvT"
TRUNCATE TABLE "T_CGuid"
TRUNCATE TABLE "T_FriendList"
TRUNCATE TABLE "T_FriendMail"
TRUNCATE TABLE "T_FriendMain"
TRUNCATE TABLE "T_PetItem_Info"
TRUNCATE TABLE "T_WaitFriend"
TRUNCATE TABLE "warehouse"
TRUNCATE TABLE "WarehouseGuild"


Créditos: samsunggon