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: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org 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.