CODEWITHSUNDEEP
wordpressreverse-engineeringerd
David Garcia
David Garcia

Reputation: 2696

Wordpress: Reverse engineer MySQL

Guys i reversed engineered a wordpress database to EER diagram in hope of seeing some relationships but it seems the tables arent linked?

I also reversed engineered to visio and to MySQL Workbench but i get the same result an EER diagram without relationships? if someone knows the reason for this please explain

Upvotes: 0

Views: 329

Answers (1)

Mike Sherrill 'Cat Recall'
Mike Sherrill 'Cat Recall'

Reputation: 95731

That's a WAD. ("Works as designed".)

Please note that within the standard installation of WordPress no integrity between the tables is enforced e.g. between posts and comments. If you are creating a plugin or extension that manipulates the WordPress database, your code should do the housekeeping so that no orphan records remain in the tables e.g. by removing records in other tables with a set of SQL commands when foreign keys are deleted (Don't forget to remind users to backup before such operations).

Reference

WordPress uses the MyISAM engine. MyISAM doesn't enforce foreign key constraints anyway.

Upvotes: 3

Related Questions