iEat/defs/sql/postgres/load-ingredients.sql

INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'avocado',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'banana',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'chocolate chips (dark)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'chocolate chips (milk)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'cornmeal',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'cumin',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'dill',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'egg',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'fennel',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'flour (buckwheat)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'flour (rye)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'flour (white)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'flour (whole wheat)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'garlic',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'ice cube',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'leek',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'lemon',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'lime',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'milk (cow)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'milk (soy)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'milk (rice)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'mozzarella',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'mushroom (white)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'olive oil (extra virgin)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'parchment paper',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'Parmesan',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'pepper',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'porcini (dried)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'salt',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'vinegar (balsamic)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'vinegar (champagne)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'vinegar (red wine)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'water',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'wine (white)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (nextval('hibernate_integer_seq'),'wine (red)',null);

/*
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (214,'semi-sweet chocolate chips',3,2.69,5,'t','usa','Nestle');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (83,'banana',36,0.59,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (223,'green beans',36,1.99,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (123,'lemon juice',26,2.99,17,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (202,'basil leaves',42,7.58,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (289,'canned bamboo shoots',27,0.11,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (39,'chicken broth',41,0.099,15,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (58,'cereal',24,0.2325,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (246,'cool whip',21,3.18,1,'t','usa','refrigerate! do not freeze!');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (165,'allspice',42,3.429,15,'t','usa','ground');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (27,'milk',15,0.825,17,'f','usa','2 %');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (44,'coffee beans',11,4.39,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (264,'hazelnut liquor',1,0,11,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (82,'hand soap',23,0,1,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (276,'linguine',34,1.19,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (151,'parsley flakes',42,9.96,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (222,'egg noodles',34,1.32,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (274,'canned minced clams',9,1.48,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (192,'bbq manwich',34,1.75,14,'t','usa','Hunt's');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (137,'crescent rolls',15,0.28625,15,'t','usa','Pillsbury');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (52,'honey',35,0.249375,15,'f','usa','in the bear!');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (277,'ketchup',12,0.073125,15,'f','usa','Hunt's');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (33,'olive oil',31,3.99,17,'f','usa','extra virgin');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (40,'parmesan cheese',16,7.99,14,'t','usa','grated');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (84,'buttermilk',15,1.99,17,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (109,'parsley',36,0.99,8,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (67,'italian bread',2,1.19,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (287,'lemon peel',42,3.327,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (113,'beef bouillon',41,0.0838,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (59,'bisquick',32,1.2,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (17,'beef flip steak',29,3.99,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (153,'chicken breast',29,4.99,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (45,'coffee filters',11,1.25,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (282,'dish soap',25,1.29,1,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (42,'mozzarella slices',15,0.365,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (145,'laundry detergent',28,6.39,1,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (239,'mexican grated cheese',15,0.32375,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (230,'jalapeno pepper',27,0.1575,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (271,'basil pesto sauce',34,0.8489,15,'f','usa','In the jar');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (55,'brown sugar',3,0.645,14,'t','usa','light brown');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (43,'coca-cola',40,3.89,1,'f','usa','12-pack of cans');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (154,'cream of mushroom soup',41,1,6,'f','usa','Campbell's Great for Cooking (blue label)');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (207,'cream of chicken soup',41,1.18,6,'f','usa','Cambell's Great for Cooking (blue label)');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (28,'green onion',36,0.5,1,'t','usa','scallion');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (124,'ginger',36,0,13,'t','usa','ground');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (138,'jellied cranberry sauce',8,0.89,1,'t','usa','Ocean Spray');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (183,'marsala wine',31,0.18,15,'f','usa','not cooking wine');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (152,'oregano ',42,0.49833,15,'t','usa','leaves');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (48,'orange juice',15,1.65,17,'f','usa','no pulp, preferably with calcium');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (98,'grape jelly',35,0.075,15,'f','usa','Welch's in the jar');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (155,'button mushroom',36,0.19875,1,'t','usa','Creekside Moonlight mushrooms');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (197,'canned pruned italian tomatos',10,0,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (284,'green bell pepper',36,0.79,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (212,'dry sherry',31,0.17244,15,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (3,'butter',15,2.99,14,'t','usa','salted');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (77,'sushi rice',27,0.738,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (87,'granola bar',6,2.99,1,'t','usa','Quaker chocolate chip');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (244,'pumpkin pie mix',3,0.086,15,'t','usa','Libby's');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (163,'cilantro',36,0.99,8,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (121,'gladware',19,2.89,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (6,'ice cream',15,2.695,17,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (47,'lambrusco wine',1,0,1,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (1,'baking potato',36,0.75,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (206,'seasoned croutons',31,0.2345,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (10,'sugar',3,0.398,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (162,'tortilla chips',38,3.29,5,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (130,'tortilla',15,0.25625,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (136,'white bread',5,0.99,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (299,'sangria',1,0,1,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (53,'vanilla extract',42,2.295,15,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (300,'paper towels',33,0.99,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (245,'evaporated milk',3,0.115,15,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (32,'garlic powder',42,2.935,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (261,'graham cracker pie crust',3,1.89,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (168,'green chili',27,0.2475,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (275,'italian seasonings',42,5.32,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (260,'kidney beans',10,0.69,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (63,'monterey jack cheese',15,3.99,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (101,'napkins',33,2.69,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (111,'paprika',42,2.37619,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (118,'aluminum foil',19,1.19,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (129,'baking powder',3,0.169,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (85,'baking soda',3,0.69,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (240,'black beans',10,0.69,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (147,'ziti',34,0.95,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (31,'cheddar cheese',15,3.99,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (161,'chili powder',42,1.99583,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (248,'chinese five spice',42,0.845,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (96,'cocoa powder',3,0.31125,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (211,'corn starch',3,0.89,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (172,'cream of tartar',42,1.992,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (110,'red wine vinegar',31,0.1724,15,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (196,'rotini',34,0.89,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (29,'salt',42,0.018846,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (263,'semi-sweet baking chocolate',3,0.33625,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (256,'rosemary ',42,4.34,15,'t','usa','leaves');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (280,'white chocolate chips',3,2.69,5,'t','usa','Nestle');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (51,'tea bags',11,3.09,1,'t','usa','herbal');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (247,'teriyaki sauce',27,0.189,15,'f','usa','Kikkoman marinade');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (125,'vegetable oil',31,1.99,17,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (302,'muffin cups',3,0.0158,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (303,'pork chop',29,1.99,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (184,'angel hair pasta',34,0.86,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (20,'apple',36,0.495,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (305,'beef sirloin tip steak',29,3.19,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (306,'beef brisket',29,3.49,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (224,'carrot',36,0.198,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (72,'beef rump roast',29,2.79,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (203,'deli turkey',29,1.99,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (70,'dryer sheets',28,2.49,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (34,'yellow onion',36,0.5175,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (12,'white onion',36,0.595,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (174,'roma tomato',36,0.22,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (139,'turkey sausage',29,3.19,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (182,'portobello mushroom',36,1.4975,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (208,'sweet pea pods',36,3.99,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (257,'red potato',36,0.1975,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (89,'pine sol',25,2.49,1,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (102,'plastic spoons',33,0.99,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (178,'plastic wrap',19,3.29,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (236,'raspberry preserves',35,0.17722,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (149,'ricotta cheese',15,0.398333,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (90,'sandwich bags',19,1.99,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (93,'windex',25,3.39,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (251,'snow pea pods',36,3.99,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (179,'sponge',25,0.99,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (186,'summer squash',36,0.995,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (86,'sweet potato',36,1.1175,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (104,'toilet bowl cleaner',25,2.49,1,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (180,'toilet paper',43,4.99,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (181,'trash bags',19,2.39,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (189,'roasting chicken',29,6.71,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (144,'formula 409',25,2.99,1,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (193,'hamburger bun',5,0.09875,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (188,'lemon',36,0.2,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (262,'oreo cookies',13,0.157917,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (24,'bag of salad',36,0.598,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (311,'vegetable broth',41,0,11,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (314,'curry',42,0,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (316,'couscous',27,0,11,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (37,'red bell pepper',36,1.49,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (142,'bar soap',23,2.39,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (310,'tortellini',16,3.69,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (309,'tarragon',36,1.99,8,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (238,'fajita seasoning mix',27,0.9815,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (328,'deli ham',16,6.99,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (332,'heavy cream',15,4.99,17,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (329,'swiss cheese',15,3.29,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (333,'sour cherries',8,0.164622,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (122,'light bulbs (2)',33,3.89,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (66,'bacon',29,0.1645,2,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (131,'bottled salsa',27,0.180625,15,'f','usa','if fresh is not available');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (148,'tomato sauce',34,0.043125,15,'f','usa','Hunt's');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (166,'scallops',39,3.99,14,'t','usa','sea');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (50,'strawberry wine',1,3.39,1,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (266,'unsweetened baking chocolate',3,0.31125,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (64,'wheat bread',5,0.05,2,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (2,'sour cream',15,0.124375,15,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (308,'chives',36,1.99,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (334,'hot sauce',27,0,1,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (62,'deli chicken',29,0.33,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (46,'green tea bag',11,0.1204,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (312,'garbanzo beans',27,0.69,6,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (318,'lamb',29,4.99,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (335,'kleenex',18,0,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (216,'skinless salmon fillet',39,6.75,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (336,'active dry yeast',15,0,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (337,'cornmeal',3,0,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (294,'marachino cherries',21,1.19,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (341,'pecans',36,0,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (338,'barley',37,0.415,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (330,'wild rice',37,0.415,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (204,'deli mustard',12,0.140625,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (346,'worcestershire sauce',12,0.249,15,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (344,'bread crumbs',5,1.39,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (345,'dry mustard',42,1.8645,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (21,'applesauce',8,2.19,1,'f','usa','individual packets ');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (159,'avocado',36,1.19,1,'t','usa','ripe when soft if squeezed; place in sun to ripen');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (25,'bacon bits',31,1.99,1,'t','usa','made from REAL bacon only!');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (99,'bagel',5,0.333,1,'t','usa','Thomas Toaster Bagels');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (304,'beef stew meat',29,2.29,14,'t','usa','not the best quality, but nicely cubed');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (73,'beefy onion soup mix',41,0.795,5,'t','usa','Lipton's');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (97,'biscuits',15,1.39,1,'t','usa','Pillsbury');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (30,'black pepper',42,0.995,15,'t','usa','ground');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (235,'blueberries',36,2.99,11,'t','usa','frozen or fresh');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (273,'bourbon whiskey',1,0.56826,15,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (13,'broccoli',36,1.19,1,'t','usa','florets');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (343,'canned salmon',9,2.39,6,'t','usa','pink');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (297,'ceaser dressing',31,5.84,17,'f','usa','Ken's Steakhouse lite');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (295,'chocolate syrup',11,1.99,1,'f','usa','hershey's');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (56,'walnuts',3,0,11,'t','usa','chopped');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (298,'cucumber ranch dressing',31,6.34,17,'f','usa','Kraft');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (210,'ginger root',36,0.124375,2,'t','usa','throw away the first piece you cut off every time you use it');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (171,'cinnamon',42,1.937,15,'t','usa','ground');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (243,'cloves',42,7.053,15,'t','usa','ground');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (22,'italian salad dressing',31,5.84,17,'f','usa','Ken's Steakhouse Zesty Italian');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (49,'lemonade',40,3.89,1,'f','usa','Countrytime Pink 12-pack');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (116,'macaroni & cheese',34,0.99,1,'t','usa','Kraft classic');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (65,'mayonnaise',31,3.49,17,'t','usa','Helmann's');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (190,'pierogies',29,0,1,'t','usa','Sophie's Choice');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (175,'peanut butter',35,0.131875,15,'t','usa','Jiffy');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (215,'powdered sugar',3,0.99,14,'t','usa','confectioners sugar');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (79,'rice vinegar',27,0,11,'f','usa','NOT a dressing');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (185,'zucchini',36,0.59666,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (5,'yogurt',15,0.75,1,'f','usa','Yoplait');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (296,'whipped cream',15,1.69,1,'t','usa','sshhhhhh');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (198,'white cooking wine',31,0.18,15,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (283,'tv dinner',21,2.99,1,'t','usa','Lean Cuisine');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (315,'turmeric ',42,0,15,'t','usa','Indian Saffron');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (23,'tomato',36,0.995,1,'t','usa','garden vine, hothouse, or salad');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (219,'shallot',36,0.3,1,'t','usa','tiny type of onion bulb');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (169,'shortening',31,0.119375,15,'t','usa','Crisco');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (74,'smoked salmon',15,1.0475,15,'t','usa','lox');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (342,'strawberries',36,2.99,11,'t','usa','fresh or frozen');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (117,'stuffing mix',35,1.99,1,'t','usa','Stovetop');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (61,'syrup',32,2.52,17,'f','usa','for pancakes');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (331,'kirsch',1,0.5284,15,'f','usa','cherry liquor');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (347,'shitake mushroom',36,7.99,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (348,'beef flank steak',29,0,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (349,'red onion',36,0,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (350,'red cooking wine',31,0,15,'f','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (351,'beef chuck roast',29,0,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (112,'bay leaves',42,0.13,1,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (80,'sushi seaweed',27,0.159,1,'t','usa','sheet of seaweed');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (250,'baby corn',27,0.14,15,'t','usa','canned');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (249,'water chestnuts',27,0.07375,15,'t','usa','canned & sliced');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (78,'wasabi',27,2.29,15,'t','usa','Japanese horseradish');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (140,'white rice',27,0.738,14,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (81,'pickled ginger',27,0.149,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (8,'soy sauce',27,0.329,15,'f','usa','San-J');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (269,'lasagna noodles',34,1.49,14,'t','usa','oven ready');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (268,'diced tomatoes',10,0.06375,15,'t','usa','canned');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (38,'tomato paste',34,0.099375,15,'f','usa','Hunt's');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (339,'frozen corn',21,0.099,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (340,'frozen peas',21,0.099,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (352,'bowtie pasta',34,0,15,'t','usa','');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (26,'flour',3,0.278,14,'t','usa','white sifted all-purpose');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (353,'cabbage',36,2,1,'t','usa','head of cabbage');
INSERT INTO recipe_ingredients (ingredient_id, ingredient_name, ingredient_location, ingredient_price, ingredient_unit, ingredient_solid, ingredient_system, ingredient_desc) VALUES (354,'white vinegar',31,0,15,'f','usa','');
*/