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 12593-12610 if ( CheckVersion($DBversion) ) { Link Here
12593
    SetVersion($DBversion);
12593
    SetVersion($DBversion);
12594
}
12594
}
12595
12595
12596
$DBversion = "3.23.00.XXX";
12597
if ( CheckVersion($DBversion) ) {
12598
    $dbh->do(q|
12599
ALTER TABLE borrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
12600
    |);
12601
    $dbh->do(q|
12602
ALTER TABLE deletedborrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
12603
    |);
12604
    print "Upgrade to $DBversion done (Bug 10459: Borrowers should have a timestamp)\n";
12605
    SetVersion($DBversion);
12606
}
12607
12608
12596
12609
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
12597
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
12610
# SEE bug 13068
12598
# SEE bug 13068
12611
- 

Return to bug 10459