Bug 14295 - Add creation time, size and owner for uploaded files
Summary: Add creation time, size and owner for uploaded files
Status: CLOSED MOVED
Alias: None
Product: Koha
Classification: Unclassified
Component: Tools (show other bugs)
Version: master
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Marcel de Rooy
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-05-29 06:23 UTC by Marcel de Rooy
Modified: 2016-01-15 10:52 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: Small patch
Who signed the patch off:
Text to go in the release notes:
Version(s) released in:


Attachments
Bug 14295: Database revision: add three columns to uploaded_files (1.91 KB, patch)
2015-05-29 07:02 UTC, Marcel de Rooy
Details | Diff | Splinter Review
Bug 14295: Add creation time, size and owner for uploaded files (1.31 KB, patch)
2015-05-29 07:02 UTC, Marcel de Rooy
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
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.