|
Lines 89-95
__PACKAGE__->table("deletedborrowers");
Link Here
|
| 89 |
|
89 |
|
| 90 |
=head2 state |
90 |
=head2 state |
| 91 |
|
91 |
|
| 92 |
data_type: 'mediumtext' |
92 |
data_type: 'longtext' |
| 93 |
is_nullable: 1 |
93 |
is_nullable: 1 |
| 94 |
|
94 |
|
| 95 |
=head2 zipcode |
95 |
=head2 zipcode |
|
Lines 170-176
__PACKAGE__->table("deletedborrowers");
Link Here
|
| 170 |
=head2 B_state |
170 |
=head2 B_state |
| 171 |
|
171 |
|
| 172 |
accessor: 'b_state' |
172 |
accessor: 'b_state' |
| 173 |
data_type: 'mediumtext' |
173 |
data_type: 'longtext' |
| 174 |
is_nullable: 1 |
174 |
is_nullable: 1 |
| 175 |
|
175 |
|
| 176 |
=head2 B_zipcode |
176 |
=head2 B_zipcode |
|
Lines 214-221
__PACKAGE__->table("deletedborrowers");
Link Here
|
| 214 |
=head2 categorycode |
214 |
=head2 categorycode |
| 215 |
|
215 |
|
| 216 |
data_type: 'varchar' |
216 |
data_type: 'varchar' |
| 217 |
default_value: (empty string) |
217 |
is_nullable: 1 |
| 218 |
is_nullable: 0 |
|
|
| 219 |
size: 10 |
218 |
size: 10 |
| 220 |
|
219 |
|
| 221 |
=head2 dateenrolled |
220 |
=head2 dateenrolled |
|
Lines 289-294
__PACKAGE__->table("deletedborrowers");
Link Here
|
| 289 |
is_nullable: 1 |
288 |
is_nullable: 1 |
| 290 |
size: 100 |
289 |
size: 100 |
| 291 |
|
290 |
|
|
|
291 |
=head2 ethnicity |
| 292 |
|
| 293 |
data_type: 'varchar' |
| 294 |
is_nullable: 1 |
| 295 |
size: 50 |
| 296 |
|
| 297 |
=head2 ethnotes |
| 298 |
|
| 299 |
data_type: 'varchar' |
| 300 |
is_nullable: 1 |
| 301 |
size: 255 |
| 302 |
|
| 292 |
=head2 sex |
303 |
=head2 sex |
| 293 |
|
304 |
|
| 294 |
data_type: 'varchar' |
305 |
data_type: 'varchar' |
|
Lines 367-373
__PACKAGE__->table("deletedborrowers");
Link Here
|
| 367 |
|
378 |
|
| 368 |
=head2 altcontactstate |
379 |
=head2 altcontactstate |
| 369 |
|
380 |
|
| 370 |
data_type: 'mediumtext' |
381 |
data_type: 'longtext' |
| 371 |
is_nullable: 1 |
382 |
is_nullable: 1 |
| 372 |
|
383 |
|
| 373 |
=head2 altcontactzipcode |
384 |
=head2 altcontactzipcode |
|
Lines 401-408
__PACKAGE__->table("deletedborrowers");
Link Here
|
| 401 |
=head2 privacy |
412 |
=head2 privacy |
| 402 |
|
413 |
|
| 403 |
data_type: 'integer' |
414 |
data_type: 'integer' |
| 404 |
default_value: 1 |
415 |
is_nullable: 1 |
| 405 |
is_nullable: 0 |
|
|
| 406 |
|
416 |
|
| 407 |
=head2 privacy_guarantor_checkouts |
417 |
=head2 privacy_guarantor_checkouts |
| 408 |
|
418 |
|
|
Lines 422-428
__PACKAGE__->table("deletedborrowers");
Link Here
|
| 422 |
data_type: 'timestamp' |
432 |
data_type: 'timestamp' |
| 423 |
datetime_undef_if_invalid: 1 |
433 |
datetime_undef_if_invalid: 1 |
| 424 |
default_value: current_timestamp |
434 |
default_value: current_timestamp |
| 425 |
is_nullable: 0 |
435 |
is_nullable: 1 |
| 426 |
|
436 |
|
| 427 |
=head2 lastseen |
437 |
=head2 lastseen |
| 428 |
|
438 |
|
|
Lines 440-446
__PACKAGE__->table("deletedborrowers");
Link Here
|
| 440 |
=head2 login_attempts |
450 |
=head2 login_attempts |
| 441 |
|
451 |
|
| 442 |
data_type: 'integer' |
452 |
data_type: 'integer' |
| 443 |
default_value: 0 |
|
|
| 444 |
is_nullable: 1 |
453 |
is_nullable: 1 |
| 445 |
|
454 |
|
| 446 |
=head2 overdrive_auth_token |
455 |
=head2 overdrive_auth_token |
|
Lines 476-482
__PACKAGE__->add_columns(
Link Here
|
| 476 |
"city", |
485 |
"city", |
| 477 |
{ data_type => "longtext", is_nullable => 1 }, |
486 |
{ data_type => "longtext", is_nullable => 1 }, |
| 478 |
"state", |
487 |
"state", |
| 479 |
{ data_type => "mediumtext", is_nullable => 1 }, |
488 |
{ data_type => "longtext", is_nullable => 1 }, |
| 480 |
"zipcode", |
489 |
"zipcode", |
| 481 |
{ data_type => "varchar", is_nullable => 1, size => 25 }, |
490 |
{ data_type => "varchar", is_nullable => 1, size => 25 }, |
| 482 |
"country", |
491 |
"country", |
|
Lines 519-525
__PACKAGE__->add_columns(
Link Here
|
| 519 |
"B_city", |
528 |
"B_city", |
| 520 |
{ accessor => "b_city", data_type => "longtext", is_nullable => 1 }, |
529 |
{ accessor => "b_city", data_type => "longtext", is_nullable => 1 }, |
| 521 |
"B_state", |
530 |
"B_state", |
| 522 |
{ accessor => "b_state", data_type => "mediumtext", is_nullable => 1 }, |
531 |
{ accessor => "b_state", data_type => "longtext", is_nullable => 1 }, |
| 523 |
"B_zipcode", |
532 |
"B_zipcode", |
| 524 |
{ |
533 |
{ |
| 525 |
accessor => "b_zipcode", |
534 |
accessor => "b_zipcode", |
|
Lines 538-544
__PACKAGE__->add_columns(
Link Here
|
| 538 |
"branchcode", |
547 |
"branchcode", |
| 539 |
{ data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, |
548 |
{ data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, |
| 540 |
"categorycode", |
549 |
"categorycode", |
| 541 |
{ data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, |
550 |
{ data_type => "varchar", is_nullable => 1, size => 10 }, |
| 542 |
"dateenrolled", |
551 |
"dateenrolled", |
| 543 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
552 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
| 544 |
"dateexpiry", |
553 |
"dateexpiry", |
|
Lines 565-570
__PACKAGE__->add_columns(
Link Here
|
| 565 |
{ data_type => "longtext", is_nullable => 1 }, |
574 |
{ data_type => "longtext", is_nullable => 1 }, |
| 566 |
"relationship", |
575 |
"relationship", |
| 567 |
{ data_type => "varchar", is_nullable => 1, size => 100 }, |
576 |
{ data_type => "varchar", is_nullable => 1, size => 100 }, |
|
|
577 |
"ethnicity", |
| 578 |
{ data_type => "varchar", is_nullable => 1, size => 50 }, |
| 579 |
"ethnotes", |
| 580 |
{ data_type => "varchar", is_nullable => 1, size => 255 }, |
| 568 |
"sex", |
581 |
"sex", |
| 569 |
{ data_type => "varchar", is_nullable => 1, size => 1 }, |
582 |
{ data_type => "varchar", is_nullable => 1, size => 1 }, |
| 570 |
"password", |
583 |
"password", |
|
Lines 592-598
__PACKAGE__->add_columns(
Link Here
|
| 592 |
"altcontactaddress3", |
605 |
"altcontactaddress3", |
| 593 |
{ data_type => "varchar", is_nullable => 1, size => 255 }, |
606 |
{ data_type => "varchar", is_nullable => 1, size => 255 }, |
| 594 |
"altcontactstate", |
607 |
"altcontactstate", |
| 595 |
{ data_type => "mediumtext", is_nullable => 1 }, |
608 |
{ data_type => "longtext", is_nullable => 1 }, |
| 596 |
"altcontactzipcode", |
609 |
"altcontactzipcode", |
| 597 |
{ data_type => "varchar", is_nullable => 1, size => 50 }, |
610 |
{ data_type => "varchar", is_nullable => 1, size => 50 }, |
| 598 |
"altcontactcountry", |
611 |
"altcontactcountry", |
|
Lines 604-610
__PACKAGE__->add_columns(
Link Here
|
| 604 |
"sms_provider_id", |
617 |
"sms_provider_id", |
| 605 |
{ data_type => "integer", is_nullable => 1 }, |
618 |
{ data_type => "integer", is_nullable => 1 }, |
| 606 |
"privacy", |
619 |
"privacy", |
| 607 |
{ data_type => "integer", default_value => 1, is_nullable => 0 }, |
620 |
{ data_type => "integer", is_nullable => 1 }, |
| 608 |
"privacy_guarantor_checkouts", |
621 |
"privacy_guarantor_checkouts", |
| 609 |
{ data_type => "tinyint", default_value => 0, is_nullable => 0 }, |
622 |
{ data_type => "tinyint", default_value => 0, is_nullable => 0 }, |
| 610 |
"checkprevcheckout", |
623 |
"checkprevcheckout", |
|
Lines 619-625
__PACKAGE__->add_columns(
Link Here
|
| 619 |
data_type => "timestamp", |
632 |
data_type => "timestamp", |
| 620 |
datetime_undef_if_invalid => 1, |
633 |
datetime_undef_if_invalid => 1, |
| 621 |
default_value => \"current_timestamp", |
634 |
default_value => \"current_timestamp", |
| 622 |
is_nullable => 0, |
635 |
is_nullable => 1, |
| 623 |
}, |
636 |
}, |
| 624 |
"lastseen", |
637 |
"lastseen", |
| 625 |
{ |
638 |
{ |
|
Lines 635-648
__PACKAGE__->add_columns(
Link Here
|
| 635 |
size => 25, |
648 |
size => 25, |
| 636 |
}, |
649 |
}, |
| 637 |
"login_attempts", |
650 |
"login_attempts", |
| 638 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
651 |
{ data_type => "integer", is_nullable => 1 }, |
| 639 |
"overdrive_auth_token", |
652 |
"overdrive_auth_token", |
| 640 |
{ data_type => "mediumtext", is_nullable => 1 }, |
653 |
{ data_type => "mediumtext", is_nullable => 1 }, |
| 641 |
); |
654 |
); |
| 642 |
|
655 |
|
| 643 |
|
656 |
|
| 644 |
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 |
657 |
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51 |
| 645 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DNkNHNcv0lkMH6/seu89hg |
658 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BEq3IZzmy8La8NnwPCbV1Q |
| 646 |
|
659 |
|
| 647 |
|
660 |
|
| 648 |
# You can replace this text with custom code or comments, and it will be preserved on regeneration |
661 |
# You can replace this text with custom code or comments, and it will be preserved on regeneration |