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

(-)a/Koha/Schema/Result/Aqbasket.pm (-2 / +18 lines)
Lines 81-86 __PACKAGE__->table("aqbasket"); Link Here
81
  is_foreign_key: 1
81
  is_foreign_key: 1
82
  is_nullable: 1
82
  is_nullable: 1
83
83
84
=head2 deliveryplace
85
86
  data_type: 'varchar'
87
  is_nullable: 1
88
  size: 10
89
90
=head2 billingplace
91
92
  data_type: 'varchar'
93
  is_nullable: 1
94
  size: 10
95
84
=cut
96
=cut
85
97
86
__PACKAGE__->add_columns(
98
__PACKAGE__->add_columns(
Lines 111-116 __PACKAGE__->add_columns( Link Here
111
  { data_type => "mediumtext", is_nullable => 1 },
123
  { data_type => "mediumtext", is_nullable => 1 },
112
  "basketgroupid",
124
  "basketgroupid",
113
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
125
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
126
  "deliveryplace",
127
  { data_type => "varchar", is_nullable => 1, size => 10 },
128
  "billingplace",
129
  { data_type => "varchar", is_nullable => 1, size => 10 },
114
);
130
);
115
__PACKAGE__->set_primary_key("basketno");
131
__PACKAGE__->set_primary_key("basketno");
116
132
Lines 177-184 __PACKAGE__->has_many( Link Here
177
);
193
);
178
194
179
195
180
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
196
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
181
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eRG3p93qKZhp3rNPwG60Ig
197
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dtVubmNVtOouPnHgut95og
182
198
183
199
184
# You can replace this text with custom content, and it will be preserved on regeneration
200
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Aqbasketgroup.pm (-10 / +10 lines)
Lines 42-53 __PACKAGE__->table("aqbasketgroups"); Link Here
42
  is_foreign_key: 1
42
  is_foreign_key: 1
43
  is_nullable: 0
43
  is_nullable: 0
44
44
45
=head2 billingplace
46
47
  data_type: 'varchar'
48
  is_nullable: 1
49
  size: 10
50
51
=head2 deliveryplace
45
=head2 deliveryplace
52
46
53
  data_type: 'varchar'
47
  data_type: 'varchar'
Lines 65-70 __PACKAGE__->table("aqbasketgroups"); Link Here
65
  is_nullable: 1
59
  is_nullable: 1
66
  size: 255
60
  size: 255
67
61
62
=head2 billingplace
63
64
  data_type: 'varchar'
65
  is_nullable: 1
66
  size: 10
67
68
=cut
68
=cut
69
69
70
__PACKAGE__->add_columns(
70
__PACKAGE__->add_columns(
Lines 76-89 __PACKAGE__->add_columns( Link Here
76
  { data_type => "tinyint", is_nullable => 1 },
76
  { data_type => "tinyint", is_nullable => 1 },
77
  "booksellerid",
77
  "booksellerid",
78
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
78
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
79
  "billingplace",
80
  { data_type => "varchar", is_nullable => 1, size => 10 },
81
  "deliveryplace",
79
  "deliveryplace",
82
  { data_type => "varchar", is_nullable => 1, size => 10 },
80
  { data_type => "varchar", is_nullable => 1, size => 10 },
83
  "freedeliveryplace",
81
  "freedeliveryplace",
84
  { data_type => "text", is_nullable => 1 },
82
  { data_type => "text", is_nullable => 1 },
85
  "deliverycomment",
83
  "deliverycomment",
86
  { data_type => "varchar", is_nullable => 1, size => 255 },
84
  { data_type => "varchar", is_nullable => 1, size => 255 },
85
  "billingplace",
86
  { data_type => "varchar", is_nullable => 1, size => 10 },
87
);
87
);
88
__PACKAGE__->set_primary_key("id");
88
__PACKAGE__->set_primary_key("id");
89
89
Lines 120-127 __PACKAGE__->belongs_to( Link Here
120
);
120
);
121
121
122
122
123
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
123
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
124
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sxuJyGpPeqNxjNAnAAe69A
124
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fm4sF0IGJYdSejZIB4uoBQ
125
125
126
126
127
# You can replace this text with custom content, and it will be preserved on regeneration
127
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Aqorder.pm (-21 / +52 lines)
Lines 114-130 __PACKAGE__->table("aqorders"); Link Here
114
  data_type: 'mediumtext'
114
  data_type: 'mediumtext'
115
  is_nullable: 1
115
  is_nullable: 1
116
116
117
=head2 subscription
118
119
  data_type: 'tinyint'
120
  is_nullable: 1
121
122
=head2 serialid
123
124
  data_type: 'varchar'
125
  is_nullable: 1
126
  size: 30
127
128
=head2 basketno
117
=head2 basketno
129
118
130
  data_type: 'integer'
119
  data_type: 'integer'
Lines 154-164 __PACKAGE__->table("aqorders"); Link Here
154
  is_nullable: 1
143
  is_nullable: 1
155
  size: [13,2]
144
  size: [13,2]
156
145
157
=head2 gst
146
=head2 gstrate
158
147
159
  data_type: 'decimal'
148
  data_type: 'decimal'
160
  is_nullable: 1
149
  is_nullable: 1
161
  size: [13,2]
150
  size: [6,4]
151
152
=head2 discount
153
154
  data_type: 'float'
155
  is_nullable: 1
156
  size: [6,4]
162
157
163
=head2 budget_id
158
=head2 budget_id
164
159
Lines 215-220 __PACKAGE__->table("aqorders"); Link Here
215
  data_type: 'date'
210
  data_type: 'date'
216
  is_nullable: 1
211
  is_nullable: 1
217
212
213
=head2 subscriptionid
214
215
  data_type: 'integer'
216
  is_foreign_key: 1
217
  is_nullable: 1
218
218
=head2 parent_ordernumber
219
=head2 parent_ordernumber
219
220
220
  data_type: 'integer'
221
  data_type: 'integer'
Lines 257-266 __PACKAGE__->add_columns( Link Here
257
  { data_type => "mediumtext", is_nullable => 1 },
258
  { data_type => "mediumtext", is_nullable => 1 },
258
  "purchaseordernumber",
259
  "purchaseordernumber",
259
  { data_type => "mediumtext", is_nullable => 1 },
260
  { data_type => "mediumtext", is_nullable => 1 },
260
  "subscription",
261
  { data_type => "tinyint", is_nullable => 1 },
262
  "serialid",
263
  { data_type => "varchar", is_nullable => 1, size => 30 },
264
  "basketno",
261
  "basketno",
265
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
262
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
266
  "biblioitemnumber",
263
  "biblioitemnumber",
Lines 275-282 __PACKAGE__->add_columns( Link Here
275
  { data_type => "decimal", is_nullable => 1, size => [13, 2] },
272
  { data_type => "decimal", is_nullable => 1, size => [13, 2] },
276
  "ecost",
273
  "ecost",
277
  { data_type => "decimal", is_nullable => 1, size => [13, 2] },
274
  { data_type => "decimal", is_nullable => 1, size => [13, 2] },
278
  "gst",
275
  "gstrate",
279
  { data_type => "decimal", is_nullable => 1, size => [13, 2] },
276
  { data_type => "decimal", is_nullable => 1, size => [6, 4] },
277
  "discount",
278
  { data_type => "float", is_nullable => 1, size => [6, 4] },
280
  "budget_id",
279
  "budget_id",
281
  { data_type => "integer", is_nullable => 0 },
280
  { data_type => "integer", is_nullable => 0 },
282
  "budgetgroup_id",
281
  "budgetgroup_id",
Lines 297-302 __PACKAGE__->add_columns( Link Here
297
  { data_type => "integer", default_value => 0, is_nullable => 1 },
296
  { data_type => "integer", default_value => 0, is_nullable => 1 },
298
  "claimed_date",
297
  "claimed_date",
299
  { data_type => "date", is_nullable => 1 },
298
  { data_type => "date", is_nullable => 1 },
299
  "subscriptionid",
300
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
300
  "parent_ordernumber",
301
  "parent_ordernumber",
301
  { data_type => "integer", is_nullable => 1 },
302
  { data_type => "integer", is_nullable => 1 },
302
);
303
);
Lines 349-357 __PACKAGE__->belongs_to( Link Here
349
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
350
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
350
);
351
);
351
352
353
=head2 subscriptionid
354
355
Type: belongs_to
356
357
Related object: L<Koha::Schema::Result::Subscription>
358
359
=cut
360
361
__PACKAGE__->belongs_to(
362
  "subscriptionid",
363
  "Koha::Schema::Result::Subscription",
364
  { subscriptionid => "subscriptionid" },
365
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
366
);
367
368
=head2 aqorders_items
369
370
Type: has_many
371
372
Related object: L<Koha::Schema::Result::AqordersItem>
373
374
=cut
375
376
__PACKAGE__->has_many(
377
  "aqorders_items",
378
  "Koha::Schema::Result::AqordersItem",
379
  { "foreign.ordernumber" => "self.ordernumber" },
380
  { cascade_copy => 0, cascade_delete => 0 },
381
);
382
352
383
353
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
384
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
354
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:McWqeFHBMTDvKV7pUEqJ3w
385
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:H1fME9Sli2LWh6zAmpzK8A
355
386
356
387
357
# You can replace this text with custom content, and it will be preserved on regeneration
388
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/AqordersItem.pm (-3 / +21 lines)
Lines 22-27 __PACKAGE__->table("aqorders_items"); Link Here
22
=head2 ordernumber
22
=head2 ordernumber
23
23
24
  data_type: 'integer'
24
  data_type: 'integer'
25
  is_foreign_key: 1
25
  is_nullable: 0
26
  is_nullable: 0
26
27
27
=head2 itemnumber
28
=head2 itemnumber
Lines 39-45 __PACKAGE__->table("aqorders_items"); Link Here
39
40
40
__PACKAGE__->add_columns(
41
__PACKAGE__->add_columns(
41
  "ordernumber",
42
  "ordernumber",
42
  { data_type => "integer", is_nullable => 0 },
43
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
43
  "itemnumber",
44
  "itemnumber",
44
  { data_type => "integer", is_nullable => 0 },
45
  { data_type => "integer", is_nullable => 0 },
45
  "timestamp",
46
  "timestamp",
Lines 51-59 __PACKAGE__->add_columns( Link Here
51
);
52
);
52
__PACKAGE__->set_primary_key("itemnumber");
53
__PACKAGE__->set_primary_key("itemnumber");
53
54
55
=head1 RELATIONS
56
57
=head2 ordernumber
58
59
Type: belongs_to
60
61
Related object: L<Koha::Schema::Result::Aqorder>
62
63
=cut
64
65
__PACKAGE__->belongs_to(
66
  "ordernumber",
67
  "Koha::Schema::Result::Aqorder",
68
  { ordernumber => "ordernumber" },
69
  { on_delete => "CASCADE", on_update => "CASCADE" },
70
);
71
54
72
55
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
73
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
56
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OlihytSmp6fCmG/hAT7FEg
74
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9KFzTfBzan4H1BxT1suyXA
57
75
58
76
59
# 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/AuthorisedValue.pm (-2 / +19 lines)
Lines 75-83 __PACKAGE__->add_columns( Link Here
75
);
75
);
76
__PACKAGE__->set_primary_key("id");
76
__PACKAGE__->set_primary_key("id");
77
77
78
=head1 RELATIONS
78
79
79
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
80
=head2 authorised_values_branches
80
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GpXi5gcFBtEj82hEFzhmVg
81
82
Type: has_many
83
84
Related object: L<Koha::Schema::Result::AuthorisedValuesBranch>
85
86
=cut
87
88
__PACKAGE__->has_many(
89
  "authorised_values_branches",
90
  "Koha::Schema::Result::AuthorisedValuesBranch",
91
  { "foreign.av_id" => "self.id" },
92
  { cascade_copy => 0, cascade_delete => 0 },
93
);
94
95
96
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
97
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UQnP1vJKTnc7KwuTT20Orw
81
98
82
99
83
# You can replace this text with custom content, and it will be preserved on regeneration
100
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/AuthorisedValuesBranch.pm (+82 lines)
Line 0 Link Here
1
package Koha::Schema::Result::AuthorisedValuesBranch;
2
3
# Created by DBIx::Class::Schema::Loader
4
# DO NOT MODIFY THE FIRST PART OF THIS FILE
5
6
use strict;
7
use warnings;
8
9
use base 'DBIx::Class::Core';
10
11
12
=head1 NAME
13
14
Koha::Schema::Result::AuthorisedValuesBranch
15
16
=cut
17
18
__PACKAGE__->table("authorised_values_branches");
19
20
=head1 ACCESSORS
21
22
=head2 av_id
23
24
  data_type: 'integer'
