[neelix-devel] neelix/db hans.sql,1.1,1.2

[<fu...@us...>]

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;