Re: AW: Re: Schema definition fails when converted to InnoDB

2003-04-04 Thread Ian Hartas
Thorsten, This is right, but on these columns has to be an index set on before you can create foreign keys with innodb. So, create the indexes and AFTER that the foreign keys and it should work : ) Thanks for the clarification ! However, moving the foreign key definitions after the table and

AW: AW: Re: Schema definition fails when converted to InnoDB

2003-04-04 Thread Thorsten Schmidt
-Ursprüngliche Nachricht- Von: Ian Hartas [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 4. April 2003 12:33 An: Thorsten Schmidt Cc: [EMAIL PROTECTED] Betreff: Re: AW: Re: Schema definition fails when converted to InnoDB Thorsten, This is right, but on these columns has

Re: AW: Re: Schema definition fails when converted to InnoDB

2003-04-04 Thread Peter Brawley
, 2003 4:41 AM Subject: AW: AW: Re: Schema definition fails when converted to InnoDB -Ursprüngliche Nachricht- Von: Ian Hartas [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 4. April 2003 12:33 An: Thorsten Schmidt Cc: [EMAIL PROTECTED] Betreff: Re: AW: Re: Schema