From bd011ddffa0911cdb969f14e5b3a945324befa0d Mon Sep 17 00:00:00 2001
From: Owen Leonard <oleonard@myacpl.org>
Date: Mon, 29 Jun 2020 13:07:42 +0000
Subject: [PATCH] Bug 23797: (follow-up) Increase the size of opac_news.lang

This patch adds a database update to increase the size of the
opac_news.lang column in order to accommodate longer values.
---
 installer/data/mysql/atomicupdate/bug-23797.perl | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 installer/data/mysql/atomicupdate/bug-23797.perl

diff --git a/installer/data/mysql/atomicupdate/bug-23797.perl b/installer/data/mysql/atomicupdate/bug-23797.perl
new file mode 100644
index 0000000000..07b0d8a2d3
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug-23797.perl
@@ -0,0 +1,7 @@
+$DBversion = 'XXX'; # will be replaced by the RM
+if( CheckVersion( $DBversion ) ) {
+    $dbh->do( "ALTER TABLE opac_news CHANGE lang lang VARCHAR(50)" );
+
+    SetVersion( $DBversion );
+    print "Upgrade to $DBversion done (Bug 23797: Extend the opac_news lang column to accommodate longer values)\n";
+}
-- 
2.11.0