Bug 14295

Summary: Add creation time, size and owner for uploaded files
Product: Koha Reporter: Marcel de Rooy <m.de.rooy>
Component: ToolsAssignee: Marcel de Rooy <m.de.rooy>
Status: CLOSED MOVED QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
See Also: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14294
Change sponsored?: --- Patch complexity: Small patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: Bug 14295: Database revision: add three columns to uploaded_files
Bug 14295: Add creation time, size and owner for uploaded files

Description Marcel de Rooy 2015-05-29 06:23:49 UTC

    
Comment 1 Marcel de Rooy 2015-05-29 07:02:32 UTC
Created attachment 39652 [details] [review]
Bug 14295: Database revision: add three columns to uploaded_files

This patch adds three columns to table uploaded_files.
Col filesize will be helpful when checking quota.
Col owner will be helpful in terms of optional permissions and security.
Col dtcreated tells you when the file was uploaded.

Test plan:
Run the database revision.
Run a new install or run kohastructure.sql.
Comment 2 Marcel de Rooy 2015-05-29 07:02:37 UTC
Created attachment 39653 [details] [review]
Bug 14295: Add creation time, size and owner for uploaded files

When inserting a new record in uploaded_files, we want to fill the new
columns correctly.

Test plan:
Upload a file via the upload plugin. Verify that filesize, owner and
creation time are correct in the database record.
Run the unit test UploadedFiles.t.
Comment 3 Marcel de Rooy 2015-09-29 09:51:31 UTC
This has been incorporated in the latest adjustments of bug 6874.