From 89f2870b97248558148667d7efdc86b76487407b Mon Sep 17 00:00:00 2001
From: Shauren <none@none>
Date: Mon, 20 Dec 2010 14:55:36 +0100
Subject: Core/Auras: Save cast item guids for auras to db

--HG--
branch : trunk
---
 sql/updates/10741_characters_character_aura.sql | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 sql/updates/10741_characters_character_aura.sql

(limited to 'sql/updates')

diff --git a/sql/updates/10741_characters_character_aura.sql b/sql/updates/10741_characters_character_aura.sql
new file mode 100644
index 00000000000..d9afb213a76
--- /dev/null
+++ b/sql/updates/10741_characters_character_aura.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `character_aura`
+  ADD COLUMN `item_guid`  bigint(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `caster_guid`,
+  DROP PRIMARY KEY,
+  ADD PRIMARY KEY (`guid`,`caster_guid`,`item_guid`,`spell`,`effect_mask`);
-- 
cgit v1.2.3