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

(-)a/installer/data/mysql/updatedatabase.pl (-3 / +2 lines)
Lines 12993-13002 if ( CheckVersion($DBversion) ) { Link Here
12993 
$DBversion = "16.06.00.027";
 12993 
$DBversion = "16.06.00.027";
12994 
if ( CheckVersion($DBversion) ) {
 12994 
if ( CheckVersion($DBversion) ) {
12995 
    $dbh->do(q{
 12995 
    $dbh->do(q{
12996 
        ALTER IGNORE TABLE borrowers ADD COLUMN lastseen datetime default NULL AFTER updated_on;
 12996 
        ALTER TABLE borrowers ADD COLUMN lastseen datetime default NULL AFTER updated_on;
12997 
    });
 12997 
    });
12998 
    $dbh->do(q{
 12998 
    $dbh->do(q{
12999 
        ALTER IGNORE TABLE deletedborrowers ADD COLUMN lastseen datetime default NULL AFTER updated_on;
 12999 
        ALTER TABLE deletedborrowers ADD COLUMN lastseen datetime default NULL AFTER updated_on;
13000 
    });
 13000 
    });
13001 
    $dbh->do(q{
 13001 
    $dbh->do(q{
13002 
        INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('TrackLastPatronActivity', '0', 'If set, the field borrowers.lastseen will be updated everytime a patron is seen', NULL, 'YesNo');
 13002 
        INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('TrackLastPatronActivity', '0', 'If set, the field borrowers.lastseen will be updated everytime a patron is seen', NULL, 'YesNo');
13003 
-

Return to bug 17234