Do you know why mysql fails creating this table? -

Do you know why mysql fails creating this table? -

maybe question silly... couln't found problem, when do:

create table prefixes ( id int(11) not null auto_increment, primary key(id), index id (id)) engine = innodb auto_increment = 1 default character set = utf8;

mysql says:

error 1005 (hy000): can't create table 'sms.prefixes' (errno: 150)

i though old foreign key or pointing/using table, did export (complete) , searched in export key "prefixes" , found nothing, no foreign key problem or something, if create same table naming "prefixes2" or else works!!! please if have clue maybe can helpful.

thanks!

try this:

create table `sms.prefixes` ( id int(11) not null auto_increment, primary key(id), index id (id)) engine = innodb auto_increment = 1 default character set = utf8;

sql fiddle demo

mysql