[Koha-bugs] [Bug 13533] New: Table suggestions is missing FK constraints / borrowernumbers are kept on deletion of patron
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Jan 7 17:28:48 CET 2015
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13533
Bug ID: 13533
Summary: Table suggestions is missing FK constraints /
borrowernumbers are kept on deletion of patron
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Database
Assignee: gmcharlt at gmail.com
Reporter: katrin.fischer at bsz-bw.de
QA Contact: testopia at bugs.koha-community.org
The suggestions table never clears the borrowernumbers referenced in
- suggestedby
- managedby
- acceptedby
- rejectedby
suggestedby is usually a patron not a staff user, I think on deletion of the
patron it would make sense to set it to NULL. Maybe also for the other 3?
There is also no FK on
- budgetid
- branchcode
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list