[Koha-bugs] [Bug 26947] New: kohastrcuture.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

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