[platal.git] / upgrade / 0.9.11 / 07_emails.sql

alter table emails add column panne_level tinyint(1) not null default 0 after panne;
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'
       AND DATE_ADD(panne, INTERVAL 2 MONTH) > CURDATE();
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
aab2ffdd SJ	6	WHERE flags = 'active'
dc557110	7	AND DATE_ADD(panne, INTERVAL 2 MONTH) > CURDATE();
dc557110	8