diff options
| author | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-09-21 04:18:31 +0200 |
|---|---|---|
| committer | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-09-21 04:18:31 +0200 |
| commit | c243bf96d436aaaaf12f4a42cf8e439defe198ea (patch) | |
| tree | 3f9ca345ab862ae50f1a01ceb0307d7396ee6444 /sql/updates | |
| parent | df50d0756797f71a3720f5bd347762b5b9bbe376 (diff) | |
DB/Spells:
- Added EffectItemType columns to spell_dbc table
- Fix "Create Bundle of Bloodthistle"
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2014_09_21_00_world_spell_dbc.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2014_09_21_00_world_spell_dbc.sql b/sql/updates/world/2014_09_21_00_world_spell_dbc.sql new file mode 100644 index 00000000000..d762bf92107 --- /dev/null +++ b/sql/updates/world/2014_09_21_00_world_spell_dbc.sql @@ -0,0 +1,5 @@ +ALTER TABLE `spell_dbc` ADD `EffectItemType1` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `EffectMultipleValue3`; +ALTER TABLE `spell_dbc` ADD `EffectItemType2` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `EffectItemType1`; +ALTER TABLE `spell_dbc` ADD `EffectItemType3` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `EffectItemType2`; + +UPDATE `spell_dbc` SET `EffectItemType1`=30616 WHERE `Id`=37064; |