aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters/master
diff options
context:
space:
mode:
authorJeremy <Golrag@users.noreply.github.com>2018-03-04 22:32:08 +0100
committerShauren <shauren.trinity@gmail.com>2018-03-04 22:32:08 +0100
commitf411b7a90e4900c9e2df7c1e0c7a301360408cec (patch)
tree9793744cf0749d37bb13d6d69355b8672e5f6c34 /sql/updates/characters/master
parente0eafc1cac9d840f897f9269e8440aaebfab6a96 (diff)
Core/Player: Implement PvP Talents (#19962)
* SPELL_AURA_119 -> SPELL_AURA_PVP_TALENTS * Learn Honorable Medallion when pvp rules are enabled
Diffstat (limited to 'sql/updates/characters/master')
-rw-r--r--sql/updates/characters/master/2018_03_04_00_characters.sql10
1 files changed, 10 insertions, 0 deletions
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;