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'
82 data_type: 'mediumtext'
92 data_type: 'mediumtext'
103 data_type: 'mediumtext'
108 data_type: 'longtext'
113 data_type: 'mediumtext'
124 data_type: 'longtext'
129 data_type: 'mediumtext'
134 data_type: 'mediumtext'
137 =head2 B_streetnumber
139 accessor: 'b_streetnumber'
146 accessor: 'b_streettype'
153 accessor: 'b_address'
160 accessor: 'b_address2'
161 data_type: 'mediumtext'
167 data_type: 'longtext'
173 data_type: 'mediumtext'
178 accessor: 'b_zipcode'
185 accessor: 'b_country'
186 data_type: 'mediumtext'
192 data_type: 'mediumtext'
198 data_type: 'longtext'
204 datetime_undef_if_invalid: 1
210 default_value: (empty string)
217 default_value: (empty string)
224 datetime_undef_if_invalid: 1
230 datetime_undef_if_invalid: 1
236 datetime_undef_if_invalid: 1
252 datetime_undef_if_invalid: 1
255 =head2 debarredcomment
263 data_type: 'longtext'
266 =head2 contactfirstname
268 data_type: 'mediumtext'
273 data_type: 'mediumtext'
278 data_type: 'longtext'
312 data_type: 'longtext'
333 =head2 altcontactfirstname
339 =head2 altcontactsurname
345 =head2 altcontactaddress1
351 =head2 altcontactaddress2
357 =head2 altcontactaddress3
363 =head2 altcontactstate
365 data_type: 'mediumtext'
368 =head2 altcontactzipcode
374 =head2 altcontactcountry
376 data_type: 'mediumtext'
379 =head2 altcontactphone
385 =head2 smsalertnumber
391 =head2 sms_provider_id
402 =head2 privacy_guarantor_fines
408 =head2 privacy_guarantor_checkouts
414 =head2 checkprevcheckout
417 default_value: 'inherit'
423 data_type: 'timestamp'
424 datetime_undef_if_invalid: 1
425 default_value: current_timestamp
430 data_type: 'datetime'
431 datetime_undef_if_invalid: 1
437 default_value: 'default'
441 =head2 login_attempts
447 =head2 overdrive_auth_token
449 data_type: 'mediumtext'
460 __PACKAGE__
->add_columns(
462 { data_type
=> "integer", default_value
=> 0, is_nullable
=> 0 },
464 { data_type
=> "varchar", is_nullable
=> 1, size
=> 32 },
466 { data_type
=> "longtext", is_nullable
=> 1 },
468 { data_type
=> "mediumtext", is_nullable
=> 1 },
470 { data_type
=> "longtext", is_nullable
=> 1 },
472 { data_type
=> "longtext", is_nullable
=> 1 },
474 { data_type
=> "mediumtext", is_nullable
=> 1 },
476 { data_type
=> "varchar", is_nullable
=> 1, size
=> 10 },
478 { data_type
=> "varchar", is_nullable
=> 1, size
=> 50 },
480 { data_type
=> "longtext", is_nullable
=> 1 },
482 { data_type
=> "mediumtext", is_nullable
=> 1 },
484 { data_type
=> "longtext", is_nullable
=> 1 },
486 { data_type
=> "mediumtext", is_nullable
=> 1 },
488 { data_type
=> "varchar", is_nullable
=> 1, size
=> 25 },
490 { data_type
=> "mediumtext", is_nullable
=> 1 },
492 { data_type
=> "longtext", is_nullable
=> 1 },
494 { data_type
=> "mediumtext", is_nullable
=> 1 },
496 { data_type
=> "varchar", is_nullable
=> 1, size
=> 50 },
498 { data_type
=> "longtext", is_nullable
=> 1 },
500 { data_type
=> "mediumtext", is_nullable
=> 1 },
502 { data_type
=> "mediumtext", is_nullable
=> 1 },
505 accessor
=> "b_streetnumber",
506 data_type
=> "varchar",
512 accessor
=> "b_streettype",
513 data_type
=> "varchar",
519 accessor
=> "b_address",
520 data_type
=> "varchar",
525 { accessor
=> "b_address2", data_type
=> "mediumtext", is_nullable
=> 1 },
527 { accessor
=> "b_city", data_type
=> "longtext", is_nullable
=> 1 },
529 { accessor
=> "b_state", data_type
=> "mediumtext", is_nullable
=> 1 },
532 accessor
=> "b_zipcode",
533 data_type
=> "varchar",
538 { accessor
=> "b_country", data_type
=> "mediumtext", is_nullable
=> 1 },
540 { accessor
=> "b_email", data_type
=> "mediumtext", is_nullable
=> 1 },
542 { accessor
=> "b_phone", data_type
=> "longtext", is_nullable
=> 1 },
544 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
546 { data_type
=> "varchar", default_value
=> "", is_nullable
=> 0, size
=> 10 },
548 { data_type
=> "varchar", default_value
=> "", is_nullable
=> 0, size
=> 10 },
550 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
552 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
554 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
556 { data_type
=> "tinyint", is_nullable
=> 1 },
558 { data_type
=> "tinyint", is_nullable
=> 1 },
560 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
562 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
564 { data_type
=> "longtext", is_nullable
=> 1 },
566 { data_type
=> "mediumtext", is_nullable
=> 1 },
568 { data_type
=> "mediumtext", is_nullable
=> 1 },
570 { data_type
=> "longtext", is_nullable
=> 1 },
572 { data_type
=> "varchar", is_nullable
=> 1, size
=> 100 },
574 { data_type
=> "varchar", is_nullable
=> 1, size
=> 1 },
576 { data_type
=> "varchar", is_nullable
=> 1, size
=> 60 },
578 { data_type
=> "integer", is_nullable
=> 1 },
580 { data_type
=> "varchar", is_nullable
=> 1, size
=> 75 },
582 { data_type
=> "longtext", is_nullable
=> 1 },
584 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
586 { data_type
=> "varchar", is_nullable
=> 1, size
=> 80 },
588 { data_type
=> "varchar", is_nullable
=> 1, size
=> 80 },
589 "altcontactfirstname",
590 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
592 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
593 "altcontactaddress1",
594 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
595 "altcontactaddress2",
596 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
597 "altcontactaddress3",
598 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
600 { data_type
=> "mediumtext", is_nullable
=> 1 },
602 { data_type
=> "varchar", is_nullable
=> 1, size
=> 50 },
604 { data_type
=> "mediumtext", is_nullable
=> 1 },
606 { data_type
=> "varchar", is_nullable
=> 1, size
=> 50 },
608 { data_type
=> "varchar", is_nullable
=> 1, size
=> 50 },
610 { data_type
=> "integer", is_nullable
=> 1 },
612 { data_type
=> "integer", default_value
=> 1, is_nullable
=> 0 },
613 "privacy_guarantor_fines",
614 { data_type
=> "tinyint", default_value
=> 0, is_nullable
=> 0 },
615 "privacy_guarantor_checkouts",
616 { data_type
=> "tinyint", default_value
=> 0, is_nullable
=> 0 },
619 data_type
=> "varchar",
620 default_value
=> "inherit",
626 data_type
=> "timestamp",
627 datetime_undef_if_invalid
=> 1,
628 default_value
=> \"current_timestamp
",
633 data_type => "datetime
",
634 datetime_undef_if_invalid => 1,
639 data_type => "varchar
",
640 default_value => "default",
645 { data_type => "integer
", default_value => 0, is_nullable => 1 },
646 "overdrive_auth_token
",
647 { data_type => "mediumtext
", is_nullable => 1 },
649 { data_type => "tinyint
", default_value => 0, is_nullable => 0 },
653 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-05-22 04:33:29
654 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zK1jC6Wawwj8B2ch9KFByw
657 # You can replace this text with custom code or comments, and it will be preserved on regeneration