|
From: <fu...@us...> - 2003-12-14 08:51:10
|
Update of /cvsroot/neelix/neelix/db In directory sc8-pr-cvs1:/tmp/cvs-serv22057/db Modified Files: hans.sql Log Message: Refined the recipes a tad. Index: hans.sql =================================================================== RCS file: /cvsroot/neelix/neelix/db/hans.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** hans.sql 13 Dec 2003 17:55:41 -0000 1.1 --- hans.sql 14 Dec 2003 04:52:46 -0000 1.2 *************** *** 5,10 **** -- name varchar(80) -- ); ! INSERT INTO category VALUES(1,1,'Bread'); ! INSERT INTO category VALUES(2,1,'Sourdough Bread'); -- CREATE TABLE cookbook ( -- cookbook_id INTEGER NOT NULL PRIMARY KEY, --- 5,11 ---- -- name varchar(80) -- ); ! INSERT INTO category VALUES(1,1,'Sourdough Bread'); ! INSERT INTO category VALUES(2,1,'Whole Wheat Bread'); ! INSERT INTO category VALUES(3,1,'White Bread'); -- CREATE TABLE cookbook ( -- cookbook_id INTEGER NOT NULL PRIMARY KEY, *************** *** 22,25 **** --- 23,27 ---- INSERT INTO food VALUES(5,'Sourdough Start'); INSERT INTO food VALUES(6,'Honey'); + INSERT INTO food VALUES(7,'Oil'); -- CREATE TABLE food_measures ( -- food_id INTEGER NOT NULL, *************** *** 37,49 **** -- ); INSERT INTO ingredient VALUES(1,1,1,5,720,'Active, 100% Hydration'); ! INSERT INTO ingredient VALUES(2,1,1,1,540,''); INSERT INTO ingredient VALUES(3,1,1,2,295,NULL); INSERT INTO ingredient VALUES(4,1,2,4,2,NULL); -- CREATE TABLE measure ( -- measure_id INTEGER NOT NULL PRIMARY KEY, -- name varchar(80) -- ); ! INSERT INTO measure VALUES(1,'grams'); ! INSERT INTO measure VALUES(2,'teaspoons'); -- CREATE TABLE recipe ( -- recipe_id INTEGER NOT NULL PRIMARY KEY, --- 39,61 ---- -- ); INSERT INTO ingredient VALUES(1,1,1,5,720,'Active, 100% Hydration'); ! INSERT INTO ingredient VALUES(2,1,1,1,540,NULL); INSERT INTO ingredient VALUES(3,1,1,2,295,NULL); INSERT INTO ingredient VALUES(4,1,2,4,2,NULL); + + INSERT INTO ingredient VALUES(5,2,2,3,2,NULL); + INSERT INTO ingredient VALUES(6,2,4,2,120,'warm'); + INSERT INTO ingredient VALUES(7,2,1,1,900,NULL); + INSERT INTO ingredient VALUES(8,2,2,4,2.5,NULL); + INSERT INTO ingredient VALUES(9,2,4,2,535,'lukewarm'); + INSERT INTO ingredient VALUES(10,2,3,6,2,NULL); + INSERT INTO ingredient VALUES(11,2,3,7,2,NULL); -- CREATE TABLE measure ( -- measure_id INTEGER NOT NULL PRIMARY KEY, -- name varchar(80) -- ); ! INSERT INTO measure VALUES(1,'g'); ! INSERT INTO measure VALUES(2,'tsp'); ! INSERT INTO measure VALUES(3,'Tbsp'); ! INSERT INTO measure VALUES(4,'ml'); -- CREATE TABLE recipe ( -- recipe_id INTEGER NOT NULL PRIMARY KEY, *************** *** 58,66 **** -- note text -- ); ! INSERT INTO recipe VALUES(1,'Basic Whole Wheat Sourdough Bread','Hans Fugal',NULL,'2 loaves',NULL,NULL,NULL,'Knead, let rise, shape and let rise, bake.','Based off the basic whole wheat bread recipe in Laurel''s Kitchen Bread Book.'); -- CREATE TABLE recipe_category ( -- recipe_id INTEGER NOT NULL, -- category_id INTEGER NOT NULL -- ); ! INSERT INTO recipe_category VALUES(1,2); COMMIT; --- 70,80 ---- -- note text -- ); ! INSERT INTO recipe VALUES(1,'Whole Wheat Sourdough Bread','Hans Fugal',NULL,'2 loaves',NULL,NULL,NULL,'Knead, let rise, shape and let rise, bake.','Based off the basic whole wheat bread recipe in Laurel''s Kitchen Bread Book.'); ! INSERT INTO recipe VALUES(2,'Whole Wheat Bread','Hans Fugal',NULL,'2 loaves',NULL,NULL,NULL,'Knead, let rise, shape and let rise, bake.','Based off of basic whole wheat bread from Laurel''s Kitchen Bread Book.'); -- CREATE TABLE recipe_category ( -- recipe_id INTEGER NOT NULL, -- category_id INTEGER NOT NULL -- ); ! INSERT INTO recipe_category VALUES(1,1); ! INSERT INTO recipe_category VALUES(2,2); COMMIT; |