http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14849 --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Created attachment 46589 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=46589&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 -- You are receiving this mail because: You are watching all bug changes.