Bug 24818: Update database accountlines.date to timestamp
authorMartin Renvoize <martin.renvoize@ptfs-europe.com>
Fri, 6 Mar 2020 11:20:51 +0000 (11:20 +0000)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Thu, 19 Mar 2020 09:23:14 +0000 (09:23 +0000)
commitad6e72dddddd29ed3330f0c282b754d941c53d95
tree1fe80db0db1b2d16c48cf641c1edff585e30b811
parent53ef5a4078d8d140c6f0d70bd183f56888767ad8
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>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
installer/data/mysql/atomicupdate/bug_24818.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql