blob: c0e5c6f428ba4ad482d1dce75c0ed7173ae2545d [file] [log] [blame]
Copybara854996b2021-09-07 19:36:02 +00001-- Cleaer all bouncing email flags for bounces in the last seven days.
2-- Accounts that have invalid email addresses will be detected again
3-- as soon as one email is sent to that address.
4
5UPDATE User
6SET email_bounce_timestamp = NULL
7WHERE email_bounce_timestamp > UNIX_TIMESTAMP() - 7 * 24 * 60 * 60
8LIMIT 1000;
9
10-- Look at the result, you may want to run it again if 1000 rows were
11-- updated because that means that there were more than that many such
12-- rows to start.