aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorTeleqraph <nyrdeveloper@gmail.com>2022-07-03 16:00:14 +0200
committerGitHub <noreply@github.com>2022-07-03 16:00:14 +0200
commitebf1b6eb5cbfd1dc8f1b0d26c29ae1423784cabb (patch)
treef2e27de6472c4ef1f76fac1ae9422d3470589e1b /sql
parent9fcf920d0e69df5c8ca5078d3687f3843b51fcbd (diff)
Core/Creatures: Implemented sending different creature id for summoner (#28066)
Co-authored-by: Shauren <shauren.trinity@gmail.com>
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_07_03_00_world.sql18
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_07_03_00_world.sql b/sql/updates/world/master/2022_07_03_00_world.sql
new file mode 100644
index 00000000000..c25cda30004
--- /dev/null
+++ b/sql/updates/world/master/2022_07_03_00_world.sql
@@ -0,0 +1,18 @@
+--
+-- Table structure for table `creature_summoned_data`
+--
+DROP TABLE IF EXISTS `creature_summoned_data`;
+CREATE TABLE `creature_summoned_data` (
+ `CreatureID` int unsigned NOT NULL,
+ `CreatureIDVisibleToSummoner` int DEFAULT NULL,
+ `GroundMountDisplayID` int unsigned DEFAULT NULL,
+ `FlyingMountDisplayID` int unsigned DEFAULT NULL,
+ PRIMARY KEY (`CreatureID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
+--
+-- Dumping data for table `creature_summoned_data`
+--
+INSERT INTO `creature_summoned_data` VALUES
+(90382,90240,54563,46930),
+(91911,91913,59339,NULL);