phpMyAdmin - 188.8.131.52
MySQL client version: 3.23.49
Used PHP extensions: mysql
MySQL - 3.23.56-Max
Protocol version: 10
Server: Localhost via UNIX socket
Given InnoDB table "order_picture" with referential
constraints "(order) REFER foobar/orders(id);
(picture) REFER foobar/picture(id)" as reported
in "structure view".
In "relation view", both referenced columns show up
as "picture->id". This is wrong. Furthermore, it is
impossible to update the relations with this view
(otherwise constraints are duplicated). This problem
also impacts data insertion and update.
This problem does not prevent referential constraints
from working if they are managed through direct SQL.
But it prevents PMA from managing referencing tables.
This problem also occurs with all other databases and
tables on the same database server. It does not occur
on MySQL 4.x. However MySQL 3.23.56 is a legacy
production server that cannot be replaced at this