--
--


--
-- Data for TOC entry 8 (OID 97924)
-- Name: recipes; Type: TABLE DATA; Schema: public; Owner: projectjj
--

INSERT INTO recipes VALUES (1, 'Meat Balls (beef)', 4, '00:40:00', '00:20:00', 'http://i.pjj.cc/160f48b557e03b1891bb24e173680d1f.jpg', 'Bla bla, comments...', 7, false, 'Bla bla bla, instructions...');
INSERT INTO recipes VALUES (2, 'Pasta with Tomato Sauce', 4, '00:40:00', '00:10:00', 'http://i.pjj.cc/6165ba745a824d9d74ff0e885d6815fd.jpg', 'Bla bla, comments...', 6, true, 'Bla bla bla, instructions...');


--
-- Data for TOC entry 9 (OID 97933)
-- Name: recipe_types; Type: TABLE DATA; Schema: public; Owner: projectjj
--

INSERT INTO recipe_types VALUES (1, 'Dessert');
INSERT INTO recipe_types VALUES (2, 'Hors d''oeuvre');
INSERT INTO recipe_types VALUES (3, 'Game Dish');
INSERT INTO recipe_types VALUES (4, 'Breakfast');
INSERT INTO recipe_types VALUES (5, 'Lunch');
INSERT INTO recipe_types VALUES (6, 'Main Course');
INSERT INTO recipe_types VALUES (7, 'Side Dish');


--
-- Data for TOC entry 10 (OID 97951)
-- Name: ingredient_units; Type: TABLE DATA; Schema: public; Owner: projectjj
--

INSERT INTO ingredient_units VALUES (1, 'g');
INSERT INTO ingredient_units VALUES (2, 'kg');
INSERT INTO ingredient_units VALUES (3, 'L');
INSERT INTO ingredient_units VALUES (4, 'dL');
INSERT INTO ingredient_units VALUES (5, 'pcs');


--
-- Data for TOC entry 11 (OID 97961)
-- Name: ingredient_types; Type: TABLE DATA; Schema: public; Owner: projectjj
--

INSERT INTO ingredient_types VALUES (1, 'Fruit');
INSERT INTO ingredient_types VALUES (2, 'Vegetable');
INSERT INTO ingredient_types VALUES (3, 'Pork');
INSERT INTO ingredient_types VALUES (4, 'Beef');
INSERT INTO ingredient_types VALUES (5, 'Other');
INSERT INTO ingredient_types VALUES (6, 'Other meat');
INSERT INTO ingredient_types VALUES (7, 'Other non-meat');


--
-- Data for TOC entry 12 (OID 97971)
-- Name: ingredients; Type: TABLE DATA; Schema: public; Owner: projectjj
--

INSERT INTO ingredients VALUES (4, 'Ground Pork', 3, 2, 80);
INSERT INTO ingredients VALUES (1, 'Apple', 1, 5, 2);
INSERT INTO ingredients VALUES (10, 'Chicken', 6, 2, 60);
INSERT INTO ingredients VALUES (2, 'Cucumber', 2, 5, 10);
INSERT INTO ingredients VALUES (5, 'Flour', 7, 2, 5);
INSERT INTO ingredients VALUES (13, 'Fresh Pasta', 7, 2, 40);
INSERT INTO ingredients VALUES (14, 'Oregano', 7, 1, 2);
INSERT INTO ingredients VALUES (15, 'Tomato Sauce', 7, 3, 10);
INSERT INTO ingredients VALUES (3, 'Ground Beef', 4, 2, 80);
INSERT INTO ingredients VALUES (12, 'Pasta', 7, 2, 10);
INSERT INTO ingredients VALUES (8, 'Salt', 6, 1, 0.25);
INSERT INTO ingredients VALUES (11, 'Honey', 5, 1, 6);
INSERT INTO ingredients VALUES (6, 'Egg', 5, 5, 2);
INSERT INTO ingredients VALUES (17, 'Whip cream', 5, 4, 23);


--
-- Data for TOC entry 13 (OID 97987)
-- Name: recipe_ingredients; Type: TABLE DATA; Schema: public; Owner: projectjj
--

