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

(-)a/Koha/Schema/Result/ArticleRequest.pm (+258 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::ArticleRequest;
3
4
# Created by DBIx::Class::Schema::Loader
5
# DO NOT MODIFY THE FIRST PART OF THIS FILE
6
7
=head1 NAME
8
9
Koha::Schema::Result::ArticleRequest
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<article_requests>
19
20
=cut
21
22
__PACKAGE__->table("article_requests");
23
24
=head1 ACCESSORS
25
26
=head2 id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 borrowernumber
33
34
  data_type: 'integer'
35
  is_foreign_key: 1
36
  is_nullable: 0
37
38
=head2 biblionumber
39
40
  data_type: 'integer'
41
  is_foreign_key: 1
42
  is_nullable: 0
43
44
=head2 itemnumber
45
46
  data_type: 'integer'
47
  is_foreign_key: 1
48
  is_nullable: 1
49
50
=head2 branchcode
51
52
  data_type: 'varchar'
53
  is_foreign_key: 1
54
  is_nullable: 1
55
  size: 10
56
57
=head2 title
58
59
  data_type: 'text'
60
  is_nullable: 1
61
62
=head2 author
63
64
  data_type: 'text'
65
  is_nullable: 1
66
67
=head2 volume
68
69
  data_type: 'text'
70
  is_nullable: 1
71
72
=head2 issue
73
74
  data_type: 'text'
75
  is_nullable: 1
76
77
=head2 date
78
79
  data_type: 'text'
80
  is_nullable: 1
81
82
=head2 pages
83
84
  data_type: 'text'
85
  is_nullable: 1
86
87
=head2 chapters
88
89
  data_type: 'text'
90
  is_nullable: 1
91
92
=head2 status
93
94
  data_type: 'enum'
95
  default_value: 'OPEN'
96
  extra: {list => ["OPEN","PROCESSING","COMPLETED","CANCELED"]}
97
  is_nullable: 0
98
99
=head2 notes
100
101
  data_type: 'text'
102
  is_nullable: 1
103
104
=head2 created_on
105
106
  data_type: 'timestamp'
107
  datetime_undef_if_invalid: 1
108
  default_value: current_timestamp
109
  is_nullable: 0
110
111
=head2 updated_on
112
113
  data_type: 'timestamp'
114
  datetime_undef_if_invalid: 1
115
  is_nullable: 1
116
117
=cut
118
119
__PACKAGE__->add_columns(
120
  "id",
121
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
122
  "borrowernumber",
123
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
124
  "biblionumber",
125
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
126
  "itemnumber",
127
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
128
  "branchcode",
129
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
130
  "title",
131
  { data_type => "text", is_nullable => 1 },
132
  "author",
133
  { data_type => "text", is_nullable => 1 },
134
  "volume",
135
  { data_type => "text", is_nullable => 1 },
136
  "issue",
137
  { data_type => "text", is_nullable => 1 },
138
  "date",
139
  { data_type => "text", is_nullable => 1 },
140
  "pages",
141
  { data_type => "text", is_nullable => 1 },
142
  "chapters",
143
  { data_type => "text", is_nullable => 1 },
144
  "status",
145
  {
146
    data_type => "enum",
147
    default_value => "OPEN",
148
    extra => { list => ["OPEN", "PROCESSING", "COMPLETED", "CANCELED"] },
149
    is_nullable => 0,
150
  },
151
  "notes",
152
  { data_type => "text", is_nullable => 1 },
153
  "created_on",
154
  {
155
    data_type => "timestamp",
156
    datetime_undef_if_invalid => 1,
157
    default_value => \"current_timestamp",
158
    is_nullable => 0,
159
  },
160
  "updated_on",
161
  {
162
    data_type => "timestamp",
163
    datetime_undef_if_invalid => 1,
164
    is_nullable => 1,
165
  },
166
);
167
168
=head1 PRIMARY KEY
169
170
=over 4
171
172
=item * L</id>
173
174
=back
175
176
=cut
177
178
__PACKAGE__->set_primary_key("id");
179
180
=head1 RELATIONS
181
182
=head2 biblionumber
183
184
Type: belongs_to
185
186
Related object: L<Koha::Schema::Result::Biblio>
187
188
=cut
189
190
__PACKAGE__->belongs_to(
191
  "biblionumber",
192
  "Koha::Schema::Result::Biblio",
193
  { biblionumber => "biblionumber" },
194
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
195
);
196
197
=head2 borrowernumber
198
199
Type: belongs_to
200
201
Related object: L<Koha::Schema::Result::Borrower>
202
203
=cut
204
205
__PACKAGE__->belongs_to(
206
  "borrowernumber",
207
  "Koha::Schema::Result::Borrower",
208
  { borrowernumber => "borrowernumber" },
209
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
210
);
211
212
=head2 branchcode
213
214
Type: belongs_to
215
216
Related object: L<Koha::Schema::Result::Branch>
217
218
=cut
219
220
__PACKAGE__->belongs_to(
221
  "branchcode",
222
  "Koha::Schema::Result::Branch",
223
  { branchcode => "branchcode" },
224
  {
225
    is_deferrable => 1,
226
    join_type     => "LEFT",
227
    on_delete     => "SET NULL",
228
    on_update     => "CASCADE",
229
  },
230
);
231
232
=head2 itemnumber
233
234
Type: belongs_to
235
236
Related object: L<Koha::Schema::Result::Item>
237
238
=cut
239
240
__PACKAGE__->belongs_to(
241
  "itemnumber",
242
  "Koha::Schema::Result::Item",
243
  { itemnumber => "itemnumber" },
244
  {
245
    is_deferrable => 1,
246
    join_type     => "LEFT",
247
    on_delete     => "SET NULL",
248
    on_update     => "CASCADE",
249
  },
250
);
251
252
253
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-05 12:05:51
254
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2oZywCYhBizoEbp96pdIcQ
255
256
257
# You can replace this text with custom code or comments, and it will be preserved on regeneration
258
1;
(-)a/Koha/Schema/Result/Biblio.pm (-2 / +17 lines)
Lines 152-157 __PACKAGE__->has_many( Link Here
152
  { cascade_copy => 0, cascade_delete => 0 },
152
  { cascade_copy => 0, cascade_delete => 0 },
153
);
153
);
154
154
155
=head2 article_requests
156
157
Type: has_many
158
159
Related object: L<Koha::Schema::Result::ArticleRequest>
160
161
=cut
162
163
__PACKAGE__->has_many(
164
  "article_requests",
165
  "Koha::Schema::Result::ArticleRequest",
166
  { "foreign.biblionumber" => "self.biblionumber" },
167
  { cascade_copy => 0, cascade_delete => 0 },
168
);
169
155
=head2 biblioimages
170
=head2 biblioimages
156
171
157
Type: has_many
172
Type: has_many
Lines 303-309 __PACKAGE__->has_many( Link Here
303
);
318
);
304
319
305
320
306
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-07-08 15:06:22
321
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-07-28 10:45:00
307
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vh7DAGajJCEzHE7YmAG3jg
322
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ilygO1c15l0SXYruaJo49w
308
323
309
1;
324
1;
(-)a/Koha/Schema/Result/Borrower.pm (-18 / +60 lines)
Lines 285-302 __PACKAGE__->table("borrowers"); Link Here
285
  is_nullable: 1
