]> git.koha-community.org Git - koha.git/commit
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)
committerVictor Grousset/tuxayo <victor@tuxayo.net>
Wed, 23 Feb 2022 19:36:54 +0000 (20:36 +0100)
commitd26dc0867cbb212aef8e6c07e594a346f2e01c02
tree86d59840e76c341c5fee39a098de1e9c4d097912
parentf10783a84cecdf3cee927f627f12ba7324ba75ab
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>
(cherry picked from commit f8125ecc182cfbc072886e0b122759c32290b0f6)
Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net>
installer/data/mysql/atomicupdate/bug_29495.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql