Re: ERROR 1005: Can't create table (errno: 150)

[Max Mir]

> create table test1 (pk_alias int not null auto_increment,
> primary key (pk_alias)) type=innodb;
>
> create table test2 (pk_alias2 int unsigned not null auto_increment,
> fk_test1 int not null, primary key (pk_alias2),
> foreign key (fk_test1) references test1(pk_alias)) type=innodb;

You need to add an index to fk_test1. Try

create table test2 (pk_alias2 int unsigned not null auto_increment,
fk_test1 int not null, primary key (pk_alias2), index(fk_test1),
foreign key (fk_test1) references test1(pk_alias)) type=innodb;