285
  is_nullable: 1
286
  size: 100
286
  size: 100
287
287
288
=head2 ethnicity
289
290
  data_type: 'varchar'
291
  is_nullable: 1
292
  size: 50
293
294
=head2 ethnotes
295
296
  data_type: 'varchar'
297
  is_nullable: 1
298
  size: 255
299
300
=head2 sex
288
=head2 sex
301
289
302
  data_type: 'varchar'
290
  data_type: 'varchar'
Lines 401-406 __PACKAGE__->table("borrowers"); Link Here
401
  is_nullable: 1
389
  is_nullable: 1
402
  size: 50
390
  size: 50
403
391
392
=head2 sms_provider_id
393
394
  data_type: 'integer'
395
  is_foreign_key: 1
396
  is_nullable: 1
397
404
=head2 privacy
398
=head2 privacy
405
399
406
  data_type: 'integer'
400
  data_type: 'integer'
Lines 534-543 __PACKAGE__->add_columns( Link Here
534
  { data_type => "mediumtext", is_nullable => 1 },
528
  { data_type => "mediumtext", is_nullable => 1 },
535
  "relationship",
529
  "relationship",
536
  { data_type => "varchar", is_nullable => 1, size => 100 },
530
  { data_type => "varchar", is_nullable => 1, size => 100 },
537
  "ethnicity",
538
  { data_type => "varchar", is_nullable => 1, size => 50 },
539
  "ethnotes",
540
  { data_type => "varchar", is_nullable => 1, size => 255 },
541
  "sex",
531
  "sex",
542
  { data_type => "varchar", is_nullable => 1, size => 1 },
532
  { data_type => "varchar", is_nullable => 1, size => 1 },
543
  "password",
533
  "password",
Lines 574-579 __PACKAGE__->add_columns( Link Here
574
  { data_type => "varchar", is_nullable => 1, size => 50 },
564
  { data_type => "varchar", is_nullable => 1, size => 50 },
575
  "smsalertnumber",
565
  "smsalertnumber",
576
  { data_type => "varchar", is_nullable => 1, size => 50 },
566
  { data_type => "varchar", is_nullable => 1, size => 50 },
567
  "sms_provider_id",
568
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
577
  "privacy",
569
  "privacy",
578
  { data_type => "integer", default_value => 1, is_nullable => 0 },
570
  { data_type => "integer", default_value => 1, is_nullable => 0 },
579
);
571
);
Lines 693-698 __PACKAGE__->has_many( Link Here
693
  { cascade_copy => 0, cascade_delete => 0 },
685
  { cascade_copy => 0, cascade_delete => 0 },
694
);
686
);
695
687
688
=head2 article_requests
689
690
Type: has_many
691
692
Related object: L<Koha::Schema::Result::ArticleRequest>
693
694
=cut
695
696
__PACKAGE__->has_many(
697
  "article_requests",
698
  "Koha::Schema::Result::ArticleRequest",
699
  { "foreign.borrowernumber" => "self.borrowernumber" },
700
  { cascade_copy => 0, cascade_delete => 0 },
701
);
702
696
=head2 borrower_attributes
703
=head2 borrower_attributes
697
704
698
Type: has_many
705
Type: has_many
Lines 873-878 __PACKAGE__->has_many( Link Here
873
  { cascade_copy => 0, cascade_delete => 0 },
880
  { cascade_copy => 0, cascade_delete => 0 },
874
);
881
);
875
882
883
=head2 items_last_borrowers
884
885
Type: has_many
886
887
Related object: L<Koha::Schema::Result::ItemsLastBorrower>
888
889
=cut
890
891
__PACKAGE__->has_many(
892
  "items_last_borrowers",
893
  "Koha::Schema::Result::ItemsLastBorrower",
894
  { "foreign.borrowernumber" => "self.borrowernumber" },
895
  { cascade_copy => 0, cascade_delete => 0 },
896
);
897
876
=head2 message_queues
898
=head2 message_queues
877
899
878
Type: has_many
900
Type: has_many
Lines 1008-1013 __PACKAGE__->has_many( Link Here
1008
  { cascade_copy => 0, cascade_delete => 0 },
1030
  { cascade_copy => 0, cascade_delete => 0 },
1009
);
1031
);
1010
1032
1033
=head2 sms_provider
1034
1035
Type: belongs_to
1036
1037
Related object: L<Koha::Schema::Result::SmsProvider>
1038
1039
=cut
1040
1041
__PACKAGE__->belongs_to(
1042
  "sms_provider",
1043
  "Koha::Schema::Result::SmsProvider",
1044
  { id => "sms_provider_id" },
1045
  {
1046
    is_deferrable => 1,
1047
    join_type     => "LEFT",
1048
    on_delete     => "RESTRICT",
1049
    on_update     => "RESTRICT",
1050
  },
1051
);
1052
1011
=head2 subscriptionroutinglists
1053
=head2 subscriptionroutinglists
1012
1054
1013
Type: has_many
1055
Type: has_many
Lines 1154-1161 Composing rels: L</aqorder_users> -> ordernumber Link Here
1154
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1196
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1155
1197
1156
1198
1157
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-04-27 16:08:40
1199
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-07 07:49:58
1158
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Z50zYBD3Hqlv5/EnoLnyZw
1200
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fnHSfYRgUIXfryLGlrJXZw
1159
1201
1160
1202
1161
# You can replace this text with custom content, and it will be preserved on regeneration
1203
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/BorrowerModification.pm (-18 / +2 lines)
Lines 295-312 __PACKAGE__->table("borrower_modifications"); Link Here
295
  is_nullable: 1
