Author : None
Price : $9.5
Rights : None
Category : Databases
Share with a friend

Are you looking for a drink recipes that you can use for you new drink recipe site?

Buy them now and instantly you have your site full of great drink recipes, rather than starting from scratch which takes you months or even year to build this big of drink recipe database.

Here are the structures:

Recipe # 1
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 ;

Recipe #2
CREATE TABLE `categories` (
`categoryid` int(10) unsigned NOT NULL default '0',
`category` varchar(100) default NULL,
PRIMARY KEY (`categoryid`),
UNIQUE KEY `categoryid` (`categoryid`),
KEY `categoryid_2` (`categoryid`)
) TYPE=MyISAM;

CREATE TABLE `drinks` (
`drinkid` int(10) unsigned NOT NULL default '0',
`title` varchar(255) default NULL,
`directions` text,
`userid` int(10) unsigned default NULL,
`rating` int(10) unsigned default '0',
`categoryid` int(10) unsigned default NULL,
`date` varchar(20) NOT NULL default '',
`story` text,
`hits` int(10) unsigned default '0',
`status` char(1) default 'W',
PRIMARY KEY (`drinkid`),
UNIQUE KEY `recipieid` (`drinkid`),
KEY `recipieid_2` (`drinkid`)
) TYPE=MyISAM;



Samples:

Recipe #1

INSERT INTO `drink` VALUES (1, '57 Chevy recipe', '57 chevy, 57, chevy, vodka, southern comfort® peach liqueur, grand marnier® 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® peach liqueur, Grand Marnier® orange liqueur and pineapple juice. Also lists similar drink recipes.', 'Cocktails', 'Short drinks', '1/2 oz vodka
1 1/2 oz Southern Comfort® peach liqueur
1/2 oz Grand Marnier® orange liqueur
 fill with pineapple juice

', 'Shake and serve.', 'Cocktail Glass', '(per 3 oz serving)
Calories (kcal)
Energy (kj)
Fats
Carbohydrates
Protein
178
748
0 g
9.6 g
0.1 g
Fiber
Sugars
Cholesterol
Sodium
Alcohol
0 g
-
0 mg
-
26.2 g
', 1);

INSERT INTO `drink` VALUES (2, 'A Little Dinghy recipe', 'a little dinghy, a, little, dinghy, captain morgan® parrot bay coconut rum, malibu® 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® Parrot Bay coconut rum, Malibu® 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
2 shots Malibu® coconut rum
 cranberry juice
 pineapple juice
 orange juice

', '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® vodka, peach schnapps, drink recipe, drink, recipe, alcoholic drink recipe, cocktail recipe, cocktail, mixed drink, martini', 'A delicious recipe for Bad Habit, with Skyy® vodka and peach schnapps. Also lists similar drink recipes.', 'Shots & Shooters', 'by base-ingredient', '1/2 oz Skyy® vodka
1/2 oz peach schnapps

', 'Combine in a shot glass, vodka first.', 'Shot Glass', '(per 1 oz serving)
Calories (kcal)
Energy (kj)
Fats
Carbohydrates
Protein
71
297
0 g
3.3 g
0 g
Fiber
Sugars
Cholesterol
Sodium
Alcohol
0 g
3.3 g
0 mg
0 mg
8.9 g
', 1);

INSERT INTO `drink` VALUES (4, 'A Clockwork Tangerine recipe', 'a clockwork tangerine, a, clockwork, tangerine, sprite® soda, kool-aid® tangerine mix, bacardi® gold rum, smirnoff® vodka, drink recipe, drink, recipe, alcoholic drink recipe, cocktail recipe, cocktail, mixed drink, martini', 'A delicious recipe for A Clockwork Tangerine, with Sprite® soda, Kool-Aid® Tangerine mix, Bacardi® gold rum and Smirnoff® vodka. Also lists similar drink recipes.', 'Cocktails', 'Long drinks', '12 oz Sprite® soda
1 packet Kool-Aid® Tangerine mix
1 oz Bacardi® gold rum
1 oz Smirnoff® vodka

', 'Combine all ingredients in a beef pilsner. Stir together, and serve.', 'Beer Pilsner', '', 1);

INSERT INTO `drinks` VALUES (4, 'Papa Smurf', 'Mix and chill vodka and kool-aid. Crush blue popsicle and add to mixture. The crushed popsicle should settle at the bottom of drink, making it appear as a blue layer at the bottom and a red layer on top. \r\n
\r\n', 0, 5, 1, '10/13/2004', '', 189, 'L');

INSERT INTO `drinks` VALUES (3, 'Zombie', 'Shake all ingredients (except 151-proof rum) with ice and strain into a collins glass over ice cubes. Float the 151-proof rum on top, add a cherry (if desired), and serve.', 0, 2, 1, '10/13/2004', '', 37, 'L');

INSERT INTO `drinks` VALUES (5, 'Prairie Fire', 'Fill a shot glass with tequila and drop a dash of tabasco sauce in and around the edge.\r\n
\r\n', 0, 0, 6, '10/13/2004', '', 36, 'L');

INSERT INTO `drinks` VALUES (6, 'After Eight', 'In a sherry glass, pour 1/3 Tia-Maria, 1/3 Creme-de-menthe and 1/3 Baileys. DO NOT MIX. Serve.', 0, 0, 6, '10/13/2004', '', 53, 'L');