aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2023-06-14 19:37:17 +0000
committerTDB Release <tdb-release@build.bot>2023-06-14 19:37:17 +0000
commit40d1f7a2e8fa54b3c9432b4432d6df968ec60cc4 (patch)
treec6f405d6af8b24fe8b30807e4d4562a8d7ffffb9 /sql/base
parentd1c6b9d253faa61246f04058719f7f3c07548165 (diff)
TDB 335.23061 - 2023/06/14TDB335.23061
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/auth_database.sql19
-rw-r--r--sql/base/characters_database.sql21
-rw-r--r--sql/base/dev/world_database.sql482
3 files changed, 262 insertions, 260 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 876cee1e60a..0018c699df4 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,13 +1,13 @@
--- MySQL dump 10.13 Distrib 8.0.31, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.33, for Linux (x86_64)
--
-- Host: localhost Database: auth
-- ------------------------------------------------------
--- Server version 8.0.31-0ubuntu0.20.04.2
+-- Server version 8.0.33-0ubuntu0.20.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!50503 SET NAMES utf8mb4 */;
+/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
@@ -2005,9 +2005,10 @@ INSERT INTO `updates` VALUES
('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),
('2023_01_16_00_auth.sql','8431F03DE6A036BEED6682C21F4B67F384390905','ARCHIVED','2023-01-16 11:06:30',0),
-('2023_02_05_00_auth.sql','DC8A2046EB4201D55342C541A0E9C398499E12B1','RELEASED','2023-02-05 14:50:30',0),
-('2023_02_05_01_auth.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','RELEASED','2023-02-05 15:58:32',0),
-('2023_05_05_00_auth.sql','DEEB1D5533658E3479FC3C988EF4B9816C511BC3','RELEASED','2023-05-07 11:52:00',0);
+('2023_02_05_00_auth.sql','DC8A2046EB4201D55342C541A0E9C398499E12B1','ARCHIVED','2023-02-05 14:50:30',0),
+('2023_02_05_01_auth.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','ARCHIVED','2023-02-05 15:58:32',0),
+('2023_05_05_00_auth.sql','DEEB1D5533658E3479FC3C988EF4B9816C511BC3','ARCHIVED','2023-05-07 11:52:00',0),
+('2023_06_14_00_auth.sql','BB8A7EB214F4F3632C4F54EA596CB7C8FBA305D5','ARCHIVED','2023-06-14 19:34:24',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2032,9 +2033,9 @@ CREATE TABLE `updates_include` (
LOCK TABLES `updates_include` WRITE;
/*!40000 ALTER TABLE `updates_include` DISABLE KEYS */;
INSERT INTO `updates_include` VALUES
-('$/sql/updates/auth','RELEASED'),
('$/sql/custom/auth','RELEASED'),
-('$/sql/old/3.3.5a/auth','ARCHIVED');
+('$/sql/old/3.3.5a/auth','ARCHIVED'),
+('$/sql/updates/auth','RELEASED');
/*!40000 ALTER TABLE `updates_include` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2146,4 +2147,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 2023-01-16 11:08:17
+-- Dump completed on 2023-06-14 19:34:37
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index b2dc3eaa1cf..7edbe051fa2 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1,13 +1,13 @@
--- MySQL dump 10.13 Distrib 8.0.31, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.33, for Linux (x86_64)
--
-- Host: localhost Database: characters
-- ------------------------------------------------------
--- Server version 8.0.31-0ubuntu0.20.04.2
+-- Server version 8.0.33-0ubuntu0.20.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!50503 SET NAMES utf8mb4 */;
+/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
@@ -2604,8 +2604,8 @@ INSERT INTO `updates` VALUES
('2015_03_20_01_characters.sql','894F08B70449A5481FFAF394EE5571D7FC4D8A3A','ARCHIVED','2015-03-21 21:44:15',0),
('2015_03_20_02_characters.sql','97D7BE0CAADC79F3F11B9FD296B8C6CD40FE593B','ARCHIVED','2015-03-21 21:44:51',0),
('2015_06_26_00_characters_335.sql','C2CC6E50AFA1ACCBEBF77CC519AAEB09F3BBAEBC','ARCHIVED','2015-07-13 23:49:22',0),
-('2015_09_28_00_characters_335.sql','F8682A431D50E54BDC4AC0E7DBED21AE8AAB6AD4','ARCHIVED','2015-09-28 21:00:00',0),
('2015_08_26_00_characters_335.sql','C7D6A3A00FECA3EBFF1E71744CA40D3076582374','ARCHIVED','2015-08-26 21:00:00',0),
+('2015_09_28_00_characters_335.sql','F8682A431D50E54BDC4AC0E7DBED21AE8AAB6AD4','ARCHIVED','2015-09-28 21:00:00',0),
('2015_10_06_00_characters.sql','16842FDD7E8547F2260D3312F53EFF8761EFAB35','ARCHIVED','2015-10-06 16:06:38',0),
('2015_10_07_00_characters.sql','E15AB463CEBE321001D7BFDEA4B662FF618728FD','ARCHIVED','2015-10-07 23:32:00',0),
('2015_10_12_00_characters.sql','D6F9927BDED72AD0A81D6EC2C6500CBC34A39FA2','ARCHIVED','2015-10-12 15:35:47',0),
@@ -2678,9 +2678,10 @@ INSERT INTO `updates` VALUES
('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),
('2023_01_16_00_characters.sql','2667390C8E0EC1E5CDE16784BFCD8F8749C7D73E','ARCHIVED','2023-01-16 11:06:30',0),
-('2023_02_05_00_characters.sql','DD3F2181CC472A040EC4AE49EBB057C1FAA5BE10','RELEASED','2023-01-16 14:51:30',0),
-('2023_02_05_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','RELEASED','2023-02-05 15:58:32',0),
-('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','RELEASED','2023-05-19 18:40:42',0);
+('2023_02_05_00_characters.sql','DD3F2181CC472A040EC4AE49EBB057C1FAA5BE10','ARCHIVED','2023-01-16 14:51:30',0),
+('2023_02_05_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','ARCHIVED','2023-02-05 15:58:32',0),
+('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','ARCHIVED','2023-05-19 18:40:42',0),
+('2023_06_14_00_characters.sql','0595B21DCFC0A04F2D8DF1F7BC018C758895DBE5','ARCHIVED','2023-06-14 19:34:24',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2705,9 +2706,9 @@ CREATE TABLE `updates_include` (
LOCK TABLES `updates_include` WRITE;
/*!40000 ALTER TABLE `updates_include` DISABLE KEYS */;
INSERT INTO `updates_include` VALUES
-('$/sql/updates/characters','RELEASED'),
('$/sql/custom/characters','RELEASED'),
-('$/sql/old/3.3.5a/characters','ARCHIVED');
+('$/sql/old/3.3.5a/characters','ARCHIVED'),
+('$/sql/updates/characters','RELEASED');
/*!40000 ALTER TABLE `updates_include` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2851,4 +2852,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2023-01-16 11:08:17
+-- Dump completed on 2023-06-14 19:34:37
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 6136160325f..15f9e206042 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.31, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.33, for Linux (x86_64)
--
-- Host: localhost Database: world
-- ------------------------------------------------------
--- Server version 8.0.31-0ubuntu0.20.04.2
+-- Server version 8.0.33-0ubuntu0.20.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -33,8 +33,8 @@ CREATE TABLE `access_requirement` (
`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,
+ `quest_failed_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`mapId`,`difficulty`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Access Requirements';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -51,7 +51,7 @@ CREATE TABLE `achievement_criteria_data` (
`type` tinyint unsigned NOT NULL DEFAULT '0',
`value1` int unsigned NOT NULL DEFAULT '0',
`value2` int unsigned NOT NULL DEFAULT '0',
- `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`criteria_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Achievment system';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -88,8 +88,8 @@ CREATE TABLE `achievement_reward` (
`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,
+ `Subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`MailTemplateID` int unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
@@ -104,9 +104,9 @@ DROP TABLE IF EXISTS `achievement_reward_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `achievement_reward_locale` (
`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,
+ `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Subject` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`ID`,`Locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -134,7 +134,7 @@ DROP TABLE IF EXISTS `areatrigger_scripts`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `areatrigger_scripts` (
`entry` int NOT NULL,
- `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -148,7 +148,7 @@ DROP TABLE IF EXISTS `areatrigger_tavern`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `areatrigger_tavern` (
`id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
- `name` mediumtext COLLATE utf8mb4_unicode_ci,
+ `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -162,13 +162,13 @@ DROP TABLE IF EXISTS `areatrigger_teleport`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `areatrigger_teleport` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `Name` mediumtext COLLATE utf8mb4_unicode_ci,
+ `Name` mediumtext CHARACTER SET utf8mb4 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',
`target_position_z` float NOT NULL DEFAULT '0',
`target_orientation` float NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`),
FULLTEXT KEY `name` (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System';
@@ -183,8 +183,8 @@ DROP TABLE IF EXISTS `battlefield_template`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `battlefield_template` (
`TypeId` tinyint unsigned NOT NULL,
- `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `comment` mediumtext COLLATE utf8mb4_unicode_ci
+ `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -207,8 +207,8 @@ CREATE TABLE `battleground_template` (
`HordeStartO` float NOT NULL,
`StartMaxDist` float NOT NULL DEFAULT '0',
`Weight` tinyint unsigned NOT NULL DEFAULT '1',
- `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `Comment` char(32) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `Comment` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -237,8 +237,8 @@ DROP TABLE IF EXISTS `broadcast_text`;
CREATE TABLE `broadcast_text` (
`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,
+ `Text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text1` longtext CHARACTER SET utf8mb4 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',
@@ -262,10 +262,10 @@ DROP TABLE IF EXISTS `broadcast_text_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `broadcast_text_locale` (
`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',
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -278,8 +278,8 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `help` longtext COLLATE utf8mb4_unicode_ci,
+ `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `help` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Chat System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -305,8 +305,8 @@ CREATE TABLE `conditions` (
`NegativeCondition` tinyint unsigned NOT NULL DEFAULT '0',
`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,
+ `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Condition System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -341,7 +341,7 @@ CREATE TABLE `creature` (
`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) COLLATE utf8mb4_unicode_ci DEFAULT '',
+ `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
`VerifiedBuild` int DEFAULT '0',
PRIMARY KEY (`guid`),
KEY `idx_map` (`map`),
@@ -368,7 +368,7 @@ CREATE TABLE `creature_addon` (
`PvPFlags` tinyint unsigned NOT NULL DEFAULT '0',
`emote` int unsigned NOT NULL DEFAULT '0',
`visibilityDistanceType` tinyint unsigned NOT NULL DEFAULT '0',
- `auras` mediumtext COLLATE utf8mb4_unicode_ci,
+ `auras` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -393,7 +393,7 @@ 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` mediumtext COLLATE utf8mb4_unicode_ci,
+ `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`level`,`class`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -425,7 +425,7 @@ CREATE TABLE `creature_equip_template` (
`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',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`CreatureID`,`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -466,7 +466,7 @@ CREATE TABLE `creature_loot_template` (
`GroupId` tinyint unsigned NOT NULL DEFAULT '0',
`MinCount` tinyint unsigned NOT NULL DEFAULT '1',
`MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`Entry`,`Item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -570,7 +570,7 @@ CREATE TABLE `creature_questitem` (
`CreatureEntry` int unsigned NOT NULL DEFAULT '0',
`Idx` int unsigned NOT NULL DEFAULT '0',
`ItemId` int unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`CreatureEntry`,`Idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -607,7 +607,7 @@ CREATE TABLE `creature_summon_groups` (
`orientation` float NOT NULL DEFAULT '0',
`summonType` tinyint unsigned NOT NULL DEFAULT '0',
`summonTime` int unsigned NOT NULL DEFAULT '0',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -629,9 +629,9 @@ CREATE TABLE `creature_template` (
`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,
+ `name` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
+ `subname` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `IconName` char(100) CHARACTER SET utf8mb4 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',
@@ -661,7 +661,7 @@ CREATE TABLE `creature_template` (
`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 '',
+ `AIName` char(64) CHARACTER SET utf8mb4 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',
@@ -675,8 +675,8 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `VerifiedBuild` smallint DEFAULT '0',
+ `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`entry`),
KEY `idx_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System';
@@ -701,7 +701,7 @@ CREATE TABLE `creature_template_addon` (
`PvPFlags` tinyint unsigned NOT NULL DEFAULT '0',
`emote` int unsigned NOT NULL DEFAULT '0',
`visibilityDistanceType` tinyint unsigned NOT NULL DEFAULT '0',
- `auras` mediumtext COLLATE utf8mb4_unicode_ci,
+ `auras` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -715,10 +715,10 @@ DROP TABLE IF EXISTS `creature_template_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `creature_template_locale` (
`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',
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Title` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`entry`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -754,7 +754,7 @@ CREATE TABLE `creature_template_resistance` (
`CreatureID` int unsigned NOT NULL,
`School` tinyint unsigned NOT NULL,
`Resistance` smallint DEFAULT NULL,
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`CreatureID`,`School`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -770,7 +770,7 @@ CREATE TABLE `creature_template_spell` (
`CreatureID` int unsigned NOT NULL,
`Index` tinyint unsigned NOT NULL DEFAULT '0',
`Spell` int unsigned NOT NULL,
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`CreatureID`,`Index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -786,7 +786,7 @@ CREATE TABLE `creature_text` (
`CreatureID` int unsigned NOT NULL DEFAULT '0',
`GroupID` tinyint unsigned NOT NULL DEFAULT '0',
`ID` tinyint unsigned NOT NULL DEFAULT '0',
- `Text` longtext COLLATE utf8mb4_unicode_ci,
+ `Text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Type` tinyint unsigned NOT NULL DEFAULT '0',
`Language` tinyint NOT NULL DEFAULT '0',
`Probability` float unsigned NOT NULL DEFAULT '0',
@@ -795,7 +795,7 @@ CREATE TABLE `creature_text` (
`Sound` int unsigned NOT NULL DEFAULT '0',
`BroadcastTextId` int NOT NULL DEFAULT '0',
`TextRange` tinyint unsigned NOT NULL DEFAULT '0',
- `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
+ `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
PRIMARY KEY (`CreatureID`,`GroupID`,`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -811,8 +811,8 @@ CREATE TABLE `creature_text_locale` (
`CreatureID` int unsigned NOT NULL DEFAULT '0',
`GroupID` tinyint unsigned NOT NULL DEFAULT '0',
`ID` tinyint unsigned NOT NULL DEFAULT '0',
- `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
- `Text` mediumtext COLLATE utf8mb4_unicode_ci,
+ `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`CreatureID`,`GroupID`,`ID`,`Locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -828,9 +828,9 @@ CREATE TABLE `disables` (
`sourceType` int unsigned NOT NULL,
`entry` int unsigned NOT NULL,
`flags` smallint NOT NULL,
- `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 '',
+ `params_0` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `params_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`sourceType`,`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -852,7 +852,7 @@ CREATE TABLE `disenchant_loot_template` (
`GroupId` tinyint unsigned NOT NULL DEFAULT '0',
`MinCount` tinyint unsigned NOT NULL DEFAULT '1',
`MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`Entry`,`Item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -875,7 +875,7 @@ CREATE TABLE `event_scripts` (
`y` float NOT NULL DEFAULT '0',
`z` float NOT NULL DEFAULT '0',
`o` float NOT NULL DEFAULT '0',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -910,7 +910,7 @@ CREATE TABLE `fishing_loot_template` (
`GroupId` tinyint unsigned NOT NULL DEFAULT '0',
`MinCount` tinyint unsigned NOT NULL DEFAULT '1',
`MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`Entry`,`Item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -930,7 +930,7 @@ CREATE TABLE `game_event` (
`length` bigint unsigned NOT NULL DEFAULT '2592000' COMMENT 'Length in minutes of the event',
`holiday` int unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id',
`holidayStage` tinyint unsigned NOT NULL DEFAULT '0',
- `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Description of the event displayed in console',
+ `description` varchar(255) CHARACTER SET utf8mb4 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`)
@@ -978,7 +978,7 @@ CREATE TABLE `game_event_condition` (
`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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `description` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`eventEntry`,`condition_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1165,7 +1165,7 @@ CREATE TABLE `game_tele` (
`position_z` float NOT NULL DEFAULT '0',
`orientation` float NOT NULL DEFAULT '0',
`map` smallint unsigned NOT NULL DEFAULT '0',
- `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1191,7 +1191,7 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`zone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Weather System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1222,8 +1222,8 @@ 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) COLLATE utf8mb4_unicode_ci DEFAULT '',
- `VerifiedBuild` smallint DEFAULT '0',
+ `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`guid`)
) ENGINE=InnoDB AUTO_INCREMENT=2134507 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Gameobject System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1264,7 +1264,7 @@ CREATE TABLE `gameobject_loot_template` (
`GroupId` tinyint unsigned NOT NULL DEFAULT '0',
`MinCount` tinyint unsigned NOT NULL DEFAULT '1',
`MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`Entry`,`Item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1309,7 +1309,7 @@ CREATE TABLE `gameobject_questitem` (
`GameObjectEntry` int unsigned NOT NULL DEFAULT '0',
`Idx` int unsigned NOT NULL DEFAULT '0',
`ItemId` int unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`GameObjectEntry`,`Idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1339,10 +1339,10 @@ CREATE TABLE `gameobject_template` (
`entry` int unsigned NOT NULL DEFAULT '0',
`type` tinyint unsigned NOT NULL DEFAULT '0',
`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 '',
+ `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `IconName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `castBarCaption` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `unk1` varchar(100) CHARACTER SET utf8mb4 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',
@@ -1368,9 +1368,9 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `VerifiedBuild` smallint DEFAULT '0',
+ `AIName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`entry`),
KEY `idx_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Gameobject System';
@@ -1406,10 +1406,10 @@ DROP TABLE IF EXISTS `gameobject_template_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `gameobject_template_locale` (
`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',
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `castBarCaption` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`entry`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1440,7 +1440,7 @@ CREATE TABLE `gossip_menu_option` (
`MenuID` smallint unsigned NOT NULL DEFAULT '0',
`OptionID` smallint unsigned NOT NULL DEFAULT '0',
`OptionIcon` int unsigned NOT NULL DEFAULT '0',
- `OptionText` mediumtext COLLATE utf8mb4_unicode_ci,
+ `OptionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`OptionBroadcastTextID` int NOT NULL DEFAULT '0',
`OptionType` tinyint unsigned NOT NULL DEFAULT '0',
`OptionNpcFlag` int unsigned NOT NULL DEFAULT '0',
@@ -1448,7 +1448,7 @@ CREATE TABLE `gossip_menu_option` (
`ActionPoiID` int unsigned NOT NULL DEFAULT '0',
`BoxCoded` tinyint unsigned NOT NULL DEFAULT '0',
`BoxMoney` int unsigned NOT NULL DEFAULT '0',
- `BoxText` mediumtext COLLATE utf8mb4_unicode_ci,
+ `BoxText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`BoxBroadcastTextID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`MenuID`,`OptionID`)
@@ -1465,9 +1465,9 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL,
- `OptionText` mediumtext COLLATE utf8mb4_unicode_ci,
- `BoxText` mediumtext COLLATE utf8mb4_unicode_ci,
+ `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `OptionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `BoxText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`MenuID`,`OptionID`,`Locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1483,7 +1483,7 @@ CREATE TABLE `graveyard_zone` (
`ID` int unsigned NOT NULL DEFAULT '0',
`GhostZone` int unsigned NOT NULL DEFAULT '0',
`Faction` smallint unsigned NOT NULL DEFAULT '0',
- `Comment` mediumtext COLLATE utf8mb4_unicode_ci,
+ `Comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`ID`,`GhostZone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1516,7 +1516,7 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1548,7 +1548,7 @@ DROP TABLE IF EXISTS `instance_template`;
CREATE TABLE `instance_template` (
`map` smallint unsigned NOT NULL,
`parent` smallint unsigned NOT NULL,
- `script` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `script` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`allowMount` tinyint unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`map`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1586,7 +1586,7 @@ CREATE TABLE `item_loot_template` (
`GroupId` tinyint unsigned NOT NULL DEFAULT '0',
`MinCount` tinyint unsigned NOT NULL DEFAULT '1',
`MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`Entry`,`Item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1600,9 +1600,9 @@ DROP TABLE IF EXISTS `item_set_names`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item_set_names` (
`entry` int unsigned NOT NULL,
- `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`InventoryType` tinyint unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1616,9 +1616,9 @@ DROP TABLE IF EXISTS `item_set_names_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item_set_names_locale` (
`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',
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1635,7 +1635,7 @@ CREATE TABLE `item_template` (
`class` tinyint unsigned NOT NULL DEFAULT '0',
`subclass` tinyint unsigned NOT NULL DEFAULT '0',
`SoundOverrideSubclass` tinyint NOT NULL DEFAULT '-1',
- `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `name` varchar(255) CHARACTER SET utf8mb4 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',
@@ -1733,7 +1733,7 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `description` varchar(255) CHARACTER SET utf8mb4 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',
@@ -1763,13 +1763,13 @@ CREATE TABLE `item_template` (
`duration` int unsigned NOT NULL DEFAULT '0',
`ItemLimitCategory` smallint NOT NULL DEFAULT '0',
`HolidayId` int unsigned NOT NULL DEFAULT '0',
- `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `ScriptName` varchar(64) CHARACTER SET utf8mb4 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',
`flagsCustom` int unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`entry`),
KEY `idx_name` (`name`),
KEY `items_index` (`class`)
@@ -1785,10 +1785,10 @@ DROP TABLE IF EXISTS `item_template_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item_template_locale` (
`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',
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1823,7 +1823,7 @@ CREATE TABLE `lfg_dungeon_template` (
`position_y` float NOT NULL DEFAULT '0',
`position_z` float NOT NULL DEFAULT '0',
`orientation` float NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`dungeonId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1876,7 +1876,7 @@ CREATE TABLE `mail_loot_template` (
`GroupId` tinyint unsigned NOT NULL DEFAULT '0',
`MinCount` tinyint unsigned NOT NULL DEFAULT '1',
`MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`Entry`,`Item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1898,7 +1898,7 @@ CREATE TABLE `milling_loot_template` (
`GroupId` tinyint unsigned NOT NULL DEFAULT '0',
`MinCount` tinyint unsigned NOT NULL DEFAULT '1',
`MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`Entry`,`Item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1928,8 +1928,8 @@ DROP TABLE IF EXISTS `npc_text`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `npc_text` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `text0_0` longtext COLLATE utf8mb4_unicode_ci,
- `text0_1` longtext COLLATE utf8mb4_unicode_ci,
+ `text0_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `text0_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`BroadcastTextID0` int NOT NULL DEFAULT '0',
`lang0` tinyint unsigned NOT NULL DEFAULT '0',
`Probability0` float NOT NULL DEFAULT '0',
@@ -1939,8 +1939,8 @@ 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 COLLATE utf8mb4_unicode_ci,
- `text1_1` longtext COLLATE utf8mb4_unicode_ci,
+ `text1_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `text1_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`BroadcastTextID1` int NOT NULL DEFAULT '0',
`lang1` tinyint unsigned NOT NULL DEFAULT '0',
`Probability1` float NOT NULL DEFAULT '0',
@@ -1950,8 +1950,8 @@ 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 COLLATE utf8mb4_unicode_ci,
- `text2_1` longtext COLLATE utf8mb4_unicode_ci,
+ `text2_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `text2_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`BroadcastTextID2` int NOT NULL DEFAULT '0',
`lang2` tinyint unsigned NOT NULL DEFAULT '0',
`Probability2` float NOT NULL DEFAULT '0',
@@ -1961,8 +1961,8 @@ 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 COLLATE utf8mb4_unicode_ci,
- `text3_1` longtext COLLATE utf8mb4_unicode_ci,
+ `text3_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `text3_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`BroadcastTextID3` int NOT NULL DEFAULT '0',
`lang3` tinyint unsigned NOT NULL DEFAULT '0',
`Probability3` float NOT NULL DEFAULT '0',
@@ -1972,8 +1972,8 @@ 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 COLLATE utf8mb4_unicode_ci,
- `text4_1` longtext COLLATE utf8mb4_unicode_ci,
+ `text4_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `text4_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`BroadcastTextID4` int NOT NULL DEFAULT '0',
`lang4` tinyint unsigned NOT NULL DEFAULT '0',
`Probability4` float NOT NULL DEFAULT '0',
@@ -1983,8 +1983,8 @@ 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 COLLATE utf8mb4_unicode_ci,
- `text5_1` longtext COLLATE utf8mb4_unicode_ci,
+ `text5_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `text5_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`BroadcastTextID5` int NOT NULL DEFAULT '0',
`lang5` tinyint unsigned NOT NULL DEFAULT '0',
`Probability5` float NOT NULL DEFAULT '0',
@@ -1994,8 +1994,8 @@ 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 COLLATE utf8mb4_unicode_ci,
- `text6_1` longtext COLLATE utf8mb4_unicode_ci,
+ `text6_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `text6_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`BroadcastTextID6` int NOT NULL DEFAULT '0',
`lang6` tinyint unsigned NOT NULL DEFAULT '0',
`Probability6` float NOT NULL DEFAULT '0',
@@ -2005,8 +2005,8 @@ 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 COLLATE utf8mb4_unicode_ci,
- `text7_1` longtext COLLATE utf8mb4_unicode_ci,
+ `text7_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `text7_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`BroadcastTextID7` int NOT NULL DEFAULT '0',
`lang7` tinyint unsigned NOT NULL DEFAULT '0',
`Probability7` float NOT NULL DEFAULT '0',
@@ -2016,7 +2016,7 @@ CREATE TABLE `npc_text` (
`Emote7_1` smallint unsigned NOT NULL DEFAULT '0',
`EmoteDelay7_2` smallint unsigned NOT NULL DEFAULT '0',
`Emote7_2` smallint unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2030,23 +2030,23 @@ DROP TABLE IF EXISTS `npc_text_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `npc_text_locale` (
`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,
+ `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Text0_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text0_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text1_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text1_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text2_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text2_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text3_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text3_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text4_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text4_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text5_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text5_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text6_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text6_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text7_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Text7_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`ID`,`Locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2065,7 +2065,7 @@ CREATE TABLE `npc_vendor` (
`maxcount` tinyint unsigned NOT NULL DEFAULT '0',
`incrtime` int unsigned NOT NULL DEFAULT '0',
`ExtendedCost` int unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`entry`,`item`,`ExtendedCost`),
KEY `slot` (`slot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Npc System';
@@ -2080,8 +2080,8 @@ DROP TABLE IF EXISTS `outdoorpvp_template`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `outdoorpvp_template` (
`TypeId` tinyint unsigned NOT NULL,
- `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `comment` mediumtext COLLATE utf8mb4_unicode_ci,
+ `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`TypeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='OutdoorPvP Templates';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2095,7 +2095,7 @@ DROP TABLE IF EXISTS `page_text`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `page_text` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `Text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`NextPageID` int unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
@@ -2111,9 +2111,9 @@ DROP TABLE IF EXISTS `page_text_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `page_text_locale` (
`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',
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2151,7 +2151,7 @@ DROP TABLE IF EXISTS `pet_name_generation`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pet_name_generation` (
`id` int unsigned NOT NULL,
- `word` text COLLATE utf8mb4_unicode_ci NOT NULL,
+ `word` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`entry` int unsigned NOT NULL DEFAULT '0',
`half` tinyint unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
@@ -2175,7 +2175,7 @@ CREATE TABLE `pickpocketing_loot_template` (
`GroupId` tinyint unsigned NOT NULL DEFAULT '0',
`MinCount` tinyint unsigned NOT NULL DEFAULT '1',
`MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`Entry`,`Item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2220,10 +2220,10 @@ 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` mediumtext COLLATE utf8mb4_unicode_ci,
+ `commentA` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`race_H` int unsigned NOT NULL,
`horde_id` int unsigned NOT NULL,
- `commentH` mediumtext COLLATE utf8mb4_unicode_ci,
+ `commentH` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`alliance_id`,`horde_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2384,7 +2384,7 @@ CREATE TABLE `playercreateinfo_cast_spell` (
`raceMask` int unsigned NOT NULL DEFAULT '0',
`classMask` int unsigned NOT NULL DEFAULT '0',
`spell` int unsigned NOT NULL DEFAULT '0',
- `note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
+ `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2417,7 +2417,7 @@ CREATE TABLE `playercreateinfo_skills` (
`classMask` int unsigned NOT NULL,
`skill` smallint unsigned NOT NULL,
`rank` smallint unsigned NOT NULL DEFAULT '0',
- `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`raceMask`,`classMask`,`skill`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2433,7 +2433,7 @@ CREATE TABLE `playercreateinfo_spell_custom` (
`racemask` int unsigned NOT NULL DEFAULT '0',
`classmask` int unsigned NOT NULL DEFAULT '0',
`Spell` int unsigned NOT NULL DEFAULT '0',
- `Note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`racemask`,`classmask`,`Spell`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2452,8 +2452,8 @@ CREATE TABLE `points_of_interest` (
`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',
+ `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2467,9 +2467,9 @@ DROP TABLE IF EXISTS `points_of_interest_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `points_of_interest_locale` (
`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',
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2486,7 +2486,7 @@ CREATE TABLE `pool_members` (
`spawnId` int unsigned NOT NULL,
`poolSpawnId` int unsigned NOT NULL,
`chance` float NOT NULL,
- `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`type`,`spawnId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2501,7 +2501,7 @@ DROP TABLE IF EXISTS `pool_template`;
CREATE TABLE `pool_template` (
`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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2523,7 +2523,7 @@ CREATE TABLE `prospecting_loot_template` (
`GroupId` tinyint unsigned NOT NULL DEFAULT '0',
`MinCount` tinyint unsigned NOT NULL DEFAULT '1',
`MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`Entry`,`Item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2562,8 +2562,8 @@ CREATE TABLE `quest_greeting` (
`Type` tinyint unsigned NOT NULL DEFAULT '0',
`GreetEmoteType` smallint unsigned NOT NULL DEFAULT '0',
`GreetEmoteDelay` int unsigned NOT NULL DEFAULT '0',
- `Greeting` mediumtext COLLATE utf8mb4_unicode_ci,
- `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+ `Greeting` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`,`Type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2578,9 +2578,9 @@ DROP TABLE IF EXISTS `quest_greeting_locale`;
CREATE TABLE `quest_greeting_locale` (
`ID` int unsigned NOT NULL DEFAULT '0',
`Type` tinyint unsigned NOT NULL DEFAULT '0',
- `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
- `Greeting` mediumtext COLLATE utf8mb4_unicode_ci,
- `VerifiedBuild` smallint DEFAULT '0',
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Greeting` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`,`Type`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2616,7 +2616,7 @@ 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` mediumtext COLLATE utf8mb4_unicode_ci,
+ `RewardText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2631,9 +2631,9 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL,
- `RewardText` mediumtext COLLATE utf8mb4_unicode_ci,
- `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `RewardText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2654,7 +2654,7 @@ CREATE TABLE `quest_poi` (
`Floor` int unsigned NOT NULL DEFAULT '0',
`Priority` int unsigned NOT NULL DEFAULT '0',
`Flags` int unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`QuestID`,`id`),
KEY `idx` (`QuestID`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2673,7 +2673,7 @@ CREATE TABLE `quest_poi_points` (
`Idx2` int unsigned NOT NULL DEFAULT '0',
`X` int NOT NULL DEFAULT '0',
`Y` int NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`QuestID`,`Idx1`,`Idx2`),
KEY `questId_id` (`QuestID`,`Idx1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2690,7 +2690,7 @@ 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`questId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2705,7 +2705,7 @@ DROP TABLE IF EXISTS `quest_pool_template`;
CREATE TABLE `quest_pool_template` (
`poolId` int unsigned NOT NULL,
`numActive` int unsigned NOT NULL COMMENT 'Number of indices to have active at any time',
- `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`poolId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2721,7 +2721,7 @@ CREATE TABLE `quest_request_items` (
`ID` int unsigned NOT NULL DEFAULT '0',
`EmoteOnComplete` smallint unsigned NOT NULL DEFAULT '0',
`EmoteOnIncomplete` smallint unsigned NOT NULL DEFAULT '0',
- `CompletionText` mediumtext COLLATE utf8mb4_unicode_ci,
+ `CompletionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2736,9 +2736,9 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL,
- `CompletionText` mediumtext COLLATE utf8mb4_unicode_ci,
- `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `CompletionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2825,11 +2825,11 @@ CREATE TABLE `quest_template` (
`RewardFactionOverride5` int NOT NULL DEFAULT '0',
`TimeAllowed` int unsigned NOT NULL DEFAULT '0',
`AllowableRaces` smallint unsigned 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,
+ `LogTitle` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `LogDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `QuestDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `AreaDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `QuestCompletionLog` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`RequiredNpcOrGo1` int NOT NULL DEFAULT '0',
`RequiredNpcOrGo2` int NOT NULL DEFAULT '0',
`RequiredNpcOrGo3` int NOT NULL DEFAULT '0',
@@ -2851,11 +2851,11 @@ 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` 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',
+ `ObjectiveText1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `ObjectiveText2` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `ObjectiveText3` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `ObjectiveText4` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Quest System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2899,17 +2899,17 @@ DROP TABLE IF EXISTS `quest_template_locale`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `quest_template_locale` (
`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',
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Title` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Details` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `Objectives` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `EndText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `CompletedText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `ObjectiveText1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `ObjectiveText2` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `ObjectiveText3` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `ObjectiveText4` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2931,7 +2931,7 @@ CREATE TABLE `reference_loot_template` (
`GroupId` tinyint unsigned NOT NULL DEFAULT '0',
`MinCount` tinyint unsigned NOT NULL DEFAULT '1',
`MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`Entry`,`Item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3032,7 +3032,7 @@ CREATE TABLE `script_waypoint` (
`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` mediumtext COLLATE utf8mb4_unicode_ci,
+ `point_comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`entry`,`pointid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Script Creature waypoints';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3116,7 +3116,7 @@ CREATE TABLE `skinning_loot_template` (
`GroupId` tinyint unsigned NOT NULL DEFAULT '0',
`MinCount` tinyint unsigned NOT NULL DEFAULT '1',
`MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`Entry`,`Item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3158,7 +3158,7 @@ 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` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Event Comment',
+ `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Event Comment',
PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3187,7 +3187,7 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `groupName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`groupFlags` int unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3228,7 +3228,7 @@ CREATE TABLE `spell_bonus_data` (
`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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `comments` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3337,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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `SpellName` varchar(100) CHARACTER SET utf8mb4 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',
@@ -3426,7 +3426,7 @@ CREATE TABLE `spell_linked_spell` (
`spell_trigger` int NOT NULL,
`spell_effect` int NOT NULL DEFAULT '0',
`type` tinyint unsigned NOT NULL DEFAULT '0',
- `comment` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
+ `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
UNIQUE KEY `trigger_effect_type` (`spell_trigger`,`spell_effect`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3448,7 +3448,7 @@ CREATE TABLE `spell_loot_template` (
`GroupId` tinyint unsigned NOT NULL DEFAULT '0',
`MinCount` tinyint unsigned NOT NULL DEFAULT '1',
`MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`Entry`,`Item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3536,7 +3536,7 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
UNIQUE KEY `spell_id` (`spell_id`,`ScriptName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3560,7 +3560,7 @@ CREATE TABLE `spell_scripts` (
`y` float NOT NULL DEFAULT '0',
`z` float NOT NULL DEFAULT '0',
`o` float NOT NULL DEFAULT '0',
- `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3579,7 +3579,7 @@ CREATE TABLE `spell_target_position` (
`PositionY` float NOT NULL DEFAULT '0',
`PositionZ` float NOT NULL DEFAULT '0',
`Orientation` float NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`ID`,`EffectIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3628,8 +3628,8 @@ CREATE TABLE `trainer` (
`Id` int unsigned NOT NULL DEFAULT '0',
`Type` tinyint unsigned NOT NULL DEFAULT '2',
`Requirement` int unsigned NOT NULL DEFAULT '0',
- `Greeting` mediumtext COLLATE utf8mb4_unicode_ci,
- `VerifiedBuild` smallint DEFAULT '0',
+ `Greeting` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3643,9 +3643,9 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL,
- `Greeting_lang` mediumtext COLLATE utf8mb4_unicode_ci,
- `VerifiedBuild` smallint DEFAULT '0',
+ `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Greeting_lang` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`Id`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3667,7 +3667,7 @@ CREATE TABLE `trainer_spell` (
`ReqAbility2` int unsigned NOT NULL DEFAULT '0',
`ReqAbility3` int unsigned NOT NULL DEFAULT '0',
`ReqLevel` tinyint unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int DEFAULT NULL,
PRIMARY KEY (`TrainerId`,`SpellId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3682,8 +3682,8 @@ DROP TABLE IF EXISTS `transports`;
CREATE TABLE `transports` (
`guid` int unsigned NOT NULL AUTO_INCREMENT,
`entry` int unsigned NOT NULL DEFAULT '0',
- `name` mediumtext COLLATE utf8mb4_unicode_ci,
- `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`guid`),
UNIQUE KEY `idx_entry` (`entry`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Transports';
@@ -3698,15 +3698,15 @@ DROP TABLE IF EXISTS `trinity_string`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trinity_string` (
`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,
+ `content_default` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+ `content_loc1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `content_loc2` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `content_loc3` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `content_loc4` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `content_loc5` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `content_loc6` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `content_loc7` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `content_loc8` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3719,9 +3719,9 @@ 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) 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.',
+ `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.',
+ `hash` char(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.',
+ `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 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`)
@@ -3736,8 +3736,8 @@ 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) 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.',
+ `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.',
+ `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.',
PRIMARY KEY (`path`)
) 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 */;
@@ -3754,7 +3754,7 @@ CREATE TABLE `vehicle_accessory` (
`accessory_entry` int unsigned NOT NULL DEFAULT '0',
`seat_id` tinyint NOT NULL DEFAULT '0',
`minion` tinyint unsigned NOT NULL DEFAULT '0',
- `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
+ `description` mediumtext CHARACTER SET utf8mb4 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`)
@@ -3806,7 +3806,7 @@ CREATE TABLE `vehicle_template_accessory` (
`accessory_entry` int unsigned NOT NULL DEFAULT '0',
`seat_id` tinyint NOT NULL DEFAULT '0',
`minion` tinyint unsigned NOT NULL DEFAULT '0',
- `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
+ `description` mediumtext CHARACTER SET utf8mb4 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`)
@@ -3821,9 +3821,9 @@ 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) 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.',
+ `core_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.',
+ `core_revision` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `db_version` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Version of world DB.',
`cache_id` int DEFAULT '0',
PRIMARY KEY (`core_version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Version Notes';
@@ -3923,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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `str` varchar(170) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` int unsigned DEFAULT NULL,
`length` tinyint unsigned DEFAULT NULL,
- `comment` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `comment` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`data` binary(24) DEFAULT NULL,
`result` varbinary(24) DEFAULT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=791 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+) ENGINE=InnoDB AUTO_INCREMENT=812 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -3975,7 +3975,7 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3995,7 +3995,7 @@ CREATE TABLE `waypoints` (
`position_z` float NOT NULL DEFAULT '0',
`orientation` float DEFAULT NULL,
`delay` int unsigned NOT NULL DEFAULT '0',
- `point_comment` mediumtext COLLATE utf8mb4_unicode_ci,
+ `point_comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`entry`,`pointid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature waypoints';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -4067,4 +4067,4 @@ CREATE TABLE `waypoints` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2023-01-16 11:08:18
+-- Dump completed on 2023-06-14 19:34:39