Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 8th, 2012  |  syntax: None  |  size: 5.36 KB  |  hits: 15  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. -- ----------------------------
  2. -- Test Data
  3. -- ----------------------------
  4. INSERT INTO "Ingredient" VALUES ('Vodka');
  5. INSERT INTO "Ingredient" VALUES ('Rum');
  6. INSERT INTO "Ingredient" VALUES ('Sherry');
  7. INSERT INTO "Ingredient" VALUES ('Whiskey');
  8. INSERT INTO "Ingredient" VALUES ('Cherry');
  9. INSERT INTO "Ingredient" VALUES ('Orange');
  10. INSERT INTO "Ingredient" VALUES ('Olive');
  11. INSERT INTO "Ingredient" VALUES ('Gin');
  12. INSERT INTO "Ingredient" VALUES ('Lemon Juice');
  13. INSERT INTO "Ingredient" VALUES ('Orange Gin');
  14. INSERT INTO "Ingredient" VALUES ('Sweet Vermouth');
  15. INSERT INTO "Ingredient" VALUES ('7-Up');
  16. INSERT INTO "Ingredient" VALUES ('Cranberry Juice');
  17. INSERT INTO "Ingredient" VALUES ('Dekuyper Razzmatazz');
  18. INSERT INTO "Ingredient" VALUES ('Orange Juice');
  19. INSERT INTO "Ingredient" VALUES ('Sour Mix');
  20. INSERT INTO "Ingredient" VALUES ('Dry Cider');
  21. INSERT INTO "Ingredient" VALUES ('Lager');
  22. INSERT INTO "Ingredient" VALUES ('Sloe Gin');
  23. INSERT INTO "Ingredient" VALUES ('Southern Comfort');
  24. INSERT INTO "Ingredient" VALUES ('Triple Sec');
  25. INSERT INTO "Ingredient" VALUES ('Blue Curacao');
  26. INSERT INTO "Ingredient" VALUES ('Lime Juice');
  27. INSERT INTO "Ingredient" VALUES ('Red Curacao');
  28. INSERT INTO "Ingredient" VALUES ('Tequila');
  29. INSERT INTO "Recipe" VALUES ('Leap Year Cocktail');
  30. INSERT INTO "Recipe" VALUES ('Purple Gecko');
  31. INSERT INTO "Recipe" VALUES ('Slow Comfortable Screw In Between the Sheets');
  32. INSERT INTO "Recipe" VALUES ('Snakebite (UK)');
  33. INSERT INTO "Recipe" VALUES ('Stoner Delight');
  34. INSERT INTO "Recipe" VALUES ('Vodka');
  35. INSERT INTO "Recipe" VALUES ('Tequila');
  36. INSERT INTO "Recipe" VALUES ('Whiskey');
  37. INSERT INTO "RecipeIngredient" VALUES ('Leap Year Cocktail', 'Lemon Juice');
  38. INSERT INTO "RecipeIngredient" VALUES ('Leap Year Cocktail', 'Gin');
  39. INSERT INTO "RecipeIngredient" VALUES ('Leap Year Cocktail', 'Orange Gin');
  40. INSERT INTO "RecipeIngredient" VALUES ('Leap Year Cocktail', 'Sweet Vermouth');
  41. INSERT INTO "RecipeIngredient" VALUES ('Purple Gecko', 'Blue Curacao');
  42. INSERT INTO "RecipeIngredient" VALUES ('Purple Gecko', 'Cranberry Juice');
  43. INSERT INTO "RecipeIngredient" VALUES ('Purple Gecko', 'Lime Juice');
  44. INSERT INTO "RecipeIngredient" VALUES ('Purple Gecko', 'Red Curacao');
  45. INSERT INTO "RecipeIngredient" VALUES ('Purple Gecko', 'Sour Mix');
  46. INSERT INTO "RecipeIngredient" VALUES ('Purple Gecko', 'Tequila');
  47. INSERT INTO "RecipeIngredient" VALUES ('Slow Comfortable Screw In Between the Sheets', 'Orange Juice');
  48. INSERT INTO "RecipeIngredient" VALUES ('Slow Comfortable Screw In Between the Sheets', 'Sloe Gin');
  49. INSERT INTO "RecipeIngredient" VALUES ('Slow Comfortable Screw In Between the Sheets', 'Southern Comfort');
  50. INSERT INTO "RecipeIngredient" VALUES ('Slow Comfortable Screw In Between the Sheets', 'Triple Sec');
  51. INSERT INTO "RecipeIngredient" VALUES ('Slow Comfortable Screw In Between the Sheets', 'Vodka');
  52. INSERT INTO "RecipeIngredient" VALUES ('Snakebite (UK)', 'Dry Cider');
  53. INSERT INTO "RecipeIngredient" VALUES ('Snakebite (UK)', 'Lager');
  54. INSERT INTO "RecipeIngredient" VALUES ('Stoner Delight', '7-Up');
  55. INSERT INTO "RecipeIngredient" VALUES ('Stoner Delight', 'Cranberry Juice');
  56. INSERT INTO "RecipeIngredient" VALUES ('Stoner Delight', 'Dekuyper Razzmatazz');
  57. INSERT INTO "RecipeIngredient" VALUES ('Stoner Delight', 'Orange Juice');
  58. INSERT INTO "RecipeIngredient" VALUES ('Stoner Delight', 'Sour Mix');
  59. INSERT INTO "RecipeIngredient" VALUES ('Stoner Delight', 'Vodka');
  60. INSERT INTO "RecipeIngredient" VALUES ('Vodka', 'Vodka');
  61. INSERT INTO "RecipeIngredient" VALUES ('Tequila', 'Tequila');
  62. INSERT INTO "RecipeIngredient" VALUES ('Whiskey', 'Whiskey');
  63. INSERT INTO "User" VALUES ('Kevin');
  64. INSERT INTO "User" VALUES ('Andy');
  65. INSERT INTO "UserIngredient" VALUES ('Kevin', 'Orange Juice');
  66. INSERT INTO "UserIngredient" VALUES ('Andy', 'Rum');
  67. INSERT INTO "UserIngredient" VALUES ('Kevin', 'Blue Curacao');
  68. INSERT INTO "UserIngredient" VALUES ('Kevin', 'Sour Mix');
  69. INSERT INTO "UserIngredient" VALUES ('Kevin', '7-Up');
  70. INSERT INTO "UserIngredient" VALUES ('Andy', 'Lemon Juice');
  71. INSERT INTO "UserIngredient" VALUES ('Kevin', 'Cherry');
  72. INSERT INTO "UserIngredient" VALUES ('Kevin', 'Dry Cider');
  73. INSERT INTO "UserIngredient" VALUES ('Andy', 'Sweet Vermouth');
  74. INSERT INTO "UserIngredient" VALUES ('Andy', 'Blue Curacao');
  75. INSERT INTO "UserIngredient" VALUES ('Kevin', 'Sherry');
  76. INSERT INTO "UserIngredient" VALUES ('Andy', 'Tequila');
  77. INSERT INTO "UserIngredient" VALUES ('Kevin', 'Red Curacao');
  78. INSERT INTO "UserIngredient" VALUES ('Andy', 'Sherry');
  79. INSERT INTO "UserIngredient" VALUES ('Kevin', 'Sweet Vermouth');
  80. INSERT INTO "UserIngredient" VALUES ('Andy', 'Olive');
  81. INSERT INTO "UserIngredient" VALUES ('Andy', 'Dekuyper Razzmatazz');
  82. INSERT INTO "UserIngredient" VALUES ('Andy', 'Lime Juice');
  83. INSERT INTO "UserIngredient" VALUES ('Andy', 'Lager');
  84. INSERT INTO "UserIngredient" VALUES ('Kevin', 'Sloe Gin');
  85. INSERT INTO "UserIngredient" VALUES ('Andy', 'Southern Comfort');
  86. INSERT INTO "UserIngredient" VALUES ('Andy', 'Red Curacao');
  87. INSERT INTO "UserIngredient" VALUES ('Andy', 'Orange Gin');
  88. INSERT INTO "UserIngredient" VALUES ('Andy', 'Orange Juice');
  89. INSERT INTO "UserIngredient" VALUES ('Kevin', 'Rum');
  90. INSERT INTO "UserIngredient" VALUES ('Andy', 'Orange');
  91. INSERT INTO "UserIngredient" VALUES ('Kevin', 'Lemon Juice');
  92. INSERT INTO "UserIngredient" VALUES ('Andy', 'Whiskey');
  93. INSERT INTO "UserIngredient" VALUES ('Kevin', 'Lime Juice');
  94. INSERT INTO "UserIngredient" VALUES ('Kevin', 'Vodka');