Lines 12669-12686
if ( CheckVersion($DBversion) ) {
Link Here
|
12669 |
|
12669 |
|
12670 |
$DBversion = "16.06.00.002"; |
12670 |
$DBversion = "16.06.00.002"; |
12671 |
if ( CheckVersion($DBversion) ) { |
12671 |
if ( CheckVersion($DBversion) ) { |
12672 |
$dbh->do(q{ |
12672 |
unless ( column_exists('borrowers', 'updated_on') ) { |
12673 |
ALTER TABLE borrowers |
12673 |
$dbh->do(q{ |
12674 |
ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP |
12674 |
ALTER TABLE borrowers |
12675 |
ON UPDATE CURRENT_TIMESTAMP |
12675 |
ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP |
12676 |
AFTER privacy_guarantor_checkouts; |
12676 |
ON UPDATE CURRENT_TIMESTAMP |
12677 |
}); |
12677 |
AFTER privacy_guarantor_checkouts; |
12678 |
$dbh->do(q{ |
12678 |
}); |
12679 |
ALTER TABLE deletedborrowers |
12679 |
$dbh->do(q{ |
12680 |
ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP |
12680 |
ALTER TABLE deletedborrowers |
12681 |
ON UPDATE CURRENT_TIMESTAMP |
12681 |
ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP |
12682 |
AFTER privacy_guarantor_checkouts; |
12682 |
ON UPDATE CURRENT_TIMESTAMP |
12683 |
}); |
12683 |
AFTER privacy_guarantor_checkouts; |
|
|
12684 |
}); |
12685 |
} |
12684 |
|
12686 |
|
12685 |
print "Upgrade to $DBversion done (Bug 10459 - borrowers should have a timestamp)\n"; |
12687 |
print "Upgrade to $DBversion done (Bug 10459 - borrowers should have a timestamp)\n"; |
12686 |
SetVersion($DBversion); |
12688 |
SetVersion($DBversion); |
12687 |
- |
|
|