@@ -, +, @@ --- C4/Members.pm | 2 +- installer/data/mysql/atomicupdate/bug_13178_wide_cardnumber.sql | 6 ++++++ 2 files changed, 7 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_13178_wide_cardnumber.sql --- a/C4/Members.pm +++ a/C4/Members.pm @@ -956,7 +956,7 @@ database column. =cut sub get_cardnumber_length { - my ( $min, $max ) = ( 0, 16 ); # borrowers.cardnumber is a nullable varchar(16) + my ( $min, $max ) = ( 0, 32 ); # borrowers.cardnumber is a nullable varchar(20) $min = 1 if C4::Context->preference('BorrowerMandatoryField') =~ /cardnumber/; if ( my $cardnumber_length = C4::Context->preference('CardnumberLength') ) { # Is integer and length match --- a/installer/data/mysql/atomicupdate/bug_13178_wide_cardnumber.sql +++ a/installer/data/mysql/atomicupdate/bug_13178_wide_cardnumber.sql @@ -0,0 +1,6 @@ +ALTER TABLE borrowers MODIFY cardnumber varchar(32); +ALTER TABLE borrower_modifications MODIFY cardnumber varchar(32); +ALTER TABLE deletedborrowers MODIFY cardnumber varchar(32); +ALTER TABLE deletedborrowers MODIFY cardnumber varchar(32); +ALTER TABLE pending_offline_operations MODIFY cardnumber varchar(32); +ALTER TABLE tmp_holdsqueue MODIFY cardnumber varchar(32); --