Jump to content


Photo

MySQL Query Browser 1.2.4 Beta Problem


  • Please log in to reply
1 reply to this topic

#1 fr@nkie

fr@nkie
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 26 October 2006 - 03:13 PM

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

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 26 October 2006 - 05:45 PM

Just like the other thread... probably a permission issue.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users