From f774c4e855b372676190279b2bc1ba12ed15f028 Mon Sep 17 00:00:00 2001 From: TDB Release Date: Fri, 6 Oct 2023 00:48:59 +0000 Subject: TDB 1017.23101 - 2023/10/06 --- sql/updates/characters/master/2023_07_14_00_characters.sql | 3 --- sql/updates/characters/master/2023_08_26_00_characters.sql | 3 --- sql/updates/characters/master/2023_09_14_00_characters.sql | 1 - sql/updates/characters/master/2023_09_30_00_characters.sql | 3 --- sql/updates/characters/master/2023_10_06_00_characters.sql | 3 +++ 5 files changed, 3 insertions(+), 10 deletions(-) delete mode 100644 sql/updates/characters/master/2023_07_14_00_characters.sql delete mode 100644 sql/updates/characters/master/2023_08_26_00_characters.sql delete mode 100644 sql/updates/characters/master/2023_09_14_00_characters.sql delete mode 100644 sql/updates/characters/master/2023_09_30_00_characters.sql create mode 100644 sql/updates/characters/master/2023_10_06_00_characters.sql (limited to 'sql/updates/characters') diff --git a/sql/updates/characters/master/2023_07_14_00_characters.sql b/sql/updates/characters/master/2023_07_14_00_characters.sql deleted file mode 100644 index 19bc9715ae3..00000000000 --- a/sql/updates/characters/master/2023_07_14_00_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ --- TDB 1015.23071 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/2023_08_26_00_characters.sql b/sql/updates/characters/master/2023_08_26_00_characters.sql deleted file mode 100644 index 7b1ca982250..00000000000 --- a/sql/updates/characters/master/2023_08_26_00_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE `character_battleground_data` ADD `queueId` BIGINT UNSIGNED NULL DEFAULT '0' AFTER `mountSpell`; - -ALTER TABLE `pvpstats_battlegrounds` CHANGE `type` `type` int unsigned NOT NULL; diff --git a/sql/updates/characters/master/2023_09_14_00_characters.sql b/sql/updates/characters/master/2023_09_14_00_characters.sql deleted file mode 100644 index 9c8709cbb1d..00000000000 --- a/sql/updates/characters/master/2023_09_14_00_characters.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `groups` MODIFY `groupType` smallint unsigned NOT NULL AFTER `icon8`; diff --git a/sql/updates/characters/master/2023_09_30_00_characters.sql b/sql/updates/characters/master/2023_09_30_00_characters.sql deleted file mode 100644 index 683db33e5cc..00000000000 --- a/sql/updates/characters/master/2023_09_30_00_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE `character_stats` - ADD `mastery` float NOT NULL DEFAULT '0' AFTER `resilience`, - ADD `versatility` int NOT NULL DEFAULT '0' AFTER `mastery`; diff --git a/sql/updates/characters/master/2023_10_06_00_characters.sql b/sql/updates/characters/master/2023_10_06_00_characters.sql new file mode 100644 index 00000000000..89ca5b774ad --- /dev/null +++ b/sql/updates/characters/master/2023_10_06_00_characters.sql @@ -0,0 +1,3 @@ +-- TDB 1017.23101 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