aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorOvahlord <dreadkiller@gmx.de>2024-09-14 18:21:09 +0200
committerOvahlord <dreadkiller@gmx.de>2024-09-14 18:21:09 +0200
commit3c2aa264c02e86f756e3b0d2bd44f2cb31813994 (patch)
treeb4954459e99d967d52d525ac7ae311e203b57ae9 /sql
parent768e63ad1a50b87d2da0a769e509f4bc3660d400 (diff)
Core/DataStores: extract, load and use NpcTotalHp and NpcDamageByClass game tables to initialize the damage and health values of creatures
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/cata_classic/2024_09_14_00_world.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_09_14_00_world.sql b/sql/updates/world/cata_classic/2024_09_14_00_world.sql
new file mode 100644
index 00000000000..f16746d5ec4
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_09_14_00_world.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `creature_classlevelstats`
+ DROP COLUMN `basehp0`,
+ DROP COLUMN `basehp1`,
+ DROP COLUMN `basehp2`,
+ DROP COLUMN `basehp3`,
+ DROP COLUMN `damage_base`,
+ DROP COLUMN `damage_exp1`,
+ DROP COLUMN `damage_exp2`,
+ DROP COLUMN `damage_exp3`;