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

(-)a/Koha/Schema/Result/Deleteditem.pm (-2 / +26 lines)
Lines 530-538 __PACKAGE__->add_columns( Link Here
530
530
531
__PACKAGE__->set_primary_key("itemnumber");
531
__PACKAGE__->set_primary_key("itemnumber");
532
532
533
=head1 RELATIONS
533
534
534
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-04-28 16:41:47
535
=head2 old_issues
535
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HKee88cG4WAK2dbWrPNrLg
536
537
Type: has_many
538
539
Related object: L<Koha::Schema::Result::OldIssue>
540
541
=cut
542
543
__PACKAGE__->has_many(
544
  "old_issues",
545
  "Koha::Schema::Result::OldIssue",
546
  { "foreign.deleted_itemnumber" => "self.itemnumber" },
547
  { cascade_copy => 0, cascade_delete => 0 },
548
);
549
550
551
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-09-23 09:02:14
552
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:O92pzALvFEWaHGLycrBNAw
553
554
__PACKAGE__->belongs_to(
555
  "biblio",
556
  "Koha::Schema::Result::Biblio",
557
  { biblionumber => "biblionumber" },
558
  { is_deferrable => 1, on_delete => "SET NULL", on_update => "CASCADE" },
559
);
536
560
537
__PACKAGE__->add_columns(
561
__PACKAGE__->add_columns(
538
    '+bookable'                          => { is_boolean => 1 },
562
    '+bookable'                          => { is_boolean => 1 },
(-)a/Koha/Schema/Result/Item.pm (+14 lines)
Lines 1027-1032 __PACKAGE__->belongs_to( Link Here
1027
  },
1027
  },
1028
);
1028
);
1029
1029
1030
__PACKAGE__->might_have(
1031
  "checkout",
1032
  "Koha::Schema::Result::Issue",
1033
  { "foreign.itemnumber" => "self.itemnumber" },
1034
  { cascade_copy => 0, cascade_delete => 0 },
1035
);
1036
1037
__PACKAGE__->has_many(
1038
  "old_checkouts",
1039
  "Koha::Schema::Result::OldIssue",
1040
  { "foreign.itemnumber" => "self.itemnumber" },
1041
  { cascade_copy => 0, cascade_delete => 0 },
1042
);
1043
1030
__PACKAGE__->add_columns(
1044
__PACKAGE__->add_columns(
1031
    '+bookable'                          => { is_boolean => 1 },
1045
    '+bookable'                          => { is_boolean => 1 },
1032
    '+damaged'                           => { is_boolean => 0 },
1046
    '+damaged'                           => { is_boolean => 0 },
(-)a/Koha/Schema/Result/OldIssue.pm (-3 / +44 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 deleted_itemnumber
58
59
  data_type: 'integer'
60
  is_foreign_key: 1
61
  is_nullable: 1
62
63
foreign key, linking this to the deleteditems table for the item that was checked out
64
57
=head2 booking_id
65
=head2 booking_id
58
66
59
  data_type: 'integer'
67
  data_type: 'integer'
Lines 192-197 __PACKAGE__->add_columns( Link Here
192
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
200
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
193
  "itemnumber",
201
  "itemnumber",
194
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
202
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
203
  "deleted_itemnumber",
204
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
195
  "booking_id",
205
  "booking_id",
196
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
206
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
197
  "date_due",
207
  "date_due",
Lines 320-325 __PACKAGE__->belongs_to( Link Here
320
  },
330
  },
321
);
331
);
322
332
333
=head2 deleted_itemnumber
334
335
Type: belongs_to
336
337
Related object: L<Koha::Schema::Result::Deleteditem>
338
339
=cut
340
341
__PACKAGE__->belongs_to(
342
  "deleted_itemnumber",
343
  "Koha::Schema::Result::Deleteditem",
344
  { itemnumber => "deleted_itemnumber" },
345
  {
346
    is_deferrable => 1,
347
    join_type     => "LEFT",
348
    on_delete     => "SET NULL",
349
    on_update     => "SET NULL",
350
  },
351
);
352
323
=head2 issuer
353
=head2 issuer
324
354
325
Type: belongs_to
355
Type: belongs_to
Lines 361-368 __PACKAGE__->belongs_to( Link Here
361
);
391
);
362
392
363
393
364
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-09-05 20:52:04
394
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-09-23 09:02:14
365
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0g+Bdh4Fs1JdmeDEsAS0BA
395
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2jKNbApUIjWoEvnNwr5CNQ
366
396
367
__PACKAGE__->add_columns(
397
__PACKAGE__->add_columns(
368
    '+auto_renew'      => { is_boolean => 1 },
398
    '+auto_renew'      => { is_boolean => 1 },
Lines 389-394 __PACKAGE__->belongs_to( Link Here
389
  },
419
  },
390
);
420
);
391
421
422
__PACKAGE__->belongs_to(
423
  "deleted_item",
424
  "Koha::Schema::Result::Deleteditem",
425
  { itemnumber => "deleted_itemnumber" },
426
  {
427
    is_deferrable => 1,
428
    join_type     => "LEFT",
429
    on_delete     => "SET NULL",
430
    on_update     => "SET NULL",
431
  },
432
);
433
392
__PACKAGE__->belongs_to(
434
__PACKAGE__->belongs_to(
393
  "library",
435
  "library",
394
  "Koha::Schema::Result::Branch",
436
  "Koha::Schema::Result::Branch",
395
- 

Return to bug 40704