25
  is_foreign_key: 1
26
  is_nullable: 1
27
28
=head2 branchcode
29
30
  data_type: 'varchar'
31
  is_foreign_key: 1
32
  is_nullable: 1
33
  size: 10
34
35
=cut
36
37
__PACKAGE__->add_columns(
38
  "av_id",
39
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
40
  "branchcode",
41
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
42
);
43
44
=head1 RELATIONS
45
46
=head2 av
47
48
Type: belongs_to
49
50
Related object: L<Koha::Schema::Result::AuthorisedValue>
51
52
=cut
53
54
__PACKAGE__->belongs_to(
55
  "av",
56
  "Koha::Schema::Result::AuthorisedValue",
57
  { id => "av_id" },
58
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
59
);
60
61
=head2 branchcode
62
63
Type: belongs_to
64
65
Related object: L<Koha::Schema::Result::Branch>
66
67
=cut
68
69
__PACKAGE__->belongs_to(
70
  "branchcode",
71
  "Koha::Schema::Result::Branch",
72
  { branchcode => "branchcode" },
73
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
74
);
75
76
77
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
78
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yPaKXjOzZX76bddoMqxKmA
79
80
81
# You can replace this text with custom content, and it will be preserved on regeneration
82
1;
(-)a/Koha/Schema/Result/Borrower.pm (-8 / +23 lines)
Lines 85-91 __PACKAGE__->table("borrowers"); Link Here
85
85
86
=head2 state
86
=head2 state
87
87
88
  data_type: 'mediumtext'
88
  data_type: 'text'
89
  is_nullable: 1
89
  is_nullable: 1
90
90
91
=head2 zipcode
91
=head2 zipcode
Lines 160-166 __PACKAGE__->table("borrowers"); Link Here
160
160
161
=head2 b_state
161
=head2 b_state
162
162
163
  data_type: 'mediumtext'
163
  data_type: 'text'
164
  is_nullable: 1
164
  is_nullable: 1
165
165
166
=head2 b_zipcode
166
=head2 b_zipcode
Lines 357-363 __PACKAGE__->table("borrowers"); Link Here
357
357
358
=head2 altcontactstate
358
=head2 altcontactstate
359
359
360
  data_type: 'mediumtext'
360
  data_type: 'text'
361
  is_nullable: 1
361
  is_nullable: 1
362
362
363
=head2 altcontactzipcode
363
=head2 altcontactzipcode
Lines 417-423 __PACKAGE__->add_columns( Link Here
417
  "city",
417
  "city",
418
  { data_type => "mediumtext", is_nullable => 0 },
418
  { data_type => "mediumtext", is_nullable => 0 },
419
  "state",
419
  "state",
420
  { data_type => "mediumtext", is_nullable => 1 },
420
  { data_type => "text", is_nullable => 1 },
421
  "zipcode",
421
  "zipcode",
422
  { data_type => "varchar", is_nullable => 1, size => 25 },
422
  { data_type => "varchar", is_nullable => 1, size => 25 },
423
  "country",
423
  "country",
Lines 445-451 __PACKAGE__->add_columns( Link Here
445
  "b_city",
445
  "b_city",
446
  { data_type => "mediumtext", is_nullable => 1 },
446
  { data_type => "mediumtext", is_nullable => 1 },
447
  "b_state",
447
  "b_state",
448
  { data_type => "mediumtext", is_nullable => 1 },
448
  { data_type => "text", is_nullable => 1 },
449
  "b_zipcode",
449
  "b_zipcode",
450
  { data_type => "varchar", is_nullable => 1, size => 25 },
450
  { data_type => "varchar", is_nullable => 1, size => 25 },
451
  "b_country",
451
  "b_country",
Lines 527-533 __PACKAGE__->add_columns( Link Here
527
  "altcontactaddress3",
527
  "altcontactaddress3",
528
  { data_type => "varchar", is_nullable => 1, size => 255 },
528
  { data_type => "varchar", is_nullable => 1, size => 255 },
529
  "altcontactstate",
529
  "altcontactstate",
530
  { data_type => "mediumtext", is_nullable => 1 },
530
  { data_type => "text", is_nullable => 1 },
531
  "altcontactzipcode",
531
  "altcontactzipcode",
532
  { data_type => "varchar", is_nullable => 1, size => 50 },
532
  { data_type => "varchar", is_nullable => 1, size => 50 },
533
  "altcontactcountry",
533
  "altcontactcountry",
Lines 664-669 __PACKAGE__->belongs_to( Link Here
664
  { on_delete => "CASCADE", on_update => "CASCADE" },
664
  { on_delete => "CASCADE", on_update => "CASCADE" },
665
);
665
);
666
666
667
=head2 course_instructors
668
669
Type: has_many
670
671
Related object: L<Koha::Schema::Result::CourseInstructor>
672
673
=cut
674
675
__PACKAGE__->has_many(
676
  "course_instructors",
677
  "Koha::Schema::Result::CourseInstructor",
678
  { "foreign.borrowernumber" => "self.borrowernumber" },
679
  { cascade_copy => 0, cascade_delete => 0 },
680
);
681
667
=head2 creator_batches
682
=head2 creator_batches
668
683
669
Type: has_many
684
Type: has_many
Lines 935-942 __PACKAGE__->has_many( Link Here
935
);
950
);
936
951
937
952
938
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
953
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
939
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:a5PYhuHX3DHlNJqdmIuqTw
954
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RZG8l5yFKXZzsAY8CenNeA
940
955
941
956
942
# You can replace this text with custom content, and it will be preserved on regeneration
957
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/BorrowerAttributeType.pm (-12 / +11 lines)
Lines 76-82 __PACKAGE__->table("borrower_attribute_types"); Link Here
76
=head2 category_code
76
=head2 category_code
77
77
78
  data_type: 'varchar'
78
  data_type: 'varchar'
79
  is_foreign_key: 1
80
  is_nullable: 1
79
  is_nullable: 1
81
  size: 10
80
  size: 10
82
81
Lines 109-115 __PACKAGE__->add_columns( Link Here
109
  "display_checkout",
108
  "display_checkout",
110
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
109
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
111
  "category_code",
110
  "category_code",
112
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
111
  { data_type => "varchar", is_nullable => 1, size => 10 },
113
  "class",
112
  "class",
114
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
113
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
115
);
114
);
Lines 117-135 __PACKAGE__->set_primary_key("code"); Link Here
117
116
118
=head1 RELATIONS
117
=head1 RELATIONS
119
118
120
=head2 category_code
119
=head2 borrower_attribute_types_branches
121
120
122
Type: belongs_to
121
Type: has_many
123
122
124
Related object: L<Koha::Schema::Result::Category>
123
Related object: L<Koha::Schema::Result::BorrowerAttributeTypesBranch>
125
124
126
=cut
125
=cut
127
126
128
__PACKAGE__->belongs_to(
127
__PACKAGE__->has_many(
129
  "category_code",
128
  "borrower_attribute_types_branches",
130
  "Koha::Schema::Result::Category",
129
  "Koha::Schema::Result::BorrowerAttributeTypesBranch",
131
  { categorycode => "category_code" },
130
  { "foreign.bat_code" => "self.code" },
132
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
131
  { cascade_copy => 0, cascade_delete => 0 },
133
);
132
);
134
133
135
=head2 borrower_attributes
134
=head2 borrower_attributes
Lines 148-155 __PACKAGE__->has_many( Link Here
148
);
147
);
149
148
150
149
151
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
150
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
152
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EpdavGdH3uR/eaNLJIoHCg
151
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vwni0x6JLQPsjX8UOSnr4Q
153
152
154
153
155
# You can replace this text with custom content, and it will be preserved on regeneration
154
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/BorrowerAttributeTypesBranch.pm (+83 lines)
Line 0 Link Here
1
package Koha::Schema::Result::BorrowerAttributeTypesBranch;
2
3
# Created by DBIx::Class::Schema::Loader
4
# DO NOT MODIFY THE FIRST PART OF THIS FILE
5
6
use strict;
7
use warnings;
8
9
use base 'DBIx::Class::Core';
10
11
12
=head1 NAME
13
14
Koha::Schema::Result::BorrowerAttributeTypesBranch
15
16
=cut
17
18
__PACKAGE__->table("borrower_attribute_types_branches");
19
20
=head1 ACCESSORS
21
22
=head2 bat_code
23
24
  data_type: 'varchar'
25
  is_foreign_key: 1
26
  is_nullable: 1
27
  size: 10
28
29
=head2 b_branchcode
30
31
  data_type: 'varchar'
32
  is_foreign_key: 1
33
  is_nullable: 1
34
  size: 10
35
36
=cut
37
38
__PACKAGE__->add_columns(
39
  "bat_code",
40
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
41
  "b_branchcode",
42
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
43
);
44
45
=head1 RELATIONS
46
47
=head2 bat_code
48
49
Type: belongs_to
50
51
Related object: L<Koha::Schema::Result::BorrowerAttributeType>
52
53
=cut
54
55
__PACKAGE__->belongs_to(
56
  "bat_code",
57
  "Koha::Schema::Result::BorrowerAttributeType",
58
  { code => "bat_code" },
59
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
60
);
61
62
=head2 b_branchcode
63
64
Type: belongs_to
65
66
Related object: L<Koha::Schema::Result::Branch>
67
68
=cut
69
70
__PACKAGE__->belongs_to(
71
  "b_branchcode",
72
  "Koha::Schema::Result::Branch",
73
  { branchcode => "b_branchcode" },
74
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
75
);
76
77
78
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
79
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:z/zsaV00AbPzi/YfCh+cwA
80
81
82
# You can replace this text with custom content, and it will be preserved on regeneration
83
1;
(-)a/Koha/Schema/Result/BorrowerModification.pm (+554 lines)
Line 0 Link Here
1
package Koha::Schema::Result::BorrowerModification;
2
3
# Created by DBIx::Class::Schema::Loader
4
# DO NOT MODIFY THE FIRST PART OF THIS FILE
5
6
use strict;
7
use warnings;
8
9
use base 'DBIx::Class::Core';
10
11
12
=head1 NAME
13
14
Koha::Schema::Result::BorrowerModification
15
16
=cut
17
18
__PACKAGE__->table("borrower_modifications");
19
20
=head1 ACCESSORS
21
22
=head2 timestamp
23
24
  data_type: 'timestamp'
25
  default_value: current_timestamp
26
  is_nullable: 0
27
28
=head2 verification_token
29
30
  data_type: 'varchar'
31
  default_value: (empty string)
32
  is_nullable: 0
33
  size: 255
34
35
=head2 borrowernumber
36
37
  data_type: 'integer'
38
  default_value: 0
39
  is_nullable: 0
40
41
=head2 cardnumber
42
43
  data_type: 'varchar'
44
  is_nullable: 1
45
  size: 16
46
47
=head2 surname
48
49
  data_type: 'mediumtext'
50
  is_nullable: 1
51
52
=head2 firstname
53
54
  data_type: 'text'
55
  is_nullable: 1
56
57
=head2 title
58
59
  data_type: 'mediumtext'
60
  is_nullable: 1
61
62
=head2 othernames
63
64
  data_type: 'mediumtext'
65
  is_nullable: 1
66
67
=head2 initials
68
69
  data_type: 'text'
