aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2023-10-06 00:48:59 +0000
committerTDB Release <tdb-release@build.bot>2023-10-06 00:48:59 +0000
commitf774c4e855b372676190279b2bc1ba12ed15f028 (patch)
treeb600663b6fa5c2982981675475b85b3f83b77bad /sql/updates/characters
parente161874695c5506bfa3cbcddf944d68b11cbc124 (diff)
TDB 1017.23101 - 2023/10/06TDB1017.23101
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/master/2023_08_26_00_characters.sql3
-rw-r--r--sql/updates/characters/master/2023_09_14_00_characters.sql1
-rw-r--r--sql/updates/characters/master/2023_09_30_00_characters.sql3
-rw-r--r--sql/updates/characters/master/2023_10_06_00_characters.sql (renamed from sql/updates/characters/master/2023_07_14_00_characters.sql)2
4 files changed, 1 insertions, 8 deletions
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_07_14_00_characters.sql b/sql/updates/characters/master/2023_10_06_00_characters.sql
index 19bc9715ae3..89ca5b774ad 100644
--- a/sql/updates/characters/master/2023_07_14_00_characters.sql
+++ b/sql/updates/characters/master/2023_10_06_00_characters.sql
@@ -1,3 +1,3 @@
--- TDB 1015.23071 characters
+-- TDB 1017.23101 characters
UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/characters', 'ARCHIVED');