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&reg; peach liqueur, grand marnier&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&reg; peach liqueur, Grand Marnier&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® peach liqueur<br>1/2 oz Grand Marnier® 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&reg; parrot bay coconut rum, malibu&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&reg; Parrot Bay coconut rum, Malibu&reg; coconut rum, cranberry juice, pineapple juice and orange juice. Also lists similar drink recipes.', 'Cocktails', 'Long drinks', '2 shots Captain Morgan® Parrot Bay coconut rum<br>2 shots Malibu® 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. Garnish with a pineapple wedge, an orange slice, and an umbrella.', 'Highball Glass', '', 1);
INSERT INTO `drink` VALUES (3, 'Bad Habit recipe', 'bad habit, bad, habit, skyy&reg; vodka, peach schnapps, drink recipe, drink, recipe, alcoholic drink recipe, cocktail recipe, cocktail, mixed drink, martini', 'A delicious recipe for Bad Habit, with Skyy&reg; vodka and peach schnapps. Also lists similar drink recipes.', 'Shots & Shooters', 'by base-ingredient', '1/2 oz Skyy® vodka<br>1/2 oz peach schnapps<br></p><br>', 'Combine in a shot glass, vodka first.', 'Shot Glass', '(per 1 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 >71<br>297<br>0 g<br>3.3 g<br>0 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>3.3 g<br>0 mg<br>0 mg<br>8.9 g<br></p></td></tr></table>', 1);