--
-- Table structure for table `recipe`
--
CREATE TABLE IF NOT EXISTS `recipe` (
  `nid` int(10) unsigned NOT NULL auto_increment,
  `source` varchar(255) default NULL,
  `yield` int(11) NOT NULL,
  `instructions` text,
  `notes` text,
  `preptime` int(10) unsigned default '0',
  PRIMARY KEY  (`nid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ;

--
-- Table structure for table `recipe_ingredient`
--
CREATE TABLE IF NOT EXISTS `recipe_ingredient` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `link` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;

--
-- Table structure for table `recipe_node_ingredient`
--
CREATE TABLE IF NOT EXISTS `recipe_node_ingredient` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `nid` int(10) unsigned NOT NULL,
  `unit_id` int(10) unsigned NOT NULL,
  `quantity` float default NULL,
  `ingredient_id` int(10) unsigned NOT NULL,
  `weight` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;

--
-- Table structure for table `recipe_unit`
--
CREATE TABLE IF NOT EXISTS `recipe_unit` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `abbreviation` varchar(8) default NULL,
  `metric` int(10) unsigned NOT NULL default '0',
  `type` varchar(6) NOT NULL default 'Mass',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;