DB/Misc: Ported world db engine and column updates from master branch

Closes #28431

1 files changed, 709 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2022_11_05_02_world.sql b/sql/updates/world/3.3.5/2022_11_05_02_world.sql
new file mode 100644
index 00000000000..bd90c3bda97
--- /dev/null
+++ b/sql/updates/world/3.3.5/2022_11_05_02_world.sql
@@ -0,0 +1,709 @@
+-- 
+ALTER TABLE `access_requirement` MODIFY `completed_achievement` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `access_requirement` MODIFY `item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `access_requirement` MODIFY `item2` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `access_requirement` MODIFY `mapId` int(10) unsigned NOT NULL;
+ALTER TABLE `access_requirement` MODIFY `quest_done_A` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `access_requirement` MODIFY `quest_done_H` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `achievement_criteria_data` MODIFY `value1` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `achievement_criteria_data` MODIFY `value2` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `achievement_reward` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `achievement_reward` MODIFY `ItemID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `achievement_reward` MODIFY `MailTemplateID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `achievement_reward` MODIFY `Sender` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `achievement_reward` MODIFY `TitleA` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `achievement_reward` MODIFY `TitleH` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `achievement_reward_locale` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `areatrigger_involvedrelation` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier';
+ALTER TABLE `areatrigger_involvedrelation` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier';
+ALTER TABLE `areatrigger_tavern` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier';
+ALTER TABLE `areatrigger_teleport` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `battleground_template` MODIFY `AllianceStartLoc` int(10) unsigned NOT NULL;
+ALTER TABLE `battleground_template` MODIFY `HordeStartLoc` int(10) unsigned NOT NULL;
+ALTER TABLE `battleground_template` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `battlemaster_entry` MODIFY `bg_template` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Battleground template id';
+ALTER TABLE `battlemaster_entry` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of a creature';
+ALTER TABLE `broadcast_text` MODIFY `EmoteDelay1` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `broadcast_text` MODIFY `EmoteDelay2` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `broadcast_text` MODIFY `EmoteDelay3` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `broadcast_text` MODIFY `EmoteID1` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `broadcast_text` MODIFY `EmoteID2` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `broadcast_text` MODIFY `EmoteID3` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `broadcast_text` MODIFY `EmotesID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `broadcast_text` MODIFY `Flags` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `broadcast_text` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `broadcast_text` MODIFY `LanguageID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `broadcast_text` MODIFY `SoundEntriesID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `broadcast_text_locale` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `conditions` MODIFY `ConditionValue1` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `conditions` MODIFY `ConditionValue2` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `conditions` MODIFY `ConditionValue3` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `conditions` MODIFY `ElseGroup` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `conditions` MODIFY `ErrorTextId` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `conditions` MODIFY `ErrorType` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `conditions` MODIFY `SourceGroup` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature` MODIFY `currentwaypoint` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier';
+ALTER TABLE `creature` MODIFY `modelid` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_addon` MODIFY `mount` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_equip_template` MODIFY `CreatureID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_equip_template` MODIFY `ItemID1` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_equip_template` MODIFY `ItemID2` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_equip_template` MODIFY `ItemID3` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_model_info` MODIFY `DisplayID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_model_info` MODIFY `DisplayID_Other_Gender` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_onkill_reputation` MODIFY `creature_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier';
+ALTER TABLE `creature_questender` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier';
+ALTER TABLE `creature_questender` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier';
+ALTER TABLE `creature_queststarter` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier';
+ALTER TABLE `creature_queststarter` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier';
+ALTER TABLE `creature_summon_groups` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_summon_groups` MODIFY `summonerId` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `difficulty_entry_1` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `difficulty_entry_2` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `difficulty_entry_3` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `gossip_menu_id` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `lootid` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `maxgold` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `mingold` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `modelid1` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `modelid2` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `modelid3` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `modelid4` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `PetSpellDataId` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `pickpocketloot` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `skinloot` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template` MODIFY `VehicleId` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template_addon` MODIFY `emote` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template_addon` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template_addon` MODIFY `mount` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template_locale` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_template_resistance` MODIFY `CreatureID` int(10) unsigned NOT NULL;
+ALTER TABLE `creature_template_spell` MODIFY `CreatureID` int(10) unsigned NOT NULL;
+ALTER TABLE `creature_template_spell` MODIFY `Spell` int(10) unsigned NOT NULL;
+ALTER TABLE `creature_text` MODIFY `CreatureID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_text` MODIFY `Duration` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_text` MODIFY `Emote` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_text` MODIFY `Sound` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `creature_text_locale` MODIFY `CreatureID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `disenchant_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `disenchant_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `disenchant_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `event_scripts` MODIFY `command` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `event_scripts` MODIFY `datalong` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `event_scripts` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `fishing_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `fishing_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `fishing_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event` MODIFY `holiday` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id';
+ALTER TABLE `game_event_condition` MODIFY `condition_id` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_creature_quest` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_creature_quest` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_gameobject_quest` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_gameobject_quest` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_model_equip` MODIFY `modelid` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_npc_vendor` MODIFY `ExtendedCost` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_npc_vendor` MODIFY `guid` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_npc_vendor` MODIFY `incrtime` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_npc_vendor` MODIFY `item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_npc_vendor` MODIFY `maxcount` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_npcflag` MODIFY `guid` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_pool` MODIFY `pool_entry` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Id of the pool';
+ALTER TABLE `game_event_prerequisite` MODIFY `prerequisite_event` int(10) unsigned NOT NULL;
+ALTER TABLE `game_event_quest_condition` MODIFY `condition_id` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_quest_condition` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `game_event_seasonal_questrelation` MODIFY `eventEntry` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of the game event';
+ALTER TABLE `game_tele` MODIFY `id` int(10) unsigned NOT NULL;
+ALTER TABLE `game_weather` MODIFY `zone` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Gameobject Identifier';
+ALTER TABLE `gameobject_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_questender` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_questender` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier';
+ALTER TABLE `gameobject_queststarter` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_queststarter` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier';
+ALTER TABLE `gameobject_template` MODIFY `displayId` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_template` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_template_addon` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_template_addon` MODIFY `maxgold` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_template_addon` MODIFY `mingold` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gameobject_template_locale` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gossip_menu` MODIFY `TextID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gossip_menu_option` MODIFY `ActionPoiID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `gossip_menu_option` MODIFY `OptionIcon` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `graveyard_zone` MODIFY `GhostZone` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `graveyard_zone` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_enchantment_template` MODIFY `ench` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_enchantment_template` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_set_names` MODIFY `entry` int(10) unsigned NOT NULL;
+ALTER TABLE `item_set_names_locale` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `area` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `block` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `DisenchantID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `displayid` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `itemset` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `lockid` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `PageText` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `RandomSuffix` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `RequiredCityRank` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `requiredhonorrank` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `requiredspell` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `startquest` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_template_locale` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `mail_level_reward` MODIFY `mailTemplateId` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `mail_level_reward` MODIFY `raceMask` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `mail_level_reward` MODIFY `senderEntry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `mail_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `mail_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `mail_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `milling_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `milling_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `milling_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `npc_text` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `npc_text_locale` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `npc_vendor` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `npc_vendor` MODIFY `ExtendedCost` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `page_text` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `page_text` MODIFY `NextPageID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `page_text_locale` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `pet_levelstats` MODIFY `creature_entry` int(10) unsigned NOT NULL;
+ALTER TABLE `pet_name_generation` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `pet_name_generation` MODIFY `id` int(10) unsigned NOT NULL;
+ALTER TABLE `pickpocketing_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `pickpocketing_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `pickpocketing_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `playercreateinfo` MODIFY `zone` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `playercreateinfo_cast_spell` MODIFY `spell` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `playercreateinfo_item` MODIFY `itemid` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `playercreateinfo_spell_custom` MODIFY `Spell` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `points_of_interest` MODIFY `Flags` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `points_of_interest` MODIFY `Icon` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `points_of_interest` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `points_of_interest` MODIFY `Importance` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `points_of_interest_locale` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `pool_template` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Pool entry';
+ALTER TABLE `prospecting_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `prospecting_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `prospecting_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_details` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_greeting` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_greeting_locale` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_offer_reward` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_pool_template` MODIFY `poolId` int(10) unsigned NOT NULL;
+ALTER TABLE `quest_request_items` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `ItemDrop1` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `ItemDrop2` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `ItemDrop3` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `ItemDrop4` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `POIPriority` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RequiredItemId1` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RequiredItemId2` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RequiredItemId3` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RequiredItemId4` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RequiredItemId5` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RequiredItemId6` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardChoiceItemID1` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardChoiceItemID2` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardChoiceItemID3` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardChoiceItemID4` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardChoiceItemID5` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardChoiceItemID6` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardDisplaySpell` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardItem1` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardItem2` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardItem3` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardItem4` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardNextQuest` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `StartItem` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template_addon` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template_addon` MODIFY `NextQuestID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template_addon` MODIFY `RewardMailTemplateID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template_addon` MODIFY `SourceSpellID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template_locale` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `reference_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `reference_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `reference_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `reputation_reward_rate` MODIFY `faction` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `script_waypoint` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry';
+ALTER TABLE `script_waypoint` MODIFY `pointid` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `skill_discovery_template` MODIFY `reqSpell` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'spell requirement';
+ALTER TABLE `skill_discovery_template` MODIFY `spellId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the discoverable spell';
+ALTER TABLE `skill_extra_item_template` MODIFY `requiredSpecialization` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id';
+ALTER TABLE `skill_extra_item_template` MODIFY `spellId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell';
+ALTER TABLE `skill_fishing_base_level` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Area identifier';
+ALTER TABLE `skill_perfect_item_template` MODIFY `perfectItemType` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'perfect item type to create instead';
+ALTER TABLE `skill_perfect_item_template` MODIFY `requiredSpecialization` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id';
+ALTER TABLE `skill_perfect_item_template` MODIFY `spellId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell';
+ALTER TABLE `skinning_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `skinning_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `skinning_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `spell_area` MODIFY `area` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `spell_area` MODIFY `quest_end` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `spell_area` MODIFY `quest_start` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `spell_area` MODIFY `racemask` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `spell_area` MODIFY `spell` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `spell_bonus_data` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `spell_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `spell_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `spell_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `spell_pet_auras` MODIFY `aura` int(10) unsigned NOT NULL COMMENT 'pet aura id';
+ALTER TABLE `spell_pet_auras` MODIFY `pet` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pet id; 0 = all';
+ALTER TABLE `spell_pet_auras` MODIFY `spell` int(10) unsigned NOT NULL COMMENT 'dummy spell id';
+ALTER TABLE `spell_scripts` MODIFY `command` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `spell_scripts` MODIFY `datalong` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `spell_scripts` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `spell_target_position` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier';
+ALTER TABLE `spell_threat` MODIFY `entry` int(10) unsigned NOT NULL;
+ALTER TABLE `trainer` MODIFY `Requirement` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `transports` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `trinity_string` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `vehicle_accessory` MODIFY `accessory_entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `vehicle_accessory` MODIFY `guid` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `vehicle_template_accessory` MODIFY `accessory_entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `vehicle_template_accessory` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `waypoint_data` MODIFY `point` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `waypoints` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `waypoints` MODIFY `pointid` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `achievement_criteria_data` MODIFY `criteria_id` int(11) NOT NULL;
+ALTER TABLE `areatrigger_scripts` MODIFY `entry` int(11) NOT NULL;
+ALTER TABLE `conditions` MODIFY `ConditionTypeOrReference` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `conditions` MODIFY `SourceEntry` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `conditions` MODIFY `SourceTypeOrReferenceId` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `creature_onkill_reputation` MODIFY `RewOnKillRepValue1` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `creature_onkill_reputation` MODIFY `RewOnKillRepValue2` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `creature_text` MODIFY `BroadcastTextId` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `exploration_basexp` MODIFY `basexp` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `gossip_menu_option` MODIFY `BoxBroadcastTextID` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `gossip_menu_option` MODIFY `OptionBroadcastTextID` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `BagFamily` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `GemProperties` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `RandomProperty` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `socketBonus` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `socketContent_1` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `socketContent_2` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `socketContent_3` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `spellid_1` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `spellid_2` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `spellid_3` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `spellid_4` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `spellid_5` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `item_template` MODIFY `TotemCategory` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `npc_text` MODIFY `BroadcastTextID0` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `npc_text` MODIFY `BroadcastTextID1` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `npc_text` MODIFY `BroadcastTextID2` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `npc_text` MODIFY `BroadcastTextID3` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `npc_text` MODIFY `BroadcastTextID4` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `npc_text` MODIFY `BroadcastTextID5` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `npc_text` MODIFY `BroadcastTextID6` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `npc_text` MODIFY `BroadcastTextID7` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `npc_vendor` MODIFY `item` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RequiredFactionValue1` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RequiredFactionValue2` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RequiredNpcOrGo1` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RequiredNpcOrGo2` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RequiredNpcOrGo3` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RequiredNpcOrGo4` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardFactionOverride1` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardFactionOverride2` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardFactionOverride3` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardFactionOverride4` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardFactionOverride5` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardFactionValue1` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardFactionValue2` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardFactionValue3` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardFactionValue4` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` MODIFY `RewardFactionValue5` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template_addon` MODIFY `BreadcrumbForQuestId` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template_addon` MODIFY `ExclusiveGroup` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template_addon` MODIFY `PrevQuestID` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template_addon` MODIFY `RequiredMaxRepValue` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template_addon` MODIFY `RequiredMinRepValue` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `spell_area` MODIFY `aura_spell` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `spell_linked_spell` MODIFY `spell_effect` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `spell_linked_spell` MODIFY `spell_trigger` int(11) NOT NULL;
+ALTER TABLE `spell_required` MODIFY `req_spell` int(11) NOT NULL DEFAULT '0';
+ALTER TABLE `spell_required` MODIFY `spell_id` int(11) NOT NULL DEFAULT '0';
+-- 
+ALTER TABLE access_requirement ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE achievement_criteria_data ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE achievement_dbc ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE achievement_reward ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE achievement_reward_locale 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 battlefield_template 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 broadcast_text ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE broadcast_text_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE command ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE conditions 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_default_trainer 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_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_movement ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE creature_template_resistance ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE creature_template_spell 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 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 gossip_menu ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE gossip_menu_option 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 holiday_dates 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_enchantment_template ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE item_loot_template ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE item_set_names ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE item_set_names_locale ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE item_template ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE item_template_locale 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 npc_spellclick_spells ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE npc_text ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE npc_text_locale 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 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_items 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_levelstats ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE player_totem_model ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE player_xp_for_level 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_skills 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_mail_sender ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE quest_offer_reward ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE quest_offer_reward_locale 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_request_items_locale 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 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 script_spline_chain_meta ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE script_spline_chain_waypoints ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE script_waypoint 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 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_bonus_data ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE spell_custom_attr ENGINE=InnoDB ROW_FORMAT=DEFAULT;
+ALTER TABLE spell_dbc 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_ranks 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 spelldifficulty_dbc 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_seat_addon 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 access_requirement CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE achievement_criteria_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE achievement_dbc CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE achievement_reward CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE achievement_reward_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE areatrigger_involvedrelation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE areatrigger_scripts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE areatrigger_tavern CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE areatrigger_teleport CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE battlefield_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE battleground_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE battlemaster_entry CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE broadcast_text CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE broadcast_text_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE command CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE conditions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; 
+ALTER TABLE creature_addon CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_classlevelstats CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_default_trainer CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_equip_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_formations CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_loot_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_model_info CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_movement_info CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_movement_override CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_onkill_reputation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_questender CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_questitem CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_queststarter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_summon_groups CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_template_addon CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_template_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_template_movement CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_template_resistance CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_template_spell CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_text CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE creature_text_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE disables CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; 
+ALTER TABLE disenchant_loot_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE event_scripts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE exploration_basexp CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE fishing_loot_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_arena_seasons CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_battleground_holiday CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_condition CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_creature CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_creature_quest CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_gameobject CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_gameobject_quest CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_model_equip CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_npc_vendor CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_npcflag CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_pool CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_prerequisite CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_quest_condition CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_event_seasonal_questrelation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_tele CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE game_weather CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE gameobject CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE gameobject_addon CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE gameobject_loot_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE gameobject_overrides CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE gameobject_questender CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE gameobject_questitem CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE gameobject_queststarter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE gameobject_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE gameobject_template_addon CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE gameobject_template_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE gossip_menu CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE gossip_menu_option CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE gossip_menu_option_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE graveyard_zone CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE holiday_dates CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE instance_encounters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE instance_spawn_groups CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE instance_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE item_enchantment_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE item_loot_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE item_set_names CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE item_set_names_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE item_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE item_template_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE lfg_dungeon_rewards CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE lfg_dungeon_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE linked_respawn CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE mail_level_reward CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE mail_loot_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE milling_loot_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE npc_spellclick_spells CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE npc_text CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; 
+ALTER TABLE npc_text_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE npc_vendor CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE outdoorpvp_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE page_text CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE page_text_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE pet_levelstats CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE pet_name_generation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE pickpocketing_loot_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE player_classlevelstats CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE player_factionchange_achievement CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE player_factionchange_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE player_factionchange_quests CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE player_factionchange_reputations CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE player_factionchange_spells CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE player_factionchange_titles CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE player_levelstats CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE player_totem_model CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE player_xp_for_level CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE playercreateinfo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE playercreateinfo_action CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE playercreateinfo_cast_spell CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE playercreateinfo_item CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE playercreateinfo_skills CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE playercreateinfo_spell_custom CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE points_of_interest CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE points_of_interest_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE pool_members CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE pool_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE prospecting_loot_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_details CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_greeting CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_greeting_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_mail_sender CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_offer_reward CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_offer_reward_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_poi CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_poi_points CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_pool_members CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_pool_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_request_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_request_items_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_template_addon CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE quest_template_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE reference_loot_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE reputation_reward_rate CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE reputation_spillover_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE script_spline_chain_meta CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE script_spline_chain_waypoints CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE script_waypoint CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE skill_discovery_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE skill_extra_item_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE skill_fishing_base_level CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE skill_perfect_item_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE skinning_loot_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE smart_scripts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spawn_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spawn_group_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_area CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_bonus_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_custom_attr CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_dbc CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_enchant_proc_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_group_stack_rules CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_learn_spell CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_linked_spell CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_loot_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_pet_auras CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_proc CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_ranks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_required CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_script_names CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_scripts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_target_position CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spell_threat CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE spelldifficulty_dbc CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE trainer CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE trainer_locale CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE trainer_spell CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE transports CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE trinity_string 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 vehicle_accessory CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE vehicle_seat_addon CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE vehicle_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE vehicle_template_accessory CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE `version` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE warden_checks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE waypoint_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE waypoint_scripts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE waypoints CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;