From: Gerald L. Clark (gerald_clarksuppliersystems.com)
Date: Mon Mar 16 2009 - 13:24:05 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Octavian Râºniþã wrote:
> Hello,
>
> I've tried to create these 4 test tables, but when I try to create the last
> one, MySQL gives the following error:
>
> ERROR 1005 (HY000) at line 20: Can't create table '.\z\favorite_link.frm'
> (errno
> : 150)
>
> It seems that the foreign keys are not created well in the fourth table, and
> I don't know why.
> Does anyone have any idea?
>
> Here are the SQL statements for creating these tables:
>
> create table if not exists user(
> id int unsigned not null auto_increment primary key
> ) engine=InnoDB;
>
> create table if not exists favorite(
> id bigint unsigned not null auto_increment primary key,
> user int unsigned not null,
> foreign key(user) references user(id) on update cascade on delete cascade
> ) engine=InnoDB;
>
> create table if not exists link(
> id bigint unsigned not null auto_increment primary key,
> user int unsigned not null,
> foreign key(user) references user(id) on update cascade on delete cascade
> ) engine=InnoDB;
>
> create table if not exists favorite_link(
> favorite bigint unsigned not null,
> link int unsigned not null,
> primary key pri(favorite, link),
> foreign key(favorite) references favorite(id) on update cascade on delete
> cascade,
> foreign key(link) references link(id) on update cascade on delete cascade
> ) engine=InnoDB;
>
> Thank you very much.
>

link int unsigned not null,
id bigint unsigned not null auto_increment primary key

These are not the same type.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]