aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/6664_world_quest_template.sql3
-rw-r--r--sql/world.sql2
2 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/6664_world_quest_template.sql b/sql/updates/6664_world_quest_template.sql
new file mode 100644
index 00000000000..c0f6b5fe4f7
--- /dev/null
+++ b/sql/updates/6664_world_quest_template.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `quest_template` ADD `RepObjectiveFaction2` smallint(5) UNSIGNED NOT NULL DEFAULT 0 AFTER `RepObjectiveValue`;
+ALTER TABLE `quest_template` ADD `RepObjectiveValue2` mediumint(9) NOT NULL DEFAULT 0 AFTER `RepObjectiveFaction2`;
+
diff --git a/sql/world.sql b/sql/world.sql
index 69504248ea6..a589d7bdb38 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -3828,6 +3828,8 @@ CREATE TABLE `quest_template` (
`RequiredSkillValue` smallint(5) unsigned NOT NULL DEFAULT '0',
`RepObjectiveFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
`RepObjectiveValue` mediumint(9) NOT NULL DEFAULT '0',
+ `RepObjectiveFaction2` smallint(5) unsigned NOT NULL DEFAULT '0',
+ `RepObjectiveValue2` mediumint(9) NOT NULL DEFAULT '0',
`RequiredMinRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
`RequiredMinRepValue` mediumint(9) NOT NULL DEFAULT '0',
`RequiredMaxRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0',