Bug 29495: Drop issue_id constraint from return_claims
authorMartin Renvoize <martin.renvoize@ptfs-europe.com>
Wed, 17 Nov 2021 09:56:48 +0000 (09:56 +0000)
committerKyle Hall <kyle@bywatersolutions.com>
Fri, 4 Feb 2022 18:27:06 +0000 (13:27 -0500)
commitd42c6445c879023166aab656b0bf027f5a37459b
treef0bf7d164c96f772b7b00433d08dcd17c34ed7ae
parentc420fca8b02013b5ef453382e64a1e692bbb442b
Bug 29495: Drop issue_id constraint from return_claims

This patch removes the issue_id constraint from return_claims.

Due to the nature of our dual table approach to checkouts/old_checkouts
we can't safely hae this constraint and not lose data.  Prior to this
commit, when an item is checked in we move the checkout from checkouts
to old_checkouts.. this therefore triggers the delete of the issue_id
from the return_claims table as described by the foreign key constraint.

Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
installer/data/mysql/atomicupdate/bug_29495.pl [new file with mode: 0755]
installer/data/mysql/kohastructure.sql