@@ -, +, @@ db_revs/211200037.pl Updated all NULL values of borrowers.updated_on to GREATEST(date_renewed, dateenrolled, lastseen): 51 rows updated --- installer/data/mysql/db_revs/211200037.pl | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) --- a/installer/data/mysql/db_revs/211200037.pl +++ a/installer/data/mysql/db_revs/211200037.pl @@ -10,9 +10,9 @@ return { my $rv = $dbh->do(q{ UPDATE borrowers SET updated_on = GREATEST( - COALESCE(date_renewed, FROM_UNIXTIME(0)), - COALESCE(dateenrolled, FROM_UNIXTIME(0)), - COALESCE(lastseen, FROM_UNIXTIME(0)) + COALESCE(date_renewed, FROM_UNIXTIME(1)), + COALESCE(dateenrolled, FROM_UNIXTIME(1)), + COALESCE(lastseen, FROM_UNIXTIME(1)) ) WHERE updated_on IS NULL }); @@ -21,9 +21,9 @@ return { $rv = $dbh->do(q{ UPDATE deletedborrowers SET updated_on = GREATEST( - COALESCE(date_renewed, FROM_UNIXTIME(0)), - COALESCE(dateenrolled, FROM_UNIXTIME(0)), - COALESCE(lastseen, FROM_UNIXTIME(0)) + COALESCE(date_renewed, FROM_UNIXTIME(1)), + COALESCE(dateenrolled, FROM_UNIXTIME(1)), + COALESCE(lastseen, FROM_UNIXTIME(1)) ) WHERE updated_on IS NULL }); --