error message

[usemysql]

    I was trying to create a table using the statment below (I am using mysql version of 5.0.)but I instead I got this error message does anybody know why?please help...

 

 

mysql> create table dvd

    -> (dvdid int not null auto_increment primary key,

    -> title varchar(40) not null,

    -> rls YEAR not null,

    -> qnty int not null,

    -> TypeID varchar(4) not null,

    -> FormatID varchar(4) not null,

    -> RateID varchar(4) not null,

    -> StudioID varchar(4) not null,

    -> StatID varchar(4) not null,

    -> foreign key(TypeID) references movtype (TypeID),

    -> foreign key(FormatID) references format (FormatID),

    -> foreign key(RateID) references rating (RateID),

    -> foreign key(StudioID) references studio (StudioID),

    -> foreign key(StatID) references status (StatID)

    -> )ENGINE = INNODB;

ERROR 1005 (HY000): Can't create table '.\dvd_rentals\dvd.frm' (errno: 150)

mysql>

[skadet]

Are your other tables (movtype, format, rating, studio, status) also InnoDB?

[Wildbug]

1005 (ER_CANT_CREATE_TABLE)

 

Cannot create table. If the error message refers to errno 150, table creation failed because a foreign key constraint was not correctly formed. If the error message refers to errno -1, table creation probably failed because the table includes a column name that matched the name of an internal InnoDB table.