aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
authorPalabola <Palabola@users.noreply.github.com>2018-07-28 19:42:50 +0200
committerShauren <shauren.trinity@gmail.com>2018-07-28 19:42:50 +0200
commit394f9775a7c6d597c9744db37783985b2e228572 (patch)
treece4cac627ef77c8c1b67331bc55ad833a7e88756 /sql/updates/characters
parenta947c8204b37c91a96f34f2569bdb4ba2797dde5 (diff)
Core/Battlegrounds: Allow full range of uint32 values in pvpstats_players table (#22187)
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/master/2018_07_28_00_characters.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/characters/master/2018_07_28_00_characters.sql b/sql/updates/characters/master/2018_07_28_00_characters.sql
new file mode 100644
index 00000000000..a70985f7627
--- /dev/null
+++ b/sql/updates/characters/master/2018_07_28_00_characters.sql
@@ -0,0 +1,12 @@
+ALTER TABLE `pvpstats_players`
+ CHANGE `score_killing_blows` `score_killing_blows` int(10) unsigned NOT NULL,
+ CHANGE `score_deaths` `score_deaths` int(10) unsigned NOT NULL,
+ CHANGE `score_honorable_kills` `score_honorable_kills` int(10) unsigned NOT NULL,
+ CHANGE `score_bonus_honor` `score_bonus_honor` int(10) unsigned NOT NULL,
+ CHANGE `score_damage_done` `score_damage_done` int(10) unsigned NOT NULL,
+ CHANGE `score_healing_done` `score_healing_done` int(10) unsigned NOT NULL,
+ CHANGE `attr_1` `attr_1` int(10) unsigned NOT NULL,
+ CHANGE `attr_2` `attr_2` int(10) unsigned NOT NULL,
+ CHANGE `attr_3` `attr_3` int(10) unsigned NOT NULL,
+ CHANGE `attr_4` `attr_4` int(10) unsigned NOT NULL,
+ CHANGE `attr_5` `attr_5` int(10) unsigned NOT NULL;