From 1cdae46468e7375785f564e9fa85180fce1948b9 Mon Sep 17 00:00:00 2001 From: megamage Date: Tue, 3 Mar 2009 18:41:11 -0600 Subject: [7376] Allow store in spell_area.aura_spell negative values for "not has aura" requirement. Author: VladimirMangos Also * Allow have in aura_spell spells with SPELL_AURA_PHASE in first effect. * Allow negative aura_spell chaining in spell_area table. * Better check at loading duplicate data (by requiremnt set) in spell_area table. --HG-- branch : trunk --- sql/mangos.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql/mangos.sql') diff --git a/sql/mangos.sql b/sql/mangos.sql index 4e895e9e735..0446fda2bb6 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -22,7 +22,7 @@ DROP TABLE IF EXISTS `db_version`; CREATE TABLE `db_version` ( `version` varchar(120) default NULL, - `required_7369_01_mangos_quest_template` bit(1) default NULL + `required_7376_01_mangos_spell_area` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -13295,7 +13295,7 @@ CREATE TABLE `spell_area` ( `quest_start` mediumint(8) unsigned NOT NULL default '0', `quest_start_active` tinyint(1) unsigned NOT NULL default '0', `quest_end` mediumint(8) unsigned NOT NULL default '0', - `aura_spell` mediumint(8) unsigned NOT NULL default '0', + `aura_spell` mediumint(8) NOT NULL default '0', `racemask` mediumint(8) unsigned NOT NULL default '0', `gender` tinyint(1) unsigned NOT NULL default '2', `autocast` tinyint(1) unsigned NOT NULL default '0', -- cgit v1.2.3