Re: ERROR 1005: Can't create table (errno: 150) - my SOLUTION

[Luca Porro]

hello, i am e newbie of mysql and i have this error in the creation of my tables...

# DROP TABLE IF EXISTS anagrafica ;

CREATE TABLE IF NOT EXISTS anagrafica(
id int(11) NOT NULL auto_increment,
id_cat int(11) UNSIGNED NOT NULL,
RagioneSociale varchar(100) NOT NULL,
Nazionalita varchar(3) NOT NULL default '',
Citta varchar(50) NOT NULL default '',
Indirizzo varchar(50) NOT NULL default '',
Telefono int(11) NOT NULL default '0',
DefStato varchar(50) default '',
PRIMARY KEY (id, id_cat)
) ENGINE=InnoDB;

# DROP TABLE IF EXISTS archivioemail;

CREATE TABLE IF NOT EXISTS archivioemail(
id_anag int(11) NOT NULL,
id_archivio int(11) NOT NULL default '0',
Referente varchar(100) NOT NULL default '',
Note varchar(250) NOT NULL default '',
email varchar(70) NOT NULL default '',
data date NOT NULL default '0000-00-00',
PRIMARY KEY (`id_anag`, `id_archivio`),
FOREIGN KEY (`id_anag`) REFERENCES `anagrafica`(`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB;

# DROP TABLE IF EXISTS categorie;

CREATE TABLE IF NOT EXISTS categorie(
`id_categorie` int(11) UNSIGNED NOT NULL,
`nome` varchar(20) NOT NULL default '',
PRIMARY KEY(`id_categorie`),
FOREIGN KEY (`id_categorie`) REFERENCES `anagrafica`(`id_cat`) ON DELETE CASCADE ON UPDATE CASCADE
)ENGINE=InnoDB;

my problem is in table categorie, i don't know how resolve this problem, in this string:
FOREIGN KEY (`id_categorie`) REFERENCES `anagrafica`(`id_cat`) ON DELETE CASCADE ON UPDATE CASCADE

help me.
thanks