1 files changed, 24 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn12559.sql b/sql-files/upgrade_svn12559.sql
new file mode 100644
index 000000000..66f36a468
--- /dev/null
+++ b/sql-files/upgrade_svn12559.sql
@@ -0,0 +1,24 @@
+--
+-- Table structure for table `quest`
+--
+
+DROP TABLE IF EXISTS `quest`;
+CREATE TABLE `quest` (
+  `char_id` int(11) unsigned NOT NULL default '0',
+  `quest_id` int(10) unsigned NOT NULL,
+  `state` enum('1','0') NOT NULL default '0',
+  PRIMARY KEY  USING BTREE (`char_id`,`quest_id`)
+) ENGINE=MyISAM;
+
+--
+-- Table structure for table `quest_mob`
+--
+
+DROP TABLE IF EXISTS `quest_objective`;
+CREATE TABLE `quest_objective` (
+  `quest_id` int(11) unsigned NOT NULL,
+  `count` mediumint(8) unsigned NOT NULL default '0',
+  `name` varchar(255) NOT NULL default '',
+  `num` tinyint(3) unsigned NOT NULL,
+  PRIMARY KEY  USING BTREE (`quest_id`,`num`)
+) ENGINE=MyISAM;