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/updates | |
| 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/updates')
| -rw-r--r-- | sql/updates/6241_world_quest_template.sql | 5 |
1 files changed, 5 insertions, 0 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`; |
