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

(-)a/Koha/Schema/Result/AccountCredit.pm (+171 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::AccountCredit;
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::AccountCredit
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<account_credits>
19
20
=cut
21
22
__PACKAGE__->table("account_credits");
23
24
=head1 ACCESSORS
25
26
=head2 credit_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_nullable: 0
36
37
=head2 type
38
39
  data_type: 'varchar'
40
  is_nullable: 0
41
  size: 255
42
43
=head2 amount_received
44
45
  data_type: 'decimal'
46
  is_nullable: 1
47
  size: [28,6]
48
49
=head2 amount_paid
50
51
  data_type: 'decimal'
52
  is_nullable: 0
53
  size: [28,6]
54
55
=head2 amount_remaining
56
57
  data_type: 'decimal'
58
  is_nullable: 0
59
  size: [28,6]
60
61
=head2 amount_voided
62
63
  data_type: 'decimal'
64
  is_nullable: 1
65
  size: [28,6]
66
67
=head2 notes
68
69
  data_type: 'text'
70
  is_nullable: 1
71
72
=head2 branchcode
73
74
  data_type: 'varchar'
75
  is_nullable: 1
76
  size: 10
77
78
=head2 manager_id
79
80
  data_type: 'integer'
81
  is_nullable: 1
82
83
=head2 created_on
84
85
  data_type: 'timestamp'
86
  datetime_undef_if_invalid: 1
87
  is_nullable: 1
88
89
=head2 updated_on
90
91
  data_type: 'timestamp'
92
  datetime_undef_if_invalid: 1
93
  is_nullable: 1
94
95
=cut
96
97
__PACKAGE__->add_columns(
98
  "credit_id",
99
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
100
  "borrowernumber",
101
  { data_type => "integer", is_nullable => 0 },
102
  "type",
103
  { data_type => "varchar", is_nullable => 0, size => 255 },
104
  "amount_received",
105
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
106
  "amount_paid",
107
  { data_type => "decimal", is_nullable => 0, size => [28, 6] },
108
  "amount_remaining",
109
  { data_type => "decimal", is_nullable => 0, size => [28, 6] },
110
  "amount_voided",
111
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
112
  "notes",
113
  { data_type => "text", is_nullable => 1 },
114
  "branchcode",
115
  { data_type => "varchar", is_nullable => 1, size => 10 },
116
  "manager_id",
117
  { data_type => "integer", is_nullable => 1 },
118
  "created_on",
119
  {
120
    data_type => "timestamp",
121
    datetime_undef_if_invalid => 1,
122
    is_nullable => 1,
123
  },
124
  "updated_on",
125
  {
126
    data_type => "timestamp",
127
    datetime_undef_if_invalid => 1,
128
    is_nullable => 1,
129
  },
130
);
131
132
=head1 PRIMARY KEY
133
134
=over 4
135
136
=item * L</credit_id>
137
138
=back
139
140
=cut
141
142
__PACKAGE__->set_primary_key("credit_id");
143
144
=head1 RELATIONS
145
146
=head2 account_offsets
147
148
Type: has_many
149
150
Related object: L<Koha::Schema::Result::AccountOffset>
151
152
=cut
153
154
__PACKAGE__->has_many(
155
  "account_offsets",
156
  "Koha::Schema::Result::AccountOffset",
157
  { "foreign.credit_id" => "self.credit_id" },
158
  { cascade_copy => 0, cascade_delete => 0 },
159
);
160
161
162
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-01-14 08:52:49
163
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nxB+s5t2sdcV71a+ElhYmg
164
165
__PACKAGE__->belongs_to(
166
  "borrower",
167
  "Koha::Schema::Result::Borrower",
168
  { borrowernumber => "borrowernumber" },
169
);
170
171
1;
(-)a/Koha/Schema/Result/AccountDebit.pm (+219 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::AccountDebit;
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::AccountDebit
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<account_debits>
19
20
=cut
21
22
__PACKAGE__->table("account_debits");
23
24
=head1 ACCESSORS
25
26
=head2 debit_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
  default_value: 0
36
  is_nullable: 0
37
38
=head2 itemnumber
39
40
  data_type: 'integer'
41
  is_nullable: 1
42
43
=head2 issue_id
44
45
  data_type: 'integer'
46
  is_nullable: 1
47
48
=head2 type
49
50
  data_type: 'varchar'
51
  is_nullable: 0
52
  size: 255
53
54
=head2 accruing
55
56
  data_type: 'tinyint'
57
  default_value: 0
58
  is_nullable: 0
59
60
=head2 amount_original
61
62
  data_type: 'decimal'
63
  is_nullable: 1
64
  size: [28,6]
65
66
=head2 amount_outstanding
67
68
  data_type: 'decimal'
69
  is_nullable: 1
70
  size: [28,6]
71
72
=head2 amount_last_increment
73
74
  data_type: 'decimal'
75
  is_nullable: 1
76
  size: [28,6]
77
78
=head2 description
79
80
  data_type: 'mediumtext'
81
  is_nullable: 1
82
83
=head2 notes
84
85
  data_type: 'text'
86
  is_nullable: 1
87
88
=head2 branchcode
89
90
  data_type: 'varchar'
91
  is_nullable: 1
92
  size: 10
93
94
=head2 manager_id
95
96
  data_type: 'integer'
97
  is_nullable: 1
98
99
=head2 created_on
100
101
  data_type: 'timestamp'
102
  datetime_undef_if_invalid: 1
103
  is_nullable: 1
104
105
=head2 updated_on
106
107
  data_type: 'timestamp'
108
  datetime_undef_if_invalid: 1
109
  is_nullable: 1
110
111
=cut
112
113
__PACKAGE__->add_columns(
114
  "debit_id",
115
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
116
  "borrowernumber",
117
  { data_type => "integer", default_value => 0, is_nullable => 0 },
118
  "itemnumber",
119
  { data_type => "integer", is_nullable => 1 },
120
  "issue_id",
121
  { data_type => "integer", is_nullable => 1 },
122
  "type",
123
  { data_type => "varchar", is_nullable => 0, size => 255 },
124
  "accruing",
125
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
126
  "amount_original",
127
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
128
  "amount_outstanding",
129
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
130
  "amount_last_increment",
131
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
132
  "description",
133
  { data_type => "mediumtext", is_nullable => 1 },
134
  "notes",
135
  { data_type => "text", is_nullable => 1 },
136
  "branchcode",
137
  { data_type => "varchar", is_nullable => 1, size => 10 },
138
  "manager_id",
139
  { data_type => "integer", is_nullable => 1 },
140
  "created_on",
141
  {
142
    data_type => "timestamp",
143
    datetime_undef_if_invalid => 1,
144
    is_nullable => 1,
145
  },
146
  "updated_on",
147
  {
148
    data_type => "timestamp",
149
    datetime_undef_if_invalid => 1,
150
    is_nullable => 1,
151
  },
152
);
153
154
=head1 PRIMARY KEY
155
156
=over 4
157
158
=item * L</debit_id>
159
160
=back
161
162
=cut
163
164
__PACKAGE__->set_primary_key("debit_id");
165
166
=head1 RELATIONS
167
168
=head2 account_offsets
169
170
Type: has_many
171
172
Related object: L<Koha::Schema::Result::AccountOffset>
173
174
=cut
175
176
__PACKAGE__->has_many(
177
  "account_offsets",
178
  "Koha::Schema::Result::AccountOffset",
179
  { "foreign.debit_id" => "self.debit_id" },
180
  { cascade_copy => 0, cascade_delete => 0 },
181
);
182
183
184
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-01-14 08:52:49
185
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M6yz+EMdQ1c79RewRIXX1g
186
187
__PACKAGE__->belongs_to(
188
  "item",
189
  "Koha::Schema::Result::Item",
190
  { itemnumber => "itemnumber" }
191
);
192
193
__PACKAGE__->belongs_to(
194
  "deleted_item",
195
  "Koha::Schema::Result::Deleteditem",
196
  { itemnumber => "itemnumber" }
197
);
198
199
__PACKAGE__->belongs_to(
200
  "issue",
201
  "Koha::Schema::Result::Issue",
202
  { issue_id => "issue_id" }
203
);
204
205
__PACKAGE__->belongs_to(
206
  "old_issue",
207
  "Koha::Schema::Result::OldIssue",
208
  { issue_id => "issue_id" }
209
);
210
211
__PACKAGE__->belongs_to(
212
  "borrower",
213
  "Koha::Schema::Result::Borrower",
214
  { borrowernumber => "borrowernumber" },
215
  { on_delete => "CASCADE", on_update => "CASCADE" },
216
);
217
218
# You can replace this text with custom content, and it will be preserved on regeneration
219
1;
(-)a/Koha/Schema/Result/AccountOffset.pm (+147 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::AccountOffset;
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::AccountOffset
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<account_offsets>
19
20
=cut
21
22
__PACKAGE__->table("account_offsets");
23
24
=head1 ACCESSORS
25
26
=head2 offset_id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 debit_id
33
34
  data_type: 'integer'
35
  is_foreign_key: 1
36
  is_nullable: 1
37
38
=head2 credit_id
39
40
  data_type: 'integer'
41
  is_foreign_key: 1
42
  is_nullable: 1
43
44
=head2 type
45
46
  data_type: 'varchar'
47
  is_nullable: 1
48
  size: 255
49
50
=head2 amount
51
52
  data_type: 'decimal'
53
  is_nullable: 0
54
  size: [28,6]
55
56
A positive number here represents a payment, a negative is a increase in a fine.
57
58
=head2 created_on
59
60
  data_type: 'timestamp'
61
  datetime_undef_if_invalid: 1
62
  default_value: current_timestamp
63
  is_nullable: 0
64
65
=cut
66
67
__PACKAGE__->add_columns(
68
  "offset_id",
69
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
70
  "debit_id",
71
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
72
  "credit_id",
73
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
74
  "type",
75
  { data_type => "varchar", is_nullable => 1, size => 255 },
76
  "amount",
77
  { data_type => "decimal", is_nullable => 0, size => [28, 6] },
78
  "created_on",
79
  {
80
    data_type => "timestamp",
81
    datetime_undef_if_invalid => 1,
82
    default_value => \"current_timestamp",
83
    is_nullable => 0,
84
  },
85
);
86
87
=head1 PRIMARY KEY
88
89
=over 4
90
91
=item * L</offset_id>
92
93
=back
94
95
=cut
96
97
__PACKAGE__->set_primary_key("offset_id");
98
99
=head1 RELATIONS
100
101
=head2 credit
102
103
Type: belongs_to
104
105
Related object: L<Koha::Schema::Result::AccountCredit>
106
107
=cut
108
109
__PACKAGE__->belongs_to(
110
  "credit",
111
  "Koha::Schema::Result::AccountCredit",
112
  { credit_id => "credit_id" },
113
  {
114
    is_deferrable => 1,
115
    join_type     => "LEFT",
116
    on_delete     => "CASCADE",
117
    on_update     => "CASCADE",
118
  },
119
);
120
121
=head2 debit
122
123
Type: belongs_to
124
125
Related object: L<Koha::Schema::Result::AccountDebit>
126
127
=cut
128
129
__PACKAGE__->belongs_to(
130
  "debit",
131
  "Koha::Schema::Result::AccountDebit",
132
  { debit_id => "debit_id" },
133
  {
134
    is_deferrable => 1,
135
    join_type     => "LEFT",
136
    on_delete     => "CASCADE",
137
    on_update     => "CASCADE",
138
  },
139
);
140
141
142
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-07-15 10:03:45
143
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CQJiVGoCnQEzkVu9ssgU/Q
144
145
146
# You can replace this text with custom content, and it will be preserved on regeneration
147
1;
(-)a/Koha/Schema/Result/Borrower.pm (-9 / +21 lines)
Lines 407-412 __PACKAGE__->table("borrowers"); Link Here
407
  default_value: 1
407
  default_value: 1
408
  is_nullable: 0
408
  is_nullable: 0
409
409
410
=head2 account_balance
411
412
  data_type: 'decimal'
413
  is_nullable: 0
414
  size: [28,6]
415
410
=cut
416
=cut
411
417
412
__PACKAGE__->add_columns(
418
__PACKAGE__->add_columns(
Lines 576-581 __PACKAGE__->add_columns( Link Here
576
  { data_type => "varchar", is_nullable => 1, size => 50 },
582
  { data_type => "varchar", is_nullable => 1, size => 50 },
577
  "privacy",
583
  "privacy",
578
  { data_type => "integer", default_value => 1, is_nullable => 0 },
584
  { data_type => "integer", default_value => 1, is_nullable => 0 },
585
  "account_balance",
586
  { data_type => "decimal", is_nullable => 0, size => [28, 6] },
579
);
587
);
580
588
581
=head1 PRIMARY KEY
589
=head1 PRIMARY KEY
Lines 618-649 __PACKAGE__->add_unique_constraint("userid", ["userid"]); Link Here
618
626
619
=head1 RELATIONS
627
=head1 RELATIONS
620
628
621
=head2 accountlines
629
=head2 account_credits
622
630
623
Type: has_many
631
Type: has_many
624
632
625
Related object: L<Koha::Schema::Result::Accountline>
633
Related object: L<Koha::Schema::Result::AccountCredit>
626
634
627
=cut
635
=cut
628
636
629
__PACKAGE__->has_many(
637
__PACKAGE__->has_many(
630
  "accountlines",
638
  "account_credits",
631
  "Koha::Schema::Result::Accountline",
639
  "Koha::Schema::Result::AccountCredit",
632
  { "foreign.borrowernumber" => "self.borrowernumber" },
640
  { "foreign.borrowernumber" => "self.borrowernumber" },
633
  { cascade_copy => 0, cascade_delete => 0 },
641
  { cascade_copy => 0, cascade_delete => 0 },
634
);
642
);
635
643
636
=head2 accountoffsets
644
=head2 account_debits
637
645
638
Type: has_many
646
Type: has_many
639
647
640
Related object: L<Koha::Schema::Result::Accountoffset>
648
Related object: L<Koha::Schema::Result::AccountDebit>
641
649
642
=cut
650
=cut
643
651
644
__PACKAGE__->has_many(
652
__PACKAGE__->has_many(
645
  "accountoffsets",
653
  "account_debits",
646
  "Koha::Schema::Result::Accountoffset",
654
  "Koha::Schema::Result::AccountDebit",
647
  { "foreign.borrowernumber" => "self.borrowernumber" },
655
  { "foreign.borrowernumber" => "self.borrowernumber" },
648
  { cascade_copy => 0, cascade_delete => 0 },
656
  { cascade_copy => 0, cascade_delete => 0 },
649
);
657
);
Lines 1157-1162 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); Link Here
1157
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-03-11 11:50:38
1165
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-03-11 11:50:38
1158
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4wVgO/FIFHQV+AxzXc+k8g
1166
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4wVgO/FIFHQV+AxzXc+k8g
1159
1167
1168
__PACKAGE__->belongs_to(
1169
    "branch",
1170
    "Koha::Schema::Result::Branch",
1171
    { branchcode => "branchcode" },
1172
);
1160
1173
1161
# You can replace this text with custom content, and it will be preserved on regeneration
1162
1;
1174
1;
(-)a/Koha/Schema/Result/Branch.pm (-1 / +31 lines)
Lines 187-192 __PACKAGE__->set_primary_key("branchcode"); Link Here
187
187
188
=head1 RELATIONS
188
=head1 RELATIONS
189
189
190
=head2 account_credits
191
192
Type: has_many
193
194
Related object: L<Koha::Schema::Result::AccountCredit>
195
196
=cut
197
198
__PACKAGE__->has_many(
199
  "account_credits",
200
  "Koha::Schema::Result::AccountCredit",
201
  { "foreign.branchcode" => "self.branchcode" },
202
  { cascade_copy => 0, cascade_delete => 0 },
203
);
204
205
=head2 account_debits
206
207
Type: has_many
208
209
Related object: L<Koha::Schema::Result::AccountDebit>
210
211
=cut
212
213
__PACKAGE__->has_many(
214
  "account_debits",
215
  "Koha::Schema::Result::AccountDebit",
216
  { "foreign.branchcode" => "self.branchcode" },
217
  { cascade_copy => 0, cascade_delete => 0 },
218
);
219
190
=head2 aqbaskets
220
=head2 aqbaskets
191
221
192
Type: has_many
222
Type: has_many
Lines 517-521 __PACKAGE__->many_to_many("categorycodes", "branchrelations", "categorycode"); Link Here
517
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CGNPB/MkGLOihDThj43/4A
547
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CGNPB/MkGLOihDThj43/4A
518
548
519
549
520
# You can replace this text with custom content, and it will be preserved on regeneration
550
# You can replace this text with custom code or comments, and it will be preserved on regeneration
521
1;
551
1;
(-)a/Koha/Schema/Result/Deleteditem.pm (+11 lines)
Lines 383-388 __PACKAGE__->set_primary_key("itemnumber"); Link Here
383
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-10-24 09:58:16
383
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-10-24 09:58:16
384
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ru5DyaIlWJcMNAgpZRjOLg
384
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ru5DyaIlWJcMNAgpZRjOLg
385
385
386
__PACKAGE__->belongs_to(
387
  "biblio",
388
  "Koha::Schema::Result::Biblio",
389
  { biblionumber => "biblionumber" }
390
);
391
392
__PACKAGE__->belongs_to(
393
  "deleted_biblio",
394
  "Koha::Schema::Result::Deletedbiblio",
395
  { biblionumber => "biblionumber" }
396
);
386
397
387
# You can replace this text with custom content, and it will be preserved on regeneration
398
# You can replace this text with custom content, and it will be preserved on regeneration
388
1;
399
1;
(-)a/Koha/Schema/Result/Issue.pm (-4 / +29 lines)
Lines 23-28 __PACKAGE__->table("issues"); Link Here
23
23
24
=head1 ACCESSORS
24
=head1 ACCESSORS
25
25
26
=head2 issue_id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
26
=head2 borrowernumber
32
=head2 borrowernumber
27
33
28
  data_type: 'integer'
34
  data_type: 'integer'
Lines 104-109 __PACKAGE__->table("issues"); Link Here
104
=cut
110
=cut
105
111
106
__PACKAGE__->add_columns(
112
__PACKAGE__->add_columns(
113
  "issue_id",
114
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
107
  "borrowernumber",
115
  "borrowernumber",
108
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
116
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
109
  "itemnumber",
117
  "itemnumber",
Lines 153-158 __PACKAGE__->add_columns( Link Here
153
  { data_type => "integer", default_value => 0, is_nullable => 0 },
161
  { data_type => "integer", default_value => 0, is_nullable => 0 },
154
);
162
);
155
163
164
=head1 PRIMARY KEY
165
166
=over 4
167
168
=item * L</issue_id>
169
170
=back
171
172
=cut
173
174
__PACKAGE__->set_primary_key("issue_id");
175
156
=head1 RELATIONS
176
=head1 RELATIONS
157
177
158
=head2 borrowernumber
178
=head2 borrowernumber
Lines 200-209 __PACKAGE__->belongs_to( Link Here
200
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7Y+5IerDnajn5GLwAY5thg
220
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7Y+5IerDnajn5GLwAY5thg
201
221
202
__PACKAGE__->belongs_to(
222
__PACKAGE__->belongs_to(
203
    "borrower",
223
  "borrower",
204
    "Koha::Schema::Result::Borrower",
224
  "Koha::Schema::Result::Borrower",
205
    { borrowernumber => "borrowernumber" },
225
  { borrowernumber => "borrowernumber" },
206
    { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
226
  {
227
    is_deferrable => 1,
228
    join_type     => "LEFT",
229
    on_delete     => "RESTRICT",
230
    on_update     => "CASCADE",
231
  },
207
);
232
);
208
233
209
__PACKAGE__->belongs_to(
234
__PACKAGE__->belongs_to(
(-)a/Koha/Schema/Result/Item.pm (-15 lines)
Lines 403-423 __PACKAGE__->add_unique_constraint("itembarcodeidx", ["barcode"]); Link Here
403
403
404
=head1 RELATIONS
404
=head1 RELATIONS
405
405
406
=head2 accountlines
407
408
Type: has_many
409
410
Related object: L<Koha::Schema::Result::Accountline>
411
412
=cut
413
414
__PACKAGE__->has_many(
415
  "accountlines",
416
  "Koha::Schema::Result::Accountline",
417
  { "foreign.itemnumber" => "self.itemnumber" },
418
  { cascade_copy => 0, cascade_delete => 0 },
419
);
420
421
=head2 biblioitemnumber
406
=head2 biblioitemnumber
422
407
423
Type: belongs_to
408
Type: belongs_to
(-)a/Koha/Schema/Result/OldIssue.pm (-2 / +47 lines)
Lines 23-28 __PACKAGE__->table("old_issues"); Link Here
23
23
24
=head1 ACCESSORS
24
=head1 ACCESSORS
25
25
26
=head2 issue_id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
26
=head2 borrowernumber
32
=head2 borrowernumber
27
33
28
  data_type: 'integer'
34
  data_type: 'integer'
Lines 104-109 __PACKAGE__->table("old_issues"); Link Here
104
=cut
110
=cut
105
111
106
__PACKAGE__->add_columns(
112
__PACKAGE__->add_columns(
113
  "issue_id",
114
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
107
  "borrowernumber",
115
  "borrowernumber",
108
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
116
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
109
  "itemnumber",
117
  "itemnumber",
Lines 153-158 __PACKAGE__->add_columns( Link Here
153
  { data_type => "integer", default_value => 0, is_nullable => 0 },
161
  { data_type => "integer", default_value => 0, is_nullable => 0 },
154
);
162
);
155
163
164
=head1 PRIMARY KEY
165
166
=over 4
167
168
=item * L</issue_id>
169
170
=back
171
172
=cut
173
174
__PACKAGE__->set_primary_key("issue_id");
175
156
=head1 RELATIONS
176
=head1 RELATIONS
157
177
158
=head2 borrowernumber
178
=head2 borrowernumber
Lines 199-204 __PACKAGE__->belongs_to( Link Here
199
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-11-03 10:40:55
219
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-11-03 10:40:55
200
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lNB9CDFcwG4DjD0pl14mvQ
220
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lNB9CDFcwG4DjD0pl14mvQ
201
221
222
__PACKAGE__->belongs_to(
223
  "borrower",
224
  "Koha::Schema::Result::Borrower",
225
  { borrowernumber => "borrowernumber" },
226
  { join_type => "LEFT" },
227
);
228
229
__PACKAGE__->belongs_to(
230
  "item",
231
  "Koha::Schema::Result::Item",
232
  { itemnumber => "itemnumber" },
233
  { join_type => "LEFT" },
234
);
235
236
__PACKAGE__->belongs_to(
237
  "deletedborrower",
238
  "Koha::Schema::Result::Deletedborrower",
239
  { borrowernumber => "borrowernumber" },
240
  { join_type => "LEFT" },
241
);
242
243
__PACKAGE__->belongs_to(
244
  "deleteditem",
245
  "Koha::Schema::Result::Deleteditem",
246
  { itemnumber => "itemnumber" },
247
  { join_type => "LEFT" },
248
);
202
249
203
# You can replace this text with custom content, and it will be preserved on regeneration
204
1;
250
1;
205
- 

Return to bug 6427