diff options
| author | teacher <none@none> | 2010-01-13 21:28:35 +0100 |
|---|---|---|
| committer | teacher <none@none> | 2010-01-13 21:28:35 +0100 |
| commit | 42d904a8bf8c7a856f8303bf1f5577ca9079af73 (patch) | |
| tree | 13cde56a6faa059bc71e66a7cfdf99306331abff | |
| parent | 445a603bef1223e5496eb0ce4697505cb108aa47 (diff) | |
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
| -rw-r--r-- | sql/updates/6979_world_scriptname.sql (renamed from sql/updates/6979_world_scriptnames.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/6984_world_quest_template.sql | 4 | ||||
| -rw-r--r-- | sql/updates/CMakeLists.txt | 1 | ||||
| -rw-r--r-- | sql/world.sql | 8 |
4 files changed, 9 insertions, 4 deletions
diff --git a/sql/updates/6979_world_scriptnames.sql b/sql/updates/6979_world_scriptname.sql index c4fb669d47d..c4fb669d47d 100644 --- a/sql/updates/6979_world_scriptnames.sql +++ b/sql/updates/6979_world_scriptname.sql diff --git a/sql/updates/6984_world_quest_template.sql b/sql/updates/6984_world_quest_template.sql new file mode 100644 index 00000000000..546898d10aa --- /dev/null +++ b/sql/updates/6984_world_quest_template.sql @@ -0,0 +1,4 @@ +ALTER TABLE `quest_template` CHANGE `RewSpellCast1` `RewSpellCast1` int(11) SIGNED NOT NULL DEFAULT 0; +ALTER TABLE `quest_template` CHANGE `RewSpellCast2` `RewSpellCast2` int(11) SIGNED NOT NULL DEFAULT 0; +ALTER TABLE `quest_template` CHANGE `RewSpellCast3` `RewSpellCast3` int(11) SIGNED NOT NULL DEFAULT 0; +ALTER TABLE `quest_template` CHANGE `RewSpellCast4` `RewSpellCast4` int(11) SIGNED NOT NULL DEFAULT 0; diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt index f8f6ac50e4b..3097e2d715d 100644 --- a/sql/updates/CMakeLists.txt +++ b/sql/updates/CMakeLists.txt @@ -1,6 +1,7 @@ add_subdirectory(2.4.3_old) add_subdirectory(3.0.9_old) add_subdirectory(3.1.3_old) +add_subdirectory(3.2.2a_old) FILE(GLOB _SQL_UPDATES *.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', |