http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14849

Marcel de Rooy <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #46759|0                           |1
        is obsolete|                            |

--- Comment #3 from Marcel de Rooy <[email protected]> ---
Created attachment 47157
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=47157&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 <[email protected]>

Signed-off-by: Marcel de Rooy <[email protected]>
The test plan seems to miss one step: 3b Delete the patron.

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to