aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorclick <none@none>2010-04-26 04:27:58 +0200
committerclick <none@none>2010-04-26 04:27:58 +0200
commit55a054c10f6ed6e16406540933e02429e57ae3c6 (patch)
tree9e2b0fa54f1bf7c47bfab91eae486ec32292f58d
parentf6b9caff4790f1f5910b24534dcd1916b571c9ec (diff)
Adjust quest_templates "questflags" fieldsize to accomodate any variation of
questflags currently available. --HG-- branch : trunk
-rw-r--r--sql/updates/8006__world_quest_template.sql1
-rw-r--r--sql/world.sql2
2 files changed, 2 insertions, 1 deletions
diff --git a/sql/updates/8006__world_quest_template.sql b/sql/updates/8006__world_quest_template.sql
new file mode 100644
index 00000000000..0a85d5074a2
--- /dev/null
+++ b/sql/updates/8006__world_quest_template.sql
@@ -0,0 +1 @@
+ALTER TABLE `quest_template` CHANGE COLUMN `QuestFlags` `QuestFlags` int(10) unsigned NOT NULL default '0';
diff --git a/sql/world.sql b/sql/world.sql
index 6fdf7173557..1b5721f9675 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -4384,7 +4384,7 @@ CREATE TABLE `quest_template` (
`RequiredMaxRepValue` mediumint(9) NOT NULL DEFAULT '0',
`SuggestedPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0',
`LimitTime` int(10) unsigned NOT NULL DEFAULT '0',
- `QuestFlags` smallint(5) unsigned NOT NULL DEFAULT '0',
+ `QuestFlags` int(10) unsigned NOT NULL DEFAULT '0',
`SpecialFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',
`CharTitleId` tinyint(3) unsigned NOT NULL DEFAULT '0',
`PlayersSlain` tinyint(3) unsigned NOT NULL DEFAULT '0',