From 4f303c4e1f06be5df9a32e137dd227c1759c0d11 Mon Sep 17 00:00:00 2001 From: Kyle Hall 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