From d03a432abd56ec57b697e639c928fe00d2bebc07 Mon Sep 17 00:00:00 2001
From: Kyle M Hall <kyle@bywatersolutions.com>
Date: Wed, 1 May 2024 09:29:57 -0400
Subject: [PATCH] Bug 18317: Add database update

---
 installer/data/mysql/atomicupdate/bug_18317.pl | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100755 installer/data/mysql/atomicupdate/bug_18317.pl

diff --git a/installer/data/mysql/atomicupdate/bug_18317.pl b/installer/data/mysql/atomicupdate/bug_18317.pl
new file mode 100755
index 00000000000..8ef88b05158
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_18317.pl
@@ -0,0 +1,17 @@
+use Modern::Perl;
+
+return {
+    bug_number => "18317",
+    description => "Allow check out of already checked out items through SIP"
+    up => sub {
+        my ($args) = @_;
+        my ( $dbh, $out ) = @$args{qw(dbh out)};
+
+        $dbh->do(q{
+            INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
+            ('AllowItemsOnLoanCheckoutSIP','0','','Do not generate ISSUED_TO_ANOTHER warning when checking out items already checked out to someone else via SIP. This allows self checkouts for those items.','YesNo')
+        });
+
+        say $out "Added new system preference 'AllowItemsOnLoanCheckoutSIP'";
+    },
+};
-- 
2.30.2