diff options
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`; |