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)
committerFridolin Somers <fridolin.somers@biblibre.com>
Tue, 18 Jan 2022 00:55:55 +0000 (14:55 -1000)
commit7beddcb7a9347e280dee0a2a43bcad5a5405e9bc
tree1bc9c3b26c755b596aa3e1990f682a34a84c4547
parent27587912d7d36faa303042b6e993f6a9a5c845ac
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