Attachment 128153 Details for Bug 29605 – Bug 29605: account_offsets.type is not null

[patch] Bug 29605: account_offsets.type is not null

Bug-29605-accountoffsetstype-is-not-null.patch (text/plain), 1.80 KB, created by Jonathan Druart on 2021-12-02 12:09:22 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2021-12-02 12:09:22 UTC

Size: 1.80 KB

patch

obsolete

>From 4c88b71f730adadb2fc025245a5f6d10b7f7b2c8 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Thu, 2 Dec 2021 12:17:12 +0100
>Subject: [PATCH] Bug 29605: account_offsets.type is not null
>
>---
> installer/data/mysql/atomicupdate/bug_29605.pl | 11 ++++++++++-
> installer/data/mysql/db_revs/210600013.pl      |  2 +-
> 2 files changed, 11 insertions(+), 2 deletions(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_29605.pl b/installer/data/mysql/atomicupdate/bug_29605.pl
>index a18e8ecccc0..a6bbbb08de8 100755
>--- a/installer/data/mysql/atomicupdate/bug_29605.pl
>+++ b/installer/data/mysql/atomicupdate/bug_29605.pl
>@@ -32,8 +32,17 @@ return {
>                 ADD CONSTRAINT `tmp_holdsqueue_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
>             });
> 
>-            say $out "Added missing foreign key on tmp_holdsqueue"
>+            say $out "Added missing foreign key on tmp_holdsqueue";
>         }
> 
>+        $dbh->do(
>+            q{
>+                ALTER TABLE `account_offsets`
>+                MODIFY COLUMN `type` enum( 'CREATE', 'APPLY', 'VOID', 'OVERDUE_INCREASE', 'OVERDUE_DECREASE' ) NOT NULL
>+            }
>+        );
>+        say $out "Ensure NOT NULL on account_offsets.type";
>+
>     },
>+
> }
>diff --git a/installer/data/mysql/db_revs/210600013.pl b/installer/data/mysql/db_revs/210600013.pl
>index a8e52eaaf65..a7ab7e028e8 100755
>--- a/installer/data/mysql/db_revs/210600013.pl
>+++ b/installer/data/mysql/db_revs/210600013.pl
>@@ -34,7 +34,7 @@ return {
>                         'VOID',
>                         'OVERDUE_INCREASE',
>                         'OVERDUE_DECREASE'
>-                    )
>+                    ) NOT NULL
>                 AFTER `debit_id`
>               }
>         );
>-- 
>2.25.1

Actions: View | Diff | Splinter Review

Attachments on bug 29605: 128113 | 128114 | 128152 | 128153 | 128154 | 128155 | 128156 | 128157 | 128158 | 128239 | 128313 | 128314 | 128437 | 128438 | 128439 | 128440 | 128441 | 128442 | 128443 | 128444 | 128445 | 128483 | 129153 | 129154 | 129155 | 129156 | 129157 | 129158 | 129159 | 129160 | 129161