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; |