-- MySQL dump 10.13 Distrib 5.5.15, for osx10.6 (i386)
--
-- Host: localhost Database: test
-- ------------------------------------------------------
-- Server version 5.5.15
/*!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 `recipelist`
--
DROP TABLE IF EXISTS `recipelist`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recipelist` (
`id` int(11) DEFAULT NULL,
`descr` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `recipelist`
--
LOCK TABLES `recipelist` WRITE;
/*!40000 ALTER TABLE `recipelist` DISABLE KEYS */;
INSERT INTO `recipelist` VALUES (101,'\n Beef Parmesan with Garlic Angel Hair Pasta\n Fri, 28 May 04\n \n \n \n \n \n \n \n \n \n \n \n \n \n Preheat oven to 350 degrees F (175 degrees C).\n \n \n Cut cube steak into serving size pieces. Coat meat with the bread crumbs\n and parmesan cheese. Heat olive oil in a large frying pan, and saute 1\n teaspoon of the garlic for 3 minutes. Quick fry (brown quickly on both sides)\n meat. Place meat in a casserole baking dish, slightly overlapping edges.\n Place onion rings and peppers on top of meat, and pour marinara sauce\n over all.\n \n \n Bake at 350 degrees F (175 degrees C) for 30 to 45 minutes, depending on\n the thickness of the meat. Sprinkle mozzarella over meat and leave in the\n oven till bubbly.\n \n \n Boil pasta al dente. Drain, and toss in butter and 1 teaspoon garlic. For a\n stronger garlic taste, season with garlic powder. Top with grated parmesan\n and parsley for color. Serve meat and sauce atop a mound of pasta!\n \n \n \n Make the meat ahead of time, and refrigerate over night, the acid in the\n tomato sauce will tenderize the meat even more. If you do this, save the\n mozzarella till the last minute.\n \n \n this goes well with Linguine Pescadoro\n \n'),(102,' \n Ricotta Pie \n Fri, 28 May 04\n \n \n \n \n \n \n \n \n Beat the 12 eggs, 2 cups sugar and vanilla extract together. Stir in\n the ricotta cheese and the chocolate chips. Set aside.\n \n \n \n \n \n \n \n \n \n \n \n \n Combine the flour, baking powder, and 1 cup of the sugar together. Cut in the\n shortening and mix until the mixture resembles coarse crumbs. Mix in 4 of\n the eggs and 1 teaspoon of the vanilla. Divide dough into 4 balls and chill (if\n needed).\n \n \n \n \n \n \n Preheat oven to 325 degrees F (165 degrees C). Grease two deep dish pie\n plates.\n \n \n Roll out 2 of the balls to fit into the pie pans. Do not make the crust too thick\n as it will expand during cooking and get too thick. Do not flute the edges of\n the dough. Roll out the other 2 balls of dough and cut each into 8 narrow\n strips for the top of the crust. Alternately you can use cookie cutters and\n place the cutouts on the top of the pies.\n \n \n Pour the filling evenly into the pie crusts. Top each pie with 8 narrow strips\n of dough or cookie cut-outs. Brush top of pie with milk for shine. Place foil on\n the edge of crust.\n \n \n Bake at 325 degrees F (165 degrees C) for 20 to 30 minutes then remove\n foil. Continue to bake for another 25 or 30 minutes or until a knife inserted in\n the center comes out clean.\n \n \n \n \n'),(104,' \n Zuppa Inglese\n Fri, 28 May 04\n \n \n \n \n \n \n \n \n \n \n Warm up the milk in a nonstick sauce pan\n \n \n In a large bowl beat the egg yolks with the sugar, add the flour \n and combine the ingredients until well mixed.\n \n \n Add the milk, a little bit at the time to the egg mixture, mixing well.\n \n \n Put the mixture into the sauce pan and cook it on the stove at a medium \n low heat. Mix the cream continuously with a wooden spoon. When it starts\n to thicken remove it from the heat and pour it on a large plate to cool off.\n \n \n Stir the cream now and then so that the top doesnt harden.\n \n \n Dip quickly both sides of the lady fingers in the liquor. Layer them one \n at the time in a glass bowl large enough to contain 7 biscuits.\n \n \n Spread 1/3 of the cream and repeat the layer with lady fingers. Finish \n with the cream.\n \n \n \n Refrigerate for at least 4 hours better yet overnight. Before serving \n decorate the zuppa inglese with whipped cream.\n \n \n \n'),(105,' \n Cailles en Sarcophages\n Fri, 28 May 04\n \n \n \n \n \n \n \n In a large bowl, cut 6 tablespoons of the butter into the flour with \n a pastry blender until the butter is more or less incorporated. Now \n coarsely cut the remaining butter into the flour mixture, leaving many \n visible pieces of butter (about 1/4 inch in diameter should be fine).\n \n \n Dissolve the salt into the ice water. Slowly drizzle the salted water \n into the flour mixture while tossing gently with a fork. When all the water\n has been evenly distributed, there will remain many dry crumbs. Dont worry.\n \n \n Empty the dough out onto a large piece of plastic wrap. By folding up the \n four sides of the wrap and pressing, form a rectangle of dough. Roll the\n dough out just a bit and fold the sides over the middle, forming a piece \n one third the former size. Repeat, this time folding the top and bottom\n to the middle. The butter and flour will not yet be working in harmony, so \n you will probably have to use the plastic wrap to aid you in the first\n few folds.\n \n \n Puff pastry requires a somewhat Calvinist submission of the will and a \n confidence that layers will appear. Roll the dough out again and repeat the\n folding, lightly dusting with flour between every layer. Discard the plastic \n wrap as soon as the dough holds together on its own.\n \n \n The dough will become progressively softer as you work on it, with an almost \n springy texture. After 6 or 10 repetitions of the folding and rolling, cut the \n dough into 18 equal pieces. Wrap each well in plastic wrap and let rest in the \n refrigerator for at least 2 hours.\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n Place the chicken legs and thighs in one baking dish, the chicken breasts \n in another. Rub herbes de Provence under the skin of these chicken parts. \n \n \n Combine the wine with the orange juice, garlic and a liberal sprinkling \n of truffle oil. Chop the onion half and add it. \n \n \n Pour over the chicken parts, cover and refrigerate overnight.\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n Place the chicken parts in a large stockpot, cover with cold water\n and bring to a boil. Skim off the foam that rises to top.\n \n \n When the liquid is relatively clear, add the carrots, celery, whole onion, \n bay leaf, parsley, peppercorns and salt. Reduce the heat, cover and let \n simmer at least 2 hours to make a hearty stock.\n \n \n Strain, discard the solids, and refrigerate the stock.\n \n \n \n \n \n Preheat the oven to 350 degrees. Skim any fat off the stock and pour \n enough over the marinated chicken to cover. Bake the chicken until its \n tender and the juices run clear, about 25 minutes for the breasts, a\n little longer for the legs and thighs.\n \n \n Reserve the juices from one of the baking dishes, skimming the fat off \n the top. Skin, bone and chill the chicken.\n \n \n \n \n \n \n \n \n \n \n \n In a large skillet, saute the mushrooms over medium-high heat in the\n butter and the wine with the shallots and garlic. Spoon out and reserve \n the mushrooms.\n \n \n \n \n \n \n \n \n \n \n \n Add to the mushroom juices in the pan the chicken juices and sherry. \n Cook until reduced by half.\n \n \n In a medium saucepan, melt the butter over low heat and sprinkle in \n the flour. Cook and stir until light brown. Add the reduced juices and\n cook until very thick. (This should yield about 1 1/2 cups.)\n \n \n \n \n \n Combine the sauce with the chicken and mushrooms.\n \n \n \n \n \n \n \n Cut the stack of phyllo sheets in half and lay between two damp, clean \n towels. Lightly dust with flour and roll each of the 18 pieces of dough \n to a diameter of 6 to 8 inches. Set aside.Place about 1/2 cup of the chicken \n mixture into a half sheet of phyllo and wrap like an egg roll into a neat, \n tight package. Place the phyllo-wrapped chicken on the rolled dough, and brush \n the egg white around it.\n \n \n Fold the bottom of the dough up onto the phyllo to form the foot of the \n coffin. Then fold up the sides and top of the dough, pinching it together \n to make a cross shape on the top. Repeat for each sarcophage. Cover and\n chill in the refrigerator for 1 hour.\n \n \n Preheat the oven to 450 degrees. Brush the pastry with egg white and bake \n for 15 minutes, or till golden brown. 18 servings.\n \n \n \n '),(103,' \n Linguine Pescadoro\n Fri, 28 May 04\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n In a heavy saucepan over medium heat saute garlic in olive oil\n until garlic softens.\n \n \n Add Italian seasoning, thyme, crushed red pepper flakes,\n crushed tomatoes, black olives, and the juice from both cans of clams.\n Simmer for 15 minutes.\n \n \n Mix in canned clams, shrimp, scallops, lemon zest,\n and salt and pepper to taste.\n \n \n Simmer for an additional 15 minutes or until\n shrimp and clams are cooked.\n \n \n \n \n \n In a large pot of boiling salted water cook linguini until al dente. Drain.\n \n \n Toss cooked and drained linguine pasta over seafood sauce. Serve warm.\n \n \n \n \n');
/*!40000 ALTER TABLE `recipelist` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `recipes`
--
DROP TABLE IF EXISTS `recipes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recipes` (
`descr` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `recipes`
--
LOCK TABLES `recipes` WRITE;
/*!40000 ALTER TABLE `recipes` DISABLE KEYS */;
INSERT INTO `recipes` VALUES ('\n \n Some recipes used in the XML tutorial.\n \n \n Beef Parmesan with Garlic Angel Hair Pasta\n Fri, 28 May 04\n \n \n \n \n \n \n \n \n \n \n \n \n \n Preheat oven to 350 degrees F (175 degrees C).\n \n \n Cut cube steak into serving size pieces. Coat meat with the bread crumbs\n and parmesan cheese. Heat olive oil in a large frying pan, and saute 1\n teaspoon of the garlic for 3 minutes. Quick fry (brown quickly on both sides)\n meat. Place meat in a casserole baking dish, slightly overlapping edges.\n Place onion rings and peppers on top of meat, and pour marinara sauce\n over all.\n \n \n Bake at 350 degrees F (175 degrees C) for 30 to 45 minutes, depending on\n the thickness of the meat. Sprinkle mozzarella over meat and leave in the\n oven till bubbly.\n \n \n Boil pasta al dente. Drain, and toss in butter and 1 teaspoon garlic. For a\n stronger garlic taste, season with garlic powder. Top with grated parmesan\n and parsley for color. Serve meat and sauce atop a mound of pasta!\n \n \n \n Make the meat ahead of time, and refrigerate over night, the acid in the\n tomato sauce will tenderize the meat even more. If you do this, save the\n mozzarella till the last minute.\n \n \n this goes well with Linguine Pescadoro\n \n \n Ricotta Pie \n Fri, 28 May 04\n \n \n \n \n \n \n \n \n Beat the 12 eggs, 2 cups sugar and vanilla extract together. Stir in\n the ricotta cheese and the chocolate chips. Set aside.\n \n \n \n \n \n \n \n \n \n \n \n \n Combine the flour, baking powder, and 1 cup of the sugar together. Cut in the\n shortening and mix until the mixture resembles coarse crumbs. Mix in 4 of\n the eggs and 1 teaspoon of the vanilla. Divide dough into 4 balls and chill (if\n needed).\n \n \n \n \n \n \n Preheat oven to 325 degrees F (165 degrees C). Grease two deep dish pie\n plates.\n \n \n Roll out 2 of the balls to fit into the pie pans. Do not make the crust too thick\n as it will expand during cooking and get too thick. Do not flute the edges of\n the dough. Roll out the other 2 balls of dough and cut each into 8 narrow\n strips for the top of the crust. Alternately you can use cookie cutters and\n place the cutouts on the top of the pies.\n \n \n Pour the filling evenly into the pie crusts. Top each pie with 8 narrow strips\n of dough or cookie cut-outs. Brush top of pie with milk for shine. Place foil on\n the edge of crust.\n \n \n Bake at 325 degrees F (165 degrees C) for 20 to 30 minutes then remove\n foil. Continue to bake for another 25 or 30 minutes or until a knife inserted in\n the center comes out clean.\n \n \n \n \n \n Linguine Pescadoro\n Fri, 28 May 04\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n In a heavy saucepan over medium heat saute garlic in olive oil\n until garlic softens.\n \n \n Add Italian seasoning, thyme, crushed red pepper flakes,\n crushed tomatoes, black olives, and the juice from both cans of clams.\n Simmer for 15 minutes.\n \n \n Mix in canned clams, shrimp, scallops, lemon zest,\n and salt and pepper to taste.\n \n \n Simmer for an additional 15 minutes or until\n shrimp and clams are cooked.\n \n \n \n \n \n In a large pot of boiling salted water cook linguini until al dente. Drain.\n \n \n Toss cooked and drained linguine pasta over seafood sauce. Serve warm.\n \n \n \n \n \n Zuppa Inglese\n Fri, 28 May 04\n \n \n \n \n \n \n \n \n \n \n Warm up the milk in a nonstick sauce pan\n \n \n In a large bowl beat the egg yolks with the sugar, add the flour \n and combine the ingredients until well mixed.\n \n \n Add the milk, a little bit at the time to the egg mixture, mixing well.\n \n \n Put the mixture into the sauce pan and cook it on the stove at a medium \n low heat. Mix the cream continuously with a wooden spoon. When it starts\n to thicken remove it from the heat and pour it on a large plate to cool off.\n \n \n Stir the cream now and then so that the top doesnt harden.\n \n \n Dip quickly both sides of the lady fingers in the liquor. Layer them one \n at the time in a glass bowl large enough to contain 7 biscuits.\n \n \n Spread 1/3 of the cream and repeat the layer with lady fingers. Finish \n with the cream.\n \n \n \n Refrigerate for at least 4 hours better yet overnight. Before serving \n decorate the zuppa inglese with whipped cream.\n \n \n \n \n Cailles en Sarcophages\n Fri, 28 May 04\n \n \n \n \n \n \n \n In a large bowl, cut 6 tablespoons of the butter into the flour with \n a pastry blender until the butter is more or less incorporated. Now \n coarsely cut the remaining butter into the flour mixture, leaving many \n visible pieces of butter (about 1/4 inch in diameter should be fine).\n \n \n Dissolve the salt into the ice water. Slowly drizzle the salted water \n into the flour mixture while tossing gently with a fork. When all the water\n has been evenly distributed, there will remain many dry crumbs. Dont worry.\n \n \n Empty the dough out onto a large piece of plastic wrap. By folding up the \n four sides of the wrap and pressing, form a rectangle of dough. Roll the\n dough out just a bit and fold the sides over the middle, forming a piece \n one third the former size. Repeat, this time folding the top and bottom\n to the middle. The butter and flour will not yet be working in harmony, so \n you will probably have to use the plastic wrap to aid you in the first\n few folds.\n \n \n Puff pastry requires a somewhat Calvinist submission of the will and a \n confidence that layers will appear. Roll the dough out again and repeat the\n folding, lightly dusting with flour between every layer. Discard the plastic \n wrap as soon as the dough holds together on its own.\n \n \n The dough will become progressively softer as you work on it, with an almost \n springy texture. After 6 or 10 repetitions of the folding and rolling, cut the \n dough into 18 equal pieces. Wrap each well in plastic wrap and let rest in the \n refrigerator for at least 2 hours.\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n Place the chicken legs and thighs in one baking dish, the chicken breasts \n in another. Rub herbes de Provence under the skin of these chicken parts. \n \n \n Combine the wine with the orange juice, garlic and a liberal sprinkling \n of truffle oil. Chop the onion half and add it. \n \n \n Pour over the chicken parts, cover and refrigerate overnight.\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n Place the chicken parts in a large stockpot, cover with cold water\n and bring to a boil. Skim off the foam that rises to top.\n \n \n When the liquid is relatively clear, add the carrots, celery, whole onion, \n bay leaf, parsley, peppercorns and salt. Reduce the heat, cover and let \n simmer at least 2 hours to make a hearty stock.\n \n \n Strain, discard the solids, and refrigerate the stock.\n \n \n \n \n \n Preheat the oven to 350 degrees. Skim any fat off the stock and pour \n enough over the marinated chicken to cover. Bake the chicken until its \n tender and the juices run clear, about 25 minutes for the breasts, a\n little longer for the legs and thighs.\n \n \n Reserve the juices from one of the baking dishes, skimming the fat off \n the top. Skin, bone and chill the chicken.\n \n \n \n \n \n \n \n \n \n \n \n In a large skillet, saute the mushrooms over medium-high heat in the\n butter and the wine with the shallots and garlic. Spoon out and reserve \n the mushrooms.\n \n \n \n \n \n \n \n \n \n \n \n Add to the mushroom juices in the pan the chicken juices and sherry. \n Cook until reduced by half.\n \n \n In a medium saucepan, melt the butter over low heat and sprinkle in \n the flour. Cook and stir until light brown. Add the reduced juices and\n cook until very thick. (This should yield about 1 1/2 cups.)\n \n \n \n \n \n Combine the sauce with the chicken and mushrooms.\n \n \n \n \n \n \n \n Cut the stack of phyllo sheets in half and lay between two damp, clean \n towels. Lightly dust with flour and roll each of the 18 pieces of dough \n to a diameter of 6 to 8 inches. Set aside.Place about 1/2 cup of the chicken \n mixture into a half sheet of phyllo and wrap like an egg roll into a neat, \n tight package. Place the phyllo-wrapped chicken on the rolled dough, and brush \n the egg white around it.\n \n \n Fold the bottom of the dough up onto the phyllo to form the foot of the \n coffin. Then fold up the sides and top of the dough, pinching it together \n to make a cross shape on the top. Repeat for each sarcophage. Cover and\n chill in the refrigerator for 1 hour.\n \n \n Preheat the oven to 450 degrees. Brush the pastry with egg white and bake \n for 15 minutes, or till golden brown. 18 servings.\n \n \n \n \n');
/*!40000 ALTER TABLE `recipes` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 */;
-- Dump completed on 2011-11-14 15:37:57