1 $DBversion = 'XXX'; # will be replaced by the RM
2 if( CheckVersion( $DBversion ) ) {
4 for my $f (qw( streetnumber streettype zipcode mobile B_streetnumber B_streettype B_zipcode ) ) {
6 ALTER TABLE borrowers MODIFY $f TINYTEXT DEFAULT NULL
9 ALTER TABLE deletedborrowers MODIFY $f TINYTEXT DEFAULT NULL
12 for my $f ( qw( B_address altcontactfirstname altcontactsurname altcontactaddress1 altcontactaddress2 altcontactaddress3 altcontactzipcode altcontactphone ) ) {
14 ALTER TABLE borrowers MODIFY $f MEDIUMTEXT DEFAULT NULL
17 ALTER TABLE deletedborrowers MODIFY $f MEDIUMTEXT DEFAULT NULL
21 SetVersion( $DBversion );
22 print "Upgrade to $DBversion done (Bug 24986 - Switch borrowers address related fields to TINYTEXT or MEDIUMTEXT)\n";