INSERT INTO `user` (`forename`, `surname`, `username`, `password`, `email`, `town`, `postcode`, `gender`, `registered_date`, `registered_time`, `tweaks`, `reviews`, `cooking_tips_ratings`, `recipe_ratings`, `books`, `website`, `blog`, `login_date`, `login_time`, `avatar_file_location`) VALUES ('Sean' ,'Hardaker' ,'slh' ,'6i7ilian' ,'seanhardaker@gmail.com' ,'Swindon' ,'SN22BZ' ,'M' ,'2010-02-25' ,'01:02:03' ,0 ,0 ,0 ,0 ,0 ,'http://www.seanhardaker.co.uk' ,'http://www.seanhardaker.co.uk' , '2010-02-25' ,'01:02:03' ,'/avatar/slh/avatar.jpg');
INSERT INTO `recipes`(`name`,`description`,`servings`,`makes_qty`,`makes`,`prep_time`,`cooking_time`,`extra_time`,`footnotes`,`extra_time_action`,`date`,`time`,`recipe_difficulty_id`,`recipe_method_id`,`user_id`,`recipe_rating_id`,`recipe_footnote_id`) VALUES('Ultimate Fairy Cakes','Quick & easy fairy cakes','24','','','00:20:00','00:45:00','00:00:00','','','2010-02-25','17:10:15',1,1,1,0,0);

INSERT INTO `Recipe_Difficulty` (`name`, `fun_name`, `description`) VALUES ('Easy' ,'Junior Shef' ,'No advanced techniques required');
INSERT INTO `Recipe_Difficulty` (`name`, `fun_name`, `description`) VALUES ('Medium' ,'Star Shef' ,'Some advanced techniques required');
INSERT INTO `Recipe_Difficulty` (`name`, `fun_name`, `description`) VALUES ('Hard' ,'Master Shef' ,'Advanced techniques required');

INSERT INTO `Recipe_Categories` (`name`) VALUES ( 'Main Ingredients');
INSERT INTO `Recipe_Categories` (`name`) VALUES ( 'Recipe Type');
INSERT INTO `Recipe_Categories` (`name`) VALUES ( 'Cook/Prep Method');
INSERT INTO `Recipe_Categories` (`name`) VALUES ( 'Cuisine');
INSERT INTO `Recipe_Categories` (`name`) VALUES ( 'Occasions');
INSERT INTO `Recipe_Categories` (`name`) VALUES ( 'Special Diets');

INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Beans' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Beef' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Cheese' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Chicken' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Chocolate' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Dairy' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Duck' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Egg' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Fish' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Grain' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Herb and spice' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Lamb' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Nut and seed' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Offal' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Other' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Pasta' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Pork' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Rice' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Seafood' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Tofu' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Turkey' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Vegetable' ,1);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Biscuit' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Bread' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Breakfast' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Budget' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Cake' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Chutney' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Cocktail' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Curry' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Dessert' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Dinner' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Drink' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Gourmet' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Jam' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Lunch' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Main' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Muffins' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Pickle and dressing' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Pie' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Salad' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Sandwiches' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Sauce' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Starters' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Stew' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Sweets' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Vegetarian' ,2);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Bake' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'BBQ' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Boil' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Braised' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Bread machine' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Deep fry' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Freeze or chill' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Grill' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Ice cream maker' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Marinate' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Microwave' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'No cook' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Pan fry' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Poach' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Pressure cooker' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Roast' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Saute' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Simmer' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Slow cooker' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Smoked' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Steam' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Stir fry' ,3);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'African' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'American' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Asian' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Australian' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'New Zealand' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'British' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Caribbean' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Chinese' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Eastern European' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'French' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'German' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Greek' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Indian' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Irish' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Italian' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Japanese' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Jewish' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Latin American' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Mexican' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Middle Eastern' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Other Cuisines' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Polish' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Portuguese' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Scandinavian' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Scottish' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Spanish' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Thai' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Turkish' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Welsh' ,4);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Birthday' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Bonfire Night' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Boxing Day' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Burns Night' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Chinese New Year' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Christmas' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Dinner party' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Diwali' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Easter' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Father\'s Day' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Halloween' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Hogmanay' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Mother\'s Day' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'New Year' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Pancake Day' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Passover' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Picnic food' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'St Andrew\'s Day' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'St David\'s Day' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'St George\'s Day' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'St Patrick\'s Day' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Sunday lunch' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Valentine\'s Day' ,5);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Dairy free' ,6);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Diabetic' ,6);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Egg free' ,6);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Gluten free' ,6);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Healthy' ,6);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Kids recipes' ,6);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Nut free' ,6);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Pregnant or nursing mums' ,6);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Vegan' ,6);
INSERT INTO `Recipe_Sub_Categories` (`value`, `recipe_category_id`) VALUES ( 'Beans' ,6);

