[Koha-bugs] [Bug 13668] Creator of an SQL report shoudl be NULL when the staff patron is deleted
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Jan 13 23:26:03 CET 2016
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13668
Joy Nelson <joy at bywatersolutions.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #46592|0 |1
is obsolete| |
--- Comment #6 from Joy Nelson <joy at bywatersolutions.com> ---
Created attachment 46622
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=46622&action=edit
Bug 13668: Add foreign key on saved_sql.borrowernumber
saved_sql.borrowernumber refers to a borrowernumber, the DB structure should
reflect this constraint.
Test plan:
0/ Do not execute the update DB entry
1/ Add a new patron
2/ Use this patron to create a new report
3/ Delete the patron
4/ Execute the DB entry
5/ The saved_sql.borrowernumber for this report should have been set to NULL
6/ On the reports table, the column 'Author' should be empty.
Signed-off-by: Joy Nelson <joy at bywatersolutions.com>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list