aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2018-09-18 23:37:45 +0200
committerShauren <shauren.trinity@gmail.com>2018-09-26 19:01:31 +0200
commite0309d94c8502d57734998cac769c474f355f7a2 (patch)
treea6c162585dccc51156eebc6a665c761a74788d52 /sql/updates
parent573dd01c6c51c0898ac17bb3073a5a7e7db89193 (diff)
Core/Players: Updated pvp talent implementation to bfa
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/characters/master/2018_09_18_00_characters.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/characters/master/2018_09_18_00_characters.sql b/sql/updates/characters/master/2018_09_18_00_characters.sql
new file mode 100644
index 00000000000..8a2dc041fe3
--- /dev/null
+++ b/sql/updates/characters/master/2018_09_18_00_characters.sql
@@ -0,0 +1,8 @@
+TRUNCATE `character_pvp_talent`;
+ALTER TABLE `character_pvp_talent`
+ DROP PRIMARY KEY,
+ CHANGE `talentId` `talentId0` int(10) unsigned NOT NULL AFTER `guid`,
+ ADD `talentId1` int(10) unsigned NOT NULL AFTER `talentId0`,
+ ADD `talentId2` int(10) unsigned NOT NULL AFTER `talentId1`,
+ ADD `talentId3` int(10) unsigned NOT NULL AFTER `talentId2`,
+ ADD PRIMARY KEY(`guid`,`talentGroup`);