|
|
Posted by blumi on 06/28/05 18:00
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??
Navigation:
[Reply to this message]
|