X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.11%2F07_emails.sql;h=1cb69c11dcb3ff99eb0456bcac3ad68ca3beaa0d;hb=3f64dbef5d9473000661e0ce00ff73bd64e0ef58;hp=9897c8afcc979e32f6d16f106d8128c883125eba;hpb=dc557110afa62b4612653a1eab41c023a4a2e0f1;p=platal.git diff --git a/upgrade/0.9.11/07_emails.sql b/upgrade/0.9.11/07_emails.sql index 9897c8a..1cb69c1 100644 --- a/upgrade/0.9.11/07_emails.sql +++ b/upgrade/0.9.11/07_emails.sql @@ -2,7 +2,7 @@ alter table emails add column panne_level tinyint(1) not null default 0 after pa alter table emails change flags flags enum('active', 'filter', 'panne') not null default 'active'; UPDATE emails SET last = panne WHERE last = 0 AND panne != 0; UPDATE emails - SET panne_level = 1 - WHERE flags = 'active' + SET panne_level = 1 + WHERE flags = 'active' AND DATE_ADD(panne, INTERVAL 2 MONTH) > CURDATE();