foreign key problem

[shwetha v]

Hi,
Am not able to create a child table with foreign key.

create table abc(sid varchar(10) not null, pid varchar(10) not null, name varchar(20), diagnosis varchar(15), date date, time time, primary key(sid, pid))type=innodb;

create table xyz(caseno varchar(10) not null, pid varchar(10) not null, pname varchar(20), age int, gender varchar(5), dob date, primary key(caseno, pid), foreign key(pid) references abc(pid) on delete cascade on update cascade)type=innodb;

I am not able to create table xyz with the foreign key. It is giving error like cant create table (errno:150).

Can anyone please help me out...... please..........

Thank you.