MySQL Query Browser 1.2.4 Beta Problem

[fr@nkie]

Hi. I would like to now what's wrong with my SQL command. I don't understand.

The error is -> "Can't create table'.\lousada\associacoes.frm' (errno: 150)  ErrorNr.1005"

Thank so much :)

CREATE TABLE Associacoes(
id_patrimonio1 INTEGER,
id_patrimonio2 INTEGER,
observacoes VARCHAR(255),
CONSTRAINT chave_primaria_associacao
PRIMARY KEY (id_patrimonio1,id_patrimonio2),
CONSTRAINT chave_estrangeira_id_patrimonio1
FOREIGN KEY (id_patrimonio1)
REFERENCES Patrimonio (id_patrimonio)
ON UPDATE CASCADE
ON DELETE SET NULL,
CONSTRAINT chave_estrangeira_id_patrimonio2
FOREIGN KEY (id_patrimonio2)
REFERENCES Patrimonio (id_patrimonio)
ON UPDATE CASCADE
ON DELETE SET NULL
);

[fenway]

Just like the other thread... probably a permission issue.