aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/master/2025_01_04_00_characters.sql8
-rw-r--r--sql/updates/characters/master/2025_03_29_00_characters.sql (renamed from sql/updates/characters/master/2024_12_22_00_characters.sql)2
2 files changed, 1 insertions, 9 deletions
diff --git a/sql/updates/characters/master/2025_01_04_00_characters.sql b/sql/updates/characters/master/2025_01_04_00_characters.sql
deleted file mode 100644
index 5c6240f6344..00000000000
--- a/sql/updates/characters/master/2025_01_04_00_characters.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-DROP TABLE IF EXISTS `character_queststatus_objectives_spawn_tracking`;
-CREATE TABLE `character_queststatus_objectives_spawn_tracking` (
- `guid` BIGINT UNSIGNED NOT NULL,
- `quest` INT UNSIGNED NOT NULL,
- `objective` TINYINT UNSIGNED NOT NULL DEFAULT '0',
- `spawnTrackingId` INT UNSIGNED NOT NULL,
- PRIMARY KEY (`guid`,`quest`,`objective`,`spawnTrackingId`)
-) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
diff --git a/sql/updates/characters/master/2024_12_22_00_characters.sql b/sql/updates/characters/master/2025_03_29_00_characters.sql
index f8e4e599012..69fab8ab5a5 100644
--- a/sql/updates/characters/master/2024_12_22_00_characters.sql
+++ b/sql/updates/characters/master/2025_03_29_00_characters.sql
@@ -1,3 +1,3 @@
--- TDB 1107.24121 characters
+-- TDB 1110.25031 characters
UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/characters', 'ARCHIVED');