enrror in foreign key reference

[F.Balicchia]

Hello i'd like to converte this DDL for mysql
ALTER TABLE MYTABLE_ROLE
       ADD  ( FOREIGN KEY (LOGIN)
                             REFERENCES MYTABLE_USER ) ;
------------
i wrote
ALTER TABLE MYTABLE_ROLE
        ADD FOREIGN KEY (LOGIN) REFERENCES MYTABLE_USER ;
by it return me this error.
#1005 - Can't create table '.\mydb\#sql-4b4_63.frm' 
(errno: 150).

I don't understand how i can resolve it.
thanks
--Filippo 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]