295
  is_nullable: 1
296
  size: 100
296
  size: 100
297
297
298
=head2 ethnicity
299
300
  data_type: 'varchar'
301
  is_nullable: 1
302
  size: 50
303
304
=head2 ethnotes
305
306
  data_type: 'varchar'
307
  is_nullable: 1
308
  size: 255
309
310
=head2 sex
298
=head2 sex
311
299
312
  data_type: 'varchar'
300
  data_type: 'varchar'
Lines 540-549 __PACKAGE__->add_columns( Link Here
540
  { data_type => "mediumtext", is_nullable => 1 },
528
  { data_type => "mediumtext", is_nullable => 1 },
541
  "relationship",
529
  "relationship",
542
  { data_type => "varchar", is_nullable => 1, size => 100 },
530
  { data_type => "varchar", is_nullable => 1, size => 100 },
543
  "ethnicity",
544
  { data_type => "varchar", is_nullable => 1, size => 50 },
545
  "ethnotes",
546
  { data_type => "varchar", is_nullable => 1, size => 255 },
547
  "sex",
531
  "sex",
548
  { data_type => "varchar", is_nullable => 1, size => 1 },
532
  { data_type => "varchar", is_nullable => 1, size => 1 },
549
  "password",
533
  "password",
Lines 599-606 __PACKAGE__->add_columns( Link Here
599
__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
583
__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
600
584
601
585
602
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
586
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-07 07:49:58
603
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xUfsaCL/IR4h5U7AKHmFzw
587
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TrDyluQOsGU1fnrGh8IcUg
604
588
605
589
606
# You can replace this text with custom content, and it will be preserved on regeneration
590
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Branch.pm (-2 / +17 lines)
Lines 202-207 __PACKAGE__->has_many( Link Here
202
  { cascade_copy => 0, cascade_delete => 0 },
202
  { cascade_copy => 0, cascade_delete => 0 },
203
);
203
);
204
204
205
=head2 article_requests
206
207
Type: has_many
208
209
Related object: L<Koha::Schema::Result::ArticleRequest>
210
211
=cut
212
213
__PACKAGE__->has_many(
214
  "article_requests",
215
  "Koha::Schema::Result::ArticleRequest",
216
  { "foreign.branchcode" => "self.branchcode" },
217
  { cascade_copy => 0, cascade_delete => 0 },
218
);
219
205
=head2 authorised_values_branches
220
=head2 authorised_values_branches
206
221
207
Type: has_many
222
Type: has_many
Lines 513-520 Composing rels: L</branchrelations> -> categorycode Link Here
513
__PACKAGE__->many_to_many("categorycodes", "branchrelations", "categorycode");
528
__PACKAGE__->many_to_many("categorycodes", "branchrelations", "categorycode");
514
529
515
530
516
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-11-06 15:26:36
531
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-05 12:05:51
517
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CGNPB/MkGLOihDThj43/4A
532
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8pDEOdJcxKIJW6kAcIDOYA
518
533
519
534
520
# You can replace this text with custom content, and it will be preserved on regeneration
535
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Deletedborrower.pm (-18 / +2 lines)
Lines 283-300 __PACKAGE__->table("deletedborrowers"); Link Here
283
  is_nullable: 1
283
  is_nullable: 1
284
  size: 100
284
  size: 100
285
285
286
=head2 ethnicity
287
288
  data_type: 'varchar'
289
  is_nullable: 1
290
  size: 50
291
292
=head2 ethnotes
293
294
  data_type: 'varchar'
295
  is_nullable: 1
296
  size: 255
297
298
=head2 sex
286
=head2 sex
299
287
300
  data_type: 'varchar'
288
  data_type: 'varchar'
Lines 520-529 __PACKAGE__->add_columns( Link Here
520
  { data_type => "mediumtext", is_nullable => 1 },
508
  { data_type => "mediumtext", is_nullable => 1 },
521
  "relationship",
509
  "relationship",
522
  { data_type => "varchar", is_nullable => 1, size => 100 },
510
  { data_type => "varchar", is_nullable => 1, size => 100 },
523
  "ethnicity",
524
  { data_type => "varchar", is_nullable => 1, size => 50 },
525
  "ethnotes",
526
  { data_type => "varchar", is_nullable => 1, size => 255 },
527
  "sex",
511
  "sex",
528
  { data_type => "varchar", is_nullable => 1, size => 1 },
512
  { data_type => "varchar", is_nullable => 1, size => 1 },
529
  "password",
513
  "password",
Lines 565-572 __PACKAGE__->add_columns( Link Here
565
);
549
);
566
550
567
551
568
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
552
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-07 07:49:59
569
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cRaxMYFjVG7JB7AvsdCweg
553
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AoaPnI0J5R89ziu2SO5UBQ
570
554
571
555
572
# You can replace this text with custom content, and it will be preserved on regeneration
556
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Issuingrule.pm (-2 / +24 lines)
Lines 148-153 __PACKAGE__->table("issuingrules"); Link Here
148
  default_value: 0
148
  default_value: 0
149
  is_nullable: 0
149
  is_nullable: 0
150
150
151
=head2 holds_per_record
152
153
  data_type: 'smallint'
154
  default_value: 1
155
  is_nullable: 0
156
151
=head2 branchcode
157
=head2 branchcode
152
158
153
  data_type: 'varchar'
159
  data_type: 'varchar'
Lines 174-179 __PACKAGE__->table("issuingrules"); Link Here
174
  is_nullable: 0
180
  is_nullable: 0
175
  size: 1
181
  size: 1
176
182
183
=head2 article_requests
184
185
  data_type: 'enum'
186
  default_value: 'no'
187
  extra: {list => ["no","yes","bib_only","item_only"]}
188
  is_nullable: 0
189
177
=cut
190
=cut
178
191
179
__PACKAGE__->add_columns(
192
__PACKAGE__->add_columns(
Lines 226-231 __PACKAGE__->add_columns( Link Here
226
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
239
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
227
  "reservesallowed",
240
  "reservesallowed",
228
  { data_type => "smallint", default_value => 0, is_nullable => 0 },
241
  { data_type => "smallint", default_value => 0, is_nullable => 0 },
242
  "holds_per_record",
243
  { data_type => "smallint", default_value => 1, is_nullable => 0 },
229
  "branchcode",
244
  "branchcode",
230
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
245
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
231
  "overduefinescap",
246
  "overduefinescap",
Lines 234-239 __PACKAGE__->add_columns( Link Here
234
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
249
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
235
  "opacitemholds",
250
  "opacitemholds",
236
  { data_type => "char", default_value => "N", is_nullable => 0, size => 1 },
251
  { data_type => "char", default_value => "N", is_nullable => 0, size => 1 },
252
  "article_requests",
253
  {
254
    data_type => "enum",
255
    default_value => "no",
256
    extra => { list => ["no", "yes", "bib_only", "item_only"] },
257
    is_nullable => 0,
258
  },
237
);
259
);
238
260
239
=head1 PRIMARY KEY
261
=head1 PRIMARY KEY
Lines 253-260 __PACKAGE__->add_columns( Link Here
253
__PACKAGE__->set_primary_key("branchcode", "categorycode", "itemtype");
275
__PACKAGE__->set_primary_key("branchcode", "categorycode", "itemtype");
254
276
255
277
256
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-12-19 07:00:40
278
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-05 12:05:51
257
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CE8yuYC5QgPHI2GOjiT28w
279
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BuOcHnkxlFi7agAWg0sC9g
258
280
259
281
260
# You can replace this text with custom content, and it will be preserved on regeneration
282
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Item.pm (-8 / +23 lines)
Lines 425-430 __PACKAGE__->has_many( Link Here
425
  { cascade_copy => 0, cascade_delete => 0 },
425
  { cascade_copy => 0, cascade_delete => 0 },
426
);
426
);
427
427
428
=head2 article_requests
429
430
Type: has_many
431
432
Related object: L<Koha::Schema::Result::ArticleRequest>
433
434
=cut
435
436
__PACKAGE__->has_many(
437
  "article_requests",
438
  "Koha::Schema::Result::ArticleRequest",
439
  { "foreign.itemnumber" => "self.itemnumber" },
440
  { cascade_copy => 0, cascade_delete => 0 },
441
);
442
428
=head2 biblioitemnumber
443
=head2 biblioitemnumber
429
444
430
Type: belongs_to
445
Type: belongs_to
Lines 555-571 __PACKAGE__->has_many( Link Here
555
  { cascade_copy => 0, cascade_delete => 0 },
570
  { cascade_copy => 0, cascade_delete => 0 },
556
);
571
);
557
572
558
=head2 old_issues
573
=head2 items_last_borrower
559
574
560
Type: has_many
575
Type: might_have
561
576
562
Related object: L<Koha::Schema::Result::OldIssue>
577
Related object: L<Koha::Schema::Result::ItemsLastBorrower>
563
578
564
=cut
579
=cut
565
580
566
__PACKAGE__->has_many(
581
__PACKAGE__->might_have(
567
  "old_issues",
582
  "items_last_borrower",
568
  "Koha::Schema::Result::OldIssue",
583
  "Koha::Schema::Result::ItemsLastBorrower",
569
  { "foreign.itemnumber" => "self.itemnumber" },
584
  { "foreign.itemnumber" => "self.itemnumber" },
570
  { cascade_copy => 0, cascade_delete => 0 },
585
  { cascade_copy => 0, cascade_delete => 0 },
571
);
586
);
Lines 616-623 __PACKAGE__->might_have( Link Here
616
);
631
);
617
632
618
633
619
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-04-23 12:42:12
634
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-05 12:05:51
620
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:urSpNt7LBda4T5Plhi6cPw
635
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SuwK+FM6ln1whQMW9gDOng
621
636
622
sub effective_itemtype {
637
sub effective_itemtype {
623
    my ( $self ) = @_;
638
    my ( $self ) = @_;
(-)a/Koha/Schema/Result/MarcModificationTemplateAction.pm (-6 / +12 lines)
Lines 43-50 __PACKAGE__->table("marc_modification_template_actions"); Link Here
43
=head2 action
43
=head2 action
44
44
45
  data_type: 'enum'
45
  data_type: 'enum'
46
  extra: {list => ["delete_field","update_field","move_field","copy_field"]}
46
  extra: {list => ["delete_field","update_field","move_field","copy_field","copy_and_replace_field"]}
47
  is_nullable: 0
47
  is_nullable: 1
48
48
49
=head2 field_number
49
=head2 field_number
50
50
Lines 152-160 __PACKAGE__->add_columns( Link Here
152
  {
152
  {
153
    data_type => "enum",
153
    data_type => "enum",
154
    extra => {
154
    extra => {
155
      list => ["delete_field", "update_field", "move_field", "copy_field"],
155
      list => [
156
        "delete_field",
157
        "update_field",
158
        "move_field",
159
        "copy_field",
160
        "copy_and_replace_field",
161
      ],
156
    },
162
    },
157
    is_nullable => 0,
163
    is_nullable => 1,
158
  },
164
  },
159
  "field_number",
165
  "field_number",
160
  { data_type => "smallint", default_value => 0, is_nullable => 0 },
166
  { data_type => "smallint", default_value => 0, is_nullable => 0 },
Lines 228-235 __PACKAGE__->belongs_to( Link Here
228
);
234
);
229
235
230
236
231
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-31 22:03:59
237
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-05 12:05:51
232
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sl0AD0sWPYcKRjHN3l3eFg
238
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ABLNsTQXblDEZTGWQ5LmTA
233
239
234
240
235
# You can replace this text with custom code or comments, and it will be preserved on regeneration
241
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/OldIssue.pm (-24 / +3 lines)
Lines 37-43 __PACKAGE__->table("old_issues"); Link Here
37
=head2 itemnumber
37
=head2 itemnumber
38
38
39
  data_type: 'integer'
39
  data_type: 'integer'
40
  is_foreign_key: 1
41
  is_nullable: 1
40
  is_nullable: 1
42
41
43
=head2 date_due
42
=head2 date_due
Lines 108-114 __PACKAGE__->add_columns( Link Here
108
  "borrowernumber",
107
  "borrowernumber",
109
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
108
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
110
  "itemnumber",
109
  "itemnumber",
111
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
110
  { data_type => "integer", is_nullable => 1 },
112
  "date_due",
111
  "date_due",
113
  {
112
  {
114
    data_type => "datetime",
113
    data_type => "datetime",
Lines 186-214 __PACKAGE__->belongs_to( Link Here
186
  },
185
  },
187
);
186
);
188
187
189
=head2 itemnumber
190
191
Type: belongs_to
192
193
Related object: L<Koha::Schema::Result::Item>
194
195
=cut
196
197
__PACKAGE__->belongs_to(
198
  "itemnumber",
199
  "Koha::Schema::Result::Item",
200
  { itemnumber => "itemnumber" },
201
  {
202
    is_deferrable => 1,
203
    join_type     => "LEFT",
204
    on_delete     => "SET NULL",
205
    on_update     => "SET NULL",
206
  },
207
);
208
209
188
210
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-04-23 13:04:51
189
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-05 12:05:51
211
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9GdzytyInRcFZns/q0qb3Q
190
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zK8c497/M5+qUGoNLl4Qlg
212
191
213
192
214
# You can replace this text with custom content, and it will be preserved on regeneration
193
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/OldReserve.pm (-2 / +14 lines)
Lines 129-134 __PACKAGE__->table("old_reserves"); Link Here
129
  datetime_undef_if_invalid: 1
129
  datetime_undef_if_invalid: 1
130
  is_nullable: 1
130
  is_nullable: 1
131
131
132
=head2 printed
133
134
  data_type: 'datetime'
135
  datetime_undef_if_invalid: 1
136
  is_nullable: 1
137
132
=cut
138
=cut
133
139
134
__PACKAGE__->add_columns(
140
__PACKAGE__->add_columns(
Lines 177-182 __PACKAGE__->add_columns( Link Here
177
    datetime_undef_if_invalid => 1,
183
    datetime_undef_if_invalid => 1,
178
    is_nullable => 1,
184
    is_nullable => 1,
179
  },
185
  },
186
  "printed",
187
  {
188
    data_type => "datetime",
189
    datetime_undef_if_invalid => 1,
190
    is_nullable => 1,
191
  },
180
);
192
);
181
193
182
=head1 PRIMARY KEY
194
=head1 PRIMARY KEY
Lines 254-261 __PACKAGE__->belongs_to( Link Here
254
);
266
);
255
267
256
268
257
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-06-30 08:51:40
269
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-05 12:05:51
258
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wGi7SO5Sz+IwuvqaAyQDbg
270
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TyCBk+/ITZ4VzxpMBzOdyg
259
271
260
272
261
# You can replace this text with custom content, and it will be preserved on regeneration
273
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Printer.pm (-20 / +24 lines)
Lines 23-73 __PACKAGE__->table("printers"); Link Here
23
23
24
=head1 ACCESSORS
24
=head1 ACCESSORS
25
25
26
=head2 printername
26
=head2 id
27
27
28
  data_type: 'varchar'
28
  data_type: 'integer'
29
  default_value: (empty string)
29
  is_auto_increment: 1
30
  is_nullable: 0
30
  is_nullable: 0
31
  size: 40
32
31
33
=head2 printqueue
32
=head2 name
34
33
35
  data_type: 'varchar'
34
  data_type: 'text'
35
  is_nullable: 0
36
37
=head2 queue
38
39
  data_type: 'text'
36
  is_nullable: 1
40
  is_nullable: 1
37
  size: 20
38
41
39
=head2 printtype
42
=head2 type
40
43
41
  data_type: 'varchar'
44
  data_type: 'text'
42
  is_nullable: 1
45
  is_nullable: 1
43
  size: 20
44
46
45
=cut
47
=cut
46
48
47
__PACKAGE__->add_columns(
49
__PACKAGE__->add_columns(
48
  "printername",
50
  "id",
49
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 40 },
51
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
50
  "printqueue",
52
  "name",
51
  { data_type => "varchar", is_nullable => 1, size => 20 },
53
  { data_type => "text", is_nullable => 0 },
52
  "printtype",
54
  "queue",
53
  { data_type => "varchar", is_nullable => 1, size => 20 },
55
  { data_type => "text", is_nullable => 1 },
56
  "type",
57
  { data_type => "text", is_nullable => 1 },
54
);
58
);
55
59
56
=head1 PRIMARY KEY
60
=head1 PRIMARY KEY
57
61
58
=over 4
62
=over 4
59
63
60
=item * L</printername>
64
=item * L</id>
61
65
62
=back
66
=back
63
67
64
=cut
68
=cut
65
69
66
__PACKAGE__->set_primary_key("printername");
70
__PACKAGE__->set_primary_key("id");
67
71
68
72
69
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
73
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-05 12:05:51
70
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OaIxwtdwn0TJLggwOygC2w
74
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Azf83iQPMGJpxWowO3EK7Q
71
75
72
76
73
# You can replace this text with custom content, and it will be preserved on regeneration
77
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Reserve.pm (-3 / +14 lines)
Lines 133-138 __PACKAGE__->table("reserves"); Link Here
133
  datetime_undef_if_invalid: 1
