Author : Collection
Price : $7
Rights : Master Resale Rights
Category : mySQL database
Share to your friend

A huge collection of free recipes database in my sql format. You can used this free recipes to create your instant huge recipe website and offer free recipes to your customers.

The total recipe in the database is more than 41,000 recipes.

Here is the data structure of the database.


--
-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
`id` int(11) NOT NULL auto_increment,
`category` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
`id` bigint(20) NOT NULL auto_increment,
`recipeid` varchar(15) NOT NULL default '',
`poster` varchar(20) NOT NULL default '',
`site` varchar(255) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`comment` text NOT NULL,
`status` varchar(7) NOT NULL default 'active',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

-- --------------------------------------------------------

--
-- Table structure for table `rating`
--

CREATE TABLE IF NOT EXISTS `rating` (
`id` bigint(20) NOT NULL auto_increment,
`recipeid` varchar(15) NOT NULL default '',
`rating` double NOT NULL default '0',
`ip` varchar(25) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;

-- --------------------------------------------------------

--
-- Table structure for table `recipes`
--

CREATE TABLE IF NOT EXISTS `recipes` (
`id` bigint(11) NOT NULL auto_increment,
`Category` varchar(255) default NULL,
`Name` varchar(255) default NULL,
`Recipe` text,
`views` int(11) NOT NULL default '0',
`comments` int(11) NOT NULL default '0',
`addedby` varchar(25) NOT NULL default '',
`ratings` float NOT NULL default '0',
`recactivation` varchar(10) NOT NULL default '1',
PRIMARY KEY (`id`),
FULLTEXT KEY `Category` (`Category`,`Name`,`Recipe`),
FULLTEXT KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=41761 ;


Sample data entry

INSERT INTO `recipes` (`id`, `Category`, `Name`, `Recipe`, `views`, `comments`, `addedby`, `ratings`, `recactivation`) VALUES(120, 'Appetizers', 'Apricot & Cucumber Soup', '