diff options
| author | teacher <none@none> | 2010-01-13 21:43:36 +0100 |
|---|---|---|
| committer | teacher <none@none> | 2010-01-13 21:43:36 +0100 |
| commit | 482604b103d3dd3741e8557de556a5ba5acd9140 (patch) | |
| tree | b19cb8134acf1d102bb77b488c3f2fd04ffcb88d | |
| parent | 42d904a8bf8c7a856f8303bf1f5577ca9079af73 (diff) | |
Fixed typo in previous commit. I misunderstood the fix.
Thank you Aokromes for being there!
--HG--
branch : trunk
| -rw-r--r-- | sql/updates/6984_world_quest_template.sql | 5 | ||||
| -rw-r--r-- | sql/world.sql | 10 |
2 files changed, 6 insertions, 9 deletions
diff --git a/sql/updates/6984_world_quest_template.sql b/sql/updates/6984_world_quest_template.sql index 546898d10aa..1cdef7525be 100644 --- a/sql/updates/6984_world_quest_template.sql +++ b/sql/updates/6984_world_quest_template.sql @@ -1,4 +1 @@ -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; +ALTER TABLE `quest_template` CHANGE `RewSpellCast` `RewSpellCast` int(11) SIGNED NOT NULL DEFAULT 0; diff --git a/sql/world.sql b/sql/world.sql index 63c669178e1..23e0df48bdb 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` 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', + `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', `RewChoiceItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewChoiceItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewChoiceItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0', @@ -4346,7 +4346,7 @@ CREATE TABLE `quest_template` ( `RewOrReqMoney` int(11) NOT NULL DEFAULT '0', `RewMoneyMaxLevel` int(10) unsigned NOT NULL DEFAULT '0', `RewSpell` mediumint(8) unsigned NOT NULL DEFAULT '0', - `RewSpellCast` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewSpellCast` int(11) signed NOT NULL DEFAULT '0', `RewMailTemplateId` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewMailDelaySecs` int(11) unsigned NOT NULL DEFAULT '0', `PointMapId` smallint(5) unsigned NOT NULL DEFAULT '0', |