Lines 10-18
return {
Link Here
|
10 |
my $rv = $dbh->do(q{ |
10 |
my $rv = $dbh->do(q{ |
11 |
UPDATE borrowers |
11 |
UPDATE borrowers |
12 |
SET updated_on = GREATEST( |
12 |
SET updated_on = GREATEST( |
13 |
COALESCE(date_renewed, FROM_UNIXTIME(0)), |
13 |
COALESCE(date_renewed, FROM_UNIXTIME(1)), |
14 |
COALESCE(dateenrolled, FROM_UNIXTIME(0)), |
14 |
COALESCE(dateenrolled, FROM_UNIXTIME(1)), |
15 |
COALESCE(lastseen, FROM_UNIXTIME(0)) |
15 |
COALESCE(lastseen, FROM_UNIXTIME(1)) |
16 |
) |
16 |
) |
17 |
WHERE updated_on IS NULL |
17 |
WHERE updated_on IS NULL |
18 |
}); |
18 |
}); |
Lines 21-29
return {
Link Here
|
21 |
$rv = $dbh->do(q{ |
21 |
$rv = $dbh->do(q{ |
22 |
UPDATE deletedborrowers |
22 |
UPDATE deletedborrowers |
23 |
SET updated_on = GREATEST( |
23 |
SET updated_on = GREATEST( |
24 |
COALESCE(date_renewed, FROM_UNIXTIME(0)), |
24 |
COALESCE(date_renewed, FROM_UNIXTIME(1)), |
25 |
COALESCE(dateenrolled, FROM_UNIXTIME(0)), |
25 |
COALESCE(dateenrolled, FROM_UNIXTIME(1)), |
26 |
COALESCE(lastseen, FROM_UNIXTIME(0)) |
26 |
COALESCE(lastseen, FROM_UNIXTIME(1)) |
27 |
) |
27 |
) |
28 |
WHERE updated_on IS NULL |
28 |
WHERE updated_on IS NULL |
29 |
}); |
29 |
}); |
30 |
- |
|
|