Do you know why mysql fails creating this table? <p>maybe my question is silly... but i couln't found the problem, when i do:</p> <pre><code>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; </code></pre> <p>Mysql says:</p> <pre><code>ERROR 1005 (HY000): Can't create table 'sms.prefixes' (errno: 150) </code></pre> <p>i though that an old foreign key or something is pointing/using this table, but i did an export (complete) and searched in the export for the key "prefixes" and i found nothing, so no foreign key problem or something, if i create the same table BUT naming it "prefixes2" or some else IT WORKS!!! Please if someone have any clue maybe it can be helpful.</p> <p>Thanks!</p>