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

(-)a/Koha/Schema/Result/Biblio.pm (-17 / +2 lines)
Lines 240-260 __PACKAGE__->has_many( Link Here
240
  { cascade_copy => 0, cascade_delete => 0 },
240
  { cascade_copy => 0, cascade_delete => 0 },
241
);
241
);
242
242
243
=head2 club_holds
244
245
Type: has_many
246
247
Related object: L<Koha::Schema::Result::ClubHold>
248
249
=cut
250
251
__PACKAGE__->has_many(
252
  "club_holds",
253
  "Koha::Schema::Result::ClubHold",
254
  { "foreign.biblio_id" => "self.biblionumber" },
255
  { cascade_copy => 0, cascade_delete => 0 },
256
);
257
258
=head2 hold_fill_targets
243
=head2 hold_fill_targets
259
244
260
Type: has_many
245
Type: has_many
Lines 406-413 __PACKAGE__->has_many( Link Here
406
);
391
);
407
392
408
393
409
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-01 07:08:47
394
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2020-01-10 16:02:56
410
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:otCex8qzJmZyc+JXpKNdpQ
395
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0iQjTxpVZpOcW5Sg538tVg
411
396
412
397
413
__PACKAGE__->has_one(
398
__PACKAGE__->has_one(
(-)a/Koha/Schema/Result/BiblioMetadata.pm (-4 / +4 lines)
Lines 44-50 __PACKAGE__->table("biblio_metadata"); Link Here
44
=head2 schema
44
=head2 schema
45
45
46
  data_type: 'varchar'
46
  data_type: 'varchar'
47
  is_nullable: 0
47
  is_nullable: 1
48
  size: 16
48
  size: 16
49
49
50
=head2 metadata
50
=head2 metadata
Lines 69-75 __PACKAGE__->add_columns( Link Here
69
  "format",
69
  "format",
70
  { data_type => "varchar", is_nullable => 0, size => 16 },
70
  { data_type => "varchar", is_nullable => 0, size => 16 },
71
  "schema",
71
  "schema",
72
  { data_type => "varchar", is_nullable => 0, size => 16 },
72
  { data_type => "varchar", is_nullable => 1, size => 16 },
73
  "metadata",
73
  "metadata",
74
  { data_type => "longtext", is_nullable => 0 },
74
  { data_type => "longtext", is_nullable => 0 },
75
  "timestamp",
75
  "timestamp",
Lines 132-139 __PACKAGE__->belongs_to( Link Here
132
);
132
);
133
133
134
134
135
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-01-30 11:34:16
135
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2020-01-10 16:02:56
136
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FJk/YOw8Y/QRmmPPL3G5qQ
136
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kyAOIks+HHuiKQvfqxduEg
137
137
138
sub koha_object_class {
138
sub koha_object_class {
139
    'Koha::Biblio::Metadata';
139
    'Koha::Biblio::Metadata';
(-)a/Koha/Schema/Result/Borrower.pm (-15 lines)
Lines 982-1002 __PACKAGE__->has_many( Link Here
982
  { cascade_copy => 0, cascade_delete => 0 },
982
  { cascade_copy => 0, cascade_delete => 0 },
983
);
983
);
984
984
985
=head2 club_holds_to_patron_holds
986
987
Type: has_many
988
989
Related object: L<Koha::Schema::Result::ClubHoldsToPatronHold>
990
991
=cut
992
993
__PACKAGE__->has_many(
994
  "club_holds_to_patron_holds",
995
  "Koha::Schema::Result::ClubHoldsToPatronHold",
996
  { "foreign.patron_id" => "self.borrowernumber" },
997
  { cascade_copy => 0, cascade_delete => 0 },
998
);
999
1000
=head2 course_instructors
985
=head2 course_instructors
1001
986
1002
Type: has_many
987
Type: has_many
(-)a/Koha/Schema/Result/BorrowerModification.pm (-4 / +4 lines)
Lines 40-46 __PACKAGE__->table("borrower_modifications"); Link Here
40
=head2 changed_fields
40
=head2 changed_fields
41
41
42
  data_type: 'mediumtext'
42
  data_type: 'mediumtext'
43
  is_nullable: 0
43
  is_nullable: 1
44
44
45
=head2 borrowernumber
45
=head2 borrowernumber
46
46
Lines 434-440 __PACKAGE__->add_columns( Link Here
434
  "verification_token",
434
  "verification_token",
435
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
435
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
436
  "changed_fields",
436
  "changed_fields",
437
  { data_type => "mediumtext", is_nullable => 0 },
437
  { data_type => "mediumtext", is_nullable => 1 },
438
  "borrowernumber",
438
  "borrowernumber",
439
  { data_type => "integer", default_value => 0, is_nullable => 0 },
439
  { data_type => "integer", default_value => 0, is_nullable => 0 },
440
  "cardnumber",
440
  "cardnumber",
Lines 610-617 __PACKAGE__->add_columns( Link Here
610
__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
610
__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
611
611
612
612
613
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-22 16:54:42
613
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2020-01-10 16:02:56
614
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jkZUTN+mGIdp8ySV0BYNTw
614
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M8mOFapLklUyhFsB5C/SGA
615
615
616
sub koha_object_class {
616
sub koha_object_class {
617
    'Koha::Patron::Modification';
617
    'Koha::Patron::Modification';
(-)a/Koha/Schema/Result/BorrowerRelationship.pm (-10 / +5 lines)
Lines 33-39 __PACKAGE__->table("borrower_relationships"); Link Here
33
33
34
  data_type: 'integer'
34
  data_type: 'integer'
35
  is_foreign_key: 1
35
  is_foreign_key: 1
36
  is_nullable: 1
36
  is_nullable: 0
37
37
38
=head2 guarantee_id
38
=head2 guarantee_id
39
39
Lines 53-59 __PACKAGE__->add_columns( Link Here
53
  "id",
53
  "id",
54
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
54
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
55
  "guarantor_id",
55
  "guarantor_id",
56
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
56
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
57
  "guarantee_id",
57
  "guarantee_id",
58
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
58
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
59
  "relationship",
59
  "relationship",
Lines 117-133 __PACKAGE__->belongs_to( Link Here
117
  "guarantor",
117
  "guarantor",
118
  "Koha::Schema::Result::Borrower",
118
  "Koha::Schema::Result::Borrower",
119
  { borrowernumber => "guarantor_id" },
119
  { borrowernumber => "guarantor_id" },
120
  {
120
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
121
    is_deferrable => 1,
122
    join_type     => "LEFT",
123
    on_delete     => "CASCADE",
124
    on_update     => "CASCADE",
125
  },
126
);
121
);
127
122
128
123
129
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-08-20 15:14:37
124
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2020-01-10 16:02:56
130
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZymvWAn9Nzfuh1lExUIhIg
125
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:icrt6W9Wnyn69FkiuHJOuw
131
126
132
sub koha_objects_class {
127
sub koha_objects_class {
133
    'Koha::Patron::Relationships';
128
    'Koha::Patron::Relationships';
(-)a/Koha/Schema/Result/Club.pm (-17 / +2 lines)
Lines 173-193 __PACKAGE__->has_many( Link Here
173
  { cascade_copy => 0, cascade_delete => 0 },
173
  { cascade_copy => 0, cascade_delete => 0 },
174
);
174
);
175
175
176
=head2 club_holds
177
178
Type: has_many
179
180
Related object: L<Koha::Schema::Result::ClubHold>
181
182
=cut
183
184
__PACKAGE__->has_many(
185
  "club_holds",
186
  "Koha::Schema::Result::ClubHold",
187
  { "foreign.club_id" => "self.id" },
188
  { cascade_copy => 0, cascade_delete => 0 },
189
);
190
191
=head2 club_template
176
=head2 club_template
192
177
193
Type: belongs_to
178
Type: belongs_to
Lines 204-211 __PACKAGE__->belongs_to( Link Here
204
);
189
);
205
190
206
191
207
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-01 07:08:47
192
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2020-01-10 16:02:56
208
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WbB7PSSU4xaszsKe9Eacqw
193
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WqSnfMI5Y1zPi7Z3JEuSlQ
209
194
210
195
211
# You can replace this text with custom content, and it will be preserved on regeneration
196
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/DeletedbiblioMetadata.pm (-4 / +4 lines)
Lines 44-50 __PACKAGE__->table("deletedbiblio_metadata"); Link Here
44
=head2 schema
44
=head2 schema
45
45
46
  data_type: 'varchar'
46
  data_type: 'varchar'
47
  is_nullable: 0
47
  is_nullable: 1
48
  size: 16
48
  size: 16
49
49
50
=head2 metadata
50
=head2 metadata
Lines 69-75 __PACKAGE__->add_columns( Link Here
69
  "format",
69
  "format",
70
  { data_type => "varchar", is_nullable => 0, size => 16 },
70
  { data_type => "varchar", is_nullable => 0, size => 16 },
71
  "schema",
71
  "schema",
72
  { data_type => "varchar", is_nullable => 0, size => 16 },
72
  { data_type => "varchar", is_nullable => 1, size => 16 },
73
  "metadata",
73
  "metadata",
74
  { data_type => "longtext", is_nullable => 0 },
74
  { data_type => "longtext", is_nullable => 0 },
75
  "timestamp",
75
  "timestamp",
Lines 132-139 __PACKAGE__->belongs_to( Link Here
132
);
132
);
133
133
134
134
135
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-01-30 11:34:16
135
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2020-01-10 16:02:56
136
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JCOh+FSSTgPlC8lMJOdOOA
136
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qP9OS+Amaz2DUzVovmFlww
137
137
138
138
139
# You can replace this text with custom code or comments, and it will be preserved on regeneration
139
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Desk.pm (-2 / +17 lines)
Lines 83-91 __PACKAGE__->belongs_to( Link Here
83
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
83
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
84
);
84
);
85
85
86
=head2 reserves
86
87
87
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2019-10-02 13:43:57
88
Type: has_many
88
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IklOycKlChqv9Tftm8rjqA
89
90
Related object: L<Koha::Schema::Result::Reserve>
91
92
=cut
93
94
__PACKAGE__->has_many(
95
  "reserves",
96
  "Koha::Schema::Result::Reserve",
97
  { "foreign.desk_id" => "self.desk_id" },
98
  { cascade_copy => 0, cascade_delete => 0 },
99
);
100
101
102
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2020-01-10 16:02:56
103
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FoGr/XGcK5TtSzNXMTeztg
89
104
90
105
91
# You can replace this text with custom code or comments, and it will be preserved on regeneration
106
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Item.pm (-15 lines)
Lines 510-530 __PACKAGE__->has_many( Link Here
510
  { cascade_copy => 0, cascade_delete => 0 },
510
  { cascade_copy => 0, cascade_delete => 0 },
511
);
511
);
512
512
513
=head2 club_holds
514
515
Type: has_many
516
517
Related object: L<Koha::Schema::Result::ClubHold>
518
519
=cut
520
521
__PACKAGE__->has_many(
522
  "club_holds",
523
  "Koha::Schema::Result::ClubHold",
524
  { "foreign.item_id" => "self.itemnumber" },
525
  { cascade_copy => 0, cascade_delete => 0 },
526
);
527
528
=head2 course_item
513
=head2 course_item
529
514
530
Type: might_have
515
Type: might_have
(-)a/Koha/Schema/Result/OldReserve.pm (+7 lines)
Lines 52-57 __PACKAGE__->table("old_reserves"); Link Here
52
  is_nullable: 1
52
  is_nullable: 1
53
  size: 10
53
  size: 10
54
54
55
=head2 desk_id
56
57
  data_type: 'integer'
58
  is_nullable: 1
59
55
=head2 notificationdate
60
=head2 notificationdate
56
61
57
  data_type: 'date'
62
  data_type: 'date'
Lines 157-162 __PACKAGE__->add_columns( Link Here
157
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
162
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
158
  "branchcode",
163
  "branchcode",
159
  { data_type => "varchar", is_nullable => 1, size => 10 },
164
  { data_type => "varchar", is_nullable => 1, size => 10 },
165
  "desk_id",
166
  { data_type => "integer", is_nullable => 1 },
160
  "notificationdate",
167
  "notificationdate",
161
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
168
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
162
  "reminderdate",
169
  "reminderdate",
(-)a/Koha/Schema/Result/Reserve.pm (-8 / +21 lines)
Lines 56-61 __PACKAGE__->table("reserves"); Link Here
56
  is_nullable: 1
56
  is_nullable: 1
57
  size: 10
57
  size: 10
58
58
59
=head2 desk_id
60
61
  data_type: 'integer'
62
  is_foreign_key: 1
63
  is_nullable: 1
64
59
=head2 notificationdate
65
=head2 notificationdate
60
66
61
  data_type: 'date'
67
  data_type: 'date'
Lines 171-176 __PACKAGE__->add_columns( Link Here
171
  },
177
  },
172
  "branchcode",
178
  "branchcode",
173
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
179
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
180
  "desk_id",
181
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
174
  "notificationdate",
182
  "notificationdate",
175
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
183
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
176
  "reminderdate",
184
  "reminderdate",
Lines 281-299 __PACKAGE__->belongs_to( Link Here
281
  },
289
  },
282
);
290
);
283
291
284
=head2 club_holds_to_patron_holds
292
=head2 desk
285
293
286
Type: has_many
294
Type: belongs_to
287
295
288
Related object: L<Koha::Schema::Result::ClubHoldsToPatronHold>
296
Related object: L<Koha::Schema::Result::Desk>
289
297
290
=cut
298
=cut
291
299
292
__PACKAGE__->has_many(
300
__PACKAGE__->belongs_to(
293
  "club_holds_to_patron_holds",
301
  "desk",
294
  "Koha::Schema::Result::ClubHoldsToPatronHold",
302
  "Koha::Schema::Result::Desk",
295
  { "foreign.hold_id" => "self.reserve_id" },
303
  { desk_id => "desk_id" },
296
  { cascade_copy => 0, cascade_delete => 0 },
304
  {
305
    is_deferrable => 1,
306
    join_type     => "LEFT",
307
    on_delete     => "CASCADE",
308
    on_update     => "CASCADE",
309
  },
297
);
310
);
298
311
299
=head2 itemnumber
312
=head2 itemnumber
(-)a/Koha/Schema/Result/SearchField.pm (-4 / +2 lines)
Lines 64-71 what type of data this holds, relevant when storing it in the search engine Link Here
64
  data_type: 'tinyint'
64
  data_type: 'tinyint'
65
  is_nullable: 1
65
  is_nullable: 1
66
66
67
the order place of the field in facet list if faceted
68
69
=head2 staff_client
67
=head2 staff_client
70
68
71
  data_type: 'tinyint'
69
  data_type: 'tinyint'
Lines 149-156 __PACKAGE__->has_many( Link Here
149
);
147
);
150
148
151
149
152
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-02 12:47:22
150
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2020-01-10 16:02:56
153
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EbUa4eprgxeUkoOUiXO/Cg
151
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hT3LpnNmDmKGyT9v/jpbjg
154
152
155
__PACKAGE__->many_to_many("search_marc_maps", "search_marc_to_fields", "search_marc_map");
153
__PACKAGE__->many_to_many("search_marc_maps", "search_marc_to_fields", "search_marc_map");
156
154
(-)a/Koha/Schema/Result/SearchMarcToField.pm (-11 / +10 lines)
Lines 23-34 __PACKAGE__->table("search_marc_to_field"); Link Here
23
23
24
=head1 ACCESSORS
24
=head1 ACCESSORS
25
25
26
=head2 search
27
28
  data_type: 'tinyint'
29
  default_value: 1
30
  is_nullable: 0
31
32
=head2 search_marc_map_id
26
=head2 search_marc_map_id
33
27
34
  data_type: 'integer'
28
  data_type: 'integer'
Lines 64-74 true if this field can be used to generate suggestions for browse Link Here
64
58
65
true/false creates special sort handling, null doesn't
59
true/false creates special sort handling, null doesn't
66
60
61
=head2 search
62
63
  data_type: 'tinyint'
64
  default_value: 1
65
  is_nullable: 0
66
67
=cut
67
=cut
68
68
69
__PACKAGE__->add_columns(
69
__PACKAGE__->add_columns(
70
  "search",
71
  { data_type => "tinyint", default_value => 1, is_nullable => 0 },
72
  "search_marc_map_id",
70
  "search_marc_map_id",
73
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
71
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
74
  "search_field_id",
72
  "search_field_id",
Lines 79-84 __PACKAGE__->add_columns( Link Here
79
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
77
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
80
  "sort",
78
  "sort",
81
  { data_type => "tinyint", is_nullable => 1 },
79
  { data_type => "tinyint", is_nullable => 1 },
80
  "search",
81
  { data_type => "tinyint", default_value => 1, is_nullable => 0 },
82
);
82
);
83
83
84
=head1 PRIMARY KEY
84
=head1 PRIMARY KEY
Lines 128-135 __PACKAGE__->belongs_to( Link Here
128
);
128
);
129
129
130
130
131
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-02 12:47:22
131
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2020-01-10 16:02:56
132
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9mqZ/zrii+Fv+k+eQNHYUw
132
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QBWMT6sHJw3YfpT+VxIu6g
133
133
134
134
135
# You can replace this text with custom code or comments, and it will be preserved on regeneration
135
# You can replace this text with custom code or comments, and it will be preserved on regeneration
136
- 

Return to bug 24412