From b6591b5d3a3459603495ceeb911d4f71cfa86db6 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Fri, 29 Aug 2025 17:29:23 -0300 Subject: [PATCH] Bug 39190: Rename 'sftp_servers' to 'file_transports' Signed-off-by: Tomas Cohen Arazi --- .../bug_35761-add_SFTP_tables_and_perm.pl | 12 ++++++------ installer/data/mysql/kohastructure.sql | 6 +++--- installer/data/mysql/mandatory/userpermissions.sql | 4 ++-- 3 files changed, 11 insertions(+), 11 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 f0acdbda2e6..653254df040 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 @@ -2,7 +2,7 @@ use Modern::Perl; return { bug_number => "35761", - description => "Add new table and permission for generalised SFTP", + description => "Add new table and permission for generalised file transports", up => sub { my ($args) = @_; my ( $dbh, $out ) = @$args{qw(dbh out)}; @@ -10,15 +10,15 @@ return { $dbh->do( q{ INSERT IGNORE INTO permissions (module_bit, code, description) - VALUES (3, 'manage_sftp_servers', 'Manage FTP/SFTP servers configuration'); + VALUES (3, 'manage_file_transports', 'Manage file transports configuration'); } ); - say $out "Added new manage_sftp_servers permission"; + say $out "Added new permission 'manage_file_transports'"; - unless ( TableExists('sftp_servers') ) { + unless ( TableExists('file_transports') ) { $dbh->do( q { - CREATE TABLE `sftp_servers` ( + CREATE TABLE `file_transports` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(80) NOT NULL, `host` varchar(80) NOT NULL DEFAULT 'localhost', @@ -38,7 +38,7 @@ return { ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; } ); - say $out "Added new sftp_servers table"; + say $out "Added new table 'file_transports"; } }, }; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e5aa96ff80f..cf951b09a56 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -5967,13 +5967,13 @@ CREATE TABLE `sessions` ( /*!40101 SET character_set_client = @saved_cs_client */; -- --- Table structure for table `sftp_servers` +-- Table structure for table `file_transports` -- -DROP TABLE IF EXISTS `sftp_servers`; +DROP TABLE IF EXISTS `file_transports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `sftp_servers` ( +CREATE TABLE `file_transports` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(80) NOT NULL, `host` varchar(80) NOT NULL DEFAULT 'localhost', diff --git a/installer/data/mysql/mandatory/userpermissions.sql b/installer/data/mysql/mandatory/userpermissions.sql index 22720c04876..8252fb44202 100644 --- a/installer/data/mysql/mandatory/userpermissions.sql +++ b/installer/data/mysql/mandatory/userpermissions.sql @@ -39,7 +39,7 @@ INSERT INTO permissions (module_bit, code, description) VALUES ( 3, 'manage_additional_fields', 'Add, edit, or delete additional custom fields for baskets or subscriptions (also requires order_manage or edit_subscription permissions)'), ( 3, 'manage_keyboard_shortcuts', 'Manage keyboard shortcuts for the advanced cataloging editor'), ( 3, 'manage_smtp_servers', 'Manage SMTP servers configuration'), - ( 3, 'manage_sftp_servers', 'Manage FTP/SFTP servers configuration'), + ( 3, 'manage_file_transports', 'Manage file transports configuration'), ( 3, 'manage_background_jobs', 'Manage background jobs'), ( 3, 'manage_curbside_pickups', 'Manage curbside pickups'), ( 3, 'manage_search_filters', 'Manage custom search filters'), @@ -167,4 +167,4 @@ INSERT INTO permissions (module_bit, code, description) VALUES (25, 'takepayment', 'Access the point of sale page and take payments'), (26, 'manage_problem_reports', 'Manage OPAC problem reports'), (27, 'manage_recalls', 'Manage recalls for patrons') -; \ No newline at end of file +; -- 2.51.0