Bug 30486 - [OMNIBUS] Synchronize database schema with (older) database revisions
Summary: [OMNIBUS] Synchronize database schema with (older) database revisions
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
Depends on: 30414 30495 30496 27253 30449 30472 30481 30483 30490 30497 30498 30565 30572 32334
  Show dependency treegraph
Reported: 2022-04-07 12:40 UTC by Marcel de Rooy
Modified: 2023-06-20 06:39 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Note You need to log in before you can comment on or make changes to this bug.
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.