diff options
Diffstat (limited to 'upgrades/dbpatches/1.6/mysql/patch/alerts.sql')
| -rw-r--r-- | upgrades/dbpatches/1.6/mysql/patch/alerts.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.6/mysql/patch/alerts.sql b/upgrades/dbpatches/1.6/mysql/patch/alerts.sql index f69c3dbf..0615db57 100644 --- a/upgrades/dbpatches/1.6/mysql/patch/alerts.sql +++ b/upgrades/dbpatches/1.6/mysql/patch/alerts.sql @@ -1,6 +1,9 @@ alter table alerts drop index alerts_3; alter table alerts drop triggerid; alter table alerts add eventid bigint(20) unsigned NOT NULL default '0'; +alter table alerts add esc_step integer DEFAULT '0' NOT NULL; +alter table alerts add alerttype integer DEFAULT '0' NOT NULL; + CREATE INDEX alerts_3 on alerts (eventid); update alerts set status=3 where retries>=2; |