TDB 440.24061 - 2024/06/02TDB440.24061

7 files changed, 2 insertions, 38 deletions

diff --git a/sql/updates/characters/cata_classic/2024_03_12_00_characters.sql b/sql/updates/characters/cata_classic/2024_03_12_00_characters.sql
deleted file mode 100644
index f5989d6dcc5..00000000000
--- a/sql/updates/characters/cata_classic/2024_03_12_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/cata_classic/2024_03_13_00_characters.sql b/sql/updates/characters/cata_classic/2024_03_13_00_characters.sql
deleted file mode 100644
index 44a9fe2ac83..00000000000
--- a/sql/updates/characters/cata_classic/2024_03_13_00_characters.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-DROP TABLE IF EXISTS `item_instance_azerite`;
-DROP TABLE IF EXISTS `item_instance_azerite_milestone_power`;
-DROP TABLE IF EXISTS `item_instance_azerite_unlocked_essence`;
-DROP TABLE IF EXISTS `item_instance_azerite_empowered`;
\ No newline at end of file
diff --git a/sql/updates/characters/cata_classic/2024_03_19_00_characters.sql b/sql/updates/characters/cata_classic/2024_03_19_00_characters.sql
deleted file mode 100644
index f770c867236..00000000000
--- a/sql/updates/characters/cata_classic/2024_03_19_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/cata_classic/2024_06_01_00_characters.sql b/sql/updates/characters/cata_classic/2024_06_01_00_characters.sql
deleted file mode 100644
index 143e3e1e620..00000000000
--- a/sql/updates/characters/cata_classic/2024_06_01_00_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE `item_instance_modifiers` 
-ADD COLUMN `itemReforgeId` int UNSIGNED NULL DEFAULT 0 AFTER `artifactKnowledgeLevel`;
diff --git a/sql/updates/characters/master/2024_02_08_00_characters.sql b/sql/updates/characters/cata_classic/2024_06_02_00_characters.sql
index 5197d985f77..8f0af751f11 100644
--- a/sql/updates/characters/master/2024_02_08_00_characters.sql
+++ b/sql/updates/characters/cata_classic/2024_06_02_00_characters.sql
@@ -1,3 +1,3 @@
--- TDB 1025.24021 characters
+-- TDB 440.24061 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/4.4.x/characters', 'ARCHIVED');
diff --git a/sql/updates/characters/master/2024_04_09_00_characters.sql b/sql/updates/characters/master/2024_04_09_00_characters.sql
deleted file mode 100644
index 7a9f88bbf5f..00000000000
--- a/sql/updates/characters/master/2024_04_09_00_characters.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-DELIMITER ;;
-CREATE PROCEDURE item_instance_deprecated_columns_2024_04_09_00() BEGIN
-  IF EXISTS (SELECT * FROM `information_schema`.`columns` WHERE `table_schema`=SCHEMA() AND `table_name`='item_instance' AND `column_name`='transmogrification') THEN
-
-    ALTER TABLE `item_instance` 
-      DROP `transmogrification`,
-      DROP `enchantIllusion`;
-
-  END IF;
-END;;
-
-DELIMITER ;
-CALL item_instance_deprecated_columns_2024_04_09_00();
-
-DROP PROCEDURE IF EXISTS item_instance_deprecated_columns_2024_04_09_00;
diff --git a/sql/updates/characters/master/2024_04_12_00_characters.sql b/sql/updates/characters/master/2024_04_12_00_characters.sql
deleted file mode 100644
index a26b60bb3c1..00000000000
--- a/sql/updates/characters/master/2024_04_12_00_characters.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-ALTER TABLE `item_instance` ADD `createTime` bigint NOT NULL DEFAULT '0' AFTER `playedTime`;
-
-UPDATE `item_instance` SET `createTime` = COALESCE(
-  (SELECT LEAST(c.`logout_time`, GREATEST(c.`createTime`,  c.`logout_time` -
-    ((c.`totaltime`-`playedTime`)
-	/ GREATEST(c.`totaltime`, 1)
-	* (c.`logout_time`-c.`createTime`)))) FROM `characters` c WHERE c.`guid`=`owner_guid`),
-	UNIX_TIMESTAMP()
-);