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 (-14 lines)
Lines 12220-12238 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
12220
    SetVersion($DBversion);
12220
    SetVersion($DBversion);
12221
}
12221
}
12222
12222
12223
$DBversion = "3.23.00.XXX";
12224
if ( CheckVersion($DBversion) ) {
12225
    $dbh->do(q|
12226
ALTER TABLE borrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
12227
    |);
12228
    $dbh->do(q|
12229
ALTER TABLE deletedborrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
12230
    |);
12231
    print "Upgrade to $DBversion done (Bug 10459: Borrowers should have a timestamp)\n";
12232
    SetVersion($DBversion);
12233
}
12234
12235
12236
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
12223
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
12237
# SEE bug 13068
12224
# SEE bug 13068
12238
# if there is anything in the atomicupdate, read and execute it.
12225
# if there is anything in the atomicupdate, read and execute it.
12239
- 

Return to bug 10459