- -- ----------------------------
- -- Test Data
- -- ----------------------------
- INSERT INTO "Ingredient" VALUES ('Vodka');
- INSERT INTO "Ingredient" VALUES ('Rum');
- INSERT INTO "Ingredient" VALUES ('Sherry');
- INSERT INTO "Ingredient" VALUES ('Whiskey');
- INSERT INTO "Ingredient" VALUES ('Cherry');
- INSERT INTO "Ingredient" VALUES ('Orange');
- INSERT INTO "Ingredient" VALUES ('Olive');
- INSERT INTO "Ingredient" VALUES ('Gin');
- INSERT INTO "Ingredient" VALUES ('Lemon Juice');
- INSERT INTO "Ingredient" VALUES ('Orange Gin');
- INSERT INTO "Ingredient" VALUES ('Sweet Vermouth');
- INSERT INTO "Ingredient" VALUES ('7-Up');
- INSERT INTO "Ingredient" VALUES ('Cranberry Juice');
- INSERT INTO "Ingredient" VALUES ('Dekuyper Razzmatazz');
- INSERT INTO "Ingredient" VALUES ('Orange Juice');
- INSERT INTO "Ingredient" VALUES ('Sour Mix');
- INSERT INTO "Ingredient" VALUES ('Dry Cider');
- INSERT INTO "Ingredient" VALUES ('Lager');
- INSERT INTO "Ingredient" VALUES ('Sloe Gin');
- INSERT INTO "Ingredient" VALUES ('Southern Comfort');
- INSERT INTO "Ingredient" VALUES ('Triple Sec');
- INSERT INTO "Ingredient" VALUES ('Blue Curacao');
- INSERT INTO "Ingredient" VALUES ('Lime Juice');
- INSERT INTO "Ingredient" VALUES ('Red Curacao');
- INSERT INTO "Ingredient" VALUES ('Tequila');
- INSERT INTO "Recipe" VALUES ('Leap Year Cocktail');
- INSERT INTO "Recipe" VALUES ('Purple Gecko');
- INSERT INTO "Recipe" VALUES ('Slow Comfortable Screw In Between the Sheets');
- INSERT INTO "Recipe" VALUES ('Snakebite (UK)');
- INSERT INTO "Recipe" VALUES ('Stoner Delight');
- INSERT INTO "Recipe" VALUES ('Vodka');
- INSERT INTO "Recipe" VALUES ('Tequila');
- INSERT INTO "Recipe" VALUES ('Whiskey');
- INSERT INTO "RecipeIngredient" VALUES ('Leap Year Cocktail', 'Lemon Juice');
- INSERT INTO "RecipeIngredient" VALUES ('Leap Year Cocktail', 'Gin');
- INSERT INTO "RecipeIngredient" VALUES ('Leap Year Cocktail', 'Orange Gin');
- INSERT INTO "RecipeIngredient" VALUES ('Leap Year Cocktail', 'Sweet Vermouth');
- INSERT INTO "RecipeIngredient" VALUES ('Purple Gecko', 'Blue Curacao');
- INSERT INTO "RecipeIngredient" VALUES ('Purple Gecko', 'Cranberry Juice');
- INSERT INTO "RecipeIngredient" VALUES ('Purple Gecko', 'Lime Juice');
- INSERT INTO "RecipeIngredient" VALUES ('Purple Gecko', 'Red Curacao');
- INSERT INTO "RecipeIngredient" VALUES ('Purple Gecko', 'Sour Mix');
- INSERT INTO "RecipeIngredient" VALUES ('Purple Gecko', 'Tequila');
- INSERT INTO "RecipeIngredient" VALUES ('Slow Comfortable Screw In Between the Sheets', 'Orange Juice');
- INSERT INTO "RecipeIngredient" VALUES ('Slow Comfortable Screw In Between the Sheets', 'Sloe Gin');
- INSERT INTO "RecipeIngredient" VALUES ('Slow Comfortable Screw In Between the Sheets', 'Southern Comfort');
- INSERT INTO "RecipeIngredient" VALUES ('Slow Comfortable Screw In Between the Sheets', 'Triple Sec');
- INSERT INTO "RecipeIngredient" VALUES ('Slow Comfortable Screw In Between the Sheets', 'Vodka');
- INSERT INTO "RecipeIngredient" VALUES ('Snakebite (UK)', 'Dry Cider');
- INSERT INTO "RecipeIngredient" VALUES ('Snakebite (UK)', 'Lager');
- INSERT INTO "RecipeIngredient" VALUES ('Stoner Delight', '7-Up');
- INSERT INTO "RecipeIngredient" VALUES ('Stoner Delight', 'Cranberry Juice');
- INSERT INTO "RecipeIngredient" VALUES ('Stoner Delight', 'Dekuyper Razzmatazz');
- INSERT INTO "RecipeIngredient" VALUES ('Stoner Delight', 'Orange Juice');
- INSERT INTO "RecipeIngredient" VALUES ('Stoner Delight', 'Sour Mix');
- INSERT INTO "RecipeIngredient" VALUES ('Stoner Delight', 'Vodka');
- INSERT INTO "RecipeIngredient" VALUES ('Vodka', 'Vodka');
- INSERT INTO "RecipeIngredient" VALUES ('Tequila', 'Tequila');
- INSERT INTO "RecipeIngredient" VALUES ('Whiskey', 'Whiskey');
- INSERT INTO "User" VALUES ('Kevin');
- INSERT INTO "User" VALUES ('Andy');
- INSERT INTO "UserIngredient" VALUES ('Kevin', 'Orange Juice');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Rum');
- INSERT INTO "UserIngredient" VALUES ('Kevin', 'Blue Curacao');
- INSERT INTO "UserIngredient" VALUES ('Kevin', 'Sour Mix');
- INSERT INTO "UserIngredient" VALUES ('Kevin', '7-Up');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Lemon Juice');
- INSERT INTO "UserIngredient" VALUES ('Kevin', 'Cherry');
- INSERT INTO "UserIngredient" VALUES ('Kevin', 'Dry Cider');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Sweet Vermouth');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Blue Curacao');
- INSERT INTO "UserIngredient" VALUES ('Kevin', 'Sherry');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Tequila');
- INSERT INTO "UserIngredient" VALUES ('Kevin', 'Red Curacao');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Sherry');
- INSERT INTO "UserIngredient" VALUES ('Kevin', 'Sweet Vermouth');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Olive');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Dekuyper Razzmatazz');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Lime Juice');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Lager');
- INSERT INTO "UserIngredient" VALUES ('Kevin', 'Sloe Gin');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Southern Comfort');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Red Curacao');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Orange Gin');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Orange Juice');
- INSERT INTO "UserIngredient" VALUES ('Kevin', 'Rum');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Orange');
- INSERT INTO "UserIngredient" VALUES ('Kevin', 'Lemon Juice');
- INSERT INTO "UserIngredient" VALUES ('Andy', 'Whiskey');
- INSERT INTO "UserIngredient" VALUES ('Kevin', 'Lime Juice');
- INSERT INTO "UserIngredient" VALUES ('Kevin', 'Vodka');