|
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 |
- |
|
|