Re: ERROR 1005: Can't create table (errno: 150) [Probable Solution]

[JOBY JOB]

Hi,

When I try to create a table with a reference to another table column, I am getting the following error:

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


Following is my SQL statement:

mysql> create table PhoneNumbers(user_id int(12), mobielnummer bigint(12), LandLineNummer bigint(12), FOREIGN KEY (user_id)
REFERENCES USERS(USER_ID) ON UPDATE CASCADE ON DELETE CASCADE);

Can some one help me on this?

Thanks,
Joby