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

(-)a/Koha/Schema/Result/Booking.pm (-2 / +32 lines)
Lines 206-211 __PACKAGE__->belongs_to( Link Here
206
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
206
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
207
);
207
);
208
208
209
=head2 issues
210
211
Type: has_many
212
213
Related object: L<Koha::Schema::Result::Issue>
214
215
=cut
216
217
__PACKAGE__->has_many(
218
  "issues",
219
  "Koha::Schema::Result::Issue",
220
  { "foreign.booking_id" => "self.booking_id" },
221
  { cascade_copy => 0, cascade_delete => 0 },
222
);
223
209
=head2 item
224
=head2 item
210
225
211
Type: belongs_to
226
Type: belongs_to
Lines 226-231 __PACKAGE__->belongs_to( Link Here
226
  },
241
  },
227
);
242
);
228
243
244
=head2 old_issues
245
246
Type: has_many
247
248
Related object: L<Koha::Schema::Result::OldIssue>
249
250
=cut
251
252
__PACKAGE__->has_many(
253
  "old_issues",
254
  "Koha::Schema::Result::OldIssue",
255
  { "foreign.booking_id" => "self.booking_id" },
256
  { cascade_copy => 0, cascade_delete => 0 },
257
);
258
229
=head2 patron
259
=head2 patron
230
260
231
Type: belongs_to
261
Type: belongs_to
Lines 257-264 __PACKAGE__->belongs_to( Link Here
257
);
287
);
258
288
259
289
260
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-24 16:23:05
290
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-08-29 09:57:15
261
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kTR2kwiwY2PnjU1E0P+CMQ
291
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FEyrrb36hjJj6j8BKKA7gQ
262
292
263
293
264
# You can replace this text with custom code or comments, and it will be preserved on regeneration
294
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Issue.pm (-2 / +32 lines)
Lines 55-60 foreign key, linking this to the borrowers table for the user who checked out th Link Here
55
55
56
foreign key, linking this to the items table for the item that was checked out
56
foreign key, linking this to the items table for the item that was checked out
57
57
58
=head2 booking_id
59
60
  data_type: 'integer'
61
  is_foreign_key: 1
62
  is_nullable: 1
63
64
foreign key linking this checkout to the booking it fulfills
65
58
=head2 date_due
66
=head2 date_due
59
67
60
  data_type: 'datetime'
68
  data_type: 'datetime'
