@@ -, +, @@ update step --- installer/data/mysql/updatedatabase.pl | 36 ++++++++++++++------------ 1 file changed, 20 insertions(+), 16 deletions(-) --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -24229,23 +24229,27 @@ if( CheckVersion( $DBversion ) ) { $DBversion = '20.12.00.048'; if( CheckVersion( $DBversion ) ) { - if ( column_exists( 'borrowers', 'relationship' ) ) { - $dbh->do(q{ - ALTER TABLE borrowers DROP COLUMN relationship - }); - } - - if ( column_exists( 'deletedborrowers', 'relationship' ) ) { - $dbh->do(q{ - ALTER TABLE deletedborrowers DROP COLUMN relationship - }); - } - if ( column_exists( 'borrower_modifications', 'relationship' ) ) { - $dbh->do(q{ - ALTER TABLE borrower_modifications DROP COLUMN relationship - }); - } + # This DB upgrade has been commented out because it removes + # actively used data, the relationship columns will be added back + + # if ( column_exists( 'borrowers', 'relationship' ) ) { + # $dbh->do(q{ + # ALTER TABLE borrowers DROP COLUMN relationship + # }); + # } + + # if ( column_exists( 'deletedborrowers', 'relationship' ) ) { + # $dbh->do(q{ + # ALTER TABLE deletedborrowers DROP COLUMN relationship + # }); + # } + + # if ( column_exists( 'borrower_modifications', 'relationship' ) ) { + # $dbh->do(q{ + # ALTER TABLE borrower_modifications DROP COLUMN relationship + # }); + # } NewVersion( $DBversion, 26995, "Drop column relationship from borrower tables"); } --