diff options
Diffstat (limited to 'sql/base/dev')
| -rw-r--r-- | sql/base/dev/world_database.sql | 176 |
1 files changed, 120 insertions, 56 deletions
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 85e7c2391da..67439898760 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 5.6.26, for Win64 (x86_64) +-- MySQL dump 10.16 Distrib 10.1.6-MariaDB, for Win64 (AMD64) -- -- Host: localhost Database: world -- ------------------------------------------------------ --- Server version 5.6.26-log +-- Server version 5.7.14-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -992,21 +992,6 @@ CREATE TABLE `game_event_seasonal_questrelation` ( /*!40101 SET character_set_client = @saved_cs_client */; -- --- Table structure for table `game_graveyard_zone` --- - -DROP TABLE IF EXISTS `game_graveyard_zone`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `game_graveyard_zone` ( - `id` mediumint(8) unsigned NOT NULL DEFAULT '0', - `ghost_zone` mediumint(8) unsigned NOT NULL DEFAULT '0', - `faction` smallint(5) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`id`,`ghost_zone`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trigger System'; -/*!40101 SET character_set_client = @saved_cs_client */; - --- -- Table structure for table `game_tele` -- @@ -1091,6 +1076,10 @@ DROP TABLE IF EXISTS `gameobject_addon`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gameobject_addon` ( `guid` int(10) unsigned NOT NULL DEFAULT '0', + `parent_rotation0` float NOT NULL DEFAULT '0', + `parent_rotation1` float NOT NULL DEFAULT '0', + `parent_rotation2` float NOT NULL DEFAULT '0', + `parent_rotation3` float NOT NULL DEFAULT '1', `invisibilityType` tinyint(3) unsigned NOT NULL DEFAULT '0', `invisibilityValue` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) @@ -1178,8 +1167,6 @@ CREATE TABLE `gameobject_template` ( `IconName` varchar(100) NOT NULL DEFAULT '', `castBarCaption` varchar(100) NOT NULL DEFAULT '', `unk1` varchar(100) NOT NULL DEFAULT '', - `faction` smallint(5) unsigned NOT NULL DEFAULT '0', - `flags` int(10) unsigned NOT NULL DEFAULT '0', `size` float NOT NULL DEFAULT '1', `Data0` int(10) unsigned NOT NULL DEFAULT '0', `Data1` int(11) NOT NULL DEFAULT '0', @@ -1214,6 +1201,23 @@ CREATE TABLE `gameobject_template` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `gameobject_template_addon` +-- + +DROP TABLE IF EXISTS `gameobject_template_addon`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `gameobject_template_addon` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `faction` smallint(5) unsigned NOT NULL DEFAULT '0', + `flags` int(10) unsigned NOT NULL DEFAULT '0', + `mingold` mediumint(8) unsigned NOT NULL DEFAULT '0', + `maxgold` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `gameobject_template_locale` -- @@ -1240,6 +1244,7 @@ DROP TABLE IF EXISTS `gossip_menu`; CREATE TABLE `gossip_menu` ( `entry` smallint(5) unsigned NOT NULL DEFAULT '0', `text_id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0', PRIMARY KEY (`entry`,`text_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1265,11 +1270,28 @@ CREATE TABLE `gossip_menu_option` ( `box_money` int(10) unsigned NOT NULL DEFAULT '0', `box_text` text, `BoxBroadcastTextID` mediumint(6) NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0', PRIMARY KEY (`menu_id`,`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `graveyard_zone` +-- + +DROP TABLE IF EXISTS `graveyard_zone`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `graveyard_zone` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `GhostZone` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Faction` smallint(5) unsigned NOT NULL DEFAULT '0', + `Comment` text, + PRIMARY KEY (`ID`,`GhostZone`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trigger System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `instance_encounters` -- @@ -2493,6 +2515,21 @@ CREATE TABLE `playercreateinfo_action` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `playercreateinfo_cast_spell` +-- + +DROP TABLE IF EXISTS `playercreateinfo_cast_spell`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `playercreateinfo_cast_spell` ( + `raceMask` int(10) unsigned NOT NULL DEFAULT '0', + `classMask` int(10) unsigned NOT NULL DEFAULT '0', + `spell` mediumint(8) unsigned NOT NULL DEFAULT '0', + `note` varchar(255) DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `playercreateinfo_item` -- @@ -2688,6 +2725,20 @@ CREATE TABLE `quest_details` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `quest_mail_sender` +-- + +DROP TABLE IF EXISTS `quest_mail_sender`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_mail_sender` ( + `QuestId` int(5) unsigned NOT NULL DEFAULT '0', + `RewardMailSenderEntry` int(5) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`QuestId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `quest_offer_reward` -- @@ -2982,6 +3033,42 @@ CREATE TABLE `reputation_spillover_template` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `script_spline_chain_meta` +-- + +DROP TABLE IF EXISTS `script_spline_chain_meta`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `script_spline_chain_meta` ( + `entry` int(10) unsigned NOT NULL, + `chainId` smallint(5) unsigned NOT NULL, + `splineId` tinyint(3) unsigned NOT NULL, + `expectedDuration` int(10) unsigned NOT NULL, + `msUntilNext` int(10) unsigned NOT NULL, + PRIMARY KEY (`entry`,`chainId`,`splineId`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `script_spline_chain_waypoints` +-- + +DROP TABLE IF EXISTS `script_spline_chain_waypoints`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `script_spline_chain_waypoints` ( + `entry` int(10) unsigned NOT NULL, + `chainId` smallint(5) unsigned NOT NULL, + `splineId` tinyint(3) unsigned NOT NULL, + `wpId` tinyint(3) unsigned NOT NULL, + `x` float NOT NULL, + `y` float NOT NULL, + `z` float NOT NULL, + PRIMARY KEY (`entry`,`chainId`,`splineId`,`wpId`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `script_waypoint` -- @@ -3099,7 +3186,7 @@ CREATE TABLE `smart_scripts` ( `event_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `event_phase_mask` tinyint(3) unsigned NOT NULL DEFAULT '0', `event_chance` tinyint(3) unsigned NOT NULL DEFAULT '100', - `event_flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `event_flags` smallint(3) unsigned NOT NULL DEFAULT '0', `event_param1` int(10) unsigned NOT NULL DEFAULT '0', `event_param2` int(10) unsigned NOT NULL DEFAULT '0', `event_param3` int(10) unsigned NOT NULL DEFAULT '0', @@ -3407,45 +3494,22 @@ DROP TABLE IF EXISTS `spell_proc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_proc` ( - `spellId` mediumint(8) NOT NULL DEFAULT '0', - `schoolMask` tinyint(4) NOT NULL DEFAULT '0', - `spellFamilyName` smallint(5) unsigned NOT NULL DEFAULT '0', - `spellFamilyMask0` int(10) unsigned NOT NULL DEFAULT '0', - `spellFamilyMask1` int(10) unsigned NOT NULL DEFAULT '0', - `spellFamilyMask2` int(10) unsigned NOT NULL DEFAULT '0', - `typeMask` int(10) unsigned NOT NULL DEFAULT '0', - `spellTypeMask` int(10) unsigned NOT NULL DEFAULT '0', - `spellPhaseMask` int(11) NOT NULL DEFAULT '0', - `hitMask` int(11) NOT NULL DEFAULT '0', - `attributesMask` int(10) unsigned NOT NULL DEFAULT '0', - `ratePerMinute` float NOT NULL DEFAULT '0', - `chance` float NOT NULL DEFAULT '0', - `cooldown` float unsigned NOT NULL DEFAULT '0', - `charges` int(10) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`spellId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `spell_proc_event` --- - -DROP TABLE IF EXISTS `spell_proc_event`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `spell_proc_event` ( - `entry` mediumint(8) NOT NULL DEFAULT '0', - `SchoolMask` tinyint(4) NOT NULL DEFAULT '0', + `SpellId` int(11) NOT NULL DEFAULT '0', + `SchoolMask` tinyint(3) unsigned NOT NULL DEFAULT '0', `SpellFamilyName` smallint(5) unsigned NOT NULL DEFAULT '0', `SpellFamilyMask0` int(10) unsigned NOT NULL DEFAULT '0', `SpellFamilyMask1` int(10) unsigned NOT NULL DEFAULT '0', `SpellFamilyMask2` int(10) unsigned NOT NULL DEFAULT '0', - `procFlags` int(10) unsigned NOT NULL DEFAULT '0', - `procEx` int(10) unsigned NOT NULL DEFAULT '0', - `ppmRate` float NOT NULL DEFAULT '0', - `CustomChance` float NOT NULL DEFAULT '0', + `ProcFlags` int(10) unsigned NOT NULL DEFAULT '0', + `SpellTypeMask` int(10) unsigned NOT NULL DEFAULT '0', + `SpellPhaseMask` int(10) unsigned NOT NULL DEFAULT '0', + `HitMask` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesMask` int(10) unsigned NOT NULL DEFAULT '0', + `ProcsPerMinute` float NOT NULL DEFAULT '0', + `Chance` float NOT NULL DEFAULT '0', `Cooldown` int(10) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`entry`) + `Charges` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`SpellId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3677,7 +3741,7 @@ CREATE TABLE `vehicle_template_accessory` ( /*!40101 SET character_set_client = @saved_cs_client */; -- --- Table structure for table `version` +-- Temporary table structure for view `version` -- DROP TABLE IF EXISTS `version`; @@ -3785,4 +3849,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2016-04-11 2:32:19 +-- Dump completed on 2016-10-16 15:05:26 |