#2319 (ok 2.11) Foreign keys spanning multiple columns

[Sven Neuhaus]

I have a table with an index spanning 3 columns which is a foreign keys. phpmyadmin wrongly shows this as a single column foreign key on the table relations page ( tbl_relation.php ).

I understand phpmyadmin does not yet support foreign keys for multi-column indexes (FAQ 3.6) but it should not display them at all instead of incorrectly.

Any idea when support for FAQ 3.6 will be added?

Thanks!

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

Ok, not displaying them is an easy fix. However I would like to add support for multi-column indexes in tbl_relation (and maybe in the new Designer module of 2.10) but I would like your input.

Visually, I don't see how to enable this feature in Relation view. I could add some input boxes where one can enter the two list of fields.

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

Any feedback please?

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

Those keys are now not displayed at all.