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

(-)a/installer/data/mysql/db_revs/211200037.pl (-7 / +6 lines)
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
- 

Return to bug 27253