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;
|
