Drink Recipes SQL Database Dump for MySQL, Microsoft Access and Oracle

Preview
CREATE TABLE `drink` (
  `id` int(5) NOT NULL auto_increment,
  `title` varchar(64) NOT NULL default '',
  `keywords` varchar(255) NOT NULL default '',
  `content` varchar(255) NOT NULL default '',
  `cat` varchar(64) NOT NULL default '',
  `subcat` varchar(64) NOT NULL default '',
  `ingredients` text NOT NULL,
  `method` text NOT NULL,
  `serve` varchar(64) NOT NULL default '',
  `nutriinfo` text NOT NULL,
  `visible` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=9034 ;

INSERT INTO `drink` VALUES (1, '57 Chevy recipe', '57 chevy, 57, chevy, vodka, southern comfort&amp;reg; peach liqueur, grand marnier&amp;reg; orange liqueur, pineapple juice, drink recipe, drink, recipe, alcoholic drink recipe, cocktail recipe, cocktail, mixed drink, martini', 'A delicious recipe for 57 Chevy, with vodka, Southern Comfort&amp;reg; peach liqueur, Grand Marnier&amp;reg; orange liqueur and pineapple juice. Also lists similar drink recipes.', 'Cocktails', 'Short drinks', '1/2 oz vodka<br>1 1/2 oz Southern Comfort&reg; peach liqueur<br>1/2 oz Grand Marnier&reg; orange liqueur<br> fill with pineapple juice<br></p><br>', 'Shake and serve.', 'Cocktail Glass', '(per 3 oz serving)</div><table  cellspacing="1" cellpadding="0" border="0" width="395"><tr><td valign="top" width="135"><p >Calories (kcal)<br>Energy (kj)<br>Fats<br>Carbohydrates<br>Protein<br></p></td><td valign="top"><p >178<br>748<br>0 g<br>9.6 g<br>0.1 g<br></p></td><td valign="top" width="135"><p >Fiber<br>Sugars<br>Cholesterol<br>Sodium<br>Alcohol<br></p></td><td valign="top"><p >0 g<br>-<br>0 mg<br>-<br>26.2 g<br></p></td></tr></table>', 1);
INSERT INTO `drink` VALUES (2, 'A Little Dinghy recipe', 'a little dinghy, a, little, dinghy, captain morgan&amp;reg; parrot bay coconut rum, malibu&amp;reg; coconut rum, cranberry juice, pineapple juice, orange juice, drink recipe, drink, recipe, alcoholic drink recipe, cocktail recipe, cocktail, mixed drink, m', 'A delicious recipe for A Little Dinghy, with Captain Morgan&amp;reg; Parrot Bay coconut rum, Malibu&amp;reg; coconut rum, cranberry juice, pineapple juice and orange juice. Also lists similar drink recipes.', 'Cocktails', 'Long drinks', '2 shots Captain Morgan&reg; Parrot Bay coconut rum<br>2 shots Malibu&reg; coconut rum<br> cranberry juice<br> pineapple juice<br> orange juice<br></p><br>', 'Pour the shots into a glass of ice, and fill the glass with equal parts orange juice, cranberry juice, and pineapple juice. Ga
To view the full dump, please login
SQL database dumps

Drink Recipes

Navigation

Popular databases
