>I get this error when I try to create the following tables:
>
>
> ERROR 1005 (HY000): Can't create table '.\haps\transcript.frm' (errno:
> 150)
>
> create table teaching (
> ProfId int,
> CrsCode varchar(10),
> Semester varchar(10),
> primary key(ProfId, CrsCode, Semester)
> ) engine=InnoDB;
>
>
> create table transcript (
> StudId int,
> CrsCode varchar(10),
> Semester varchar(10),
> primary key(StudId, CrsCode, Semester),
> foreign key(CrsCode, Semester) references teaching(ProfId, CrsCode,
> Semester)
> ) engine=InnoDB;
>
> What am I doing wrong??
>
>