133
  datetime_undef_if_invalid: 1
134
  is_nullable: 1
134
  is_nullable: 1
135
135
136
=head2 printed
137
138
  data_type: 'datetime'
139
  datetime_undef_if_invalid: 1
140
  is_nullable: 1
141
136
=cut
142
=cut
137
143
138
__PACKAGE__->add_columns(
144
__PACKAGE__->add_columns(
Lines 191-196 __PACKAGE__->add_columns( Link Here
191
    datetime_undef_if_invalid => 1,
197
    datetime_undef_if_invalid => 1,
192
    is_nullable => 1,
198
    is_nullable => 1,
193
  },
199
  },
200
  "printed",
201
  {
202
    data_type => "datetime",
203
    datetime_undef_if_invalid => 1,
204
    is_nullable => 1,
205
  },
194
);
206
);
195
207
196
=head1 PRIMARY KEY
208
=head1 PRIMARY KEY
Lines 278-285 __PACKAGE__->belongs_to( Link Here
278
);
290
);
279
291
280
292
281
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-06-30 08:51:40
293
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-05 12:05:51
282
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uHHqseJ56g3nDyKnNncyUA
294
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:h7jkbIPxF550/i0iwWZmFw
283
295
284
__PACKAGE__->belongs_to(
296
__PACKAGE__->belongs_to(
285
  "item",
297
  "item",
286
- 

Return to bug 14610