INSERT INTO recipe_ingredients VALUES (1, 3, 1);
INSERT INTO recipe_ingredients VALUES (1, 5, 0.1);
INSERT INTO recipe_ingredients VALUES (1, 6, 3);
INSERT INTO recipe_ingredients VALUES (2, 8, 4);
INSERT INTO recipe_ingredients VALUES (2, 13, 1.5);
INSERT INTO recipe_ingredients VALUES (2, 14, 2.5);
INSERT INTO recipe_ingredients VALUES (2, 15, 1);


--
-- Data for TOC entry 14 (OID 98001)
-- Name: menus; Type: TABLE DATA; Schema: public; Owner: projectjj
--

INSERT INTO menus VALUES (1, 'Pasta with Tomato Sauce and Meat Balls', NULL);


--
-- Data for TOC entry 15 (OID 98009)
-- Name: menu_recipes; Type: TABLE DATA; Schema: public; Owner: projectjj
--

INSERT INTO menu_recipes VALUES (1, 2, 10);
INSERT INTO menu_recipes VALUES (1, 1, 11);


--
-- Data for TOC entry 16 (OID 98023)
-- Name: inventories; Type: TABLE DATA; Schema: public; Owner: projectjj
--

INSERT INTO inventories VALUES (1, 'Yule', '2004-12-23', '2004-12-25');
INSERT INTO inventories VALUES (2, 'New Years Eve', '2004-12-31', '2004-12-31');
INSERT INTO inventories VALUES (3, 'Birthday', '2004-09-18', '2004-09-18');
INSERT INTO inventories VALUES (0, 'Current', '0001-01-01', '9999-12-31');


--
-- Data for TOC entry 17 (OID 98031)
-- Name: inventory_ingredients; Type: TABLE DATA; Schema: public; Owner: projectjj
--

INSERT INTO inventory_ingredients VALUES (0, 2, 5);
INSERT INTO inventory_ingredients VALUES (0, 1, 20);
INSERT INTO inventory_ingredients VALUES (0, 10, 2);
INSERT INTO inventory_ingredients VALUES (0, 11, 3);
INSERT INTO inventory_ingredients VALUES (1, 5, 200);
INSERT INTO inventory_ingredients VALUES (1, 6, 300);
INSERT INTO inventory_ingredients VALUES (1, 8, 100);
INSERT INTO inventory_ingredients VALUES (0, 3, 2);
INSERT INTO inventory_ingredients VALUES (0, 5, 2);
INSERT INTO inventory_ingredients VALUES (0, 6, 6);
INSERT INTO inventory_ingredients VALUES (0, 8, 5);


--
-- TOC entry 1 (OID 97922)
-- Name: recipes_recipe_id_seq; Type: SEQUENCE SET; Schema: public; Owner: projectjj
--

SELECT pg_catalog.setval('recipes_recipe_id_seq', 2, true);


--
-- TOC entry 2 (OID 97931)
-- Name: recipe_types_recipe_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: projectjj
--

SELECT pg_catalog.setval('recipe_types_recipe_type_id_seq', 7, true);


--
-- TOC entry 3 (OID 97949)
-- Name: ingredient_units_ingredient_unit_id_seq; Type: SEQUENCE SET; Schema: public; Owner: projectjj
--

SELECT pg_catalog.setval('ingredient_units_ingredient_unit_id_seq', 5, true);


--
-- TOC entry 4 (OID 97959)
-- Name: ingredient_types_ingredient_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: projectjj
--

SELECT pg_catalog.setval('ingredient_types_ingredient_type_id_seq', 7, true);


--
-- TOC entry 5 (OID 97969)
-- Name: ingredients_ingredient_id_seq; Type: SEQUENCE SET; Schema: public; Owner: projectjj
--

SELECT pg_catalog.setval('ingredients_ingredient_id_seq', 17, true);


--
-- TOC entry 6 (OID 97999)
-- Name: menus_menu_id_seq; Type: SEQUENCE SET; Schema: public; Owner: projectjj
--

SELECT pg_catalog.setval('menus_menu_id_seq', 1, true);


--
-- TOC entry 7 (OID 98021)
-- Name: inventories_inventory_id_seq; Type: SEQUENCE SET; Schema: public; Owner: projectjj
--

SELECT pg_catalog.setval('inventories_inventory_id_seq', 3, true);


