From fd3e4d5139edf7e6dd036315794e7eba3e8ff91f Mon Sep 17 00:00:00 2001
From: Shauren <none@none>
Date: Tue, 13 Jul 2010 23:04:31 +0200
Subject: Add Stances and StancesNot fields to spell_dbc table

--HG--
branch : trunk
---
 sql/base/world_database.sql          | 2 ++
 sql/updates/8890_world_spell_dbc.sql | 3 +++
 2 files changed, 5 insertions(+)
 create mode 100644 sql/updates/8890_world_spell_dbc.sql

(limited to 'sql')

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 6bd4a008a8a..7f6dae9f01a 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -5205,6 +5205,8 @@ CREATE TABLE `spell_dbc` (
   `AttributesEx3` int(10) unsigned NOT NULL DEFAULT '0',
   `AttributesEx4` int(10) unsigned NOT NULL DEFAULT '0',
   `AttributesEx5` int(10) unsigned NOT NULL DEFAULT '0',
+  `Stances` int(10) unsigned NOT NULL DEFAULT '0',
+  `StancesNot` int(10) unsigned NOT NULL DEFAULT '0',
   `Targets` int(10) unsigned NOT NULL DEFAULT '0',
   `CastingTimeIndex` tinyint(3) unsigned NOT NULL DEFAULT '1',
   `AuraInterruptFlags` int(10) unsigned NOT NULL DEFAULT '0',
diff --git a/sql/updates/8890_world_spell_dbc.sql b/sql/updates/8890_world_spell_dbc.sql
new file mode 100644
index 00000000000..a5e0927806f
--- /dev/null
+++ b/sql/updates/8890_world_spell_dbc.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `spell_dbc`
+  ADD COLUMN `Stances` int(10) unsigned NOT NULL DEFAULT '0' AFTER `AttributesEx5`,
+  ADD COLUMN `StancesNot` int(10) unsigned NOT NULL DEFAULT '0' AFTER `Stances`;
-- 
cgit v1.2.3