70
  is_nullable: 1
71
72
=head2 streetnumber
73
74
  data_type: 'varchar'
75
  is_nullable: 1
76
  size: 10
77
78
=head2 streettype
79
80
  data_type: 'varchar'
81
  is_nullable: 1
82
  size: 50
83
84
=head2 address
85
86
  data_type: 'mediumtext'
87
  is_nullable: 1
88
89
=head2 address2
90
91
  data_type: 'text'
92
  is_nullable: 1
93
94
=head2 city
95
96
  data_type: 'mediumtext'
97
  is_nullable: 1
98
99
=head2 state
100
101
  data_type: 'text'
102
  is_nullable: 1
103
104
=head2 zipcode
105
106
  data_type: 'varchar'
107
  is_nullable: 1
108
  size: 25
109
110
=head2 country
111
112
  data_type: 'text'
113
  is_nullable: 1
114
115
=head2 email
116
117
  data_type: 'mediumtext'
118
  is_nullable: 1
119
120
=head2 phone
121
122
  data_type: 'text'
123
  is_nullable: 1
124
125
=head2 mobile
126
127
  data_type: 'varchar'
128
  is_nullable: 1
129
  size: 50
130
131
=head2 fax
132
133
  data_type: 'mediumtext'
134
  is_nullable: 1
135
136
=head2 emailpro
137
138
  data_type: 'text'
139
  is_nullable: 1
140
141
=head2 phonepro
142
143
  data_type: 'text'
144
  is_nullable: 1
145
146
=head2 b_streetnumber
147
148
  data_type: 'varchar'
149
  is_nullable: 1
150
  size: 10
151
152
=head2 b_streettype
153
154
  data_type: 'varchar'
155
  is_nullable: 1
156
  size: 50
157
158
=head2 b_address
159
160
  data_type: 'varchar'
161
  is_nullable: 1
162
  size: 100
163
164
=head2 b_address2
165
166
  data_type: 'text'
167
  is_nullable: 1
168
169
=head2 b_city
170
171
  data_type: 'mediumtext'
172
  is_nullable: 1
173
174
=head2 b_state
175
176
  data_type: 'text'
177
  is_nullable: 1
178
179
=head2 b_zipcode
180
181
  data_type: 'varchar'
182
  is_nullable: 1
183
  size: 25
184
185
=head2 b_country
186
187
  data_type: 'text'
188
  is_nullable: 1
189
190
=head2 b_email
191
192
  data_type: 'text'
193
  is_nullable: 1
194
195
=head2 b_phone
196
197
  data_type: 'mediumtext'
198
  is_nullable: 1
199
200
=head2 dateofbirth
201
202
  data_type: 'date'
203
  is_nullable: 1
204
205
=head2 branchcode
206
207
  data_type: 'varchar'
208
  is_nullable: 1
209
  size: 10
210
211
=head2 categorycode
212
213
  data_type: 'varchar'
214
  is_nullable: 1
215
  size: 10
216
217
=head2 dateenrolled
218
219
  data_type: 'date'
220
  is_nullable: 1
221
222
=head2 dateexpiry
223
224
  data_type: 'date'
225
  is_nullable: 1
226
227
=head2 gonenoaddress
228
229
  data_type: 'tinyint'
230
  is_nullable: 1
231
232
=head2 lost
233
234
  data_type: 'tinyint'
235
  is_nullable: 1
236
237
=head2 debarred
238
239
  data_type: 'date'
240
  is_nullable: 1
241
242
=head2 debarredcomment
243
244
  data_type: 'varchar'
245
  is_nullable: 1
246
  size: 255
247
248
=head2 contactname
249
250
  data_type: 'mediumtext'
251
  is_nullable: 1
252
253
=head2 contactfirstname
254
255
  data_type: 'text'
256
  is_nullable: 1
257
258
=head2 contacttitle
259
260
  data_type: 'text'
261
  is_nullable: 1
262
263
=head2 guarantorid
264
265
  data_type: 'integer'
266
  is_nullable: 1
267
268
=head2 borrowernotes
269
270
  data_type: 'mediumtext'
271
  is_nullable: 1
272
273
=head2 relationship
274
275
  data_type: 'varchar'
276
  is_nullable: 1
277
  size: 100
278
279
=head2 ethnicity
280
281
  data_type: 'varchar'
282
  is_nullable: 1
283
  size: 50
284
285
=head2 ethnotes
286
287
  data_type: 'varchar'
288
  is_nullable: 1
289
  size: 255
290
291
=head2 sex
292
293
  data_type: 'varchar'
294
  is_nullable: 1
295
  size: 1
296
297
=head2 password
298
299
  data_type: 'varchar'
300
  is_nullable: 1
301
  size: 30
302
303
=head2 flags
304
305
  data_type: 'integer'
306
  is_nullable: 1
307
308
=head2 userid
309
310
  data_type: 'varchar'
311
  is_nullable: 1
312
  size: 75
313
314
=head2 opacnote
315
316
  data_type: 'mediumtext'
317
  is_nullable: 1
318
319
=head2 contactnote
320
321
  data_type: 'varchar'
322
  is_nullable: 1
323
  size: 255
324
325
=head2 sort1
326
327
  data_type: 'varchar'
328
  is_nullable: 1
329
  size: 80
330
331
=head2 sort2
332
333
  data_type: 'varchar'
334
  is_nullable: 1
335
  size: 80
336
337
=head2 altcontactfirstname
338
339
  data_type: 'varchar'
340
  is_nullable: 1
341
  size: 255
342
343
=head2 altcontactsurname
344
345
  data_type: 'varchar'
346
  is_nullable: 1
347
  size: 255
348
349
=head2 altcontactaddress1
350
351
  data_type: 'varchar'
352
  is_nullable: 1
353
  size: 255
354
355
=head2 altcontactaddress2
356
357
  data_type: 'varchar'
358
  is_nullable: 1
359
  size: 255
360
361
=head2 altcontactaddress3
362
363
  data_type: 'varchar'
364
  is_nullable: 1
365
  size: 255
366
367
=head2 altcontactstate
368
369
  data_type: 'text'
370
  is_nullable: 1
371
372
=head2 altcontactzipcode
373
374
  data_type: 'varchar'
375
  is_nullable: 1
376
  size: 50
377
378
=head2 altcontactcountry
379
380
  data_type: 'text'
381
  is_nullable: 1
382
383
=head2 altcontactphone
384
385
  data_type: 'varchar'
386
  is_nullable: 1
387
  size: 50
388
389
=head2 smsalertnumber
390
391
  data_type: 'varchar'
392
  is_nullable: 1
393
  size: 50
394
395
=head2 privacy
396
397
  data_type: 'integer'
398
  is_nullable: 1
399
400
=cut
401
402
__PACKAGE__->add_columns(
403
  "timestamp",
404
  {
405
    data_type     => "timestamp",
406
    default_value => \"current_timestamp",
407
    is_nullable   => 0,
408
  },
409
  "verification_token",
410
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
411
  "borrowernumber",
412
  { data_type => "integer", default_value => 0, is_nullable => 0 },
413
  "cardnumber",
414
  { data_type => "varchar", is_nullable => 1, size => 16 },
415
  "surname",
416
  { data_type => "mediumtext", is_nullable => 1 },
417
  "firstname",
418
  { data_type => "text", is_nullable => 1 },
419
  "title",
420
  { data_type => "mediumtext", is_nullable => 1 },
421
  "othernames",
422
  { data_type => "mediumtext", is_nullable => 1 },
423
  "initials",
424
  { data_type => "text", is_nullable => 1 },
425
  "streetnumber",
426
  { data_type => "varchar", is_nullable => 1, size => 10 },
427
  "streettype",
428
  { data_type => "varchar", is_nullable => 1, size => 50 },
429
  "address",
430
  { data_type => "mediumtext", is_nullable => 1 },
431
  "address2",
432
  { data_type => "text", is_nullable => 1 },
433
  "city",
434
  { data_type => "mediumtext", is_nullable => 1 },
435
  "state",
436
  { data_type => "text", is_nullable => 1 },
437
  "zipcode",
438
  { data_type => "varchar", is_nullable => 1, size => 25 },
439
  "country",
440
  { data_type => "text", is_nullable => 1 },
441
  "email",
442
  { data_type => "mediumtext", is_nullable => 1 },
443
  "phone",
444
  { data_type => "text", is_nullable => 1 },
445
  "mobile",
446
  { data_type => "varchar", is_nullable => 1, size => 50 },
447
  "fax",
448
  { data_type => "mediumtext", is_nullable => 1 },
449
  "emailpro",
450
  { data_type => "text", is_nullable => 1 },
451
  "phonepro",
452
  { data_type => "text", is_nullable => 1 },
453
  "b_streetnumber",
454
  { data_type => "varchar", is_nullable => 1, size => 10 },
455
  "b_streettype",
456
  { data_type => "varchar", is_nullable => 1, size => 50 },
457
  "b_address",
458
  { data_type => "varchar", is_nullable => 1, size => 100 },
459
  "b_address2",
460
  { data_type => "text", is_nullable => 1 },
461
  "b_city",
462
  { data_type => "mediumtext", is_nullable => 1 },
463
  "b_state",
464
  { data_type => "text", is_nullable => 1 },
465
  "b_zipcode",
466
  { data_type => "varchar", is_nullable => 1, size => 25 },
467
  "b_country",
468
  { data_type => "text", is_nullable => 1 },
469
  "b_email",
470
  { data_type => "text", is_nullable => 1 },
471
  "b_phone",
472
  { data_type => "mediumtext", is_nullable => 1 },
473
  "dateofbirth",
474
  { data_type => "date", is_nullable => 1 },
475
  "branchcode",
476
  { data_type => "varchar", is_nullable => 1, size => 10 },
477
  "categorycode",
478
  { data_type => "varchar", is_nullable => 1, size => 10 },
479
  "dateenrolled",
480
  { data_type => "date", is_nullable => 1 },
481
  "dateexpiry",
482
  { data_type => "date", is_nullable => 1 },
483
  "gonenoaddress",
484
  { data_type => "tinyint", is_nullable => 1 },
485
  "lost",
486
  { data_type => "tinyint", is_nullable => 1 },
487
  "debarred",
488
  { data_type => "date", is_nullable => 1 },
489
  "debarredcomment",
490
  { data_type => "varchar", is_nullable => 1, size => 255 },
491
  "contactname",
492
  { data_type => "mediumtext", is_nullable => 1 },
493
  "contactfirstname",
494
  { data_type => "text", is_nullable => 1 },
495
  "contacttitle",
496
  { data_type => "text", is_nullable => 1 },
497
  "guarantorid",
498
  { data_type => "integer", is_nullable => 1 },
499
  "borrowernotes",
500
  { data_type => "mediumtext", is_nullable => 1 },
501
  "relationship",
502
  { data_type => "varchar", is_nullable => 1, size => 100 },
503
  "ethnicity",
504
  { data_type => "varchar", is_nullable => 1, size => 50 },
505
  "ethnotes",
506
  { data_type => "varchar", is_nullable => 1, size => 255 },
507
  "sex",
508
  { data_type => "varchar", is_nullable => 1, size => 1 },
509
  "password",
510
  { data_type => "varchar", is_nullable => 1, size => 30 },
511
  "flags",
512
  { data_type => "integer", is_nullable => 1 },
513
  "userid",
514
  { data_type => "varchar", is_nullable => 1, size => 75 },
515
  "opacnote",
516
  { data_type => "mediumtext", is_nullable => 1 },
517
  "contactnote",
518
  { data_type => "varchar", is_nullable => 1, size => 255 },
519
  "sort1",
520
  { data_type => "varchar", is_nullable => 1, size => 80 },
521
  "sort2",
522
  { data_type => "varchar", is_nullable => 1, size => 80 },
523
  "altcontactfirstname",
524
  { data_type => "varchar", is_nullable => 1, size => 255 },
525
  "altcontactsurname",
526
  { data_type => "varchar", is_nullable => 1, size => 255 },
527
  "altcontactaddress1",
528
  { data_type => "varchar", is_nullable => 1, size => 255 },
529
  "altcontactaddress2",
530
  { data_type => "varchar", is_nullable => 1, size => 255 },
531
  "altcontactaddress3",
532
  { data_type => "varchar", is_nullable => 1, size => 255 },
533
  "altcontactstate",
534
  { data_type => "text", is_nullable => 1 },
535
  "altcontactzipcode",
536
  { data_type => "varchar", is_nullable => 1, size => 50 },
537
  "altcontactcountry",
538
  { data_type => "text", is_nullable => 1 },
539
  "altcontactphone",
540
  { data_type => "varchar", is_nullable => 1, size => 50 },
541
  "smsalertnumber",
542
  { data_type => "varchar", is_nullable => 1, size => 50 },
543
  "privacy",
544
  { data_type => "integer", is_nullable => 1 },
545
);
546
__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
547
548
549
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
550
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:F50fjkEjqHuyl7zaEDV+3A
551
552
553
# You can replace this text with custom content, and it will be preserved on regeneration
554
1;
(-)a/Koha/Schema/Result/Branch.pm (-2 / +62 lines)
Lines 158-163 __PACKAGE__->set_primary_key("branchcode"); Link Here
158
158
159
=head1 RELATIONS
159
=head1 RELATIONS
160
160
161
=head2 authorised_values_branches
162
163
Type: has_many
164
165
Related object: L<Koha::Schema::Result::AuthorisedValuesBranch>
166
167
=cut
168
169
__PACKAGE__->has_many(
170
  "authorised_values_branches",
171
  "Koha::Schema::Result::AuthorisedValuesBranch",
172
  { "foreign.branchcode" => "self.branchcode" },
173
  { cascade_copy => 0, cascade_delete => 0 },
174
);
175
176
=head2 borrower_attribute_types_branches
177
178
Type: has_many
179
180
Related object: L<Koha::Schema::Result::BorrowerAttributeTypesBranch>
181
182
=cut
183
184
__PACKAGE__->has_many(
185
  "borrower_attribute_types_branches",
186
  "Koha::Schema::Result::BorrowerAttributeTypesBranch",
187
  { "foreign.b_branchcode" => "self.branchcode" },
188
  { cascade_copy => 0, cascade_delete => 0 },
189
);
190
161
=head2 borrowers
191
=head2 borrowers
162
192
163
Type: has_many
193
Type: has_many
Lines 248-253 __PACKAGE__->has_many( Link Here
248
  { cascade_copy => 0, cascade_delete => 0 },
278
  { cascade_copy => 0, cascade_delete => 0 },
249
);
279
);
250
280
281
=head2 categories_branches
282
283
Type: has_many
284
285
Related object: L<Koha::Schema::Result::CategoriesBranch>
286
287
=cut
288
289
__PACKAGE__->has_many(
290
  "categories_branches",
291
  "Koha::Schema::Result::CategoriesBranch",
292
  { "foreign.branchcode" => "self.branchcode" },
293
  { cascade_copy => 0, cascade_delete => 0 },
294
);
295
296
=head2 course_items
297
298
Type: has_many
299
300
Related object: L<Koha::Schema::Result::CourseItem>
301
302
=cut
303
304
__PACKAGE__->has_many(
305
  "course_items",
306
  "Koha::Schema::Result::CourseItem",
307
  { "foreign.holdingbranch" => "self.branchcode" },
308
  { cascade_copy => 0, cascade_delete => 0 },
309
);
310
251
=head2 creator_batches
311
=head2 creator_batches
252
312
253
Type: has_many
313
Type: has_many
Lines 369-376 __PACKAGE__->has_many( Link Here
369
);
429
);
370
430
371
431
372
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
432
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
373
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7/fUACQhSXHg0daDi6MGbQ
433
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BS/6xtFAoMSKsXho4IXXjQ
374
434
375
435
376
# You can replace this text with custom content, and it will be preserved on regeneration
436
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Branchcategory.pm (-2 / +10 lines)
Lines 43-48 __PACKAGE__->table("branchcategories"); Link Here
43
  is_nullable: 1
