Bug 31948: Add timestamp to tmp_holdsqueue table
authorKatrin Fischer <katrin.fischer@bsz-bw.de>
Fri, 28 Oct 2022 13:56:10 +0000 (13:56 +0000)
committerTomas Cohen Arazi <tomascohen@theke.io>
Fri, 28 Oct 2022 19:41:12 +0000 (16:41 -0300)
commitb2b7180c8f73740a607431aad898403dd0d598f7
tree49ff52759a24f71ef1a9415221aed83570bdd28c
parenta9ea3650bd09c25539242736b07c9c33041cc090
Bug 31948: Add timestamp to tmp_holdsqueue table

With the option to have real time updates to tmp_holdsqueue
a timestamp will be really helpful to help find the most recently
added entries.

To test:
* Place some holds on a record with available items
* Run build_holds-queue.pl
* Verify the hold shows up under circulation > holds queue
* Apply patch
* Run build_holds_queue.pl again
* Verify this works without any issues
* Turn on RealTimeHoldsQueue
* Update pick-up location, add another hold
* Make sure these changes are reflected in the holds queue as well
* Look at the database and verify timestamps are set

Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/atomicupdate/bug_31948_tmp_holdsqueue.pl [new file with mode: 0755]
installer/data/mysql/kohastructure.sql