aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/7680_world_quest_template.sql1
-rw-r--r--sql/world.sql1
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/7680_world_quest_template.sql b/sql/updates/7680_world_quest_template.sql
new file mode 100644
index 00000000000..296f2d5cdba
--- /dev/null
+++ b/sql/updates/7680_world_quest_template.sql
@@ -0,0 +1 @@
+ALTER TABLE `quest_template` ADD COLUMN `MaxLevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `MinLevel`;
diff --git a/sql/world.sql b/sql/world.sql
index 1ac1ee4e7e9..9db5ff08fb4 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -4369,6 +4369,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',
+ `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
`QuestLevel` smallint(3) NOT NULL DEFAULT '1',
`Type` smallint(5) unsigned NOT NULL DEFAULT '0',
`RequiredRaces` smallint(5) unsigned NOT NULL DEFAULT '0',