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)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Mon, 2 Mar 2020 09:49:57 +0000 (09:49 +0000)
commit266bcd554bd298ee4a1f09696af6e20c8fa3f548
tree2417563c0baa59679b86d561a3312224a9f36c75
parent8dc15ceffd7c9b3a720210537dff098a7b0c83d8
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>
installer/data/mysql/atomicupdate/bug22273.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql