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

(-)a/Koha/Schema/Result/Issue.pm (-19 / +8 lines)
Lines 35-41 primary key for issues table Link Here
35
35
36
  data_type: 'integer'
36
  data_type: 'integer'
37
  is_foreign_key: 1
37
  is_foreign_key: 1
38
  is_nullable: 1
38
  is_nullable: 0
39
39
40
foreign key, linking this to the borrowers table for the patron this item was checked out to
40
foreign key, linking this to the borrowers table for the patron this item was checked out to
41
41
Lines 51-57 foreign key, linking this to the borrowers table for the user who checked out th Link Here
51
51
52
  data_type: 'integer'
52
  data_type: 'integer'
53
  is_foreign_key: 1
53
  is_foreign_key: 1
54
  is_nullable: 1
54
  is_nullable: 0
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
Lines 172-182 __PACKAGE__->add_columns( Link Here
172
  "issue_id",
172
  "issue_id",
173
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
173
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
174
  "borrowernumber",
174
  "borrowernumber",
175
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
175
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
176
  "issuer_id",
176
  "issuer_id",
177
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
177
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
178
  "itemnumber",
178
  "itemnumber",
179
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
179
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
180
  "date_due",
180
  "date_due",
181
  {
181
  {
182
    data_type => "datetime",
182
    data_type => "datetime",
Lines 272-283 __PACKAGE__->belongs_to( Link Here
272
  "borrowernumber",
272
  "borrowernumber",
273
  "Koha::Schema::Result::Borrower",
273
  "Koha::Schema::Result::Borrower",
274
  { borrowernumber => "borrowernumber" },
274
  { borrowernumber => "borrowernumber" },
275
  {
275
  { is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" },
276
    is_deferrable => 1,
277
    join_type     => "LEFT",
278
    on_delete     => "RESTRICT",
279
    on_update     => "CASCADE",
280
  },
281
);
276
);
282
277
283
=head2 issuer
278
=head2 issuer
Lines 312-328 __PACKAGE__->belongs_to( Link Here
312
  "itemnumber",
307
  "itemnumber",
313
  "Koha::Schema::Result::Item",
308
  "Koha::Schema::Result::Item",
314
  { itemnumber => "itemnumber" },
309
  { itemnumber => "itemnumber" },
315
  {
310
  { is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" },
316
    is_deferrable => 1,
317
    join_type     => "LEFT",
318
    on_delete     => "RESTRICT",
319
    on_update     => "CASCADE",
320
  },
321
);
311
);
322
312
323
313
324
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-11-17 10:01:24
314
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-04-07 13:01:57
325
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kDcP8DNMT8sLUmzBFfz3fg
315
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cWl4KIpiUfl+uNMXqTTJ8w
326
316
327
__PACKAGE__->add_columns(
317
__PACKAGE__->add_columns(
328
    '+auto_renew'      => { is_boolean => 1 },
318
    '+auto_renew'      => { is_boolean => 1 },
329
- 

Return to bug 30483