I am selling my collection of more than 7000 recipes database with picture included most of the recipes have pictures....
for only $50 each copy
demo site:http://www.recipeathome.info
database structure
CREATE TABLE `addrecipe` (
`recipeid` int(3) NOT NULL auto_increment,
`reccat` text,
`recsubcat` varchar(255) default NULL,
`rectitle` text,
`recing` text,
`rectext` text,
`recpic` varchar(255) NOT NULL default '',
`recactivation` int(3) default '0',
`recaddedby` varchar(255) default NULL,
`recrating` int(3) default '0',
PRIMARY KEY (`recipeid`),
UNIQUE KEY `recipeid` (`recipeid`),
KEY `recipeid_2` (`recipeid`),
FULLTEXT KEY `reccat` (`reccat`,`recsubcat`,`rectitle`,`rectext`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7328 ;
--
-- Table structure for table `dd_categories`
--
CREATE TABLE `dd_categories` (
`CategoryName` varchar(100) NOT NULL default '',
`CategoryID` bigint(20) NOT NULL auto_increment,
PRIMARY KEY (`CategoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
for only $50 each copy
demo site:http://www.recipeathome.info
database structure
CREATE TABLE `addrecipe` (
`recipeid` int(3) NOT NULL auto_increment,
`reccat` text,
`recsubcat` varchar(255) default NULL,
`rectitle` text,
`recing` text,
`rectext` text,
`recpic` varchar(255) NOT NULL default '',
`recactivation` int(3) default '0',
`recaddedby` varchar(255) default NULL,
`recrating` int(3) default '0',
PRIMARY KEY (`recipeid`),
UNIQUE KEY `recipeid` (`recipeid`),
KEY `recipeid_2` (`recipeid`),
FULLTEXT KEY `reccat` (`reccat`,`recsubcat`,`rectitle`,`rectext`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7328 ;
--
-- Table structure for table `dd_categories`
--
CREATE TABLE `dd_categories` (
`CategoryName` varchar(100) NOT NULL default '',
`CategoryID` bigint(20) NOT NULL auto_increment,
PRIMARY KEY (`CategoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;






