Attachment 132034 Details for Bug 27981 – Bug 27981: DB update

[patch] Bug 27981: DB update

Bug-27981-DB-update.patch (text/plain), 1.26 KB, created by Nick Clemens (kidclamp) on 2022-03-22 18:45:58 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2022-03-22 18:45:58 UTC

Size: 1.26 KB

patch

obsolete

>From d8bca6bc2187c75f8a073f134fb48dc9d2fddef9 Mon Sep 17 00:00:00 2001
>From: Nick Clemens <nick@bywatersolutions.com>
>Date: Thu, 24 Jun 2021 06:20:23 +0000
>Subject: [PATCH] Bug 27981: DB update
>
>---
> installer/data/mysql/atomicupdate/bug_27981.pl | 17 +++++++++++++++++
> 1 file changed, 17 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_27981.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_27981.pl b/installer/data/mysql/atomicupdate/bug_27981.pl
>new file mode 100755
>index 0000000000..f518c60b55
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_27981.pl
>@@ -0,0 +1,17 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number => "27981",
>+    description => "Make it possible to force 001 = biblionumber",
>+    up => sub {
>+        my ($args) = @_;
>+        my ($dbh, $out) = @$args{qw(dbh out)};
>+        # Do you stuffs here
>+        $dbh->do(q{
>+            INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES ('autoControlNumber','OFF','biblionumber|OFF',
>+            'Used to autogenerate a Control Number: biblionumber will be as biblionumber; OFF will leave it as is','Choice');
>+        });
>+        # Print useful stuff here
>+        say $out "Added system preference autoControlNumber";
>+    },
>+};
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 27981: 118461 | 118513 | 119704 | 119705 | 119717 | 121805 | 122280 | 122301 | 122344 | 122356 | 122672 | 122674 | 122675 | 124279 | 124280 | 124281 | 128223 | 128224 | 128225 | 132034 | 132035 | 132036 | 134536 | 134537 | 134538 | 134539 | 136022 | 140092 | 140093 | 140094 | 140095 | 140096 | 140097 | 140502