From 322f0b8873e14a67bad0f23e1d3a2927a43c2495 Mon Sep 17 00:00:00 2001 From: TDB Release Date: Sat, 15 Feb 2020 17:38:06 +0000 Subject: TDB 335.20021 - 2020/02/15 --- sql/base/dev/world_database.sql | 139 +++++++++++++++++++++++----------------- 1 file changed, 79 insertions(+), 60 deletions(-) (limited to 'sql/base/dev') diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index a99895c7c28..cafd81daf8d 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -222,18 +222,18 @@ DROP TABLE IF EXISTS `broadcast_text`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `broadcast_text` ( `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Language` mediumint(8) unsigned NOT NULL DEFAULT '0', - `MaleText` longtext, - `FemaleText` longtext, - `EmoteID0` mediumint(8) unsigned NOT NULL DEFAULT '0', + `LanguageID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Text` longtext, + `Text1` longtext, `EmoteID1` mediumint(8) unsigned NOT NULL DEFAULT '0', `EmoteID2` mediumint(8) unsigned NOT NULL DEFAULT '0', - `EmoteDelay0` mediumint(8) unsigned NOT NULL DEFAULT '0', + `EmoteID3` mediumint(8) unsigned NOT NULL DEFAULT '0', `EmoteDelay1` mediumint(8) unsigned NOT NULL DEFAULT '0', `EmoteDelay2` mediumint(8) unsigned NOT NULL DEFAULT '0', - `SoundId` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Unk1` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Unk2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `EmoteDelay3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `SoundEntriesID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `EmotesID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Flags` mediumint(8) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -249,8 +249,8 @@ DROP TABLE IF EXISTS `broadcast_text_locale`; CREATE TABLE `broadcast_text_locale` ( `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', `locale` varchar(4) NOT NULL, - `MaleText` text, - `FemaleText` text, + `Text` text, + `Text1` text, `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1455,7 +1455,7 @@ CREATE TABLE `holiday_dates` ( `id` int(10) unsigned NOT NULL, `date_id` tinyint(3) unsigned NOT NULL, `date_value` int(10) unsigned NOT NULL, - `holiday_duration` int(10) unsigned NOT NULL, + `holiday_duration` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`date_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1889,89 +1889,89 @@ CREATE TABLE `npc_text` ( `BroadcastTextID0` mediumint(6) NOT NULL DEFAULT '0', `lang0` tinyint(3) unsigned NOT NULL DEFAULT '0', `Probability0` float NOT NULL DEFAULT '0', - `em0_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em0_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em0_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em0_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em0_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em0_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay0_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote0_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay0_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote0_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay0_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote0_2` smallint(5) unsigned NOT NULL DEFAULT '0', `text1_0` longtext, `text1_1` longtext, `BroadcastTextID1` mediumint(6) NOT NULL DEFAULT '0', `lang1` tinyint(3) unsigned NOT NULL DEFAULT '0', `Probability1` float NOT NULL DEFAULT '0', - `em1_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em1_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em1_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em1_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em1_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em1_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay1_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote1_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay1_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote1_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay1_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote1_2` smallint(5) unsigned NOT NULL DEFAULT '0', `text2_0` longtext, `text2_1` longtext, `BroadcastTextID2` mediumint(6) NOT NULL DEFAULT '0', `lang2` tinyint(3) unsigned NOT NULL DEFAULT '0', `Probability2` float NOT NULL DEFAULT '0', - `em2_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em2_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em2_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em2_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em2_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em2_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay2_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote2_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay2_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote2_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay2_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote2_2` smallint(5) unsigned NOT NULL DEFAULT '0', `text3_0` longtext, `text3_1` longtext, `BroadcastTextID3` mediumint(6) NOT NULL DEFAULT '0', `lang3` tinyint(3) unsigned NOT NULL DEFAULT '0', `Probability3` float NOT NULL DEFAULT '0', - `em3_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em3_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em3_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em3_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em3_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em3_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay3_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote3_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay3_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote3_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay3_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote3_2` smallint(5) unsigned NOT NULL DEFAULT '0', `text4_0` longtext, `text4_1` longtext, `BroadcastTextID4` mediumint(6) NOT NULL DEFAULT '0', `lang4` tinyint(3) unsigned NOT NULL DEFAULT '0', `Probability4` float NOT NULL DEFAULT '0', - `em4_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em4_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em4_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em4_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em4_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em4_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay4_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote4_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay4_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote4_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay4_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote4_2` smallint(5) unsigned NOT NULL DEFAULT '0', `text5_0` longtext, `text5_1` longtext, `BroadcastTextID5` mediumint(6) NOT NULL DEFAULT '0', `lang5` tinyint(3) unsigned NOT NULL DEFAULT '0', `Probability5` float NOT NULL DEFAULT '0', - `em5_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em5_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em5_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em5_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em5_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em5_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay5_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote5_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay5_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote5_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay5_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote5_2` smallint(5) unsigned NOT NULL DEFAULT '0', `text6_0` longtext, `text6_1` longtext, `BroadcastTextID6` mediumint(6) NOT NULL DEFAULT '0', `lang6` tinyint(3) unsigned NOT NULL DEFAULT '0', `Probability6` float NOT NULL DEFAULT '0', - `em6_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em6_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em6_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em6_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em6_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em6_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay6_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote6_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay6_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote6_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay6_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote6_2` smallint(5) unsigned NOT NULL DEFAULT '0', `text7_0` longtext, `text7_1` longtext, `BroadcastTextID7` mediumint(6) NOT NULL DEFAULT '0', `lang7` tinyint(3) unsigned NOT NULL DEFAULT '0', `Probability7` float NOT NULL DEFAULT '0', - `em7_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em7_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em7_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em7_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em7_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em7_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay7_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote7_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay7_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote7_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteDelay7_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `Emote7_2` smallint(5) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -3716,6 +3716,25 @@ CREATE TABLE `vehicle_accessory` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `vehicle_seat_addon` +-- + +DROP TABLE IF EXISTS `vehicle_seat_addon`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `vehicle_seat_addon` ( + `SeatEntry` int(4) unsigned NOT NULL COMMENT 'VehicleSeatEntry.dbc identifier', + `SeatOrientation` float DEFAULT '0' COMMENT 'Seat Orientation override value', + `ExitParamX` float DEFAULT '0', + `ExitParamY` float DEFAULT '0', + `ExitParamZ` float DEFAULT '0', + `ExitParamO` float DEFAULT '0', + `ExitParamValue` tinyint(1) DEFAULT '0', + PRIMARY KEY (`SeatEntry`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `vehicle_template_accessory` -- @@ -3844,4 +3863,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2020-01-15 7:45:20 +-- Dump completed on 2020-02-15 17:36:07 -- cgit v1.2.3