diff options
| author | Shauren <shauren.trinity@gmail.com> | 2020-02-17 23:58:47 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2020-02-17 23:58:47 +0100 |
| commit | 90628b7d29e041310abc25438f219a0c73c41bae (patch) | |
| tree | 27bf5b09c958335bc1b17189cedb08dc4e5886e4 /sql/updates/characters | |
| parent | 462a10de17003631957b69e578e7e4c55ed1ef61 (diff) | |
Core/DataStores: Updated db2 structures to 8.3.0
Diffstat (limited to 'sql/updates/characters')
| -rw-r--r-- | sql/updates/characters/master/2020_02_17_00_characters.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/characters/master/2020_02_17_00_characters.sql b/sql/updates/characters/master/2020_02_17_00_characters.sql index 171f0461235..fe5e8134c8d 100644 --- a/sql/updates/characters/master/2020_02_17_00_characters.sql +++ b/sql/updates/characters/master/2020_02_17_00_characters.sql @@ -1 +1,7 @@ UPDATE `character_inventory` SET `slot`=`slot`+4 WHERE `slot`>=47 AND `bag`=0;
+
+ALTER TABLE `item_instance_azerite`
+ ADD `selectedAzeriteEssences1azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences1azeriteEssenceId3`,
+ ADD `selectedAzeriteEssences2azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences2azeriteEssenceId3`,
+ ADD `selectedAzeriteEssences3azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences3azeriteEssenceId3`,
+ ADD `selectedAzeriteEssences4azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences4azeriteEssenceId3`;
|