From 09609a81d36d61e8004fbdf9cb779e01955ef0dc Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Sat, 25 Jan 2025 11:26:40 +0000 Subject: [PATCH] Bug 39190: Update status to longtext Update status field to store longtext so we can sore more details information about connection statuses from test connection --- .../mysql/atomicupdate/bug_35761-add_SFTP_tables_and_perm.pl | 2 +- installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_35761-add_SFTP_tables_and_perm.pl b/installer/data/mysql/atomicupdate/bug_35761-add_SFTP_tables_and_perm.pl index 72ba331436f..f0acdbda2e6 100755 --- a/installer/data/mysql/atomicupdate/bug_35761-add_SFTP_tables_and_perm.pl +++ b/installer/data/mysql/atomicupdate/bug_35761-add_SFTP_tables_and_perm.pl @@ -31,7 +31,7 @@ return { `auth_mode` enum('password','key_file','noauth') NOT NULL DEFAULT 'password', `download_directory` mediumtext DEFAULT NULL, `upload_directory` mediumtext DEFAULT NULL, - `status` varchar(32) DEFAULT NULL, + `status` longtext DEFAULT NULL, `debug` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `host_idx` (`host`) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index d17f7f04a1c..bc3a8a01866 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -5984,7 +5984,7 @@ CREATE TABLE `sftp_servers` ( `auth_mode` enum('password','key_file','noauth') NOT NULL DEFAULT 'password', `download_directory` mediumtext DEFAULT NULL, `upload_directory` mediumtext DEFAULT NULL, - `status` varchar(32) DEFAULT NULL, + `status` longtext DEFAULT NULL, `debug` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `host_idx` (`host`) -- 2.48.1