https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26947
Bug ID: 26947
Summary: kohastrcuture.sql should be updated for each release
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Architecture, internals, and plumbing
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
The kohastructure.sql was originally a dump fo the database schema. Over time,
however, it has been manually updated by developers as the tables were altered.
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.
We can add a script to kohadevbox or the release tools to make it easy to
generate the new file and can add as a step in the release process
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
