Bug 13533 - Table suggestions is missing FK constraints / borrowernumbers are kept on deletion of patron
Summary: Table suggestions is missing FK constraints / borrowernumbers are kept on del...
Status: RESOLVED DUPLICATE of bug 22368
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Galen Charlton
QA Contact: Testopia
URL:
Keywords:
: 10633 (view as bug list)
Depends on:
Blocks: 5334
  Show dependency tree / graph
 
Reported: 2015-01-07 16:28 UTC by Katrin Fischer
Modified: 2019-02-20 16:44 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Katrin Fischer 2015-01-07 16:28:48 UTC 
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
Comment 1 Katrin Fischer 2015-01-08 14:42:27 UTC 
*** Bug 10633 has been marked as a duplicate of this bug. ***
Comment 2 Martin Renvoize (ashimema) 2019-02-20 16:44:42 UTC 
Sorry Katrin, I didn't spot this one before creating a new one which adds the constraints... hopefully you agree with the ones added there?

*** This bug has been marked as a duplicate of bug 22368 ***