TDB 910.21101 - 2021/10/15TDB910.21101

2 files changed, 159 insertions, 87 deletions

diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index 917a38e1065..d27b8f2a777 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_database.sql
@@ -7663,6 +7663,23 @@ CREATE TABLE `spell_reagents` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `spell_reagents_currency`
+--
+
+DROP TABLE IF EXISTS `spell_reagents_currency`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spell_reagents_currency` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID` int(11) NOT NULL DEFAULT '0',
+  `CurrencyTypesID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `CurrencyCount` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `spell_scaling`
 --
 
@@ -8799,4 +8816,4 @@ CREATE TABLE `world_state_expression` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-08-18 15:14:20
+-- Dump completed on 2021-10-15 10:11:51
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index ee2d8694807..21798f11323 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -112,12 +112,108 @@ CREATE TABLE `areatrigger` (
   `PhaseUseFlags` tinyint(3) unsigned DEFAULT '0',
   `PhaseId` int(10) unsigned DEFAULT '0',
   `PhaseGroup` int(10) unsigned DEFAULT '0',
+  `Shape` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ShapeData0` float NOT NULL DEFAULT '0',
+  `ShapeData1` float NOT NULL DEFAULT '0',
+  `ShapeData2` float NOT NULL DEFAULT '0',
+  `ShapeData3` float NOT NULL DEFAULT '0',
+  `ShapeData4` float NOT NULL DEFAULT '0',
+  `ShapeData5` float NOT NULL DEFAULT '0',
   `Comment` varchar(255) DEFAULT NULL,
   PRIMARY KEY (`SpawnId`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `areatrigger_create_properties`
+--
+
+DROP TABLE IF EXISTS `areatrigger_create_properties`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `areatrigger_create_properties` (
+  `Id` int(10) unsigned NOT NULL,
+  `AreaTriggerId` int(10) unsigned NOT NULL,
+  `MoveCurveId` int(10) unsigned NOT NULL DEFAULT '0',
+  `ScaleCurveId` int(10) unsigned NOT NULL DEFAULT '0',
+  `MorphCurveId` int(10) unsigned NOT NULL DEFAULT '0',
+  `FacingCurveId` int(10) unsigned NOT NULL DEFAULT '0',
+  `AnimId` int(11) NOT NULL DEFAULT '0',
+  `AnimKitId` int(11) NOT NULL DEFAULT '0',
+  `DecalPropertiesId` int(10) unsigned NOT NULL DEFAULT '0',
+  `TimeToTarget` int(10) unsigned NOT NULL DEFAULT '0',
+  `TimeToTargetScale` int(10) unsigned NOT NULL DEFAULT '0',
+  `Shape` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ShapeData0` float NOT NULL DEFAULT '0',
+  `ShapeData1` float NOT NULL DEFAULT '0',
+  `ShapeData2` float NOT NULL DEFAULT '0',
+  `ShapeData3` float NOT NULL DEFAULT '0',
+  `ShapeData4` float NOT NULL DEFAULT '0',
+  `ShapeData5` float NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `areatrigger_create_properties_orbit`
+--
+
+DROP TABLE IF EXISTS `areatrigger_create_properties_orbit`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `areatrigger_create_properties_orbit` (
+  `AreaTriggerCreatePropertiesId` int(10) unsigned NOT NULL,
+  `StartDelay` int(10) unsigned NOT NULL DEFAULT '0',
+  `CircleRadius` float NOT NULL DEFAULT '0',
+  `BlendFromRadius` float NOT NULL DEFAULT '0',
+  `InitialAngle` float NOT NULL DEFAULT '0',
+  `ZOffset` float NOT NULL DEFAULT '0',
+  `CounterClockwise` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `CanLoop` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`AreaTriggerCreatePropertiesId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `areatrigger_create_properties_polygon_vertex`
+--
+
+DROP TABLE IF EXISTS `areatrigger_create_properties_polygon_vertex`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `areatrigger_create_properties_polygon_vertex` (
+  `AreaTriggerCreatePropertiesId` int(10) unsigned NOT NULL,
+  `Idx` int(10) unsigned NOT NULL,
+  `VerticeX` float NOT NULL DEFAULT '0',
+  `VerticeY` float NOT NULL DEFAULT '0',
+  `VerticeTargetX` float DEFAULT NULL,
+  `VerticeTargetY` float DEFAULT NULL,
+  `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`AreaTriggerCreatePropertiesId`,`Idx`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `areatrigger_create_properties_spline_point`
+--
+
+DROP TABLE IF EXISTS `areatrigger_create_properties_spline_point`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `areatrigger_create_properties_spline_point` (
+  `AreaTriggerCreatePropertiesId` int(10) unsigned NOT NULL,
+  `Idx` int(10) unsigned NOT NULL,
+  `X` float NOT NULL DEFAULT '0',
+  `Y` float NOT NULL DEFAULT '0',
+  `Z` float NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`AreaTriggerCreatePropertiesId`,`Idx`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `areatrigger_involvedrelation`
 --
 
@@ -217,25 +313,6 @@ CREATE TABLE `areatrigger_template_actions` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
--- Table structure for table `areatrigger_template_polygon_vertices`
---
-
-DROP TABLE IF EXISTS `areatrigger_template_polygon_vertices`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `areatrigger_template_polygon_vertices` (
-  `AreaTriggerId` int(10) unsigned NOT NULL,
-  `Idx` int(10) unsigned NOT NULL,
-  `VerticeX` float NOT NULL DEFAULT '0',
-  `VerticeY` float NOT NULL DEFAULT '0',
-  `VerticeTargetX` float DEFAULT NULL,
-  `VerticeTargetY` float DEFAULT NULL,
-  `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`AreaTriggerId`,`Idx`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
 -- Table structure for table `battle_pet_breeds`
 --
 
@@ -627,6 +704,23 @@ CREATE TABLE `creature_model_info` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `creature_movement_override`
+--
+
+DROP TABLE IF EXISTS `creature_movement_override`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature_movement_override` (
+  `SpawnId` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `Ground` tinyint(3) unsigned NOT NULL DEFAULT '1',
+  `Swim` tinyint(3) unsigned NOT NULL DEFAULT '1',
+  `Flight` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Rooted` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`SpawnId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `creature_onkill_reputation`
 --
 
@@ -781,7 +875,6 @@ CREATE TABLE `creature_template` (
   `maxgold` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `AIName` varchar(64) NOT NULL DEFAULT '',
   `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `InhabitType` tinyint(3) unsigned NOT NULL DEFAULT '3',
   `HoverHeight` float NOT NULL DEFAULT '1',
   `HealthModifier` float NOT NULL DEFAULT '1',
   `HealthModifierExtra` float NOT NULL DEFAULT '1',
@@ -866,6 +959,23 @@ CREATE TABLE `creature_template_model` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `creature_template_movement`
+--
+
+DROP TABLE IF EXISTS `creature_template_movement`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature_template_movement` (
+  `CreatureId` int(10) unsigned NOT NULL DEFAULT '0',
+  `Ground` tinyint(3) unsigned NOT NULL DEFAULT '1',
+  `Swim` tinyint(3) unsigned NOT NULL DEFAULT '1',
+  `Flight` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Rooted` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`CreatureId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `creature_template_scaling`
 --
 
@@ -1311,7 +1421,7 @@ CREATE TABLE `game_tele` (
   `map` smallint(5) unsigned NOT NULL DEFAULT '0',
   `name` varchar(100) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=1689 DEFAULT CHARSET=utf8 COMMENT='Tele Command';
+) ENGINE=MyISAM AUTO_INCREMENT=1758 DEFAULT CHARSET=utf8 COMMENT='Tele Command';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2538,11 +2648,19 @@ CREATE TABLE `playercreateinfo` (
   `race` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `class` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `map` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `zone` mediumint(8) 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',
+  `npe_map` int(10) unsigned DEFAULT NULL,
+  `npe_position_x` float DEFAULT NULL,
+  `npe_position_y` float DEFAULT NULL,
+  `npe_position_z` float DEFAULT NULL,
+  `npe_orientation` float DEFAULT NULL,
+  `npe_transport_guid` bigint(20) unsigned DEFAULT NULL,
+  `intro_movie_id` int(10) unsigned DEFAULT NULL,
+  `intro_scene_id` int(10) unsigned DEFAULT NULL,
+  `npe_intro_scene_id` int(10) unsigned DEFAULT NULL,
   PRIMARY KEY (`race`,`class`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3790,69 +3908,6 @@ CREATE TABLE `spell_area` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
--- Table structure for table `spell_areatrigger`
---
-
-DROP TABLE IF EXISTS `spell_areatrigger`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `spell_areatrigger` (
-  `SpellMiscId` int(10) unsigned NOT NULL,
-  `AreaTriggerId` int(10) unsigned NOT NULL,
-  `MoveCurveId` int(10) unsigned NOT NULL DEFAULT '0',
-  `ScaleCurveId` int(10) unsigned NOT NULL DEFAULT '0',
-  `MorphCurveId` int(10) unsigned NOT NULL DEFAULT '0',
-  `FacingCurveId` int(10) unsigned NOT NULL DEFAULT '0',
-  `AnimId` int(11) NOT NULL DEFAULT '0',
-  `AnimKitId` int(11) NOT NULL DEFAULT '0',
-  `DecalPropertiesId` int(10) unsigned NOT NULL DEFAULT '0',
-  `TimeToTarget` int(10) unsigned NOT NULL DEFAULT '0',
-  `TimeToTargetScale` int(10) unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`SpellMiscId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `spell_areatrigger_circular`
---
-
-DROP TABLE IF EXISTS `spell_areatrigger_circular`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `spell_areatrigger_circular` (
-  `SpellMiscId` int(10) unsigned NOT NULL,
-  `StartDelay` int(10) unsigned NOT NULL DEFAULT '0',
-  `CircleRadius` float NOT NULL DEFAULT '0',
-  `BlendFromRadius` float NOT NULL DEFAULT '0',
-  `InitialAngle` float NOT NULL DEFAULT '0',
-  `ZOffset` float NOT NULL DEFAULT '0',
-  `CounterClockwise` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `CanLoop` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`SpellMiscId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `spell_areatrigger_splines`
---
-
-DROP TABLE IF EXISTS `spell_areatrigger_splines`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `spell_areatrigger_splines` (
-  `SpellMiscId` int(10) unsigned NOT NULL,
-  `Idx` int(10) unsigned NOT NULL,
-  `X` float NOT NULL DEFAULT '0',
-  `Y` float NOT NULL DEFAULT '0',
-  `Z` float NOT NULL DEFAULT '0',
-  `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`SpellMiscId`,`Idx`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
 -- Table structure for table `spell_custom_attr`
 --
 
@@ -4450,4 +4505,4 @@ CREATE TABLE `world_safe_locs` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-08-18 15:14:19
+-- Dump completed on 2021-10-15 10:11:49