Attachment 170106 Details for Bug 33641 – Bug 33641: DB update

[patch] Bug 33641: DB update

Bug-33641-DB-update.patch (text/plain), 1.86 KB, created by Nick Clemens (kidclamp) on 2024-08-06 17:38:47 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2024-08-06 17:38:47 UTC

Size: 1.86 KB

patch

obsolete

>From 32d992eb7e27820f006b8d29760bccaf70299ba9 Mon Sep 17 00:00:00 2001
>From: Nick Clemens <nick@bywatersolutions.com>
>Date: Tue, 6 Aug 2024 17:37:12 +0000
>Subject: [PATCH] Bug 33641: DB update
>
>---
> .../data/mysql/atomicupdate/bug_33641.pl      | 35 +++++++++++++++++++
> 1 file changed, 35 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_33641.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_33641.pl b/installer/data/mysql/atomicupdate/bug_33641.pl
>new file mode 100755
>index 00000000000..e738d50a0a0
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_33641.pl
>@@ -0,0 +1,35 @@
>+use Modern::Perl;
>+use Koha::Installer::Output qw(say_warning say_failure say_success say_info);
>+
>+return {
>+    bug_number  => "33641",
>+    description => "Added issues.return_branch and old_issues.return_branch",
>+    up          => sub {
>+        my ($args) = @_;
>+        my ( $dbh, $out ) = @$args{qw(dbh out)};
>+
>+        if ( !column_exists( 'issues', 'return_branch' ) ) {
>+            $dbh->do(
>+                q{
>+                ALTER TABLE issues
>+                ADD COLUMN return_branch varchar(10) DEFAULT NULL
>+                COMMENT 'foreign key, linking to the branches table for the location the item was returned'
>+                AFTER returndate
>+             }
>+            );
>+            say_success( $out, "Added column 'issues.return_branch'" );
>+        }
>+        if ( !column_exists( 'old_issues', 'return_branch' ) ) {
>+            $dbh->do(
>+                q{
>+                ALTER TABLE old_issues
>+                ADD COLUMN return_branch varchar(10) DEFAULT NULL
>+                COMMENT 'foreign key, linking to the branches table for the location the item was returned'
>+                AFTER returndate
>+             }
>+            );
>+            say_success( $out, "Added column 'old_issues.return_branch'" );
>+        }
>+
>+    },
>+};
>-- 
>2.39.2

Actions: View | Diff | Splinter Review

Attachments on bug 33641: 170105 | 170106 | 170107 | 170108 | 170109 | 170110 | 170111 | 170138 | 170139 | 170140 | 170141 | 173562 | 173563 | 173564 | 173565 | 174510 | 174511 | 174512 | 174513 | 174514 | 174536 | 174538 | 174569 | 174570 | 174571 | 174572 | 174573 | 174574 | 174584 | 174585