From 4aef035573c1be8b28ddb9e7f5424447e13f8463 Mon Sep 17 00:00:00 2001
From: Agustin Moyano <agustinmoyano@theke.io>
Date: Mon, 16 Sep 2019 17:47:44 -0300
Subject: [PATCH] Bug 23260: Make borrowernumber nullable in
 items_last_borrower

This patch alters table structure to make borrowernumber nullable

Sponsored-by: Northeast Kansas Library System

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
---
 installer/data/mysql/atomicupdate/bug_23260.perl | 8 ++++++++
 installer/data/mysql/kohastructure.sql           | 2 +-
 2 files changed, 9 insertions(+), 1 deletion(-)
 create mode 100644 installer/data/mysql/atomicupdate/bug_23260.perl

diff --git a/installer/data/mysql/atomicupdate/bug_23260.perl b/installer/data/mysql/atomicupdate/bug_23260.perl
new file mode 100644
index 0000000000..b758f58b33
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_23260.perl
@@ -0,0 +1,8 @@
+$DBversion = 'XXX'; # will be replaced by the RM
+if( CheckVersion( $DBversion ) ) {
+    # you can use $dbh here like:
+    $dbh->do( "ALTER TABLE items_last_borrower MODIFY COLUMN `borrowernumber` int(11) default NULL" );
+
+    SetVersion( $DBversion );
+    print "Upgrade to $DBversion done (Bug 23260 - make borrowernumber from items_last_borrower nullable)\n";
+}
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 3f28188c02..0b11055fab 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -1729,7 +1729,7 @@ CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
 CREATE TABLE IF NOT EXISTS `items_last_borrower` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `itemnumber` int(11) NOT NULL,
-  `borrowernumber` int(11) NOT NULL,
+  `borrowernumber` int(11) default NULL,
   `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`),
   UNIQUE KEY `itemnumber` (`itemnumber`),
-- 
2.17.1