From f28011735862eac1808edc14869ecda5143cc35b Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Fri, 26 Apr 2024 22:32:17 +0200 Subject: Core/Creature: implement overriding creature static flags based on spawnId and difficultyId (#29940) (cherry picked from commit b5ce4a66df0c76583c662056e46619c8fe98f297) --- sql/updates/world/master/2024_04_26_00_world.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/master/2024_04_26_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2024_04_26_00_world.sql b/sql/updates/world/master/2024_04_26_00_world.sql new file mode 100644 index 00000000000..b0546695d1e --- /dev/null +++ b/sql/updates/world/master/2024_04_26_00_world.sql @@ -0,0 +1,14 @@ +DROP TABLE IF EXISTS `creature_static_flags_override`; +CREATE TABLE `creature_static_flags_override` ( + `SpawnId` BIGINT UNSIGNED NOT NULL, + `DifficultyId` TINYINT UNSIGNED NOT NULL DEFAULT 0, + `StaticFlags1` INT UNSIGNED, + `StaticFlags2` INT UNSIGNED, + `StaticFlags3` INT UNSIGNED, + `StaticFlags4` INT UNSIGNED, + `StaticFlags5` INT UNSIGNED, + `StaticFlags6` INT UNSIGNED, + `StaticFlags7` INT UNSIGNED, + `StaticFlags8` INT UNSIGNED, + PRIMARY KEY (`SpawnId`, `DifficultyId`) +); -- cgit v1.2.3