upgrades/dbpatches/1.6/mysql/patch/alerts.sql


1
2
3
4
5
6

alter table alerts drop index alerts_3;
alter table alerts drop triggerid;
alter table alerts add eventid bigint(20) unsigned NOT NULL default '0';
CREATE INDEX alerts_3 on alerts (eventid);

update alerts set status=3 where retries>=2;