Can't create foreign key to a table in another DB if the table has the same name
Database management in a single PHP file
Brought to you by:
jakubvrana
I found out that when I want to create a foreign key to a target table in another DB,
if the target table has the same name as a table in the source DB, the target fields I can choose from are the target fields of the table from the source DB and not the target DB - thus I cant create the foreign key.
see the attached screenshot
by the way, I use version 4.7.7
Last edit: Jakub Vrána 2021-02-07
Thanks for a good problem description, fixed.