aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <none@none>2010-07-13 23:04:31 +0200
committerShauren <none@none>2010-07-13 23:04:31 +0200
commitfd3e4d5139edf7e6dd036315794e7eba3e8ff91f (patch)
tree854279202261b6e3de5db0e1a4ee2a16e2ec2ddd /sql
parentc783cacbe63023c36e9393d28a574b613ff6b555 (diff)
Add Stances and StancesNot fields to spell_dbc table
--HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/base/world_database.sql2
-rw-r--r--sql/updates/8890_world_spell_dbc.sql3
2 files changed, 5 insertions, 0 deletions
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`;