I have a database that I built a while back. Every table in the database is InnoDb. Several tables had foreign key constraints, and I set them up for `On Delete = Cascade`. When I was using an earlier version of phpmyadmin, working with these was simple: I'd just go to the Structure tab of a table, click the Relation View link, and as long as I had the correct indexes set up on the correct columns, I could set the foreign keys as I saw fit.

Since upgrading to version 4, it's become a nightmare. For some tables, I go to the relation view and everything is just fine. But for others--even when they already have foreign key constraints set--I can't see any options for working with them.

To make matters worse, I've even tried dropping the indexes and re-adding them, only to be given the following error: `Cannot drop index [index_name]: needed in a foreign key constraint.` So unless I'm mistaken, the constraint is there, but phpmyadmin is refusing to show it to me.

Is there something I have to do to make them show up again? This is extremely frustrating to say the least: something that worked just fine before now does not thanks to an upgrade.