subject:"\[Maria\-discuss\] Problems with Foreign Key"

Re: [Maria-discuss] Problems with Foreign Key

2010-04-06 Thread Sergei Golubchik

Hi, Alexandre! On Mar 30, Alexandre Almeida wrote: > > Hi all, > > Any idea why I am getting this error: > > > A) ERROR > > ALTER TABLE login ADD CONSTRAINT fk_db_perfil FOREIGN KEY (id_perfil) > REFERENCES db_perfil (id_perfil) ON DELETE NO ACTION ON UPDATE NO ACTION; > ERROR 1005 (HY000):

[Maria-discuss] Problems with Foreign Key

2010-03-30 Thread Alexandre Almeida

Hi all, Any idea why I am getting this error: A) ERROR ALTER TABLE login-> ADD CONSTRAINT fk_db_perfil FOREIGN KEY (id_perfil)-> REFERENCES db_perfil (id_perfil)-> ON DELETE NO ACTION-> ON UPDATE NO ACTION;ERROR 1005 (HY000): Can't create table 'dbhomo_aa.#sql-c1f