View | Details | Raw Unified | Return to bug 28490
Collapse All | Expand All

(-)a/installer/data/mysql/updatedatabase.pl (-17 / +20 lines)
Lines 24229-24251 if( CheckVersion( $DBversion ) ) { Link Here
24229
24229
24230
$DBversion = '20.12.00.048';
24230
$DBversion = '20.12.00.048';
24231
if( CheckVersion( $DBversion ) ) {
24231
if( CheckVersion( $DBversion ) ) {
24232
    if ( column_exists( 'borrowers', 'relationship' ) ) {
24233
        $dbh->do(q{
24234
            ALTER TABLE borrowers DROP COLUMN relationship
24235
        });
24236
    }
24237
24238
    if ( column_exists( 'deletedborrowers', 'relationship' ) ) {
24239
        $dbh->do(q{
24240
            ALTER TABLE deletedborrowers DROP COLUMN relationship
24241
        });
24242
    }
24243
24232
24244
    if ( column_exists( 'borrower_modifications', 'relationship' ) ) {
24233
    # This DB upgrade has been commented out because it removes
24245
        $dbh->do(q{
24234
    # actively used data, the relationship columns will be added back
24246
            ALTER TABLE borrower_modifications DROP COLUMN relationship
24235
24247
        });
24236
    # if ( column_exists( 'borrowers', 'relationship' ) ) {
24248
    }
24237
    #     $dbh->do(q{
24238
    #         ALTER TABLE borrowers DROP COLUMN relationship
24239
    #     });
24240
    # }
24241
24242
    # if ( column_exists( 'deletedborrowers', 'relationship' ) ) {
24243
    #     $dbh->do(q{
24244
    #         ALTER TABLE deletedborrowers DROP COLUMN relationship
24245
    #     });
24246
    # }
24247
24248
    # if ( column_exists( 'borrower_modifications', 'relationship' ) ) {
24249
    #     $dbh->do(q{
24250
    #         ALTER TABLE borrower_modifications DROP COLUMN relationship
24251
    #     });
24252
    # }
24249
24253
24250
    NewVersion( $DBversion, 26995, "Drop column relationship from borrower tables");
24254
    NewVersion( $DBversion, 26995, "Drop column relationship from borrower tables");
24251
}
24255
}
24252
- 

Return to bug 28490