#1005 – Can’t create table ‘tbl_user’ (errno:105)
While we design ER model of our database (schema) , we get this common error . i was asked by many of my friends and colleagues about this issue.
first we have to check the tables for both primary tables and foreign tables ,if a Er table exists we have to check for both main tables have primary key are indexed are not.
This error causes mainly adding foreign key constraint without indexing primary keys.
primary and foreign keys must have same type.
Another this works with only innoDB engine only.