iEat/defs/sql/mysql/load.sql

INSERT INTO ethnicity (value_) VALUES ('African');
INSERT INTO ethnicity (value_) VALUES ('American');
INSERT INTO ethnicity (value_) VALUES ('Chinese');
INSERT INTO ethnicity (value_) VALUES ('French');
INSERT INTO ethnicity (value_) VALUES ('German');
INSERT INTO ethnicity (value_) VALUES ('Greek');
INSERT INTO ethnicity (value_) VALUES ('Indian');
INSERT INTO ethnicity (value_) VALUES ('Italian');
INSERT INTO ethnicity (value_) VALUES ('Japanese');
INSERT INTO ethnicity (value_) VALUES ('Mexican');
INSERT INTO ethnicity (value_) VALUES ('Middle Eastern');
INSERT INTO ethnicity (value_) VALUES ('None');
INSERT INTO ethnicity (value_) VALUES ('Slavic');
INSERT INTO ethnicity (value_) VALUES ('Thai');

INSERT INTO measurement_system (systemid,value_) VALUES (1,'USA');
INSERT INTO measurement_system (systemid,value_) VALUES (2,'Metric');

-- Generic units
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('small','sm',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('medium','med',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('large','lg',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('unit','ea',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('slice','sli',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('clove','clv',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('pinch','pn',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('package','pk',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('can','cn',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('drop','dr',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('bunch','bn',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('dash','ds',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('carton','ct',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('sprig','sprig',null,0,0,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) 
		VALUES ('leaf','leaf',null,0,0,0,FALSE);

-- US volumes
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('Teaspoon','t',
		1,1,5,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('Tablespoon','T',
		1,3,15,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('Ounce (fluid)','fl. oz',
		1,6,29.56,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('Cup','c',
		1,48,236,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('Pint','pt',
		1,96,473,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('Quart','q',
		1,192,946,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('Gallon','gal',
		1,768,3785.4,0,FALSE);
		
-- US mass
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('Ounce','oz',
		1,1,28.35,0,TRUE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('Pound','lb',
		1,16,454,0,TRUE);

-- Metric volumes	
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('milliliter','ml',
		2,0.203,1,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('cubic centimeter','cc',
		2,0.203,1,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('tea spoon','tsp',
		2,1.015,5,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('centiliter','cl',
		2,2.03,10,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('table spoon','Tbsp',
		2,3.045,15,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('deciliter','dl',
		2,20.3,100,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('cup','cup',
		2,50.75,250,0,FALSE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('liter','L',
		2,203,1000,0,FALSE);

-- Metric mass
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('milligram','mg',
		2,3.448275862E-5,1,0,TRUE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('decagram','dg',
		2,3.448275862E-4,10,0,TRUE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('hectogram','hg',
		2,3.448275862E-3,100,0,TRUE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('gram','g',
		2,3.448275862E-2,1000,0,TRUE);
INSERT INTO unit (value_,abbreviation,systemid,tous,tometric,toimperial,mass) VALUES ('kilogram','kg',
		2,34.48275862,1000000,0,TRUE);

INSERT INTO base (value_) VALUES ('Beef');
INSERT INTO base (value_) VALUES ('Bread');
INSERT INTO base (value_) VALUES ('Dairy');
INSERT INTO base (value_) VALUES ('Egg');
INSERT INTO base (value_) VALUES ('Fruit');
INSERT INTO base (value_) VALUES ('Grain');
INSERT INTO base (value_) VALUES ('Lamb');
INSERT INTO base (value_) VALUES ('Other');
INSERT INTO base (value_) VALUES ('Pasta');
INSERT INTO base (value_) VALUES ('Pork/Ham');
INSERT INTO base (value_) VALUES ('Poultry');
INSERT INTO base (value_) VALUES ('Seafood');
INSERT INTO base (value_) VALUES ('Vegetable');


INSERT INTO preptime (value_) VALUES ('0 Minutes');
INSERT INTO preptime (value_) VALUES ('1-10 Minutes');
INSERT INTO preptime (value_) VALUES ('10-30 Minutes');
INSERT INTO preptime (value_) VALUES ('30-60 Minutes');
INSERT INTO preptime (value_) VALUES ('60+ Minutes');


INSERT INTO difficulty (value_) VALUES ('Easy');
INSERT INTO difficulty (value_) VALUES ('Intermediate');
INSERT INTO difficulty (value_) VALUES ('Difficult');
INSERT INTO difficulty (value_) VALUES ('Expert');


INSERT INTO course (value_) VALUES ('Breakfast');
INSERT INTO course (value_) VALUES ('Snack');
INSERT INTO course (value_) VALUES ('Lunch');
INSERT INTO course (value_) VALUES ('Appetizer');
INSERT INTO course (value_) VALUES ('Side Dish');
INSERT INTO course (value_) VALUES ('Entree');
INSERT INTO course (value_) VALUES ('Dessert');
INSERT INTO course (value_) VALUES ('Beverage');
INSERT INTO course (value_) VALUES ('N/A');