If MySQL reports an error number 1005 from a CREATE TABLE statement, and the error message refers to error 150, table creation failed because a foreign key constraint was not correctly formed. Similarly, if an ALTER TABLE fails and it refers to error 150, that means a foreign key definition would be .
Error: 1005 SQLSTATE: HY000 (ER_CANT_CREATE_TABLE)
Message: Can’t create table ‘%s’ (errno: %d)
For any query or issue, feel free to discuss on http://discuss.eduguru.in