Bug 22273: Database revision for table article_requests
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Wed, 18 Dec 2019 14:35:50 +0000 (14:35 +0000)
committerJoy Nelson <joy@bywatersolutions.com>
Wed, 1 Apr 2020 20:45:55 +0000 (20:45 +0000)
commit06235e20eea8a8e619e6192edb0a8808297716ef
tree97dfa087743015c9b8dc1c4c13ff43e99cbf4b0a
parent74c8c459e3e032bd35125c620fc25cae2201abbd
Bug 22273: Database revision for table article_requests

Column created_on should not be updated. It is filled once by the
store method of Koha::ArticleRequest.
Column updated_on should be a timestamp, updated by the database.

Note: Although higher versions of MySQL and MariaDB support two timestamps
(NOT NULL) in one table, I kept on the safe side by allowing NULL on the
created_on column.

@RM: Don't forget to run DBIx update.

Test plan:
Run new install or upgrade.

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Joy Nelson <joy@bywatersolutions.com>
installer/data/mysql/atomicupdate/bug22273.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql