From 291a0b8f944e8cbafce51fe4fbc94fcdbace1e39 Mon Sep 17 00:00:00 2001 From: David Cook Date: Tue, 7 Sep 2021 07:09:43 +0000 Subject: [PATCH] Bug 8367: Make database update idempotent Signed-off-by: Emmi Takkinen --- .../bug_8367-add_holds_pickup_period_circrule.perl | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_8367-add_holds_pickup_period_circrule.perl b/installer/data/mysql/atomicupdate/bug_8367-add_holds_pickup_period_circrule.perl index 2f62aa436d6..fe8553e11b2 100644 --- a/installer/data/mysql/atomicupdate/bug_8367-add_holds_pickup_period_circrule.perl +++ b/installer/data/mysql/atomicupdate/bug_8367-add_holds_pickup_period_circrule.perl @@ -1,6 +1,10 @@ $DBversion = 'XXX'; if( CheckVersion( $DBversion ) ) { - $dbh->do(q{INSERT IGNORE INTO circulation_rules (branchcode, categorycode, itemtype, rule_name, rule_value) VALUES (NULL, NULL, NULL, 'holds_pickup_period', NULL) }); + $dbh->do(q{ + INSERT INTO circulation_rules (branchcode, categorycode, itemtype, rule_name, rule_value) + SELECT NULL, NULL, NULL, 'holds_pickup_period', '' + WHERE NOT EXISTS ( SELECT rule_name FROM circulation_rules where rule_name = 'holds_pickup_period' ) + }); NewVersion( $DBversion, 8367, "Add holds_pickup_period circulation rule" ); } -- 2.20.1