2 files changed, 10 insertions, 0 deletions
diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index 39db97bc3df..f05add0a3a5 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -525,6 +525,12 @@ INSERT INTO `spell_script_target` VALUES
 (55083, 1, 29700),(55223, 1, 29686),
 (59951, 1, 29686),(59952, 1, 29686);
 
+-- Violet Hold
+DELETE FROM `spell_script_target` WHERE `entry` IN (54160,59474);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(54160, 1, 29266),
+(59474, 1, 29266);
+
 -- --------
 -- POSITION
 -- --------
diff --git a/sql/updates/6452_world_spells.sql b/sql/updates/6452_world_spells.sql
new file mode 100644
index 00000000000..55b1721f259
--- /dev/null
+++ b/sql/updates/6452_world_spells.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_script_target` WHERE `entry` IN (54160,59474);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(54160, 1, 29266),
+(59474, 1, 29266);