One feature I would like to see is the ability to see on the designer, and on the Relations View, even if it is based on a global setting, all the valid index on other databases not the current one only. On my current project, we have a central InnoDB DB called basic_info, and each module implements a new DB and have tons of foreign keys references to this basic info. Right now I have to right the SQL everytime I want to add a new FK to this other DB, since it doesn't show on the dropdown menu on the "Relation View". Nor I can put these tables on the designer.
Is it possible? And if so, lem9, I'm willing to try to tackle this problem and do a patch for it. Just need some pointers, specially on the designer part.
Ok, did you look at the source code for Designer? I guess it would be easier to do it on the relation view. Maybe next to the "Choose field to display" dialog, add a drop-down with the database names to specify an additional database to look into.
As of version 4.3 the ability to add foreign keys to other databases on Relations View has been implemented.
I am not very sure about doing the same for the designer as it would get cluttered with a large number of tables from multiple databases.