Bug 28854: (follow-up) Replace unique constraint in return claims
authorMartin Renvoize <martin.renvoize@ptfs-europe.com>
Wed, 13 Jul 2022 17:11:34 +0000 (18:11 +0100)
committerTomas Cohen Arazi <tomascohen@theke.io>
Wed, 13 Jul 2022 17:53:28 +0000 (14:53 -0300)
commit475486781fec55b6a6bd62afd5f69ff5fdafd632
tree96e70acf8853de3a2c824ad9be0ae37f2db59964
parent5476be0c900adf1f6527dd431dc9d7b14d0fc595
Bug 28854: (follow-up) Replace unique constraint in return claims

This patch fixes the failing test for the return claims api.  We add a
new unique constraint to replace the one we removed earlier in the
patchset. One should not be able to create a duplicate return claim for
the same issue of an item.

Test plan
1) Run the database update
2) Confirm that t/db_dependent/api/v1/return_claims.t now passes
3) Confirm that t/db_dependent/api/v1/items.t continues to pass
4) Bonus points, confirm that bundle checkin still works when items are
   missing

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/atomicupdate/bug_28854.pl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql