From ec9d624aec9e0a39b1bcee7d4077f46be358faad Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 22 Nov 2019 11:02:04 +0100 Subject: Core/Items: Implement azerite essences * Implement inspecting heart of azeroth data * Fixed heart of azeroth item level - bonuses now apply --- .../characters/master/2019_11_22_00_characters.sql | 38 +++++++++ .../hotfixes/master/2019_11_22_00_hotfixes.sql | 96 ++++++++++++++++++++++ 2 files changed, 134 insertions(+) create mode 100644 sql/updates/characters/master/2019_11_22_00_characters.sql create mode 100644 sql/updates/hotfixes/master/2019_11_22_00_hotfixes.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/master/2019_11_22_00_characters.sql b/sql/updates/characters/master/2019_11_22_00_characters.sql new file mode 100644 index 00000000000..97671dfbbde --- /dev/null +++ b/sql/updates/characters/master/2019_11_22_00_characters.sql @@ -0,0 +1,38 @@ +ALTER TABLE `item_instance_azerite` + ADD `selectedAzeriteEssences1specId` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences1azeriteEssenceId1` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences1azeriteEssenceId2` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences1azeriteEssenceId3` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences2specId` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences2azeriteEssenceId1` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences2azeriteEssenceId2` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences2azeriteEssenceId3` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences3specId` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences3azeriteEssenceId1` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences3azeriteEssenceId2` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences3azeriteEssenceId3` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences4specId` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences4azeriteEssenceId1` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences4azeriteEssenceId2` int(10) unsigned NULL DEFAULT '0', + ADD `selectedAzeriteEssences4azeriteEssenceId3` int(10) unsigned NULL DEFAULT '0'; + +-- +-- Table structure for table `item_instance_azerite_milestone_power` +-- +DROP TABLE IF EXISTS `item_instance_azerite_milestone_power`; +CREATE TABLE `item_instance_azerite_milestone_power` ( + `itemGuid` bigint(20) unsigned NOT NULL, + `azeriteItemMilestonePowerId` int(10) unsigned NOT NULL, + PRIMARY KEY (`itemGuid`,`azeriteItemMilestonePowerId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `item_instance_azerite_unlocked_essence` +-- +DROP TABLE IF EXISTS `item_instance_azerite_unlocked_essence`; +CREATE TABLE `item_instance_azerite_unlocked_essence` ( + `itemGuid` bigint(20) unsigned NOT NULL, + `azeriteEssenceId` int(10) unsigned NOT NULL, + `rank` int(10) unsigned NOT NULL, + PRIMARY KEY (`itemGuid`,`azeriteEssenceId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/updates/hotfixes/master/2019_11_22_00_hotfixes.sql b/sql/updates/hotfixes/master/2019_11_22_00_hotfixes.sql new file mode 100644 index 00000000000..5951dec9aa2 --- /dev/null +++ b/sql/updates/hotfixes/master/2019_11_22_00_hotfixes.sql @@ -0,0 +1,96 @@ +-- +-- Table structure for table `azerite_essence` +-- +DROP TABLE IF EXISTS `azerite_essence`; +CREATE TABLE `azerite_essence` ( + `Name` text, + `Description` text, + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SpecSetID` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `azerite_essence_locale` +-- +DROP TABLE IF EXISTS `azerite_essence_locale`; +CREATE TABLE `azerite_essence_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name_lang` text, + `Description_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `azerite_essence_power` +-- +DROP TABLE IF EXISTS `azerite_essence_power`; +CREATE TABLE `azerite_essence_power` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SourceAlliance` text, + `SourceHorde` text, + `AzeriteEssenceID` int(11) NOT NULL DEFAULT '0', + `Tier` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MajorPowerDescription` int(11) NOT NULL DEFAULT '0', + `MinorPowerDescription` int(11) NOT NULL DEFAULT '0', + `MajorPowerActual` int(11) NOT NULL DEFAULT '0', + `MinorPowerActual` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `azerite_essence_power_locale` +-- +DROP TABLE IF EXISTS `azerite_essence_power_locale`; +CREATE TABLE `azerite_essence_power_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `SourceAlliance_lang` text, + `SourceHorde_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `azerite_item_milestone_power` +-- +DROP TABLE IF EXISTS `azerite_item_milestone_power`; +CREATE TABLE `azerite_item_milestone_power` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredLevel` int(11) NOT NULL DEFAULT '0', + `AzeritePowerID` int(11) NOT NULL DEFAULT '0', + `Type` int(11) NOT NULL DEFAULT '0', + `AutoUnlock` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `azerite_power` +-- +DROP TABLE IF EXISTS `azerite_power`; +CREATE TABLE `azerite_power` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(11) NOT NULL DEFAULT '0', + `ItemBonusListID` int(11) NOT NULL DEFAULT '0', + `SpecSetID` int(11) NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `spec_set_member` +-- +DROP TABLE IF EXISTS `spec_set_member`; +CREATE TABLE `spec_set_member` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ChrSpecializationID` int(11) NOT NULL DEFAULT '0', + `SpecSetID` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3