Commit | Line | Data |
---|---|---|
dc557110 | 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 | |
aab2ffdd SJ |
5 | SET panne_level = 1 |
6 | WHERE flags = 'active' | |
dc557110 | 7 | AND DATE_ADD(panne, INTERVAL 2 MONTH) > CURDATE(); |
8 |