From a2be8d202823706ad4b29c2dc988c0fe978ae652 Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 2 Jun 2023 00:50:30 +0200 Subject: Core/Quests: Implemented new db table quest_objectives_completion_effect * Turn off automatic phase updates on quest objective completion * Allow more convenient conversation and spell casts on quest objective completion --- sql/updates/world/master/2023_06_02_00_world.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/master/2023_06_02_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2023_06_02_00_world.sql b/sql/updates/world/master/2023_06_02_00_world.sql new file mode 100644 index 00000000000..0ebca464ea6 --- /dev/null +++ b/sql/updates/world/master/2023_06_02_00_world.sql @@ -0,0 +1,13 @@ +-- +-- Table structure for table `quest_objectives_completion_effect` +-- +DROP TABLE IF EXISTS `quest_objectives_completion_effect`; +CREATE TABLE `quest_objectives_completion_effect` ( + `ObjectiveID` int NOT NULL, + `GameEventID` int DEFAULT NULL, + `SpellID` int DEFAULT NULL, + `ConversationID` int DEFAULT NULL, + `UpdatePhaseShift` tinyint(1) DEFAULT '0', + `UpdateZoneAuras` tinyint(1) DEFAULT '0', + PRIMARY KEY (`ObjectiveID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- cgit v1.2.3