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

(-)a/Koha/Schema/Result/Borrower.pm (-32 / +62 lines)
Lines 134-190 __PACKAGE__->table("borrowers"); Link Here
134
  data_type: 'text'
134
  data_type: 'text'
135
  is_nullable: 1
135
  is_nullable: 1
136
136
137
=head2 b_streetnumber
137
=head2 B_streetnumber
138
138
139
  accessor: 'b_streetnumber'
139
  data_type: 'varchar'
140
  data_type: 'varchar'
140
  is_nullable: 1
141
  is_nullable: 1
141
  size: 10
142
  size: 10
142
143
143
=head2 b_streettype
144
=head2 B_streettype
144
145
146
  accessor: 'b_streettype'
145
  data_type: 'varchar'
147
  data_type: 'varchar'
146
  is_nullable: 1
148
  is_nullable: 1
147
  size: 50
149
  size: 50
148
150
149
=head2 b_address
151
=head2 B_address
150
152
153
  accessor: 'b_address'
151
  data_type: 'varchar'
154
  data_type: 'varchar'
152
  is_nullable: 1
155
  is_nullable: 1
153
  size: 100
156
  size: 100
154
157
155
=head2 b_address2
158
=head2 B_address2
156
159
160
  accessor: 'b_address2'
157
  data_type: 'text'
161
  data_type: 'text'
158
  is_nullable: 1
162
  is_nullable: 1
159
163
160
=head2 b_city
164
=head2 B_city
161
165
166
  accessor: 'b_city'
162
  data_type: 'mediumtext'
167
  data_type: 'mediumtext'
163
  is_nullable: 1
168
  is_nullable: 1
164
169
165
=head2 b_state
170
=head2 B_state
166
171
172
  accessor: 'b_state'
167
  data_type: 'text'
173
  data_type: 'text'
168
  is_nullable: 1
174
  is_nullable: 1
169
175
170
=head2 b_zipcode
176
=head2 B_zipcode
171
177
178
  accessor: 'b_zipcode'
172
  data_type: 'varchar'
179
  data_type: 'varchar'
173
  is_nullable: 1
180
  is_nullable: 1
174
  size: 25
181
  size: 25
175
182
176
=head2 b_country
183
=head2 B_country
177
184
185
  accessor: 'b_country'
178
  data_type: 'text'
186
  data_type: 'text'
179
  is_nullable: 1
187
  is_nullable: 1
180
188
181
=head2 b_email
189
=head2 B_email
182
190
191
  accessor: 'b_email'
183
  data_type: 'text'
192
  data_type: 'text'
184
  is_nullable: 1
193
  is_nullable: 1
185
194
186
=head2 b_phone
195
=head2 B_phone
187
196
197
  accessor: 'b_phone'
188
  data_type: 'mediumtext'
198
  data_type: 'mediumtext'
189
  is_nullable: 1
199
  is_nullable: 1
