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 originally
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
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 it's
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 schema_mysql.sql
ERROR 1005 at line 54: Can't create table './hbs/#sql-34ef_f.frm' (errno:
-Ursprüngliche Nachricht-
Von: Ian Hartas [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 3. April 2003 11:40
An: [EMAIL PROTECTED]
Betreff: Schema definition fails when converted to InnoDB
Description:
I have a database schema .sql file which is accepted
when run
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
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 schema_mysql.sql
ERROR 1005 at