diff options
| author | TDB Release <tdb-release@build.bot> | 2022-03-06 15:20:27 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2022-03-06 15:20:27 +0000 |
| commit | 85b15a4b8c798f0bcb190a5481d624e6eb091e67 (patch) | |
| tree | e75c0f2f758d648d453c9035ad4767c4ac056683 /sql/updates/characters | |
| parent | b7fa116704a4edc28aa0b66bc326cab9ea26a799 (diff) | |
TDB 920.22031 - 2022/03/06TDB920.22031
Diffstat (limited to 'sql/updates/characters')
| -rw-r--r-- | sql/updates/characters/master/2022_01_31_00_characters.sql | 1 | ||||
| -rw-r--r-- | sql/updates/characters/master/2022_01_31_01_characters.sql | 3 | ||||
| -rw-r--r-- | sql/updates/characters/master/2022_01_31_02_characters.sql | 3 | ||||
| -rw-r--r-- | sql/updates/characters/master/2022_02_28_00_characters_2020_09_27_00_characters.sql | 1 | ||||
| -rw-r--r-- | sql/updates/characters/master/2022_03_06_00_characters.sql (renamed from sql/updates/characters/master/2022_01_15_00_characters.sql) | 2 |
5 files changed, 1 insertions, 9 deletions
diff --git a/sql/updates/characters/master/2022_01_31_00_characters.sql b/sql/updates/characters/master/2022_01_31_00_characters.sql deleted file mode 100644 index ef9bc6ecb53..00000000000 --- a/sql/updates/characters/master/2022_01_31_00_characters.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `characters` DROP `stable_slots`; diff --git a/sql/updates/characters/master/2022_01_31_01_characters.sql b/sql/updates/characters/master/2022_01_31_01_characters.sql deleted file mode 100644 index 9b5efaa5eec..00000000000 --- a/sql/updates/characters/master/2022_01_31_01_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE `characters` ADD `summonedPetNumber` int unsigned NOT NULL DEFAULT '0' AFTER `extra_flags`; - -UPDATE `characters` SET `summonedPetNumber` = COALESCE((SELECT `id` FROM `character_pet` WHERE `owner` = `guid` AND `slot` = 0 AND `curhealth` > 0), 0); diff --git a/sql/updates/characters/master/2022_01_31_02_characters.sql b/sql/updates/characters/master/2022_01_31_02_characters.sql deleted file mode 100644 index 06b223de895..00000000000 --- a/sql/updates/characters/master/2022_01_31_02_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE `character_pet` CHANGE `slot` `slot` smallint NOT NULL DEFAULT '-1'; - -UPDATE `character_pet` SET `slot` = -1 WHERE `slot` = 100; diff --git a/sql/updates/characters/master/2022_02_28_00_characters_2020_09_27_00_characters.sql b/sql/updates/characters/master/2022_02_28_00_characters_2020_09_27_00_characters.sql deleted file mode 100644 index fb648b58528..00000000000 --- a/sql/updates/characters/master/2022_02_28_00_characters_2020_09_27_00_characters.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `auctionhouse` ADD `serverFlags` tinyint unsigned NOT NULL DEFAULT '0' AFTER `endTime`; diff --git a/sql/updates/characters/master/2022_01_15_00_characters.sql b/sql/updates/characters/master/2022_03_06_00_characters.sql index 9fc61f158ff..9af77726636 100644 --- a/sql/updates/characters/master/2022_01_15_00_characters.sql +++ b/sql/updates/characters/master/2022_03_06_00_characters.sql @@ -1,3 +1,3 @@ --- TDB 915.22012 characters +-- TDB 920.22031 characters UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/characters', 'ARCHIVED'); |