2 package Koha::Schema::Result::Deletedborrower;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Deletedborrower
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<deletedborrowers>
22 __PACKAGE__->table("deletedborrowers");
45 data_type: 'mediumtext'
60 data_type: 'mediumtext'
80 data_type: 'mediumtext'
90 data_type: 'mediumtext'
100 data_type: 'mediumtext'
105 data_type: 'longtext'
110 data_type: 'mediumtext'
115 data_type: 'tinytext'
120 data_type: 'longtext'
125 data_type: 'mediumtext'
130 data_type: 'mediumtext'
133 =head2 B_streetnumber
135 accessor: 'b_streetnumber'
136 data_type: 'tinytext'
141 accessor: 'b_streettype'
142 data_type: 'tinytext'
147 accessor: 'b_address'
148 data_type: 'mediumtext'
153 accessor: 'b_address2'
154 data_type: 'mediumtext'
160 data_type: 'longtext'
166 data_type: 'mediumtext'
171 accessor: 'b_zipcode'
172 data_type: 'tinytext'
177 accessor: 'b_country'
178 data_type: 'mediumtext'
184 data_type: 'mediumtext'
190 data_type: 'longtext'
196 datetime_undef_if_invalid: 1
202 default_value: (empty string)
209 default_value: (empty string)
216 datetime_undef_if_invalid: 1
222 datetime_undef_if_invalid: 1
228 datetime_undef_if_invalid: 1
244 datetime_undef_if_invalid: 1
247 =head2 debarredcomment
255 data_type: 'longtext'
258 =head2 contactfirstname
260 data_type: 'mediumtext'
265 data_type: 'mediumtext'
270 data_type: 'longtext'
304 data_type: 'longtext'
325 =head2 altcontactfirstname
327 data_type: 'mediumtext'
330 =head2 altcontactsurname
332 data_type: 'mediumtext'
335 =head2 altcontactaddress1
337 data_type: 'mediumtext'
340 =head2 altcontactaddress2
342 data_type: 'mediumtext'
345 =head2 altcontactaddress3
347 data_type: 'mediumtext'
350 =head2 altcontactstate
352 data_type: 'mediumtext'
355 =head2 altcontactzipcode
357 data_type: 'mediumtext'
360 =head2 altcontactcountry
362 data_type: 'mediumtext'
365 =head2 altcontactphone
367 data_type: 'mediumtext'
370 =head2 smsalertnumber
376 =head2 sms_provider_id
387 =head2 privacy_guarantor_fines
393 =head2 privacy_guarantor_checkouts
399 =head2 checkprevcheckout
402 default_value: 'inherit'
408 data_type: 'timestamp'
409 datetime_undef_if_invalid: 1
410 default_value: current_timestamp
415 data_type: 'datetime'
416 datetime_undef_if_invalid: 1
422 default_value: 'default'
426 =head2 login_attempts
432 =head2 overdrive_auth_token
434 data_type: 'mediumtext'
443 =head2 autorenew_checkouts
451 __PACKAGE__->add_columns(
453 { data_type => "integer", default_value => 0, is_nullable => 0 },
455 { data_type => "varchar", is_nullable => 1, size => 32 },
457 { data_type => "longtext", is_nullable => 1 },
459 { data_type => "mediumtext", is_nullable => 1 },
461 { data_type => "longtext", is_nullable => 1 },
463 { data_type => "longtext", is_nullable => 1 },
465 { data_type => "mediumtext", is_nullable => 1 },
467 { data_type => "tinytext", is_nullable => 1 },
469 { data_type => "tinytext", is_nullable => 1 },
471 { data_type => "longtext", is_nullable => 1 },
473 { data_type => "mediumtext", is_nullable => 1 },
475 { data_type => "longtext", is_nullable => 1 },
477 { data_type => "mediumtext", is_nullable => 1 },
479 { data_type => "tinytext", is_nullable => 1 },
481 { data_type => "mediumtext", is_nullable => 1 },
483 { data_type => "longtext", is_nullable => 1 },
485 { data_type => "mediumtext", is_nullable => 1 },
487 { data_type => "tinytext", is_nullable => 1 },
489 { data_type => "longtext", is_nullable => 1 },
491 { data_type => "mediumtext", is_nullable => 1 },
493 { data_type => "mediumtext", is_nullable => 1 },
495 { accessor => "b_streetnumber", data_type => "tinytext", is_nullable => 1 },
497 { accessor => "b_streettype", data_type => "tinytext", is_nullable => 1 },
499 { accessor => "b_address", data_type => "mediumtext", is_nullable => 1 },
501 { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 },
503 { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
505 { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
507 { accessor => "b_zipcode", data_type => "tinytext", is_nullable => 1 },
509 { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 },
511 { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 },
513 { accessor => "b_phone", data_type => "longtext", is_nullable => 1 },
515 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
517 { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
519 { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
521 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
523 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
525 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
527 { data_type => "tinyint", is_nullable => 1 },
529 { data_type => "tinyint", is_nullable => 1 },
531 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
533 { data_type => "varchar", is_nullable => 1, size => 255 },
535 { data_type => "longtext", is_nullable => 1 },
537 { data_type => "mediumtext", is_nullable => 1 },
539 { data_type => "mediumtext", is_nullable => 1 },
541 { data_type => "longtext", is_nullable => 1 },
543 { data_type => "varchar", is_nullable => 1, size => 100 },
545 { data_type => "varchar", is_nullable => 1, size => 1 },
547 { data_type => "varchar", is_nullable => 1, size => 60 },
549 { data_type => "integer", is_nullable => 1 },
551 { data_type => "varchar", is_nullable => 1, size => 75 },
553 { data_type => "longtext", is_nullable => 1 },
555 { data_type => "varchar", is_nullable => 1, size => 255 },
557 { data_type => "varchar", is_nullable => 1, size => 80 },
559 { data_type => "varchar", is_nullable => 1, size => 80 },
560 "altcontactfirstname",
561 { data_type => "mediumtext", is_nullable => 1 },
563 { data_type => "mediumtext", is_nullable => 1 },
564 "altcontactaddress1",
565 { data_type => "mediumtext", is_nullable => 1 },
566 "altcontactaddress2",
567 { data_type => "mediumtext", is_nullable => 1 },
568 "altcontactaddress3",
569 { data_type => "mediumtext", is_nullable => 1 },
571 { data_type => "mediumtext", is_nullable => 1 },
573 { data_type => "mediumtext", is_nullable => 1 },
575 { data_type => "mediumtext", is_nullable => 1 },
577 { data_type => "mediumtext", is_nullable => 1 },
579 { data_type => "varchar", is_nullable => 1, size => 50 },
581 { data_type => "integer", is_nullable => 1 },
583 { data_type => "integer", default_value => 1, is_nullable => 0 },
584 "privacy_guarantor_fines",
585 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
586 "privacy_guarantor_checkouts",
587 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
590 data_type => "varchar",
591 default_value => "inherit",
597 data_type => "timestamp",
598 datetime_undef_if_invalid => 1,
599 default_value => \"current_timestamp",
604 data_type => "datetime",
605 datetime_undef_if_invalid => 1,
610 data_type => "varchar",
611 default_value => "default",
616 { data_type => "integer", default_value => 0, is_nullable => 0 },
617 "overdrive_auth_token",
618 { data_type => "mediumtext", is_nullable => 1 },
620 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
621 "autorenew_checkouts",
622 { data_type => "tinyint", default_value => 1, is_nullable => 0 },
626 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-07-20 10:54:51
627 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4xYIkJhZWN+O/s8cMYbJmw
629 __PACKAGE__->add_columns(
630 '+anonymized' => { is_boolean => 1 },
631 '+lost' => { is_boolean => 1 },
632 '+gonenoaddress' => { is_boolean => 1 },
633 '+privacy_guarantor_fines' => { is_boolean => 1 },
634 '+autorenew_checkouts' => { is_boolean => 1 }
637 sub koha_objects_class {
638 'Koha::Old::Patrons';
640 sub koha_object_class {