From 5641955918480a1d493637fdcaafaa2db0c2226b Mon Sep 17 00:00:00 2001 From: TDB Release Date: Sat, 29 Mar 2025 01:17:19 +0000 Subject: TDB 1110.25031 - 2025/03/29 --- sql/updates/characters/master/2024_12_22_00_characters.sql | 3 --- sql/updates/characters/master/2025_01_04_00_characters.sql | 8 -------- sql/updates/characters/master/2025_03_29_00_characters.sql | 3 +++ 3 files changed, 3 insertions(+), 11 deletions(-) delete mode 100644 sql/updates/characters/master/2024_12_22_00_characters.sql delete mode 100644 sql/updates/characters/master/2025_01_04_00_characters.sql create mode 100644 sql/updates/characters/master/2025_03_29_00_characters.sql (limited to 'sql/updates/characters') diff --git a/sql/updates/characters/master/2024_12_22_00_characters.sql b/sql/updates/characters/master/2024_12_22_00_characters.sql deleted file mode 100644 index f8e4e599012..00000000000 --- a/sql/updates/characters/master/2024_12_22_00_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ --- TDB 1107.24121 characters -UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; -REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/characters', 'ARCHIVED'); 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/2025_03_29_00_characters.sql b/sql/updates/characters/master/2025_03_29_00_characters.sql new file mode 100644 index 00000000000..69fab8ab5a5 --- /dev/null +++ b/sql/updates/characters/master/2025_03_29_00_characters.sql @@ -0,0 +1,3 @@ +-- TDB 1110.25031 characters +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/characters', 'ARCHIVED'); -- cgit v1.2.3