43
  is_nullable: 1
44
  size: 16
44
  size: 16
45
45
46
=head2 show_in_pulldown
47
48
  data_type: 'tinyint'
49
  default_value: 0
50
  is_nullable: 0
51
46
=cut
52
=cut
47
53
48
__PACKAGE__->add_columns(
54
__PACKAGE__->add_columns(
Lines 54-59 __PACKAGE__->add_columns( Link Here
54
  { data_type => "mediumtext", is_nullable => 1 },
60
  { data_type => "mediumtext", is_nullable => 1 },
55
  "categorytype",
61
  "categorytype",
56
  { data_type => "varchar", is_nullable => 1, size => 16 },
62
  { data_type => "varchar", is_nullable => 1, size => 16 },
63
  "show_in_pulldown",
64
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
57
);
65
);
58
__PACKAGE__->set_primary_key("categorycode");
66
__PACKAGE__->set_primary_key("categorycode");
59
67
Lines 75-82 __PACKAGE__->has_many( Link Here
75
);
83
);
76
84
77
85
78
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
86
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
79
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:i3um3oAfQ9EV/pJHuUiWnA
87
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VkvImio07fpqmHCntPn5+w
80
88
81
89
82
# You can replace this text with custom content, and it will be preserved on regeneration
90
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/CategoriesBranch.pm (+83 lines)
Line 0 Link Here
1
package Koha::Schema::Result::CategoriesBranch;
2
3
# Created by DBIx::Class::Schema::Loader
4
# DO NOT MODIFY THE FIRST PART OF THIS FILE
5
6
use strict;
7
use warnings;
8
9
use base 'DBIx::Class::Core';
10
11
12
=head1 NAME
13
14
Koha::Schema::Result::CategoriesBranch
15
16
=cut
17
18
__PACKAGE__->table("categories_branches");
19
20
=head1 ACCESSORS
21
22
=head2 categorycode
23
24
  data_type: 'varchar'
25
  is_foreign_key: 1
26
  is_nullable: 1
27
  size: 10
28
29
=head2 branchcode
30
31
  data_type: 'varchar'
32
  is_foreign_key: 1
33
  is_nullable: 1
34
  size: 10
35
36
=cut
37
38
__PACKAGE__->add_columns(
39
  "categorycode",
40
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
41
  "branchcode",
42
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
43
);
44
45
=head1 RELATIONS
46
47
=head2 categorycode
48
49
Type: belongs_to
50
51
Related object: L<Koha::Schema::Result::Category>
52
53
=cut
54
55
__PACKAGE__->belongs_to(
56
  "categorycode",
57
  "Koha::Schema::Result::Category",
58
  { categorycode => "categorycode" },
59
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
60
);
61
62
=head2 branchcode
63
64
Type: belongs_to
65
66
Related object: L<Koha::Schema::Result::Branch>
67
68
=cut
69
70
__PACKAGE__->belongs_to(
71
  "branchcode",
72
  "Koha::Schema::Result::Branch",
73
  { branchcode => "branchcode" },
74
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
75
);
76
77
78
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
79
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SVolMqOZ2fpkPdSCSjpDUA
80
81
82
# You can replace this text with custom content, and it will be preserved on regeneration
83
1;
(-)a/Koha/Schema/Result/Category.pm (-17 / +17 lines)
Lines 133-153 __PACKAGE__->set_primary_key("categorycode"); Link Here
133
133
134
=head1 RELATIONS
134
=head1 RELATIONS
135
135
136
=head2 borrower_attribute_types
137
138
Type: has_many
139
140
Related object: L<Koha::Schema::Result::BorrowerAttributeType>
141
142
=cut
143
144
__PACKAGE__->has_many(
145
  "borrower_attribute_types",
146
  "Koha::Schema::Result::BorrowerAttributeType",
147
  { "foreign.category_code" => "self.categorycode" },
148
  { cascade_copy => 0, cascade_delete => 0 },
149
);
150
151
=head2 borrower_message_preferences
136
=head2 borrower_message_preferences
152
137
153
Type: has_many
138
Type: has_many
Lines 193-198 __PACKAGE__->has_many( Link Here
193
  { cascade_copy => 0, cascade_delete => 0 },
178
  { cascade_copy => 0, cascade_delete => 0 },
194
);
179
);
195
180
181
=head2 categories_branches
182
183
Type: has_many
184
185
Related object: L<Koha::Schema::Result::CategoriesBranch>
186
187
=cut
188
189
__PACKAGE__->has_many(
190
  "categories_branches",
191
  "Koha::Schema::Result::CategoriesBranch",
192
  { "foreign.categorycode" => "self.categorycode" },
193
  { cascade_copy => 0, cascade_delete => 0 },
194
);
195
196
=head2 default_borrower_circ_rule
196
=head2 default_borrower_circ_rule
197
197
198
Type: might_have
198
Type: might_have
Lines 209-216 __PACKAGE__->might_have( Link Here
209
);
209
);
210
210
211
211
212
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
212
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
213
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BpTckQJaDAxGwrOS9s3tuQ
213
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rQnbpUtXD6tNSnSGpowcaw
214
214
215
215
216
# You can replace this text with custom content, and it will be preserved on regeneration
216
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/City.pm (-8 / +8 lines)
Lines 38-54 __PACKAGE__->table("cities"); Link Here
38
  is_nullable: 1
38
  is_nullable: 1
39
  size: 100
39
  size: 100
40
40
41
=head2 city_zipcode
41
=head2 city_country
42
42
43
  data_type: 'varchar'
43
  data_type: 'varchar'
44
  is_nullable: 1
44
  is_nullable: 1
45
  size: 20
45
  size: 100
46
46
47
=head2 city_country
47
=head2 city_zipcode
48
48
49
  data_type: 'varchar'
49
  data_type: 'varchar'
50
  is_nullable: 1
50
  is_nullable: 1
51
  size: 100
51
  size: 20
52
52
53
=cut
53
=cut
54
54
Lines 59-74 __PACKAGE__->add_columns( Link Here
59
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
59
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
60
  "city_state",
60
  "city_state",
61
  { data_type => "varchar", is_nullable => 1, size => 100 },
61
  { data_type => "varchar", is_nullable => 1, size => 100 },
62
  "city_zipcode",
63
  { data_type => "varchar", is_nullable => 1, size => 20 },
64
  "city_country",
62
  "city_country",
65
  { data_type => "varchar", is_nullable => 1, size => 100 },
63
  { data_type => "varchar", is_nullable => 1, size => 100 },
64
  "city_zipcode",
65
  { data_type => "varchar", is_nullable => 1, size => 20 },
66
);
66
);
67
__PACKAGE__->set_primary_key("cityid");
67
__PACKAGE__->set_primary_key("cityid");
68
68
69
69
70
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
70
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
71
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rm0FlpZ/rA6OLY0TP/RMTQ
71
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ziAiH8vvSS8OzKHZBcpUow
72
72
73
73
74
# You can replace this text with custom content, and it will be preserved on regeneration
74
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Course.pm (+162 lines)
Line 0 Link Here
1
package Koha::Schema::Result::Course;
2
3
# Created by DBIx::Class::Schema::Loader
4
# DO NOT MODIFY THE FIRST PART OF THIS FILE
5
6
use strict;
7
use warnings;
8
9
use base 'DBIx::Class::Core';
10
11
12
=head1 NAME
13
14
Koha::Schema::Result::Course
15
16
=cut
17
18
__PACKAGE__->table("courses");
19
20
=head1 ACCESSORS
21
22
=head2 course_id
23
24
  data_type: 'integer'
25
  is_auto_increment: 1
26
  is_nullable: 0
27
28
=head2 department
29
30
  data_type: 'varchar'
31
  is_nullable: 1
32
  size: 20
33
34
=head2 course_number
35
36
  data_type: 'varchar'
37
  is_nullable: 1
38
  size: 255
39
40
=head2 section
41
42
  data_type: 'varchar'
43
  is_nullable: 1
44
  size: 255
