diff options
| -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', |