From 42f4e435aa84388938d31fe78f7d80b1af44cf50 Mon Sep 17 00:00:00 2001
From: Nick Clemens <nick@bywatersolutions.com>
Date: Thu, 23 Jan 2020 02:35:38 +0000
Subject: [PATCH] Bug 24476: Database updates

---
 .../mysql/atomicupdate/bug_24476_opt_out_of_auto_renewal.perl | 11 +++++++++++
 installer/data/mysql/kohastructure.sql                        |  2 ++
 2 files changed, 13 insertions(+)
 create mode 100644 installer/data/mysql/atomicupdate/bug_24476_opt_out_of_auto_renewal.perl

diff --git a/installer/data/mysql/atomicupdate/bug_24476_opt_out_of_auto_renewal.perl b/installer/data/mysql/atomicupdate/bug_24476_opt_out_of_auto_renewal.perl
new file mode 100644
index 0000000000..35b01478ad
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_24476_opt_out_of_auto_renewal.perl
@@ -0,0 +1,11 @@
+$DBversion = 'XXX';
+if( CheckVersion( $DBversion ) ) {
+    unless( column_exists('borrowers','no_autorenewal') ){
+        $dbh->do( "ALTER TABLE borrowers ADD COLUMN no_autorenewal TINYINT(1)" );
+    }
+    unless( column_exists('deletedborrowers','no_autorenewal') ){
+        $dbh->do( "ALTER TABLE deletedborrowers ADD COLUMN no_autorenewal TINYINT(1)" );
+    }
+    SetVersion( $DBversion );
+    print "Upgrade to $DBversion done (Bug 24476 - Allow patrons to opt-out of autorenewal)\n";
+}
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 3f28188c02..06af4aa2c6 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -590,6 +590,7 @@ CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
   `login_attempts` int(4) default 0, -- number of failed login attemps
   `overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
   `anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization
+  `no_autorenewal` TINYINT(1) NOT NULL DEFAULT 0, -- flag for auto-renewal opt out
   KEY borrowernumber (borrowernumber),
   KEY `cardnumber` (`cardnumber`),
   KEY `sms_provider_id` (`sms_provider_id`)
@@ -1585,6 +1586,7 @@ CREATE TABLE `borrowers` ( -- this table includes information about your patrons
   `login_attempts` int(4) default 0, -- number of failed login attemps
   `overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
   `anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization
+  `no_autorenewal` TINYINT(1) NOT NULL DEFAULT 0, -- flag for auto-renewal opt out
   UNIQUE KEY `cardnumber` (`cardnumber`),
   PRIMARY KEY `borrowernumber` (`borrowernumber`),
   KEY `categorycode` (`categorycode`),
-- 
2.11.0