From 42d904a8bf8c7a856f8303bf1f5577ca9079af73 Mon Sep 17 00:00:00 2001 From: teacher Date: Wed, 13 Jan 2010 21:28:35 +0100 Subject: Added long forgotten sql update for Rev6693 (Add support for RewSpellCast=-1. If -1 remove all auras applied to player at quest start). Thank you Warhead. --HG-- branch : trunk --- sql/world.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'sql/world.sql') diff --git a/sql/world.sql b/sql/world.sql index b0552ec6646..63c669178e1 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -4308,10 +4308,10 @@ CREATE TABLE `quest_template` ( `ReqCreatureOrGOCount2` smallint(5) unsigned NOT NULL DEFAULT '0', `ReqCreatureOrGOCount3` smallint(5) unsigned NOT NULL DEFAULT '0', `ReqCreatureOrGOCount4` smallint(5) unsigned NOT NULL DEFAULT '0', - `ReqSpellCast1` mediumint(8) unsigned NOT NULL DEFAULT '0', - `ReqSpellCast2` mediumint(8) unsigned NOT NULL DEFAULT '0', - `ReqSpellCast3` mediumint(8) unsigned NOT NULL DEFAULT '0', - `ReqSpellCast4` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ReqSpellCast1` int(11) signed NOT NULL DEFAULT '0', + `ReqSpellCast2` int(11) signed NOT NULL DEFAULT '0', + `ReqSpellCast3` int(11) signed NOT NULL DEFAULT '0', + `ReqSpellCast4` int(11) signed NOT NULL DEFAULT '0', `RewChoiceItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewChoiceItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewChoiceItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0', -- cgit v1.2.3