|
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 |
- |
|
|