TDB 440.24101 - 2024/10/27TDB440.24101

8 files changed, 1 insertions, 58 deletions

diff --git a/sql/updates/characters/cata_classic/2024_06_05_00_characters.sql b/sql/updates/characters/cata_classic/2024_06_05_00_characters.sql
deleted file mode 100644
index ad03c2a1e7e..00000000000
--- a/sql/updates/characters/cata_classic/2024_06_05_00_characters.sql
+++ /dev/null
@@ -1 +0,0 @@
-DROP TABLE IF EXISTS `character_pvp_talent`;
diff --git a/sql/updates/characters/cata_classic/2024_06_25_00_characters.sql b/sql/updates/characters/cata_classic/2024_06_25_00_characters.sql
deleted file mode 100644
index 2388055c8f0..00000000000
--- a/sql/updates/characters/cata_classic/2024_06_25_00_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-DROP TABLE IF EXISTS `item_instance_artifact`;
-DROP TABLE IF EXISTS `item_instance_artifact_powers`;
diff --git a/sql/updates/characters/cata_classic/2024_07_27_00_characters.sql b/sql/updates/characters/cata_classic/2024_07_27_00_characters.sql
deleted file mode 100644
index 3a01e0a7f8e..00000000000
--- a/sql/updates/characters/cata_classic/2024_07_27_00_characters.sql
+++ /dev/null
@@ -1,16 +0,0 @@
-DROP TABLE IF EXISTS `character_talent`;
-CREATE TABLE `character_talent`  (
-  `guid` bigint UNSIGNED NOT NULL,
-  `talentGroup` tinyint UNSIGNED NOT NULL DEFAULT 0,
-  `talentId` int UNSIGNED NOT NULL,
-  `rank` tinyint UNSIGNED NOT NULL DEFAULT 0,
-  PRIMARY KEY (`guid`, `talentId`, `talentGroup`)
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
-
-DROP TABLE IF EXISTS `character_talent_group`;
-CREATE TABLE `character_talent_group`  (
-  `guid` bigint UNSIGNED NOT NULL DEFAULT 0,
-  `id` tinyint UNSIGNED NOT NULL DEFAULT 0,
-  `talentTabId` int UNSIGNED NOT NULL DEFAULT 0,
-  PRIMARY KEY (`guid`, `id`)
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
diff --git a/sql/updates/characters/cata_classic/2024_07_28_00_characters.sql b/sql/updates/characters/cata_classic/2024_07_28_00_characters.sql
deleted file mode 100644
index b1810fbbe1f..00000000000
--- a/sql/updates/characters/cata_classic/2024_07_28_00_characters.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE `character_glyphs` 
-ADD COLUMN `glyphSlot` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `talentGroup`,
-DROP PRIMARY KEY,
-ADD PRIMARY KEY (`guid`, `talentGroup`, `glyphSlot`, `glyphId`);
diff --git a/sql/updates/characters/cata_classic/2024_08_27_00_characters_2024_08_26_00_characters.sql b/sql/updates/characters/cata_classic/2024_08_27_00_characters_2024_08_26_00_characters.sql
deleted file mode 100644
index dedde7070ec..00000000000
--- a/sql/updates/characters/cata_classic/2024_08_27_00_characters_2024_08_26_00_characters.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE `item_loot_items` ADD `item_type` tinyint NOT NULL DEFAULT 0 COMMENT 'item or currency' AFTER `container_id`;
-ALTER TABLE `item_loot_items` DROP PRIMARY KEY;
-ALTER TABLE `item_loot_items` ADD PRIMARY KEY (`container_id`,`item_type`,`item_id`);
diff --git a/sql/updates/characters/cata_classic/2024_09_01_00_characters.sql b/sql/updates/characters/cata_classic/2024_09_01_00_characters.sql
deleted file mode 100644
index aaacfd4d2f7..00000000000
--- a/sql/updates/characters/cata_classic/2024_09_01_00_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-DROP TABLE IF EXISTS `character_trait_entry`;
-DROP TABLE IF EXISTS `character_trait_config`;
diff --git a/sql/updates/characters/cata_classic/2024_10_03_00_characters.sql b/sql/updates/characters/cata_classic/2024_10_03_00_characters.sql
deleted file mode 100644
index 7b5a6fcf357..00000000000
--- a/sql/updates/characters/cata_classic/2024_10_03_00_characters.sql
+++ /dev/null
@@ -1,29 +0,0 @@
--- append guid as hex to characters who have duplicate names in database except the one with lowest guid (assumed to have been created first)
--- and flag them for rename
-CREATE TEMPORARY TABLE `characters_to_rename` SELECT
-    c2.`guid`
-  FROM
-    (
-      SELECT
-        c1.`name` AS `name`,
-        MIN(c1.`guid`) AS originalGuid
-      FROM
-        `characters` c1 
-      WHERE
-        LENGTH(c1.`name`) > 0 
-      GROUP BY
-        1 
-      HAVING
-        COUNT(*) > 1
-    ) c3
-    INNER JOIN `characters` c2 ON c3.`name` = c2.`name`
-  WHERE
-    c2.guid <> c3.originalGuid;
-
-UPDATE `characters` SET `name` = CONCAT(SUBSTRING(`name` FROM 1 FOR 12 - LENGTH(CONV(`guid`, 10, 16))), CONV(`guid`, 10, 16)), `at_login` = `at_login` | 1 WHERE `guid` IN (SELECT `guid` FROM `characters_to_rename`);
-
--- recreate name index with unique constraint
-ALTER TABLE `characters` DROP INDEX `idx_name`;
-ALTER TABLE `characters` MODIFY COLUMN `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL AFTER `account`;
-UPDATE `characters` SET `name` = NULL WHERE `name` = '';
-ALTER TABLE `characters` ADD UNIQUE INDEX `idx_name` (`name` ASC);
diff --git a/sql/updates/characters/cata_classic/2024_06_02_00_characters.sql b/sql/updates/characters/cata_classic/2024_10_27_00_characters.sql
index 8f0af751f11..a3e5ef0005d 100644
--- a/sql/updates/characters/cata_classic/2024_06_02_00_characters.sql
+++ b/sql/updates/characters/cata_classic/2024_10_27_00_characters.sql
@@ -1,3 +1,3 @@
--- TDB 440.24061 characters
+-- TDB 440.24101 characters
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/4.4.x/characters', 'ARCHIVED');