I tried to create a foreign key using:
ALTER TABLE msg_recipients ADD CONSTRAINT
msg_recipient_member_fk FOREIGN KEY
(recipient_member_id) REFERENCES members (id);
and got this error:
Can't create table '.\wapmagic\#sql-c50_48.frm'
(errno: 150)
Any ideas?
Thanx
Herman
__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
