View | Details | Raw Unified | Return to bug 39190
Collapse All | Expand All

(-)a/Koha/Schema/Result/FileTransport.pm (-6 / +6 lines)
Lines 23-29 __PACKAGE__->table("file_transports"); Link Here
23
23
24
=head1 ACCESSORS
24
=head1 ACCESSORS
25
25
26
=head2 id
26
=head2 file_transport_id
27
27
28
  data_type: 'integer'
28
  data_type: 'integer'
29
  is_auto_increment: 1
29
  is_auto_increment: 1
Lines 108-114 __PACKAGE__->table("file_transports"); Link Here
108
=cut
108
=cut
109
109
110
__PACKAGE__->add_columns(
110
__PACKAGE__->add_columns(
111
  "id",
111
  "file_transport_id",
112
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
112
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
113
  "name",
113
  "name",
114
  { data_type => "varchar", is_nullable => 0, size => 80 },
114
  { data_type => "varchar", is_nullable => 0, size => 80 },
Lines 157-173 __PACKAGE__->add_columns( Link Here
157
157
158
=over 4
158
=over 4
159
159
160
=item * L</id>
160
=item * L</file_transport_id>
161
161
162
=back
162
=back
163
163
164
=cut
164
=cut
165
165
166
__PACKAGE__->set_primary_key("id");
166
__PACKAGE__->set_primary_key("file_transport_id");
167
167
168
168
169
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-08-29 20:23:47
169
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-09-15 14:28:35
170
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eeoKreXE9wfz12s4ENo5Tg
170
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Mpw0xCAH2Jmoxv3V9fHJRw
171
171
172
__PACKAGE__->add_columns(
172
__PACKAGE__->add_columns(
173
    '+passive' => { is_boolean => 1 },
173
    '+passive' => { is_boolean => 1 },
(-)a/installer/data/mysql/atomicupdate/bug_35761-add_SFTP_tables_and_perm.pl (-2 / +2 lines)
Lines 19-25 return { Link Here
19
            $dbh->do(
19
            $dbh->do(
20
                q {
20
                q {
21
                    CREATE TABLE `file_transports` (
21
                    CREATE TABLE `file_transports` (
22
                    `id` int(11) NOT NULL AUTO_INCREMENT,
22
                    `file_transport_id` int(11) NOT NULL AUTO_INCREMENT,
23
                    `name` varchar(80) NOT NULL,
23
                    `name` varchar(80) NOT NULL,
24
                    `host` varchar(80) NOT NULL DEFAULT 'localhost',
24
                    `host` varchar(80) NOT NULL DEFAULT 'localhost',
25
                    `port` int(11) NOT NULL DEFAULT 22,
25
                    `port` int(11) NOT NULL DEFAULT 22,
Lines 33-39 return { Link Here
33
                    `upload_directory` mediumtext DEFAULT NULL,
33
                    `upload_directory` mediumtext DEFAULT NULL,
34
                    `status` longtext DEFAULT NULL,
34
                    `status` longtext DEFAULT NULL,
35
                    `debug` tinyint(1) NOT NULL DEFAULT 0,
35
                    `debug` tinyint(1) NOT NULL DEFAULT 0,
36
                    PRIMARY KEY (`id`),
36
                    PRIMARY KEY (`file_transport_id`),
37
                    KEY `host_idx` (`host`)
37
                    KEY `host_idx` (`host`)
38
                    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
38
                    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
39
                }
39
                }
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 5996-6002 DROP TABLE IF EXISTS `file_transports`; Link Here
5996
/*!40101 SET @saved_cs_client     = @@character_set_client */;
5996
/*!40101 SET @saved_cs_client     = @@character_set_client */;
5997
/*!40101 SET character_set_client = utf8 */;
5997
/*!40101 SET character_set_client = utf8 */;
5998
CREATE TABLE `file_transports` (
5998
CREATE TABLE `file_transports` (
5999
  `id` int(11) NOT NULL AUTO_INCREMENT,
5999
  `file_transport_id` int(11) NOT NULL AUTO_INCREMENT,
6000
  `name` varchar(80) NOT NULL,
6000
  `name` varchar(80) NOT NULL,
6001
  `host` varchar(80) NOT NULL DEFAULT 'localhost',
6001
  `host` varchar(80) NOT NULL DEFAULT 'localhost',
6002
  `port` int(11) NOT NULL DEFAULT 22,
6002
  `port` int(11) NOT NULL DEFAULT 22,
Lines 6010-6016 CREATE TABLE `file_transports` ( Link Here
6010
  `upload_directory` mediumtext DEFAULT NULL,
6010
  `upload_directory` mediumtext DEFAULT NULL,
6011
  `status` longtext DEFAULT NULL,
6011
  `status` longtext DEFAULT NULL,
6012
  `debug` tinyint(1) NOT NULL DEFAULT 0,
6012
  `debug` tinyint(1) NOT NULL DEFAULT 0,
6013
  PRIMARY KEY (`id`),
6013
  PRIMARY KEY (`file_transport_id`),
6014
  KEY `host_idx` (`host`)
6014
  KEY `host_idx` (`host`)
6015
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6015
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6016
/*!40101 SET character_set_client = @saved_cs_client */;
6016
/*!40101 SET character_set_client = @saved_cs_client */;
(-)a/t/db_dependent/Koha/File/Transports.t (-2 / +2 lines)
Lines 94-100 subtest 'search() tests' => sub { Link Here
94
    );
94
    );
95
95
96
    # Search for both transports
96
    # Search for both transports
97
    my $transports = Koha::File::Transports->search( { id => { -in => [ $sftp_transport->id, $ftp_transport->id ] } } );
97
    my $transports = Koha::File::Transports->search(
98
        { file_transport_id => { -in => [ $sftp_transport->id, $ftp_transport->id ] } } );
98
99
99
    is(
100
    is(
100
        ref($transports), 'Koha::File::Transports',
101
        ref($transports), 'Koha::File::Transports',
101
- 

Return to bug 39190