aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/3.3.5/2016_10_30_00_characters.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/characters/3.3.5/2016_10_30_00_characters.sql b/sql/updates/characters/3.3.5/2016_10_30_00_characters.sql
new file mode 100644
index 00000000000..f72e8c32e22
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2016_10_30_00_characters.sql
@@ -0,0 +1,2 @@
+DELETE FROM `character_aura` WHERE `itemGuid` != 0;
+ALTER TABLE `character_aura` DROP COLUMN `itemGuid`;