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

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/updates/characters/3.3.5/2017_04_03_00_characters.sql b/sql/updates/characters/3.3.5/2017_04_03_00_characters.sql
new file mode 100644
index 00000000000..8519bd94556
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2017_04_03_00_characters.sql
@@ -0,0 +1,11 @@
+ALTER TABLE `character_arena_stats`
+CHANGE `guid` `guid` INT(10) 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` INT(10) 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` INT(10) unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)';