[Koha-bugs] [Bug 32729] Deleting an item removes the itemnumber from old_issues when it probably should not
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Feb 14 14:07:46 CET 2024
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32729
Lari Strand <lmstrand at gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |lmstrand at gmail.com
--- Comment #2 from Lari Strand <lmstrand at gmail.com> ---
(In reply to Cab Vinton from comment #1)
> Unless there's a good reason for this data loss, the itemnumber should be
> preserved.
I agree. We need this information for reports and finding out biblio details
based on the itemnumber in the old_issues table etc.
I propose we remove the constraint:
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items`
(`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
from old_issues-table.
Same goes for old_reserves-table (propably should make a new ticket?):
CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items`
(`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
These tables are archive tables and I think this information should be
preserved. I can't justify the data loss with any good reason.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
More information about the Koha-bugs
mailing list