summaryrefslogblamecommitdiff
path: root/sql-files/upgrade_svn12545.sql
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;