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

(-)a/Koha/Schema/Result/FileTransport.pm (-4 / +21 lines)
Lines 52-58 __PACKAGE__->table("file_transports"); Link Here
52
52
53
  data_type: 'enum'
53
  data_type: 'enum'
54
  default_value: 'sftp'
54
  default_value: 'sftp'
55
  extra: {list => ["ftp","sftp"]}
55
  extra: {list => ["ftp","sftp","local"]}
56
  is_nullable: 0
56
  is_nullable: 0
57
57
58
=head2 passive
58
=head2 passive
Lines 125-131 __PACKAGE__->add_columns( Link Here
125
  {
125
  {
126
    data_type => "enum",
126
    data_type => "enum",
127
    default_value => "sftp",
127
    default_value => "sftp",
128
    extra => { list => ["ftp", "sftp"] },
128
    extra => { list => ["ftp", "sftp", "local"] },
129
    is_nullable => 0,
129
    is_nullable => 0,
130
  },
130
  },
131
  "passive",
131
  "passive",
Lines 165-173 __PACKAGE__->add_columns( Link Here
165
165
166
__PACKAGE__->set_primary_key("file_transport_id");
166
__PACKAGE__->set_primary_key("file_transport_id");
167
167
168
=head1 RELATIONS
168
169
169
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-09-15 14:28:35
170
=head2 vendor_edi_accounts
170
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Mpw0xCAH2Jmoxv3V9fHJRw
171
172
Type: has_many
173
174
Related object: L<Koha::Schema::Result::VendorEdiAccount>
175
176
=cut
177
178
__PACKAGE__->has_many(
179
  "vendor_edi_accounts",
180
  "Koha::Schema::Result::VendorEdiAccount",
181
  { "foreign.file_transport_id" => "self.file_transport_id" },
182
  { cascade_copy => 0, cascade_delete => 0 },
183
);
184
185
186
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-09-23 18:55:50
187
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PhzRy63/hkdrU9fyelSOug
171
188
172
__PACKAGE__->add_columns(
189
__PACKAGE__->add_columns(
173
    '+passive' => { is_boolean => 1 },
190
    '+passive' => { is_boolean => 1 },
(-)a/Koha/Schema/Result/VendorEdiAccount.pm (-63 / +30 lines)
Lines 34-66 __PACKAGE__->table("vendor_edi_accounts"); Link Here
34
  data_type: 'mediumtext'
34
  data_type: 'mediumtext'
35
  is_nullable: 0
35
  is_nullable: 0
36
36
37
=head2 host
38
39
  data_type: 'varchar'
40
  is_nullable: 1
41
  size: 40
42
43
=head2 username
44
45
  data_type: 'varchar'
46
  is_nullable: 1
47
  size: 40
48
49
=head2 password
50
51
  data_type: 'mediumtext'
52
  is_nullable: 1
53
54
=head2 upload_port
55
56
  data_type: 'integer'
57
  is_nullable: 1
58
59
=head2 download_port
60
61
  data_type: 'integer'
62
  is_nullable: 1
63
64
=head2 last_activity
37
=head2 last_activity
65
38
66
  data_type: 'date'
39
  data_type: 'date'
Lines 73-88 __PACKAGE__->table("vendor_edi_accounts"); Link Here
73
  is_foreign_key: 1
46
  is_foreign_key: 1
74
  is_nullable: 1
47
  is_nullable: 1
75
48
76
=head2 download_directory
77
78
  data_type: 'mediumtext'
79
  is_nullable: 1
80
81
=head2 upload_directory
82
83
  data_type: 'mediumtext'
84
  is_nullable: 1
85
86
=head2 san
49
=head2 san
87
50
88
  data_type: 'varchar'
51
  data_type: 'varchar'
Lines 103-115 __PACKAGE__->table("vendor_edi_accounts"); Link Here
103
  is_nullable: 1
66
  is_nullable: 1
104
  size: 3
67
  size: 3
105
68
106
=head2 transport
107
108
  data_type: 'varchar'
109
  default_value: 'FTP'
110
  is_nullable: 1
111
  size: 6
112
113
=head2 quotes_enabled
69
=head2 quotes_enabled
114
70
115
  data_type: 'tinyint'
71
  data_type: 'tinyint'
Lines 153-158 __PACKAGE__->table("vendor_edi_accounts"); Link Here
153
  is_nullable: 0
109
  is_nullable: 0
154
  size: 256
110
  size: 256
155
111
112
=head2 file_transport_id
113
114
  data_type: 'integer'
115
  is_foreign_key: 1
116
  is_nullable: 1
117
156
=cut
118
=cut
157
119
158
__PACKAGE__->add_columns(
120
__PACKAGE__->add_columns(
Lines 160-191 __PACKAGE__->add_columns( Link Here
160
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
122
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
161
  "description",
123
  "description",
162
  { data_type => "mediumtext", is_nullable => 0 },
124
  { data_type => "mediumtext", is_nullable => 0 },
163
  "host",
164
  { data_type => "varchar", is_nullable => 1, size => 40 },
165
  "username",
166
  { data_type => "varchar", is_nullable => 1, size => 40 },
167
  "password",
168
  { data_type => "mediumtext", is_nullable => 1 },
169
  "upload_port",
170
  { data_type => "integer", is_nullable => 1 },
171
  "download_port",
172
  { data_type => "integer", is_nullable => 1 },
173
  "last_activity",
125
  "last_activity",
174
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
126
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
175
  "vendor_id",
127
  "vendor_id",
176
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
128
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
177
  "download_directory",
178
  { data_type => "mediumtext", is_nullable => 1 },
179
  "upload_directory",
180
  { data_type => "mediumtext", is_nullable => 1 },
181
  "san",
129
  "san",
182
  { data_type => "varchar", is_nullable => 1, size => 20 },
130
  { data_type => "varchar", is_nullable => 1, size => 20 },
183
  "standard",
131
  "standard",
184
  { data_type => "varchar", default_value => "EUR", is_nullable => 1, size => 3 },
132
  { data_type => "varchar", default_value => "EUR", is_nullable => 1, size => 3 },
185
  "id_code_qualifier",
133
  "id_code_qualifier",
186
  { data_type => "varchar", default_value => 14, is_nullable => 1, size => 3 },
134
  { data_type => "varchar", default_value => 14, is_nullable => 1, size => 3 },
187
  "transport",
188
  { data_type => "varchar", default_value => "FTP", is_nullable => 1, size => 6 },
189
  "quotes_enabled",
135
  "quotes_enabled",
190
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
136
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
191
  "invoices_enabled",
137
  "invoices_enabled",
Lines 200-205 __PACKAGE__->add_columns( Link Here
200
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
146
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
201
  "plugin",
147
  "plugin",
202
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 256 },
148
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 256 },
149
  "file_transport_id",
150
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
203
);
151
);
204
152
205
=head1 PRIMARY KEY
153
=head1 PRIMARY KEY
Lines 231-236 __PACKAGE__->has_many( Link Here
231
  { cascade_copy => 0, cascade_delete => 0 },
179
  { cascade_copy => 0, cascade_delete => 0 },
232
);
180
);
233
181
182
=head2 file_transport
183
184
Type: belongs_to
185
186
Related object: L<Koha::Schema::Result::FileTransport>
187
188
=cut
189
190
__PACKAGE__->belongs_to(
191
  "file_transport",
192
  "Koha::Schema::Result::FileTransport",
193
  { file_transport_id => "file_transport_id" },
194
  {
195
    is_deferrable => 1,
196
    join_type     => "LEFT",
197
    on_delete     => "SET NULL",
198
    on_update     => "CASCADE",
199
  },
200
);
201
234
=head2 shipment_budget
202
=head2 shipment_budget
235
203
236
Type: belongs_to
204
Type: belongs_to
Lines 272-279 __PACKAGE__->belongs_to( Link Here
272
);
240
);
273
241
274
242
275
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-04-19 16:25:44
243
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-09-23 18:55:50
276
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jenUF3Wx7J7F5270mLQMbw
244
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eKyPktjU7CQ+Me3x3Mht0w
277
245
278
__PACKAGE__->add_columns(
246
__PACKAGE__->add_columns(
279
    '+auto_orders'       => { is_boolean => 1 },
247
    '+auto_orders'       => { is_boolean => 1 },
280
- 

Return to bug 38489