https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26947 --- Comment #44 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- I think Nick explained quite well the original need in comment 0:
Currently the file is out of order, and the conventions for punctuation and formatting are not standard. For instance, some numbers are quoted, some tables names are in backticks, some foreign keys are listed as 'CONSTRAINT' and some aren't
The advantage to regenerating the file is that then users can dump their db schema and easily diff it against the expected structure to see what might be missing.
Many DB updates simply don't add a new constraint if the existing data violates this, and as we use more Koha Objects, these missing constraints cause issues.
So it's a need for both standardisation/homogeneity and maintenance. -- You are receiving this mail because: You are watching all bug changes.