From c57f01359c485cdea6e1572eefd582d3d49d6e39 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 9 Oct 2025 16:25:46 +0200 Subject: [PATCH] Bug 39190: Fix DB struct diff --- installer/data/mysql/kohastructure.sql | 54 +++++++++++++------------- 1 file changed, 27 insertions(+), 27 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e391dc68f5d..b1773941123 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3475,6 +3475,33 @@ CREATE TABLE `export_format` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export'; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `file_transports` +-- + +DROP TABLE IF EXISTS `file_transports`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8mb4 */; +CREATE TABLE `file_transports` ( + `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, + `transport` enum('ftp','sftp') NOT NULL DEFAULT 'sftp', + `passive` tinyint(1) NOT NULL DEFAULT 1, + `user_name` varchar(80) DEFAULT NULL, + `password` mediumtext DEFAULT NULL, + `key_file` mediumtext DEFAULT NULL, + `auth_mode` enum('password','key_file','noauth') NOT NULL DEFAULT 'password', + `download_directory` mediumtext DEFAULT NULL, + `upload_directory` mediumtext DEFAULT NULL, + `status` longtext DEFAULT NULL, + `debug` tinyint(1) NOT NULL DEFAULT 0, + 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 */; + -- -- Table structure for table `hold_cancellation_requests` -- @@ -5991,33 +6018,6 @@ CREATE TABLE `sessions` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; --- --- Table structure for table `file_transports` --- - -DROP TABLE IF EXISTS `file_transports`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `file_transports` ( - `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, - `transport` enum('ftp','sftp') NOT NULL DEFAULT 'sftp', - `passive` tinyint(1) NOT NULL DEFAULT 1, - `user_name` varchar(80) DEFAULT NULL, - `password` mediumtext DEFAULT NULL, - `key_file` mediumtext DEFAULT NULL, - `auth_mode` enum('password','key_file','noauth') NOT NULL DEFAULT 'password', - `download_directory` mediumtext DEFAULT NULL, - `upload_directory` mediumtext DEFAULT NULL, - `status` longtext DEFAULT NULL, - `debug` tinyint(1) NOT NULL DEFAULT 0, - 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 */; - -- -- Table structure for table `sms_providers` -- -- 2.34.1