Attachment 171895 Details for Bug 37856 – Bug 37856: atomicupdate

[patch] Bug 37856: atomicupdate

Bug-37856-atomicupdate.patch (text/plain), 1.44 KB, created by David Nind on 2024-09-23 20:09:07 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: David Nind

Created: 2024-09-23 20:09:07 UTC

Size: 1.44 KB

patch

obsolete

>From 1f5d57714933f2c8b02ae9528ab934f610627597 Mon Sep 17 00:00:00 2001
>From: Pedro Amorim <pedro.amorim@ptfs-europe.com>
>Date: Wed, 18 Sep 2024 15:57:43 +0000
>Subject: [PATCH] Bug 37856: atomicupdate
>
>Signed-off-by: David Nind <david@davidnind.com>
>---
> .../data/mysql/atomicupdate/bug_37856.pl      | 19 +++++++++++++++++++
> 1 file changed, 19 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_37856.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_37856.pl b/installer/data/mysql/atomicupdate/bug_37856.pl
>new file mode 100755
>index 0000000000..0d62d17143
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_37856.pl
>@@ -0,0 +1,19 @@
>+use Modern::Perl;
>+use Koha::Installer::Output qw(say_warning say_failure say_success say_info);
>+
>+return {
>+    bug_number  => "37856",
>+    description => "Add service_platform column to erm_usage_data_providers",
>+    up          => sub {
>+        my ($args) = @_;
>+        my ( $dbh, $out ) = @$args{qw(dbh out)};
>+
>+        if( !column_exists( 'erm_usage_data_providers', 'service_platform' ) ) {
>+          $dbh->do(q{
>+              ALTER TABLE erm_usage_data_providers ADD COLUMN `service_platform` varchar(80) DEFAULT NULL COMMENT 'platform if provider requires it' AFTER `report_types`
>+          });
>+          say_info( $out, "Bug 37856 - Added service_platform column to table 'erm_usage_data_providers'" );
>+        }
>+        say_success( $out, "Bug 37856 - Done" );
>+    },
>+};
>-- 
>2.39.5

Actions: View | Diff | Splinter Review

Attachments on bug 37856: 171680 | 171681 | 171682 | 171683 | 171773 | 171774 | 171775 | 171893 | 171894 | 171895 | 171896 | 171897 | 171898 | 171899 | 172040 | 172042 | 172043 | 172044 | 172045 | 172046 | 172047 | 172048 | 172155 | 172156 | 172215