code

For Some Reason ever time I try to create a Foreign Key I keep getting the “unable to create foreign key constraint” error in mysql yet the parent and it are both the exact same type.

I’ve tried adding the key later with Alter table, removing primary key constraint from both, one then the other, assigned the unsigned constraint and removed it to no avail.

I feel really dumb at the moment as I’ve seen from past work I was able to add them the exact same way with no issues so not sure what exactly has changed.