From 80884e32ef6e79b6de66fe02a16b0546282f75bb Mon Sep 17 00:00:00 2001 From: TDB Release Date: Mon, 16 Jan 2023 11:10:56 +0000 Subject: TDB 335.23011 - 2023/01/16 --- sql/base/auth_database.sql | 9 +- sql/base/characters_database.sql | 9 +- sql/base/dev/world_database.sql | 1468 +++++++++++++++++++------------------- 3 files changed, 747 insertions(+), 739 deletions(-) (limited to 'sql/base') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index d14a8d60d2f..526a7e48d3c 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.30, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.31, for Linux (x86_64) -- -- Host: localhost Database: auth -- ------------------------------------------------------ --- Server version 8.0.30-0ubuntu0.20.04.2 +-- Server version 8.0.31-0ubuntu0.20.04.2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -2003,7 +2003,8 @@ INSERT INTO `updates` VALUES ('2022_04_14_00_auth.sql','B1ED102EB7C9A2A0BDA866201960E70CCCA22FB5','ARCHIVED','2022-04-14 16:24:35',0), ('2022_06_01_00_auth.sql','351FA0BEE4F99B4EF451D0B1B6D822376DE4C26C','ARCHIVED','2022-06-01 10:50:50',0), ('2022_08_15_00_auth.sql','9EED4B445CAEC5337879206849A5C194872F228D','ARCHIVED','2022-08-15 11:21:17',0), -('2022_10_17_00_auth.sql','EB711C5B9B3272A05DDF47CA998F87E5DE6DE238','ARCHIVED','2022-10-17 09:02:28',0); +('2022_10_17_00_auth.sql','EB711C5B9B3272A05DDF47CA998F87E5DE6DE238','ARCHIVED','2022-10-17 09:02:28',0), +('2023_01_16_00_auth.sql','8431F03DE6A036BEED6682C21F4B67F384390905','ARCHIVED','2023-01-16 11:06:30',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2142,4 +2143,4 @@ SET character_set_client = @saved_cs_client; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-10-17 9:02:31 +-- Dump completed on 2023-01-16 11:08:17 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 7fda6da21ee..f5955382dc4 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.30, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.31, for Linux (x86_64) -- -- Host: localhost Database: characters -- ------------------------------------------------------ --- Server version 8.0.30-0ubuntu0.20.04.2 +-- Server version 8.0.31-0ubuntu0.20.04.2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -2676,7 +2676,8 @@ INSERT INTO `updates` VALUES ('2022_04_14_00_characters.sql','FFFF611BE95F047CD853701136452BF8D28C3130','ARCHIVED','2022-04-14 16:24:35',0), ('2022_06_01_00_characters.sql','F33CA4F6F0A685CE1F42F0106269F3C39E31F1B0','ARCHIVED','2022-06-01 10:50:50',0), ('2022_08_15_00_characters.sql','B2468D3323AB51872385A0B36EF66688C4F661EA','ARCHIVED','2022-08-15 11:21:17',0), -('2022_10_17_00_characters.sql','3E50C54495FE2653EB2F5F9120B17D124D70CEDE','ARCHIVED','2022-10-17 09:02:28',0); +('2022_10_17_00_characters.sql','3E50C54495FE2653EB2F5F9120B17D124D70CEDE','ARCHIVED','2022-10-17 09:02:28',0), +('2023_01_16_00_characters.sql','2667390C8E0EC1E5CDE16784BFCD8F8749C7D73E','ARCHIVED','2023-01-16 11:06:30',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2847,4 +2848,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-10-17 9:02:31 +-- Dump completed on 2023-01-16 11:08:17 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index e421bd4ebf3..6136160325f 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.30, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.31, for Linux (x86_64) -- -- Host: localhost Database: world -- ------------------------------------------------------ --- Server version 8.0.30-0ubuntu0.20.04.2 +-- Server version 8.0.31-0ubuntu0.20.04.2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -23,20 +23,20 @@ DROP TABLE IF EXISTS `access_requirement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `access_requirement` ( - `mapId` mediumint unsigned NOT NULL, + `mapId` int unsigned NOT NULL, `difficulty` tinyint unsigned NOT NULL DEFAULT '0', `level_min` tinyint unsigned NOT NULL DEFAULT '0', `level_max` tinyint unsigned NOT NULL DEFAULT '0', `item_level` smallint unsigned NOT NULL DEFAULT '0', - `item` mediumint unsigned NOT NULL DEFAULT '0', - `item2` mediumint unsigned NOT NULL DEFAULT '0', - `quest_done_A` mediumint unsigned NOT NULL DEFAULT '0', - `quest_done_H` mediumint unsigned NOT NULL DEFAULT '0', - `completed_achievement` mediumint unsigned NOT NULL DEFAULT '0', - `quest_failed_text` text, - `comment` text, + `item` int unsigned NOT NULL DEFAULT '0', + `item2` int unsigned NOT NULL DEFAULT '0', + `quest_done_A` int unsigned NOT NULL DEFAULT '0', + `quest_done_H` int unsigned NOT NULL DEFAULT '0', + `completed_achievement` int unsigned NOT NULL DEFAULT '0', + `quest_failed_text` mediumtext COLLATE utf8mb4_unicode_ci, + `comment` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`mapId`,`difficulty`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='Access Requirements'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Access Requirements'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -47,13 +47,13 @@ DROP TABLE IF EXISTS `achievement_criteria_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `achievement_criteria_data` ( - `criteria_id` mediumint NOT NULL, + `criteria_id` int NOT NULL, `type` tinyint unsigned NOT NULL DEFAULT '0', - `value1` mediumint unsigned NOT NULL DEFAULT '0', - `value2` mediumint unsigned NOT NULL DEFAULT '0', - `ScriptName` char(64) NOT NULL DEFAULT '', + `value1` int unsigned NOT NULL DEFAULT '0', + `value2` int unsigned NOT NULL DEFAULT '0', + `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`criteria_id`,`type`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Achievment system'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Achievment system'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -72,7 +72,7 @@ CREATE TABLE `achievement_dbc` ( `count` int unsigned NOT NULL DEFAULT '0', `refAchievement` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -83,16 +83,16 @@ DROP TABLE IF EXISTS `achievement_reward`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `achievement_reward` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `TitleA` mediumint unsigned NOT NULL DEFAULT '0', - `TitleH` mediumint unsigned NOT NULL DEFAULT '0', - `ItemID` mediumint unsigned NOT NULL DEFAULT '0', - `Sender` mediumint unsigned NOT NULL DEFAULT '0', - `Subject` varchar(255) DEFAULT NULL, - `Body` text, - `MailTemplateID` mediumint unsigned DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', + `TitleA` int unsigned NOT NULL DEFAULT '0', + `TitleH` int unsigned NOT NULL DEFAULT '0', + `ItemID` int unsigned NOT NULL DEFAULT '0', + `Sender` int unsigned NOT NULL DEFAULT '0', + `Subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Body` mediumtext COLLATE utf8mb4_unicode_ci, + `MailTemplateID` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -103,12 +103,12 @@ DROP TABLE IF EXISTS `achievement_reward_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `achievement_reward_locale` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `Locale` varchar(4) NOT NULL, - `Subject` text, - `Body` text, + `ID` int unsigned NOT NULL DEFAULT '0', + `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Subject` mediumtext COLLATE utf8mb4_unicode_ci, + `Body` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`ID`,`Locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -119,10 +119,10 @@ DROP TABLE IF EXISTS `areatrigger_involvedrelation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `areatrigger_involvedrelation` ( - `id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', - `quest` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', + `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Trigger System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -133,10 +133,10 @@ DROP TABLE IF EXISTS `areatrigger_scripts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `areatrigger_scripts` ( - `entry` mediumint NOT NULL, - `ScriptName` char(64) NOT NULL, + `entry` int NOT NULL, + `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -147,10 +147,10 @@ DROP TABLE IF EXISTS `areatrigger_tavern`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `areatrigger_tavern` ( - `id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', - `name` text, + `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', + `name` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Trigger System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -161,8 +161,8 @@ DROP TABLE IF EXISTS `areatrigger_teleport`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `areatrigger_teleport` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `Name` text, + `ID` int unsigned NOT NULL DEFAULT '0', + `Name` mediumtext COLLATE utf8mb4_unicode_ci, `target_map` smallint unsigned NOT NULL DEFAULT '0', `target_position_x` float NOT NULL DEFAULT '0', `target_position_y` float NOT NULL DEFAULT '0', @@ -171,7 +171,7 @@ CREATE TABLE `areatrigger_teleport` ( `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`ID`), FULLTEXT KEY `name` (`Name`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Trigger System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -183,9 +183,9 @@ DROP TABLE IF EXISTS `battlefield_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `battlefield_template` ( `TypeId` tinyint unsigned NOT NULL, - `ScriptName` varchar(64) NOT NULL DEFAULT '', - `comment` text -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; + `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `comment` mediumtext COLLATE utf8mb4_unicode_ci +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -196,21 +196,21 @@ DROP TABLE IF EXISTS `battleground_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `battleground_template` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', `MinPlayersPerTeam` smallint unsigned NOT NULL DEFAULT '0', `MaxPlayersPerTeam` smallint unsigned NOT NULL DEFAULT '0', `MinLvl` tinyint unsigned NOT NULL DEFAULT '0', `MaxLvl` tinyint unsigned NOT NULL DEFAULT '0', - `AllianceStartLoc` mediumint unsigned NOT NULL, + `AllianceStartLoc` int unsigned NOT NULL, `AllianceStartO` float NOT NULL, - `HordeStartLoc` mediumint unsigned NOT NULL, + `HordeStartLoc` int unsigned NOT NULL, `HordeStartO` float NOT NULL, `StartMaxDist` float NOT NULL DEFAULT '0', `Weight` tinyint unsigned NOT NULL DEFAULT '1', - `ScriptName` char(64) NOT NULL DEFAULT '', - `Comment` char(32) NOT NULL, + `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Comment` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -221,10 +221,10 @@ DROP TABLE IF EXISTS `battlemaster_entry`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `battlemaster_entry` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of a creature', - `bg_template` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Battleground template id', + `entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of a creature', + `bg_template` int unsigned NOT NULL DEFAULT '0' COMMENT 'Battleground template id', PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -235,22 +235,22 @@ DROP TABLE IF EXISTS `broadcast_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `broadcast_text` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `LanguageID` mediumint unsigned NOT NULL DEFAULT '0', - `Text` longtext, - `Text1` longtext, - `EmoteID1` mediumint unsigned NOT NULL DEFAULT '0', - `EmoteID2` mediumint unsigned NOT NULL DEFAULT '0', - `EmoteID3` mediumint unsigned NOT NULL DEFAULT '0', - `EmoteDelay1` mediumint unsigned NOT NULL DEFAULT '0', - `EmoteDelay2` mediumint unsigned NOT NULL DEFAULT '0', - `EmoteDelay3` mediumint unsigned NOT NULL DEFAULT '0', - `SoundEntriesID` mediumint unsigned NOT NULL DEFAULT '0', - `EmotesID` mediumint unsigned NOT NULL DEFAULT '0', - `Flags` mediumint unsigned NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', + `LanguageID` int unsigned NOT NULL DEFAULT '0', + `Text` longtext COLLATE utf8mb4_unicode_ci, + `Text1` longtext COLLATE utf8mb4_unicode_ci, + `EmoteID1` int unsigned NOT NULL DEFAULT '0', + `EmoteID2` int unsigned NOT NULL DEFAULT '0', + `EmoteID3` int unsigned NOT NULL DEFAULT '0', + `EmoteDelay1` int unsigned NOT NULL DEFAULT '0', + `EmoteDelay2` int unsigned NOT NULL DEFAULT '0', + `EmoteDelay3` int unsigned NOT NULL DEFAULT '0', + `SoundEntriesID` int unsigned NOT NULL DEFAULT '0', + `EmotesID` int unsigned NOT NULL DEFAULT '0', + `Flags` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -261,13 +261,13 @@ DROP TABLE IF EXISTS `broadcast_text_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `broadcast_text_locale` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) NOT NULL, - `Text` text, - `Text1` text, + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Text` mediumtext COLLATE utf8mb4_unicode_ci, + `Text1` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`ID`,`locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -278,10 +278,10 @@ DROP TABLE IF EXISTS `command`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `command` ( - `name` varchar(50) NOT NULL DEFAULT '', - `help` longtext, + `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `help` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`name`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Chat System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Chat System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -292,23 +292,23 @@ DROP TABLE IF EXISTS `conditions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `conditions` ( - `SourceTypeOrReferenceId` mediumint NOT NULL DEFAULT '0', - `SourceGroup` mediumint unsigned NOT NULL DEFAULT '0', - `SourceEntry` mediumint NOT NULL DEFAULT '0', + `SourceTypeOrReferenceId` int NOT NULL DEFAULT '0', + `SourceGroup` int unsigned NOT NULL DEFAULT '0', + `SourceEntry` int NOT NULL DEFAULT '0', `SourceId` int NOT NULL DEFAULT '0', - `ElseGroup` mediumint unsigned NOT NULL DEFAULT '0', - `ConditionTypeOrReference` mediumint NOT NULL DEFAULT '0', + `ElseGroup` int unsigned NOT NULL DEFAULT '0', + `ConditionTypeOrReference` int NOT NULL DEFAULT '0', `ConditionTarget` tinyint unsigned NOT NULL DEFAULT '0', - `ConditionValue1` mediumint unsigned NOT NULL DEFAULT '0', - `ConditionValue2` mediumint unsigned NOT NULL DEFAULT '0', - `ConditionValue3` mediumint unsigned NOT NULL DEFAULT '0', + `ConditionValue1` int unsigned NOT NULL DEFAULT '0', + `ConditionValue2` int unsigned NOT NULL DEFAULT '0', + `ConditionValue3` int unsigned NOT NULL DEFAULT '0', `NegativeCondition` tinyint unsigned NOT NULL DEFAULT '0', - `ErrorType` mediumint unsigned NOT NULL DEFAULT '0', - `ErrorTextId` mediumint unsigned NOT NULL DEFAULT '0', - `ScriptName` char(64) NOT NULL DEFAULT '', - `Comment` varchar(255) DEFAULT NULL, + `ErrorType` int unsigned NOT NULL DEFAULT '0', + `ErrorTextId` int unsigned NOT NULL DEFAULT '0', + `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Condition System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Condition System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -320,13 +320,13 @@ DROP TABLE IF EXISTS `creature`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature` ( `guid` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier', - `id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier', + `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier', `map` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', `zoneId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier', `areaId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Area Identifier', `spawnMask` tinyint unsigned NOT NULL DEFAULT '1', `phaseMask` int unsigned NOT NULL DEFAULT '1', - `modelid` mediumint unsigned NOT NULL DEFAULT '0', + `modelid` int unsigned NOT NULL DEFAULT '0', `equipment_id` tinyint NOT NULL DEFAULT '0', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', @@ -334,19 +334,19 @@ CREATE TABLE `creature` ( `orientation` float NOT NULL DEFAULT '0', `spawntimesecs` int unsigned NOT NULL DEFAULT '120', `wander_distance` float NOT NULL DEFAULT '0', - `currentwaypoint` mediumint unsigned NOT NULL DEFAULT '0', + `currentwaypoint` int unsigned NOT NULL DEFAULT '0', `curhealth` int unsigned NOT NULL DEFAULT '1', `curmana` int unsigned NOT NULL DEFAULT '0', `MovementType` tinyint unsigned NOT NULL DEFAULT '0', `npcflag` int unsigned NOT NULL DEFAULT '0', `unit_flags` int unsigned NOT NULL DEFAULT '0', `dynamicflags` int unsigned NOT NULL DEFAULT '0', - `ScriptName` char(64) DEFAULT '', + `ScriptName` char(64) COLLATE utf8mb4_unicode_ci DEFAULT '', `VerifiedBuild` int DEFAULT '0', PRIMARY KEY (`guid`), KEY `idx_map` (`map`), KEY `idx_id` (`id`) -) ENGINE=MyISAM AUTO_INCREMENT=1022682 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='Creature System'; +) ENGINE=InnoDB AUTO_INCREMENT=1022682 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -359,15 +359,18 @@ DROP TABLE IF EXISTS `creature_addon`; CREATE TABLE `creature_addon` ( `guid` int unsigned NOT NULL DEFAULT '0', `path_id` int unsigned NOT NULL DEFAULT '0', - `mount` mediumint unsigned NOT NULL DEFAULT '0', + `mount` int unsigned NOT NULL DEFAULT '0', `MountCreatureID` int unsigned NOT NULL DEFAULT '0', - `bytes1` int unsigned NOT NULL DEFAULT '0', - `bytes2` int unsigned NOT NULL DEFAULT '1', + `StandState` tinyint unsigned NOT NULL DEFAULT '0', + `AnimTier` tinyint unsigned NOT NULL DEFAULT '0', + `VisFlags` tinyint unsigned NOT NULL DEFAULT '0', + `SheathState` tinyint unsigned NOT NULL DEFAULT '1', + `PvPFlags` tinyint unsigned NOT NULL DEFAULT '0', `emote` int unsigned NOT NULL DEFAULT '0', `visibilityDistanceType` tinyint unsigned NOT NULL DEFAULT '0', - `auras` text, + `auras` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`guid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -390,9 +393,9 @@ CREATE TABLE `creature_classlevelstats` ( `damage_base` float NOT NULL DEFAULT '0', `damage_exp1` float NOT NULL DEFAULT '0', `damage_exp2` float NOT NULL DEFAULT '0', - `comment` text, + `comment` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`level`,`class`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -406,7 +409,7 @@ CREATE TABLE `creature_default_trainer` ( `CreatureId` int unsigned NOT NULL, `TrainerId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`CreatureId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -417,14 +420,14 @@ DROP TABLE IF EXISTS `creature_equip_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_equip_template` ( - `CreatureID` mediumint unsigned NOT NULL DEFAULT '0', + `CreatureID` int unsigned NOT NULL DEFAULT '0', `ID` tinyint unsigned NOT NULL DEFAULT '1', - `ItemID1` mediumint unsigned NOT NULL DEFAULT '0', - `ItemID2` mediumint unsigned NOT NULL DEFAULT '0', - `ItemID3` mediumint unsigned NOT NULL DEFAULT '0', + `ItemID1` int unsigned NOT NULL DEFAULT '0', + `ItemID2` int unsigned NOT NULL DEFAULT '0', + `ItemID3` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`CreatureID`,`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -443,7 +446,7 @@ CREATE TABLE `creature_formations` ( `point_1` smallint unsigned NOT NULL DEFAULT '0', `point_2` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`memberGUID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -454,18 +457,18 @@ DROP TABLE IF EXISTS `creature_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_loot_template` ( - `Entry` mediumint unsigned NOT NULL DEFAULT '0', - `Item` mediumint unsigned NOT NULL DEFAULT '0', - `Reference` mediumint unsigned NOT NULL DEFAULT '0', + `Entry` int unsigned NOT NULL DEFAULT '0', + `Item` int unsigned NOT NULL DEFAULT '0', + `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) DEFAULT NULL, + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Loot System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -476,13 +479,13 @@ DROP TABLE IF EXISTS `creature_model_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_model_info` ( - `DisplayID` mediumint unsigned NOT NULL DEFAULT '0', + `DisplayID` int unsigned NOT NULL DEFAULT '0', `BoundingRadius` float NOT NULL DEFAULT '0', `CombatReach` float NOT NULL DEFAULT '0', `Gender` tinyint unsigned NOT NULL DEFAULT '2', - `DisplayID_Other_Gender` mediumint unsigned NOT NULL DEFAULT '0', + `DisplayID_Other_Gender` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`DisplayID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Creature System (Model related info)'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System (Model related info)'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -497,7 +500,7 @@ CREATE TABLE `creature_movement_info` ( `WalkSpeed` float unsigned DEFAULT NULL, `RunSpeed` float unsigned DEFAULT NULL, PRIMARY KEY (`MovementID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -517,7 +520,7 @@ CREATE TABLE `creature_movement_override` ( `Random` tinyint unsigned DEFAULT NULL, `InteractionPauseTimer` int unsigned DEFAULT NULL COMMENT 'Time (in milliseconds) during which creature will not move after interaction with player', PRIMARY KEY (`SpawnId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -528,18 +531,18 @@ DROP TABLE IF EXISTS `creature_onkill_reputation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_onkill_reputation` ( - `creature_id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier', + `creature_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier', `RewOnKillRepFaction1` smallint NOT NULL DEFAULT '0', `RewOnKillRepFaction2` smallint NOT NULL DEFAULT '0', `MaxStanding1` tinyint NOT NULL DEFAULT '0', `IsTeamAward1` tinyint NOT NULL DEFAULT '0', - `RewOnKillRepValue1` mediumint NOT NULL DEFAULT '0', + `RewOnKillRepValue1` int NOT NULL DEFAULT '0', `MaxStanding2` tinyint NOT NULL DEFAULT '0', `IsTeamAward2` tinyint NOT NULL DEFAULT '0', - `RewOnKillRepValue2` mediumint NOT NULL DEFAULT '0', + `RewOnKillRepValue2` int NOT NULL DEFAULT '0', `TeamDependent` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`creature_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='Creature OnKill Reputation gain'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature OnKill Reputation gain'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -550,10 +553,10 @@ DROP TABLE IF EXISTS `creature_questender`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_questender` ( - `id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', - `quest` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', + `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`id`,`quest`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Creature System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -569,7 +572,7 @@ CREATE TABLE `creature_questitem` ( `ItemId` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint NOT NULL DEFAULT '0', PRIMARY KEY (`CreatureEntry`,`Idx`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -580,10 +583,10 @@ DROP TABLE IF EXISTS `creature_queststarter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_queststarter` ( - `id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', - `quest` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', + `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`id`,`quest`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Creature System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -594,18 +597,18 @@ DROP TABLE IF EXISTS `creature_summon_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_summon_groups` ( - `summonerId` mediumint unsigned NOT NULL DEFAULT '0', + `summonerId` int unsigned NOT NULL DEFAULT '0', `summonerType` tinyint unsigned NOT NULL DEFAULT '0', `groupId` tinyint unsigned NOT NULL DEFAULT '0', - `entry` mediumint unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `summonType` tinyint unsigned NOT NULL DEFAULT '0', `summonTime` int unsigned NOT NULL DEFAULT '0', - `Comment` varchar(255) NOT NULL DEFAULT '' -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -616,20 +619,20 @@ DROP TABLE IF EXISTS `creature_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_template` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0', - `difficulty_entry_1` mediumint unsigned NOT NULL DEFAULT '0', - `difficulty_entry_2` mediumint unsigned NOT NULL DEFAULT '0', - `difficulty_entry_3` mediumint unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', + `difficulty_entry_1` int unsigned NOT NULL DEFAULT '0', + `difficulty_entry_2` int unsigned NOT NULL DEFAULT '0', + `difficulty_entry_3` int unsigned NOT NULL DEFAULT '0', `KillCredit1` int unsigned NOT NULL DEFAULT '0', `KillCredit2` int unsigned NOT NULL DEFAULT '0', - `modelid1` mediumint unsigned NOT NULL DEFAULT '0', - `modelid2` mediumint unsigned NOT NULL DEFAULT '0', - `modelid3` mediumint unsigned NOT NULL DEFAULT '0', - `modelid4` mediumint unsigned NOT NULL DEFAULT '0', - `name` char(100) NOT NULL DEFAULT '0', - `subname` char(100) DEFAULT NULL, - `IconName` char(100) DEFAULT NULL, - `gossip_menu_id` mediumint unsigned NOT NULL DEFAULT '0', + `modelid1` int unsigned NOT NULL DEFAULT '0', + `modelid2` int unsigned NOT NULL DEFAULT '0', + `modelid3` int unsigned NOT NULL DEFAULT '0', + `modelid4` int unsigned NOT NULL DEFAULT '0', + `name` char(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', + `subname` char(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `IconName` char(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `gossip_menu_id` int unsigned NOT NULL DEFAULT '0', `minlevel` tinyint unsigned NOT NULL DEFAULT '1', `maxlevel` tinyint unsigned NOT NULL DEFAULT '1', `exp` smallint NOT NULL DEFAULT '0', @@ -651,14 +654,14 @@ CREATE TABLE `creature_template` ( `family` tinyint NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', `type_flags` int unsigned NOT NULL DEFAULT '0', - `lootid` mediumint unsigned NOT NULL DEFAULT '0', - `pickpocketloot` mediumint unsigned NOT NULL DEFAULT '0', - `skinloot` mediumint unsigned NOT NULL DEFAULT '0', - `PetSpellDataId` mediumint unsigned NOT NULL DEFAULT '0', - `VehicleId` mediumint unsigned NOT NULL DEFAULT '0', - `mingold` mediumint unsigned NOT NULL DEFAULT '0', - `maxgold` mediumint unsigned NOT NULL DEFAULT '0', - `AIName` char(64) NOT NULL DEFAULT '', + `lootid` int unsigned NOT NULL DEFAULT '0', + `pickpocketloot` int unsigned NOT NULL DEFAULT '0', + `skinloot` int unsigned NOT NULL DEFAULT '0', + `PetSpellDataId` int unsigned NOT NULL DEFAULT '0', + `VehicleId` int unsigned NOT NULL DEFAULT '0', + `mingold` int unsigned NOT NULL DEFAULT '0', + `maxgold` int unsigned NOT NULL DEFAULT '0', + `AIName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `MovementType` tinyint unsigned NOT NULL DEFAULT '0', `HoverHeight` float NOT NULL DEFAULT '1', `HealthModifier` float NOT NULL DEFAULT '1', @@ -672,11 +675,11 @@ CREATE TABLE `creature_template` ( `mechanic_immune_mask` int unsigned NOT NULL DEFAULT '0', `spell_school_immune_mask` int unsigned NOT NULL DEFAULT '0', `flags_extra` int unsigned NOT NULL DEFAULT '0', - `ScriptName` char(64) NOT NULL DEFAULT '', + `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`entry`), KEY `idx_name` (`name`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Creature System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -687,17 +690,20 @@ DROP TABLE IF EXISTS `creature_template_addon`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_template_addon` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', `path_id` int unsigned NOT NULL DEFAULT '0', - `mount` mediumint unsigned NOT NULL DEFAULT '0', + `mount` int unsigned NOT NULL DEFAULT '0', `MountCreatureID` int unsigned NOT NULL DEFAULT '0', - `bytes1` int unsigned NOT NULL DEFAULT '0', - `bytes2` int unsigned NOT NULL DEFAULT '1', - `emote` mediumint unsigned NOT NULL DEFAULT '0', + `StandState` tinyint unsigned NOT NULL DEFAULT '0', + `AnimTier` tinyint unsigned NOT NULL DEFAULT '0', + `VisFlags` tinyint unsigned NOT NULL DEFAULT '0', + `SheathState` tinyint unsigned NOT NULL DEFAULT '1', + `PvPFlags` tinyint unsigned NOT NULL DEFAULT '0', + `emote` int unsigned NOT NULL DEFAULT '0', `visibilityDistanceType` tinyint unsigned NOT NULL DEFAULT '0', - `auras` text, + `auras` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -708,13 +714,13 @@ DROP TABLE IF EXISTS `creature_template_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_template_locale` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) NOT NULL, - `Name` text, - `Title` text, + `entry` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name` mediumtext COLLATE utf8mb4_unicode_ci, + `Title` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`entry`,`locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -734,7 +740,7 @@ CREATE TABLE `creature_template_movement` ( `Random` tinyint unsigned DEFAULT NULL, `InteractionPauseTimer` int unsigned DEFAULT NULL COMMENT 'Time (in milliseconds) during which creature will not move after interaction with player', PRIMARY KEY (`CreatureId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -745,12 +751,12 @@ DROP TABLE IF EXISTS `creature_template_resistance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_template_resistance` ( - `CreatureID` mediumint unsigned NOT NULL, + `CreatureID` int unsigned NOT NULL, `School` tinyint unsigned NOT NULL, `Resistance` smallint DEFAULT NULL, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`CreatureID`,`School`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -761,12 +767,12 @@ DROP TABLE IF EXISTS `creature_template_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_template_spell` ( - `CreatureID` mediumint unsigned NOT NULL, + `CreatureID` int unsigned NOT NULL, `Index` tinyint unsigned NOT NULL DEFAULT '0', - `Spell` mediumint unsigned DEFAULT NULL, + `Spell` int unsigned NOT NULL, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`CreatureID`,`Index`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -777,21 +783,21 @@ DROP TABLE IF EXISTS `creature_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_text` ( - `CreatureID` mediumint unsigned NOT NULL DEFAULT '0', + `CreatureID` int unsigned NOT NULL DEFAULT '0', `GroupID` tinyint unsigned NOT NULL DEFAULT '0', `ID` tinyint unsigned NOT NULL DEFAULT '0', - `Text` longtext, + `Text` longtext COLLATE utf8mb4_unicode_ci, `Type` tinyint unsigned NOT NULL DEFAULT '0', `Language` tinyint NOT NULL DEFAULT '0', `Probability` float unsigned NOT NULL DEFAULT '0', - `Emote` mediumint unsigned NOT NULL DEFAULT '0', - `Duration` mediumint unsigned NOT NULL DEFAULT '0', - `Sound` mediumint unsigned NOT NULL DEFAULT '0', - `BroadcastTextId` mediumint NOT NULL DEFAULT '0', + `Emote` int unsigned NOT NULL DEFAULT '0', + `Duration` int unsigned NOT NULL DEFAULT '0', + `Sound` int unsigned NOT NULL DEFAULT '0', + `BroadcastTextId` int NOT NULL DEFAULT '0', `TextRange` tinyint unsigned NOT NULL DEFAULT '0', - `comment` varchar(255) DEFAULT '', + `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', PRIMARY KEY (`CreatureID`,`GroupID`,`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -802,13 +808,13 @@ DROP TABLE IF EXISTS `creature_text_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_text_locale` ( - `CreatureID` mediumint unsigned NOT NULL DEFAULT '0', + `CreatureID` int unsigned NOT NULL DEFAULT '0', `GroupID` tinyint unsigned NOT NULL DEFAULT '0', `ID` tinyint unsigned NOT NULL DEFAULT '0', - `Locale` varchar(4) NOT NULL, - `Text` text, + `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Text` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`CreatureID`,`GroupID`,`ID`,`Locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -822,11 +828,11 @@ CREATE TABLE `disables` ( `sourceType` int unsigned NOT NULL, `entry` int unsigned NOT NULL, `flags` smallint NOT NULL, - `params_0` varchar(255) NOT NULL DEFAULT '', - `params_1` varchar(255) NOT NULL DEFAULT '', - `comment` varchar(255) NOT NULL DEFAULT '', + `params_0` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `params_1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`sourceType`,`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -837,18 +843,18 @@ DROP TABLE IF EXISTS `disenchant_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `disenchant_loot_template` ( - `Entry` mediumint unsigned NOT NULL DEFAULT '0', - `Item` mediumint unsigned NOT NULL DEFAULT '0', - `Reference` mediumint unsigned NOT NULL DEFAULT '0', + `Entry` int unsigned NOT NULL DEFAULT '0', + `Item` int unsigned NOT NULL DEFAULT '0', + `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) DEFAULT NULL, + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -859,18 +865,18 @@ DROP TABLE IF EXISTS `event_scripts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `event_scripts` ( - `id` mediumint unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL DEFAULT '0', `delay` int unsigned NOT NULL DEFAULT '0', - `command` mediumint unsigned NOT NULL DEFAULT '0', - `datalong` mediumint unsigned NOT NULL DEFAULT '0', + `command` int unsigned NOT NULL DEFAULT '0', + `datalong` int unsigned NOT NULL DEFAULT '0', `datalong2` int unsigned NOT NULL DEFAULT '0', `dataint` int NOT NULL DEFAULT '0', `x` float NOT NULL DEFAULT '0', `y` float NOT NULL DEFAULT '0', `z` float NOT NULL DEFAULT '0', `o` float NOT NULL DEFAULT '0', - `Comment` varchar(255) NOT NULL DEFAULT '' -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -882,9 +888,9 @@ DROP TABLE IF EXISTS `exploration_basexp`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `exploration_basexp` ( `level` tinyint unsigned NOT NULL DEFAULT '0', - `basexp` mediumint NOT NULL DEFAULT '0', + `basexp` int NOT NULL DEFAULT '0', PRIMARY KEY (`level`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Exploration System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Exploration System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -895,18 +901,18 @@ DROP TABLE IF EXISTS `fishing_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `fishing_loot_template` ( - `Entry` mediumint unsigned NOT NULL DEFAULT '0', - `Item` mediumint unsigned NOT NULL DEFAULT '0', - `Reference` mediumint unsigned NOT NULL DEFAULT '0', + `Entry` int unsigned NOT NULL DEFAULT '0', + `Item` int unsigned NOT NULL DEFAULT '0', + `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) DEFAULT NULL, + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Loot System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -922,13 +928,13 @@ CREATE TABLE `game_event` ( `end_time` timestamp NULL DEFAULT NULL COMMENT 'Absolute end date, the event will never start after', `occurence` bigint unsigned NOT NULL DEFAULT '5184000' COMMENT 'Delay in minutes between occurences of the event', `length` bigint unsigned NOT NULL DEFAULT '2592000' COMMENT 'Length in minutes of the event', - `holiday` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id', + `holiday` int unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id', `holidayStage` tinyint unsigned NOT NULL DEFAULT '0', - `description` varchar(255) DEFAULT NULL COMMENT 'Description of the event displayed in console', + `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Description of the event displayed in console', `world_event` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '0 if normal event, 1 if world event', `announce` tinyint unsigned DEFAULT '2' COMMENT '0 dont announce, 1 announce, 2 value from config', PRIMARY KEY (`eventEntry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -942,7 +948,7 @@ CREATE TABLE `game_event_arena_seasons` ( `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event', `season` tinyint unsigned NOT NULL COMMENT 'Arena season number', UNIQUE KEY `season` (`season`,`eventEntry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -956,7 +962,7 @@ CREATE TABLE `game_event_battleground_holiday` ( `EventEntry` tinyint unsigned NOT NULL COMMENT 'game_event EventEntry identifier', `BattlegroundID` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`EventEntry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -968,13 +974,13 @@ DROP TABLE IF EXISTS `game_event_condition`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_condition` ( `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event', - `condition_id` mediumint unsigned NOT NULL DEFAULT '0', + `condition_id` int unsigned NOT NULL DEFAULT '0', `req_num` float DEFAULT '0', `max_world_state_field` smallint unsigned NOT NULL DEFAULT '0', `done_world_state_field` smallint unsigned NOT NULL DEFAULT '0', - `description` varchar(25) NOT NULL DEFAULT '', + `description` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`eventEntry`,`condition_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -988,7 +994,7 @@ CREATE TABLE `game_event_creature` ( `eventEntry` tinyint NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.', `guid` int unsigned NOT NULL, PRIMARY KEY (`guid`,`eventEntry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1000,10 +1006,10 @@ DROP TABLE IF EXISTS `game_event_creature_quest`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_creature_quest` ( `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event.', - `id` mediumint unsigned NOT NULL DEFAULT '0', - `quest` mediumint unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL DEFAULT '0', + `quest` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`quest`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1017,7 +1023,7 @@ CREATE TABLE `game_event_gameobject` ( `eventEntry` tinyint NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.', `guid` int unsigned NOT NULL, PRIMARY KEY (`guid`,`eventEntry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1029,10 +1035,10 @@ DROP TABLE IF EXISTS `game_event_gameobject_quest`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_gameobject_quest` ( `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event', - `id` mediumint unsigned NOT NULL DEFAULT '0', - `quest` mediumint unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL DEFAULT '0', + `quest` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`quest`,`eventEntry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1045,10 +1051,10 @@ DROP TABLE IF EXISTS `game_event_model_equip`; CREATE TABLE `game_event_model_equip` ( `eventEntry` tinyint NOT NULL COMMENT 'Entry of the game event.', `guid` int unsigned NOT NULL DEFAULT '0', - `modelid` mediumint unsigned NOT NULL DEFAULT '0', + `modelid` int unsigned NOT NULL DEFAULT '0', `equipment_id` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1060,15 +1066,15 @@ DROP TABLE IF EXISTS `game_event_npc_vendor`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_npc_vendor` ( `eventEntry` tinyint NOT NULL COMMENT 'Entry of the game event.', - `guid` mediumint unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0', `slot` smallint NOT NULL DEFAULT '0', - `item` mediumint unsigned NOT NULL DEFAULT '0', - `maxcount` mediumint unsigned NOT NULL DEFAULT '0', - `incrtime` mediumint unsigned NOT NULL DEFAULT '0', - `ExtendedCost` mediumint unsigned NOT NULL DEFAULT '0', + `item` int unsigned NOT NULL DEFAULT '0', + `maxcount` int unsigned NOT NULL DEFAULT '0', + `incrtime` int unsigned NOT NULL DEFAULT '0', + `ExtendedCost` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`item`), KEY `slot` (`slot`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1080,10 +1086,10 @@ DROP TABLE IF EXISTS `game_event_npcflag`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_npcflag` ( `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event', - `guid` mediumint unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0', `npcflag` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`eventEntry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1095,9 +1101,9 @@ DROP TABLE IF EXISTS `game_event_pool`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_pool` ( `eventEntry` tinyint NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.', - `pool_entry` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Id of the pool', + `pool_entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'Id of the pool', PRIMARY KEY (`pool_entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1109,9 +1115,9 @@ DROP TABLE IF EXISTS `game_event_prerequisite`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_prerequisite` ( `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event', - `prerequisite_event` mediumint unsigned NOT NULL, + `prerequisite_event` int unsigned NOT NULL, PRIMARY KEY (`eventEntry`,`prerequisite_event`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1123,11 +1129,11 @@ DROP TABLE IF EXISTS `game_event_quest_condition`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_quest_condition` ( `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event.', - `quest` mediumint unsigned NOT NULL DEFAULT '0', - `condition_id` mediumint unsigned NOT NULL DEFAULT '0', + `quest` int unsigned NOT NULL DEFAULT '0', + `condition_id` int unsigned NOT NULL DEFAULT '0', `num` float DEFAULT '0', PRIMARY KEY (`quest`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1139,10 +1145,10 @@ DROP TABLE IF EXISTS `game_event_seasonal_questrelation`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_seasonal_questrelation` ( `questId` int unsigned NOT NULL COMMENT 'Quest Identifier', - `eventEntry` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of the game event', + `eventEntry` int unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of the game event', PRIMARY KEY (`questId`,`eventEntry`), KEY `idx_quest` (`questId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1153,15 +1159,15 @@ DROP TABLE IF EXISTS `game_tele`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_tele` ( - `id` mediumint unsigned NOT NULL AUTO_INCREMENT, + `id` int unsigned NOT NULL, `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `map` smallint unsigned NOT NULL DEFAULT '0', - `name` varchar(100) NOT NULL DEFAULT '', + `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) ENGINE=MyISAM AUTO_INCREMENT=1517 DEFAULT CHARSET=utf8mb3 COMMENT='Tele Command'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1172,7 +1178,7 @@ DROP TABLE IF EXISTS `game_weather`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_weather` ( - `zone` mediumint unsigned NOT NULL DEFAULT '0', + `zone` int unsigned NOT NULL DEFAULT '0', `spring_rain_chance` tinyint unsigned NOT NULL DEFAULT '25', `spring_snow_chance` tinyint unsigned NOT NULL DEFAULT '25', `spring_storm_chance` tinyint unsigned NOT NULL DEFAULT '25', @@ -1185,9 +1191,9 @@ CREATE TABLE `game_weather` ( `winter_rain_chance` tinyint unsigned NOT NULL DEFAULT '25', `winter_snow_chance` tinyint unsigned NOT NULL DEFAULT '25', `winter_storm_chance` tinyint unsigned NOT NULL DEFAULT '25', - `ScriptName` char(64) NOT NULL DEFAULT '', + `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`zone`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Weather System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Weather System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1199,7 +1205,7 @@ DROP TABLE IF EXISTS `gameobject`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gameobject` ( `guid` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier', - `id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Gameobject Identifier', + `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Gameobject Identifier', `map` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', `zoneId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier', `areaId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Area Identifier', @@ -1216,10 +1222,10 @@ CREATE TABLE `gameobject` ( `spawntimesecs` int NOT NULL DEFAULT '0', `animprogress` tinyint unsigned NOT NULL DEFAULT '0', `state` tinyint unsigned NOT NULL DEFAULT '0', - `ScriptName` char(64) DEFAULT '', + `ScriptName` char(64) COLLATE utf8mb4_unicode_ci DEFAULT '', `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=MyISAM AUTO_INCREMENT=255094 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Gameobject System'; +) ENGINE=InnoDB AUTO_INCREMENT=2134507 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Gameobject System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1238,7 +1244,7 @@ CREATE TABLE `gameobject_addon` ( `invisibilityType` tinyint unsigned NOT NULL DEFAULT '0', `invisibilityValue` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1249,18 +1255,18 @@ DROP TABLE IF EXISTS `gameobject_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gameobject_loot_template` ( - `Entry` mediumint unsigned NOT NULL DEFAULT '0', - `Item` mediumint unsigned NOT NULL DEFAULT '0', - `Reference` mediumint unsigned NOT NULL DEFAULT '0', + `Entry` int unsigned NOT NULL DEFAULT '0', + `Item` int unsigned NOT NULL DEFAULT '0', + `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) DEFAULT NULL, + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Loot System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1275,7 +1281,7 @@ CREATE TABLE `gameobject_overrides` ( `faction` smallint unsigned NOT NULL DEFAULT '0', `flags` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`spawnId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1286,10 +1292,10 @@ DROP TABLE IF EXISTS `gameobject_questender`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gameobject_questender` ( - `id` mediumint unsigned NOT NULL DEFAULT '0', - `quest` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `id` int unsigned NOT NULL DEFAULT '0', + `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`id`,`quest`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1305,7 +1311,7 @@ CREATE TABLE `gameobject_questitem` ( `ItemId` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint NOT NULL DEFAULT '0', PRIMARY KEY (`GameObjectEntry`,`Idx`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1316,10 +1322,10 @@ DROP TABLE IF EXISTS `gameobject_queststarter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gameobject_queststarter` ( - `id` mediumint unsigned NOT NULL DEFAULT '0', - `quest` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `id` int unsigned NOT NULL DEFAULT '0', + `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`id`,`quest`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1330,13 +1336,13 @@ DROP TABLE IF EXISTS `gameobject_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gameobject_template` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', - `displayId` mediumint unsigned NOT NULL DEFAULT '0', - `name` varchar(100) NOT NULL DEFAULT '', - `IconName` varchar(100) NOT NULL DEFAULT '', - `castBarCaption` varchar(100) NOT NULL DEFAULT '', - `unk1` varchar(100) NOT NULL DEFAULT '', + `displayId` int unsigned NOT NULL DEFAULT '0', + `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `IconName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `castBarCaption` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `unk1` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `size` float NOT NULL DEFAULT '1', `Data0` int unsigned NOT NULL DEFAULT '0', `Data1` int NOT NULL DEFAULT '0', @@ -1362,12 +1368,12 @@ CREATE TABLE `gameobject_template` ( `Data21` int unsigned NOT NULL DEFAULT '0', `Data22` int unsigned NOT NULL DEFAULT '0', `Data23` int unsigned NOT NULL DEFAULT '0', - `AIName` char(64) NOT NULL DEFAULT '', - `ScriptName` varchar(64) NOT NULL DEFAULT '', + `AIName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`entry`), KEY `idx_name` (`name`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Gameobject System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Gameobject System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1378,17 +1384,17 @@ DROP TABLE IF EXISTS `gameobject_template_addon`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gameobject_template_addon` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', `faction` smallint unsigned NOT NULL DEFAULT '0', `flags` int unsigned NOT NULL DEFAULT '0', - `mingold` mediumint unsigned NOT NULL DEFAULT '0', - `maxgold` mediumint unsigned NOT NULL DEFAULT '0', + `mingold` int unsigned NOT NULL DEFAULT '0', + `maxgold` int unsigned NOT NULL DEFAULT '0', `artkit0` int NOT NULL DEFAULT '0', `artkit1` int NOT NULL DEFAULT '0', `artkit2` int NOT NULL DEFAULT '0', `artkit3` int NOT NULL DEFAULT '0', PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1399,13 +1405,13 @@ DROP TABLE IF EXISTS `gameobject_template_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gameobject_template_locale` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) NOT NULL, - `name` text, - `castBarCaption` text, + `entry` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` mediumtext COLLATE utf8mb4_unicode_ci, + `castBarCaption` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`entry`,`locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1417,10 +1423,10 @@ DROP TABLE IF EXISTS `gossip_menu`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gossip_menu` ( `MenuID` smallint unsigned NOT NULL DEFAULT '0', - `TextID` mediumint unsigned NOT NULL DEFAULT '0', + `TextID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`MenuID`,`TextID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1433,20 +1439,20 @@ DROP TABLE IF EXISTS `gossip_menu_option`; CREATE TABLE `gossip_menu_option` ( `MenuID` smallint unsigned NOT NULL DEFAULT '0', `OptionID` smallint unsigned NOT NULL DEFAULT '0', - `OptionIcon` mediumint unsigned NOT NULL DEFAULT '0', - `OptionText` text, - `OptionBroadcastTextID` mediumint NOT NULL DEFAULT '0', + `OptionIcon` int unsigned NOT NULL DEFAULT '0', + `OptionText` mediumtext COLLATE utf8mb4_unicode_ci, + `OptionBroadcastTextID` int NOT NULL DEFAULT '0', `OptionType` tinyint unsigned NOT NULL DEFAULT '0', `OptionNpcFlag` int unsigned NOT NULL DEFAULT '0', `ActionMenuID` int unsigned NOT NULL DEFAULT '0', - `ActionPoiID` mediumint unsigned NOT NULL DEFAULT '0', + `ActionPoiID` int unsigned NOT NULL DEFAULT '0', `BoxCoded` tinyint unsigned NOT NULL DEFAULT '0', `BoxMoney` int unsigned NOT NULL DEFAULT '0', - `BoxText` text, - `BoxBroadcastTextID` mediumint NOT NULL DEFAULT '0', + `BoxText` mediumtext COLLATE utf8mb4_unicode_ci, + `BoxBroadcastTextID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`MenuID`,`OptionID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1459,11 +1465,11 @@ DROP TABLE IF EXISTS `gossip_menu_option_locale`; CREATE TABLE `gossip_menu_option_locale` ( `MenuID` smallint unsigned NOT NULL DEFAULT '0', `OptionID` smallint unsigned NOT NULL DEFAULT '0', - `Locale` varchar(4) NOT NULL, - `OptionText` text, - `BoxText` text, + `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `OptionText` mediumtext COLLATE utf8mb4_unicode_ci, + `BoxText` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`MenuID`,`OptionID`,`Locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1474,12 +1480,12 @@ DROP TABLE IF EXISTS `graveyard_zone`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `graveyard_zone` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `GhostZone` mediumint unsigned NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', + `GhostZone` int unsigned NOT NULL DEFAULT '0', `Faction` smallint unsigned NOT NULL DEFAULT '0', - `Comment` text, + `Comment` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`ID`,`GhostZone`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Trigger System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1495,7 +1501,7 @@ CREATE TABLE `holiday_dates` ( `date_value` int unsigned NOT NULL, `holiday_duration` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`date_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1510,9 +1516,9 @@ CREATE TABLE `instance_encounters` ( `creditType` tinyint unsigned NOT NULL DEFAULT '0', `creditEntry` int unsigned NOT NULL DEFAULT '0', `lastEncounterDungeon` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'If not 0, LfgDungeon.dbc entry for the instance it is last encounter in', - `comment` varchar(255) NOT NULL DEFAULT '', + `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1529,7 +1535,7 @@ CREATE TABLE `instance_spawn_groups` ( `spawnGroupId` int unsigned NOT NULL, `flags` tinyint unsigned NOT NULL, PRIMARY KEY (`instanceMapId`,`bossStateId`,`spawnGroupId`,`bossStates`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1542,10 +1548,10 @@ DROP TABLE IF EXISTS `instance_template`; CREATE TABLE `instance_template` ( `map` smallint unsigned NOT NULL, `parent` smallint unsigned NOT NULL, - `script` varchar(128) NOT NULL DEFAULT '', + `script` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `allowMount` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`map`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1556,11 +1562,11 @@ DROP TABLE IF EXISTS `item_enchantment_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_enchantment_template` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0', - `ench` mediumint unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', + `ench` int unsigned NOT NULL DEFAULT '0', `chance` float unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`entry`,`ench`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Item Random Enchantment System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item Random Enchantment System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1571,18 +1577,18 @@ DROP TABLE IF EXISTS `item_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_loot_template` ( - `Entry` mediumint unsigned NOT NULL DEFAULT '0', - `Item` mediumint unsigned NOT NULL DEFAULT '0', - `Reference` mediumint unsigned NOT NULL DEFAULT '0', + `Entry` int unsigned NOT NULL DEFAULT '0', + `Item` int unsigned NOT NULL DEFAULT '0', + `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) DEFAULT NULL, + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1593,12 +1599,12 @@ DROP TABLE IF EXISTS `item_set_names`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_set_names` ( - `entry` mediumint unsigned NOT NULL, - `name` varchar(255) NOT NULL DEFAULT '', + `entry` int unsigned NOT NULL, + `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `InventoryType` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1609,12 +1615,12 @@ DROP TABLE IF EXISTS `item_set_names_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_set_names_locale` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) NOT NULL, - `Name` text, + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`ID`,`locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1625,12 +1631,12 @@ DROP TABLE IF EXISTS `item_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_template` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', `class` tinyint unsigned NOT NULL DEFAULT '0', `subclass` tinyint unsigned NOT NULL DEFAULT '0', `SoundOverrideSubclass` tinyint NOT NULL DEFAULT '-1', - `name` varchar(255) NOT NULL DEFAULT '', - `displayid` mediumint unsigned NOT NULL DEFAULT '0', + `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `displayid` int unsigned NOT NULL DEFAULT '0', `Quality` tinyint unsigned NOT NULL DEFAULT '0', `Flags` int unsigned NOT NULL DEFAULT '0', `FlagsExtra` int unsigned NOT NULL DEFAULT '0', @@ -1644,9 +1650,9 @@ CREATE TABLE `item_template` ( `RequiredLevel` tinyint unsigned NOT NULL DEFAULT '0', `RequiredSkill` smallint unsigned NOT NULL DEFAULT '0', `RequiredSkillRank` smallint unsigned NOT NULL DEFAULT '0', - `requiredspell` mediumint unsigned NOT NULL DEFAULT '0', - `requiredhonorrank` mediumint unsigned NOT NULL DEFAULT '0', - `RequiredCityRank` mediumint unsigned NOT NULL DEFAULT '0', + `requiredspell` int unsigned NOT NULL DEFAULT '0', + `requiredhonorrank` int unsigned NOT NULL DEFAULT '0', + `RequiredCityRank` int unsigned NOT NULL DEFAULT '0', `RequiredReputationFaction` smallint unsigned NOT NULL DEFAULT '0', `RequiredReputationRank` smallint unsigned NOT NULL DEFAULT '0', `maxcount` int NOT NULL DEFAULT '0', @@ -1691,35 +1697,35 @@ CREATE TABLE `item_template` ( `delay` smallint unsigned NOT NULL DEFAULT '1000', `ammo_type` tinyint unsigned NOT NULL DEFAULT '0', `RangedModRange` float NOT NULL DEFAULT '0', - `spellid_1` mediumint NOT NULL DEFAULT '0', + `spellid_1` int NOT NULL DEFAULT '0', `spelltrigger_1` tinyint unsigned NOT NULL DEFAULT '0', `spellcharges_1` smallint NOT NULL DEFAULT '0', `spellppmRate_1` float NOT NULL DEFAULT '0', `spellcooldown_1` int NOT NULL DEFAULT '-1', `spellcategory_1` smallint unsigned NOT NULL DEFAULT '0', `spellcategorycooldown_1` int NOT NULL DEFAULT '-1', - `spellid_2` mediumint NOT NULL DEFAULT '0', + `spellid_2` int NOT NULL DEFAULT '0', `spelltrigger_2` tinyint unsigned NOT NULL DEFAULT '0', `spellcharges_2` smallint NOT NULL DEFAULT '0', `spellppmRate_2` float NOT NULL DEFAULT '0', `spellcooldown_2` int NOT NULL DEFAULT '-1', `spellcategory_2` smallint unsigned NOT NULL DEFAULT '0', `spellcategorycooldown_2` int NOT NULL DEFAULT '-1', - `spellid_3` mediumint NOT NULL DEFAULT '0', + `spellid_3` int NOT NULL DEFAULT '0', `spelltrigger_3` tinyint unsigned NOT NULL DEFAULT '0', `spellcharges_3` smallint NOT NULL DEFAULT '0', `spellppmRate_3` float NOT NULL DEFAULT '0', `spellcooldown_3` int NOT NULL DEFAULT '-1', `spellcategory_3` smallint unsigned NOT NULL DEFAULT '0', `spellcategorycooldown_3` int NOT NULL DEFAULT '-1', - `spellid_4` mediumint NOT NULL DEFAULT '0', + `spellid_4` int NOT NULL DEFAULT '0', `spelltrigger_4` tinyint unsigned NOT NULL DEFAULT '0', `spellcharges_4` smallint NOT NULL DEFAULT '0', `spellppmRate_4` float NOT NULL DEFAULT '0', `spellcooldown_4` int NOT NULL DEFAULT '-1', `spellcategory_4` smallint unsigned NOT NULL DEFAULT '0', `spellcategorycooldown_4` int NOT NULL DEFAULT '-1', - `spellid_5` mediumint NOT NULL DEFAULT '0', + `spellid_5` int NOT NULL DEFAULT '0', `spelltrigger_5` tinyint unsigned NOT NULL DEFAULT '0', `spellcharges_5` smallint NOT NULL DEFAULT '0', `spellppmRate_5` float NOT NULL DEFAULT '0', @@ -1727,38 +1733,38 @@ CREATE TABLE `item_template` ( `spellcategory_5` smallint unsigned NOT NULL DEFAULT '0', `spellcategorycooldown_5` int NOT NULL DEFAULT '-1', `bonding` tinyint unsigned NOT NULL DEFAULT '0', - `description` varchar(255) NOT NULL DEFAULT '', - `PageText` mediumint unsigned NOT NULL DEFAULT '0', + `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `PageText` int unsigned NOT NULL DEFAULT '0', `LanguageID` tinyint unsigned NOT NULL DEFAULT '0', `PageMaterial` tinyint unsigned NOT NULL DEFAULT '0', - `startquest` mediumint unsigned NOT NULL DEFAULT '0', - `lockid` mediumint unsigned NOT NULL DEFAULT '0', + `startquest` int unsigned NOT NULL DEFAULT '0', + `lockid` int unsigned NOT NULL DEFAULT '0', `Material` tinyint NOT NULL DEFAULT '0', `sheath` tinyint unsigned NOT NULL DEFAULT '0', - `RandomProperty` mediumint NOT NULL DEFAULT '0', - `RandomSuffix` mediumint unsigned NOT NULL DEFAULT '0', - `block` mediumint unsigned NOT NULL DEFAULT '0', - `itemset` mediumint unsigned NOT NULL DEFAULT '0', + `RandomProperty` int NOT NULL DEFAULT '0', + `RandomSuffix` int unsigned NOT NULL DEFAULT '0', + `block` int unsigned NOT NULL DEFAULT '0', + `itemset` int unsigned NOT NULL DEFAULT '0', `MaxDurability` smallint unsigned NOT NULL DEFAULT '0', - `area` mediumint unsigned NOT NULL DEFAULT '0', + `area` int unsigned NOT NULL DEFAULT '0', `Map` smallint NOT NULL DEFAULT '0', - `BagFamily` mediumint NOT NULL DEFAULT '0', - `TotemCategory` mediumint NOT NULL DEFAULT '0', + `BagFamily` int NOT NULL DEFAULT '0', + `TotemCategory` int NOT NULL DEFAULT '0', `socketColor_1` tinyint NOT NULL DEFAULT '0', - `socketContent_1` mediumint NOT NULL DEFAULT '0', + `socketContent_1` int NOT NULL DEFAULT '0', `socketColor_2` tinyint NOT NULL DEFAULT '0', - `socketContent_2` mediumint NOT NULL DEFAULT '0', + `socketContent_2` int NOT NULL DEFAULT '0', `socketColor_3` tinyint NOT NULL DEFAULT '0', - `socketContent_3` mediumint NOT NULL DEFAULT '0', - `socketBonus` mediumint NOT NULL DEFAULT '0', - `GemProperties` mediumint NOT NULL DEFAULT '0', + `socketContent_3` int NOT NULL DEFAULT '0', + `socketBonus` int NOT NULL DEFAULT '0', + `GemProperties` int NOT NULL DEFAULT '0', `RequiredDisenchantSkill` smallint NOT NULL DEFAULT '-1', `ArmorDamageModifier` float NOT NULL DEFAULT '0', `duration` int unsigned NOT NULL DEFAULT '0', `ItemLimitCategory` smallint NOT NULL DEFAULT '0', `HolidayId` int unsigned NOT NULL DEFAULT '0', - `ScriptName` varchar(64) NOT NULL DEFAULT '', - `DisenchantID` mediumint unsigned NOT NULL DEFAULT '0', + `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `DisenchantID` int unsigned NOT NULL DEFAULT '0', `FoodType` tinyint unsigned NOT NULL DEFAULT '0', `minMoneyLoot` int unsigned NOT NULL DEFAULT '0', `maxMoneyLoot` int unsigned NOT NULL DEFAULT '0', @@ -1767,7 +1773,7 @@ CREATE TABLE `item_template` ( PRIMARY KEY (`entry`), KEY `idx_name` (`name`), KEY `items_index` (`class`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Item System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1778,13 +1784,13 @@ DROP TABLE IF EXISTS `item_template_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_template_locale` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) NOT NULL, - `Name` text, - `Description` text, + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name` mediumtext COLLATE utf8mb4_unicode_ci, + `Description` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`ID`,`locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1800,7 +1806,7 @@ CREATE TABLE `lfg_dungeon_rewards` ( `firstQuestId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest id with rewards for first dungeon this day', `otherQuestId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest id with rewards for Nth dungeon this day', PRIMARY KEY (`dungeonId`,`maxLevel`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1812,14 +1818,14 @@ DROP TABLE IF EXISTS `lfg_dungeon_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `lfg_dungeon_template` ( `dungeonId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Unique id from LFGDungeons.dbc', - `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`dungeonId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1834,7 +1840,7 @@ CREATE TABLE `linked_respawn` ( `linkedGuid` int unsigned NOT NULL COMMENT 'master creature', `linkType` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`linkType`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='Creature Respawn Link System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature Respawn Link System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1846,11 +1852,11 @@ DROP TABLE IF EXISTS `mail_level_reward`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mail_level_reward` ( `level` tinyint unsigned NOT NULL DEFAULT '0', - `raceMask` mediumint unsigned NOT NULL DEFAULT '0', - `mailTemplateId` mediumint unsigned NOT NULL DEFAULT '0', - `senderEntry` mediumint unsigned NOT NULL DEFAULT '0', + `raceMask` int unsigned NOT NULL DEFAULT '0', + `mailTemplateId` int unsigned NOT NULL DEFAULT '0', + `senderEntry` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`level`,`raceMask`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Mail System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Mail System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1861,18 +1867,18 @@ DROP TABLE IF EXISTS `mail_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mail_loot_template` ( - `Entry` mediumint unsigned NOT NULL DEFAULT '0', - `Item` mediumint unsigned NOT NULL DEFAULT '0', - `Reference` mediumint unsigned NOT NULL DEFAULT '0', + `Entry` int unsigned NOT NULL DEFAULT '0', + `Item` int unsigned NOT NULL DEFAULT '0', + `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) DEFAULT NULL, + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1883,18 +1889,18 @@ DROP TABLE IF EXISTS `milling_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `milling_loot_template` ( - `Entry` mediumint unsigned NOT NULL DEFAULT '0', - `Item` mediumint unsigned NOT NULL DEFAULT '0', - `Reference` mediumint unsigned NOT NULL DEFAULT '0', + `Entry` int unsigned NOT NULL DEFAULT '0', + `Item` int unsigned NOT NULL DEFAULT '0', + `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) DEFAULT NULL, + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1910,7 +1916,7 @@ CREATE TABLE `npc_spellclick_spells` ( `cast_flags` tinyint unsigned NOT NULL COMMENT 'first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit', `user_type` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'relation with summoner: 0-no 1-friendly 2-raid 3-party player can click', PRIMARY KEY (`npc_entry`,`spell_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1921,10 +1927,10 @@ DROP TABLE IF EXISTS `npc_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `npc_text` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `text0_0` longtext, - `text0_1` longtext, - `BroadcastTextID0` mediumint NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', + `text0_0` longtext COLLATE utf8mb4_unicode_ci, + `text0_1` longtext COLLATE utf8mb4_unicode_ci, + `BroadcastTextID0` int NOT NULL DEFAULT '0', `lang0` tinyint unsigned NOT NULL DEFAULT '0', `Probability0` float NOT NULL DEFAULT '0', `EmoteDelay0_0` smallint unsigned NOT NULL DEFAULT '0', @@ -1933,9 +1939,9 @@ CREATE TABLE `npc_text` ( `Emote0_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay0_2` smallint unsigned NOT NULL DEFAULT '0', `Emote0_2` smallint unsigned NOT NULL DEFAULT '0', - `text1_0` longtext, - `text1_1` longtext, - `BroadcastTextID1` mediumint NOT NULL DEFAULT '0', + `text1_0` longtext COLLATE utf8mb4_unicode_ci, + `text1_1` longtext COLLATE utf8mb4_unicode_ci, + `BroadcastTextID1` int NOT NULL DEFAULT '0', `lang1` tinyint unsigned NOT NULL DEFAULT '0', `Probability1` float NOT NULL DEFAULT '0', `EmoteDelay1_0` smallint unsigned NOT NULL DEFAULT '0', @@ -1944,9 +1950,9 @@ CREATE TABLE `npc_text` ( `Emote1_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay1_2` smallint unsigned NOT NULL DEFAULT '0', `Emote1_2` smallint unsigned NOT NULL DEFAULT '0', - `text2_0` longtext, - `text2_1` longtext, - `BroadcastTextID2` mediumint NOT NULL DEFAULT '0', + `text2_0` longtext COLLATE utf8mb4_unicode_ci, + `text2_1` longtext COLLATE utf8mb4_unicode_ci, + `BroadcastTextID2` int NOT NULL DEFAULT '0', `lang2` tinyint unsigned NOT NULL DEFAULT '0', `Probability2` float NOT NULL DEFAULT '0', `EmoteDelay2_0` smallint unsigned NOT NULL DEFAULT '0', @@ -1955,9 +1961,9 @@ CREATE TABLE `npc_text` ( `Emote2_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay2_2` smallint unsigned NOT NULL DEFAULT '0', `Emote2_2` smallint unsigned NOT NULL DEFAULT '0', - `text3_0` longtext, - `text3_1` longtext, - `BroadcastTextID3` mediumint NOT NULL DEFAULT '0', + `text3_0` longtext COLLATE utf8mb4_unicode_ci, + `text3_1` longtext COLLATE utf8mb4_unicode_ci, + `BroadcastTextID3` int NOT NULL DEFAULT '0', `lang3` tinyint unsigned NOT NULL DEFAULT '0', `Probability3` float NOT NULL DEFAULT '0', `EmoteDelay3_0` smallint unsigned NOT NULL DEFAULT '0', @@ -1966,9 +1972,9 @@ CREATE TABLE `npc_text` ( `Emote3_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay3_2` smallint unsigned NOT NULL DEFAULT '0', `Emote3_2` smallint unsigned NOT NULL DEFAULT '0', - `text4_0` longtext, - `text4_1` longtext, - `BroadcastTextID4` mediumint NOT NULL DEFAULT '0', + `text4_0` longtext COLLATE utf8mb4_unicode_ci, + `text4_1` longtext COLLATE utf8mb4_unicode_ci, + `BroadcastTextID4` int NOT NULL DEFAULT '0', `lang4` tinyint unsigned NOT NULL DEFAULT '0', `Probability4` float NOT NULL DEFAULT '0', `EmoteDelay4_0` smallint unsigned NOT NULL DEFAULT '0', @@ -1977,9 +1983,9 @@ CREATE TABLE `npc_text` ( `Emote4_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay4_2` smallint unsigned NOT NULL DEFAULT '0', `Emote4_2` smallint unsigned NOT NULL DEFAULT '0', - `text5_0` longtext, - `text5_1` longtext, - `BroadcastTextID5` mediumint NOT NULL DEFAULT '0', + `text5_0` longtext COLLATE utf8mb4_unicode_ci, + `text5_1` longtext COLLATE utf8mb4_unicode_ci, + `BroadcastTextID5` int NOT NULL DEFAULT '0', `lang5` tinyint unsigned NOT NULL DEFAULT '0', `Probability5` float NOT NULL DEFAULT '0', `EmoteDelay5_0` smallint unsigned NOT NULL DEFAULT '0', @@ -1988,9 +1994,9 @@ CREATE TABLE `npc_text` ( `Emote5_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay5_2` smallint unsigned NOT NULL DEFAULT '0', `Emote5_2` smallint unsigned NOT NULL DEFAULT '0', - `text6_0` longtext, - `text6_1` longtext, - `BroadcastTextID6` mediumint NOT NULL DEFAULT '0', + `text6_0` longtext COLLATE utf8mb4_unicode_ci, + `text6_1` longtext COLLATE utf8mb4_unicode_ci, + `BroadcastTextID6` int NOT NULL DEFAULT '0', `lang6` tinyint unsigned NOT NULL DEFAULT '0', `Probability6` float NOT NULL DEFAULT '0', `EmoteDelay6_0` smallint unsigned NOT NULL DEFAULT '0', @@ -1999,9 +2005,9 @@ CREATE TABLE `npc_text` ( `Emote6_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay6_2` smallint unsigned NOT NULL DEFAULT '0', `Emote6_2` smallint unsigned NOT NULL DEFAULT '0', - `text7_0` longtext, - `text7_1` longtext, - `BroadcastTextID7` mediumint NOT NULL DEFAULT '0', + `text7_0` longtext COLLATE utf8mb4_unicode_ci, + `text7_1` longtext COLLATE utf8mb4_unicode_ci, + `BroadcastTextID7` int NOT NULL DEFAULT '0', `lang7` tinyint unsigned NOT NULL DEFAULT '0', `Probability7` float NOT NULL DEFAULT '0', `EmoteDelay7_0` smallint unsigned NOT NULL DEFAULT '0', @@ -2012,7 +2018,7 @@ CREATE TABLE `npc_text` ( `Emote7_2` smallint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2023,26 +2029,26 @@ DROP TABLE IF EXISTS `npc_text_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `npc_text_locale` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `Locale` varchar(4) NOT NULL, - `Text0_0` longtext, - `Text0_1` longtext, - `Text1_0` longtext, - `Text1_1` longtext, - `Text2_0` longtext, - `Text2_1` longtext, - `Text3_0` longtext, - `Text3_1` longtext, - `Text4_0` longtext, - `Text4_1` longtext, - `Text5_0` longtext, - `Text5_1` longtext, - `Text6_0` longtext, - `Text6_1` longtext, - `Text7_0` longtext, - `Text7_1` longtext, + `ID` int unsigned NOT NULL DEFAULT '0', + `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Text0_0` longtext COLLATE utf8mb4_unicode_ci, + `Text0_1` longtext COLLATE utf8mb4_unicode_ci, + `Text1_0` longtext COLLATE utf8mb4_unicode_ci, + `Text1_1` longtext COLLATE utf8mb4_unicode_ci, + `Text2_0` longtext COLLATE utf8mb4_unicode_ci, + `Text2_1` longtext COLLATE utf8mb4_unicode_ci, + `Text3_0` longtext COLLATE utf8mb4_unicode_ci, + `Text3_1` longtext COLLATE utf8mb4_unicode_ci, + `Text4_0` longtext COLLATE utf8mb4_unicode_ci, + `Text4_1` longtext COLLATE utf8mb4_unicode_ci, + `Text5_0` longtext COLLATE utf8mb4_unicode_ci, + `Text5_1` longtext COLLATE utf8mb4_unicode_ci, + `Text6_0` longtext COLLATE utf8mb4_unicode_ci, + `Text6_1` longtext COLLATE utf8mb4_unicode_ci, + `Text7_0` longtext COLLATE utf8mb4_unicode_ci, + `Text7_1` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`ID`,`Locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2053,16 +2059,16 @@ DROP TABLE IF EXISTS `npc_vendor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `npc_vendor` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', `slot` smallint NOT NULL DEFAULT '0', - `item` mediumint NOT NULL DEFAULT '0', + `item` int NOT NULL DEFAULT '0', `maxcount` tinyint unsigned NOT NULL DEFAULT '0', `incrtime` int unsigned NOT NULL DEFAULT '0', - `ExtendedCost` mediumint unsigned NOT NULL DEFAULT '0', + `ExtendedCost` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`entry`,`item`,`ExtendedCost`), KEY `slot` (`slot`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Npc System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Npc System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2074,10 +2080,10 @@ DROP TABLE IF EXISTS `outdoorpvp_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `outdoorpvp_template` ( `TypeId` tinyint unsigned NOT NULL, - `ScriptName` char(64) NOT NULL DEFAULT '', - `comment` text, + `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `comment` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`TypeId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='OutdoorPvP Templates'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='OutdoorPvP Templates'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2088,12 +2094,12 @@ DROP TABLE IF EXISTS `page_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `page_text` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `Text` longtext NOT NULL, - `NextPageID` mediumint unsigned NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', + `Text` longtext COLLATE utf8mb4_unicode_ci NOT NULL, + `NextPageID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Item System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2104,12 +2110,12 @@ DROP TABLE IF EXISTS `page_text_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `page_text_locale` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) NOT NULL, - `Text` text, + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Text` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`ID`,`locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2120,7 +2126,7 @@ DROP TABLE IF EXISTS `pet_levelstats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_levelstats` ( - `creature_entry` mediumint unsigned NOT NULL, + `creature_entry` int unsigned NOT NULL, `level` tinyint unsigned NOT NULL, `hp` smallint unsigned NOT NULL, `mana` smallint unsigned NOT NULL, @@ -2133,7 +2139,7 @@ CREATE TABLE `pet_levelstats` ( `min_dmg` smallint unsigned NOT NULL DEFAULT '0', `max_dmg` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`creature_entry`,`level`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 PACK_KEYS=0 COMMENT='Stores pet levels stats.'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PACK_KEYS=0 COMMENT='Stores pet levels stats.'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2144,12 +2150,12 @@ DROP TABLE IF EXISTS `pet_name_generation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_name_generation` ( - `id` mediumint unsigned NOT NULL AUTO_INCREMENT, - `word` tinytext NOT NULL, - `entry` mediumint unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL, + `word` text COLLATE utf8mb4_unicode_ci NOT NULL, + `entry` int unsigned NOT NULL DEFAULT '0', `half` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) -) ENGINE=MyISAM AUTO_INCREMENT=314 DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2160,18 +2166,18 @@ DROP TABLE IF EXISTS `pickpocketing_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pickpocketing_loot_template` ( - `Entry` mediumint unsigned NOT NULL DEFAULT '0', - `Item` mediumint unsigned NOT NULL DEFAULT '0', - `Reference` mediumint unsigned NOT NULL DEFAULT '0', + `Entry` int unsigned NOT NULL DEFAULT '0', + `Item` int unsigned NOT NULL DEFAULT '0', + `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) DEFAULT NULL, + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2187,7 +2193,7 @@ CREATE TABLE `player_classlevelstats` ( `basehp` smallint unsigned NOT NULL, `basemana` smallint unsigned NOT NULL, PRIMARY KEY (`class`,`level`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 PACK_KEYS=0 COMMENT='Stores levels stats.'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PACK_KEYS=0 COMMENT='Stores levels stats.'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2201,7 +2207,7 @@ CREATE TABLE `player_factionchange_achievement` ( `alliance_id` int unsigned NOT NULL, `horde_id` int unsigned NOT NULL, PRIMARY KEY (`alliance_id`,`horde_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2214,12 +2220,12 @@ DROP TABLE IF EXISTS `player_factionchange_items`; CREATE TABLE `player_factionchange_items` ( `race_A` int unsigned NOT NULL, `alliance_id` int unsigned NOT NULL, - `commentA` text, + `commentA` mediumtext COLLATE utf8mb4_unicode_ci, `race_H` int unsigned NOT NULL, `horde_id` int unsigned NOT NULL, - `commentH` text, + `commentH` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`alliance_id`,`horde_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2235,7 +2241,7 @@ CREATE TABLE `player_factionchange_quests` ( PRIMARY KEY (`alliance_id`,`horde_id`), UNIQUE KEY `alliance_uniq` (`alliance_id`), UNIQUE KEY `horde_uniq` (`horde_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2249,7 +2255,7 @@ CREATE TABLE `player_factionchange_reputations` ( `alliance_id` int unsigned NOT NULL, `horde_id` int unsigned NOT NULL, PRIMARY KEY (`alliance_id`,`horde_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2263,7 +2269,7 @@ CREATE TABLE `player_factionchange_spells` ( `alliance_id` int unsigned NOT NULL, `horde_id` int unsigned NOT NULL, PRIMARY KEY (`alliance_id`,`horde_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2277,7 +2283,7 @@ CREATE TABLE `player_factionchange_titles` ( `alliance_id` int NOT NULL, `horde_id` int NOT NULL, PRIMARY KEY (`alliance_id`,`horde_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2297,7 +2303,7 @@ CREATE TABLE `player_levelstats` ( `inte` tinyint unsigned NOT NULL, `spi` tinyint unsigned NOT NULL, PRIMARY KEY (`race`,`class`,`level`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 PACK_KEYS=0 COMMENT='Stores levels stats.'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PACK_KEYS=0 COMMENT='Stores levels stats.'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2312,7 +2318,7 @@ CREATE TABLE `player_totem_model` ( `RaceId` tinyint unsigned NOT NULL, `DisplayId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`TotemSlot`,`RaceId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2326,7 +2332,7 @@ CREATE TABLE `player_xp_for_level` ( `Level` tinyint unsigned NOT NULL, `Experience` int unsigned NOT NULL, PRIMARY KEY (`Level`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2340,13 +2346,13 @@ CREATE TABLE `playercreateinfo` ( `race` tinyint unsigned NOT NULL DEFAULT '0', `class` tinyint unsigned NOT NULL DEFAULT '0', `map` smallint unsigned NOT NULL DEFAULT '0', - `zone` mediumint unsigned NOT NULL DEFAULT '0', + `zone` int unsigned NOT NULL DEFAULT '0', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', PRIMARY KEY (`race`,`class`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2364,7 +2370,7 @@ CREATE TABLE `playercreateinfo_action` ( `type` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`race`,`class`,`button`), KEY `playercreateinfo_race_class_index` (`race`,`class`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2377,9 +2383,9 @@ DROP TABLE IF EXISTS `playercreateinfo_cast_spell`; CREATE TABLE `playercreateinfo_cast_spell` ( `raceMask` int unsigned NOT NULL DEFAULT '0', `classMask` int unsigned NOT NULL DEFAULT '0', - `spell` mediumint unsigned NOT NULL DEFAULT '0', - `note` varchar(255) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; + `spell` int unsigned NOT NULL DEFAULT '0', + `note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2392,11 +2398,11 @@ DROP TABLE IF EXISTS `playercreateinfo_item`; CREATE TABLE `playercreateinfo_item` ( `race` tinyint unsigned NOT NULL DEFAULT '0', `class` tinyint unsigned NOT NULL DEFAULT '0', - `itemid` mediumint unsigned NOT NULL DEFAULT '0', + `itemid` int unsigned NOT NULL DEFAULT '0', `amount` tinyint NOT NULL DEFAULT '1', PRIMARY KEY (`race`,`class`,`itemid`), KEY `playercreateinfo_race_class_index` (`race`,`class`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2411,9 +2417,9 @@ CREATE TABLE `playercreateinfo_skills` ( `classMask` int unsigned NOT NULL, `skill` smallint unsigned NOT NULL, `rank` smallint unsigned NOT NULL DEFAULT '0', - `comment` varchar(255) DEFAULT NULL, + `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`raceMask`,`classMask`,`skill`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2426,10 +2432,10 @@ DROP TABLE IF EXISTS `playercreateinfo_spell_custom`; CREATE TABLE `playercreateinfo_spell_custom` ( `racemask` int unsigned NOT NULL DEFAULT '0', `classmask` int unsigned NOT NULL DEFAULT '0', - `Spell` mediumint unsigned NOT NULL DEFAULT '0', - `Note` varchar(255) DEFAULT NULL, + `Spell` int unsigned NOT NULL DEFAULT '0', + `Note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`racemask`,`classmask`,`Spell`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2440,16 +2446,16 @@ DROP TABLE IF EXISTS `points_of_interest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `points_of_interest` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', `PositionX` float NOT NULL DEFAULT '0', `PositionY` float NOT NULL DEFAULT '0', - `Icon` mediumint unsigned NOT NULL DEFAULT '0', - `Flags` mediumint unsigned NOT NULL DEFAULT '0', - `Importance` mediumint unsigned NOT NULL DEFAULT '0', - `Name` text NOT NULL, + `Icon` int unsigned NOT NULL DEFAULT '0', + `Flags` int unsigned NOT NULL DEFAULT '0', + `Importance` int unsigned NOT NULL DEFAULT '0', + `Name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2460,12 +2466,12 @@ DROP TABLE IF EXISTS `points_of_interest_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `points_of_interest_locale` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) NOT NULL, - `Name` text, + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`ID`,`locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2480,9 +2486,9 @@ CREATE TABLE `pool_members` ( `spawnId` int unsigned NOT NULL, `poolSpawnId` int unsigned NOT NULL, `chance` float NOT NULL, - `description` varchar(255) DEFAULT NULL, + `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`type`,`spawnId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2493,11 +2499,11 @@ DROP TABLE IF EXISTS `pool_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pool_template` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Pool entry', + `entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'Pool entry', `max_limit` int unsigned NOT NULL DEFAULT '0' COMMENT 'Max number of objects (0) is no limit', - `description` varchar(255) DEFAULT NULL, + `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2508,18 +2514,18 @@ DROP TABLE IF EXISTS `prospecting_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `prospecting_loot_template` ( - `Entry` mediumint unsigned NOT NULL DEFAULT '0', - `Item` mediumint unsigned NOT NULL DEFAULT '0', - `Reference` mediumint unsigned NOT NULL DEFAULT '0', + `Entry` int unsigned NOT NULL DEFAULT '0', + `Item` int unsigned NOT NULL DEFAULT '0', + `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) DEFAULT NULL, + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2530,7 +2536,7 @@ DROP TABLE IF EXISTS `quest_details`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_details` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', `Emote1` smallint unsigned NOT NULL DEFAULT '0', `Emote2` smallint unsigned NOT NULL DEFAULT '0', `Emote3` smallint unsigned NOT NULL DEFAULT '0', @@ -2541,7 +2547,7 @@ CREATE TABLE `quest_details` ( `EmoteDelay4` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2552,14 +2558,14 @@ DROP TABLE IF EXISTS `quest_greeting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_greeting` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', `Type` tinyint unsigned NOT NULL DEFAULT '0', `GreetEmoteType` smallint unsigned NOT NULL DEFAULT '0', `GreetEmoteDelay` int unsigned NOT NULL DEFAULT '0', - `Greeting` text, + `Greeting` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`Type`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2570,13 +2576,13 @@ DROP TABLE IF EXISTS `quest_greeting_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_greeting_locale` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', `Type` tinyint unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) NOT NULL, - `Greeting` text, + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Greeting` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`ID`,`Type`,`locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2590,7 +2596,7 @@ CREATE TABLE `quest_mail_sender` ( `QuestId` int unsigned NOT NULL DEFAULT '0', `RewardMailSenderEntry` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`QuestId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2601,7 +2607,7 @@ DROP TABLE IF EXISTS `quest_offer_reward`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_offer_reward` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', `Emote1` smallint unsigned NOT NULL DEFAULT '0', `Emote2` smallint unsigned NOT NULL DEFAULT '0', `Emote3` smallint unsigned NOT NULL DEFAULT '0', @@ -2610,10 +2616,10 @@ CREATE TABLE `quest_offer_reward` ( `EmoteDelay2` int unsigned NOT NULL DEFAULT '0', `EmoteDelay3` int unsigned NOT NULL DEFAULT '0', `EmoteDelay4` int unsigned NOT NULL DEFAULT '0', - `RewardText` text, + `RewardText` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2625,11 +2631,11 @@ DROP TABLE IF EXISTS `quest_offer_reward_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_offer_reward_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) NOT NULL, - `RewardText` text, + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `RewardText` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2651,7 +2657,7 @@ CREATE TABLE `quest_poi` ( `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`QuestID`,`id`), KEY `idx` (`QuestID`,`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2670,7 +2676,7 @@ CREATE TABLE `quest_poi_points` ( `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`QuestID`,`Idx1`,`Idx2`), KEY `questId_id` (`QuestID`,`Idx1`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2684,9 +2690,9 @@ CREATE TABLE `quest_pool_members` ( `questId` int unsigned NOT NULL, `poolId` int unsigned NOT NULL, `poolIndex` tinyint unsigned NOT NULL COMMENT 'Multiple quests with the same index will always spawn together!', - `description` varchar(255) DEFAULT NULL, + `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`questId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2697,11 +2703,11 @@ DROP TABLE IF EXISTS `quest_pool_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_pool_template` ( - `poolId` mediumint unsigned NOT NULL, + `poolId` int unsigned NOT NULL, `numActive` int unsigned NOT NULL COMMENT 'Number of indices to have active at any time', - `description` varchar(255) DEFAULT NULL, + `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`poolId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2712,13 +2718,13 @@ DROP TABLE IF EXISTS `quest_request_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_request_items` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', `EmoteOnComplete` smallint unsigned NOT NULL DEFAULT '0', `EmoteOnIncomplete` smallint unsigned NOT NULL DEFAULT '0', - `CompletionText` text, + `CompletionText` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2730,11 +2736,11 @@ DROP TABLE IF EXISTS `quest_request_items_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_request_items_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) NOT NULL, - `CompletionText` text, + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `CompletionText` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2745,7 +2751,7 @@ DROP TABLE IF EXISTS `quest_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_template` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', `QuestType` tinyint unsigned NOT NULL DEFAULT '2', `QuestLevel` smallint NOT NULL DEFAULT '1', `MinLevel` tinyint unsigned NOT NULL DEFAULT '0', @@ -2754,90 +2760,90 @@ CREATE TABLE `quest_template` ( `SuggestedGroupNum` tinyint unsigned NOT NULL DEFAULT '0', `RequiredFactionId1` smallint unsigned NOT NULL DEFAULT '0', `RequiredFactionId2` smallint unsigned NOT NULL DEFAULT '0', - `RequiredFactionValue1` mediumint NOT NULL DEFAULT '0', - `RequiredFactionValue2` mediumint NOT NULL DEFAULT '0', - `RewardNextQuest` mediumint unsigned NOT NULL DEFAULT '0', + `RequiredFactionValue1` int NOT NULL DEFAULT '0', + `RequiredFactionValue2` int NOT NULL DEFAULT '0', + `RewardNextQuest` int unsigned NOT NULL DEFAULT '0', `RewardXPDifficulty` tinyint unsigned NOT NULL DEFAULT '0', `RewardMoney` int NOT NULL DEFAULT '0', `RewardBonusMoney` int unsigned NOT NULL DEFAULT '0', - `RewardDisplaySpell` mediumint unsigned NOT NULL DEFAULT '0', + `RewardDisplaySpell` int unsigned NOT NULL DEFAULT '0', `RewardSpell` int NOT NULL DEFAULT '0', `RewardHonor` int NOT NULL DEFAULT '0', `RewardKillHonor` float NOT NULL DEFAULT '0', - `StartItem` mediumint unsigned NOT NULL DEFAULT '0', + `StartItem` int unsigned NOT NULL DEFAULT '0', `Flags` int unsigned NOT NULL DEFAULT '0', `RequiredPlayerKills` tinyint unsigned NOT NULL DEFAULT '0', - `RewardItem1` mediumint unsigned NOT NULL DEFAULT '0', + `RewardItem1` int unsigned NOT NULL DEFAULT '0', `RewardAmount1` smallint unsigned NOT NULL DEFAULT '0', - `RewardItem2` mediumint unsigned NOT NULL DEFAULT '0', + `RewardItem2` int unsigned NOT NULL DEFAULT '0', `RewardAmount2` smallint unsigned NOT NULL DEFAULT '0', - `RewardItem3` mediumint unsigned NOT NULL DEFAULT '0', + `RewardItem3` int unsigned NOT NULL DEFAULT '0', `RewardAmount3` smallint unsigned NOT NULL DEFAULT '0', - `RewardItem4` mediumint unsigned NOT NULL DEFAULT '0', + `RewardItem4` int unsigned NOT NULL DEFAULT '0', `RewardAmount4` smallint unsigned NOT NULL DEFAULT '0', - `ItemDrop1` mediumint unsigned NOT NULL DEFAULT '0', + `ItemDrop1` int unsigned NOT NULL DEFAULT '0', `ItemDropQuantity1` smallint unsigned NOT NULL DEFAULT '0', - `ItemDrop2` mediumint unsigned NOT NULL DEFAULT '0', + `ItemDrop2` int unsigned NOT NULL DEFAULT '0', `ItemDropQuantity2` smallint unsigned NOT NULL DEFAULT '0', - `ItemDrop3` mediumint unsigned NOT NULL DEFAULT '0', + `ItemDrop3` int unsigned NOT NULL DEFAULT '0', `ItemDropQuantity3` smallint unsigned NOT NULL DEFAULT '0', - `ItemDrop4` mediumint unsigned NOT NULL DEFAULT '0', + `ItemDrop4` int unsigned NOT NULL DEFAULT '0', `ItemDropQuantity4` smallint unsigned NOT NULL DEFAULT '0', - `RewardChoiceItemID1` mediumint unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemID1` int unsigned NOT NULL DEFAULT '0', `RewardChoiceItemQuantity1` smallint unsigned NOT NULL DEFAULT '0', - `RewardChoiceItemID2` mediumint unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemID2` int unsigned NOT NULL DEFAULT '0', `RewardChoiceItemQuantity2` smallint unsigned NOT NULL DEFAULT '0', - `RewardChoiceItemID3` mediumint unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemID3` int unsigned NOT NULL DEFAULT '0', `RewardChoiceItemQuantity3` smallint unsigned NOT NULL DEFAULT '0', - `RewardChoiceItemID4` mediumint unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemID4` int unsigned NOT NULL DEFAULT '0', `RewardChoiceItemQuantity4` smallint unsigned NOT NULL DEFAULT '0', - `RewardChoiceItemID5` mediumint unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemID5` int unsigned NOT NULL DEFAULT '0', `RewardChoiceItemQuantity5` smallint unsigned NOT NULL DEFAULT '0', - `RewardChoiceItemID6` mediumint unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemID6` int unsigned NOT NULL DEFAULT '0', `RewardChoiceItemQuantity6` smallint unsigned NOT NULL DEFAULT '0', `POIContinent` smallint unsigned NOT NULL DEFAULT '0', `POIx` float NOT NULL DEFAULT '0', `POIy` float NOT NULL DEFAULT '0', - `POIPriority` mediumint unsigned NOT NULL DEFAULT '0', + `POIPriority` int unsigned NOT NULL DEFAULT '0', `RewardTitle` tinyint unsigned NOT NULL DEFAULT '0', `RewardTalents` tinyint unsigned NOT NULL DEFAULT '0', `RewardArenaPoints` smallint unsigned NOT NULL DEFAULT '0', `RewardFactionID1` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', - `RewardFactionValue1` mediumint NOT NULL DEFAULT '0', - `RewardFactionOverride1` mediumint NOT NULL DEFAULT '0', + `RewardFactionValue1` int NOT NULL DEFAULT '0', + `RewardFactionOverride1` int NOT NULL DEFAULT '0', `RewardFactionID2` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', - `RewardFactionValue2` mediumint NOT NULL DEFAULT '0', - `RewardFactionOverride2` mediumint NOT NULL DEFAULT '0', + `RewardFactionValue2` int NOT NULL DEFAULT '0', + `RewardFactionOverride2` int NOT NULL DEFAULT '0', `RewardFactionID3` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', - `RewardFactionValue3` mediumint NOT NULL DEFAULT '0', - `RewardFactionOverride3` mediumint NOT NULL DEFAULT '0', + `RewardFactionValue3` int NOT NULL DEFAULT '0', + `RewardFactionOverride3` int NOT NULL DEFAULT '0', `RewardFactionID4` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', - `RewardFactionValue4` mediumint NOT NULL DEFAULT '0', - `RewardFactionOverride4` mediumint NOT NULL DEFAULT '0', + `RewardFactionValue4` int NOT NULL DEFAULT '0', + `RewardFactionOverride4` int NOT NULL DEFAULT '0', `RewardFactionID5` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', - `RewardFactionValue5` mediumint NOT NULL DEFAULT '0', - `RewardFactionOverride5` mediumint NOT NULL DEFAULT '0', + `RewardFactionValue5` int NOT NULL DEFAULT '0', + `RewardFactionOverride5` int NOT NULL DEFAULT '0', `TimeAllowed` int unsigned NOT NULL DEFAULT '0', `AllowableRaces` smallint unsigned NOT NULL DEFAULT '0', - `LogTitle` text, - `LogDescription` text, - `QuestDescription` text, - `AreaDescription` text, - `QuestCompletionLog` text, - `RequiredNpcOrGo1` mediumint NOT NULL DEFAULT '0', - `RequiredNpcOrGo2` mediumint NOT NULL DEFAULT '0', - `RequiredNpcOrGo3` mediumint NOT NULL DEFAULT '0', - `RequiredNpcOrGo4` mediumint NOT NULL DEFAULT '0', + `LogTitle` mediumtext COLLATE utf8mb4_unicode_ci, + `LogDescription` mediumtext COLLATE utf8mb4_unicode_ci, + `QuestDescription` mediumtext COLLATE utf8mb4_unicode_ci, + `AreaDescription` mediumtext COLLATE utf8mb4_unicode_ci, + `QuestCompletionLog` mediumtext COLLATE utf8mb4_unicode_ci, + `RequiredNpcOrGo1` int NOT NULL DEFAULT '0', + `RequiredNpcOrGo2` int NOT NULL DEFAULT '0', + `RequiredNpcOrGo3` int NOT NULL DEFAULT '0', + `RequiredNpcOrGo4` int NOT NULL DEFAULT '0', `RequiredNpcOrGoCount1` smallint unsigned NOT NULL DEFAULT '0', `RequiredNpcOrGoCount2` smallint unsigned NOT NULL DEFAULT '0', `RequiredNpcOrGoCount3` smallint unsigned NOT NULL DEFAULT '0', `RequiredNpcOrGoCount4` smallint unsigned NOT NULL DEFAULT '0', - `RequiredItemId1` mediumint unsigned NOT NULL DEFAULT '0', - `RequiredItemId2` mediumint unsigned NOT NULL DEFAULT '0', - `RequiredItemId3` mediumint unsigned NOT NULL DEFAULT '0', - `RequiredItemId4` mediumint unsigned NOT NULL DEFAULT '0', - `RequiredItemId5` mediumint unsigned NOT NULL DEFAULT '0', - `RequiredItemId6` mediumint unsigned NOT NULL DEFAULT '0', + `RequiredItemId1` int unsigned NOT NULL DEFAULT '0', + `RequiredItemId2` int unsigned NOT NULL DEFAULT '0', + `RequiredItemId3` int unsigned NOT NULL DEFAULT '0', + `RequiredItemId4` int unsigned NOT NULL DEFAULT '0', + `RequiredItemId5` int unsigned NOT NULL DEFAULT '0', + `RequiredItemId6` int unsigned NOT NULL DEFAULT '0', `RequiredItemCount1` smallint unsigned NOT NULL DEFAULT '0', `RequiredItemCount2` smallint unsigned NOT NULL DEFAULT '0', `RequiredItemCount3` smallint unsigned NOT NULL DEFAULT '0', @@ -2845,13 +2851,13 @@ CREATE TABLE `quest_template` ( `RequiredItemCount5` smallint unsigned NOT NULL DEFAULT '0', `RequiredItemCount6` smallint unsigned NOT NULL DEFAULT '0', `Unknown0` tinyint unsigned NOT NULL DEFAULT '0', - `ObjectiveText1` text, - `ObjectiveText2` text, - `ObjectiveText3` text, - `ObjectiveText4` text, + `ObjectiveText1` mediumtext COLLATE utf8mb4_unicode_ci, + `ObjectiveText2` mediumtext COLLATE utf8mb4_unicode_ci, + `ObjectiveText3` mediumtext COLLATE utf8mb4_unicode_ci, + `ObjectiveText4` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Quest System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Quest System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2862,26 +2868,26 @@ DROP TABLE IF EXISTS `quest_template_addon`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_template_addon` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', `MaxLevel` tinyint unsigned NOT NULL DEFAULT '0', `AllowableClasses` int unsigned NOT NULL DEFAULT '0', - `SourceSpellID` mediumint unsigned NOT NULL DEFAULT '0', - `PrevQuestID` mediumint NOT NULL DEFAULT '0', - `NextQuestID` mediumint unsigned NOT NULL DEFAULT '0', - `ExclusiveGroup` mediumint NOT NULL DEFAULT '0', - `BreadcrumbForQuestId` mediumint NOT NULL DEFAULT '0', - `RewardMailTemplateID` mediumint unsigned NOT NULL DEFAULT '0', + `SourceSpellID` int unsigned NOT NULL DEFAULT '0', + `PrevQuestID` int NOT NULL DEFAULT '0', + `NextQuestID` int unsigned NOT NULL DEFAULT '0', + `ExclusiveGroup` int NOT NULL DEFAULT '0', + `BreadcrumbForQuestId` int NOT NULL DEFAULT '0', + `RewardMailTemplateID` int unsigned NOT NULL DEFAULT '0', `RewardMailDelay` int unsigned NOT NULL DEFAULT '0', `RequiredSkillID` smallint unsigned NOT NULL DEFAULT '0', `RequiredSkillPoints` smallint unsigned NOT NULL DEFAULT '0', `RequiredMinRepFaction` smallint unsigned NOT NULL DEFAULT '0', `RequiredMaxRepFaction` smallint unsigned NOT NULL DEFAULT '0', - `RequiredMinRepValue` mediumint NOT NULL DEFAULT '0', - `RequiredMaxRepValue` mediumint NOT NULL DEFAULT '0', + `RequiredMinRepValue` int NOT NULL DEFAULT '0', + `RequiredMaxRepValue` int NOT NULL DEFAULT '0', `ProvidedItemCount` tinyint unsigned NOT NULL DEFAULT '0', `SpecialFlags` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2892,20 +2898,20 @@ DROP TABLE IF EXISTS `quest_template_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_template_locale` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) NOT NULL, - `Title` text, - `Details` text, - `Objectives` text, - `EndText` text, - `CompletedText` text, - `ObjectiveText1` text, - `ObjectiveText2` text, - `ObjectiveText3` text, - `ObjectiveText4` text, + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Title` mediumtext COLLATE utf8mb4_unicode_ci, + `Details` mediumtext COLLATE utf8mb4_unicode_ci, + `Objectives` mediumtext COLLATE utf8mb4_unicode_ci, + `EndText` mediumtext COLLATE utf8mb4_unicode_ci, + `CompletedText` mediumtext COLLATE utf8mb4_unicode_ci, + `ObjectiveText1` mediumtext COLLATE utf8mb4_unicode_ci, + `ObjectiveText2` mediumtext COLLATE utf8mb4_unicode_ci, + `ObjectiveText3` mediumtext COLLATE utf8mb4_unicode_ci, + `ObjectiveText4` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`ID`,`locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2916,18 +2922,18 @@ DROP TABLE IF EXISTS `reference_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reference_loot_template` ( - `Entry` mediumint unsigned NOT NULL DEFAULT '0', - `Item` mediumint unsigned NOT NULL DEFAULT '0', - `Reference` mediumint unsigned NOT NULL DEFAULT '0', + `Entry` int unsigned NOT NULL DEFAULT '0', + `Item` int unsigned NOT NULL DEFAULT '0', + `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) DEFAULT NULL, + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2938,7 +2944,7 @@ DROP TABLE IF EXISTS `reputation_reward_rate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reputation_reward_rate` ( - `faction` mediumint unsigned NOT NULL DEFAULT '0', + `faction` int unsigned NOT NULL DEFAULT '0', `quest_rate` float NOT NULL DEFAULT '1', `quest_daily_rate` float NOT NULL DEFAULT '1', `quest_weekly_rate` float NOT NULL DEFAULT '1', @@ -2947,7 +2953,7 @@ CREATE TABLE `reputation_reward_rate` ( `creature_rate` float NOT NULL DEFAULT '1', `spell_rate` float NOT NULL DEFAULT '1', PRIMARY KEY (`faction`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2972,7 +2978,7 @@ CREATE TABLE `reputation_spillover_template` ( `rate_4` float NOT NULL DEFAULT '0', `rank_4` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`faction`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='Reputation spillover reputation gain'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Reputation spillover reputation gain'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2990,7 +2996,7 @@ CREATE TABLE `script_spline_chain_meta` ( `msUntilNext` int unsigned NOT NULL, `velocity` float unsigned DEFAULT '0', PRIMARY KEY (`entry`,`chainId`,`splineId`) USING BTREE -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3009,7 +3015,7 @@ CREATE TABLE `script_spline_chain_waypoints` ( `y` float NOT NULL, `z` float NOT NULL, PRIMARY KEY (`entry`,`chainId`,`splineId`,`wpId`) USING BTREE -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3020,15 +3026,15 @@ DROP TABLE IF EXISTS `script_waypoint`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `script_waypoint` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry', - `pointid` mediumint unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry', + `pointid` int unsigned NOT NULL DEFAULT '0', `location_x` float NOT NULL DEFAULT '0', `location_y` float NOT NULL DEFAULT '0', `location_z` float NOT NULL DEFAULT '0', `waittime` int unsigned NOT NULL DEFAULT '0' COMMENT 'waittime in millisecs', - `point_comment` text, + `point_comment` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`,`pointid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Script Creature waypoints'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3039,12 +3045,12 @@ DROP TABLE IF EXISTS `skill_discovery_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `skill_discovery_template` ( - `spellId` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the discoverable spell', - `reqSpell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'spell requirement', + `spellId` int unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the discoverable spell', + `reqSpell` int unsigned NOT NULL DEFAULT '0' COMMENT 'spell requirement', `reqSkillValue` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'skill points requirement', `chance` float NOT NULL DEFAULT '0' COMMENT 'chance to discover', PRIMARY KEY (`spellId`,`reqSpell`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Skill Discovery System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Skill Discovery System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3055,12 +3061,12 @@ DROP TABLE IF EXISTS `skill_extra_item_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `skill_extra_item_template` ( - `spellId` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell', - `requiredSpecialization` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id', + `spellId` int unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell', + `requiredSpecialization` int unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id', `additionalCreateChance` float NOT NULL DEFAULT '0' COMMENT 'chance to create add', `additionalMaxNum` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'max num of adds', PRIMARY KEY (`spellId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Skill Specialization System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Skill Specialization System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3071,10 +3077,10 @@ DROP TABLE IF EXISTS `skill_fishing_base_level`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `skill_fishing_base_level` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Area identifier', + `entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'Area identifier', `skill` smallint NOT NULL DEFAULT '0' COMMENT 'Base skill level requirement', PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Fishing system'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Fishing system'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3085,12 +3091,12 @@ DROP TABLE IF EXISTS `skill_perfect_item_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `skill_perfect_item_template` ( - `spellId` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell', - `requiredSpecialization` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id', + `spellId` int unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell', + `requiredSpecialization` int unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id', `perfectCreateChance` float NOT NULL DEFAULT '0' COMMENT 'chance to create the perfect item instead', - `perfectItemType` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'perfect item type to create instead', + `perfectItemType` int unsigned NOT NULL DEFAULT '0' COMMENT 'perfect item type to create instead', PRIMARY KEY (`spellId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Crafting Perfection System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Crafting Perfection System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3101,18 +3107,18 @@ DROP TABLE IF EXISTS `skinning_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `skinning_loot_template` ( - `Entry` mediumint unsigned NOT NULL DEFAULT '0', - `Item` mediumint unsigned NOT NULL DEFAULT '0', - `Reference` mediumint unsigned NOT NULL DEFAULT '0', + `Entry` int unsigned NOT NULL DEFAULT '0', + `Item` int unsigned NOT NULL DEFAULT '0', + `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) DEFAULT NULL, + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3152,9 +3158,9 @@ CREATE TABLE `smart_scripts` ( `target_y` float NOT NULL DEFAULT '0', `target_z` float NOT NULL DEFAULT '0', `target_o` float NOT NULL DEFAULT '0', - `comment` text NOT NULL COMMENT 'Event Comment', + `comment` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Event Comment', PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3169,7 +3175,7 @@ CREATE TABLE `spawn_group` ( `spawnType` tinyint unsigned NOT NULL, `spawnId` int unsigned NOT NULL, PRIMARY KEY (`groupId`,`spawnType`,`spawnId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3181,10 +3187,10 @@ DROP TABLE IF EXISTS `spawn_group_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spawn_group_template` ( `groupId` int unsigned NOT NULL, - `groupName` varchar(100) NOT NULL, + `groupName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `groupFlags` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`groupId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3195,18 +3201,18 @@ DROP TABLE IF EXISTS `spell_area`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_area` ( - `spell` mediumint unsigned NOT NULL DEFAULT '0', - `area` mediumint unsigned NOT NULL DEFAULT '0', - `quest_start` mediumint unsigned NOT NULL DEFAULT '0', - `quest_end` mediumint unsigned NOT NULL DEFAULT '0', - `aura_spell` mediumint NOT NULL DEFAULT '0', - `racemask` mediumint unsigned NOT NULL DEFAULT '0', + `spell` int unsigned NOT NULL DEFAULT '0', + `area` int unsigned NOT NULL DEFAULT '0', + `quest_start` int unsigned NOT NULL DEFAULT '0', + `quest_end` int unsigned NOT NULL DEFAULT '0', + `aura_spell` int NOT NULL DEFAULT '0', + `racemask` int unsigned NOT NULL DEFAULT '0', `gender` tinyint unsigned NOT NULL DEFAULT '2', `autocast` tinyint unsigned NOT NULL DEFAULT '0', `quest_start_status` int NOT NULL DEFAULT '64', `quest_end_status` int NOT NULL DEFAULT '11', PRIMARY KEY (`spell`,`area`,`quest_start`,`aura_spell`,`racemask`,`gender`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3217,14 +3223,14 @@ DROP TABLE IF EXISTS `spell_bonus_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_bonus_data` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', `direct_bonus` float NOT NULL DEFAULT '0', `dot_bonus` float NOT NULL DEFAULT '0', `ap_bonus` float NOT NULL DEFAULT '0', `ap_dot_bonus` float NOT NULL DEFAULT '0', - `comments` varchar(255) DEFAULT NULL, + `comments` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3238,7 +3244,7 @@ CREATE TABLE `spell_custom_attr` ( `entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'spell id', `attributes` int unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCustomAttributes', PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='SpellInfo custom attributes'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='SpellInfo custom attributes'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3331,7 +3337,7 @@ CREATE TABLE `spell_dbc` ( `EffectSpellClassMaskC1` int unsigned NOT NULL DEFAULT '0', `EffectSpellClassMaskC2` int unsigned NOT NULL DEFAULT '0', `EffectSpellClassMaskC3` int unsigned NOT NULL DEFAULT '0', - `SpellName` varchar(100) DEFAULT NULL, + `SpellName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `MaxTargetLevel` int unsigned NOT NULL DEFAULT '0', `SpellFamilyName` int unsigned NOT NULL DEFAULT '0', `SpellFamilyFlags1` int unsigned NOT NULL DEFAULT '0', @@ -3346,7 +3352,7 @@ CREATE TABLE `spell_dbc` ( `AreaGroupId` int NOT NULL DEFAULT '0', `SchoolMask` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`Id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Custom spell.dbc entries'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Custom spell.dbc entries'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3363,7 +3369,7 @@ CREATE TABLE `spell_enchant_proc_data` ( `HitMask` int unsigned NOT NULL DEFAULT '0', `AttributesMask` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`EnchantID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant proc data'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell enchant proc data'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3377,7 +3383,7 @@ CREATE TABLE `spell_group` ( `id` int unsigned NOT NULL DEFAULT '0', `spell_id` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`spell_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Spell System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3391,7 +3397,7 @@ CREATE TABLE `spell_group_stack_rules` ( `group_id` int unsigned NOT NULL DEFAULT '0', `stack_rule` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`group_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3406,7 +3412,7 @@ CREATE TABLE `spell_learn_spell` ( `SpellID` int unsigned NOT NULL DEFAULT '0', `Active` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`SpellID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Item System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3417,12 +3423,12 @@ DROP TABLE IF EXISTS `spell_linked_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_linked_spell` ( - `spell_trigger` mediumint NOT NULL, - `spell_effect` mediumint NOT NULL DEFAULT '0', + `spell_trigger` int NOT NULL, + `spell_effect` int NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', - `comment` text NOT NULL, + `comment` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, UNIQUE KEY `trigger_effect_type` (`spell_trigger`,`spell_effect`,`type`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Spell System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3433,18 +3439,18 @@ DROP TABLE IF EXISTS `spell_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_loot_template` ( - `Entry` mediumint unsigned NOT NULL DEFAULT '0', - `Item` mediumint unsigned NOT NULL DEFAULT '0', - `Reference` mediumint unsigned NOT NULL DEFAULT '0', + `Entry` int unsigned NOT NULL DEFAULT '0', + `Item` int unsigned NOT NULL DEFAULT '0', + `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) DEFAULT NULL, + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3455,12 +3461,12 @@ DROP TABLE IF EXISTS `spell_pet_auras`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_pet_auras` ( - `spell` mediumint unsigned NOT NULL COMMENT 'dummy spell id', + `spell` int unsigned NOT NULL COMMENT 'dummy spell id', `effectId` tinyint unsigned NOT NULL DEFAULT '0', - `pet` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'pet id; 0 = all', - `aura` mediumint unsigned NOT NULL COMMENT 'pet aura id', + `pet` int unsigned NOT NULL DEFAULT '0' COMMENT 'pet id; 0 = all', + `aura` int unsigned NOT NULL COMMENT 'pet aura id', PRIMARY KEY (`spell`,`effectId`,`pet`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3488,7 +3494,7 @@ CREATE TABLE `spell_proc` ( `Cooldown` int unsigned NOT NULL DEFAULT '0', `Charges` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`SpellId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3504,7 +3510,7 @@ CREATE TABLE `spell_ranks` ( `rank` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`first_spell_id`,`rank`), UNIQUE KEY `spell_id` (`spell_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Spell Rank Data'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell Rank Data'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3515,10 +3521,10 @@ DROP TABLE IF EXISTS `spell_required`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_required` ( - `spell_id` mediumint NOT NULL DEFAULT '0', - `req_spell` mediumint NOT NULL DEFAULT '0', + `spell_id` int NOT NULL DEFAULT '0', + `req_spell` int NOT NULL DEFAULT '0', PRIMARY KEY (`spell_id`,`req_spell`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Spell Additinal Data'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell Additinal Data'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3530,9 +3536,9 @@ DROP TABLE IF EXISTS `spell_script_names`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_script_names` ( `spell_id` int NOT NULL, - `ScriptName` char(64) NOT NULL, + `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL, UNIQUE KEY `spell_id` (`spell_id`,`ScriptName`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3543,19 +3549,19 @@ DROP TABLE IF EXISTS `spell_scripts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_scripts` ( - `id` mediumint unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL DEFAULT '0', `effIndex` tinyint unsigned NOT NULL DEFAULT '0', `delay` int unsigned NOT NULL DEFAULT '0', - `command` mediumint unsigned NOT NULL DEFAULT '0', - `datalong` mediumint unsigned NOT NULL DEFAULT '0', + `command` int unsigned NOT NULL DEFAULT '0', + `datalong` int unsigned NOT NULL DEFAULT '0', `datalong2` int unsigned NOT NULL DEFAULT '0', `dataint` int NOT NULL DEFAULT '0', `x` float NOT NULL DEFAULT '0', `y` float NOT NULL DEFAULT '0', `z` float NOT NULL DEFAULT '0', `o` float NOT NULL DEFAULT '0', - `Comment` varchar(255) NOT NULL DEFAULT '' -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3566,7 +3572,7 @@ DROP TABLE IF EXISTS `spell_target_position`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_target_position` ( - `ID` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', + `ID` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', `EffectIndex` tinyint unsigned NOT NULL DEFAULT '0', `MapID` smallint unsigned NOT NULL DEFAULT '0', `PositionX` float NOT NULL DEFAULT '0', @@ -3575,7 +3581,7 @@ CREATE TABLE `spell_target_position` ( `Orientation` float NOT NULL DEFAULT '0', `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`ID`,`EffectIndex`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Spell System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3586,12 +3592,12 @@ DROP TABLE IF EXISTS `spell_threat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_threat` ( - `entry` mediumint unsigned NOT NULL, + `entry` int unsigned NOT NULL, `flatMod` int DEFAULT NULL, `pctMod` float NOT NULL DEFAULT '1' COMMENT 'threat multiplier for damage/healing', `apPctMod` float NOT NULL DEFAULT '0' COMMENT 'additional threat bonus from attack power', PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3608,7 +3614,7 @@ CREATE TABLE `spelldifficulty_dbc` ( `spellid2` int unsigned NOT NULL DEFAULT '0', `spellid3` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3621,11 +3627,11 @@ DROP TABLE IF EXISTS `trainer`; CREATE TABLE `trainer` ( `Id` int unsigned NOT NULL DEFAULT '0', `Type` tinyint unsigned NOT NULL DEFAULT '2', - `Requirement` mediumint unsigned NOT NULL DEFAULT '0', - `Greeting` text, + `Requirement` int unsigned NOT NULL DEFAULT '0', + `Greeting` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`Id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3637,11 +3643,11 @@ DROP TABLE IF EXISTS `trainer_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trainer_locale` ( `Id` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) NOT NULL, - `Greeting_lang` text, + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Greeting_lang` mediumtext COLLATE utf8mb4_unicode_ci, `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`Id`,`locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3663,7 +3669,7 @@ CREATE TABLE `trainer_spell` ( `ReqLevel` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint DEFAULT '0', PRIMARY KEY (`TrainerId`,`SpellId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3675,12 +3681,12 @@ DROP TABLE IF EXISTS `transports`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `transports` ( `guid` int unsigned NOT NULL AUTO_INCREMENT, - `entry` mediumint unsigned NOT NULL DEFAULT '0', - `name` text, - `ScriptName` char(64) NOT NULL DEFAULT '', + `entry` int unsigned NOT NULL DEFAULT '0', + `name` mediumtext COLLATE utf8mb4_unicode_ci, + `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`guid`), UNIQUE KEY `idx_entry` (`entry`) -) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Transports'; +) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Transports'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3691,18 +3697,18 @@ DROP TABLE IF EXISTS `trinity_string`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trinity_string` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0', - `content_default` text NOT NULL, - `content_loc1` text, - `content_loc2` text, - `content_loc3` text, - `content_loc4` text, - `content_loc5` text, - `content_loc6` text, - `content_loc7` text, - `content_loc8` text, + `entry` int unsigned NOT NULL DEFAULT '0', + `content_default` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, + `content_loc1` mediumtext COLLATE utf8mb4_unicode_ci, + `content_loc2` mediumtext COLLATE utf8mb4_unicode_ci, + `content_loc3` mediumtext COLLATE utf8mb4_unicode_ci, + `content_loc4` mediumtext COLLATE utf8mb4_unicode_ci, + `content_loc5` mediumtext COLLATE utf8mb4_unicode_ci, + `content_loc6` mediumtext COLLATE utf8mb4_unicode_ci, + `content_loc7` mediumtext COLLATE utf8mb4_unicode_ci, + `content_loc8` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3713,13 +3719,13 @@ DROP TABLE IF EXISTS `updates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates` ( - `name` varchar(200) NOT NULL COMMENT 'filename with extension of the update.', - `hash` char(40) DEFAULT '' COMMENT 'sha1 hash of the sql file.', - `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', + `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', + `hash` char(40) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', + `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.', `speed` int unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.', PRIMARY KEY (`name`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='List of all applied updates in this database.'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of all applied updates in this database.'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3730,10 +3736,10 @@ DROP TABLE IF EXISTS `updates_include`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates_include` ( - `path` varchar(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', - `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', + `path` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', + `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', PRIMARY KEY (`path`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='List of directories where we want to include sql updates.'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of directories where we want to include sql updates.'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3744,15 +3750,15 @@ DROP TABLE IF EXISTS `vehicle_accessory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `vehicle_accessory` ( - `guid` mediumint unsigned NOT NULL DEFAULT '0', - `accessory_entry` mediumint unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0', + `accessory_entry` int unsigned NOT NULL DEFAULT '0', `seat_id` tinyint NOT NULL DEFAULT '0', `minion` tinyint unsigned NOT NULL DEFAULT '0', - `description` text NOT NULL, + `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `summontype` tinyint unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType', `summontimer` int unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes', PRIMARY KEY (`guid`,`seat_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3771,7 +3777,7 @@ CREATE TABLE `vehicle_seat_addon` ( `ExitParamO` float DEFAULT '0', `ExitParamValue` tinyint(1) DEFAULT '0', PRIMARY KEY (`SeatEntry`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3785,7 +3791,7 @@ CREATE TABLE `vehicle_template` ( `creatureId` int unsigned NOT NULL, `despawnDelayMs` int NOT NULL DEFAULT '0', PRIMARY KEY (`creatureId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3796,15 +3802,15 @@ DROP TABLE IF EXISTS `vehicle_template_accessory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `vehicle_template_accessory` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0', - `accessory_entry` mediumint unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', + `accessory_entry` int unsigned NOT NULL DEFAULT '0', `seat_id` tinyint NOT NULL DEFAULT '0', `minion` tinyint unsigned NOT NULL DEFAULT '0', - `description` text NOT NULL, + `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `summontype` tinyint unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType', `summontimer` int unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes', PRIMARY KEY (`entry`,`seat_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3815,12 +3821,12 @@ DROP TABLE IF EXISTS `version`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `version` ( - `core_version` varchar(255) NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.', - `core_revision` varchar(120) DEFAULT NULL, - `db_version` varchar(120) DEFAULT NULL COMMENT 'Version of world DB.', + `core_version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.', + `core_revision` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `db_version` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Version of world DB.', `cache_id` int DEFAULT '0', PRIMARY KEY (`core_version`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Version Notes'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Version Notes'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3917,14 +3923,14 @@ DROP TABLE IF EXISTS `warden_checks`; CREATE TABLE `warden_checks` ( `id` smallint unsigned NOT NULL AUTO_INCREMENT, `type` tinyint unsigned DEFAULT NULL, - `str` varchar(170) DEFAULT NULL, + `str` varchar(170) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` int unsigned DEFAULT NULL, `length` tinyint unsigned DEFAULT NULL, - `comment` varchar(50) DEFAULT NULL, + `comment` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `data` binary(24) DEFAULT NULL, `result` varbinary(24) DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=MyISAM AUTO_INCREMENT=791 DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB AUTO_INCREMENT=791 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3936,7 +3942,7 @@ DROP TABLE IF EXISTS `waypoint_data`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `waypoint_data` ( `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Creature GUID', - `point` mediumint unsigned NOT NULL DEFAULT '0', + `point` int unsigned NOT NULL DEFAULT '0', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', @@ -3947,7 +3953,7 @@ CREATE TABLE `waypoint_data` ( `action_chance` smallint NOT NULL DEFAULT '100', `wpguid` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`point`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3969,9 +3975,9 @@ CREATE TABLE `waypoint_scripts` ( `z` float NOT NULL DEFAULT '0', `o` float NOT NULL DEFAULT '0', `guid` int NOT NULL DEFAULT '0', - `Comment` varchar(255) NOT NULL DEFAULT '', + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`guid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3982,16 +3988,16 @@ DROP TABLE IF EXISTS `waypoints`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `waypoints` ( - `entry` mediumint unsigned NOT NULL DEFAULT '0', - `pointid` mediumint unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', + `pointid` int unsigned NOT NULL DEFAULT '0', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float DEFAULT NULL, `delay` int unsigned NOT NULL DEFAULT '0', - `point_comment` text, + `point_comment` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`,`pointid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Creature waypoints'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature waypoints'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -4061,4 +4067,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-10-17 9:02:33 +-- Dump completed on 2023-01-16 11:08:18 -- cgit v1.2.3