Lines 185-190 __PACKAGE__->add_columns( Link Here
185
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
193
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
186
  "itemnumber",
194
  "itemnumber",
187
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
195
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
196
  "booking_id",
197
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
188
  "date_due",
198
  "date_due",
189
  {
199
  {
190
    data_type => "datetime",
200
    data_type => "datetime",
Lines 285-290 __PACKAGE__->has_many( Link Here
285
  { cascade_copy => 0, cascade_delete => 0 },
295
  { cascade_copy => 0, cascade_delete => 0 },
286
);
296
);
287
297
298
=head2 booking
299
300
Type: belongs_to
301
302
Related object: L<Koha::Schema::Result::Booking>
303
304
=cut
305
306
__PACKAGE__->belongs_to(
307
  "booking",
308
  "Koha::Schema::Result::Booking",
309
  { booking_id => "booking_id" },
310
  {
311
    is_deferrable => 1,
312
    join_type     => "LEFT",
313
    on_delete     => "SET NULL",
314
    on_update     => "CASCADE",
315
  },
316
);
317
288
=head2 borrowernumber
318
=head2 borrowernumber
289
319
290
Type: belongs_to
320
Type: belongs_to
Lines 336-343 __PACKAGE__->belongs_to( Link Here
336
);
366
);
337
367
338
368
339
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-05-06 16:22:12
369
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-08-29 09:57:15
340
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sCGlwnT9B7Mn1k80Gme6hw
370
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4NoLuAW2nJWH/n19NVt72g
341
371
342
__PACKAGE__->add_columns(
372
__PACKAGE__->add_columns(
343
    '+auto_renew'      => { is_boolean => 1 },
373
    '+auto_renew'      => { is_boolean => 1 },
(-)a/Koha/Schema/Result/Itemtype.pm (-12 / +12 lines)
Lines 176-189 Group this item type with others with the same value on OPAC search options Link Here
176
176
177
If automatic checkin is enabled for items of this type
177
If automatic checkin is enabled for items of this type
178
178
179
=head2 bookable
180
181
  data_type: 'tinyint'
182
  default_value: 0
183
  is_nullable: 0
184
185
Activate bookable feature for items related to this item type
186
187
=head2 checkprevcheckout
179
=head2 checkprevcheckout
188
180
189
  data_type: 'enum'
181
  data_type: 'enum'
Lines 193-198 Activate bookable feature for items related to this item type Link Here
193
185
194
produce a warning for a patron if a item of this type has previously been checked out to the same patron if 'yes', not if 'no', defer to category setting if 'inherit'.
186
produce a warning for a patron if a item of this type has previously been checked out to the same patron if 'yes', not if 'no', defer to category setting if 'inherit'.
195
187
188
=head2 bookable
189
190
  data_type: 'tinyint'
191
  default_value: 0
192
  is_nullable: 0
193
194
Activate bookable feature for items related to this item type
195
196
=cut
196
=cut
197
197
198
__PACKAGE__->add_columns(
198
__PACKAGE__->add_columns(
Lines 239-246 __PACKAGE__->add_columns( Link Here
239
  { data_type => "varchar", is_nullable => 1, size => 80 },
239
  { data_type => "varchar", is_nullable => 1, size => 80 },
240
  "automatic_checkin",
240
  "automatic_checkin",
241
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
241
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
242
  "bookable",
243
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
244
  "checkprevcheckout",
242
  "checkprevcheckout",
245
  {
243
  {
246
    data_type => "enum",
244
    data_type => "enum",
Lines 248-253 __PACKAGE__->add_columns( Link Here
248
    extra => { list => ["yes", "no", "inherit"] },
246
    extra => { list => ["yes", "no", "inherit"] },
249
    is_nullable => 0,
247
    is_nullable => 0,
250
  },
248
  },
249
  "bookable",
250
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
251
);
251
);
252
252
253
=head1 PRIMARY KEY
253
=head1 PRIMARY KEY
Lines 360-367 __PACKAGE__->has_many( Link Here
360
);
360
);
361
361
362
362
363
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-08-20 19:06:37
363
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-08-29 09:57:15
364
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:T/3QdCb353e+qBkN4as7Bg
364
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GlyegvJnPS5lYmtZRH20KQ
365
365
366
__PACKAGE__->add_columns(
366
__PACKAGE__->add_columns(
367
    '+automatic_checkin'            => { is_boolean => 1 },
367
    '+automatic_checkin'            => { is_boolean => 1 },
(-)a/Koha/Schema/Result/OldIssue.pm (-2 / +32 lines)
Lines 54-59 foreign key, linking this to the borrowers table for the user who checked out th Link Here
54
54
55
foreign key, linking this to the items table for the item that was checked out
55
foreign key, linking this to the items table for the item that was checked out
56
56
57
=head2 booking_id
58
59
  data_type: 'integer'
60
  is_foreign_key: 1
61
  is_nullable: 1
62
63
foreign key linking this checkout to the booking it fulfilled
64
57
=head2 date_due
65
=head2 date_due
58
66
59
  data_type: 'datetime'
67
  data_type: 'datetime'
Lines 184-189 __PACKAGE__->add_columns( Link Here
184
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
192
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
185
  "itemnumber",
193
  "itemnumber",
186
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
194
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
195
  "booking_id",
196
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
187
  "date_due",
197
  "date_due",
188
  {
198
  {
189
    data_type => "datetime",
199
    data_type => "datetime",
Lines 270-275 __PACKAGE__->has_many( Link Here
270
  { cascade_copy => 0, cascade_delete => 0 },
280
  { cascade_copy => 0, cascade_delete => 0 },
271
);
281
);
272
282
283
=head2 booking
284
285
Type: belongs_to
286
287
Related object: L<Koha::Schema::Result::Booking>
288
289
=cut
290
291
__PACKAGE__->belongs_to(
292
  "booking",
293
  "Koha::Schema::Result::Booking",
294
  { booking_id => "booking_id" },
295
  {
296
    is_deferrable => 1,
297
    join_type     => "LEFT",
298
    on_delete     => "SET NULL",
299
    on_update     => "CASCADE",
300
  },
301
);
302
273
=head2 borrowernumber
303
=head2 borrowernumber
274
304
275
Type: belongs_to
305
Type: belongs_to
Lines 331-338 __PACKAGE__->belongs_to( Link Here
331
);
361
);
332
362
333
363
334
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-05-06 16:22:12
364
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-08-29 09:57:15
335
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bO+nRkR4QDXrb5wmEOz9mw
365
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LNRlWzUjwNnp7tWmtgO9OQ
336
366
337
__PACKAGE__->add_columns(
367
__PACKAGE__->add_columns(
338
    '+auto_renew'      => { is_boolean => 1 },
368
    '+auto_renew'      => { is_boolean => 1 },
(-)a/Koha/Schema/Result/Statistic.pm (-5 / +2 lines)
Lines 67-74 used by SIP Link Here
67
  data_type: 'integer'
67
  data_type: 'integer'
68
  is_nullable: 1
68
  is_nullable: 1
69
69
70
foreign key from the illrequests table, links transaction to a specific illrequest
71
72
=head2 itemnumber
70
=head2 itemnumber
73
71
74
  data_type: 'integer'
72
  data_type: 'integer'
Lines 159-166 __PACKAGE__->add_columns( Link Here
159
);
157
);
160
158
161
159
162
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-08-20 19:38:05
160
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-08-29 09:57:15
163
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RthuhgFIXWLLDyprEtdx3g
161
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8ypTJrAAiw2Oq0X04+NdHA
164
162
165
163
166
# You can replace this text with custom content, and it will be preserved on regeneration
164
# You can replace this text with custom content, and it will be preserved on regeneration
167
- 

Return to bug 40665