self-relationship innodb
Sorry, my english is so bad! So, I can`t do that on innodb:

create table user (
id_user tinyint(3) not null auto_increment,
name char(30),
primary key (id_user)
index (id_user)
);

create table subordinated (
id_manager tinyint(3) not null,
id_sub tinyint(3) not null,
primary key (id_manager, id_sub),
index (id_manager, id_sub),
foreign key (id_manager, id_sub)
references user (id_user, id_user) ????????
on update cascade on delete restrict
);

thanks,

Dirceu - Brazil