diff options
| author | Shauren <shauren.trinity@gmail.com> | 2022-01-31 21:50:32 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-31 21:50:32 +0100 |
| commit | 22e823b5f9693e461ee158913c1caf3484eeb039 (patch) | |
| tree | 1ad3d36956a97daffa112a53e7d71096b0483f37 /sql/updates/characters | |
| parent | 8349444749227b3fd95196c7d74d9a3dde22dd6b (diff) | |
Core/Pets: Change PET_SAVE_NOT_IN_SLOT constant from 100 to -1 to truly avoid conflicts when growing stable size and change PET_SAVE_AS_DELETED from -1 to -2
Diffstat (limited to 'sql/updates/characters')
| -rw-r--r-- | sql/updates/characters/master/2022_01_31_02_characters.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/characters/master/2022_01_31_02_characters.sql b/sql/updates/characters/master/2022_01_31_02_characters.sql new file mode 100644 index 00000000000..06b223de895 --- /dev/null +++ b/sql/updates/characters/master/2022_01_31_02_characters.sql @@ -0,0 +1,3 @@ +ALTER TABLE `character_pet` CHANGE `slot` `slot` smallint NOT NULL DEFAULT '-1'; + +UPDATE `character_pet` SET `slot` = -1 WHERE `slot` = 100; |