From 05581806cdb35b2cde4760f8c73da1c04ee8cf3b Mon Sep 17 00:00:00 2001 From: TDB Release Date: Fri, 3 Feb 2023 01:20:41 +0000 Subject: TDB 1005.23021 - 2023/02/03 --- sql/updates/characters/master/2022_12_20_00_characters.sql | 3 --- sql/updates/characters/master/2022_12_30_00_characters.sql | 3 --- sql/updates/characters/master/2023_01_28_00_characters.sql | 2 -- sql/updates/characters/master/2023_01_29_00_characters.sql | 3 --- sql/updates/characters/master/2023_02_03_00_characters.sql | 3 +++ 5 files changed, 3 insertions(+), 11 deletions(-) delete mode 100644 sql/updates/characters/master/2022_12_20_00_characters.sql delete mode 100644 sql/updates/characters/master/2022_12_30_00_characters.sql delete mode 100644 sql/updates/characters/master/2023_01_28_00_characters.sql delete mode 100644 sql/updates/characters/master/2023_01_29_00_characters.sql create mode 100644 sql/updates/characters/master/2023_02_03_00_characters.sql (limited to 'sql/updates/characters/master') diff --git a/sql/updates/characters/master/2022_12_20_00_characters.sql b/sql/updates/characters/master/2022_12_20_00_characters.sql deleted file mode 100644 index 27a01e4766e..00000000000 --- a/sql/updates/characters/master/2022_12_20_00_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ --- TDB 1002.22121 characters -UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; -REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/characters', 'ARCHIVED'); diff --git a/sql/updates/characters/master/2022_12_30_00_characters.sql b/sql/updates/characters/master/2022_12_30_00_characters.sql deleted file mode 100644 index ce1280de0d7..00000000000 --- a/sql/updates/characters/master/2022_12_30_00_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ --- delete corrupted trait configs -DELETE FROM `character_trait_entry`; -DELETE FROM `character_trait_config`; diff --git a/sql/updates/characters/master/2023_01_28_00_characters.sql b/sql/updates/characters/master/2023_01_28_00_characters.sql deleted file mode 100644 index 6a744624ecd..00000000000 --- a/sql/updates/characters/master/2023_01_28_00_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `mail` MODIFY `id` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier'; -ALTER TABLE `mail_items` MODIFY `mail_id` bigint unsigned NOT NULL DEFAULT '0'; diff --git a/sql/updates/characters/master/2023_01_29_00_characters.sql b/sql/updates/characters/master/2023_01_29_00_characters.sql deleted file mode 100644 index 89522507989..00000000000 --- a/sql/updates/characters/master/2023_01_29_00_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE `character_currency` -ADD `IncreasedCapQuantity` INT UNSIGNED NOT NULL DEFAULT 0 AFTER `TrackedQuantity`, -ADD `EarnedQuantity` INT UNSIGNED NOT NULL DEFAULT 0 AFTER `IncreasedCapQuantity`; diff --git a/sql/updates/characters/master/2023_02_03_00_characters.sql b/sql/updates/characters/master/2023_02_03_00_characters.sql new file mode 100644 index 00000000000..3358156788c --- /dev/null +++ b/sql/updates/characters/master/2023_02_03_00_characters.sql @@ -0,0 +1,3 @@ +-- TDB 1005.23021 characters +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/characters', 'ARCHIVED'); -- cgit v1.2.3