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
-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
, 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