[Koha-bugs] [Bug 26947] kohastructure.sql should be updated for each release

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26947

--- Comment #44 from Jonathan Druart <jonathan.druart at 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.