`id` int unsigned not null primary key,
`name` varchar(45) not null,
`index` int unsigned not null default 0,
`parent_id` int unsigned,
constrainst foreignkey FK_menu__parent_id (parent_id)
references `menu` (`id`) on update cascade on delete cascade
) engine=INNODB;
[/sql]
Show, use GII to generate your model, with some small modifications, it will be fine.