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