iEat/defs/sql/derby/load-ingredients.sql

INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (1,'avocado',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (2,'banana',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (3,'chocolate chips (dark)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (4,'chocolate chips (milk)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (5,'cornmeal',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (6,'cumin',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (7,'dill',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (8,'egg',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (9,'fennel',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (10,'flour (buckwheat)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (11,'flour (rye)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (12,'flour (white)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (13,'flour (whole wheat)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (14,'garlic',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (15,'ice cube',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (16,'leek',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (17,'lemon',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (18,'lime',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (19,'milk (cow)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (20,'milk (soy)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (21,'milk (rice)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (22,'mozzarella',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (23,'mushroom (white)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (24,'olive oil (extra virgin)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (25,'parchment paper',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (26,'Parmesan',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (27,'pepper',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (28,'porcini (dried)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (29,'salt',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (30,'vinegar (balsamic)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (31,'vinegar (champagne)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (32,'vinegar (red wine)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (33,'water',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (34,'wine (white)',null);
INSERT INTO ingredient (ingredientid,ingr_name,description) VALUES (35,'wine (red)',null);

UPDATE HIBERNATE_UNIQUE_KEY SET NEXT_HI = 1 + (select max(id) from (
	select baseid as id from base union 
	select courseid as id from course union 
	select difficultyid as id from difficulty union 
	select ethnicityid as id from ethnicity union 
	select ingredientid as id from ingredient union 
	select preptimeid as id from preptime union 
	select relationkindid as id from relationkind union 
	select systemid as id from measurement_system union 
	select unitid as id from unit union 
	select userid as id from users
	) as sub);