Bug 30486

Summary: [OMNIBUS] Synchronize database schema with (older) database revisions
Product: Koha Reporter: Marcel de Rooy <m.de.rooy>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: ASSIGNED --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: david
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26947
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34063
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34064
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34065
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on: 30414, 30495, 30496, 27253, 30449, 30472, 30481, 30483, 30490, 30497, 30498, 30565, 30572, 32334    
Bug Blocks:    

Description Marcel de Rooy 2022-04-07 12:40:52 UTC
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.
Comment 1 Marcel de Rooy 2022-04-07 12:45:55 UTC
Note that I counted changes in about 45 tables (read: DBIx schema files) recently before starting to resolve them.