Bug 24658: (bug 22008 follow-up) Correct update DB entry 18.12.00.031
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Tue, 17 Nov 2020 14:15:02 +0000 (15:15 +0100)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Wed, 9 Dec 2020 10:08:20 +0000 (11:08 +0100)
commitfb0a659684a70204c1922675df18efca257bddd9
tree9f2edb371199bda69bbc6322e5a854510ff689b1
parenta37ba7903d6e7c18b2e2f8d9e145936b0dc8b938
Bug 24658: (bug 22008 follow-up) Correct update DB entry 18.12.00.031

If the original constraint does not exist, the second one is not added.

Test plan:
1. checkout dbrev 18.12.00.030
2. Remove the constraint: ALTER TABLE accountlines DROP FOREIGN KEY accountlines_ibfk_2
3. checkout master
4.
% updatedatabase
=> The constraint accountlines_ibfk_items is not added
5. Repeat 1 to 4
=> The constraint is added correctly

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
installer/data/mysql/updatedatabase.pl