On Friday 04 April 2003 12:19, Ian Hartas wrote:
> >You can't add constraints referencing indices that don't exist.
> >Create your indecies first.
>
> Constraints don't reference indexes, they reference columns.
> These columns exist. When the table type is MyISAM, the syntax
> is accepted. When
ED]
Sent: Friday, April 04, 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: [
> -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,
>
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
Gerald,
>You can't add constraints referencing indices that don't exist.
>Create your indecies first.
Constraints don't reference indexes, they reference columns.
These columns exist. When the table type is MyISAM, the syntax
is accepted. When it's InnoDB - it fails.
(
This schema was originall
On Thursday 03 April 2003 12:40, Ian Hartas wrote:
> >Description:
>
> I have a database schema .sql file which is accepted when run with
> MyISAM tables. If I change the tables to be type = InnoDB, then it fails
> with the error message:
>
> mysql -u ts -p hbs ERROR 1005 at line 54: Can'
You can't add constraints referencing indices that don't exist.
Create your indecies first.
Ian Hartas wrote:
Description:
I have a database schema .sql file which is accepted when run with MyISAM
tables. If I change the tables to be type = InnoDB, then it fails with the error
message
