Columns and foreign keys

[random1]

I have two columns on two seperate tables that are IDs, one is primary and the other is not primary.

 

`version_id` BIGINT(50) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'The ID of the Version'

 

`versionchange_version_id` BIGINT(50) UNSIGNED NOT NULL COMMENT 'The Name of the Version ID'

 

When I try to create a FK relationship I get the error:

 

/* SQL Error (1452): Cannot add or update a child row: a foreign key constraint fails (`webman`.<result 2 when explaining filename '#sql-704_8'>, CONSTRAINT `FK_version_change_version` FOREIGN KEY (`versionchange_version_id`) REFERENCES `version` (`version_id`)) */

 

To set up a foreign key relationship do both fields need to be AUTO_INCREMENT?

 

I am using InnoDB with the latest version of MySQL if that makes any difference.

[ignace]

No, a FK does not need the AUTO_INCREMENT attribute. And why do you use BIGINT?? Did you create the PK first before creating the FK?

[random1]

Yes I created the PK first.

 

The BIGINT supports my efforts for 32-bit and 64-bit compatability.

[Mchl]

The BIGINT supports my efforts for 32-bit and 64-bit compatability.

 

How exactly?