Commit | Line | Data |
---|---|---|
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 |