45
46
=head2 course_name
47
48
  data_type: 'varchar'
49
  is_nullable: 1
50
  size: 255
51
52
=head2 term
53
54
  data_type: 'varchar'
55
  is_nullable: 1
56
  size: 20
57
58
=head2 staff_note
59
60
  data_type: 'mediumtext'
61
  is_nullable: 1
62
63
=head2 public_note
64
65
  data_type: 'mediumtext'
66
  is_nullable: 1
67
68
=head2 students_count
69
70
  data_type: 'varchar'
71
  is_nullable: 1
72
  size: 20
73
74
=head2 enabled
75
76
  data_type: 'enum'
77
  default_value: 'yes'
78
  extra: {list => ["yes","no"]}
79
  is_nullable: 0
80
81
=head2 timestamp
82
83
  data_type: 'timestamp'
84
  default_value: current_timestamp
85
  is_nullable: 0
86
87
=cut
88
89
__PACKAGE__->add_columns(
90
  "course_id",
91
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
92
  "department",
93
  { data_type => "varchar", is_nullable => 1, size => 20 },
94
  "course_number",
95
  { data_type => "varchar", is_nullable => 1, size => 255 },
96
  "section",
97
  { data_type => "varchar", is_nullable => 1, size => 255 },
98
  "course_name",
99
  { data_type => "varchar", is_nullable => 1, size => 255 },
100
  "term",
101
  { data_type => "varchar", is_nullable => 1, size => 20 },
102
  "staff_note",
103
  { data_type => "mediumtext", is_nullable => 1 },
104
  "public_note",
105
  { data_type => "mediumtext", is_nullable => 1 },
106
  "students_count",
107
  { data_type => "varchar", is_nullable => 1, size => 20 },
108
  "enabled",
109
  {
110
    data_type => "enum",
111
    default_value => "yes",
112
    extra => { list => ["yes", "no"] },
113
    is_nullable => 0,
114
  },
115
  "timestamp",
116
  {
117
    data_type     => "timestamp",
118
    default_value => \"current_timestamp",
119
    is_nullable   => 0,
120
  },
121
);
122
__PACKAGE__->set_primary_key("course_id");
123
124
=head1 RELATIONS
125
126
=head2 course_instructors
127
128
Type: has_many
129
130
Related object: L<Koha::Schema::Result::CourseInstructor>
131
132
=cut
133
134
__PACKAGE__->has_many(
135
  "course_instructors",
136
  "Koha::Schema::Result::CourseInstructor",
137
  { "foreign.course_id" => "self.course_id" },
138
  { cascade_copy => 0, cascade_delete => 0 },
139
);
140
141
=head2 course_reserves
142
143
Type: has_many
144
145
Related object: L<Koha::Schema::Result::CourseReserve>
146
147
=cut
148
149
__PACKAGE__->has_many(
150
  "course_reserves",
151
  "Koha::Schema::Result::CourseReserve",
152
  { "foreign.course_id" => "self.course_id" },
153
  { cascade_copy => 0, cascade_delete => 0 },
154
);
155
156
157
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
158
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SN5SfQi+SbfPr069wck64w
159
160
161
# You can replace this text with custom content, and it will be preserved on regeneration
162
1;
(-)a/Koha/Schema/Result/CourseInstructor.pm (+82 lines)
Line 0 Link Here
1
package Koha::Schema::Result::CourseInstructor;
2
3
# Created by DBIx::Class::Schema::Loader
4
# DO NOT MODIFY THE FIRST PART OF THIS FILE
5
6
use strict;
7
use warnings;
8
9
use base 'DBIx::Class::Core';
10
11
12
=head1 NAME
13
14
Koha::Schema::Result::CourseInstructor
15
16
=cut
17
18
__PACKAGE__->table("course_instructors");
19
20
=head1 ACCESSORS
21
22
=head2 course_id
23
24
  data_type: 'integer'
25
  is_foreign_key: 1
26
  is_nullable: 0
27
28
=head2 borrowernumber
29
30
  data_type: 'integer'
31
  is_foreign_key: 1
32
  is_nullable: 0
33
34
=cut
35
36
__PACKAGE__->add_columns(
37
  "course_id",
38
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
39
  "borrowernumber",
40
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
41
);
42
__PACKAGE__->set_primary_key("course_id", "borrowernumber");
43
44
=head1 RELATIONS
45
46
=head2 course
47
48
Type: belongs_to
49
50
Related object: L<Koha::Schema::Result::Course>
51
52
=cut
53
54
__PACKAGE__->belongs_to(
55
  "course",
56
  "Koha::Schema::Result::Course",
57
  { course_id => "course_id" },
58
  { on_delete => "CASCADE", on_update => "CASCADE" },
59
);
60
61
=head2 borrowernumber
62
63
Type: belongs_to
64
65
Related object: L<Koha::Schema::Result::Borrower>
66
67
=cut
68
69
__PACKAGE__->belongs_to(
70
  "borrowernumber",
71
  "Koha::Schema::Result::Borrower",
72
  { borrowernumber => "borrowernumber" },
73
  { on_delete => "CASCADE", on_update => "CASCADE" },
74
);
75
76
77
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
78
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zPwefIbI2Pz0pX03KpS1eQ
79
80
81
# You can replace this text with custom content, and it will be preserved on regeneration
82
1;
(-)a/Koha/Schema/Result/CourseItem.pm (+142 lines)
Line 0 Link Here
1
package Koha::Schema::Result::CourseItem;
2
3
# Created by DBIx::Class::Schema::Loader
4
# DO NOT MODIFY THE FIRST PART OF THIS FILE
5
6
use strict;
7
use warnings;
8
9
use base 'DBIx::Class::Core';
10
11
12
=head1 NAME
13
14
Koha::Schema::Result::CourseItem
15
16
=cut
17
18
__PACKAGE__->table("course_items");
19
20
=head1 ACCESSORS
21
22
=head2 ci_id
23
24
  data_type: 'integer'
25
  is_auto_increment: 1
26
  is_nullable: 0
27
28
=head2 itemnumber
29
30
  data_type: 'integer'
31
  is_foreign_key: 1
32
  is_nullable: 0
33
34
=head2 itype
35
36
  data_type: 'varchar'
37
  is_nullable: 1
38
  size: 10
39
40
=head2 ccode
41
42
  data_type: 'varchar'
43
  is_nullable: 1
44
  size: 10
45
46
=head2 holdingbranch
47
48
  data_type: 'varchar'
49
  is_foreign_key: 1
50
  is_nullable: 1
51
  size: 10
52
53
=head2 location
54
55
  data_type: 'varchar'
56
  is_nullable: 1
57
  size: 80
58
59
=head2 enabled
60
61
  data_type: 'enum'
62
  default_value: 'no'
63
  extra: {list => ["yes","no"]}
64
  is_nullable: 0
65
66
=head2 timestamp
67
68
  data_type: 'timestamp'
69
  default_value: current_timestamp
70
  is_nullable: 0
71
72
=cut
73
74
__PACKAGE__->add_columns(
75
  "ci_id",
76
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
77
  "itemnumber",
78
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
79
  "itype",
80
  { data_type => "varchar", is_nullable => 1, size => 10 },
81
  "ccode",
82
  { data_type => "varchar", is_nullable => 1, size => 10 },
83
  "holdingbranch",
84
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
85
  "location",
86
  { data_type => "varchar", is_nullable => 1, size => 80 },
87
  "enabled",
88
  {
89
    data_type => "enum",
90
    default_value => "no",
91
    extra => { list => ["yes", "no"] },
92
    is_nullable => 0,
93
  },
94
  "timestamp",
95
  {
96
    data_type     => "timestamp",
97
    default_value => \"current_timestamp",
98
    is_nullable   => 0,
99
  },
100
);
101
__PACKAGE__->set_primary_key("ci_id");
102
__PACKAGE__->add_unique_constraint("itemnumber", ["itemnumber"]);
103
104
=head1 RELATIONS
105
106
=head2 holdingbranch
107
108
Type: belongs_to
109
110
Related object: L<Koha::Schema::Result::Branch>
111
112
=cut
113
114
__PACKAGE__->belongs_to(
115
  "holdingbranch",
116
  "Koha::Schema::Result::Branch",
117
  { branchcode => "holdingbranch" },
118
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
119
);
120
121
=head2 itemnumber
122
123
Type: belongs_to
124
125
Related object: L<Koha::Schema::Result::Item>
126
127
=cut
128
129
__PACKAGE__->belongs_to(
130
  "itemnumber",
131
  "Koha::Schema::Result::Item",
132
  { itemnumber => "itemnumber" },
133
  { on_delete => "CASCADE", on_update => "CASCADE" },
134
);
135
136
137
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
138
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BAqW3ImuEzBoIMWAeM12qA
139
140
141
# You can replace this text with custom content, and it will be preserved on regeneration
142
1;
(-)a/Koha/Schema/Result/CourseReserve.pm (+101 lines)
Line 0 Link Here
1
package Koha::Schema::Result::CourseReserve;
2
3
# Created by DBIx::Class::Schema::Loader
4
# DO NOT MODIFY THE FIRST PART OF THIS FILE
5
6
use strict;
7
use warnings;
8
9
use base 'DBIx::Class::Core';
10
11
12
=head1 NAME
13
14
Koha::Schema::Result::CourseReserve
15
16
=cut
17
18
__PACKAGE__->table("course_reserves");
19
20
=head1 ACCESSORS
21
22
=head2 cr_id
23
24
  data_type: 'integer'
25
  is_auto_increment: 1
26
  is_nullable: 0
27
28
=head2 course_id
29
30
  data_type: 'integer'
31
  is_foreign_key: 1
32
  is_nullable: 0
33
34
=head2 ci_id
35
36
  data_type: 'integer'
37
  is_nullable: 0
38
39
=head2 staff_note
40
41
  data_type: 'mediumtext'
42
  is_nullable: 1
43
44
=head2 public_note
45
46
  data_type: 'mediumtext'
47
  is_nullable: 1
48
49
=head2 timestamp
50
51
  data_type: 'timestamp'
52
  default_value: current_timestamp
53
  is_nullable: 0
54
55
=cut
56
57
__PACKAGE__->add_columns(
58
  "cr_id",
59
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
60
  "course_id",
61
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
62
  "ci_id",
63
  { data_type => "integer", is_nullable => 0 },
64
  "staff_note",
65
  { data_type => "mediumtext", is_nullable => 1 },
66
  "public_note",
67
  { data_type => "mediumtext", is_nullable => 1 },
68
  "timestamp",
69
  {
70
    data_type     => "timestamp",
71
    default_value => \"current_timestamp",
72
    is_nullable   => 0,
73
  },
74
);
75
__PACKAGE__->set_primary_key("cr_id");
76
__PACKAGE__->add_unique_constraint("pseudo_key", ["course_id", "ci_id"]);
77
78
=head1 RELATIONS
79
80
=head2 course
81
82
Type: belongs_to
83
84
Related object: L<Koha::Schema::Result::Course>
85
86
=cut
87
88
__PACKAGE__->belongs_to(
89
  "course",
90
  "Koha::Schema::Result::Course",
91
  { course_id => "course_id" },
92
  { on_delete => "CASCADE", on_update => "CASCADE" },
93
);
94
95
96
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
97
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LUZRTXuhywezgITcSqqDJQ
98
99
100
# You can replace this text with custom content, and it will be preserved on regeneration
101
1;
(-)a/Koha/Schema/Result/Deletedbiblio.pm (-4 / +4 lines)
Lines 22-28 __PACKAGE__->table("deletedbiblio"); Link Here
22
=head2 biblionumber
22
=head2 biblionumber
23
23
24
  data_type: 'integer'
24
  data_type: 'integer'
25
  default_value: 0
25
  is_auto_increment: 1
26
  is_nullable: 0
26
  is_nullable: 0
