aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
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');