From f5c8b53b2e3d4203d74ba1af2b0345efe7609db3 Mon Sep 17 00:00:00 2001 From: funjoker Date: Thu, 21 Dec 2023 00:28:23 +0100 Subject: TDB 343.23121 - 2023/12/20 --- .../characters/master/2023_10_06_00_characters.sql | 3 --- .../characters/master/2023_11_02_00_characters.sql | 1 - .../characters/master/2023_11_09_00_characters.sql | 6 ------ .../wotlk_classic/2023_11_16_00_characters.sql | 1 - .../wotlk_classic/2023_11_19_00_characters.sql | 4 ---- .../wotlk_classic/2023_11_20_00_characters.sql | 2 -- .../wotlk_classic/2023_11_21_00_characters.sql | 5 ----- .../wotlk_classic/2023_11_22_00_characters.sql | 19 ------------------- .../wotlk_classic/2023_11_23_00_characters.sql | 1 - .../wotlk_classic/2023_11_25_00_characters.sql | 4 ---- .../wotlk_classic/2023_11_27_00_characters.sql | 11 ----------- .../wotlk_classic/2023_12_03_00_characters.sql | 5 ----- .../wotlk_classic/2023_12_20_00_characters.sql | 4 ++++ 13 files changed, 4 insertions(+), 62 deletions(-) delete mode 100644 sql/updates/characters/master/2023_10_06_00_characters.sql delete mode 100644 sql/updates/characters/master/2023_11_02_00_characters.sql delete mode 100644 sql/updates/characters/master/2023_11_09_00_characters.sql delete mode 100644 sql/updates/characters/wotlk_classic/2023_11_16_00_characters.sql delete mode 100644 sql/updates/characters/wotlk_classic/2023_11_19_00_characters.sql delete mode 100644 sql/updates/characters/wotlk_classic/2023_11_20_00_characters.sql delete mode 100644 sql/updates/characters/wotlk_classic/2023_11_21_00_characters.sql delete mode 100644 sql/updates/characters/wotlk_classic/2023_11_22_00_characters.sql delete mode 100644 sql/updates/characters/wotlk_classic/2023_11_23_00_characters.sql delete mode 100644 sql/updates/characters/wotlk_classic/2023_11_25_00_characters.sql delete mode 100644 sql/updates/characters/wotlk_classic/2023_11_27_00_characters.sql delete mode 100644 sql/updates/characters/wotlk_classic/2023_12_03_00_characters.sql create mode 100644 sql/updates/characters/wotlk_classic/2023_12_20_00_characters.sql (limited to 'sql/updates/characters') diff --git a/sql/updates/characters/master/2023_10_06_00_characters.sql b/sql/updates/characters/master/2023_10_06_00_characters.sql deleted file mode 100644 index 89ca5b774ad..00000000000 --- a/sql/updates/characters/master/2023_10_06_00_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ --- TDB 1017.23101 characters -UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; -REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/characters', 'ARCHIVED'); diff --git a/sql/updates/characters/master/2023_11_02_00_characters.sql b/sql/updates/characters/master/2023_11_02_00_characters.sql deleted file mode 100644 index 1c06a0785a4..00000000000 --- a/sql/updates/characters/master/2023_11_02_00_characters.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE ctc, cte FROM `character_trait_config` ctc LEFT JOIN `character_trait_entry` cte ON ctc.`guid` = cte.`guid` AND ctc.`traitConfigId` = cte.`traitConfigId` WHERE ctc.`type` = 3; diff --git a/sql/updates/characters/master/2023_11_09_00_characters.sql b/sql/updates/characters/master/2023_11_09_00_characters.sql deleted file mode 100644 index dec6bfc0432..00000000000 --- a/sql/updates/characters/master/2023_11_09_00_characters.sql +++ /dev/null @@ -1,6 +0,0 @@ -ALTER TABLE `characters` - ADD `personalTabardEmblemStyle` int NOT NULL DEFAULT -1 AFTER `lastLoginBuild`, - ADD `personalTabardEmblemColor` int NOT NULL DEFAULT -1 AFTER `personalTabardEmblemStyle`, - ADD `personalTabardBorderStyle` int NOT NULL DEFAULT -1 AFTER `personalTabardEmblemColor`, - ADD `personalTabardBorderColor` int NOT NULL DEFAULT -1 AFTER `personalTabardBorderStyle`, - ADD `personalTabardBackgroundColor` int NOT NULL DEFAULT -1 AFTER `personalTabardBorderColor`; diff --git a/sql/updates/characters/wotlk_classic/2023_11_16_00_characters.sql b/sql/updates/characters/wotlk_classic/2023_11_16_00_characters.sql deleted file mode 100644 index f770c867236..00000000000 --- a/sql/updates/characters/wotlk_classic/2023_11_16_00_characters.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `character_action` MODIFY `action` int unsigned NOT NULL DEFAULT 0; diff --git a/sql/updates/characters/wotlk_classic/2023_11_19_00_characters.sql b/sql/updates/characters/wotlk_classic/2023_11_19_00_characters.sql deleted file mode 100644 index aabb3180e67..00000000000 --- a/sql/updates/characters/wotlk_classic/2023_11_19_00_characters.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE `characters` - DROP COLUMN `activeTalentGroup`, - CHANGE `primarySpecialization` `activeTalentGroup` TINYINT UNSIGNED DEFAULT 0 NOT NULL, - ADD COLUMN `bonusTalentGroups` TINYINT UNSIGNED DEFAULT 0 NOT NULL AFTER `activeTalentGroup`; diff --git a/sql/updates/characters/wotlk_classic/2023_11_20_00_characters.sql b/sql/updates/characters/wotlk_classic/2023_11_20_00_characters.sql deleted file mode 100644 index 3c8be1ba07d..00000000000 --- a/sql/updates/characters/wotlk_classic/2023_11_20_00_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `character_talent` - ADD COLUMN `talentRank` TINYINT UNSIGNED DEFAULT 0 NOT NULL AFTER `talentId`; diff --git a/sql/updates/characters/wotlk_classic/2023_11_21_00_characters.sql b/sql/updates/characters/wotlk_classic/2023_11_21_00_characters.sql deleted file mode 100644 index d0c3dae0e4d..00000000000 --- a/sql/updates/characters/wotlk_classic/2023_11_21_00_characters.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE `character_glyphs` - ADD COLUMN `glyphSlot` TINYINT UNSIGNED DEFAULT 0 NOT NULL AFTER `talentGroup`, - CHANGE `glyphId` `glyphId` SMALLINT UNSIGNED DEFAULT 0 NOT NULL AFTER `glyphSlot`, - DROP PRIMARY KEY, - ADD PRIMARY KEY (`guid`, `talentGroup`, `glyphSlot`, `glyphId`); diff --git a/sql/updates/characters/wotlk_classic/2023_11_22_00_characters.sql b/sql/updates/characters/wotlk_classic/2023_11_22_00_characters.sql deleted file mode 100644 index 97c316db5ce..00000000000 --- a/sql/updates/characters/wotlk_classic/2023_11_22_00_characters.sql +++ /dev/null @@ -1,19 +0,0 @@ -ALTER TABLE `item_instance` - DROP COLUMN `bonusListIDs`, - DROP COLUMN `randomBonusListId`; - -DROP TABLE IF EXISTS `item_instance_artifact`; -DROP TABLE IF EXISTS `item_instance_artifact_powers`; -DROP TABLE IF EXISTS `item_instance_azerite`; -DROP TABLE IF EXISTS `item_instance_azerite_empowered`; -DROP TABLE IF EXISTS `item_instance_azerite_milestone_power`; -DROP TABLE IF EXISTS `item_instance_azerite_unlocked_essence`; - -ALTER TABLE `character_void_storage` - DROP COLUMN `randomBonusListId`, - DROP COLUMN `artifactKnowledgeLevel`, - DROP COLUMN `bonusListIDs`; - -ALTER TABLE `item_loot_items` - DROP COLUMN `rnd_bonus`, - DROP COLUMN `bonus_list_ids`; diff --git a/sql/updates/characters/wotlk_classic/2023_11_23_00_characters.sql b/sql/updates/characters/wotlk_classic/2023_11_23_00_characters.sql deleted file mode 100644 index f76ebf7bcba..00000000000 --- a/sql/updates/characters/wotlk_classic/2023_11_23_00_characters.sql +++ /dev/null @@ -1 +0,0 @@ -DROP TABLE IF EXISTS `item_instance_modifiers`; diff --git a/sql/updates/characters/wotlk_classic/2023_11_25_00_characters.sql b/sql/updates/characters/wotlk_classic/2023_11_25_00_characters.sql deleted file mode 100644 index 32bd61292c1..00000000000 --- a/sql/updates/characters/wotlk_classic/2023_11_25_00_characters.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE `item_instance_gems` - DROP COLUMN `gemScalingLevel1`, - DROP COLUMN `gemScalingLevel2`, - DROP COLUMN `gemScalingLevel3`; diff --git a/sql/updates/characters/wotlk_classic/2023_11_27_00_characters.sql b/sql/updates/characters/wotlk_classic/2023_11_27_00_characters.sql deleted file mode 100644 index 12c5f735bf0..00000000000 --- a/sql/updates/characters/wotlk_classic/2023_11_27_00_characters.sql +++ /dev/null @@ -1,11 +0,0 @@ -ALTER TABLE `item_instance` - ADD COLUMN `randomPropertiesId` INT DEFAULT 0 NOT NULL AFTER `battlePetDisplayId`, - ADD COLUMN `randomPropertiesSeed` INT DEFAULT 0 NOT NULL AFTER `randomPropertiesId`; - -ALTER TABLE `item_loot_items` - ADD COLUMN `random_properties_id` INT DEFAULT 0 NOT NULL AFTER `needs_quest`, - ADD COLUMN `random_properties_seed` INT DEFAULT 0 NOT NULL AFTER `random_properties_id`; - -ALTER TABLE `character_void_storage` - ADD COLUMN `randomPropertiesId` INT DEFAULT 0 NOT NULL AFTER `fixedScalingLevel`, - ADD COLUMN `randomPropertiesSeed` INT DEFAULT 0 NOT NULL AFTER `randomPropertiesId`; diff --git a/sql/updates/characters/wotlk_classic/2023_12_03_00_characters.sql b/sql/updates/characters/wotlk_classic/2023_12_03_00_characters.sql deleted file mode 100644 index f5989d6dcc5..00000000000 --- a/sql/updates/characters/wotlk_classic/2023_12_03_00_characters.sql +++ /dev/null @@ -1,5 +0,0 @@ -DROP TABLE IF EXISTS `character_garrison`; -DROP TABLE IF EXISTS `character_garrison_blueprints`; -DROP TABLE IF EXISTS `character_garrison_buildings`; -DROP TABLE IF EXISTS `character_garrison_follower_abilities`; -DROP TABLE IF EXISTS `character_garrison_followers`; diff --git a/sql/updates/characters/wotlk_classic/2023_12_20_00_characters.sql b/sql/updates/characters/wotlk_classic/2023_12_20_00_characters.sql new file mode 100644 index 00000000000..7a085e369cb --- /dev/null +++ b/sql/updates/characters/wotlk_classic/2023_12_20_00_characters.sql @@ -0,0 +1,4 @@ +-- TDB 343.23121 characters +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/characters', 'ARCHIVED'); +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/3.4.x/characters', 'ARCHIVED'); -- cgit v1.2.3