27
27
28
=head2 frameworkcode
28
=head2 frameworkcode
Lines 87-93 __PACKAGE__->table("deletedbiblio"); Link Here
87
87
88
__PACKAGE__->add_columns(
88
__PACKAGE__->add_columns(
89
  "biblionumber",
89
  "biblionumber",
90
  { data_type => "integer", default_value => 0, is_nullable => 0 },
90
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
91
  "frameworkcode",
91
  "frameworkcode",
92
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 4 },
92
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 4 },
93
  "author",
93
  "author",
Lines 118-125 __PACKAGE__->add_columns( Link Here
118
__PACKAGE__->set_primary_key("biblionumber");
118
__PACKAGE__->set_primary_key("biblionumber");
119
119
120
120
121
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
121
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
122
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/x/M9xGCkN5ClHrk1GUELw
122
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:NeMRnyT+TXPaypKdluD7BQ
123
123
124
124
125
# You can replace this text with custom content, and it will be preserved on regeneration
125
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Deletedborrower.pm (-12 / +14 lines)
Lines 85-91 __PACKAGE__->table("deletedborrowers"); Link Here
85
85
86
=head2 state
86
=head2 state
87
87
88
  data_type: 'mediumtext'
88
  data_type: 'text'
89
  is_nullable: 1
89
  is_nullable: 1
90
90
91
=head2 zipcode
91
=head2 zipcode
Lines 160-166 __PACKAGE__->table("deletedborrowers"); Link Here
160
160
161
=head2 b_state
161
=head2 b_state
162
162
163
  data_type: 'mediumtext'
163
  data_type: 'text'
164
  is_nullable: 1
164
  is_nullable: 1
165
165
166
=head2 b_zipcode
166
=head2 b_zipcode
Lines 199-205 __PACKAGE__->table("deletedborrowers"); Link Here
199
=head2 categorycode
199
=head2 categorycode
200
200
201
  data_type: 'varchar'
201
  data_type: 'varchar'
202
  is_nullable: 1
202
  default_value: (empty string)
203
  is_nullable: 0
203
  size: 10
204
  size: 10
204
205
205
=head2 dateenrolled
206
=head2 dateenrolled
Lines 354-360 __PACKAGE__->table("deletedborrowers"); Link Here
354
355
355
=head2 altcontactstate
356
=head2 altcontactstate
356
357
357
  data_type: 'mediumtext'
358
  data_type: 'text'
358
  is_nullable: 1
359
  is_nullable: 1
359
360
360
=head2 altcontactzipcode
361
=head2 altcontactzipcode
Lines 383-389 __PACKAGE__->table("deletedborrowers"); Link Here
383
=head2 privacy
384
=head2 privacy
384
385
385
  data_type: 'integer'
386
  data_type: 'integer'
386
  is_nullable: 1
387
  default_value: 1
388
  is_nullable: 0
387
389
388
=cut
390
=cut
389
391
Lines 413-419 __PACKAGE__->add_columns( Link Here
413
  "city",
415
  "city",
414
  { data_type => "mediumtext", is_nullable => 0 },
416
  { data_type => "mediumtext", is_nullable => 0 },
415
  "state",
417
  "state",
416
  { data_type => "mediumtext", is_nullable => 1 },
418
  { data_type => "text", is_nullable => 1 },
417
  "zipcode",
419
  "zipcode",
418
  { data_type => "varchar", is_nullable => 1, size => 25 },
420
  { data_type => "varchar", is_nullable => 1, size => 25 },
419
  "country",
421
  "country",
Lines 441-447 __PACKAGE__->add_columns( Link Here
441
  "b_city",
443
  "b_city",
442
  { data_type => "mediumtext", is_nullable => 1 },
444
  { data_type => "mediumtext", is_nullable => 1 },
443
  "b_state",
445
  "b_state",
444
  { data_type => "mediumtext", is_nullable => 1 },
446
  { data_type => "text", is_nullable => 1 },
445
  "b_zipcode",
447
  "b_zipcode",
446
  { data_type => "varchar", is_nullable => 1, size => 25 },
448
  { data_type => "varchar", is_nullable => 1, size => 25 },
447
  "b_country",
449
  "b_country",
Lines 455-461 __PACKAGE__->add_columns( Link Here
455
  "branchcode",
457
  "branchcode",
456
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
458
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
457
  "categorycode",
459
  "categorycode",
458
  { data_type => "varchar", is_nullable => 1, size => 10 },
460
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
459
  "dateenrolled",
461
  "dateenrolled",
460
  { data_type => "date", is_nullable => 1 },
462
  { data_type => "date", is_nullable => 1 },
461
  "dateexpiry",
463
  "dateexpiry",
Lines 511-517 __PACKAGE__->add_columns( Link Here
511
  "altcontactaddress3",
513
  "altcontactaddress3",
512
  { data_type => "varchar", is_nullable => 1, size => 255 },
514
  { data_type => "varchar", is_nullable => 1, size => 255 },
513
  "altcontactstate",
515
  "altcontactstate",
514
  { data_type => "mediumtext", is_nullable => 1 },
516
  { data_type => "text", is_nullable => 1 },
515
  "altcontactzipcode",
517
  "altcontactzipcode",
516
  { data_type => "varchar", is_nullable => 1, size => 50 },
518
  { data_type => "varchar", is_nullable => 1, size => 50 },
517
  "altcontactcountry",
519
  "altcontactcountry",
Lines 521-532 __PACKAGE__->add_columns( Link Here
521
  "smsalertnumber",
523
  "smsalertnumber",
522
  { data_type => "varchar", is_nullable => 1, size => 50 },
524
  { data_type => "varchar", is_nullable => 1, size => 50 },
523
  "privacy",
525
  "privacy",
524
  { data_type => "integer", is_nullable => 1 },
526
  { data_type => "integer", default_value => 1, is_nullable => 0 },
525
);
527
);
526
528
527
529
528
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
530
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
529
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bFluvx9OwGTzEMpQZPBuKQ
531
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1D2zAd8OsHXZ2s9cEVevug
530
532
531
533
532
# You can replace this text with custom content, and it will be preserved on regeneration
534
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Deleteditem.pm (-2 / +10 lines)
Lines 121-126 __PACKAGE__->table("deleteditems"); Link Here
121
  is_nullable: 1
121
  is_nullable: 1
122
  size: 255
122
  size: 255
123
123
124
=head2 coded_location_qualifier
125
126
  data_type: 'varchar'
127
  is_nullable: 1
128
  size: 10
129
124
=head2 issues
130
=head2 issues
125
131
126
  data_type: 'smallint'
132
  data_type: 'smallint'
Lines 282-287 __PACKAGE__->add_columns( Link Here
282
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
288
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
283
  "itemcallnumber",
289
  "itemcallnumber",
284
  { data_type => "varchar", is_nullable => 1, size => 255 },
290
  { data_type => "varchar", is_nullable => 1, size => 255 },
291
  "coded_location_qualifier",
292
  { data_type => "varchar", is_nullable => 1, size => 10 },
285
  "issues",
293
  "issues",
286
  { data_type => "smallint", is_nullable => 1 },
294
  { data_type => "smallint", is_nullable => 1 },
287
  "renewals",
295
  "renewals",
Lines 334-341 __PACKAGE__->add_columns( Link Here
334
__PACKAGE__->set_primary_key("itemnumber");
342
__PACKAGE__->set_primary_key("itemnumber");
335
343
336
344
337
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
345
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
338
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:71VE1YzdzK7dAtGTVKeCkg
346
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dQeILHSwObg9anjIGL+5vA
339
347
340
348
341
# You can replace this text with custom content, and it will be preserved on regeneration
349
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/ImportBatch.pm (-13 / +13 lines)
Lines 94-99 __PACKAGE__->table("import_batches"); Link Here
94
  extra: {list => ["batch","z3950","webservice"]}
94
  extra: {list => ["batch","z3950","webservice"]}
95
  is_nullable: 0
95
  is_nullable: 0
96
96
97
=head2 record_type
98
99
  data_type: 'enum'
100
  default_value: 'biblio'
101
  extra: {list => ["biblio","auth","holdings"]}
102
  is_nullable: 0
103
97
=head2 file_name
104
=head2 file_name
98
105
99
  data_type: 'varchar'
106
  data_type: 'varchar'
Lines 105-117 __PACKAGE__->table("import_batches"); Link Here
105
  data_type: 'mediumtext'
112
  data_type: 'mediumtext'
106
  is_nullable: 1
113
  is_nullable: 1
107
114
108
=head2 record_type
109
110
  data_type: 'enum'
111
  default_value: 'biblio'
112
  extra: {list => ["biblio","auth","holdings"]}
113
  is_nullable: 0
114
115
=cut
115
=cut
116
116
117
__PACKAGE__->add_columns(
117
__PACKAGE__->add_columns(
Lines 185-194 __PACKAGE__->add_columns( Link Here
185
    extra => { list => ["batch", "z3950", "webservice"] },
185
    extra => { list => ["batch", "z3950", "webservice"] },
186
    is_nullable => 0,
186
    is_nullable => 0,
187
  },
187
  },
188
  "file_name",
189
  { data_type => "varchar", is_nullable => 1, size => 100 },
190
  "comments",
191
  { data_type => "mediumtext", is_nullable => 1 },
192
  "record_type",
188
  "record_type",
193
  {
189
  {
194
    data_type => "enum",
190
    data_type => "enum",
Lines 196-201 __PACKAGE__->add_columns( Link Here
196
    extra => { list => ["biblio", "auth", "holdings"] },
192
    extra => { list => ["biblio", "auth", "holdings"] },
197
    is_nullable => 0,
193
    is_nullable => 0,
198
  },
194
  },
195
  "file_name",
196
  { data_type => "varchar", is_nullable => 1, size => 100 },
197
  "comments",
198
  { data_type => "mediumtext", is_nullable => 1 },
199
);
199
);
200
__PACKAGE__->set_primary_key("import_batch_id");
200
__PACKAGE__->set_primary_key("import_batch_id");
201
201
Lines 217-224 __PACKAGE__->has_many( Link Here
217
);
217
);
218
218
219
219
220
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
220
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
221
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:es2clfR8Vlgv8rN/kM65iA
221
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LUl8GuPahmUwYeaGAKBJxw
222
222
223
223
224
# You can replace this text with custom content, and it will be preserved on regeneration
224
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Issue.pm (-8 / +8 lines)
Lines 23-35 __PACKAGE__->table("issues"); Link Here
23
23
24
  data_type: 'integer'
24
  data_type: 'integer'
25
  is_foreign_key: 1
25
  is_foreign_key: 1
26
  is_nullable: 0
26
  is_nullable: 1
27
27
28
=head2 itemnumber
28
=head2 itemnumber
29
29
30
  data_type: 'integer'
30
  data_type: 'integer'
31
  is_foreign_key: 1
31
  is_foreign_key: 1
32
  is_nullable: 0
32
  is_nullable: 1
33
33
34
=head2 date_due
34
=head2 date_due
35
35
Lines 84-92 __PACKAGE__->table("issues"); Link Here
84
84
85
__PACKAGE__->add_columns(
85
__PACKAGE__->add_columns(
86
  "borrowernumber",
86
  "borrowernumber",
87
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
87
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
88
  "itemnumber",
88
  "itemnumber",
89
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
89
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
90
  "date_due",
90
  "date_due",
91
  { data_type => "datetime", is_nullable => 1 },
91
  { data_type => "datetime", is_nullable => 1 },
92
  "branchcode",
92
  "branchcode",
Lines 125-131 __PACKAGE__->belongs_to( Link Here
125
  "borrowernumber",
125
  "borrowernumber",
126
  "Koha::Schema::Result::Borrower",
126
  "Koha::Schema::Result::Borrower",
127
  { borrowernumber => "borrowernumber" },
127
  { borrowernumber => "borrowernumber" },
128
  { on_delete => "CASCADE", on_update => "CASCADE" },
128
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
129
);
129
);
130
130
131
=head2 itemnumber
131
=head2 itemnumber
Lines 140-151 __PACKAGE__->belongs_to( Link Here
140
  "itemnumber",
140
  "itemnumber",
141
  "Koha::Schema::Result::Item",
141
  "Koha::Schema::Result::Item",
142
  { itemnumber => "itemnumber" },
142
  { itemnumber => "itemnumber" },
143
  { on_delete => "CASCADE", on_update => "CASCADE" },
143
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
144
);
144
);
145
145
146
146
147
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
147
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
148
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KCy3FmbJK9aZRqXSAkYe5g
148
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uZUDWDGWOkC3oCOyMaG1sg
149
149
150
150
151
# You can replace this text with custom content, and it will be preserved on regeneration
151
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Issuingrule.pm (-2 / +16 lines)
Lines 116-127 __PACKAGE__->table("issuingrules"); Link Here
116
  default_value: 0
116
  default_value: 0
117
  is_nullable: 0
117
  is_nullable: 0
118
118
119
=head2 renewalperiod
120
121
  data_type: 'integer'
122
  is_nullable: 1
123
119
=head2 reservesallowed
124
=head2 reservesallowed
120
125
121
  data_type: 'smallint'
126
  data_type: 'smallint'
122
  default_value: 0
127
  default_value: 0
123
  is_nullable: 0
128
  is_nullable: 0
124
129
130
=head2 holdspickupdelay
131
132
  data_type: 'integer'
133
  is_nullable: 1
134
125
=head2 branchcode
135
=head2 branchcode
126
136
127
  data_type: 'varchar'
137
  data_type: 'varchar'
Lines 176-183 __PACKAGE__->add_columns( Link Here
176
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
186
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
177
  "renewalsallowed",
187
  "renewalsallowed",
178
  { data_type => "smallint", default_value => 0, is_nullable => 0 },
188
  { data_type => "smallint", default_value => 0, is_nullable => 0 },
189
  "renewalperiod",
190
  { data_type => "integer", is_nullable => 1 },
179
  "reservesallowed",
191
  "reservesallowed",
180
  { data_type => "smallint", default_value => 0, is_nullable => 0 },
192
  { data_type => "smallint", default_value => 0, is_nullable => 0 },
193
  "holdspickupdelay",
194
  { data_type => "integer", is_nullable => 1 },
181
  "branchcode",
195
  "branchcode",
182
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
196
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
183
  "overduefinescap",
197
  "overduefinescap",
Lines 186-193 __PACKAGE__->add_columns( Link Here
186
__PACKAGE__->set_primary_key("branchcode", "categorycode", "itemtype");
200
__PACKAGE__->set_primary_key("branchcode", "categorycode", "itemtype");
187
201
188
202
189
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
203
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
190
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bsTUaL5I872EWP0ZLfdPQA
204
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:odTb6vtz4DignNIlYwkNEg
191
205
192
206
193
# You can replace this text with custom content, and it will be preserved on regeneration
207
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Item.pm (-2 / +25 lines)
Lines 123-128 __PACKAGE__->table("items"); Link Here
123
  is_nullable: 1
123
  is_nullable: 1
124
  size: 255
124
  size: 255
125
125
126
=head2 coded_location_qualifier
127
128
  data_type: 'varchar'
129
  is_nullable: 1
130
  size: 10
131
126
=head2 issues
132
=head2 issues
127
133
128
  data_type: 'smallint'
134
  data_type: 'smallint'
Lines 284-289 __PACKAGE__->add_columns( Link Here
284
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
290
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
285
  "itemcallnumber",
291
  "itemcallnumber",
286
  { data_type => "varchar", is_nullable => 1, size => 255 },
292
  { data_type => "varchar", is_nullable => 1, size => 255 },
293
  "coded_location_qualifier",
294
  { data_type => "varchar", is_nullable => 1, size => 10 },
287
  "issues",
295
  "issues",
288
  { data_type => "smallint", is_nullable => 1 },
296
  { data_type => "smallint", is_nullable => 1 },
289
  "renewals",
297
  "renewals",
Lines 366-371 __PACKAGE__->has_many( Link Here
366
  { cascade_copy => 0, cascade_delete => 0 },
374
  { cascade_copy => 0, cascade_delete => 0 },
367
);
375
);
368
376
377
=head2 course_item
378
379
Type: might_have
380
381
Related object: L<Koha::Schema::Result::CourseItem>
382
383
=cut
384
385
__PACKAGE__->might_have(
386
  "course_item",
387
  "Koha::Schema::Result::CourseItem",
388
  { "foreign.itemnumber" => "self.itemnumber" },
389
  { cascade_copy => 0, cascade_delete => 0 },
390
);
391
369
=head2 creator_batches
392
=head2 creator_batches
370
393
371
Type: has_many
394
Type: has_many
Lines 517-524 __PACKAGE__->might_have( Link Here
517
);
540
);
518
541
519
542
520
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
543
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
521
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+jjodrPqX4WhBbgnTc5OqQ
544
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f3HngbnArIKegakzHgcFBg
522
545
523
546
524
# You can replace this text with custom content, and it will be preserved on regeneration
547
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Linktracker.pm (+77 lines)
Line 0 Link Here
1
package Koha::Schema::Result::Linktracker;
2
3
# Created by DBIx::Class::Schema::Loader
4
# DO NOT MODIFY THE FIRST PART OF THIS FILE
5
6
use strict;
7
use warnings;
8
9
use base 'DBIx::Class::Core';
10
11
12
=head1 NAME
13
14
Koha::Schema::Result::Linktracker
15
16
=cut
17
18
__PACKAGE__->table("linktracker");
19
20
=head1 ACCESSORS
21
22
=head2 id
23
24
  data_type: 'integer'
25
  is_auto_increment: 1
26
  is_nullable: 0
27
28
=head2 biblionumber
29
30
  data_type: 'integer'
31
  is_nullable: 1
32
33
=head2 itemnumber
34
35
  data_type: 'integer'
36
  is_nullable: 1
37
38
=head2 borrowernumber
39
40
  data_type: 'integer'
41
  is_nullable: 1
42
43
=head2 url
44
45
  data_type: 'text'
46
  is_nullable: 1
47
48
=head2 timeclicked
49
50
  data_type: 'datetime'
51
  is_nullable: 1
52
53
=cut
54
55
__PACKAGE__->add_columns(
56
  "id",
57
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
58
  "biblionumber",
59
  { data_type => "integer", is_nullable => 1 },
60
  "itemnumber",
61
  { data_type => "integer", is_nullable => 1 },
62
  "borrowernumber",
63
  { data_type => "integer", is_nullable => 1 },
64
  "url",
65
  { data_type => "text", is_nullable => 1 },
66
  "timeclicked",
67
  { data_type => "datetime", is_nullable => 1 },
68
);
69
__PACKAGE__->set_primary_key("id");
70
71
72
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
73
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6e2s/DzzRjvXXrusUC4TZg
74
75
76
# You can replace this text with custom content, and it will be preserved on regeneration
77
1;
(-)a/Koha/Schema/Result/OldReserve.pm (-2 / +9 lines)
Lines 122-127 __PACKAGE__->table("old_reserves"); Link Here
122
  data_type: 'datetime'
122
  data_type: 'datetime'
123
  is_nullable: 1
123
  is_nullable: 1
124
124
125
=head2 maxpickupdate
126
127
  data_type: 'date'
128
  is_nullable: 1
129
125
=cut
130
=cut
126
131
127
__PACKAGE__->add_columns(
132
__PACKAGE__->add_columns(
Lines 167-172 __PACKAGE__->add_columns( Link Here
167
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
172
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
168
  "suspend_until",
173
  "suspend_until",
169
  { data_type => "datetime", is_nullable => 1 },
174
  { data_type => "datetime", is_nullable => 1 },
175
  "maxpickupdate",
176
  { data_type => "date", is_nullable => 1 },
170
);
177
);
171
__PACKAGE__->set_primary_key("reserve_id");
178
__PACKAGE__->set_primary_key("reserve_id");
172
179
Lines 218-225 __PACKAGE__->belongs_to( Link Here
218
);
225
);
219
226
220
227
221
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
228
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
222
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1b1FcIuOJ5ZRU2apc6swkQ
229
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ni1RNxdeOoypM+GwYu1vAQ
223
230
224
231
225
# You can replace this text with custom content, and it will be preserved on regeneration
232
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/PendingOfflineOperation.pm (-4 / +12 lines)
Lines 52-58 __PACKAGE__->table("pending_offline_operations"); Link Here
52
=head2 barcode
52
=head2 barcode
53
53
54
  data_type: 'varchar'
54
  data_type: 'varchar'
55
  is_nullable: 0
55
  is_nullable: 1
56
  size: 20
56
  size: 20
57
57
58
=head2 cardnumber
58
=head2 cardnumber
Lines 61-66 __PACKAGE__->table("pending_offline_operations"); Link Here
61
  is_nullable: 1
61
  is_nullable: 1
62
  size: 16
62
  size: 16
63
63
64
=head2 amount
65
66
  data_type: 'decimal'
67
  is_nullable: 1
68
  size: [28,6]
69
64
=cut
70
=cut
65
71
66
__PACKAGE__->add_columns(
72
__PACKAGE__->add_columns(
Lines 79-93 __PACKAGE__->add_columns( Link Here
79
  "action",
85
  "action",
80
  { data_type => "varchar", is_nullable => 0, size => 10 },
86
  { data_type => "varchar", is_nullable => 0, size => 10 },
81
  "barcode",
87
  "barcode",
82
  { data_type => "varchar", is_nullable => 0, size => 20 },
88
  { data_type => "varchar", is_nullable => 1, size => 20 },
83
  "cardnumber",
89
  "cardnumber",
84
  { data_type => "varchar", is_nullable => 1, size => 16 },
90
  { data_type => "varchar", is_nullable => 1, size => 16 },
91
  "amount",
92
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
85
);
93
);
86
__PACKAGE__->set_primary_key("operationid");
94
__PACKAGE__->set_primary_key("operationid");
87
95
88
96
89
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
97
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
90
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PFEH3bfCYOG8Q3dOX/IQ5w
98
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ECj0ps97NmZowYLZv++zbA
91
99
92
100
93
# You can replace this text with custom content, and it will be preserved on regeneration
101
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/PluginData.pm (+57 lines)
Line 0 Link Here
1
package Koha::Schema::Result::PluginData;
2
3
# Created by DBIx::Class::Schema::Loader
4
# DO NOT MODIFY THE FIRST PART OF THIS FILE
5
6
use strict;
7
use warnings;
8
9
use base 'DBIx::Class::Core';
10
11
12
=head1 NAME
13
14
Koha::Schema::Result::PluginData
15
16
=cut
17
18
__PACKAGE__->table("plugin_data");
19
20
=head1 ACCESSORS
21
22
=head2 plugin_class
23
24
  data_type: 'varchar'
25
  is_nullable: 0
26
  size: 255
27
28
=head2 plugin_key
29
30
  data_type: 'varchar'
31
  is_nullable: 0
32
  size: 255
33
34
=head2 plugin_value
35
36
  data_type: 'text'
37
  is_nullable: 1
38
39
=cut
40
41
__PACKAGE__->add_columns(
42
  "plugin_class",
43
  { data_type => "varchar", is_nullable => 0, size => 255 },
44
  "plugin_key",
45
  { data_type => "varchar", is_nullable => 0, size => 255 },
46
  "plugin_value",
47
  { data_type => "text", is_nullable => 1 },
48
);
49
__PACKAGE__->set_primary_key("plugin_class", "plugin_key");
50
51
52
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
53
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XC9EptLCJK8QWBHGy1TnPw
54
55
56
# You can replace this text with custom content, and it will be preserved on regeneration
57
1;
(-)a/Koha/Schema/Result/Reserve.pm (-2 / +9 lines)
Lines 126-131 __PACKAGE__->table("reserves"); Link Here
126
  data_type: 'datetime'
126
  data_type: 'datetime'
127
  is_nullable: 1
127
  is_nullable: 1
128
128
129
=head2 maxpickupdate
130
131
  data_type: 'date'
132
  is_nullable: 1
133
129
=cut
134
=cut
130
135
131
__PACKAGE__->add_columns(
136
__PACKAGE__->add_columns(
Lines 181-186 __PACKAGE__->add_columns( Link Here
181
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
186
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
182
  "suspend_until",
187
  "suspend_until",
183
  { data_type => "datetime", is_nullable => 1 },
188
  { data_type => "datetime", is_nullable => 1 },
189
  "maxpickupdate",
190
  { data_type => "date", is_nullable => 1 },
184
);
191
);
185
__PACKAGE__->set_primary_key("reserve_id");
192
__PACKAGE__->set_primary_key("reserve_id");
186
193
Lines 247-254 __PACKAGE__->belongs_to( Link Here
247
);
254
);
248
255
249
256
250
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
257
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
251
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+8kr13IjL7oHVHRXQzTReA
258
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RqJFYCoDl4dMH1cwZilLKA
252
259
253
260
254
# You can replace this text with custom content, and it will be preserved on regeneration
261
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Serial.pm (-9 / +2 lines)
Lines 67-77 __PACKAGE__->table("serial"); Link Here
67
  data_type: 'date'
67
  data_type: 'date'
68
  is_nullable: 1
68
  is_nullable: 1
69
69
70
=head2 itemnumber
71
72
  data_type: 'text'
73
  is_nullable: 1
74
75
=head2 claimdate
70
=head2 claimdate
76
71
77
  data_type: 'date'
72
  data_type: 'date'
Lines 101-108 __PACKAGE__->add_columns( Link Here
101
  { data_type => "text", is_nullable => 1 },
96
  { data_type => "text", is_nullable => 1 },
102
  "publisheddate",
97
  "publisheddate",
103
  { data_type => "date", is_nullable => 1 },
98
  { data_type => "date", is_nullable => 1 },
104
  "itemnumber",
105
  { data_type => "text", is_nullable => 1 },
106
  "claimdate",
99
  "claimdate",
107
  { data_type => "date", is_nullable => 1 },
100
  { data_type => "date", is_nullable => 1 },
108
  "routingnotes",
101
  "routingnotes",
Lines 128-135 __PACKAGE__->has_many( Link Here
128
);
121
);
129
122
130
123
131
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
124
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
132
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PqzibMlED9bg0uOONSBnmg
125
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6kL+JePSa/pT8Fvyrp2xow
133
126
134
127
135
# You can replace this text with custom content, and it will be preserved on regeneration
128
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Subscription.pm (-2 / +32 lines)
Lines 317-322 __PACKAGE__->table("subscription"); Link Here
317
  data_type: 'date'
317
  data_type: 'date'
318
  is_nullable: 1
318
  is_nullable: 1
319
319
320
=head2 closed
321
322
  data_type: 'integer'
323
  default_value: 0
324
  is_nullable: 0
325
326
=head2 reneweddate
327
328
  data_type: 'date'
329
  is_nullable: 1
330
320
=cut
331
=cut
321
332
322
__PACKAGE__->add_columns(
333
__PACKAGE__->add_columns(
Lines 422-432 __PACKAGE__->add_columns( Link Here
422
  { data_type => "integer", default_value => 0, is_nullable => 0 },
433
  { data_type => "integer", default_value => 0, is_nullable => 0 },
423
  "enddate",
434
  "enddate",
424
  { data_type => "date", is_nullable => 1 },
435
  { data_type => "date", is_nullable => 1 },
436
  "closed",
437
  { data_type => "integer", default_value => 0, is_nullable => 0 },
438
  "reneweddate",
439
  { data_type => "date", is_nullable => 1 },
425
);
440
);
426
__PACKAGE__->set_primary_key("subscriptionid");
441
__PACKAGE__->set_primary_key("subscriptionid");
427
442
428
=head1 RELATIONS
443
=head1 RELATIONS
429
444
445
=head2 aqorders
446
447
Type: has_many
448
449
Related object: L<Koha::Schema::Result::Aqorder>
450
451
=cut
452
453
__PACKAGE__->has_many(
454
  "aqorders",
455
  "Koha::Schema::Result::Aqorder",
456
  { "foreign.subscriptionid" => "self.subscriptionid" },
457
  { cascade_copy => 0, cascade_delete => 0 },
458
);
459
430
=head2 subscriptionroutinglists
460
=head2 subscriptionroutinglists
431
461
432
Type: has_many
462
Type: has_many
Lines 443-450 __PACKAGE__->has_many( Link Here
443
);
473
);
444
474
445
475
446
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
476
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
447
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:V94nwW1uwvdVX634/QPe6A
477
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dNaDbtGiAeSsPKEu2vd9sw
448
478
449
479
450
# You can replace this text with custom content, and it will be preserved on regeneration
480
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Suggestion.pm (-4 / +4 lines)
Lines 89-95 __PACKAGE__->table("suggestions"); Link Here
89
89
90
  data_type: 'varchar'
90
  data_type: 'varchar'
91
  is_nullable: 1
91
  is_nullable: 1
92
  size: 80
92
  size: 255
93
93
94
=head2 copyrightdate
94
=head2 copyrightdate
95
95
Lines 226-232 __PACKAGE__->add_columns( Link Here
226
  "author",
226
  "author",
227
  { data_type => "varchar", is_nullable => 1, size => 80 },
227
  { data_type => "varchar", is_nullable => 1, size => 80 },
228
  "title",
228
  "title",
229
  { data_type => "varchar", is_nullable => 1, size => 80 },
229
  { data_type => "varchar", is_nullable => 1, size => 255 },
230
  "copyrightdate",
230
  "copyrightdate",
231
  { data_type => "smallint", is_nullable => 1 },
231
  { data_type => "smallint", is_nullable => 1 },
232
  "publishercode",
232
  "publishercode",
Lines 273-280 __PACKAGE__->add_columns( Link Here
273
__PACKAGE__->set_primary_key("suggestionid");
273
__PACKAGE__->set_primary_key("suggestionid");
274
274
275
275
276
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
276
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
277
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Yseojs5ogx6ZmYsbhE03Gw
277
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FCZjU1DjqLCAcw+dSjpP/w
278
278
279
279
280
# You can replace this text with custom content, and it will be preserved on regeneration
280
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/TagAll.pm (-12 / +12 lines)
Lines 73-111 __PACKAGE__->set_primary_key("tag_id"); Link Here
73
73
74
=head1 RELATIONS
74
=head1 RELATIONS
75
75
76
=head2 biblionumber
76
=head2 borrowernumber
77
77
78
Type: belongs_to
78
Type: belongs_to
79
79
80
Related object: L<Koha::Schema::Result::Biblio>
80
Related object: L<Koha::Schema::Result::Borrower>
81
81
82
=cut
82
=cut
83
83
84
__PACKAGE__->belongs_to(
84
__PACKAGE__->belongs_to(
85
  "biblionumber",
85
  "borrowernumber",
86
  "Koha::Schema::Result::Biblio",
86
  "Koha::Schema::Result::Borrower",
87
  { biblionumber => "biblionumber" },
87
  { borrowernumber => "borrowernumber" },
88
  { on_delete => "CASCADE", on_update => "CASCADE" },
88
  { on_delete => "CASCADE", on_update => "CASCADE" },
89
);
89
);
90
90
91
=head2 borrowernumber
91
=head2 biblionumber
92
92
93
Type: belongs_to
93
Type: belongs_to
94
94
95
Related object: L<Koha::Schema::Result::Borrower>
95
Related object: L<Koha::Schema::Result::Biblio>
96
96
97
=cut
97
=cut
98
98
99
__PACKAGE__->belongs_to(
99
__PACKAGE__->belongs_to(
100
  "borrowernumber",
100
  "biblionumber",
101
  "Koha::Schema::Result::Borrower",
101
  "Koha::Schema::Result::Biblio",
102
  { borrowernumber => "borrowernumber" },
102
  { biblionumber => "biblionumber" },
103
  { on_delete => "CASCADE", on_update => "CASCADE" },
103
  { on_delete => "CASCADE", on_update => "CASCADE" },
104
);
104
);
105
105
106
106
107
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
107
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
108
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xdc0YzmHsXuuuUWfa1aRpg
108
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SunUKfsdQ6hNupUkD2ygzw
109
109
110
110
111
# You can replace this text with custom content, and it will be preserved on regeneration
111
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/TagsIndex.pm (-12 / +12 lines)
Lines 52-90 __PACKAGE__->set_primary_key("term", "biblionumber"); Link Here
52
52
53
=head1 RELATIONS
53
=head1 RELATIONS
54
54
55
=head2 biblionumber
55
=head2 term
56
56
57
Type: belongs_to
57
Type: belongs_to
58
58
59
Related object: L<Koha::Schema::Result::Biblio>
59
Related object: L<Koha::Schema::Result::TagsApproval>
60
60
61
=cut
61
=cut
62
62
63
__PACKAGE__->belongs_to(
63
__PACKAGE__->belongs_to(
64
  "biblionumber",
64
  "term",
65
  "Koha::Schema::Result::Biblio",
65
  "Koha::Schema::Result::TagsApproval",
66
  { biblionumber => "biblionumber" },
66
  { term => "term" },
67
  { on_delete => "CASCADE", on_update => "CASCADE" },
67
  { on_delete => "CASCADE", on_update => "CASCADE" },
68
);
68
);
69
69
70
=head2 term
70
=head2 biblionumber
71
71
72
Type: belongs_to
72
Type: belongs_to
73
73
74
Related object: L<Koha::Schema::Result::TagsApproval>
74
Related object: L<Koha::Schema::Result::Biblio>
75
75
76
=cut
76
=cut
77
77
78
__PACKAGE__->belongs_to(
78
__PACKAGE__->belongs_to(
79
  "term",
79
  "biblionumber",
80
  "Koha::Schema::Result::TagsApproval",
80
  "Koha::Schema::Result::Biblio",
81
  { term => "term" },
81
  { biblionumber => "biblionumber" },
82
  { on_delete => "CASCADE", on_update => "CASCADE" },
82
  { on_delete => "CASCADE", on_update => "CASCADE" },
83
);
83
);
84
84
85
85
86
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
86
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
87
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BTw4FJK85g85U1U0RELiQQ
87
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X0OvXQjDYLVCMgHHWx/kpw
88
88
89
89
90
# You can replace this text with custom content, and it will be preserved on regeneration
90
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Virtualshelfcontent.pm (-18 / +17 lines)
Lines 81-86 __PACKAGE__->add_columns( Link Here
81
81
82
=head1 RELATIONS
82
=head1 RELATIONS
83
83
84
=head2 shelfnumber
85
86
Type: belongs_to
87
88
Related object: L<Koha::Schema::Result::Virtualshelve>
89
90
=cut
91
92
__PACKAGE__->belongs_to(
93
  "shelfnumber",
94
  "Koha::Schema::Result::Virtualshelve",
95
  { shelfnumber => "shelfnumber" },
96
  { on_delete => "CASCADE", on_update => "CASCADE" },
97
);
98
84
=head2 biblionumber
99
=head2 biblionumber
85
100
86
Type: belongs_to
101
Type: belongs_to
Lines 111-134 __PACKAGE__->belongs_to( Link Here
111
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
126
  { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
112
);
127
);
113
128
114
=head2 shelfnumber
115
116
Type: belongs_to
117
118
Related object: L<Koha::Schema::Result::Virtualshelve>
119
120
=cut
121
122
__PACKAGE__->belongs_to(
123
  "shelfnumber",
124
  "Koha::Schema::Result::Virtualshelve",
125
  { shelfnumber => "shelfnumber" },
126
  { on_delete => "CASCADE", on_update => "CASCADE" },
127
);
128
129
129
130
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
130
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-06-18 13:13:57
131
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LytHu3VzJUfDRLgSsRHy1Q
131
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Hno59ucoCC6fZqGi1A2yIA
132
132
133
133
134
# You can replace this text with custom content, and it will be preserved on regeneration
134
# You can replace this text with custom content, and it will be preserved on regeneration
135
- 

Return to bug 8798