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;

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. rn<BR>rn', 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.rn<BR>rn', 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');