summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 8e831872..ed291f5e 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -250,6 +250,10 @@ CREATE TABLE alerts (
status int4 DEFAULT '0' NOT NULL,
retries int4 DEFAULT '0' NOT NULL,
error varchar(128) DEFAULT '' NOT NULL,
+ repeats int4 DEFAULT '0' NOT NULL,
+ maxrepeats int4 DEFAULT '0' NOT NULL,
+ nextcheck int4 DEFAULT '0' NOT NULL,
+ delay int4 DEFAULT '0' NOT NULL,
PRIMARY KEY (alertid),
FOREIGN KEY (actionid) REFERENCES actions,
FOREIGN KEY (triggerid) REFERENCES triggers,