From 251ad7f8a838c0de1495b351ad6bead2e5968896 Mon Sep 17 00:00:00 2001 From: TDB Release Date: Fri, 15 Oct 2021 10:18:03 +0000 Subject: TDB 910.21101 - 2021/10/15 --- sql/base/dev/hotfixes_database.sql | 19 +++- sql/base/dev/world_database.sql | 227 +++++++++++++++++++++++-------------- 2 files changed, 159 insertions(+), 87 deletions(-) (limited to 'sql/base/dev') 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 @@ -7662,6 +7662,23 @@ CREATE TABLE `spell_reagents` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!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,11 +112,107 @@ 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` -- @@ -216,25 +312,6 @@ CREATE TABLE `areatrigger_template_actions` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!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` -- @@ -626,6 +703,23 @@ CREATE TABLE `creature_model_info` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Creature System (Model related 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', @@ -865,6 +958,23 @@ CREATE TABLE `creature_template_model` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; /*!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 */; @@ -3789,69 +3907,6 @@ CREATE TABLE `spell_area` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!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 -- cgit v1.2.3