From 8eb1938fe83ec2879b46838c592c8aced4a2ef37 Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 31 Dec 2021 16:01:43 +0100 Subject: DB: Convert all databases to InnoDB engine --- sql/updates/auth/master/2021_12_31_01_auth.sql | 2 + .../characters/master/2021_12_31_00_characters.sql | 126 ++++++++++++ .../characters/master/2021_12_31_01_characters.sql | 2 + .../characters/master/2021_13_31_00_characters.sql | 126 ------------ .../hotfixes/master/2021_12_31_01_hotfixes.sql | 6 + sql/updates/world/master/2021_12_31_10_world.sql | 211 +++++++++++++++++++++ 6 files changed, 347 insertions(+), 126 deletions(-) create mode 100644 sql/updates/auth/master/2021_12_31_01_auth.sql create mode 100644 sql/updates/characters/master/2021_12_31_00_characters.sql create mode 100644 sql/updates/characters/master/2021_12_31_01_characters.sql delete mode 100644 sql/updates/characters/master/2021_13_31_00_characters.sql create mode 100644 sql/updates/hotfixes/master/2021_12_31_01_hotfixes.sql create mode 100644 sql/updates/world/master/2021_12_31_10_world.sql (limited to 'sql/updates') diff --git a/sql/updates/auth/master/2021_12_31_01_auth.sql b/sql/updates/auth/master/2021_12_31_01_auth.sql new file mode 100644 index 00000000000..c1cca3f8c7d --- /dev/null +++ b/sql/updates/auth/master/2021_12_31_01_auth.sql @@ -0,0 +1,2 @@ +ALTER TABLE updates ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE updates_include ENGINE=InnoDB ROW_FORMAT=DEFAULT; diff --git a/sql/updates/characters/master/2021_12_31_00_characters.sql b/sql/updates/characters/master/2021_12_31_00_characters.sql new file mode 100644 index 00000000000..ba5c2057929 --- /dev/null +++ b/sql/updates/characters/master/2021_12_31_00_characters.sql @@ -0,0 +1,126 @@ +ALTER TABLE account_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE account_instance_times CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE account_tutorial CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE arena_team CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE arena_team_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE auction_bidders CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE auction_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE auctionhouse CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE blackmarket_auctions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE bugreport CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE calendar_events CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE calendar_invites CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE channels CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_account_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_achievement CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_achievement_progress CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_action CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_arena_stats CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_aura CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_aura_effect CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_aura_stored_location CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_banned CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_battleground_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_battleground_random CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_cuf_profiles CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_currency CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_customizations CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_declinedname CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_equipmentsets CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_favorite_auctions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_fishingsteps CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_garrison CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_garrison_blueprints CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_garrison_buildings CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_garrison_follower_abilities CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_garrison_followers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_gifts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_glyphs CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_homebind CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_instance CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_inventory CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_pet CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_pet_declinedname CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_pvp_talent CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_queststatus CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_queststatus_daily CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_queststatus_monthly CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_queststatus_objectives CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_queststatus_objectives_criteria CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_queststatus_objectives_criteria_progress CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_queststatus_rewarded CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_queststatus_seasonal CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_queststatus_weekly CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_reputation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_skills CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_social CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_spell CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_spell_charges CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_spell_cooldown CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_stats CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_talent CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_transmog_outfits CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE character_void_storage CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE characters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE characters MODIFY `name` varchar(12) NOT NULL; +ALTER TABLE corpse CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE corpse_customizations CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE corpse_phases CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE game_event_condition_save CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE game_event_save CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE gm_bug CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE gm_complaint CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE gm_complaint_chatlog CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE gm_suggestion CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE group_instance CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE group_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `groups` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE guild CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE guild_achievement CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE guild_achievement_progress CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE guild_bank_eventlog CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE guild_bank_item CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE guild_bank_right CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE guild_bank_tab CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE guild_eventlog CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE guild_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE guild_member_withdraw CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE guild_newslog CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE guild_rank CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE instance CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE instance_reset CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE instance_scenario_progress CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_instance CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_instance_artifact CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_instance_artifact_powers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_instance_azerite CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_instance_azerite_empowered CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_instance_azerite_milestone_power CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_instance_azerite_unlocked_essence CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_instance_gems CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_instance_modifiers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_instance_transmog CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_loot_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_loot_money CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_refund_instance CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE item_soulbound_trade_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE lfg_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE mail CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE mail_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE pet_aura CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE pet_aura_effect CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE pet_spell CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE pet_spell_charges CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE pet_spell_cooldown CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE petition CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE petition_sign CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE pool_quest_save CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE pvpstats_battlegrounds CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE pvpstats_players CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE quest_tracker CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE reserved_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE respawn CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE updates CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE updates_include CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE warden_action CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE worldstates CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; diff --git a/sql/updates/characters/master/2021_12_31_01_characters.sql b/sql/updates/characters/master/2021_12_31_01_characters.sql new file mode 100644 index 00000000000..c1cca3f8c7d --- /dev/null +++ b/sql/updates/characters/master/2021_12_31_01_characters.sql @@ -0,0 +1,2 @@ +ALTER TABLE updates ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE updates_include ENGINE=InnoDB ROW_FORMAT=DEFAULT; diff --git a/sql/updates/characters/master/2021_13_31_00_characters.sql b/sql/updates/characters/master/2021_13_31_00_characters.sql deleted file mode 100644 index ba5c2057929..00000000000 --- a/sql/updates/characters/master/2021_13_31_00_characters.sql +++ /dev/null @@ -1,126 +0,0 @@ -ALTER TABLE account_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE account_instance_times CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE account_tutorial CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE arena_team CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE arena_team_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE auction_bidders CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE auction_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE auctionhouse CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE blackmarket_auctions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE bugreport CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE calendar_events CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE calendar_invites CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE channels CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_account_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_achievement CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_achievement_progress CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_action CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_arena_stats CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_aura CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_aura_effect CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_aura_stored_location CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_banned CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_battleground_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_battleground_random CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_cuf_profiles CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_currency CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_customizations CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_declinedname CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_equipmentsets CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_favorite_auctions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_fishingsteps CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_garrison CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_garrison_blueprints CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_garrison_buildings CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_garrison_follower_abilities CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_garrison_followers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_gifts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_glyphs CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_homebind CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_instance CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_inventory CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_pet CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_pet_declinedname CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_pvp_talent CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_queststatus CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_queststatus_daily CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_queststatus_monthly CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_queststatus_objectives CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_queststatus_objectives_criteria CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_queststatus_objectives_criteria_progress CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_queststatus_rewarded CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_queststatus_seasonal CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_queststatus_weekly CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_reputation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_skills CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_social CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_spell CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_spell_charges CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_spell_cooldown CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_stats CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_talent CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_transmog_outfits CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE character_void_storage CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE characters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE characters MODIFY `name` varchar(12) NOT NULL; -ALTER TABLE corpse CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE corpse_customizations CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE corpse_phases CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE game_event_condition_save CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE game_event_save CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE gm_bug CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE gm_complaint CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE gm_complaint_chatlog CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE gm_suggestion CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE group_instance CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE group_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `groups` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE guild CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE guild_achievement CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE guild_achievement_progress CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE guild_bank_eventlog CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE guild_bank_item CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE guild_bank_right CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE guild_bank_tab CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE guild_eventlog CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE guild_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE guild_member_withdraw CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE guild_newslog CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE guild_rank CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE instance CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE instance_reset CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE instance_scenario_progress CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_instance CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_instance_artifact CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_instance_artifact_powers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_instance_azerite CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_instance_azerite_empowered CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_instance_azerite_milestone_power CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_instance_azerite_unlocked_essence CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_instance_gems CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_instance_modifiers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_instance_transmog CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_loot_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_loot_money CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_refund_instance CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE item_soulbound_trade_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE lfg_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE mail CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE mail_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE pet_aura CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE pet_aura_effect CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE pet_spell CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE pet_spell_charges CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE pet_spell_cooldown CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE petition CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE petition_sign CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE pool_quest_save CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE pvpstats_battlegrounds CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE pvpstats_players CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE quest_tracker CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE reserved_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE respawn CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE updates CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE updates_include CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE warden_action CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE worldstates CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; diff --git a/sql/updates/hotfixes/master/2021_12_31_01_hotfixes.sql b/sql/updates/hotfixes/master/2021_12_31_01_hotfixes.sql new file mode 100644 index 00000000000..35a48ee7ff4 --- /dev/null +++ b/sql/updates/hotfixes/master/2021_12_31_01_hotfixes.sql @@ -0,0 +1,6 @@ +ALTER TABLE creature ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_difficulty ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE hotfix_blob ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE hotfix_data ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE updates ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE updates_include ENGINE=InnoDB ROW_FORMAT=DEFAULT; diff --git a/sql/updates/world/master/2021_12_31_10_world.sql b/sql/updates/world/master/2021_12_31_10_world.sql new file mode 100644 index 00000000000..26a2bbd1712 --- /dev/null +++ b/sql/updates/world/master/2021_12_31_10_world.sql @@ -0,0 +1,211 @@ +ALTER TABLE achievement_reward_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE areatrigger ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE areatrigger_create_properties ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE areatrigger_create_properties_polygon_vertex ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE areatrigger_create_properties_spline_point ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE areatrigger_involvedrelation ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE areatrigger_scripts ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE areatrigger_tavern ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE areatrigger_teleport ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE areatrigger_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE areatrigger_template_actions ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE battleground_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE battlemaster_entry ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE blackmarket_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE character_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE character_template_class ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE class_expansion_requirement ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE command ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE conditions ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE conversation_actors ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE conversation_line_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE conversation_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_addon ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_classlevelstats ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_equip_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_formations ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_loot_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_model_info ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_movement_override ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_onkill_reputation ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_questender ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_questitem ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_queststarter ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_summon_groups ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_template_addon ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_template_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_template_model ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_template_movement ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_text ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_text_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE creature_trainer ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE criteria_data ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE disables ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE disenchant_loot_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE event_scripts ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE exploration_basexp ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE fishing_loot_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_arena_seasons ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_battleground_holiday ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_condition ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_creature ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_creature_quest ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_gameobject ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_gameobject_quest ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_model_equip ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_npc_vendor ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_npcflag ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_pool ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_prerequisite ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_quest_condition ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_event_seasonal_questrelation ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_tele ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE game_weather ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gameobject ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gameobject_addon ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gameobject_loot_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gameobject_overrides ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gameobject_questender ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gameobject_questitem ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gameobject_queststarter ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gameobject_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gameobject_template_addon ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gameobject_template_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE garrison_follower_class_spec_abilities ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE garrison_plot_finalize_info ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gossip_menu ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gossip_menu_option ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gossip_menu_option_action ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gossip_menu_option_box ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE gossip_menu_option_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE graveyard_zone ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE guild_rewards ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE guild_rewards_req_achievements ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE instance_encounters ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE instance_spawn_groups ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE instance_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE item_loot_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE item_random_bonus_list_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE item_script_names ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE item_template_addon ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE jump_charge_params ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE lfg_dungeon_rewards ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE lfg_dungeon_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE linked_respawn ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE mail_level_reward ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE mail_loot_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE milling_loot_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE mount_definitions ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE npc_spellclick_spells ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE npc_text ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE npc_vendor ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE outdoorpvp_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE page_text ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE page_text_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE pet_levelstats ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE pet_name_generation ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE phase_area ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE phase_name ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE pickpocketing_loot_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE player_classlevelstats ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE player_factionchange_achievement ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE player_factionchange_quests ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE player_factionchange_reputations ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE player_factionchange_spells ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE player_factionchange_titles ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE player_racestats ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE player_xp_for_level ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playerchoice ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playerchoice_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playerchoice_response ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playerchoice_response_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playerchoice_response_maw_power ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playerchoice_response_reward ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playerchoice_response_reward_currency ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playerchoice_response_reward_faction ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playerchoice_response_reward_item ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playerchoice_response_reward_item_choice ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playercreateinfo ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playercreateinfo_action ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playercreateinfo_cast_spell ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playercreateinfo_item ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE playercreateinfo_spell_custom ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE points_of_interest ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE points_of_interest_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE pool_members ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE pool_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE prospecting_loot_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_details ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_greeting ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_greeting_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_objectives ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_objectives_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_offer_reward ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_poi ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_poi_points ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_pool_members ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_pool_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_request_items ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_reward_choice_items ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_reward_display_spell ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_template_addon ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_template_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE quest_visual_effect ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE race_unlock_requirement ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE reference_loot_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE reputation_reward_rate ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE reputation_spillover_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE scenario_poi ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE scenario_poi_points ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE scenarios ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE scene_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE script_waypoint ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE serverside_spell ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE serverside_spell_effect ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE skill_discovery_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE skill_extra_item_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE skill_fishing_base_level ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE skill_perfect_item_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE skill_tiers ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE skinning_loot_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE smart_scripts ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spawn_group ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spawn_group_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_area ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_custom_attr ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_enchant_proc_data ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_group ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_group_stack_rules ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_learn_spell ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_linked_spell ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_loot_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_pet_auras ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_proc ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_required ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_script_names ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_scripts ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_target_position ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_threat ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE spell_totem_model ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE terrain_swap_defaults ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE terrain_worldmap ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE trainer ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE trainer_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE trainer_spell ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE transports ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE trinity_string ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE updates ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE updates_include ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE vehicle_accessory ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE vehicle_template ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE vehicle_template_accessory ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE version ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE warden_checks ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE waypoint_data ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE waypoint_scripts ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE waypoints ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE world_safe_locs ENGINE=InnoDB ROW_FORMAT=DEFAULT; -- cgit v1.2.3