From 4f303c4e1f06be5df9a32e137dd227c1759c0d11 Mon Sep 17 00:00:00 2001
From: Kyle Hall <kyle@bywatersolutions.com>
Date: Tue, 29 Nov 2022 09:29:45 -0500
Subject: [PATCH] =?UTF-8?q?Bug=C2=A030649:=20(QA=20follow-up)=20Switch=20p?=
 =?UTF-8?q?assword=20field=20to=20mediumtext?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 installer/data/mysql/atomicupdate/bug_30649.pl | 2 +-
 installer/data/mysql/kohastructure.sql         | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/installer/data/mysql/atomicupdate/bug_30649.pl b/installer/data/mysql/atomicupdate/bug_30649.pl
index 68c4e2df4e..ad933e316e 100755
--- a/installer/data/mysql/atomicupdate/bug_30649.pl
+++ b/installer/data/mysql/atomicupdate/bug_30649.pl
@@ -7,7 +7,7 @@ return {
         my ($args) = @_;
         my ( $dbh, $out ) = @$args{qw(dbh out)};
         $dbh->do(q{
-            ALTER TABLE vendor_edi_accounts CHANGE COLUMN `password` `password` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL
+            ALTER TABLE vendor_edi_accounts CHANGE COLUMN `password` `password` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL
         });
 
         require Koha::Encryption;
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 0c5e561233..9ae0f55ebc 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -5850,7 +5850,7 @@ CREATE TABLE `vendor_edi_accounts` (
   `description` mediumtext NOT NULL,
   `host` varchar(40) DEFAULT NULL,
   `username` varchar(40) DEFAULT NULL,
-  `password` varchar(256) DEFAULT NULL,
+  `password` mediumtext DEFAULT NULL,
   `last_activity` date DEFAULT NULL,
   `vendor_id` int(11) DEFAULT NULL,
   `download_directory` mediumtext DEFAULT NULL,
-- 
2.30.2