database structure
CREATE TABLE `recipes` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`category` varchar(100) NOT NULL default '',
`incredients` text NOT NULL,
`procedures` text NOT NULL,
`score` int(11) NOT NULL default '0',
`imagepath` varchar(255) NOT NULL default '',
`notes` varchar(255) NOT NULL default '',
`status` varchar(15) NOT NULL default 'Active',
PRIMARY KEY (`id`),
FULLTEXT KEY `title` (`title`,`category`,`incredients`,`procedures`)
) TYPE=MyISAM AUTO_INCREMENT=4242 ;
--
-- Dumping data for table `recipes`
--
INSERT INTO `recipes` VALUES (4021, 'Zucchini Crisp', 'Pies_And_Pastries', '1/2 cup butter or margarine\r\n1/4 cup brown sugar, firmly packed\r\n1/4 cup granulated sugar\r\n1 cup flour\r\n4 cups peeled, cored and sliced zucchini\r\n1/2 cup lemon juice\r\n1/2 teaspoon nutmeg\r\n1 teaspoon cinnamon\r\n3/4 cup granulated sugar', 'Cut butter into brown sugar, the 1/4 cup granulated sugar and flour until the mixture resembles coarse crumbs; set aside.\r\n\r\nCook zucchini and lemon juice for 20 minutes over medium heat. Drain, then add nutmeg, cinnamon and the 3/4 cup granulated sugar. Pour batter into a greased 9 x 13-inch pan and bake at 350 degrees F for 30 minutes. Remove from the oven and sprinkle the crumb mixture over the top. Return to oven and bake for another 10 to 15 minutes, or until brown. It will crisp as it cools.', 0, '', '', 'Active');
INSERT INTO `recipes` VALUES (4022, 'Anchovy Pasta', 'Pasta', '10 anchovy filets (rinse well if packed in salt)\r\n1 red onion, chopped very fine\r\nOlive oil (enough to cover onions and anchovies in saut� pan)\r\n8 ounces dry spaghetti', 'Saut� the chopped onions in olive oil until golden, making sure there is enough oil to fully cover onions.\r\n\r\nWhile pasta is cooking in lightly salted water, gently add the anchovy filets to onions and press lightly with a fork until the anchovies are well mixed with the saut�ing onions.\r\n\r\nToss spaghetti and anchovy mix together and ensure the spaghetti is well coated. Serve immediately.', 0, '', '', 'Active');