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)
committerAndrew Fuerste-Henry <andrew@bywatersolutions.com>
Thu, 17 Feb 2022 19:47:01 +0000 (19:47 +0000)
commitf8125ecc182cfbc072886e0b122759c32290b0f6
tree3871c0eafa7834db64c4c6b40a5568c5e0716edb
parenta052d6752ca641017d3008d56b6638643f9f1651
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: Andrew Fuerste-Henry <andrew@bywatersolutions.com>
installer/data/mysql/atomicupdate/bug_29495.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql