Attachment 100621 Details for Bug 24298 – Bug 24298: Add return enums to branchstransfer triggers

[patch] Bug 24298: Add return enums to branchstransfer triggers

Bug-24298-Add-return-enums-to-branchstransfer-trig.patch (text/plain), 2.45 KB, created by Nick Clemens (kidclamp) on 2020-03-12 12:15:49 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2020-03-12 12:15:49 UTC

Size: 2.45 KB

patch

obsolete

>From e4c7fc38453ba71f1516a026d53f586dbc46f57e Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Thu, 16 Jan 2020 15:25:34 +0000
>Subject: [PATCH] Bug 24298: Add return enums to branchstransfer triggers
>
>Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
>updatedabase runs Ok
>
>Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
>---
> installer/data/mysql/atomicupdate/bug_24298.perl | 23 +++++++++++++++++++++++
> installer/data/mysql/kohastructure.sql           |  2 +-
> 2 files changed, 24 insertions(+), 1 deletion(-)
> create mode 100644 installer/data/mysql/atomicupdate/bug_24298.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_24298.perl b/installer/data/mysql/atomicupdate/bug_24298.perl
>new file mode 100644
>index 0000000000..695354b39d
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_24298.perl
>@@ -0,0 +1,23 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+
>+    # Add return reasons to enum
>+    $dbh->do(
>+        qq{
>+            ALTER TABLE
>+                `branchtransfers`
>+            MODIFY COLUMN
>+                `reason` enum(
>+                    'Manual',
>+                    'StockrotationAdvance',
>+                    'StockrotationRepatriation',
>+                    'ReturnToHome',
>+                    'ReturnToHolding'
>+                )
>+            AFTER `comments`
>+          }
>+    );
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 24296 - Add 'return' reasons to branchtransfers enum)\n";
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 0f4f2a7f83..c9ac55018f 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -906,7 +906,7 @@ CREATE TABLE `branchtransfers` ( -- information for items that are in transit be
>   `datearrived` datetime default NULL, -- the date the transfer arrived at its destination
>   `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to
>   `comments` LONGTEXT, -- any comments related to the transfer
>-  `reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation'), -- what triggered the transfer
>+  `reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding'), -- what triggered the transfer
>   PRIMARY KEY (`branchtransfer_id`),
>   KEY `frombranch` (`frombranch`),
>   KEY `tobranch` (`tobranch`),
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 24298: 97450 | 97451 | 97506 | 97507 | 97535 | 97536 | 98292 | 98293 | 98294 | 99774 | 99775 | 99776 | 99777 | 99781 | 99782 | 99783 | 99784 | 100621 | 100622 | 100623 | 100624 | 100625 | 103792