From 8a61024cfad05279791badf33fcdb5a608ad6e94 Mon Sep 17 00:00:00 2001 From: ModoX Date: Fri, 14 Jan 2022 19:52:56 +0100 Subject: Core/Player: Added PlayerCreateMode field to playercreateinfo_cast_spell to only cast spells based on related mode (#27593) --- sql/updates/world/master/2022_01_14_03_world.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/master/2022_01_14_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_01_14_03_world.sql b/sql/updates/world/master/2022_01_14_03_world.sql new file mode 100644 index 00000000000..609f4b576a4 --- /dev/null +++ b/sql/updates/world/master/2022_01_14_03_world.sql @@ -0,0 +1,4 @@ +-- +ALTER TABLE `playercreateinfo_cast_spell` DROP PRIMARY KEY; +ALTER TABLE `playercreateinfo_cast_spell` ADD `createMode` tinyint(4) NOT NULL DEFAULT '0' AFTER `classMask`; +ALTER TABLE `playercreateinfo_cast_spell` ADD PRIMARY KEY(`raceMask`,`classMask`,`createMode`,`spell`); -- cgit v1.2.3