column types

[webgod]

I am tyring to figure out if I go the right column types here:

Table Menu
Menu_id - unique id
Menu_item - Menu Item
Menu_desc - Description of Item
Menu_price- Price
Menu_pict - optional picture (img src=blah.gif)
Menu_cat - category - refers to Table Category

Table Category
Cat_id - unique id
Cat_name - category name

I believe that it would be set up like this (are the types right? Do I need to add optional sizes?):

CREATE TABLE Menu (
Menu_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
Menu_item TINYTEXT NOT NULL,
Menu_desc TEXT NOT NULL,
Menu_price SMALLINT NOT NULL,
Menu_pict TINYTEXT NOT NULL,
Menu_cat TINYTEXT NOT NULL,
);

CREATE TABLE Category (
Cat_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
Cat_name TINYTEXT NOT NULL,
);

[Lars_Berg]

Use integer for menu_id and cat_id.

Menu_cat should be integer as well as it should be the same type as cat_id.

price decimal(8,2)