From 1fb4acc25ae89360e71d33a8f7cba99bcc028b32 Mon Sep 17 00:00:00 2001 From: Shauren Date: Mon, 2 Dec 2024 15:29:02 +0100 Subject: Core/Quests: Implemented QUEST_OBJECTIVE_KILL_WITH_LABEL --- .../hotfixes/master/2024_12_02_00_hotfixes.sql | 23 ++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 sql/updates/hotfixes/master/2024_12_02_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2024_12_02_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_12_02_00_hotfixes.sql new file mode 100644 index 00000000000..a3946e51902 --- /dev/null +++ b/sql/updates/hotfixes/master/2024_12_02_00_hotfixes.sql @@ -0,0 +1,23 @@ +-- +-- Table structure for table `creature_label` +-- +DROP TABLE IF EXISTS `creature_label`; +CREATE TABLE `creature_label` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `LabelID` int NOT NULL DEFAULT '0', + `CreatureDifficultyID` int unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `gameobject_label` +-- +DROP TABLE IF EXISTS `gameobject_label`; +CREATE TABLE `gameobject_label` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `LabelID` int NOT NULL DEFAULT '0', + `GameObjectID` int unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- cgit v1.2.3