Core/Spells: Implement SPELL_EFFECT_TELEPORT_TO_RETURN_POINT (#26217)

1 files changed, 14 insertions, 0 deletions

diff --git a/sql/updates/characters/master/2021_03_27_00_characters_aura_stored_location.sql b/sql/updates/characters/master/2021_03_27_00_characters_aura_stored_location.sql
new file mode 100644
index 00000000000..2a0f6e93614
--- /dev/null
+++ b/sql/updates/characters/master/2021_03_27_00_characters_aura_stored_location.sql
@@ -0,0 +1,14 @@
+--
+-- Table structure for table `character_spell_location`
+--
+DROP TABLE IF EXISTS `character_aura_stored_location`;
+CREATE TABLE `character_aura_stored_location` (
+  `Guid` bigint(20) unsigned NOT NULL COMMENT 'Global Unique Identifier of Player',
+  `Spell` int(10) unsigned NOT NULL COMMENT 'Spell Identifier',
+  `MapId` int(10) unsigned NOT NULL COMMENT 'Map Id',
+  `PositionX` float NOT NULL COMMENT 'position x',
+  `PositionY` float NOT NULL COMMENT 'position y',
+  `PositionZ` float NOT NULL COMMENT 'position z',
+  `Orientation` float NOT NULL COMMENT 'Orientation',
+  PRIMARY KEY (`Guid`,`Spell`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;