[Koha-bugs] [Bug 30486] New: [OMNIBUS] Synchronize database schema with (older) database revisions

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Apr 7 14:40:52 CEST 2022


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

            Bug ID: 30486
           Summary: [OMNIBUS] Synchronize database schema with (older)
                    database revisions
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Database
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: m.de.rooy at rijksmuseum.nl
        QA Contact: testopia at bugs.koha-community.org

When you are working with a Koha database, installed many years ago and
upgraded since then, you may have quite a bit of small deviations from a
freshly installed database.
This may be due to small inconsistencies between the changes to kohastructure
and the atomic update files, among other reasons (failing dbrevs, local
changes, etc)

Some changes only involve for instance the order of the database columns but
others may be a bit more serious: NULL or NOT NULL, type of constraint
(RESTRICT or CASCADE), etc.
You can have an idea of the state of your database by running the dbix script
in the misc folder [in a safe way :) ] and looking at git diff.

This report only collects links to individual reports where such changes are
reported / resolved.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.


More information about the Koha-bugs mailing list