|
|
Posted by Fernand St-Georges on 06/28/05 22:20
Because you are in MySql
"blumi" <test@me.com> a ιcrit dans le message de news:
d9roip$m29$1@news.net.uni-c.dk...
>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??
>
>
[Back to original message]
|