TDB 343.23121 - 2023/12/20TDB343.23121

12 files changed, 2 insertions, 60 deletions

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/master/2023_10_06_00_characters.sql b/sql/updates/characters/wotlk_classic/2023_12_20_00_characters.sql
index 89ca5b774ad..7a085e369cb 100644
--- a/sql/updates/characters/master/2023_10_06_00_characters.sql
+++ b/sql/updates/characters/wotlk_classic/2023_12_20_00_characters.sql
@@ -1,3 +1,4 @@
--- TDB 1017.23101 characters
+-- 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');