diff options
| author | Aokromes <aokromes@gmail.com> | 2020-03-11 15:10:15 +0100 |
|---|---|---|
| committer | Aokromes <aokromes@gmail.com> | 2020-03-11 15:10:15 +0100 |
| commit | 79099fb95ded51a59999386a154986127c0f052a (patch) | |
| tree | 3e94d6319e2bf6f90f83a1f0bf67ae1e9bd77fe6 /sql/updates | |
| parent | f30e06db8a66aef1f1589a9d2e681c1bc582bb74 (diff) | |
DB/Characters: Fix encoding
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/master/2020_02_17_00_characters.sql | 14 |
1 files changed, 7 insertions, 7 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 fe5e8134c8d..ed834a9dd6f 100644 --- a/sql/updates/characters/master/2020_02_17_00_characters.sql +++ b/sql/updates/characters/master/2020_02_17_00_characters.sql @@ -1,7 +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`;
+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`; |