From cca05feeb4cb5be081694ada75a90069c96dc13d Mon Sep 17 00:00:00 2001 From: TDB Release Date: Wed, 29 Oct 2025 07:02:07 +0000 Subject: TDB 1125.25101 - 2025/10/29 --- sql/updates/characters/master/2025_08_16_00_characters.sql | 3 --- sql/updates/characters/master/2025_08_19_00_characters.sql | 1 - sql/updates/characters/master/2025_09_09_00_characters.sql | 3 --- sql/updates/characters/master/2025_10_10_00_characters.sql | 3 --- sql/updates/characters/master/2025_10_29_00_characters.sql | 3 +++ 5 files changed, 3 insertions(+), 10 deletions(-) delete mode 100644 sql/updates/characters/master/2025_08_16_00_characters.sql delete mode 100644 sql/updates/characters/master/2025_08_19_00_characters.sql delete mode 100644 sql/updates/characters/master/2025_09_09_00_characters.sql delete mode 100644 sql/updates/characters/master/2025_10_10_00_characters.sql create mode 100644 sql/updates/characters/master/2025_10_29_00_characters.sql (limited to 'sql/updates/characters/master') diff --git a/sql/updates/characters/master/2025_08_16_00_characters.sql b/sql/updates/characters/master/2025_08_16_00_characters.sql deleted file mode 100644 index 33efc7188f6..00000000000 --- a/sql/updates/characters/master/2025_08_16_00_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ --- TDB 1120.25081 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_08_19_00_characters.sql b/sql/updates/characters/master/2025_08_19_00_characters.sql deleted file mode 100644 index d44679cacd1..00000000000 --- a/sql/updates/characters/master/2025_08_19_00_characters.sql +++ /dev/null @@ -1 +0,0 @@ -DROP PROCEDURE IF EXISTS apply_if_not_exists_2025_08_13_00; diff --git a/sql/updates/characters/master/2025_09_09_00_characters.sql b/sql/updates/characters/master/2025_09_09_00_characters.sql deleted file mode 100644 index dab74f06fb7..00000000000 --- a/sql/updates/characters/master/2025_09_09_00_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE `quest_tracker` - DROP PRIMARY KEY, - ADD UNIQUE INDEX `idx_latest_quest_for_character`(`id`, `character_guid`, `quest_accept_time` DESC); diff --git a/sql/updates/characters/master/2025_10_10_00_characters.sql b/sql/updates/characters/master/2025_10_10_00_characters.sql deleted file mode 100644 index 0c8b8bfc61e..00000000000 --- a/sql/updates/characters/master/2025_10_10_00_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE `character_trait_config` ADD `variationId` int DEFAULT NULL AFTER `traitSystemId`; - -UPDATE `character_trait_config` SET `variationId`=0 WHERE `type`=3; diff --git a/sql/updates/characters/master/2025_10_29_00_characters.sql b/sql/updates/characters/master/2025_10_29_00_characters.sql new file mode 100644 index 00000000000..efe8c2ec4f7 --- /dev/null +++ b/sql/updates/characters/master/2025_10_29_00_characters.sql @@ -0,0 +1,3 @@ +-- TDB 1125.25101 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