Core/Spells: Made the loading of the orientation of SPELL_DEST_DB from SpellEffect.dbc

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/world/2014_11_20_02_world.sql b/sql/updates/world/2014_11_20_02_world.sql
new file mode 100644
index 00000000000..1e0048e1943
--- /dev/null
+++ b/sql/updates/world/2014_11_20_02_world.sql
@@ -0,0 +1,7 @@
+ALTER TABLE `spell_target_position` CHANGE `id` `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `spell_target_position` CHANGE `effIndex` `EffectIndex` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `spell_target_position` CHANGE `target_map` `MapID` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `spell_target_position` CHANGE `target_position_x` `PositionX` FLOAT NOT NULL DEFAULT '0';
+ALTER TABLE `spell_target_position` CHANGE `target_position_y` `PositionY` FLOAT NOT NULL DEFAULT '0';
+ALTER TABLE `spell_target_position` CHANGE `target_position_z` `PositionZ` FLOAT NOT NULL DEFAULT '0';
+ALTER TABLE `spell_target_position` DROP COLUMN `target_orientation`;