From b0b5b0d397b53209b1e778225efc5db933f88d81 Mon Sep 17 00:00:00 2001
From: Aqua Deus <95978183+aquadeus@users.noreply.github.com>
Date: Wed, 9 Nov 2022 00:14:05 +0100
Subject: DB/Azsuna: Added missing Demon Ward

Closes #28472
---
 sql/updates/world/master/2022_11_09_03_world.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 sql/updates/world/master/2022_11_09_03_world.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/master/2022_11_09_03_world.sql b/sql/updates/world/master/2022_11_09_03_world.sql
new file mode 100644
index 00000000000..2822e6190d5
--- /dev/null
+++ b/sql/updates/world/master/2022_11_09_03_world.sql
@@ -0,0 +1,5 @@
+SET @OGUID := 400420;
+
+DELETE FROM `gameobject` WHERE `guid` = @OGUID+0;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 240291, 1220, 7334, 7364, '0', 0, 0, -137.583328247070312, 6983.27978515625, 8.014510154724121093, 1.862035393714904785, 0, 0, 0.802227973937988281, 0.597017824649810791, 120, 255, 0, 46455); -- Demon Ward
-- 
cgit v1.2.3