diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/master/2020_04_25_00_characters_2017_04_03_00_characters.sql | 11 |
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)'; |