forked from Apostolos24/Database-Semester-Project
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDML.sql
More file actions
8149 lines (6986 loc) · 477 KB
/
DML.sql
File metadata and controls
8149 lines (6986 loc) · 477 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
USE cooking_show;
-- Empties the base by deleting all rows from all tables before the insertions happens.
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE cook;
TRUNCATE TABLE countries;
TRUNCATE TABLE episodes;
TRUNCATE TABLE equipment;
TRUNCATE TABLE expertise;
TRUNCATE TABLE food_groups;
TRUNCATE TABLE ingredients;
TRUNCATE TABLE is_a_contestant;
TRUNCATE TABLE is_a_critic;
TRUNCATE TABLE main_ingr;
TRUNCATE TABLE meal_type;
TRUNCATE TABLE recipe_belongs_to;
TRUNCATE TABLE recipe_steps;
TRUNCATE TABLE recipes;
TRUNCATE TABLE requires_eq;
TRUNCATE TABLE requires_ingr;
TRUNCATE TABLE tags;
TRUNCATE TABLE thematic_section;
SET FOREIGN_KEY_CHECKS = 1;
--
-- Insertions
INSERT INTO countries (country_name) VALUES
('Brazil'),
('Norway'),
('Japan'),
('Australia'),
('Mexico'),
('Germany'),
('Thailand'),
('Canada'),
('India'),
('Egypt'),
('Argetina'),
('Sweden'),
('Turkey'),
('Italy'),
('Russia'),
('Kenya'),
('France'),
('Saudi Arabia'),
('South Korea'),
('Spain'),
('Vietnam'),
('Netherlands'),
('Malta'),
('Peru'),
-- ('Switzerland'),
('Iran'),
('Indonesia'),
('Poland'),
('Nigeria'),
('United Kingdom'),
-- ('Philippines'),
-- ('Colombia'),
('Greece'),
-- ('Ukraine'),
('Chile'),
-- ('Malaysia'),
-- ('Israel'),
-- ('Belgium'),
('Portugal'),
('Pakistan'),
('Czech Republic'),
-- ('Austria'),
('Venezuela'),
('Hungary'),
('Bangladesh'),
-- ('Singapore'),
('Denmark'),
-- ('Finland'),
('United Arab Emirates'),
('China'),
('Ireland'),
-- ('New Zealand'),
('Morocco'),
-- ('Romania'),
-- ('Algeria'),
('Iraq'),
-- ('Ecuador'),
-- ('Qatar'),
('Kuwait'),
-- ('Oman'),
('Jamaica'),
('United States');
-- ('Bolivia');
INSERT INTO thematic_section (sec_name, sec_desc) VALUES
('Christmas', 'Recipes perfect for the holiday season.'),
('Seafood', 'Delicious dishes featuring various types of seafood.'),
('Vegetarian', 'Recipes suitable for vegetarians, with no meat or fish.'),
('Quick and Easy', 'Simple and fast recipes for busy days.'),
('Healthy Choices', 'Nutritious recipes that are good for your body.'),
('Comfort Food', 'Classic dishes that bring warmth and comfort.'),
('Grilling and BBQ', 'Recipes for outdoor cooking and barbecuing.'),
('Desserts and Sweeteners', 'Indulgent treats and desserts to satisfy your sweet tooth.'),
('Family Favorites', 'Recipes loved by both kids and adults.'),
('Gluten-Free', 'Recipes free from gluten, suitable for those with gluten sensitivities.'),
('Vegan Delights', 'Plant-based recipes free from animal products.'),
('Soup and Stew', 'Warm and comforting soups and stews for any occasion.'),
('Baking Adventures', 'Explore the world of baking with these delightful recipes.'),
('Budget-Friendly', 'Affordable recipes without sacrificing flavor.'),
('Brunch Ideas', 'Recipes perfect for a leisurely brunch with friends and family.'),
('Summer BBQ', 'Grilled dishes and sides perfect for summertime gatherings.'),
('Game Day Snacks', 'Snack ideas for watching sports or hosting game day parties.'),
('Picnic Treats', 'Portable and tasty dishes perfect for a picnic outdoors.'),
('Slow Cooker Favorites', 'Set it and forget it with these delicious slow cooker recipes.'),
('Date Night Dinners', 'Romantic recipes for a special evening at home.');
-- INSERT INTO recipe_belongs_to (recipe, them_sec) VALUES ('Spaghetti Carbonara', 'Christmas');
INSERT INTO equipment (eq_name, eq_instructions, eq_photo, eq_photo_desc) VALUES
('Pasta Machine','Used for making homemade pasta','https://www.kitchenstuffplus.com/media/catalog/product/7/2/72255_Marcato_Manual_Pasta_Machine__Chrome.jpg?width=2000&height=&canvas=2000:&optimize=high&fit=bounds','Photo of a pasta machine'),
('Potato Masher','Used for mashing potatoes','https://ae01.alicdn.com/kf/HTB1ahgfXJfvK1RjSspoq6zfNpXaG/New-Potato-Masher-Stainless-Steel-Mashed-Potato-Masher-Garlic-masher-Crush-Kitchen-Tool-Black-Handle-With.jpg','Photo of a potato masher'),
('Muffin tin','Used for making muffins','https://www.cooksinfo.com/wp-content/uploads/Muffin-tins-empty.jpg','Photo of muffin tin'),
('Pizza cutter','Used for cutting pizza','https://www.pennstateind.com/graphics/1600px/PKPCUTA.jpg','Photo of pizza cutter'),
('Pizza stone','Used for cooking pizza','https://i.pinimg.com/736x/47/fc/19/47fc19e53afb98ae9cb747d0c898742e.jpg','Photo of pizza stone oven'),
('Spatula','Used for grabbing flat objects from a hot surface','http://www.wowline.com/Images/ProductImages/Large/S70798X.jpg','Photo of a spatula'),
('Grill','Used for cooking','https://i5.walmartimages.com/asr/6eb517d3-b28b-4215-a79e-39be1dacfcc4_1.f008fc0c530756d8b71f7e065df18e17.jpeg','A photo of a grill'),
('Knife','Used for cutting ingredients','https://exquisiteknives.com/wp-content/uploads/2017/04/20160216_1936.jpg','Photo of knife'),
('Blender','Used for mixing ingredients','http://www.italia76.com/wp-content/uploads/2013/12/rossowolf-blender-black-frullatore-nero.png','Photo of a blender'),
('Immersion Blender','Used for melting and mixing','https://digital.hammacher.com/Items/74962/74962_1000x1000.jpg','Photo of an immersion blender'),
('Mixing Bowl', 'Use for mixing ingredients together.', 'https://example.com/mixing-bowl.jpg', 'A photo of a mixing bowl.'),
('Bowl','Used for pouring ingredients to it','https://s7d2.scene7.com/is/image/DesignWithinReach/PD_623_SIZE_medium_COLOR_red?$main$','Photo of a bowl'),
('Glass Bowls','Used for pouring ingredients and mixing them','https://www.barnitts.co.uk/images/shop/more/2500x1816_1534428629TC380JudgeKitchenGlassBowl1L.jpg','Photo of a glass bowl'),
("Chef's Knife", 'Use for chopping, slicing, and dicing ingredients.', 'https://example.com/chefs-knife.jpg', "A photo of a chef's knife."),
('Cutting Board', 'Use as a surface for cutting and chopping ingredients.', 'https://example.com/cutting-board.jpg', 'A photo of a cutting board.'),
('Saucepan', 'Use for heating sauces, soups, and liquids.', 'https://example.com/saucepan.jpg', 'A photo of a saucepan.'),
('Skillet', 'Use for frying, searing, and sautéing ingredients.', 'https://example.com/skillet.jpg', 'A photo of a skillet.'),
('Baking Sheet', 'Use for baking cookies, pastries, and other baked goods.', 'https://example.com/baking-sheet.jpg', 'A photo of a baking sheet.'),
('Baking dish','Used for placing food in the oven','https://www.seriouseats.com/thmb/Cv9-oIKmooq3u9Q9A1uXRgiqoOY=/1500x1125/filters:no_upscale():max_bytes(150000):strip_icc()/__opt__aboutcom__coeus__resources__content_migration__serious_eats__seriouseats.com__2017__12__20171206-baking-dish-tests-vicky-wasik-staub-1500x1125-b1cf737fed66429da539272109706b47.jpg','Photo of a baking dish'),
('Whisk', 'Use for mixing ingredients together and incorporating air into batters and sauces.', 'https://example.com/whisk.jpg', 'A photo of a whisk.'),
('Measuring Cups', 'Use for accurately measuring dry and liquid ingredients.', 'https://example.com/measuring-cups.jpg', 'A photo of measuring cups.'),
('Measuring Spoons', 'Use for accurately measuring small amounts of ingredients.', 'https://example.com/measuring-spoons.jpg', 'A photo of measuring spoons.'),
('Mixing Spoon', 'Use for stirring and mixing ingredients in pots and pans.', 'https://example.com/mixing-spoon.jpg', 'A photo of a mixing spoon.'),
('Tongs', 'Use for flipping, turning, and serving foods.', 'https://example.com/tongs.jpg', 'A photo of tongs.'),
('Rolling Pin', 'Use for rolling out dough for pies, pastries, and breads.', 'https://example.com/rolling-pin.jpg', 'A photo of a rolling pin.'),
('Grater', 'Use for grating cheese, vegetables, and other ingredients.', 'https://example.com/grater.jpg', 'A photo of a grater.'),
('Strainer', 'Use for draining liquids from cooked foods or rinsing fruits and vegetables.', 'https://example.com/strainer.jpg', 'A photo of a strainer.'),
('Mixing Bowls Set', 'A set of bowls for mixing various ingredients at once.', 'https://example.com/mixing-bowls-set.jpg', 'A photo of a set of mixing bowls.'),
('Pot', 'Use for boiling, simmering, and cooking soups, stews, and pasta.', 'https://example.com/pot.jpg', 'A photo of a pot.'),
('Mug','Used for storing liquids','https://images-na.ssl-images-amazon.com/images/I/71S8zUoBskL._AC_SL1500_.jpg','Photo of a mug'),
('Colander', 'Use for draining pasta, washing vegetables, and straining liquids.', 'https://example.com/colander.jpg', 'A photo of a colander.'),
('Pastry Brush', 'Use for applying egg washes, glazes, and sauces to pastries.', 'https://www.kitchenstuffplus.com/media/catalog/product/9/3/93312_KSP_Colour_Splash_Silicone_Pastry_Basting_Brush__Red.jpg?width=2000&height=&canvas=2000:&optimize=high&fit=bounds', 'A photo of a pastry brush.'),
('Oven','Used for cooking','https://www.viewclickbuy.co.uk/product/beko-bbaif22300x-66l-electric-built-in-single-oven-stainless-steel/image246850060.jpg','Photo of oven'),
('Oven Mitts', 'Use for handling hot dishes and pans.', 'https://example.com/oven-mitts.jpg', 'A photo of oven mitts.'),
('Slotted Spoon','Useful for grabbing food without any liquid','http://kitchenkneads.com/wp-content/uploads/2017/04/43693-12-ss-slotted-spoon.png','Photo of a slotted spoon'),
('Pastry cutter','Used for giving shapes to sweets','https://cf.shopee.ph/file/31795b73b485d9a62acc3787df396e6e','Photo of pastry cutter'),
('Zester','Used for peeling fruits','https://www.foodchamps.org/wp-content/uploads/2020/10/Deiss-PRO-Citrus-Lemon-Zester-958x1024.jpg','Photo of a zester'),
('Round Cake Pans','Used for putting cakes of different sizes','https://i5.walmartimages.com/asr/9d912d8c-540b-4f44-8f76-de360591ca05_2.12b9716dd00d7d6d6ef522f9797eaf33.jpeg','Photo of round cake pans'),
('Cooling Rack','Useful for letting food cool','https://i5.walmartimages.com/asr/b451049b-f979-420c-a763-c8964b67da95_1.1d90083616c6e31e6adf834859c6b63a.jpeg','Photo of a cooling rack'),
('Waffle Iron','Used for making waffles','https://www.brylanehome.com/on/demandware.static/-/Sites-masterCatalog_BrylaneHome/default/dw2bc5625e/images/hi-res/1550_16900_mc_8844.jpg','Photo of a waffle iron'),
('Kitchen Timer', 'Use for timing cooking and baking processes.', 'https://example.com/kitchen-timer.jpg', 'A photo of a kitchen timer.');
INSERT INTO food_groups (group_name, group_desc, recipe_characterisation)
VALUES
('Herbs and Essential Oils', 'Includes various herbs and essential oils.', 'Herbal'),
('Coffee, Tea, and Their Products', 'Includes coffee, tea, and related products.', 'Caffeinated'),
('Preserved Foods', 'Includes various preserved foods.', 'Preserved'),
('Sweeteners', 'Includes various sweetening agents.', 'Sweet'),
('Fats and Oils', 'Includes various fats and oils.', 'Rich'),
('Milk, Eggs, and Their Products', 'Includes dairy products like milk and eggs.', 'Creamy'),
('Meat and Meat Products', 'Includes various types of meat.', 'Meaty'),
('Fish and Fish Products', 'Includes various types of fish and seafood.', 'Fishy'),
('Cereals and Cereal Products', 'Includes various grains and cereal products.', 'Grainy'),
('Various Plant-based Foods', 'Includes various plant-based foods.', 'Vegetarian'),
('Products with Sweeteners', 'Includes products with added sweeteners.', 'Sweetened'),
('Various Beverages', 'Includes various types of beverages.', 'Refreshing'),
('Legumes and Legume Products','Includes beans, peas etc','Legumy'),
('Others', 'Anything else','Other');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Chocolate Chip Cookies', 'Pastry', 2, 'These chocolate chip cookies are soft, chewy, and loaded with gooey chocolate chips. They are perfect for satisfying your sweet tooth and are sure to become a favorite.', 'Make sure to chill the dough for at least 30 minutes before baking to prevent spreading.', 'You can use a combination of milk and dark chocolate chips for extra flavor.', 'Serve warm with a glass of milk for a classic treat.', 5.0, 30.0, 20.0, 'France', 'http://fakephotolink.com/chocolate_chip_cookies.jpg', 'Chocolate Chip Cookies loaded with chocolate chips', 20, 25, 2);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Chocolate Chip Cookies', 'Mixing Bowl', 1),
('Chocolate Chip Cookies', 'Baking Sheet', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('Butter', 102.0, 0, 'Milk, Eggs, and Their Products', 'gr'),
('Brown Sugar', 380.0, 1, 'Sweeteners', 'gr'),
('Granulated Sugar', 387.0, 1, 'Sweeteners', 'gr'),
('Egg', 72.0, 0, 'Milk, Eggs, and Their Products', 'unit'),
('Vanilla Extract', 288.0, 0, 'Milk, Eggs, and Their Products', 'ml'),
('All-Purpose Flour', 364.0, 0, 'Cereals and Cereal Products', 'gr'),
('Baking Soda', 0.0, 0, 'Others', 'gr'),
('Salt', 0.0, 0, 'Others', 'gr'),
('Chocolate Chips', 535.0, 1, 'Products with Sweeteners', 'gr');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('Chocolate Chip Cookies', 'Butter', 113, NULL),
('Chocolate Chip Cookies', 'Brown Sugar', NULL, 'Some'),
('Chocolate Chip Cookies', 'Granulated Sugar', NULL, 'Some'),
('Chocolate Chip Cookies', 'Egg', 1, NULL),
('Chocolate Chip Cookies', 'Vanilla Extract', 5, NULL),
('Chocolate Chip Cookies', 'All-Purpose Flour', NULL, 'Some'),
('Chocolate Chip Cookies', 'Baking Soda', 1, NULL),
('Chocolate Chip Cookies', 'Salt', 2, NULL),
('Chocolate Chip Cookies', 'Chocolate Chips', NULL, 'A lot');
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('Chocolate Chip Cookies', 'Chocolate Chips');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('Chocolate Chip Cookies', 'Preheat the oven to 375°F (190°C). Line a baking sheet with parchment paper.', 1),
('Chocolate Chip Cookies', 'In a large mixing bowl, cream together the butter, brown sugar, and granulated sugar until light and fluffy.', 2),
('Chocolate Chip Cookies', 'Beat in the egg and vanilla extract until well combined.', 3),
('Chocolate Chip Cookies', 'In a separate bowl, whisk together the all-purpose flour, baking soda, and salt.', 4),
('Chocolate Chip Cookies', 'Gradually add the dry ingredients to the wet ingredients, mixing until just combined.', 5),
('Chocolate Chip Cookies', 'Fold in the chocolate chips.', 6),
('Chocolate Chip Cookies', 'Scoop tablespoon-sized portions of dough onto the prepared baking sheet.', 7),
('Chocolate Chip Cookies', 'Bake for 8-10 minutes, or until the edges are lightly golden.', 8),
('Chocolate Chip Cookies', 'Allow the cookies to cool on the baking sheet for 5 minutes before transferring to a wire rack to cool completely.', 9);
INSERT INTO tags (recipe_name, tag_name) VALUES
('Chocolate Chip Cookies', 'Homemade'),
('Chocolate Chip Cookies', 'Classic'),
('Chocolate Chip Cookies', 'Family Recipe');
INSERT INTO meal_type (recipe_name,meal) VALUES
('Chocolate Chip Cookies', 'Dessert'),
('Chocolate Chip Cookies', 'Snack');
#
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Jerk Chicken', 'Cooking', 3, "This Jerk Chicken recipe is packed with bold flavors and spices. It's marinated in a spicy and aromatic jerk sauce, then grilled to perfection. Serve with rice and peas for a delicious Caribbean-inspired meal.", 'For an authentic taste, marinate the chicken overnight to allow the flavors to develop fully.', 'Adjust the amount of Scotch bonnet peppers based on your spice preference. Use less for a milder flavor or more for extra heat.', 'Serve with traditional sides like rice and peas, fried plantains, and coleslaw for a complete meal.', 25.0, 10.0, 15.0, 'Jamaica', 'http://fakephotolink.com/jerk_chicken.jpg', 'Jerk Chicken with rice and peas', 20, 30, 3);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Jerk Chicken', 'Mixing Bowl', 1),
('Jerk Chicken', 'Grill', 1),
('Jerk Chicken', 'Blender', 1),
('Jerk Chicken', 'Measuring Spoons', 1),
('Jerk Chicken', 'Knife', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('Chicken Thighs', 245.0, 0, 'Meat and Meat Products', 'gr'),
('Scotch Bonnet Peppers', 30.0, 1, 'Herbs and Essential Oils', 'unit'),
('Green Onions', 32.0, 0, 'Herbs and Essential Oils', 'unit'),
('Thyme', 5.0, 0, 'Herbs and Essential Oils', 'gr'),
('Garlic', 4.0, 0, 'Herbs and Essential Oils', 'unit'),
('Ginger', 80.0, 0, 'Herbs and Essential Oils', 'gr'),
('Allspice', 263.0, 0, 'Herbs and Essential Oils', 'gr'),
('Black Pepper', 255.0, 0, 'Herbs and Essential Oils', 'gr'),
('Soy Sauce', 61.0, 0, 'Various Plant-based Foods', 'ml'),
('Vinegar', 18.0, 0, 'Various Plant-based Foods', 'ml');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('Jerk Chicken', 'Chicken Thighs', 800, NULL),
('Jerk Chicken', 'Scotch Bonnet Peppers', 2, NULL),
('Jerk Chicken', 'Green Onions', 4, NULL),
('Jerk Chicken', 'Thyme', 5, NULL),
('Jerk Chicken', 'Garlic', 4, NULL),
('Jerk Chicken', 'Ginger', 20, NULL),
('Jerk Chicken', 'Allspice', 10, NULL),
('Jerk Chicken', 'Black Pepper', 5, NULL),
('Jerk Chicken', 'Brown Sugar', 30, NULL),
('Jerk Chicken', 'Soy Sauce', 30, NULL),
('Jerk Chicken', 'Vinegar', 15, NULL);
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('Jerk Chicken', 'Chicken Thighs');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('Jerk Chicken', 'In a blender, combine the Scotch bonnet peppers, green onions, thyme, garlic, ginger, allspice, black pepper, brown sugar, soy sauce, and vinegar. Blend until smooth to make the jerk marinade.', 1),
('Jerk Chicken', 'Place the chicken thighs in a mixing bowl and pour the jerk marinade over them. Rub the marinade into the chicken until evenly coated. Cover and refrigerate for at least 4 hours, or preferably overnight.', 2),
('Jerk Chicken', 'Preheat the grill to medium-high heat. Remove the chicken from the marinade and grill for 6-7 minutes per side, or until fully cooked and slightly charred.', 3),
('Jerk Chicken', 'Serve the jerk chicken hot with rice and peas, fried plantains, and coleslaw.', 4);
INSERT INTO tags (recipe_name, tag_name) VALUES
('Jerk Chicken', 'Spicy'),
('Jerk Chicken', 'Grilled'),
('Jerk Chicken', 'Caribbean');
INSERT INTO meal_type (recipe_name, meal) VALUES
('Jerk Chicken', 'Main Course'),
('Jerk Chicken', 'Dinner');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Pasta Salad', 'Cooking', 2, "This Pasta Salad recipe is light, refreshing, and perfect for summer gatherings. It's made with cooked pasta, fresh vegetables, and a zesty vinaigrette dressing.", 'Cook the pasta until al dente for the best texture in the salad.', 'You can customize the vegetables based on your preferences. Try adding cherry tomatoes, bell peppers, or cucumbers.', 'For extra flavor, add some chopped fresh herbs like basil, parsley, or dill.', 5.0, 30.0, 15.0, 'Italy', 'http://fakephotolink.com/pasta_salad.jpg', 'Pasta Salad with fresh vegetables', 15, 20, 6);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Pasta Salad', 'Mixing Bowl', 1),
('Pasta Salad', 'Pot', 1),
('Pasta Salad', 'Strainer', 1),
('Pasta Salad', 'Knife', 1),
('Pasta Salad', 'Cutting Board', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('Pasta', 131.0, 0, 'Cereals and Cereal Products', 'gr'),
('Cherry Tomatoes', 18.0, 1, 'Various Plant-based Foods', 'unit'),
('Cucumber', 16.0, 1, 'Various Plant-based Foods', 'unit'),
('Red Onion', 40.0, 0, 'Various Plant-based Foods', 'gr'),
('Black Olives', 115.0, 1, 'Various Plant-based Foods', 'gr'),
('Feta Cheese', 264.0, 0, 'Milk, Eggs, and Their Products', 'gr'),
('Olive Oil', 884.0, 0, 'Fats and Oils', 'ml'),
('Red Wine Vinegar', 3.0, 0, 'Various Plant-based Foods', 'ml'),
('Dijon Mustard', 66.0, 0, 'Various Plant-based Foods', 'ml'),
('Honey', 304.0, 0, 'Sweeteners', 'ml');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('Pasta Salad', 'Pasta', 200, NULL),
('Pasta Salad', 'Cherry Tomatoes', 200, NULL),
('Pasta Salad', 'Cucumber', 150, NULL),
('Pasta Salad', 'Red Onion', 100, NULL),
('Pasta Salad', 'Black Olives', 100, NULL),
('Pasta Salad', 'Feta Cheese', 150, NULL),
('Pasta Salad', 'Olive Oil', 30, NULL),
('Pasta Salad', 'Red Wine Vinegar', 15, NULL),
('Pasta Salad', 'Dijon Mustard', 10, NULL),
('Pasta Salad', 'Honey', 10, NULL),
('Pasta Salad', 'Salt', NULL, 'Some'),
('Pasta Salad', 'Black Pepper', NULL, 'Some');
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('Pasta Salad', 'Pasta');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('Pasta Salad', 'Cook the pasta according to package instructions. Drain and rinse under cold water.', 1),
('Pasta Salad', 'In a mixing bowl, combine the cooked pasta, cherry tomatoes (halved), cucumber (sliced), red onion (thinly sliced), black olives (halved), and crumbled feta cheese.', 2),
('Pasta Salad', 'In a small bowl, whisk together the olive oil, red wine vinegar, Dijon mustard, honey, salt, and black pepper to make the dressing.', 3),
('Pasta Salad', 'Pour the dressing over the pasta and vegetables. Toss until everything is well coated.', 4),
('Pasta Salad', 'Cover and refrigerate for at least 1 hour to allow the flavors to meld together.', 5),
('Pasta Salad', 'Before serving, give the salad a final toss and adjust seasoning if necessary.', 6);
INSERT INTO tags (recipe_name, tag_name) VALUES
('Pasta Salad', 'Refreshing'),
('Pasta Salad', 'Summer'),
('Pasta Salad', 'Salad');
INSERT INTO meal_type (recipe_name, meal) VALUES
('Pasta Salad', 'Side Dish'),
('Pasta Salad', 'Lunch');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Lasagna', 'Cooking', 3, 'This classic Lasagna recipe features layers of tender pasta, rich meat sauce, creamy béchamel, and melted cheese. It\'s a comforting and hearty dish that\'s perfect for family dinners.', 'Cook the lasagna noodles until al dente to prevent them from becoming mushy in the oven.', 'Let the lasagna rest for at least 10 minutes after baking to allow it to set before slicing.', 'You can prepare the meat sauce and béchamel ahead of time for easier assembly.', 35.0, 60.0, 40.0, 'Italy', 'http://fakephotolink.com/lasagna.jpg', 'Homemade Lasagna with layers of pasta, meat sauce, and cheese', 30, 60, 2);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Lasagna', 'Mixing Bowl', 1),
('Lasagna', 'Saucepan', 1),
('Lasagna', 'Skillet', 1),
('Lasagna', 'Baking Dish', 1),
('Lasagna', 'Oven', 1),
('Lasagna', 'Knife', 1),
('Lasagna', 'Cutting Board', 1),
('Lasagna', 'Grater', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('Lasagna Noodles', 131.0, 0, 'Cereals and Cereal Products', 'gr'),
('Ground Beef', 250.0, 0, 'Meat and Meat Products', 'gr'),
('Onion', 40.0, 0, 'Various Plant-based Foods', 'gr'),
('Tomato Paste', 82.0, 0, 'Various Plant-based Foods', 'gr'),
('Crushed Tomatoes', 32.0, 0, 'Various Plant-based Foods', 'ml'),
('Sugar', 387.0, 0, 'Sweeteners', 'gr'),
('Dried Oregano', 306.0, 0, 'Herbs and Essential Oils', 'gr'),
('Milk', 42.0, 0, 'Milk, Eggs, and Their Products', 'ml'),
('Nutmeg', 525.0, 0, 'Herbs and Essential Oils', 'gr'),
('Mozzarella Cheese', 280.0, 0, 'Milk, Eggs, and Their Products', 'gr'),
('Parmesan Cheese', 431.0, 0, 'Milk, Eggs, and Their Products', 'gr');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('Lasagna', 'Lasagna Noodles', 250, NULL),
('Lasagna', 'Ground Beef', 500, NULL),
('Lasagna', 'Onion', 1, NULL),
('Lasagna', 'Garlic', 2, NULL),
('Lasagna', 'Tomato Paste', 30, NULL),
('Lasagna', 'Crushed Tomatoes', 400, NULL),
('Lasagna', 'Sugar', 15, NULL),
('Lasagna', 'Dried Oregano', 5, NULL),
('Lasagna', 'Salt', NULL, 'Some'),
('Lasagna', 'Black Pepper', NULL, 'Some'),
('Lasagna', 'Butter', 30, NULL),
('Lasagna', 'All-Purpose Flour', 30, NULL),
('Lasagna', 'Milk', 500, NULL),
('Lasagna', 'Nutmeg', 5, NULL),
('Lasagna', 'Mozzarella Cheese', 200, NULL),
('Lasagna', 'Parmesan Cheese', 100, NULL);
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('Lasagna', 'Lasagna Noodles');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('Lasagna', 'Preheat the oven to 375°F (190°C).', 1),
('Lasagna', 'Cook the lasagna noodles according to package instructions. Drain and set aside.', 2),
('Lasagna', 'In a skillet, cook the ground beef over medium heat until browned. Add chopped onion and minced garlic, and cook until softened.', 3),
('Lasagna', 'Stir in the tomato paste, crushed tomatoes, sugar, dried oregano, salt, and black pepper. Simmer for 10-15 minutes.', 4),
('Lasagna', 'In a saucepan, melt butter over medium heat. Stir in flour and cook for 1-2 minutes. Gradually whisk in milk until smooth.', 5),
('Lasagna', 'Cook the sauce until thickened, then add nutmeg and season with salt and pepper to taste.', 6),
('Lasagna', 'Spread a thin layer of meat sauce in the bottom of a baking dish. Arrange a layer of cooked lasagna noodles on top.', 7),
('Lasagna', 'Spread a layer of béchamel sauce over the noodles, then sprinkle with mozzarella and Parmesan cheese.', 8),
('Lasagna', 'Repeat the layers until all ingredients are used, ending with a layer of cheese on top.', 9),
('Lasagna', 'Cover the baking dish with foil and bake in the preheated oven for 30 minutes.', 10),
('Lasagna', 'Remove the foil and bake for an additional 10-15 minutes, or until the cheese is golden and bubbly.', 11),
('Lasagna', 'Let the lasagna rest for 10 minutes before slicing and serving.', 12);
INSERT INTO tags (recipe_name, tag_name) VALUES
('Lasagna', 'Comfort Food'),
('Lasagna', 'Italian'),
('Lasagna', 'Dinner');
INSERT INTO meal_type (recipe_name, meal) VALUES
('Lasagna', 'Main Dish'),
('Lasagna', 'Dinner');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Hearty Pancakes', 'Pastry', 2, 'These hearty pancakes are fluffy, flavorful, and perfect for a satisfying breakfast or brunch. They are made with whole wheat flour, oats, and bananas for added nutrition and sweetness.', 'For extra indulgence, serve with a drizzle of maple syrup and a dollop of Greek yogurt.', 'You can customize these pancakes by adding your favorite toppings such as berries, nuts, or chocolate chips.', 'Leftover pancakes can be stored in an airtight container in the refrigerator and reheated in the toaster or microwave.', 5.0, 15.0, 10.0, 'United States', 'http://fakephotolink.com/hearty_pancakes.jpg', 'Hearty Pancakes with bananas and maple syrup', 10, 15, 1);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Hearty Pancakes', 'Mixing Bowl', 1),
('Hearty Pancakes', 'Skillet', 1),
('Hearty Pancakes', 'Spatula', 1),
('Hearty Pancakes', 'Measuring Cups', 1),
('Hearty Pancakes', 'Measuring Spoons', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('Whole Wheat Flour', 364.0, 0, 'Cereals and Cereal Products', 'gr'),
('Oats', 389.0, 0, 'Cereals and Cereal Products', 'gr'),
('Baking Powder', 2.0, 0, 'Others', 'tsp'),
('Banana', 105.0, 0, 'Various Plant-based Foods', 'gr'),
('Maple Syrup', 52.0, 0, 'Sweeteners', 'ml');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('Hearty Pancakes', 'Whole Wheat Flour', 150, NULL),
('Hearty Pancakes', 'Oats', 50, NULL),
('Hearty Pancakes', 'Baking Powder', 2, NULL),
('Hearty Pancakes', 'Salt', 1, NULL),
('Hearty Pancakes', 'Banana', 1, NULL),
('Hearty Pancakes', 'Egg', 1, NULL),
('Hearty Pancakes', 'Milk', 240, NULL),
('Hearty Pancakes', 'Butter', 30, NULL),
('Hearty Pancakes', 'Maple Syrup', NULL, 'Some');
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('Hearty Pancakes', 'Whole Wheat Flour');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('Hearty Pancakes', 'In a mixing bowl, combine the whole wheat flour, oats, baking powder, and salt.', 1),
('Hearty Pancakes', 'Mash the banana in a separate bowl and whisk in the egg, milk, and melted butter.', 2),
('Hearty Pancakes', 'Pour the wet ingredients into the dry ingredients and stir until just combined.', 3),
('Hearty Pancakes', 'Heat a skillet over medium heat and lightly grease with butter or oil.', 4),
('Hearty Pancakes', 'Pour 1/4 cups of batter onto the skillet for each pancake.', 5),
('Hearty Pancakes', 'Cook until bubbles form on the surface, then flip and cook until golden brown.', 6),
('Hearty Pancakes', 'Serve warm with maple syrup.', 7);
INSERT INTO tags (recipe_name, tag_name) VALUES
('Hearty Pancakes', 'Breakfast'),
('Hearty Pancakes', 'Healthy'),
('Hearty Pancakes', 'Easy');
INSERT INTO meal_type (recipe_name, meal) VALUES
('Hearty Pancakes', 'Breakfast'),
('Hearty Pancakes', 'Brunch');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Summer Garden Couscous Salad', 'Cooking', 2, 'This Summer Garden Couscous Salad is bursting with fresh flavors and vibrant colors. It features a medley of garden vegetables, herbs, and feta cheese tossed with fluffy couscous and a zesty lemon dressing.', 'For best results, chill the salad in the refrigerator for at least 1 hour before serving to allow the flavors to meld together.', 'You can customize this salad with your favorite seasonal vegetables such as cherry tomatoes, cucumbers, or bell peppers.', 'This salad makes a delicious and refreshing side dish for picnics, barbecues, or potlucks.', 6.0, 15.0, 10.0, 'Italy', 'http://fakephotolink.com/summer_garden_couscous_salad.jpg', 'Summer Garden Couscous Salad with fresh vegetables and herbs', 15, 15, 2);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Summer Garden Couscous Salad', 'Mixing Bowl', 1),
('Summer Garden Couscous Salad', 'Saucepan', 1),
('Summer Garden Couscous Salad', 'Chef\'s Knife', 1),
('Summer Garden Couscous Salad', 'Cutting Board', 1),
('Summer Garden Couscous Salad', 'Measuring Cups', 1),
('Summer Garden Couscous Salad', 'Measuring Spoons', 1),
('Summer Garden Couscous Salad', 'Strainer', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('Couscous', 376.0, 0, 'Cereals and Cereal Products', 'gr'),
('Water', 0.0, 0, 'Others', 'ml'),
('Lemon Juice', 4.0, 0, 'Coffee, Tea, and Their Products', 'tbsp'),
('Bell Pepper', 25.0, 1, 'Various Plant-based Foods', 'gr'),
('Fresh Parsley', 2.0, 0, 'Herbs and Essential Oils', 'tbsp'),
('Fresh Mint', 2.0, 0, 'Herbs and Essential Oils', 'tbsp');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('Summer Garden Couscous Salad', 'Couscous', 200, NULL),
('Summer Garden Couscous Salad', 'Water', 240, NULL),
('Summer Garden Couscous Salad', 'Salt', 1, NULL),
('Summer Garden Couscous Salad', 'Olive Oil', 60, NULL),
('Summer Garden Couscous Salad', 'Lemon Juice', 45, NULL),
('Summer Garden Couscous Salad', 'Garlic', 2, NULL),
('Summer Garden Couscous Salad', 'Cherry Tomatoes', NULL, 'Some'),
('Summer Garden Couscous Salad', 'Cucumber', NULL, 'Some'),
('Summer Garden Couscous Salad', 'Red Onion', NULL, 'Some'),
('Summer Garden Couscous Salad', 'Bell Pepper', NULL, 'Some'),
('Summer Garden Couscous Salad', 'Fresh Parsley', NULL, 'Some'),
('Summer Garden Couscous Salad', 'Fresh Mint', NULL, 'Some'),
('Summer Garden Couscous Salad', 'Feta Cheese', 100, NULL);
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('Summer Garden Couscous Salad', 'Couscous');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('Summer Garden Couscous Salad', 'In a saucepan, bring water to a boil. Stir in the couscous and salt, cover, and remove from heat. Let stand for 5 minutes.', 1),
('Summer Garden Couscous Salad', 'Fluff the couscous with a fork and transfer to a large mixing bowl. Drizzle with olive oil and lemon juice, and toss to combine.', 2),
('Summer Garden Couscous Salad', 'Add the minced garlic, cherry tomatoes, cucumber, red onion, bell pepper, parsley, mint, and crumbled feta cheese to the bowl.', 3),
('Summer Garden Couscous Salad', 'Gently toss the salad until all ingredients are evenly distributed.', 4),
('Summer Garden Couscous Salad', 'Season with salt and pepper to taste.', 5),
('Summer Garden Couscous Salad', 'Chill in the refrigerator for at least 1 hour before serving.', 6);
INSERT INTO tags (recipe_name, tag_name) VALUES
('Summer Garden Couscous Salad', 'Salad'),
('Summer Garden Couscous Salad', 'Vegetarian'),
('Summer Garden Couscous Salad', 'Fresh');
INSERT INTO meal_type (recipe_name, meal) VALUES
('Summer Garden Couscous Salad', 'Lunch'),
('Summer Garden Couscous Salad', 'Dinner');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Squash Corn Chowder', 'Cooking', 3, 'This Squash Corn Chowder is a creamy and comforting soup that\'s perfect for cool evenings. It\'s made with butternut squash, sweet corn, and aromatic spices, creating a deliciously hearty dish.', 'For added richness, stir in a splash of heavy cream or coconut milk just before serving.', 'Garnish with fresh herbs such as parsley or chives for a pop of color and flavor.', 'Serve with crusty bread or crackers for a satisfying meal.', 4.0, 30.0, 25.0, 'United States', 'http://fakephotolink.com/squash_corn_chowder.jpg', 'Squash Corn Chowder with butternut squash and sweet corn', 15, 30, 1);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Squash Corn Chowder', 'Pot', 1),
('Squash Corn Chowder', 'Chef\'s Knife', 1),
('Squash Corn Chowder', 'Cutting Board', 1),
('Squash Corn Chowder', 'Strainer', 1),
('Squash Corn Chowder', 'Measuring Cups', 1),
('Squash Corn Chowder', 'Measuring Spoons', 1),
('Squash Corn Chowder', 'Immersion Blender', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('Butternut Squash', 45.0, 1, 'Various Plant-based Foods', 'gr'),
('Sweet Corn', 86.0, 1, 'Various Plant-based Foods', 'gr'),
('Celery', 6.0, 1, 'Various Plant-based Foods', NULL),
('Carrot', 25.0, 1, 'Various Plant-based Foods', 'gr'),
('Potato', 77.0, 1, 'Various Plant-based Foods', 'gr'),
('Vegetable Broth', 3.0, 0, 'Others', 'cups'),
('Bay Leaf', 0.0, 0, 'Herbs and Essential Oils', NULL),
('Heavy Cream', 345.0, 0, 'Milk, Eggs, and Their Products', 'ml');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('Squash Corn Chowder', 'Butternut Squash', 400, NULL),
('Squash Corn Chowder', 'Sweet Corn', 200, NULL),
('Squash Corn Chowder', 'Onion', 1, NULL),
('Squash Corn Chowder', 'Celery', 2, NULL),
('Squash Corn Chowder', 'Carrot', 1, NULL),
('Squash Corn Chowder', 'Potato', 1, NULL),
('Squash Corn Chowder', 'Vegetable Broth', 4, NULL),
('Squash Corn Chowder', 'Garlic', 2, NULL),
('Squash Corn Chowder', 'Bay Leaf', 1, NULL),
('Squash Corn Chowder', 'Thyme', 1, NULL),
('Squash Corn Chowder', 'Salt', 1, NULL),
('Squash Corn Chowder', 'Black Pepper', 1, NULL),
('Squash Corn Chowder', 'Heavy Cream', 60, NULL);
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('Squash Corn Chowder', 'Butternut Squash');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('Squash Corn Chowder', 'Peel and dice the butternut squash, onion, celery, carrot, and potato.', 1),
('Squash Corn Chowder', 'In a large pot, heat olive oil over medium heat. Add the diced vegetables and garlic, and cook until softened.', 2),
('Squash Corn Chowder', 'Add the vegetable broth, bay leaf, thyme, salt, and pepper to the pot. Bring to a simmer and cook for 15-20 minutes, until the vegetables are tender.', 3),
('Squash Corn Chowder', 'Remove the bay leaf and thyme sprigs from the pot. Use an immersion blender to puree the soup until smooth.', 4),
('Squash Corn Chowder', 'Stir in the sweet corn and heavy cream, and cook for an additional 5 minutes.', 5),
('Squash Corn Chowder', 'Season with additional salt and pepper to taste.', 6),
('Squash Corn Chowder', 'Serve hot, garnished with fresh herbs if desired.', 7);
INSERT INTO tags (recipe_name, tag_name) VALUES
('Squash Corn Chowder', 'Soup'),
('Squash Corn Chowder', 'Comfort Food'),
('Squash Corn Chowder', 'Vegetarian');
INSERT INTO meal_type (recipe_name, meal) VALUES
('Squash Corn Chowder', 'Lunch'),
('Squash Corn Chowder', 'Dinner');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('White Beans, Tomatoes, and Spinach', 'Cooking', 2, 'This White Beans, Tomatoes, and Spinach dish is a simple and flavorful one-pan meal. It combines tender white beans, juicy tomatoes, and fresh spinach, all cooked in a savory garlic and herb-infused broth.', 'For added protein, you can serve this dish with grilled chicken, shrimp, or tofu.', 'This recipe is easily customizable—feel free to add other vegetables such as bell peppers, zucchini, or mushrooms.', 'Leftovers can be stored in an airtight container in the refrigerator for up to 3 days.', 10.0, 20.0, 15.0, 'Italy', 'http://fakephotolink.com/white_beans_tomatoes_spinach.jpg', 'White Beans, Tomatoes, and Spinach cooked in garlic and herbs', 10, 20, 3);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('White Beans, Tomatoes, and Spinach', 'Skillet', 1),
('White Beans, Tomatoes, and Spinach', 'Chef\'s Knife', 1),
('White Beans, Tomatoes, and Spinach', 'Cutting Board', 1),
('White Beans, Tomatoes, and Spinach', 'Measuring Cups', 1),
('White Beans, Tomatoes, and Spinach', 'Measuring Spoons', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('White Beans', 339.0, 1, 'Various Plant-based Foods', 'gr'),
('Tomatoes', 18.0, 1, 'Various Plant-based Foods', 'gr'),
('Spinach', 23.0, 1, 'Various Plant-based Foods', 'gr'),
('Dried Thyme', 0.0, 0, 'Herbs and Essential Oils', 'tsp');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('White Beans, Tomatoes, and Spinach', 'White Beans', 400, NULL),
('White Beans, Tomatoes, and Spinach', 'Tomatoes', 200, NULL),
('White Beans, Tomatoes, and Spinach', 'Spinach', 100, NULL),
('White Beans, Tomatoes, and Spinach', 'Olive Oil', 30, NULL),
('White Beans, Tomatoes, and Spinach', 'Garlic', 2, NULL),
('White Beans, Tomatoes, and Spinach', 'Vegetable Broth', 240, NULL),
('White Beans, Tomatoes, and Spinach', 'Dried Thyme', 1, NULL),
('White Beans, Tomatoes, and Spinach', 'Salt', 1, NULL),
('White Beans, Tomatoes, and Spinach', 'Black Pepper', 1, NULL);
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('White Beans, Tomatoes, and Spinach', 'White Beans');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('White Beans, Tomatoes, and Spinach', 'Heat olive oil in a skillet over medium heat. Add minced garlic and cook until fragrant.', 1),
('White Beans, Tomatoes, and Spinach', 'Add the white beans, diced tomatoes, spinach, vegetable broth, dried thyme, salt, and black pepper to the skillet.', 2),
('White Beans, Tomatoes, and Spinach', 'Simmer for 10-15 minutes, or until the vegetables are tender and the flavors have melded together.', 3),
('White Beans, Tomatoes, and Spinach', 'Taste and adjust seasoning if necessary.', 4),
('White Beans, Tomatoes, and Spinach', 'Serve hot as a main dish or a side.', 5);
INSERT INTO tags (recipe_name, tag_name) VALUES
('White Beans, Tomatoes, and Spinach', 'One-Pan Meal'),
('White Beans, Tomatoes, and Spinach', 'Vegetarian'),
('White Beans, Tomatoes, and Spinach', 'Quick');
INSERT INTO meal_type (recipe_name, meal) VALUES
('White Beans, Tomatoes, and Spinach', 'Lunch'),
('White Beans, Tomatoes, and Spinach', 'Dinner');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Spaghetti', 'Cooking', 2, 'This classic Spaghetti recipe is simple, yet delicious. Al dente spaghetti noodles are tossed in a savory marinara sauce made with tomatoes, garlic, onions, and herbs, then topped with freshly grated Parmesan cheese.', 'For a heartier meal, you can add cooked meatballs, sausage, or grilled chicken to the sauce.', 'Cook the spaghetti just until it is al dente (firm to the bite) for the best texture.', 'Garnish with fresh basil leaves and extra Parmesan cheese before serving.', 10.0, 20.0, 15.0, 'Italy', 'http://fakephotolink.com/spaghetti.jpg', 'Classic Spaghetti with marinara sauce and Parmesan cheese', 10, 20, 1);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Spaghetti', 'Pot', 1),
('Spaghetti', 'Chef\'s Knife', 1),
('Spaghetti', 'Cutting Board', 1),
('Spaghetti', 'Strainer', 1),
('Spaghetti', 'Measuring Cups', 1),
('Spaghetti', 'Measuring Spoons', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('Spaghetti Noodles', 371.0, 0, 'Cereals and Cereal Products', 'gr'),
('Dried Basil', 0.0, 0, 'Herbs and Essential Oils', 'tsp');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('Spaghetti', 'Spaghetti Noodles', 200, NULL),
('Spaghetti', 'Tomatoes', 200, NULL),
('Spaghetti', 'Onion', 1, NULL),
('Spaghetti', 'Garlic', 2, NULL),
('Spaghetti', 'Olive Oil', 30, NULL),
('Spaghetti', 'Tomato Paste', 30, NULL),
('Spaghetti', 'Dried Basil', 1, NULL),
('Spaghetti', 'Dried Oregano', 1, NULL),
('Spaghetti', 'Salt', 1, NULL),
('Spaghetti', 'Black Pepper', 1, NULL),
('Spaghetti', 'Parmesan Cheese', NULL, 'Some');
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('Spaghetti', 'Spaghetti Noodles');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('Spaghetti', 'Cook the spaghetti noodles according to package instructions until al dente. Drain and set aside.', 1),
('Spaghetti', 'In a large skillet, heat olive oil over medium heat. Add minced garlic and diced onion, and cook until softened.', 2),
('Spaghetti', 'Stir in diced tomatoes, tomato paste, dried basil, dried oregano, salt, and black pepper. Simmer for 10 minutes, stirring occasionally.', 3),
('Spaghetti', 'Add the cooked spaghetti to the skillet and toss to coat evenly with the sauce.', 4),
('Spaghetti', 'Serve hot, garnished with freshly grated Parmesan cheese.', 5);
INSERT INTO tags (recipe_name, tag_name) VALUES
('Spaghetti', 'Pasta'),
('Spaghetti', 'Italian'),
('Spaghetti', 'Family-Friendly');
INSERT INTO meal_type (recipe_name, meal) VALUES
('Spaghetti', 'Dinner'),
('Spaghetti', 'Lunch');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Scones', 'Pastry', 2, 'These Scones are tender, flaky, and perfect for a cozy breakfast or afternoon tea. They are lightly sweetened and flavored with vanilla, and can be customized with your favorite add-ins such as dried fruit, chocolate chips, or nuts.', 'Handle the dough gently to avoid overworking it, which can result in tough scones.', 'For best results, chill the scone dough in the refrigerator for 30 minutes before baking to help them hold their shape.', 'Serve warm with clotted cream and jam for a traditional English treat.', 5.0, 20.0, 15.0, 'United Kingdom', 'http://fakephotolink.com/scones.jpg', 'Scones served with clotted cream and jam', 10, 15, 4);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Scones', 'Mixing Bowl', 1),
('Scones', 'Baking Sheet', 1),
('Scones', 'Pastry Cutter', 1),
('Scones', 'Pastry Brush', 1),
('Scones', 'Measuring Cups', 1),
('Scones', 'Measuring Spoons', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('Unsalted Butter', 102.0, 0, 'Milk, Eggs, and Their Products', 'gr');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('Scones', 'All-Purpose Flour', 300, NULL),
('Scones', 'Granulated Sugar', 50, NULL),
('Scones', 'Baking Powder', 2, NULL),
('Scones', 'Salt', 1, NULL),
('Scones', 'Unsalted Butter', 75, NULL),
('Scones', 'Egg', 1, NULL),
('Scones', 'Heavy Cream', 120, NULL),
('Scones', 'Vanilla Extract', 5, NULL);
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('Scones', 'All-Purpose Flour');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('Scones', 'Preheat the oven to 400°F (200°C). Line a baking sheet with parchment paper.', 1),
('Scones', 'In a mixing bowl, whisk together the flour, sugar, baking powder, and salt.', 2),
('Scones', 'Cut the cold butter into small cubes and add it to the dry ingredients. Use a pastry cutter or your fingers to work the butter into the flour mixture until it resembles coarse crumbs.', 3),
('Scones', 'In a separate bowl, whisk together the egg, heavy cream, and vanilla extract.', 4),
('Scones', 'Pour the wet ingredients into the dry ingredients and stir until just combined.', 5),
('Scones', 'Turn the dough out onto a lightly floured surface and gently knead it a few times until it comes together.', 6),
('Scones', 'Pat the dough into a circle about 1 inch thick. Use a sharp knife to cut the dough into 8 wedges.', 7),
('Scones', 'Place the scones on the prepared baking sheet, leaving space between each one.', 8),
('Scones', 'Brush the tops of the scones with a little heavy cream.', 9),
('Scones', 'Bake for 15-18 minutes, or until golden brown.', 10),
('Scones', 'Transfer to a wire rack to cool slightly before serving.', 11);
INSERT INTO tags (recipe_name, tag_name) VALUES
('Scones', 'Pastry'),
('Scones', 'Breakfast'),
('Scones', 'Teatime');
INSERT INTO meal_type (recipe_name, meal) VALUES
('Scones', 'Breakfast'),
('Scones', 'Brunch');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Pizza', 'Cooking', 3, 'This Pizza recipe yields a delicious homemade pizza with a crispy crust and flavorful toppings. Customize it with your favorite sauces, cheeses, and toppings for a meal the whole family will love.', 'For a quicker option, you can use store-bought pizza dough instead of making your own.', 'Get creative with your toppings—try classics like pepperoni and mushrooms or experiment with unique combinations like barbecue chicken and pineapple.', 'If you don\'t have a pizza stone, you can use a baking sheet or pizza pan instead.', 15.0, 25.0, 20.0, 'Italy', 'http://fakephotolink.com/pizza.jpg', 'Homemade Pizza with pepperoni, olives, and bell peppers', 15, 25, 1);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Pizza', 'Pizza Stone', 1),
('Pizza', 'Rolling Pin', 1),
('Pizza', 'Pizza Cutter', 1),
('Pizza', 'Mixing Bowl', 1),
('Pizza', 'Measuring Cups', 1),
('Pizza', 'Measuring Spoons', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('Yeast', 105.0, 0, 'Various Plant-based Foods', 'gr'),
('Warm Water', 0.0, 0, 'Others', 'ml'),
('Pizza Sauce', 32.0, 0, 'Various Plant-based Foods', 'ml'),
('Toppings (e.g., pepperoni, vegetables)', 100.0, 1, 'Various Plant-based Foods', 'gr');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('Pizza', 'All-Purpose Flour', 300, NULL),
('Pizza', 'Yeast', 7, NULL),
('Pizza', 'Sugar', 1, NULL),
('Pizza', 'Salt', 1, NULL),
('Pizza', 'Olive Oil', 30, NULL),
('Pizza', 'Warm Water', 240, NULL),
('Pizza', 'Pizza Sauce', NULL, 'Some'),
('Pizza', 'Mozzarella Cheese', 200, NULL),
('Pizza', 'Toppings (e.g., pepperoni, vegetables)', NULL, 'Some');
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('Pizza', 'All-Purpose Flour');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('Pizza', 'In a mixing bowl, combine warm water, yeast, and sugar. Let it sit for 5-10 minutes until foamy.', 1),
('Pizza', 'Add olive oil, salt, and flour to the yeast mixture. Stir until a dough forms.', 2),
('Pizza', 'Transfer the dough to a floured surface and knead for 5-7 minutes, until smooth and elastic.', 3),
('Pizza', 'Place the dough in a greased bowl, cover with a clean kitchen towel, and let it rise in a warm place for 1-2 hours, or until doubled in size.', 4),
('Pizza', 'Preheat the oven to 475°F (245°C). If using a pizza stone, place it in the oven to preheat as well.', 5),
('Pizza', 'Punch down the dough and transfer it to a lightly floured surface. Roll it out into a circle or rectangle, depending on your preference.', 6),
('Pizza', 'Transfer the rolled-out dough to a pizza peel or parchment paper dusted with cornmeal.', 7),
('Pizza', 'Spread pizza sauce evenly over the dough, leaving a small border around the edges.', 8),
('Pizza', 'Sprinkle mozzarella cheese over the sauce, then add your desired toppings.', 9),
('Pizza', 'Carefully transfer the pizza to the preheated pizza stone or baking sheet in the oven.', 10),
('Pizza', 'Bake for 12-15 minutes, or until the crust is golden brown and the cheese is bubbly.', 11),
('Pizza', 'Remove from the oven and let it cool slightly before slicing and serving.', 12);
INSERT INTO tags (recipe_name, tag_name) VALUES
('Pizza', 'Italian'),
('Pizza', 'Homemade'),
('Pizza', 'Family-Friendly');
INSERT INTO meal_type (recipe_name, meal) VALUES
('Pizza', 'Dinner'),
('Pizza', 'Lunch');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Stir-Fry', 'Cooking', 2, 'This Stir-Fry recipe is a quick and versatile dish that\'s perfect for busy weeknights. It features a colorful mix of vegetables and protein stir-fried in a savory sauce, served over rice or noodles.', 'Prep all your ingredients before you start cooking—once you begin stir-frying, things move quickly!', 'Feel free to use any combination of vegetables and protein you like, such as bell peppers, broccoli, carrots, tofu, chicken, or shrimp.', 'Make extra sauce if you like your stir-fry saucy—you can always use it for another meal.', 15.0, 15.0, 10.0, 'China', 'http://fakephotolink.com/stir_fry.jpg', 'Stir-Fry with vegetables and chicken served over rice', 15, 15, 1);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Stir-Fry', 'Skillet', 1),
('Stir-Fry', 'Spatula', 1),
('Stir-Fry', 'Chef\'s Knife', 1),
('Stir-Fry', 'Cutting Board', 1),
('Stir-Fry', 'Measuring Cups', 1),
('Stir-Fry', 'Measuring Spoons', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('Protein (e.g., chicken, tofu, shrimp)', 200.0, 1, 'Meat and Meat Products', 'gr'),
('Vegetables (e.g., bell peppers, broccoli, carrots)', 50.0, 1, 'Various Plant-based Foods', 'gr'),
('Rice or Noodles', 130.0, 0, 'Cereals and Cereal Products', 'gr'),
('Sesame Oil', 884.0, 0, 'Fats and Oils', 'tbsp'),
('Cornstarch', 30.0, 0, 'Various Plant-based Foods', 'tbsp');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('Stir-Fry', 'Protein (e.g., chicken, tofu, shrimp)', NULL, 'Some'),
('Stir-Fry', 'Vegetables (e.g., bell peppers, broccoli, carrots)', NULL, 'Some'),
('Stir-Fry', 'Rice or Noodles', 200, NULL),
('Stir-Fry', 'Soy Sauce', 60, NULL),
('Stir-Fry', 'Sesame Oil', 1, NULL),
('Stir-Fry', 'Garlic', 2, NULL),
('Stir-Fry', 'Ginger', 1, NULL),
('Stir-Fry', 'Cornstarch', 1.5, NULL),
('Stir-Fry', 'Water', 30, NULL);
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('Stir-Fry', 'Protein (e.g., chicken, tofu, shrimp)');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('Stir-Fry', 'Cook rice or noodles according to package instructions. Drain and set aside.', 1),
('Stir-Fry', 'In a small bowl, whisk together soy sauce, sesame oil, minced garlic, grated ginger, cornstarch, and water to make the sauce.', 2),
('Stir-Fry', 'Heat a wok or large skillet over high heat. Add a splash of oil and swirl to coat the pan.', 3),
('Stir-Fry', 'Add the protein to the hot pan and cook until browned and cooked through. Remove from the pan and set aside.', 4),
('Stir-Fry', 'Add a bit more oil to the pan if needed, then add the vegetables. Stir-fry until tender-crisp.', 5),
('Stir-Fry', 'Return the protein to the pan. Pour the sauce over the protein and vegetables.', 6),
('Stir-Fry', 'Cook, stirring constantly, until the sauce has thickened and everything is heated through.', 7),
('Stir-Fry', 'Serve the stir-fry hot over the cooked rice or noodles.', 8);
INSERT INTO tags (recipe_name, tag_name) VALUES
('Stir-Fry', 'Asian'),
('Stir-Fry', 'Quick'),
('Stir-Fry', 'Easy');
INSERT INTO meal_type (recipe_name, meal) VALUES
('Stir-Fry', 'Dinner'),
('Stir-Fry', 'Lunch');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Rustic Italian Tortellini Soup', 'Cooking', 2, 'This Rustic Italian Tortellini Soup is hearty, flavorful, and perfect for a cozy dinner. It features cheese-filled tortellini simmered in a savory broth with tomatoes, spinach, and Italian herbs.', 'Feel free to customize this soup with your favorite vegetables or protein.', 'For extra richness, you can add a splash of heavy cream or a sprinkle of grated Parmesan cheese before serving.', 'Serve with crusty bread or a side salad for a complete meal.', 10.0, 30.0, 20.0, 'Italy', 'http://fakephotolink.com/tortellini_soup.jpg', 'Rustic Italian Tortellini Soup with tomatoes, spinach, and herbs', 10, 30, 1);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Rustic Italian Tortellini Soup', 'Pot', 1),
('Rustic Italian Tortellini Soup', 'Chef\'s Knife', 1),
('Rustic Italian Tortellini Soup', 'Cutting Board', 1),
('Rustic Italian Tortellini Soup', 'Strainer', 1),
('Rustic Italian Tortellini Soup', 'Measuring Cups', 1),
('Rustic Italian Tortellini Soup', 'Measuring Spoons', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('Cheese Tortellini', 100.0, 0, 'Cereals and Cereal Products', 'gr');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('Rustic Italian Tortellini Soup', 'Cheese Tortellini', 200, NULL),
('Rustic Italian Tortellini Soup', 'Tomatoes', 200, NULL),
('Rustic Italian Tortellini Soup', 'Spinach', 100, NULL),
('Rustic Italian Tortellini Soup', 'Onion', 1, NULL),
('Rustic Italian Tortellini Soup', 'Garlic', 2, NULL),
('Rustic Italian Tortellini Soup', 'Vegetable Broth', 4, NULL),
('Rustic Italian Tortellini Soup', 'Dried Basil', 1, NULL),
('Rustic Italian Tortellini Soup', 'Dried Oregano', 1, NULL),
('Rustic Italian Tortellini Soup', 'Salt', 1, NULL),
('Rustic Italian Tortellini Soup', 'Black Pepper', 1, NULL),
('Rustic Italian Tortellini Soup', 'Heavy Cream', 60, NULL);
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('Rustic Italian Tortellini Soup', 'Cheese Tortellini');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('Rustic Italian Tortellini Soup', 'In a large pot, heat olive oil over medium heat. Add diced onion and minced garlic, and cook until softened.', 1),
('Rustic Italian Tortellini Soup', 'Add diced tomatoes, dried basil, dried oregano, salt, and black pepper to the pot. Cook for 5 minutes, until the tomatoes start to break down.', 2),
('Rustic Italian Tortellini Soup', 'Pour in the vegetable broth and bring the mixture to a simmer.', 3),
('Rustic Italian Tortellini Soup', 'Add the cheese tortellini to the pot and cook according to package instructions.', 4),
('Rustic Italian Tortellini Soup', 'Stir in the spinach until wilted, then add the heavy cream and cook for an additional 2-3 minutes.', 5),
('Rustic Italian Tortellini Soup', 'Taste and adjust seasoning if necessary.', 6),
('Rustic Italian Tortellini Soup', 'Serve hot, garnished with grated Parmesan cheese if desired.', 7);
INSERT INTO tags (recipe_name, tag_name) VALUES
('Rustic Italian Tortellini Soup', 'Soup'),
('Rustic Italian Tortellini Soup', 'Italian'),
('Rustic Italian Tortellini Soup', 'Comfort Food');
INSERT INTO meal_type (recipe_name, meal) VALUES
('Rustic Italian Tortellini Soup', 'Lunch'),
('Rustic Italian Tortellini Soup', 'Dinner');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Swedish Meatballs', 'Cooking', 3, 'These Swedish Meatballs are tender, juicy, and packed with flavor. They are made with a mix of ground beef and pork, seasoned with aromatic spices, then simmered in a creamy sauce until they\'re melt-in-your-mouth delicious.', 'To keep the meatballs tender, don\'t overmix the meat mixture.', 'For extra flavor, you can add a splash of Worcestershire sauce or soy sauce to the meatball mixture.', 'Serve over mashed potatoes, noodles, or with lingonberry jam for a traditional Swedish meal.', 25.0, 30.0, 20.0, 'Sweden', 'http://fakephotolink.com/meatballs.jpg', 'Swedish Meatballs in creamy sauce', 25, 30, 3);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Swedish Meatballs', 'Skillet', 1),
('Swedish Meatballs', 'Mixing Bowl', 1),
('Swedish Meatballs', 'Chef\'s Knife', 1),
('Swedish Meatballs', 'Cutting Board', 1),
('Swedish Meatballs', 'Measuring Cups', 1),
('Swedish Meatballs', 'Measuring Spoons', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES
('Ground Pork', 310.0, 0, 'Meat and Meat Products', 'gr'),
('Breadcrumbs', 400.0, 0, 'Cereals and Cereal Products', 'gr'),
('Beef Broth', 2.0, 0, 'Others', 'cups');
INSERT INTO requires_ingr (recipe_name, ingr_name, quantity, undefined_quantity)
VALUES
('Swedish Meatballs', 'Ground Beef', 250, NULL),
('Swedish Meatballs', 'Ground Pork', 250, NULL),
('Swedish Meatballs', 'Breadcrumbs', 50, NULL),
('Swedish Meatballs', 'Egg', 1, NULL),
('Swedish Meatballs', 'Onion', 1, NULL),
('Swedish Meatballs', 'Garlic', 2, NULL),
('Swedish Meatballs', 'Allspice', 1, NULL),
('Swedish Meatballs', 'Nutmeg', 1, NULL),
('Swedish Meatballs', 'Salt', 1, NULL),
('Swedish Meatballs', 'Black Pepper', 1, NULL),
('Swedish Meatballs', 'Butter', 60, NULL),
('Swedish Meatballs', 'All-Purpose Flour', 60, NULL),
('Swedish Meatballs', 'Beef Broth', 480, NULL),
('Swedish Meatballs', 'Heavy Cream', 120, NULL);
INSERT INTO main_ingr (recipe_name, ingr_name)
VALUES
('Swedish Meatballs', 'Ground Beef');
INSERT INTO recipe_steps (recipe_name, instruction, step_num)
VALUES
('Swedish Meatballs', 'In a mixing bowl, combine ground beef, ground pork, breadcrumbs, egg, minced onion, minced garlic, allspice, nutmeg, salt, and black pepper.', 1),
('Swedish Meatballs', 'Mix until well combined, then shape the mixture into meatballs.', 2),
('Swedish Meatballs', 'In a large skillet, melt butter over medium heat. Add the meatballs and cook until browned on all sides.', 3),
('Swedish Meatballs', 'Remove the meatballs from the skillet and set aside.', 4),
('Swedish Meatballs', 'Add flour to the skillet and cook, stirring constantly, for 1-2 minutes to make a roux.', 5),
('Swedish Meatballs', 'Gradually whisk in beef broth and heavy cream until smooth.', 6),
('Swedish Meatballs', 'Return the meatballs to the skillet and simmer in the sauce for 10-15 minutes, until cooked through and the sauce has thickened.', 7),
('Swedish Meatballs', 'Serve hot, garnished with chopped parsley if desired.', 8);
INSERT INTO tags (recipe_name, tag_name) VALUES
('Swedish Meatballs', 'Meat'),
('Swedish Meatballs', 'Comfort Food'),
('Swedish Meatballs', 'European');
INSERT INTO meal_type (recipe_name, meal) VALUES
('Swedish Meatballs', 'Dinner'),
('Swedish Meatballs', 'Lunch');
INSERT INTO recipes (recipe_name, recipe_type, recipe_difficulty, recipe_desc, recipe_tip1, recipe_tip2, recipe_tip3, recipe_proteins, recipe_carbs, recipe_fats, country_name, recipe_photo, recipe_photo_desc, prep_time, execution_time, portions)
VALUES
('Barley Beef Skillet', 'Cooking', 2, 'This Barley Beef Skillet is a hearty and nutritious one-pan meal that\'s perfect for busy weeknights. Tender beef is cooked with barley, vegetables, and savory herbs for a comforting dish the whole family will love.', 'For a vegetarian version, you can omit the beef and use mushrooms or tofu instead.', 'Barley absorbs a lot of liquid, so you may need to add more broth or water as it cooks.', 'Feel free to customize the vegetables based on what you have on hand or your personal preferences.', 25.0, 35.0, 20.0, 'Nigeria', 'http://fakephotolink.com/barley_beef_skillet.jpg', 'Barley Beef Skillet with vegetables and herbs', 25, 35, 1);
INSERT INTO requires_eq (recipe_name, eq_name, quantity)
VALUES
('Barley Beef Skillet', 'Skillet', 1),
('Barley Beef Skillet', 'Chef\'s Knife', 1),
('Barley Beef Skillet', 'Cutting Board', 1),
('Barley Beef Skillet', 'Measuring Cups', 1),
('Barley Beef Skillet', 'Measuring Spoons', 1);
INSERT INTO ingredients (ingr_name, ingr_calories, allows_loose_units, group_name, unit) VALUES