Bugzilla – Attachment 187671 Details for
Bug 39190
Rework new (S)FTP classes to be polymorphic classes
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 39190: Fix DB struct diff
Bug-39190-Fix-DB-struct-diff.patch (text/plain), 3.20 KB, created by
Jonathan Druart
on 2025-10-09 15:03:12 UTC
(
hide
)
Description:
Bug 39190: Fix DB struct diff
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2025-10-09 15:03:12 UTC
Size:
3.20 KB
patch
obsolete
>From c57f01359c485cdea6e1572eefd582d3d49d6e39 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 39190
:
178555
|
178556
|
178557
|
178558
|
178559
|
178560
|
178561
|
178562
|
178563
|
178564
|
178565
|
178566
|
178567
|
178568
|
178569
|
178570
|
178571
|
179252
|
179253
|
179254
|
179255
|
179256
|
179257
|
179258
|
179259
|
179260
|
179261
|
179262
|
179263
|
179264
|
179265
|
179266
|
179267
|
179268
|
179396
|
179397
|
179398
|
179399
|
179400
|
179401
|
179402
|
179403
|
179404
|
179405
|
179406
|
179407
|
179408
|
179409
|
179410
|
179411
|
179412
|
179413
|
179589
|
179590
|
179591
|
179592
|
179593
|
179594
|
179595
|
179596
|
179597
|
179598
|
179599
|
179600
|
179601
|
179602
|
179603
|
179604
|
179605
|
179606
|
179646
|
179647
|
179648
|
179649
|
179650
|
179651
|
179652
|
179653
|
179654
|
179655
|
179656
|
179657
|
179658
|
179659
|
179660
|
179661
|
179662
|
179663
|
179992
|
179993
|
179994
|
179995
|
179996
|
179997
|
179998
|
179999
|
180000
|
180001
|
180002
|
180003
|
180004
|
180005
|
180006
|
180010
|
180011
|
180012
|
180013
|
180014
|
180015
|
180016
|
180017
|
180018
|
180019
|
180020
|
180021
|
180022
|
180023
|
180024
|
180025
|
185014
|
185015
|
185016
|
185017
|
185018
|
185019
|
185020
|
185021
|
185022
|
185023
|
185024
|
185025
|
185026
|
185027
|
185028
|
185029
|
185972
|
185973
|
185974
|
185975
|
185976
|
185977
|
185978
|
185979
|
185980
|
185981
|
185982
|
185983
|
185984
|
185985
|
185986
|
185987
|
185988
|
185989
|
185990
|
185994
|
185995
|
185996
|
185997
|
185998
|
186408
|
186409
|
186410
|
186411
|
186412
|
186413
|
186414
|
186415
|
186416
|
186417
|
186418
|
186419
|
186420
|
186421
|
186422
|
186423
|
186424
|
186425
|
186426
|
186427
|
186428
|
186429
|
186430
|
186431
|
186619
|
186628
|
187671
|
187701