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

(-)a/installer/data/mysql/atomicupdate/Bug10459_AddTimestampToBorrowers.sql (+8 lines)
Line 0 Link Here
1
ALTER TABLE borrowers
2
    ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
3
    ON UPDATE CURRENT_TIMESTAMP
4
    AFTER privacy_guarantor_checkouts;
5
ALTER TABLE deletedborrowers
6
    ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
7
    ON UPDATE CURRENT_TIMESTAMP
8
    AFTER privacy_guarantor_checkouts;
(-)a/installer/data/mysql/updatedatabase.pl (-13 lines)
Lines 12599-12616 if ( CheckVersion($DBversion) ) { Link Here
12599
    SetVersion($DBversion);
12599
    SetVersion($DBversion);
12600
}
12600
}
12601
12601
12602
$DBversion = "3.23.00.XXX";
12603
if ( CheckVersion($DBversion) ) {
12604
    $dbh->do(q|
12605
ALTER TABLE borrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
12606
    |);
12607
    $dbh->do(q|
12608
ALTER TABLE deletedborrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
12609
    |);
12610
    print "Upgrade to $DBversion done (Bug 10459: Borrowers should have a timestamp)\n";
12611
    SetVersion($DBversion);
12612
}
12613
12614
12602
12615
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
12603
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
12616
# SEE bug 13068
12604
# SEE bug 13068
12617
- 

Return to bug 10459