diff options
| author | Kudlaty <none@none> | 2009-11-13 17:15:59 +0100 |
|---|---|---|
| committer | Kudlaty <none@none> | 2009-11-13 17:15:59 +0100 |
| commit | cbd9709d23b7f78c7460f5e12ae1c404aecfe555 (patch) | |
| tree | dbc963645c073476d02880066a2e94dd27b0b427 /sql | |
| parent | 3b4159e1e3364651f2712d47728538c96f824059 (diff) | |
QuestLevel can be -1. Quest with this level are allways show yellow ? above quest giver
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/6241_world_quest_template.sql | 5 | ||||
| -rw-r--r-- | sql/world.sql | 2 |
2 files changed, 6 insertions, 1 deletions
diff --git a/sql/updates/6241_world_quest_template.sql b/sql/updates/6241_world_quest_template.sql new file mode 100644 index 00000000000..bc1fe74c2c3 --- /dev/null +++ b/sql/updates/6241_world_quest_template.sql @@ -0,0 +1,5 @@ +-- Change column QuestLevel to allowed -1 value. +ALTER TABLE `quest_template` CHANGE `QuestLevel` `QuestLeveltemp` INT(8); +ALTER TABLE `quest_template` ADD `QuestLevel` SMALLINT(3) AFTER `QuestLeveltemp`; +UPDATE `quest_template` SET `QuestLevel` = `QuestLeveltemp`; +ALTER TABLE `quest_template` DROP `QuestLeveltemp`; diff --git a/sql/world.sql b/sql/world.sql index 391aae19be6..1c24a339b95 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -2430,7 +2430,7 @@ CREATE TABLE `quest_template` ( `ZoneOrSort` smallint(6) NOT NULL default '0', `SkillOrClass` smallint(6) NOT NULL default '0', `MinLevel` tinyint(3) unsigned NOT NULL default '0', - `QuestLevel` tinyint(3) unsigned NOT NULL default '0', + `QuestLevel` smallint(3) NOT NULL default '0', `Type` smallint(5) unsigned NOT NULL default '0', `RequiredRaces` smallint(5) unsigned NOT NULL default '0', `RequiredSkillValue` smallint(5) unsigned NOT NULL default '0', |