blob: a3eadacf01ff0d40beb894d006516a43fba0594e (
plain) (
tree)
|
|
--
-- 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;
|