DB/Schema: add unsigned to some guid fields in characters

(cherry picked from commit 0c698b4567044f67eb52f6459308fb6edf693966)

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/updates/characters/master/2020_04_25_00_characters_2017_04_03_00_characters.sql b/sql/updates/characters/master/2020_04_25_00_characters_2017_04_03_00_characters.sql
new file mode 100644
index 00000000000..3a962753a55
--- /dev/null
+++ b/sql/updates/characters/master/2020_04_25_00_characters_2017_04_03_00_characters.sql
@@ -0,0 +1,11 @@
+ALTER TABLE `character_arena_stats`
+CHANGE `guid` `guid` BIGINT(20) unsigned NOT NULL DEFAULT '0',
+CHANGE `slot` `slot` TINYINT(3) unsigned NOT NULL DEFAULT '0',
+CHANGE `matchMakerRating` `matchMakerRating` SMALLINT(5) unsigned NOT NULL DEFAULT 0;
+
+ALTER TABLE `character_equipmentsets`
+CHANGE `guid` `guid` BIGINT(20) unsigned NOT NULL DEFAULT '0',
+CHANGE `setguid` `setguid` BIGINT(20) unsigned NOT NULL AUTO_INCREMENT;
+
+ALTER TABLE `item_loot_money`
+CHANGE `container_id` `container_id` BIGINT(20) unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)';