aboutsummaryrefslogtreecommitdiff
path: root/sql/base/dev
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base/dev')
-rw-r--r--sql/base/dev/world_database.sql139
1 files changed, 79 insertions, 60 deletions
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;
@@ -3717,6 +3717,25 @@ CREATE TABLE `vehicle_accessory` (
/*!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