update core
[platal.git] / upgrade / 0.9.11 / 07_emails.sql
1 alter table emails add column panne_level tinyint(1) not null default 0 after panne;
2 alter table emails change flags flags enum('active', 'filter', 'panne') not null default 'active';
3 UPDATE emails SET last = panne WHERE last = 0 AND panne != 0;
4 UPDATE emails
5 SET panne_level = 1
6 WHERE flags = 'active'
7 AND DATE_ADD(panne, INTERVAL 2 MONTH) > CURDATE();
8