insert into ingredients (name) values ('Plain flour');
insert into ingredients (name) values ('Self raising flour');
insert into ingredients (name) values ('Mashed bananas');
insert into ingredients (name) values ('Caster sugar');
insert into ingredients (name) values ('Eggs');
insert into ingredients (name) values ('Water');
insert into ingredients (name) values ('Milk');
insert into ingredients (name) values ('Tomatoes');
insert into ingredients (name) values ('Chopped Tomatoes');
insert into ingredients (name) values ('Icing sugar');

insert into recipe_extra_time (extra_time_action) values ('Cooling');
insert into recipe_extra_time (extra_time_action) values ('Chiling');
insert into recipe_extra_time (extra_time_action) values ('Curing');
insert into recipe_extra_time (extra_time_action) values ('Drying');
insert into recipe_extra_time (extra_time_action) values ('Freezing');
insert into recipe_extra_time (extra_time_action) values ('Marinating');
insert into recipe_extra_time (extra_time_action) values ('Proofing');
insert into recipe_extra_time (extra_time_action) values ('Pickling');
insert into recipe_extra_time (extra_time_action) values ('Preserving');
insert into recipe_extra_time (extra_time_action) values ('Resting');
insert into recipe_extra_time (extra_time_action) values ('Rising');
insert into recipe_extra_time (extra_time_action) values ('Setting');
insert into recipe_extra_time (extra_time_action) values ('Soaking');

insert into recipe_footnotes_description (footnote_description) values ('Tip');
insert into recipe_footnotes_description (footnote_description) values ('Freezing tip');
insert into recipe_footnotes_description (footnote_description) values ('Shortcut');
insert into recipe_footnotes_description (footnote_description) values ('Serving suggestion');
insert into recipe_footnotes_description (footnote_description) values ('Substitution');
insert into recipe_footnotes_description (footnote_description) values ('Make ahead');
insert into recipe_footnotes_description (footnote_description) values ('Make it healthier');
insert into recipe_footnotes_description (footnote_description) values ('Use for leftovers');
insert into recipe_footnotes_description (footnote_description) values ('Drink pairing');
insert into recipe_footnotes_description (footnote_description) values ('Other ideas');


insert into recipe_rating (rating, name, fun_name) values ('10', 'Ten', 'Awesome');
insert into recipe_rating (rating, name, fun_name) values ('9', 'Nine', 'Very Good');
insert into recipe_rating (rating, name, fun_name) values ('8', 'Eight', 'Good');
insert into recipe_rating (rating, name, fun_name) values ('7', 'Seven', 'Very Nice');
insert into recipe_rating (rating, name, fun_name) values ('6', 'Six', 'Nice');
insert into recipe_rating (rating, name, fun_name) values ('5', 'Five', 'OK');
insert into recipe_rating (rating, name, fun_name) values ('4', 'Four', 'Not Bad');
insert into recipe_rating (rating, name, fun_name) values ('3', 'Three', 'Not Great');
insert into recipe_rating (rating, name, fun_name) values ('2', 'Two', 'Poor');
insert into recipe_rating (rating, name, fun_name) values ('1', 'One', 'Urgh');
insert into recipe_rating (rating, name, fun_name) values ('0', 'Zero', 'Unrated');
