From 30aea44831874050e69cb19911d4310d0304aa81 Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Thu, 16 Jul 2020 16:17:14 +1200 Subject: [PATCH] Bug 24986: DBIC Signed-off-by: Aleisha Amohia --- Koha/Schema/Result/Borrower.pm | 99 +++++++++------------------ Koha/Schema/Result/Deletedborrower.pm | 99 +++++++++------------------ 2 files changed, 64 insertions(+), 134 deletions(-) diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm index f7224cc299..43647b0e8c 100644 --- a/Koha/Schema/Result/Borrower.pm +++ b/Koha/Schema/Result/Borrower.pm @@ -62,15 +62,13 @@ __PACKAGE__->table("borrowers"); =head2 streetnumber - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 10 =head2 streettype - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 50 =head2 address @@ -94,9 +92,8 @@ __PACKAGE__->table("borrowers"); =head2 zipcode - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 25 =head2 country @@ -115,9 +112,8 @@ __PACKAGE__->table("borrowers"); =head2 mobile - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 50 =head2 fax @@ -137,23 +133,20 @@ __PACKAGE__->table("borrowers"); =head2 B_streetnumber accessor: 'b_streetnumber' - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 10 =head2 B_streettype accessor: 'b_streettype' - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 50 =head2 B_address accessor: 'b_address' - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 100 =head2 B_address2 @@ -176,9 +169,8 @@ __PACKAGE__->table("borrowers"); =head2 B_zipcode accessor: 'b_zipcode' - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 25 =head2 B_country @@ -334,33 +326,28 @@ __PACKAGE__->table("borrowers"); =head2 altcontactfirstname - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 255 =head2 altcontactsurname - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 255 =head2 altcontactaddress1 - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 255 =head2 altcontactaddress2 - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 255 =head2 altcontactaddress3 - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 255 =head2 altcontactstate @@ -369,9 +356,8 @@ __PACKAGE__->table("borrowers"); =head2 altcontactzipcode - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 50 =head2 altcontactcountry @@ -380,9 +366,8 @@ __PACKAGE__->table("borrowers"); =head2 altcontactphone - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 50 =head2 smsalertnumber @@ -476,9 +461,9 @@ __PACKAGE__->add_columns( "initials", { data_type => "mediumtext", is_nullable => 1 }, "streetnumber", - { data_type => "varchar", is_nullable => 1, size => 10 }, + { data_type => "tinytext", is_nullable => 1 }, "streettype", - { data_type => "varchar", is_nullable => 1, size => 50 }, + { data_type => "tinytext", is_nullable => 1 }, "address", { data_type => "longtext", is_nullable => 1 }, "address2", @@ -488,7 +473,7 @@ __PACKAGE__->add_columns( "state", { data_type => "mediumtext", is_nullable => 1 }, "zipcode", - { data_type => "varchar", is_nullable => 1, size => 25 }, + { data_type => "tinytext", is_nullable => 1 }, "country", { data_type => "mediumtext", is_nullable => 1 }, "email", @@ -496,7 +481,7 @@ __PACKAGE__->add_columns( "phone", { data_type => "mediumtext", is_nullable => 1 }, "mobile", - { data_type => "varchar", is_nullable => 1, size => 50 }, + { data_type => "tinytext", is_nullable => 1 }, "fax", { data_type => "longtext", is_nullable => 1 }, "emailpro", @@ -504,26 +489,11 @@ __PACKAGE__->add_columns( "phonepro", { data_type => "mediumtext", is_nullable => 1 }, "B_streetnumber", - { - accessor => "b_streetnumber", - data_type => "varchar", - is_nullable => 1, - size => 10, - }, + { accessor => "b_streetnumber", data_type => "tinytext", is_nullable => 1 }, "B_streettype", - { - accessor => "b_streettype", - data_type => "varchar", - is_nullable => 1, - size => 50, - }, + { accessor => "b_streettype", data_type => "tinytext", is_nullable => 1 }, "B_address", - { - accessor => "b_address", - data_type => "varchar", - is_nullable => 1, - size => 100, - }, + { accessor => "b_address", data_type => "mediumtext", is_nullable => 1 }, "B_address2", { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 }, "B_city", @@ -531,12 +501,7 @@ __PACKAGE__->add_columns( "B_state", { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 }, "B_zipcode", - { - accessor => "b_zipcode", - data_type => "varchar", - is_nullable => 1, - size => 25, - }, + { accessor => "b_zipcode", data_type => "tinytext", is_nullable => 1 }, "B_country", { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 }, "B_email", @@ -602,23 +567,23 @@ __PACKAGE__->add_columns( "sort2", { data_type => "varchar", is_nullable => 1, size => 80 }, "altcontactfirstname", - { data_type => "varchar", is_nullable => 1, size => 255 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactsurname", - { data_type => "varchar", is_nullable => 1, size => 255 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactaddress1", - { data_type => "varchar", is_nullable => 1, size => 255 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactaddress2", - { data_type => "varchar", is_nullable => 1, size => 255 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactaddress3", - { data_type => "varchar", is_nullable => 1, size => 255 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactstate", { data_type => "mediumtext", is_nullable => 1 }, "altcontactzipcode", - { data_type => "varchar", is_nullable => 1, size => 50 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactcountry", { data_type => "mediumtext", is_nullable => 1 }, "altcontactphone", - { data_type => "varchar", is_nullable => 1, size => 50 }, + { data_type => "mediumtext", is_nullable => 1 }, "smsalertnumber", { data_type => "varchar", is_nullable => 1, size => 50 }, "sms_provider_id", @@ -1635,8 +1600,8 @@ Composing rels: L -> ordernumber __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-10 14:31:00 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GjJLIOViIFRm185Yjl9vYA +# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-07-16 16:16:23 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kM4ka0DO50m/qLc8kT6sPQ __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm index df8877ff72..3e07830270 100644 --- a/Koha/Schema/Result/Deletedborrower.pm +++ b/Koha/Schema/Result/Deletedborrower.pm @@ -62,15 +62,13 @@ __PACKAGE__->table("deletedborrowers"); =head2 streetnumber - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 10 =head2 streettype - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 50 =head2 address @@ -94,9 +92,8 @@ __PACKAGE__->table("deletedborrowers"); =head2 zipcode - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 25 =head2 country @@ -115,9 +112,8 @@ __PACKAGE__->table("deletedborrowers"); =head2 mobile - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 50 =head2 fax @@ -137,23 +133,20 @@ __PACKAGE__->table("deletedborrowers"); =head2 B_streetnumber accessor: 'b_streetnumber' - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 10 =head2 B_streettype accessor: 'b_streettype' - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 50 =head2 B_address accessor: 'b_address' - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 100 =head2 B_address2 @@ -176,9 +169,8 @@ __PACKAGE__->table("deletedborrowers"); =head2 B_zipcode accessor: 'b_zipcode' - data_type: 'varchar' + data_type: 'tinytext' is_nullable: 1 - size: 25 =head2 B_country @@ -332,33 +324,28 @@ __PACKAGE__->table("deletedborrowers"); =head2 altcontactfirstname - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 255 =head2 altcontactsurname - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 255 =head2 altcontactaddress1 - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 255 =head2 altcontactaddress2 - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 255 =head2 altcontactaddress3 - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 255 =head2 altcontactstate @@ -367,9 +354,8 @@ __PACKAGE__->table("deletedborrowers"); =head2 altcontactzipcode - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 50 =head2 altcontactcountry @@ -378,9 +364,8 @@ __PACKAGE__->table("deletedborrowers"); =head2 altcontactphone - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 50 =head2 smsalertnumber @@ -473,9 +458,9 @@ __PACKAGE__->add_columns( "initials", { data_type => "mediumtext", is_nullable => 1 }, "streetnumber", - { data_type => "varchar", is_nullable => 1, size => 10 }, + { data_type => "tinytext", is_nullable => 1 }, "streettype", - { data_type => "varchar", is_nullable => 1, size => 50 }, + { data_type => "tinytext", is_nullable => 1 }, "address", { data_type => "longtext", is_nullable => 1 }, "address2", @@ -485,7 +470,7 @@ __PACKAGE__->add_columns( "state", { data_type => "mediumtext", is_nullable => 1 }, "zipcode", - { data_type => "varchar", is_nullable => 1, size => 25 }, + { data_type => "tinytext", is_nullable => 1 }, "country", { data_type => "mediumtext", is_nullable => 1 }, "email", @@ -493,7 +478,7 @@ __PACKAGE__->add_columns( "phone", { data_type => "mediumtext", is_nullable => 1 }, "mobile", - { data_type => "varchar", is_nullable => 1, size => 50 }, + { data_type => "tinytext", is_nullable => 1 }, "fax", { data_type => "longtext", is_nullable => 1 }, "emailpro", @@ -501,26 +486,11 @@ __PACKAGE__->add_columns( "phonepro", { data_type => "mediumtext", is_nullable => 1 }, "B_streetnumber", - { - accessor => "b_streetnumber", - data_type => "varchar", - is_nullable => 1, - size => 10, - }, + { accessor => "b_streetnumber", data_type => "tinytext", is_nullable => 1 }, "B_streettype", - { - accessor => "b_streettype", - data_type => "varchar", - is_nullable => 1, - size => 50, - }, + { accessor => "b_streettype", data_type => "tinytext", is_nullable => 1 }, "B_address", - { - accessor => "b_address", - data_type => "varchar", - is_nullable => 1, - size => 100, - }, + { accessor => "b_address", data_type => "mediumtext", is_nullable => 1 }, "B_address2", { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 }, "B_city", @@ -528,12 +498,7 @@ __PACKAGE__->add_columns( "B_state", { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 }, "B_zipcode", - { - accessor => "b_zipcode", - data_type => "varchar", - is_nullable => 1, - size => 25, - }, + { accessor => "b_zipcode", data_type => "tinytext", is_nullable => 1 }, "B_country", { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 }, "B_email", @@ -587,23 +552,23 @@ __PACKAGE__->add_columns( "sort2", { data_type => "varchar", is_nullable => 1, size => 80 }, "altcontactfirstname", - { data_type => "varchar", is_nullable => 1, size => 255 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactsurname", - { data_type => "varchar", is_nullable => 1, size => 255 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactaddress1", - { data_type => "varchar", is_nullable => 1, size => 255 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactaddress2", - { data_type => "varchar", is_nullable => 1, size => 255 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactaddress3", - { data_type => "varchar", is_nullable => 1, size => 255 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactstate", { data_type => "mediumtext", is_nullable => 1 }, "altcontactzipcode", - { data_type => "varchar", is_nullable => 1, size => 50 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactcountry", { data_type => "mediumtext", is_nullable => 1 }, "altcontactphone", - { data_type => "varchar", is_nullable => 1, size => 50 }, + { data_type => "mediumtext", is_nullable => 1 }, "smsalertnumber", { data_type => "varchar", is_nullable => 1, size => 50 }, "sms_provider_id", @@ -650,8 +615,8 @@ __PACKAGE__->add_columns( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-05-22 04:33:29 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zK1jC6Wawwj8B2ch9KFByw +# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-07-16 16:16:23 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HiETuS+0kBHCvN7dJ2FDQg # You can replace this text with custom code or comments, and it will be preserved on regeneration -- 2.20.1