Core/Battlegrounds: Allow full range of uint32 values in pvpstats_players table (#22187)

2 files changed, 25 insertions, 12 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 1084311bc84..ef73caef3aa 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -3385,17 +3385,17 @@ CREATE TABLE `pvpstats_players` (
   `battleground_id` bigint(20) unsigned NOT NULL,
   `character_guid` bigint(20) unsigned NOT NULL,
   `winner` bit(1) NOT NULL,
-  `score_killing_blows` mediumint(8) unsigned NOT NULL,
-  `score_deaths` mediumint(8) unsigned NOT NULL,
-  `score_honorable_kills` mediumint(8) unsigned NOT NULL,
-  `score_bonus_honor` mediumint(8) unsigned NOT NULL,
-  `score_damage_done` mediumint(8) unsigned NOT NULL,
-  `score_healing_done` mediumint(8) unsigned NOT NULL,
-  `attr_1` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `attr_2` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `attr_3` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `attr_4` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `attr_5` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `score_killing_blows` int(10) unsigned NOT NULL,
+  `score_deaths` int(10) unsigned NOT NULL,
+  `score_honorable_kills` int(10) unsigned NOT NULL,
+  `score_bonus_honor` int(10) unsigned NOT NULL,
+  `score_damage_done` int(10) unsigned NOT NULL,
+  `score_healing_done` int(10) unsigned NOT NULL,
+  `attr_1` int(10) unsigned NOT NULL DEFAULT '0',
+  `attr_2` int(10) unsigned NOT NULL DEFAULT '0',
+  `attr_3` int(10) unsigned NOT NULL DEFAULT '0',
+  `attr_4` int(10) unsigned NOT NULL DEFAULT '0',
+  `attr_5` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`battleground_id`,`character_guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3563,7 +3563,8 @@ INSERT INTO `updates` VALUES
 ('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_03_04_00_characters.sql','2A4CD2EE2547E718490706FADC78BF36F0DED8D6','RELEASED','2018-03-04 18:15:24',0),
-('2018_04_28_00_characters.sql','CBD0FDC0F32DE3F456F7CE3D9CAD6933CD6A50F5','RELEASED','2018-04-28 12:44:09',0);
+('2018_04_28_00_characters.sql','CBD0FDC0F32DE3F456F7CE3D9CAD6933CD6A50F5','RELEASED','2018-04-28 12:44:09',0),
+('2018_07_28_00_characters.sql','31F66AE7831251A8915625EC7F10FA138AB8B654','RELEASED','2018-07-28 18:30:19',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
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;