From 1e294f753ed26097f9cbdf7b9ee1432862ed3260 Mon Sep 17 00:00:00 2001 From: ariel- Date: Mon, 3 Apr 2017 01:05:17 -0300 Subject: DB/Schema: add unsigned to some guid fields in characters (cherry picked from commit 0c698b4567044f67eb52f6459308fb6edf693966) --- .../2020_04_25_00_characters_2017_04_03_00_characters.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/characters/master/2020_04_25_00_characters_2017_04_03_00_characters.sql (limited to 'sql/updates') 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)'; -- cgit v1.2.3