Enhancement: Compare DB with Filesystem for differences

[colinmo]

When the system loads, it should compare the filesystem schema to the database schema so that objects that differ can be highlighted.

[victorstanciu]

This sounds good, but it's not as simple as checking to see if there is any difference between two SQL commands. Different tools create different CREATE TABLE statements when exporting, so simply comparing the resulting SQL is not enough. The two CREATE TABLE commands have to actually be parsed and interpreted column by column, index by index, etc. I will look into existing tools to see what would be the best way of doing this.

[colinmo]

There are a few good tools like ADODB, Doctrine etc. that abstract database creates etc. into a common format regardless of DB language. http://adodb.sourceforge.net/tips_portable_sql.htm look up DDL or http://docs.doctrine-project.org/en/2.0.x/reference/tools.html look up Reverse Engineering.