-- MySQL dump 10.10
--
-- Host: localhost    Database: RECIPE
-- ------------------------------------------------------
-- Server version	5.0.24a-Debian_9-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `ingredient`
--

DROP TABLE IF EXISTS `ingredient`;
CREATE TABLE `ingredient` (
  `ingredient_id` int(11) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL,
  `description` varchar(250) default NULL,
  PRIMARY KEY  (`ingredient_id`),
  KEY `XAK1level` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ingredient`
--


/*!40000 ALTER TABLE `ingredient` DISABLE KEYS */;
LOCK TABLES `ingredient` WRITE;
INSERT INTO `ingredient` VALUES (1,'egg','egg'),(2,'sugar','white sugar'),(3,'light corn syrup','light corn syrup'),(4,'vanilla extract','pure vanilla'),(5,'deep dish pie crust','deep dish pie crust'),(6,'salt','salt'),(7,'pecan','pecans'),(8,'cream cheese','cream cheese'),(9,'jalapeno peppers','fresh jalapeno peppers'),(10,'diced onions','fresh diced onions'),(11,'vinegar','white vinegar'),(12,'water','water'),(13,'celery seed','celery seed'),(14,'mustard seed','mustard seed'),(15,'turmeric','turmeric'),(16,'garlic powder','garlic powder'),(17,'ginger','ginger');
UNLOCK TABLES;
/*!40000 ALTER TABLE `ingredient` ENABLE KEYS */;

--
-- Table structure for table `recipe`
--

DROP TABLE IF EXISTS `recipe`;
CREATE TABLE `recipe` (
  `recipe_id` int(11) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL,
  `description` varchar(250) default NULL,
  `notes` mediumtext,
  PRIMARY KEY  (`recipe_id`),
  KEY `XAK1level` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `recipe`
--


/*!40000 ALTER TABLE `recipe` DISABLE KEYS */;
LOCK TABLES `recipe` WRITE;
INSERT INTO `recipe` VALUES (1,'Mystery Pecan Pie','Nice pecan pie made with cream chesse','Chill or freeze base before adding topping.  This will keep them from mixing too much during the baking process.  Bake for 45 minutes. Serve warm or at room temp.'),(2,'Cowboy Candy','Candied Jalapenos',NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `recipe` ENABLE KEYS */;

--
-- Table structure for table `recipe_ingredient_map`
--

DROP TABLE IF EXISTS `recipe_ingredient_map`;
CREATE TABLE `recipe_ingredient_map` (
  `recipe_part_id` int(11) NOT NULL,
  `ingredient_id` int(11) NOT NULL,
  `amount` varchar(20) NOT NULL,
  PRIMARY KEY  (`recipe_part_id`,`ingredient_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `recipe_ingredient_map`
--


/*!40000 ALTER TABLE `recipe_ingredient_map` DISABLE KEYS */;
LOCK TABLES `recipe_ingredient_map` WRITE;
INSERT INTO `recipe_ingredient_map` VALUES (1,8,'1 8oz package'),(1,2,'1/3 cup'),(1,6,'1/4t'),(1,4,'1t'),(1,1,'1'),(1,5,'1'),(1,7,'1 1/4c chopped'),(2,1,'3'),(2,2,'1/4 cup'),(2,3,'1 cup'),(2,4,'1t'),(3,9,'4 lbs sliced'),(3,10,'2 lbs'),(3,12,'1/2c'),(3,11,'1/2c'),(3,2,'6-8c'),(3,14,'2T'),(3,15,'1t'),(3,16,'1T'),(3,17,'1t'),(3,13,'2t (optional)');
UNLOCK TABLES;
/*!40000 ALTER TABLE `recipe_ingredient_map` ENABLE KEYS */;

--
-- Table structure for table `recipe_part`
--

DROP TABLE IF EXISTS `recipe_part`;
CREATE TABLE `recipe_part` (
  `recipe_part_id` int(11) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL,
  `directions` mediumtext,
  PRIMARY KEY  (`recipe_part_id`),
  KEY `XAK1level` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `recipe_part`
--


/*!40000 ALTER TABLE `recipe_part` DISABLE KEYS */;
LOCK TABLES `recipe_part` WRITE;
INSERT INTO `recipe_part` VALUES (1,'Base','In a medium bowl, mix cream cheese, sugar, salt, vanilla, and egg until combined. Pour into pie shell. Top with chopped pecans.'),(2,'Topping','Combine all topping ingredients in a medium bowl.'),(3,'Main','Slice jalapenos into thin slices and dice onions. Place in pan with water and vinegar, bring to a boil, reduce heat, and simmer about 10 minutes or until peppers and onions are tender (do not breath fumes). Pour off most of the water-vinegar mixture, add the sugar and spices, and bring to soft-candy temperature to completely dissolve the sugar, about another 10 minutes. Place boiling mixture into jars, leaving 1/4-inch head space. Adjust caps.');
UNLOCK TABLES;
/*!40000 ALTER TABLE `recipe_part` ENABLE KEYS */;

--
-- Table structure for table `recipe_part_map`
--

DROP TABLE IF EXISTS `recipe_part_map`;
CREATE TABLE `recipe_part_map` (
  `recipe_id` int(11) NOT NULL,
  `recipe_part_id` int(11) NOT NULL,
  PRIMARY KEY  (`recipe_part_id`,`recipe_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `recipe_part_map`
--


/*!40000 ALTER TABLE `recipe_part_map` DISABLE KEYS */;
LOCK TABLES `recipe_part_map` WRITE;
INSERT INTO `recipe_part_map` VALUES (1,1),(1,2),(2,3);
UNLOCK TABLES;
/*!40000 ALTER TABLE `recipe_part_map` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;