to extract all the tables definitions.
We then strip the AUTO_INCREMENTS with SED:
The output is then hashed in order to check table version across different servers.
We realize that few time the comparison doesn't match because INDEX are dumped by: "indextype ASC, creation ASC" instead of "indextype ASC, indexname ASC".
So 2 identical table structure will be different just because a developer added an index before another. This is weird.
Is it possible to force the dump of the indexes by type and then by alphabetical order?