diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/4.x/2011_11_27_00_world_spell_script.sql | 6 | ||||
| -rw-r--r-- | sql/updates/world/4.x/2011_11_28_00_world_gameobject_template.sql | 9 |
2 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/4.x/2011_11_27_00_world_spell_script.sql b/sql/updates/world/4.x/2011_11_27_00_world_spell_script.sql new file mode 100644 index 00000000000..5411d660c2b --- /dev/null +++ b/sql/updates/world/4.x/2011_11_27_00_world_spell_script.sql @@ -0,0 +1,6 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_damage_reduction_aura'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(20911,'spell_gen_damage_reduction_aura'), -- Blessing of Sanctuary +(25899,'spell_gen_damage_reduction_aura'), -- Greater Blessing of Sanctuary +(63944,'spell_gen_damage_reduction_aura'), -- Renewed Hope +(50720,'spell_gen_damage_reduction_aura'); -- Vigilance diff --git a/sql/updates/world/4.x/2011_11_28_00_world_gameobject_template.sql b/sql/updates/world/4.x/2011_11_28_00_world_gameobject_template.sql new file mode 100644 index 00000000000..236f6acc6ae --- /dev/null +++ b/sql/updates/world/4.x/2011_11_28_00_world_gameobject_template.sql @@ -0,0 +1,9 @@ +ALTER TABLE `gameobject_template` ADD `data24` INT(10) NOT NULL DEFAULT '0' AFTER `data23`; +ALTER TABLE `gameobject_template` ADD `data25` INT(10) NOT NULL DEFAULT '0' AFTER `data24`; +ALTER TABLE `gameobject_template` ADD `data26` INT(10) NOT NULL DEFAULT '0' AFTER `data25`; +ALTER TABLE `gameobject_template` ADD `data27` INT(10) NOT NULL DEFAULT '0' AFTER `data26`; +ALTER TABLE `gameobject_template` ADD `data28` INT(10) NOT NULL DEFAULT '0' AFTER `data27`; +ALTER TABLE `gameobject_template` ADD `data29` INT(10) NOT NULL DEFAULT '0' AFTER `data28`; +ALTER TABLE `gameobject_template` ADD `data30` INT(10) NOT NULL DEFAULT '0' AFTER `data29`; +ALTER TABLE `gameobject_template` ADD `data31` INT(10) NOT NULL DEFAULT '0' AFTER `data30`; +ALTER TABLE `gameobject_template` ADD `unkInt32` INT(10) NOT NULL DEFAULT '0' AFTER `data31`; -- Unk size |