Hello, I'm trying to find and correct some problems in a database, one of them is the missing of foreign keys. I use different tools, one of them is schema spy, but there was some inconsistency between the tools, schema spy was telling me that there was a foreign key constraint and other tools where telling me that there wasn't. Then I discovered that schema spy inferred those relations, because isam engine has no foreign keys relations, but the innodb has them. Is it possible to configure schema spy to stick to the database schema without inferring relations, which aren't defined in the database?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello, I'm trying to find and correct some problems in a database, one of them is the missing of foreign keys. I use different tools, one of them is schema spy, but there was some inconsistency between the tools, schema spy was telling me that there was a foreign key constraint and other tools where telling me that there wasn't. Then I discovered that schema spy inferred those relations, because isam engine has no foreign keys relations, but the innodb has them. Is it possible to configure schema spy to stick to the database schema without inferring relations, which aren't defined in the database?