Attachment 165972 Details for Bug 18317 – Bug 18317: Add database update

[patch] Bug 18317: Add database update

Bug-18317-Add-database-update.patch (text/plain), 1.30 KB, created by Kyle M Hall (khall) on 2024-05-01 13:31:32 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2024-05-01 13:31:32 UTC

Size: 1.30 KB

patch

obsolete

>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

Actions: View | Diff | Splinter Review

Attachments on bug 18317: 122934 | 158688 | 158689 | 159130 | 159131 | 162394 | 162395 | 162396 | 165972 | 168489 | 168490 | 168491 | 168492 | 168493