aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorKudlaty <none@none>2009-11-13 17:15:59 +0100
committerKudlaty <none@none>2009-11-13 17:15:59 +0100
commitcbd9709d23b7f78c7460f5e12ae1c404aecfe555 (patch)
treedbc963645c073476d02880066a2e94dd27b0b427 /sql/updates
parent3b4159e1e3364651f2712d47728538c96f824059 (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.sql5
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`;