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 | |
| 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')
| -rw-r--r-- | sql/base/characters_database.sql | 6 | ||||
| -rw-r--r-- | sql/updates/characters/master/2022_01_31_02_characters.sql | 3 |
2 files changed, 7 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 044b995bc88..bdaa46253e0 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1164,7 +1164,7 @@ CREATE TABLE `character_pet` ( `Reactstate` tinyint unsigned NOT NULL DEFAULT '0', `name` varchar(21) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pet', `renamed` tinyint unsigned NOT NULL DEFAULT '0', - `slot` tinyint unsigned NOT NULL DEFAULT '0', + `slot` smallint NOT NULL DEFAULT '-1', `curhealth` int unsigned NOT NULL DEFAULT '1', `curmana` int unsigned NOT NULL DEFAULT '0', `savetime` int unsigned NOT NULL DEFAULT '0', @@ -3660,7 +3660,9 @@ INSERT INTO `updates` VALUES ('2022_01_02_00_characters.sql','5169A5BBACB42E6CEDE405D3C4843FD386CDF92E','ARCHIVED','2022-01-02 21:22:35',0), ('2022_01_09_00_characters.sql','3AC51F589821C17027CBA861EF762A709430CDB3','ARCHIVED','2022-01-09 21:29:45',0), ('2022_01_15_00_characters.sql','884EFB6592DC8A765E0C0BF8BF907B4E4733BB0C','ARCHIVED','2022-01-15 23:24:58',0), -('2022_01_31_00_characters.sql','19551474AA6079F0616B565F254914C5DD9ED1A1','RELEASED','2022-01-31 14:32:49',0); +('2022_01_31_00_characters.sql','19551474AA6079F0616B565F254914C5DD9ED1A1','RELEASED','2022-01-31 14:32:49',0), +('2022_01_31_01_characters.sql','E0A1FA670F4621AEB594D7ACBA4921CB298F54FF','RELEASED','2022-01-31 20:47:59',0), +('2022_01_31_02_characters.sql','6E3A3F02276287DD540BC4C17E246DFB850260D8','RELEASED','2022-01-31 21:43:38',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; 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; |