TDB 1027.24051 - 2024/05/11TDB1027.24051

4 files changed, 1 insertions, 40 deletions

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()
-);
diff --git a/sql/updates/characters/master/2024_04_28_00_characters.sql b/sql/updates/characters/master/2024_04_28_00_characters.sql
deleted file mode 100644
index c17aa412b08..00000000000
--- a/sql/updates/characters/master/2024_04_28_00_characters.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-ALTER TABLE `characters`
-  ADD `inventoryBagFlags` int unsigned NOT NULL DEFAULT '0' AFTER `inventorySlots`,
-  ADD `bagSlotFlags1` int unsigned NOT NULL DEFAULT '0' AFTER `inventoryBagFlags`,
-  ADD `bagSlotFlags2` int unsigned NOT NULL DEFAULT '0' AFTER `bagSlotFlags1`,
-  ADD `bagSlotFlags3` int unsigned NOT NULL DEFAULT '0' AFTER `bagSlotFlags2`,
-  ADD `bagSlotFlags4` int unsigned NOT NULL DEFAULT '0' AFTER `bagSlotFlags3`,
-  ADD `bagSlotFlags5` int unsigned NOT NULL DEFAULT '0' AFTER `bagSlotFlags4`,
-  ADD `bankBagFlags` int unsigned NOT NULL DEFAULT '0' AFTER `bankSlots`,
-  ADD `bankBagSlotFlags1` int unsigned NOT NULL DEFAULT '0' AFTER `bankBagFlags`,
-  ADD `bankBagSlotFlags2` int unsigned NOT NULL DEFAULT '0' AFTER `bankBagSlotFlags1`,
-  ADD `bankBagSlotFlags3` int unsigned NOT NULL DEFAULT '0' AFTER `bankBagSlotFlags2`,
-  ADD `bankBagSlotFlags4` int unsigned NOT NULL DEFAULT '0' AFTER `bankBagSlotFlags3`,
-  ADD `bankBagSlotFlags5` int unsigned NOT NULL DEFAULT '0' AFTER `bankBagSlotFlags4`,
-  ADD `bankBagSlotFlags6` int unsigned NOT NULL DEFAULT '0' AFTER `bankBagSlotFlags5`,
-  ADD `bankBagSlotFlags7` int unsigned NOT NULL DEFAULT '0' AFTER `bankBagSlotFlags6`;
diff --git a/sql/updates/characters/master/2024_02_08_00_characters.sql b/sql/updates/characters/master/2024_05_11_00_characters.sql
index 5197d985f77..105c3b99fff 100644
--- a/sql/updates/characters/master/2024_02_08_00_characters.sql
+++ b/sql/updates/characters/master/2024_05_11_00_characters.sql
@@ -1,3 +1,3 @@
--- TDB 1025.24021 characters
+-- TDB 1027.24051 characters
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/characters', 'ARCHIVED');