190
200
Lines 442-467 __PACKAGE__->add_columns( Link Here
442
  { data_type => "text", is_nullable => 1 },
452
  { data_type => "text", is_nullable => 1 },
443
  "phonepro",
453
  "phonepro",
444
  { data_type => "text", is_nullable => 1 },
454
  { data_type => "text", is_nullable => 1 },
445
  "b_streetnumber",
455
  "B_streetnumber",
446
  { data_type => "varchar", is_nullable => 1, size => 10 },
456
  {
447
  "b_streettype",
457
    accessor => "b_streetnumber",
448
  { data_type => "varchar", is_nullable => 1, size => 50 },
458
    data_type => "varchar",
449
  "b_address",
459
    is_nullable => 1,
450
  { data_type => "varchar", is_nullable => 1, size => 100 },
460
    size => 10,
451
  "b_address2",
461
  },
452
  { data_type => "text", is_nullable => 1 },
462
  "B_streettype",
453
  "b_city",
463
  {
454
  { data_type => "mediumtext", is_nullable => 1 },
464
    accessor => "b_streettype",
455
  "b_state",
465
    data_type => "varchar",
456
  { data_type => "text", is_nullable => 1 },
466
    is_nullable => 1,
457
  "b_zipcode",
467
    size => 50,
458
  { data_type => "varchar", is_nullable => 1, size => 25 },
468
  },
459
  "b_country",
469
  "B_address",
460
  { data_type => "text", is_nullable => 1 },
470
  {
461
  "b_email",
471
    accessor => "b_address",
462
  { data_type => "text", is_nullable => 1 },
472
    data_type => "varchar",
463
  "b_phone",
473
    is_nullable => 1,
464
  { data_type => "mediumtext", is_nullable => 1 },
474
    size => 100,
475
  },
476
  "B_address2",
477
  { accessor => "b_address2", data_type => "text", is_nullable => 1 },
478
  "B_city",
479
  { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
480
  "B_state",
481
  { accessor => "b_state", data_type => "text", is_nullable => 1 },
482
  "B_zipcode",
483
  {
484
    accessor => "b_zipcode",
485
    data_type => "varchar",
486
    is_nullable => 1,
487
    size => 25,
488
  },
489
  "B_country",
490
  { accessor => "b_country", data_type => "text", is_nullable => 1 },
491
  "B_email",
492
  { accessor => "b_email", data_type => "text", is_nullable => 1 },
493
  "B_phone",
494
  { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
465
  "dateofbirth",
495
  "dateofbirth",
466
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
496
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
467
  "branchcode",
497
  "branchcode",
Lines 1072-1079 Composing rels: L</course_instructors> -> course Link Here
1072
__PACKAGE__->many_to_many("courses", "course_instructors", "course");
1102
__PACKAGE__->many_to_many("courses", "course_instructors", "course");
1073
1103
1074
1104
1075
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
1105
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
1076
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5cfpOojccKCoVRMj+0mWHg
1106
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZzZiKYN4b/LuEARX4rawhA
1077
1107
1078
1108
1079
# You can replace this text with custom content, and it will be preserved on regeneration
1109
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/BorrowerModification.pm (-32 / +62 lines)
Lines 148-204 __PACKAGE__->table("borrower_modifications"); Link Here
148
  data_type: 'text'
148
  data_type: 'text'
149
  is_nullable: 1
149
  is_nullable: 1
150
150
151
=head2 b_streetnumber
151
=head2 B_streetnumber
152
152
153
  accessor: 'b_streetnumber'
153
  data_type: 'varchar'
154
  data_type: 'varchar'
154
  is_nullable: 1
155
  is_nullable: 1
155
  size: 10
156
  size: 10
156
157
157
=head2 b_streettype
158
=head2 B_streettype
158
159
160
  accessor: 'b_streettype'
159
  data_type: 'varchar'
161
  data_type: 'varchar'
160
  is_nullable: 1
162
  is_nullable: 1
161
  size: 50
163
  size: 50
162
164
163
=head2 b_address
165
=head2 B_address
164
166
167
  accessor: 'b_address'
165
  data_type: 'varchar'
168
  data_type: 'varchar'
166
  is_nullable: 1
169
  is_nullable: 1
167
  size: 100
170
  size: 100
168
171
169
=head2 b_address2
172
=head2 B_address2
170
173
174
  accessor: 'b_address2'
171
  data_type: 'text'
175
  data_type: 'text'
172
  is_nullable: 1
176
  is_nullable: 1
173
177
174
=head2 b_city
178
=head2 B_city
175
179
180
  accessor: 'b_city'
176
  data_type: 'mediumtext'
181
  data_type: 'mediumtext'
177
  is_nullable: 1
182
  is_nullable: 1
178
183
179
=head2 b_state
184
=head2 B_state
180
185
186
  accessor: 'b_state'
181
  data_type: 'text'
187
  data_type: 'text'
182
  is_nullable: 1
188
  is_nullable: 1
183
189
184
=head2 b_zipcode
190
=head2 B_zipcode
185
191
192
  accessor: 'b_zipcode'
186
  data_type: 'varchar'
193
  data_type: 'varchar'
187
  is_nullable: 1
194
  is_nullable: 1
188
  size: 25
195
  size: 25
189
196
190
=head2 b_country
197
=head2 B_country
191
198
199
  accessor: 'b_country'
192
  data_type: 'text'
200
  data_type: 'text'
193
  is_nullable: 1
201
  is_nullable: 1
194
202
195
=head2 b_email
203
=head2 B_email
196
204
205
  accessor: 'b_email'
197
  data_type: 'text'
206
  data_type: 'text'
198
  is_nullable: 1
207
  is_nullable: 1
199
208
200
=head2 b_phone
209
=head2 B_phone
201
210
211
  accessor: 'b_phone'
202
  data_type: 'mediumtext'
212
  data_type: 'mediumtext'
203
  is_nullable: 1
213
  is_nullable: 1
204
214
Lines 460-485 __PACKAGE__->add_columns( Link Here
460
  { data_type => "text", is_nullable => 1 },
470
  { data_type => "text", is_nullable => 1 },
461
  "phonepro",
471
  "phonepro",
462
  { data_type => "text", is_nullable => 1 },
472
  { data_type => "text", is_nullable => 1 },
463
  "b_streetnumber",
473
  "B_streetnumber",
464
  { data_type => "varchar", is_nullable => 1, size => 10 },
474
  {
465
  "b_streettype",
475
    accessor => "b_streetnumber",
466
  { data_type => "varchar", is_nullable => 1, size => 50 },
476
    data_type => "varchar",
467
  "b_address",
477
    is_nullable => 1,
468
  { data_type => "varchar", is_nullable => 1, size => 100 },
478
    size => 10,
469
  "b_address2",
479
  },
470
  { data_type => "text", is_nullable => 1 },
480
  "B_streettype",
471
  "b_city",
481
  {
472
  { data_type => "mediumtext", is_nullable => 1 },
482
    accessor => "b_streettype",
473
  "b_state",
483
    data_type => "varchar",
474
  { data_type => "text", is_nullable => 1 },
484
    is_nullable => 1,
475
  "b_zipcode",
485
    size => 50,
476
  { data_type => "varchar", is_nullable => 1, size => 25 },
486
  },
477
  "b_country",
487
  "B_address",
478
  { data_type => "text", is_nullable => 1 },
488
  {
479
  "b_email",
489
    accessor => "b_address",
480
  { data_type => "text", is_nullable => 1 },
490
    data_type => "varchar",
481
  "b_phone",
491
    is_nullable => 1,
482
  { data_type => "mediumtext", is_nullable => 1 },
492
    size => 100,
493
  },
494
  "B_address2",
495
  { accessor => "b_address2", data_type => "text", is_nullable => 1 },
496
  "B_city",
497
  { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
498
  "B_state",
499
  { accessor => "b_state", data_type => "text", is_nullable => 1 },
500
  "B_zipcode",
501
  {
502
    accessor => "b_zipcode",
503
    data_type => "varchar",
504
    is_nullable => 1,
505
    size => 25,
506
  },
507
  "B_country",
508
  { accessor => "b_country", data_type => "text", is_nullable => 1 },
509
  "B_email",
510
  { accessor => "b_email", data_type => "text", is_nullable => 1 },
511
  "B_phone",
512
  { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
483
  "dateofbirth",
513
  "dateofbirth",
484
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
514
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
485
  "branchcode",
515
  "branchcode",
Lines 569-576 __PACKAGE__->add_columns( Link Here
569
__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
599
__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
570
600
571
601
572
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
602
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
573
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:11X5o3u4/EqPRVbQdtAuOA
603
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xUfsaCL/IR4h5U7AKHmFzw
574
604
575
605
576
# You can replace this text with custom content, and it will be preserved on regeneration
606
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/BranchTransferLimit.pm (-13 / +31 lines)
Lines 23-42 __PACKAGE__->table("branch_transfer_limits"); Link Here
23
23
24
=head1 ACCESSORS
24
=head1 ACCESSORS
25
25
26
=head2 limitid
26
=head2 limitId
27
27
28
  accessor: 'limit_id'
28
  data_type: 'integer'
29
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_auto_increment: 1
30
  is_nullable: 0
31
  is_nullable: 0
31
32
32
=head2 tobranch
33
=head2 toBranch
33
34
35
  accessor: 'to_branch'
34
  data_type: 'varchar'
36
  data_type: 'varchar'
35
  is_nullable: 0
37
  is_nullable: 0
36
  size: 10
38
  size: 10
37
39
38
=head2 frombranch
40
=head2 fromBranch
39
41
42
  accessor: 'from_branch'
40
  data_type: 'varchar'
43
  data_type: 'varchar'
41
  is_nullable: 0
44
  is_nullable: 0
42
  size: 10
45
  size: 10
Lines 56-67 __PACKAGE__->table("branch_transfer_limits"); Link Here
56
=cut
59
=cut
57
60
58
__PACKAGE__->add_columns(
61
__PACKAGE__->add_columns(
59
  "limitid",
62
  "limitId",
60
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
63
  {
61
  "tobranch",
64
    accessor          => "limit_id",
62
  { data_type => "varchar", is_nullable => 0, size => 10 },
65
    data_type         => "integer",
63
  "frombranch",
66
    is_auto_increment => 1,
64
  { data_type => "varchar", is_nullable => 0, size => 10 },
67
    is_nullable       => 0,
68
  },
69
  "toBranch",
70
  {
71
    accessor => "to_branch",
72
    data_type => "varchar",
73
    is_nullable => 0,
74
    size => 10,
75
  },
76
  "fromBranch",
77
  {
78
    accessor => "from_branch",
79
    data_type => "varchar",
80
    is_nullable => 0,
81
    size => 10,
82
  },
65
  "itemtype",
83
  "itemtype",
66
  { data_type => "varchar", is_nullable => 1, size => 10 },
84
  { data_type => "varchar", is_nullable => 1, size => 10 },
67
  "ccode",
85
  "ccode",
Lines 72-88 __PACKAGE__->add_columns( Link Here
72
90
73
=over 4
91
=over 4
74
92
75
=item * L</limitid>
93
=item * L</limitId>
76
94
77
=back
95
=back
78
96
79
=cut
97
=cut
80
98
81
__PACKAGE__->set_primary_key("limitid");
99
__PACKAGE__->set_primary_key("limitId");
82
100
83
101
84
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
102
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
85
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HN/uEtGTNOewMCqTQZ1Vew
103
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XPpJwcw5PRa7Fo7PRg32zg
86
104
87
105
88
# You can replace this text with custom content, and it will be preserved on regeneration
106
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Category.pm (-5 / +11 lines)
Lines 102-109 __PACKAGE__->table("categories"); Link Here
102
  is_nullable: 0
102
  is_nullable: 0
103
  size: 1
103
  size: 1
104
104
105
=head2 blockexpiredpatronopacactions
105
=head2 BlockExpiredPatronOpacActions
106
106
107
  accessor: 'block_expired_patron_opac_actions'
107
  data_type: 'tinyint'
108
  data_type: 'tinyint'
108
  default_value: -1
109
  default_value: -1
109
  is_nullable: 0
110
  is_nullable: 0
Lines 146-153 __PACKAGE__->add_columns( Link Here
146
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
147
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
147
  "category_type",
148
  "category_type",
148
  { data_type => "varchar", default_value => "A", is_nullable => 0, size => 1 },
149
  { data_type => "varchar", default_value => "A", is_nullable => 0, size => 1 },
149
  "blockexpiredpatronopacactions",
150
  "BlockExpiredPatronOpacActions",
150
  { data_type => "tinyint", default_value => -1, is_nullable => 0 },
151
  {
152
    accessor      => "block_expired_patron_opac_actions",
153
    data_type     => "tinyint",
154
    default_value => -1,
155
    is_nullable   => 0,
156
  },
151
  "default_privacy",
157
  "default_privacy",
152
  {
158
  {
153
    data_type => "enum",
159
    data_type => "enum",
Lines 247-254 __PACKAGE__->might_have( Link Here
247
);
253
);
248
254
249
255
250
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2014-05-26 01:25:05
256
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
251
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7am0HIdPPQD5sZyKF4FipQ
257
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:T4i7vp1kAZFXy6DiV1dqyw
252
258
253
259
254
# You can replace this text with custom content, and it will be preserved on regeneration
260
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Collection.pm (-16 / +36 lines)
Lines 23-48 __PACKAGE__->table("collections"); Link Here
23
23
24
=head1 ACCESSORS
24
=head1 ACCESSORS
25
25
26
=head2 colid
26
=head2 colId
27
27
28
  accessor: 'col_id'
28
  data_type: 'integer'
29
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_auto_increment: 1
30
  is_nullable: 0
31
  is_nullable: 0
31
32
32
=head2 coltitle
33
=head2 colTitle
33
34
35
  accessor: 'col_title'
34
  data_type: 'varchar'
36
  data_type: 'varchar'
35
  default_value: (empty string)
37
  default_value: (empty string)
36
  is_nullable: 0
38
  is_nullable: 0
37
  size: 100
39
  size: 100
38
40
39
=head2 coldesc
41
=head2 colDesc
40
42
43
  accessor: 'col_desc'
41
  data_type: 'text'
44
  data_type: 'text'
42
  is_nullable: 0
45
  is_nullable: 0
43
46
44
=head2 colbranchcode
47
=head2 colBranchcode
45
48
49
  accessor: 'col_branchcode'
46
  data_type: 'varchar'
50
  data_type: 'varchar'
47
  is_nullable: 1
51
  is_nullable: 1
48
  size: 4
52
  size: 4
Lines 52-82 branchcode for branch where item should be held. Link Here
52
=cut
56
=cut
53
57
54
__PACKAGE__->add_columns(
58
__PACKAGE__->add_columns(
55
  "colid",
59
  "colId",
56
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
60
  {
57
  "coltitle",
61
    accessor          => "col_id",
58
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
62
    data_type         => "integer",
59
  "coldesc",
63
    is_auto_increment => 1,
60
  { data_type => "text", is_nullable => 0 },
64
    is_nullable       => 0,
61
  "colbranchcode",
65
  },
62
  { data_type => "varchar", is_nullable => 1, size => 4 },
66
  "colTitle",
67
  {
68
    accessor => "col_title",
69
    data_type => "varchar",
70
    default_value => "",
71
    is_nullable => 0,
72
    size => 100,
73
  },
74
  "colDesc",
75
  { accessor => "col_desc", data_type => "text", is_nullable => 0 },
76
  "colBranchcode",
77
  {
78
    accessor => "col_branchcode",
79
    data_type => "varchar",
80
    is_nullable => 1,
81
    size => 4,
82
  },
63
);
83
);
64
84
65
=head1 PRIMARY KEY
85
=head1 PRIMARY KEY
66
86
67
=over 4
87
=over 4
68
88
69
=item * L</colid>
89
=item * L</colId>
70
90
71
=back
91
=back
72
92
73
=cut
93
=cut
74
94
75
__PACKAGE__->set_primary_key("colid");
95
__PACKAGE__->set_primary_key("colId");
76
96
77
97
78
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
98
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
79
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KNJIC+I4OdfXBAPM8zOB4A
99
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4QFGZYwbv0aj6eXdn7vO9A
80
100
81
101
82
# You can replace this text with custom content, and it will be preserved on regeneration
102
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/CollectionsTracking.pm (-5 / +11 lines)
Lines 29-36 __PACKAGE__->table("collections_tracking"); Link Here
29
  is_auto_increment: 1
29
  is_auto_increment: 1
30
  is_nullable: 0
30
  is_nullable: 0
31
31
32
=head2 colid
32
=head2 colId
33
33
34
  accessor: 'col_id'
34
  data_type: 'integer'
35
  data_type: 'integer'
35
  default_value: 0
36
  default_value: 0
36
  is_nullable: 0
37
  is_nullable: 0
Lines 50-57 items.itemnumber Link Here
50
__PACKAGE__->add_columns(
51
__PACKAGE__->add_columns(
51
  "collections_tracking_id",
52
  "collections_tracking_id",
52
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
53
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
53
  "colid",
54
  "colId",
54
  { data_type => "integer", default_value => 0, is_nullable => 0 },
55
  {
56
    accessor      => "col_id",
57
    data_type     => "integer",
58
    default_value => 0,
59
    is_nullable   => 0,
60
  },
55
  "itemnumber",
61
  "itemnumber",
56
  { data_type => "integer", default_value => 0, is_nullable => 0 },
62
  { data_type => "integer", default_value => 0, is_nullable => 0 },
57
);
63
);
Lines 69-76 __PACKAGE__->add_columns( Link Here
69
__PACKAGE__->set_primary_key("collections_tracking_id");
75
__PACKAGE__->set_primary_key("collections_tracking_id");
70
76
71
77
72
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
78
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
73
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aV5bgiXNrskXo+q+WLuwPg
79
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:s8ZFSmMJt313bz3XdlhITQ
74
80
75
81
76
# You can replace this text with custom code or comments, and it will be preserved on regeneration
82
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Deletedborrower.pm (-32 / +62 lines)
Lines 134-190 __PACKAGE__->table("deletedborrowers"); Link Here
134
  data_type: 'text'
134
  data_type: 'text'
135
  is_nullable: 1
135
  is_nullable: 1
136
136
137
=head2 b_streetnumber
137
=head2 B_streetnumber
138
138
139
  accessor: 'b_streetnumber'
139
  data_type: 'varchar'
140
  data_type: 'varchar'
140
  is_nullable: 1
141
  is_nullable: 1
141
  size: 10
142
  size: 10
142
143
143
=head2 b_streettype
144
=head2 B_streettype
144
145
146
  accessor: 'b_streettype'
145
  data_type: 'varchar'
147
  data_type: 'varchar'
146
  is_nullable: 1
148
  is_nullable: 1
147
  size: 50
149
  size: 50
148
150
149
=head2 b_address
151
=head2 B_address
150
152
153
  accessor: 'b_address'
151
  data_type: 'varchar'
154
  data_type: 'varchar'
152
  is_nullable: 1
155
  is_nullable: 1
153
  size: 100
156
  size: 100
154
157
155
=head2 b_address2
158
=head2 B_address2
156
159
160
  accessor: 'b_address2'
157
  data_type: 'text'
161
  data_type: 'text'
158
  is_nullable: 1
162
  is_nullable: 1
159
163
160
=head2 b_city
164
=head2 B_city
161
165
166
  accessor: 'b_city'
162
  data_type: 'mediumtext'
167
  data_type: 'mediumtext'
163
  is_nullable: 1
168
  is_nullable: 1
164
169
165
=head2 b_state
170
=head2 B_state
166
171
172
  accessor: 'b_state'
167
  data_type: 'text'
173
  data_type: 'text'
168
  is_nullable: 1
174
  is_nullable: 1
169
175
170
=head2 b_zipcode
176
=head2 B_zipcode
171
177
178
  accessor: 'b_zipcode'
172
  data_type: 'varchar'
179
  data_type: 'varchar'
173
  is_nullable: 1
180
  is_nullable: 1
174
  size: 25
181
  size: 25
175
182
176
=head2 b_country
183
=head2 B_country
177
184
185
  accessor: 'b_country'
178
  data_type: 'text'
186
  data_type: 'text'
179
  is_nullable: 1
187
  is_nullable: 1
180
188
181
=head2 b_email
189
=head2 B_email
182
190
191
  accessor: 'b_email'
183
  data_type: 'text'
192
  data_type: 'text'
184
  is_nullable: 1
193
  is_nullable: 1
185
194
186
=head2 b_phone
195
=head2 B_phone
187
196
197
  accessor: 'b_phone'
188
  data_type: 'mediumtext'
198
  data_type: 'mediumtext'
189
  is_nullable: 1
199
  is_nullable: 1
190
200
Lines 440-465 __PACKAGE__->add_columns( Link Here
440
  { data_type => "text", is_nullable => 1 },
450
  { data_type => "text", is_nullable => 1 },
441
  "phonepro",
451
  "phonepro",
442
  { data_type => "text", is_nullable => 1 },
452
  { data_type => "text", is_nullable => 1 },
443
  "b_streetnumber",
453
  "B_streetnumber",
444
  { data_type => "varchar", is_nullable => 1, size => 10 },
454
  {
445
  "b_streettype",
455
    accessor => "b_streetnumber",
446
  { data_type => "varchar", is_nullable => 1, size => 50 },
456
    data_type => "varchar",
447
  "b_address",
457
    is_nullable => 1,
448
  { data_type => "varchar", is_nullable => 1, size => 100 },
458
    size => 10,
449
  "b_address2",
459
  },
450
  { data_type => "text", is_nullable => 1 },
460
  "B_streettype",
451
  "b_city",
461
  {
452
  { data_type => "mediumtext", is_nullable => 1 },
462
    accessor => "b_streettype",
453
  "b_state",
463
    data_type => "varchar",
454
  { data_type => "text", is_nullable => 1 },
464
    is_nullable => 1,
455
  "b_zipcode",
465
    size => 50,
456
  { data_type => "varchar", is_nullable => 1, size => 25 },
466
  },
457
  "b_country",
467
  "B_address",
458
  { data_type => "text", is_nullable => 1 },
468
  {
459
  "b_email",
469
    accessor => "b_address",
460
  { data_type => "text", is_nullable => 1 },
470
    data_type => "varchar",
461
  "b_phone",
471
    is_nullable => 1,
462
  { data_type => "mediumtext", is_nullable => 1 },
472
    size => 100,
473
  },
474
  "B_address2",
475
  { accessor => "b_address2", data_type => "text", is_nullable => 1 },
476
  "B_city",
477
  { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
478
  "B_state",
479
  { accessor => "b_state", data_type => "text", is_nullable => 1 },
480
  "B_zipcode",
481
  {
482
    accessor => "b_zipcode",
483
    data_type => "varchar",
484
    is_nullable => 1,
485
    size => 25,
486
  },
487
  "B_country",
488
  { accessor => "b_country", data_type => "text", is_nullable => 1 },
489
  "B_email",
490
  { accessor => "b_email", data_type => "text", is_nullable => 1 },
491
  "B_phone",
492
  { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
463
  "dateofbirth",
493
  "dateofbirth",
464
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
494
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
465
  "branchcode",
495
  "branchcode",
Lines 535-542 __PACKAGE__->add_columns( Link Here
535
);
565
);
536
566
537
567
538
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
568
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
539
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yA/UeNpbYIUrX/iWsF0NLw
569
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cRaxMYFjVG7JB7AvsdCweg
540
570
541
571
542
# You can replace this text with custom content, and it will be preserved on regeneration
572
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/OldReserve.pm (-5 / +6 lines)
Lines 117-124 __PACKAGE__->table("old_reserves"); Link Here
117
  datetime_undef_if_invalid: 1
117
  datetime_undef_if_invalid: 1
118
  is_nullable: 1
118
  is_nullable: 1
119
119
120
=head2 lowestpriority
120
=head2 lowestPriority
121
121
122
  accessor: 'lowest_priority'
122
  data_type: 'tinyint'
123
  data_type: 'tinyint'
123
  is_nullable: 0
124
  is_nullable: 0
124
125
Lines 174-181 __PACKAGE__->add_columns( Link Here
174
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
175
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
175
  "expirationdate",
176
  "expirationdate",
176
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
177
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
177
  "lowestpriority",
178
  "lowestPriority",
178
  { data_type => "tinyint", is_nullable => 0 },
179
  { accessor => "lowest_priority", data_type => "tinyint", is_nullable => 0 },
179
  "suspend",
180
  "suspend",
180
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
181
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
181
  "suspend_until",
182
  "suspend_until",
Lines 261-268 __PACKAGE__->belongs_to( Link Here
261
);
262
);
262
263
263
264
264
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
265
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
265
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CMfQmK2sJxQB0FBb0X12ug
266
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bCHe3BGidrVm0LIlC6h+ow
266
267
267
268
268
# You can replace this text with custom content, and it will be preserved on regeneration
269
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Reserve.pm (-5 / +6 lines)
Lines 121-128 __PACKAGE__->table("reserves"); Link Here
121
  datetime_undef_if_invalid: 1
121
  datetime_undef_if_invalid: 1
122
  is_nullable: 1
122
  is_nullable: 1
123
123
124
=head2 lowestpriority
124
=head2 lowestPriority
125
125
126
  accessor: 'lowest_priority'
126
  data_type: 'tinyint'
127
  data_type: 'tinyint'
127
  is_nullable: 0
128
  is_nullable: 0
128
129
Lines 188-195 __PACKAGE__->add_columns( Link Here
188
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
189
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
189
  "expirationdate",
190
  "expirationdate",
190
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
191
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
191
  "lowestpriority",
192
  "lowestPriority",
192
  { data_type => "tinyint", is_nullable => 0 },
193
  { accessor => "lowest_priority", data_type => "tinyint", is_nullable => 0 },
193
  "suspend",
194
  "suspend",
194
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
195
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
195
  "suspend_until",
196
  "suspend_until",
Lines 285-292 __PACKAGE__->belongs_to( Link Here
285
);
286
);
286
287
287
288
288
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
289
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
289
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ig/fobzvZf1OgAHZFtkyyQ
290
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jzng9D1Pns0I2PUF7Wssiw
290
291
291
__PACKAGE__->belongs_to(
292
__PACKAGE__->belongs_to(
292
  "item",
293
  "item",
(-)a/Koha/Schema/Result/Suggestion.pm (-6 / +12 lines)
Lines 74-81 __PACKAGE__->table("suggestions"); Link Here
74
  datetime_undef_if_invalid: 1
74
  datetime_undef_if_invalid: 1
75
  is_nullable: 1
75
  is_nullable: 1
76
76
77
=head2 status
77
=head2 STATUS
78
78
79
  accessor: 'status'
79
  data_type: 'varchar'
80
  data_type: 'varchar'
80
  default_value: (empty string)
81
  default_value: (empty string)
81
  is_nullable: 0
82
  is_nullable: 0
Lines 227-234 __PACKAGE__->add_columns( Link Here
227
  { data_type => "integer", is_nullable => 1 },
228
  { data_type => "integer", is_nullable => 1 },
228
  "rejecteddate",
229
  "rejecteddate",
229
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
230
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
230
  "status",
231
  "STATUS",
231
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
232
  {
233
    accessor => "status",
234
    data_type => "varchar",
235
    default_value => "",
236
    is_nullable => 0,
237
    size => 10,
238
  },
232
  "note",
239
  "note",
233
  { data_type => "mediumtext", is_nullable => 1 },
240
  { data_type => "mediumtext", is_nullable => 1 },
234
  "author",
241
  "author",
Lines 293-300 __PACKAGE__->add_columns( Link Here
293
__PACKAGE__->set_primary_key("suggestionid");
300
__PACKAGE__->set_primary_key("suggestionid");
294
301
295
302
296
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-12-13 01:10:43
303
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
297
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LJoqZVAeoZ0ra2BKxXRQMQ
304
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tMbXZ1id2ls57UMp5jicFA
298
305
299
306
300
# You can replace this text with custom content, and it will be preserved on regeneration
307
# You can replace this text with custom content, and it will be preserved on regeneration
301
- 

Return to bug 12781