-
Notifications
You must be signed in to change notification settings - Fork 0
/
Data_Refresh.sql
311 lines (311 loc) · 21.5 KB
/
Data_Refresh.sql
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
Insert into flavor_profile(flavor_id, name)
values (1, 'traditional');
Insert into flavor_profile(flavor_id, name)
values (2, 'american');
Insert into flavor_profile(flavor_id, name)
values (3, 'mexican');
Insert into flavor_profile(flavor_id, name)
values (4, 'chinese');
Insert into flavor_profile(flavor_id, name)
values (5, 'japanese');
Insert into flavor_profile(flavor_id, name)
values (6, 'vegetarian');
Insert into flavor_profile(flavor_id, name)
values (7, 'vegan');
Insert into flavor_profile(flavor_id, name)
values (8, 'italian');
Insert into flavor_profile(flavor_id, name)
values (9, 'greek');
Insert into flavor_profile(flavor_id, name)
values (10, 'british');
Insert into flavor_profile(flavor_id, name)
values (11, 'irish');
Insert into flavor_profile(flavor_id, name)
values (12, 'french');
Insert into flavor_profile(flavor_id, name)
values (13, 'spanish');
Insert into flavor_profile(flavor_id, name)
values (14, 'thailand');
Insert into flavor_profile(flavor_id, name)
values (15, 'scottish');
Insert into ingredient(ingredient_id, ingredient)
values (1, 'bread');
Insert into ingredient(ingredient_id, ingredient)
values (2, 'peanut butter');
Insert into ingredient(ingredient_id, ingredient)
values (3, 'butter');
Insert into ingredient(ingredient_id, ingredient)
values (4, 'salt');
Insert into ingredient(ingredient_id, ingredient)
values (5, 'black pepper');
Insert into ingredient(ingredient_id, ingredient)
values (6, 'salmon');
Insert into ingredient(ingredient_id, ingredient)
values (7, 'parsley');
Insert into ingredient(ingredient_id, ingredient)
values (8, 'olive oil');
Insert into ingredient(ingredient_id, ingredient)
values (9, 'sea scallop');
Insert into ingredient(ingredient_id, ingredient)
values (10, 'minced garlic');
Insert into ingredient(ingredient_id, ingredient)
values (11, 'lemon juice');
Insert into ingredient(ingredient_id, ingredient)
values (12, 'white wine');
Insert into ingredient(ingredient_id, ingredient)
values (13, 'water');
Insert into ingredient(ingredient_id, ingredient)
values (14, 'chopped chives');
Insert into ingredient(ingredient_id, ingredient)
values (15, 'chocolate');
Insert into ingredient(ingredient_id, ingredient)
values (16, 'sugar');
Insert into ingredient(ingredient_id, ingredient)
values (17, 'egg');
Insert into ingredient(ingredient_id, ingredient)
values (18, 'all-purpose flour');
Insert into ingredient(ingredient_id, ingredient)
values (19, 'vanilla extract');
Insert into ingredient(ingredient_id, ingredient)
values (20, 'tortilla');
Insert into ingredient(ingredient_id, ingredient)
values (21, 'chopped onion');
Insert into ingredient(ingredient_id, ingredient)
values (22, 'ground cumin');
Insert into ingredient(ingredient_id, ingredient)
values (23, 'cayenne');
Insert into ingredient(ingredient_id, ingredient)
values (24, 'pinto beans');
Insert into ingredient(ingredient_id, ingredient)
values (25, 'cheddar');
Insert into ingredient(ingredient_id, ingredient)
values (26, 'jack cheese');
Insert into ingredient(ingredient_id, ingredient)
values (27, 'sour cream');
Insert into ingredient(ingredient_id, ingredient)
values (28, 'iceberg lettuce');
Insert into ingredient(ingredient_id, ingredient)
values (29, 'romaine lettuce');
Insert into ingredient(ingredient_id, ingredient)
values (30, 'salsa');
Insert into ingredient(ingredient_id, ingredient)
values (31, 'chicken breast');
Insert into ingredient(ingredient_id, ingredient)
values (32, 'vegetable oil');
Insert into ingredient(ingredient_id, ingredient)
values (33, 'sesame seeds');
Insert into ingredient(ingredient_id, ingredient)
values (34, 'green onion');
Insert into ingredient(ingredient_id, ingredient)
values (35, 'soy sauce');
Insert into ingredient(ingredient_id, ingredient)
values (36, 'cornstarch');
Insert into ingredient(ingredient_id, ingredient)
values (37, 'orange juice');
Insert into ingredient(ingredient_id, ingredient)
values (38, 'dark brown sugar');
Insert into ingredient(ingredient_id, ingredient)
values (39, 'hoisin sauce');
Insert into ingredient(ingredient_id, ingredient)
values (40, 'rice vinegar');
Insert into ingredient(ingredient_id, ingredient)
values (41, 'orange zest');
Insert into ingredient(ingredient_id, ingredient)
values (42, 'sriracha sauce');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (1, 'admin', 'mozzarella', 'cheese', 'Jakob', 'LaSorella');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (2, 'admin', 'mraware', 'admin', 'Aaron', 'Ware');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (3, 'admin', 'pawling', 'admin', 'Isaac', 'Pawling');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (4, 'admin', 'mille409', 'admin', 'Jacob', 'Miller');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (5, 'star', 'fox', 'arwing', 'Fox', 'McCloud');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (6, 'star', 'falco', 'arwing', 'Falco', 'Lombardi');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (7, 'star', 'peppy', 'arwing', 'Peppy', 'Hare');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (8, 'star', 'wolf', 'arwing', 'Wolf', 'O''Donnel');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (9, 'star', 'slippy', 'arwing', 'Slippy', 'Toad');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (10, 'star', 'leon', 'arwing', 'Leon', 'Powalski');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (11, 'user', 'sweets', 'sugar', 'Meatball', 'Monday');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (12, 'user', 'dairy', 'milk', 'Taco', 'Tuesday');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (13, 'user', 'vegetables', 'carrot', 'Waffle', 'Wednesday');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (14, 'user', 'meats', 'steak', 'Tuna', 'Thursday');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (15, 'user', 'fruits', 'apple', 'Fried', 'Friday');
Insert into recipeak_user(user_id, type, username, password, firstname, lastname)
values (16, 'user', 'grains', 'bread', 'Soup', 'Saturday');
Insert into recipe(recipe_id, name, flavor, creator, privacy, burns, promoted, notes)
values (1, 'Peanut Butter Sandwich', 1, 1, 'public', 0, 0, 'A family favorite.');
Insert into recipe(recipe_id, name, flavor, creator, privacy, burns, promoted, notes)
values (2, 'Seared Scallops with Pan Sauce', 8, 1, 'public', 0, 1, 'You''ll amaze yourself and your friends with this easy restaurant-style dish.');
Insert into recipe(recipe_id, name, flavor, creator, privacy, burns, promoted, notes)
values (3, 'Orange Chicken', 4, 1, 'private', 0, 0, 'Tastes like chicken.');
Insert into recipe(recipe_id, name, flavor, creator, privacy, burns, promoted, notes)
values (4, 'Brownie', 2, 4, 'public', 0, 1, 'Ridiculously good.');
Insert into recipe(recipe_id, name, flavor, creator, privacy, burns, promoted, notes)
values (5, 'Bean Burrito', 3, 3, 'public', 0, 1, 'One fast recipe.');
Insert into recipe(recipe_id, name, flavor, creator, privacy, burns, promoted, notes)
values (6, 'Roasted Salmon with Butter', 2, 2, 'public', 0, 1, 'Something fishy.');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (1, 1, 1, 2, 'slices');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (2, 1, 2, 1, 'smear');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (3, 2, 3, 3, 'tablespoons');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (4, 2, 8, 1, 'tablespoon');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (5, 2, 9, 1.5, 'pounds');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (6, 2, 4, 0, 'to taste');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (7, 2, 5, 0, 'to taste');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (8, 2, 10, 1, 'tablespoon');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (9, 2, 11, 1, 'lemon');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (10, 2, 12, .5, 'cup');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (11, 2, 14, 2, 'tablespoons');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (12, 3, 31, 1.5, 'pounds');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (13, 3, 32, 2, 'tablespoons');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (14, 3, 33, 0, 'as garnish');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (15, 3, 34, 0, 'as garnish');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (16, 3, 35, .25, 'cup');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (17, 3, 36, .25, 'cups');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (18, 3, 13, 2, 'tablespoons');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (19, 3, 37, .75, 'cups');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (20, 3, 38, 2, 'tablespoons');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (21, 3, 36, 1, 'tablespoon');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (22, 3, 35, 1, 'tablespoon');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (23, 3, 39, 1, 'tablespoon');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (24, 3, 40, 2, 'teaspoons');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (25, 3, 41, 1, 'teaspoon');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (26, 3, 42, 1, 'teaspoon');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (27, 4, 3, 8, 'tablespoons');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (28, 4, 15, 3, 'ounces');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (29, 4, 16, 1, 'cup');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (30, 4, 17, 2, 'eggs');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (31, 4, 18, .5, 'cups');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (32, 4, 4, 1, 'pinch');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (33, 4, 19, .5, 'teaspoon');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (34, 5, 20, 4, 'large');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (35, 5, 8, .25, 'cup');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (36, 5, 21, 1, 'medium onion');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (37, 5, 22, 1, 'tablespoon');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (38, 5, 23, .25, 'teaspoon');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (39, 5, 4, 0, 'to taste');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (40, 5, 5, 0, 'to taste');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (41, 5, 24, 3, 'cups');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (42, 5, 25, 1, 'cup');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (43, 5, 26, 1, 'cup');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (44, 5, 27, .25, 'cup');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (45, 5, 28, 1, 'cup');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (46, 5, 29, 1, 'cup');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (47, 5, 30, 1, 'cup');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (48, 6, 3, 4, 'tablespoons');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (49, 6, 4, 0, 'to taste');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (50, 6, 5, 0, 'to taste');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (51, 6, 6, 1, 'fillet');
Insert into recipe_ingredients(recipeingredient_id, recipe_id, ingredient, amount, unit)
values (52, 6, 7, 2, 'tablespoons');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (1, 1, 1, 'Lay the two pieces of bread next to each other');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (2, 1, 2, 'Spread the peanut butter evenly on one piece of bread');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (3, 1, 3, 'Put the two pieces of bread together, with the peanut butter in the middle');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (4, 2, 1, 'Cut 2 tablespoons of the butter into pea-sized pieces, put it on a small plate, and stick it in the freezer. Heat a large skillet over medium-high heat for 3 or 4 minutes. Add the remaining 1 table-spoon butter and the olive oil and wait for the butter to melt.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (5, 2, 2, 'Pat the scallops dry with paper towels, add them to the pan, and sprinkle with salt and pepper; work in batches if necessary to avoid crowding the skillet. Cook, turning once, until they are well browned on both sides but not quite cooked through, 2 minutes per side (less if the scallops are under 1 inch across; more if they are over). Transfer the scallops to a plate.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (6, 2, 3, 'Stir in the garlic, lemon juice, and wine and scrape all the brown bits off the bottom of the skillet with a spatula. Lower the heat to medium and cook until the liquid in the skillet thickens, a minute or two, then whisk in the butter you chilled in the freezer, one bit at a time, to make a creamy sauce, adding another tablespoon or two of liquid if necessary.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (7, 2, 4, 'Return the scallops to the skillet and add the chives. Adjust the heat so the sauce bubbles gently and toss to coat the scallops with the sauce. To serve, transfer the scallops to a platter and spoon the sauce over all.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (8, 3, 1, 'Start by cutting 1 1/2 pounds of chicken breasts into chunks (about 1 1 1/2 cubes). Mix together soy sauce, cornstarch, and water. Add the chicken and stir to coat. Allow the chicken to marinate for 5 minutes.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (9, 3, 2, 'While it is marinating, prepare the orange sauce so that it is ready when you need it later. Whisk together fresh squeezed orange juice, dark brown sugar, cornstarch, soy sauce, hoisin sauce, rice vinegar, orange zest, and optional sriracha sauce. Set aside.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (10, 3, 3, 'Heat 2 tablespoons of oil in a large skillet. Remove the chicken from the marinade with a slotted spoon and carefully add it to the skillet. Stir-fry the chicken, over medium-high heat, for 5-7 minutes until golden and cooked through.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (11, 3, 4, 'Add the orange sauce to the chicken and cook for 4-6 minutes, stirring often until the sauce has thickened.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (12, 3, 5, 'Top with sesame seeds and sliced green onions, if desired. Serve over rice or noodles.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (13, 4, 1, 'Heat the oven to 350 degrees F. Grease a square baking pan with butter or line it by overlapping 2 pieces of parchment paper or aluminum foil crosswise and grease the lining.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (14, 4, 2, 'Combine the stick of butter and the chocolate in a small saucepan over very low heat, stirring occasionally. (Or microwave them in a large microwave-safe bowl on medium for 10-seconds intervals, stirring after each.) When the chocolate is just about melted, remove the saucepan from the heat (or bowl from the microwave) and continue to stir until the mixture is smooth.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (15, 4, 3, 'Transfer the mixture to a large bowl (or use the bowl you put in the microwave) and stir in the sugar. Then beat in the eggs, one at a time. Gently stir in the flour, salt, and the vanilla if you''re using it.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (16, 4, 4, 'Pour and scrape the mixture into the prepared pan and bake for 20 to 25 minutes, until just barely set in the middle. Cool on a rack until set. If you used parchment, lift it out to remove the brownies. If not, cut them in squares right in the pan. Store, covered, at room temperature, for no more than a day.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (17, 5, 1, 'Heat the oven to 300 degrees F. Stack the tortillas on a sheet of foil and roll them up with the foil into a log. Warm them in the oven while you make the filling.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (18, 5, 2, 'Put the oil in a large skillet over medium heat. When it''s hot, add the onion and cook, stirring frequently, until it softens and begins to turn translucent, 3 to 5 minutes. Add the cumin, cayenne, and a sprinkle of salt and pepper and stir until the spices become fragrant, no more than 1 minute. Add the beans and mash them with a large fork or potato masher until they''re mostly broken up but not completely smooth.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (19, 5, 3, 'Cook, mashing and stirring, until the onion is quite soft and the beans are hot and creamy, 5 to 10 minutes; add water, a tablespoon at a time, if the mixture looks dry. Taste and adjust the seasoning, adding more spices if you like.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (20, 5, 4, 'Remove the tortillas from the oven. Lay a tortilla on a flat surface and put about 1/2 cup of the beans on the third closest to you. Sprinkle with about a quarter of the cheese, sour cream, lettuce, and salsa.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (21, 5, 5, 'First fold the tortilla over the fillings to enclose them, then fold in the sides and roll. (You will have some leftover beans.) Serve right away.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (22, 6, 1, 'Heat the oven to 475 degrees F. When the oven is hot, put the butter on a rimmed baking sheet and sprinkle with salt and pepper. Put the pan in the oven for the butter to melt, about 1 minute. Watch it the whole time: As soon as the foaming stops, remove the pan.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (23, 6, 2, 'Put the salmon in the seasoned butter, skin side down, and sprinkle the top with more salt and pepper. Return the pan to the oven.');
Insert into instructions(instruction_id, recipe_id, step_number, step)
values (24, 6, 3, 'Roast until the salmon is just cooked through, 8 to 12 minutes. To see whether the fish is done, stick a paring knife between the layers of flesh; the center should be bright pink and still a little translucent. Garnish with the parsley and serve.');
commit;