diff options
Diffstat (limited to 'sql-files/main.sql')
-rw-r--r-- | sql-files/main.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index 0b8c9b32c..dc733686b 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -566,6 +566,34 @@ CREATE TABLE `pet` ( ) ENGINE=MyISAM; -- +-- Table structure for table `quest` +-- + +DROP TABLE IF EXISTS `quest`; +CREATE TABLE `quest` ( + `id` int(11) unsigned NOT NULL auto_increment, + `name` varchar(255) NOT NULL default '', + `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 (`id`) +) ENGINE=MyISAM; + +-- +-- Table structure for table `quest_mob` +-- + +DROP TABLE IF EXISTS `quest_objective`; +CREATE TABLE `quest_objective` ( + `id` int(11) unsigned NOT NULL auto_increment, + `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 (`id`) +) ENGINE=MyISAM; + +-- -- Table structure for table `ragsrvinfo` -- |