aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters/master
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2023-02-03 01:20:41 +0000
committerTDB Release <tdb-release@build.bot>2023-02-03 01:20:41 +0000
commit05581806cdb35b2cde4760f8c73da1c04ee8cf3b (patch)
tree055c1b39ef7f468dc59b2b7bd7eae12fda058c34 /sql/updates/characters/master
parent50e8da3b7975067c5b4173528a463f9935a97d15 (diff)
TDB 1005.23021 - 2023/02/03TDB1005.23021
Diffstat (limited to 'sql/updates/characters/master')
-rw-r--r--sql/updates/characters/master/2022_12_30_00_characters.sql3
-rw-r--r--sql/updates/characters/master/2023_01_28_00_characters.sql2
-rw-r--r--sql/updates/characters/master/2023_01_29_00_characters.sql3
-rw-r--r--sql/updates/characters/master/2023_02_03_00_characters.sql (renamed from sql/updates/characters/master/2022_12_20_00_characters.sql)2
4 files changed, 1 insertions, 9 deletions
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/2022_12_20_00_characters.sql b/sql/updates/characters/master/2023_02_03_00_characters.sql
index 27a01e4766e..3358156788c 100644
--- a/sql/updates/characters/master/2022_12_20_00_characters.sql
+++ b/sql/updates/characters/master/2023_02_03_00_characters.sql
@@ -1,3 +1,3 @@
--- TDB 1002.22121 characters
+-- TDB 1005.23021 characters
UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/characters', 'ARCHIVED');