[Bug 30486] New: [OMNIBUS] Synchronize database schema with (older) database revisions
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@lists.koha-community.org Reporter: m.de.rooy@rijksmuseum.nl QA Contact: testopia@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.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |30414, 30449, 30472, 30481, | |30483 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30414 [Bug 30414] Inconsistent (duplicated) FK constraint name: aqbudgets.aqbudgetperiods_ibfk_1 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30449 [Bug 30449] Missing FK constraint on borrower_attribute_types https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30472 [Bug 30472] Field borrower_relationships.guarantor_id should be marked as NOT NULL https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30481 [Bug 30481] Drop unique constraint deleteditemsstocknumberidx for deleteditems https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30483 [Bug 30483] Should issues.borrowernumber and issues.itemnumber be NOT NULL ? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 --- Comment #1 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- Note that I counted changes in about 45 tables (read: DBIx schema files) recently before starting to resolve them. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=26947 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |30490 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30490 [Bug 30490] Should deleting a parent itemtype be CASCADING? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |30495 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30495 [Bug 30495] marc_modification_template_actions.action should be NOT NULL -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |30496 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30496 [Bug 30496] message_attributes.message_name should be NOT NULL -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |30497 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30497 [Bug 30497] Constraint old_reserves_ibfk_4 should be SET NULL instead of CASCADE -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |30498 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30498 [Bug 30498] Enum search_field.type should contain year in kohastructure -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |27253 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27253 [Bug 27253] borrowers.updated_on cannot be null on fresh install, but can be null with upgrade -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |30565 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30565 [Bug 30565] Field stockrotationrotas.description should be NOT NULL, title UNIQUE -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |30571 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30571 [Bug 30571] Table z3950servers: which fields should be NOT NULL ? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |30572 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30572 [Bug 30572] Field search_marc_to_field.sort needs syncing too -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Bug 30486 depends on bug 30449, which changed state. Bug 30449 Summary: Missing FK constraint on borrower_attribute_types https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30449 What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to stable |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Bug 30486 depends on bug 27253, which changed state. Bug 27253 Summary: borrowers.updated_on cannot be null on fresh install, but can be null with upgrade https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27253 What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to stable |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Bug 30486 depends on bug 30449, which changed state. Bug 30449 Summary: Missing FK constraint on borrower_attribute_types https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30449 What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |Needs documenting Resolution|FIXED |--- -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Bug 30486 depends on bug 30565, which changed state. Bug 30565 Summary: Field stockrotationrotas.description should be NOT NULL, title UNIQUE https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30565 What |Removed |Added ---------------------------------------------------------------------------- Status|Needs documenting |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Bug 30486 depends on bug 30572, which changed state. Bug 30572 Summary: Field search_marc_to_field.sort needs syncing too https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30572 What |Removed |Added ---------------------------------------------------------------------------- Status|Needs documenting |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Bug 30486 depends on bug 30449, which changed state. Bug 30449 Summary: Missing FK constraint on borrower_attribute_types https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30449 What |Removed |Added ---------------------------------------------------------------------------- Status|Needs documenting |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on|30571 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30571 [Bug 30571] Table z3950servers: which fields should be NOT NULL ? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Bug 30486 depends on bug 30483, which changed state. Bug 30483 Summary: Do not allow NULL in issues.borrowernumber and issues.itemnumber https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30483 What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to stable |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |32334 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32334 [Bug 32334] Sync comments in database with schema -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 Bug 30486 depends on bug 32334, which changed state. Bug 32334 Summary: Sync comments in database with schema https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32334 What |Removed |Added ---------------------------------------------------------------------------- Status|Needs documenting |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=34063 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=34064 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=34065 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |david@davidnind.com -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org