Re: SOLVED: Re: Foreign Key Issue

2009-03-26 Thread Claudio Nanni
I had the same problem and was going crazy, the ket/foreign key fields must be exactly the same. I 'forward' engineered the database with MySQL Workbench and was almost posting a bug! Cheers Claudio 2009/3/26 John Daisley > Sorry all, I was being a dummy! Missed the unsigned attribute off th

SOLVED: Re: Foreign Key Issue

2009-03-26 Thread John Daisley
Sorry all, I was being a dummy! Missed the unsigned attribute off the foreign key columns on the problem tables. Regards > Hi, > > I have the script below to create 5 tables. Three of them create fine but > two return an error of 150 which I understand to be a foreign key issue, > however I can'