CREATE TABLE recipemenu_recipes ( recipe_id int(10) unsigned NOT NULL auto_increment, recipe_name VARCHAR(50) default '', recipe_author VARCHAR(100) default '', recipe_servings VARCHAR(100) default '', recipe_preptime VARCHAR(100) default '', recipe_ingredients text, recipe_body text, recipe_source text, recipe_nutrition text, recipe_category int(10) unsigned NOT NULL default '0', recipe_approved int(10) unsigned NOT NULL default '0', recipe_posted int(10) unsigned NOT NULL default '0', recipe_picture varchar(200) default '', recipe_views int(10) unsigned NOT NULL default '0', recipe_viewers text, recipe_unique int(10) unsigned NOT NULL default '0', PRIMARY KEY (recipe_id) ) TYPE=MyISAM; CREATE TABLE recipemenu_category ( recipe_category_id int(10) NOT NULL auto_increment, recipe_category_name VARCHAR(50) default NULL, recipe_category_description VARCHAR(250) default NULL, recipe_category_updated int(10) unsigned NOT NULL default '0', recipe_category_icon VARCHAR(50) default NULL, PRIMARY KEY (recipe_category_id) ) TYPE=MyISAM;