aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/characters/cata_classic/2024_03_12_00_characters.sql5
-rw-r--r--sql/updates/world/cata_classic/2024_03_12_01_world.sql1
2 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/characters/cata_classic/2024_03_12_00_characters.sql b/sql/updates/characters/cata_classic/2024_03_12_00_characters.sql
new file mode 100644
index 00000000000..f5989d6dcc5
--- /dev/null
+++ b/sql/updates/characters/cata_classic/2024_03_12_00_characters.sql
@@ -0,0 +1,5 @@
+DROP TABLE IF EXISTS `character_garrison`;
+DROP TABLE IF EXISTS `character_garrison_blueprints`;
+DROP TABLE IF EXISTS `character_garrison_buildings`;
+DROP TABLE IF EXISTS `character_garrison_follower_abilities`;
+DROP TABLE IF EXISTS `character_garrison_followers`;
diff --git a/sql/updates/world/cata_classic/2024_03_12_01_world.sql b/sql/updates/world/cata_classic/2024_03_12_01_world.sql
new file mode 100644
index 00000000000..83130467d2a
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_03_12_01_world.sql
@@ -0,0 +1 @@
+DELETE FROM `areatrigger_scripts` WHERE `ScriptName` IN ('at_garrison_enter', 'at_garrison_exit');