Re: can´t register more than one FK per table, why?

[Joao Galli]

After creating one of the FKs,
I create the second like this:

ALTER TABLE `topassist`.`ordem_servico` ADD CONSTRAINT `FK_ordem_servico_2` FOREIGN KEY `FK_ordem_servico_2` (`tecnico_fk`)
REFERENCES `tecnico` (`id`)
ON DELETE RESTRICT
ON UPDATE RESTRICT;

and the error I get:

Mysql Error Number 1005
Can´t create table '.\topassist\#sql-6a8_1.frm' (errno : 150)


What can it be?