Bug 24818

Summary: Accountline creation dates should be datetimes
Product: Koha Reporter: Martin Renvoize <martin.renvoize>
Component: Fines and feesAssignee: Martin Renvoize <martin.renvoize>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: 1joynelson
Version: master   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: Trivial patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
20.05.00
Bug Depends on:    
Bug Blocks: 14825, 24820    
Attachments: Bug 24818: Update database accountlines.date to timestamp
Bug 24818: Update database accountlines.date to timestamp
Bug 24818: Update database accountlines.date to timestamp

Description Martin Renvoize 2020-03-06 09:15:41 UTC
The resolution of the 'date' field in accountlines is just a date. It should be helpful if it were a full timestamp and also nice if it were maintained by the database rather than a DEFAULT NULL
Comment 1 Martin Renvoize 2020-03-06 11:22:14 UTC
Created attachment 100250 [details] [review]
Bug 24818: Update database accountlines.date to timestamp

This update increases the resolution for the 'date' field, used for
'creation date' in accountlines from a 'date' to a 'timestamp'.

This matches other tables where both a created and updated field are
included.
Comment 2 Owen Leonard 2020-03-11 13:47:01 UTC
Created attachment 100566 [details] [review]
Bug 24818: Update database accountlines.date to timestamp

This update increases the resolution for the 'date' field, used for
'creation date' in accountlines from a 'date' to a 'timestamp'.

This matches other tables where both a created and updated field are
included.

Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Comment 3 Katrin Fischer 2020-03-16 21:18:17 UTC
Created attachment 100821 [details] [review]
Bug 24818: Update database accountlines.date to timestamp

This update increases the resolution for the 'date' field, used for
'creation date' in accountlines from a 'date' to a 'timestamp'.

This matches other tables where both a created and updated field are
included.

Signed-off-by: Owen Leonard <oleonard@myacpl.org>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Comment 4 Martin Renvoize 2020-03-19 09:23:46 UTC
Nice work everyone!

Pushed to master for 20.05
Comment 5 Martin Renvoize 2020-03-19 13:07:47 UTC
Nice work everyone!

Pushed to master for 20.05
Comment 6 Joy Nelson 2020-04-03 20:28:20 UTC
enhancement not backported to 19.11.x