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.sql198
1 files changed, 166 insertions, 32 deletions
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index bcbcdd086f2..60e905dc79a 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.16 Distrib 10.1.6-MariaDB, for Win64 (AMD64)
+-- MySQL dump 10.13 Distrib 5.7.24, for Linux (x86_64)
--
-- Host: localhost Database: world
-- ------------------------------------------------------
--- Server version 5.7.14-log
+-- Server version 5.7.24-0ubuntu0.16.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -89,7 +89,7 @@ CREATE TABLE `achievement_reward` (
`ItemID` mediumint(8) unsigned NOT NULL DEFAULT '0',
`Sender` mediumint(8) unsigned NOT NULL DEFAULT '0',
`Subject` varchar(255) DEFAULT NULL,
- `Text` text,
+ `Body` text,
`MailTemplateID` mediumint(8) unsigned DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
@@ -106,7 +106,7 @@ CREATE TABLE `achievement_reward_locale` (
`ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
`Locale` varchar(4) NOT NULL,
`Subject` text,
- `Text` text,
+ `Body` text,
PRIMARY KEY (`ID`,`Locale`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -350,6 +350,7 @@ CREATE TABLE `creature_addon` (
`bytes1` int(10) unsigned NOT NULL DEFAULT '0',
`bytes2` int(10) unsigned NOT NULL DEFAULT '0',
`emote` int(10) unsigned NOT NULL DEFAULT '0',
+ `visibilityDistanceType` tinyint(3) unsigned NOT NULL DEFAULT '0',
`auras` text,
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@ -381,6 +382,20 @@ CREATE TABLE `creature_classlevelstats` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `creature_default_trainer`
+--
+
+DROP TABLE IF EXISTS `creature_default_trainer`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature_default_trainer` (
+ `CreatureId` int(11) unsigned NOT NULL,
+ `TrainerId` int(11) 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_equip_template`
--
@@ -457,6 +472,25 @@ 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` 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',
+ `Chase` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `Random` 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`
--
@@ -584,10 +618,6 @@ CREATE TABLE `creature_template` (
`unit_flags2` int(10) unsigned NOT NULL DEFAULT '0',
`dynamicflags` int(10) unsigned NOT NULL DEFAULT '0',
`family` tinyint(4) NOT NULL DEFAULT '0',
- `trainer_type` tinyint(4) NOT NULL DEFAULT '0',
- `trainer_spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `trainer_class` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `trainer_race` tinyint(3) unsigned NOT NULL DEFAULT '0',
`type` tinyint(3) unsigned NOT NULL DEFAULT '0',
`type_flags` int(10) unsigned NOT NULL DEFAULT '0',
`lootid` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -613,7 +643,6 @@ CREATE TABLE `creature_template` (
`maxgold` mediumint(8) unsigned NOT NULL DEFAULT '0',
`AIName` char(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',
`ManaModifier` float NOT NULL DEFAULT '1',
@@ -647,6 +676,7 @@ CREATE TABLE `creature_template_addon` (
`bytes1` int(10) unsigned NOT NULL DEFAULT '0',
`bytes2` int(10) unsigned NOT NULL DEFAULT '0',
`emote` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `visibilityDistanceType` tinyint(3) unsigned NOT NULL DEFAULT '0',
`auras` text,
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@ -670,6 +700,25 @@ CREATE TABLE `creature_template_locale` (
/*!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',
+ `Chase` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `Random` 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_text`
--
@@ -721,7 +770,7 @@ DROP TABLE IF EXISTS `disables`;
CREATE TABLE `disables` (
`sourceType` int(10) unsigned NOT NULL,
`entry` int(10) unsigned NOT NULL,
- `flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `flags` smallint(5) NOT NULL,
`params_0` varchar(255) NOT NULL DEFAULT '',
`params_1` varchar(255) NOT NULL DEFAULT '',
`comment` varchar(255) NOT NULL DEFAULT '',
@@ -1163,6 +1212,21 @@ CREATE TABLE `gameobject_loot_template` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `gameobject_overrides`
+--
+
+DROP TABLE IF EXISTS `gameobject_overrides`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `gameobject_overrides` (
+ `spawnId` int(10) unsigned NOT NULL DEFAULT '0',
+ `faction` smallint(5) unsigned NOT NULL DEFAULT '0',
+ `flags` int(10) 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 `gameobject_questender`
--
@@ -1925,24 +1989,6 @@ CREATE TABLE `npc_text_locale` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Table structure for table `npc_trainer`
---
-
-DROP TABLE IF EXISTS `npc_trainer`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `npc_trainer` (
- `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `SpellID` mediumint(8) NOT NULL DEFAULT '0',
- `MoneyCost` int(10) unsigned NOT NULL DEFAULT '0',
- `ReqSkillLine` smallint(5) unsigned NOT NULL DEFAULT '0',
- `ReqSkillRank` smallint(5) unsigned NOT NULL DEFAULT '0',
- `ReqLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`ID`,`SpellID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
-- Table structure for table `npc_vendor`
--
@@ -2027,6 +2073,8 @@ CREATE TABLE `pet_levelstats` (
`sta` smallint(5) unsigned NOT NULL,
`inte` smallint(5) unsigned NOT NULL,
`spi` smallint(5) unsigned NOT NULL,
+ `min_dmg` smallint(5) unsigned NOT NULL DEFAULT '0',
+ `max_dmg` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`creature_entry`,`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores pet levels stats.';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2546,6 +2594,22 @@ CREATE TABLE `quest_offer_reward` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `quest_offer_reward_locale`
+--
+
+DROP TABLE IF EXISTS `quest_offer_reward_locale`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `quest_offer_reward_locale` (
+ `ID` int(10) unsigned NOT NULL DEFAULT '0',
+ `locale` varchar(4) NOT NULL,
+ `RewardText` text,
+ `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`,`locale`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `quest_poi`
--
@@ -2604,6 +2668,22 @@ CREATE TABLE `quest_request_items` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `quest_request_items_locale`
+--
+
+DROP TABLE IF EXISTS `quest_request_items_locale`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `quest_request_items_locale` (
+ `ID` int(10) unsigned NOT NULL DEFAULT '0',
+ `locale` varchar(4) NOT NULL,
+ `CompletionText` text,
+ `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`,`locale`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `quest_template`
--
@@ -2762,8 +2842,6 @@ CREATE TABLE `quest_template_locale` (
`Title` text,
`Details` text,
`Objectives` text,
- `OfferRewardText` text,
- `RequestItemsText` text,
`EndText` text,
`CompletedText` text,
`ObjectiveText1` text,
@@ -3013,6 +3091,7 @@ CREATE TABLE `smart_scripts` (
`target_param1` int(10) unsigned NOT NULL DEFAULT '0',
`target_param2` int(10) unsigned NOT NULL DEFAULT '0',
`target_param3` int(10) unsigned NOT NULL DEFAULT '0',
+ `target_param4` int(10) unsigned NOT NULL DEFAULT '0',
`target_x` float NOT NULL DEFAULT '0',
`target_y` float NOT NULL DEFAULT '0',
`target_z` float NOT NULL DEFAULT '0',
@@ -3196,6 +3275,7 @@ CREATE TABLE `spell_dbc` (
`EffectSpellClassMaskC1` int(10) unsigned NOT NULL DEFAULT '0',
`EffectSpellClassMaskC2` int(10) unsigned NOT NULL DEFAULT '0',
`EffectSpellClassMaskC3` int(10) unsigned NOT NULL DEFAULT '0',
+ `SpellName` varchar(100) DEFAULT NULL,
`MaxTargetLevel` int(10) unsigned NOT NULL DEFAULT '0',
`SpellFamilyName` int(10) unsigned NOT NULL DEFAULT '0',
`SpellFamilyFlags1` int(10) unsigned NOT NULL DEFAULT '0',
@@ -3209,7 +3289,6 @@ CREATE TABLE `spell_dbc` (
`DmgMultiplier3` float NOT NULL DEFAULT '0',
`AreaGroupId` int(11) NOT NULL DEFAULT '0',
`SchoolMask` int(10) unsigned NOT NULL DEFAULT '0',
- `Comment` text NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom spell.dbc entries';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3475,6 +3554,61 @@ CREATE TABLE `spelldifficulty_dbc` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `trainer`
+--
+
+DROP TABLE IF EXISTS `trainer`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `trainer` (
+ `Id` int(10) unsigned NOT NULL DEFAULT '0',
+ `Type` tinyint(2) unsigned NOT NULL DEFAULT '2',
+ `Requirement` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `Greeting` text,
+ `VerifiedBuild` smallint(5) DEFAULT '0',
+ PRIMARY KEY (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trainer_locale`
+--
+
+DROP TABLE IF EXISTS `trainer_locale`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `trainer_locale` (
+ `Id` int(10) unsigned NOT NULL DEFAULT '0',
+ `locale` varchar(4) NOT NULL,
+ `Greeting_lang` text,
+ `VerifiedBuild` smallint(5) DEFAULT '0',
+ PRIMARY KEY (`Id`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trainer_spell`
+--
+
+DROP TABLE IF EXISTS `trainer_spell`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `trainer_spell` (
+ `TrainerId` int(10) unsigned NOT NULL DEFAULT '0',
+ `SpellId` int(10) unsigned NOT NULL DEFAULT '0',
+ `MoneyCost` int(10) unsigned NOT NULL DEFAULT '0',
+ `ReqSkillLine` int(10) unsigned NOT NULL DEFAULT '0',
+ `ReqSkillRank` int(10) unsigned NOT NULL DEFAULT '0',
+ `ReqAbility1` int(10) unsigned NOT NULL DEFAULT '0',
+ `ReqAbility2` int(10) unsigned NOT NULL DEFAULT '0',
+ `ReqAbility3` int(10) unsigned NOT NULL DEFAULT '0',
+ `ReqLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `VerifiedBuild` smallint(5) DEFAULT '0',
+ PRIMARY KEY (`TrainerId`,`SpellId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `transports`
--
@@ -3691,4 +3825,4 @@ CREATE TABLE `waypoints` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2018-02-18 19:49:40
+-- Dump completed on 2019-03-19 7:18:01