Core/Player: Implement PvP Talents (#19962)

* SPELL_AURA_119 -> SPELL_AURA_PVP_TALENTS
* Learn Honorable Medallion when pvp rules are enabled

3 files changed, 80 insertions, 1 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 55abfac06c7..9e08c4a4a31 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1087,6 +1087,30 @@ LOCK TABLES `character_pet_declinedname` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `character_pvp_talent`
+--
+
+DROP TABLE IF EXISTS `character_pvp_talent`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `character_pvp_talent` (
+  `guid` bigint(20) unsigned NOT NULL,
+  `talentId` mediumint(8) unsigned NOT NULL,
+  `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`guid`,`talentId`,`talentGroup`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `character_pvp_talent`
+--
+
+LOCK TABLES `character_pvp_talent` WRITE;
+/*!40000 ALTER TABLE `character_pvp_talent` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_pvp_talent` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `character_queststatus`
 --
 
@@ -3537,7 +3561,8 @@ INSERT INTO `updates` VALUES
 ('2017_10_29_00_characters.sql','8CFC473E7E87E58C317A72016BF69E9050D3BC83','ARCHIVED','2017-04-19 00:07:40',25),
 ('2018_02_03_00_characters.sql','73E9BFD848D7A22F2A7DD89CF64E30E3A8689512','ARCHIVED','2018-02-03 23:52:42',0),
 ('2018_02_08_00_characters.sql','75FA162A9B85D678B26F972371265F1EC2C75187','ARCHIVED','2018-02-08 22:23:28',0),
-('2018_02_19_00_characters.sql','75A0FFAFD0633921708DB0F72F9CC9796ACB960B','RELEASED','2018-02-19 22:33:32',117);
+('2018_02_19_00_characters.sql','75A0FFAFD0633921708DB0F72F9CC9796ACB960B','RELEASED','2018-02-19 22:33:32',117),
+('2018_03_04_00_characters.sql','2A4CD2EE2547E718490706FADC78BF36F0DED8D6','RELEASED','2018-03-04 18:15:24',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/characters/master/2018_03_04_00_characters.sql b/sql/updates/characters/master/2018_03_04_00_characters.sql
new file mode 100644
index 00000000000..66ce84bad5e
--- /dev/null
+++ b/sql/updates/characters/master/2018_03_04_00_characters.sql
@@ -0,0 +1,10 @@
+--
+-- Table structure for table `character_pvp_talent`
+--
+DROP TABLE IF EXISTS `character_pvp_talent`;
+CREATE TABLE `character_pvp_talent` (
+  `guid` bigint(20) unsigned NOT NULL,
+  `talentId` mediumint(8) unsigned NOT NULL,
+  `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`guid`,`talentId`,`talentGroup`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/hotfixes/master/2018_03_04_00_hotfixes.sql b/sql/updates/hotfixes/master/2018_03_04_00_hotfixes.sql
new file mode 100644
index 00000000000..ef7a3adfc49
--- /dev/null
+++ b/sql/updates/hotfixes/master/2018_03_04_00_hotfixes.sql
@@ -0,0 +1,44 @@
+--
+-- Table structure for table `pvp_talent`
+--
+DROP TABLE IF EXISTS `pvp_talent`;
+CREATE TABLE `pvp_talent` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Description` text,
+  `SpellID` int(10) NOT NULL DEFAULT '0',
+  `OverridesSpellID` int(10) NOT NULL DEFAULT '0',
+  `ExtraSpellID` int(10) NOT NULL DEFAULT '0',
+  `TierID` int(10) NOT NULL DEFAULT '0',
+  `ColumnIndex` int(10) NOT NULL DEFAULT '0',
+  `Flags` int(10) NOT NULL DEFAULT '0',
+  `ClassID` int(10) NOT NULL DEFAULT '0',
+  `SpecID` int(10) NOT NULL DEFAULT '0',
+  `Role` int(10) NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `pvp_talent_locale`
+--
+DROP TABLE IF EXISTS `pvp_talent_locale`;
+CREATE TABLE `pvp_talent_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Description_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `pvp_talent_unlock`
+--
+DROP TABLE IF EXISTS `pvp_talent_unlock`;
+CREATE TABLE `pvp_talent_unlock` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `TierID` int(10) NOT NULL DEFAULT '0',
+  `ColumnIndex` int(10) NOT NULL DEFAULT '0',
+  `HonorLevel` int(10) NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;