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