no relationships shown
Brought to you by:
johncurrier
Menu
▾
▴
#122 no relationships shown
I am using SchemaSpy 5.0.0 on Debian Squeeze and MySQL 5.1.49-1. Everything is great as usual, but I get the message that no relationships are detected. This used to work with the same realtionship definitions (i.e. foreign key specifications) formerly. Also, I am ABSOLUTELY sure that I didn't change ANY table definitions lately. I do use lots of foreign key relations, however I do not give those explicit names. Any hints why things might not work anymore? Thanks in advance
If you're using MyISAM as the MySQL database engine then there are no real foreign key relationships and SchemaSpy will not be able to do anything other than derive implied relationships based on naming conventions (or via XML). InnoDB fully supports foreign key relationships.
John
I assume you figured out what was causing the issue. As far as I can tell not giving the foreign keys explicit names shouldn't have any impact since they should end up with generated names.
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).