Bug 28972: Add missing foreign key constraints to holds queue table
authorKyle M Hall <kyle@bywatersolutions.com>
Wed, 8 Sep 2021 12:02:05 +0000 (08:02 -0400)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Mon, 20 Sep 2021 12:04:48 +0000 (14:04 +0200)
commit7170fe2cc5f30e055ffa3ab33648e977ffd3a25c
tree68eddd6da7e0b5d8199cbcc007a52e2c649560e9
parent5bbafce7204c6c1e0e87578f4abaf79713458c5e
Bug 28972: Add missing foreign key constraints to holds queue table

The table tmp_holdsqueue is missing a couple key constraints that should
be there, one for biblio and one for borrowers.

Test Plan:
1) "SHOW CREATE TABLE tmp_holdsqueue;" should show no FKs for biblio or borrowers
2) Apply this patch
3) Run updatedatabase.pl
4) "SHOW CREATE TABLE tmp_holdsqueue;" should now show FKs for biblio or borrowers

Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Joonas Kylmälä <joonas.kylmala@iki.fi>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
installer/data/mysql/atomicupdate/bug_28972.pl [new file with mode: 0755]
installer/data/mysql/kohastructure.sql