Jump to content

Archived

This topic is now archived and is closed to further replies.

fr@nkie

MySQL Query Browser 1.2.4 Beta Problem

Recommended Posts

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
);

Share this post


Link to post
Share on other sites
Just like the other thread... probably a permission issue.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.