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

(-)a/installer/data/mysql/updatedatabase.pl (-13 / +14 lines)
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
- 

Return to bug 17914