[Koha-bugs] [Bug 14849] Owner should be FK in uploaded_files
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Sun Jan 17 08:07:12 CET 2016
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14849
Chris Cormack <chris at bigballofwax.co.nz> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #46589|0 |1
is obsolete| |
--- Comment #2 from Chris Cormack <chris at bigballofwax.co.nz> ---
Created attachment 46759
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=46759&action=edit
Bug 14849: Add foreign key on uploaded_files.owner
uploaded_files.owner 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 upload a new file
3/ In the uploaded_files you should see that the owner value is the
borrowernumber of the newly created patron
4/ Execute the DB entry
5/ The uploaded_files.owner value should have been set to NULL
6/ Repeat 1, 2 and 3
7/ Delete the patron
5/ The uploaded_files.owner value should have been set to NULL
Signed-off-by: Chris Cormack <chrisc at catalyst.net.nz>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list