-- -- 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;