From 1677c738518db0ad955d8f0eda149e403665b176 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Sat, 30 Aug 2025 12:29:55 -0300 Subject: [PATCH] Bug 39190: Rename id => file_transport_id and remove mapping Signed-off-by: Tomas Cohen Arazi --- .../mysql/atomicupdate/bug_35761-add_SFTP_tables_and_perm.pl | 4 ++-- installer/data/mysql/kohastructure.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 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 653254df040..43e18e162d2 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 @@ -19,7 +19,7 @@ return { $dbh->do( q { CREATE TABLE `file_transports` ( - `id` int(11) NOT NULL AUTO_INCREMENT, + `file_transport_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(80) NOT NULL, `host` varchar(80) NOT NULL DEFAULT 'localhost', `port` int(11) NOT NULL DEFAULT 22, @@ -33,7 +33,7 @@ return { `upload_directory` mediumtext DEFAULT NULL, `status` longtext DEFAULT NULL, `debug` tinyint(1) NOT NULL DEFAULT 0, - PRIMARY KEY (`id`), + PRIMARY KEY (`file_transport_id`), KEY `host_idx` (`host`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; } diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index cf951b09a56..d2165d8f11b 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -5974,7 +5974,7 @@ DROP TABLE IF EXISTS `file_transports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `file_transports` ( - `id` int(11) NOT NULL AUTO_INCREMENT, + `file_transport_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(80) NOT NULL, `host` varchar(80) NOT NULL DEFAULT 'localhost', `port` int(11) NOT NULL DEFAULT 22, @@ -5988,7 +5988,7 @@ CREATE TABLE `file_transports` ( `upload_directory` mediumtext DEFAULT NULL, `status` longtext DEFAULT NULL, `debug` tinyint(1) NOT NULL DEFAULT 0, - PRIMARY KEY (`id`), + PRIMARY KEY (`file_transport_id`), KEY `host_idx` (`host`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- 2.51.0