summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2005-10-11 09:44:13 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2005-10-11 09:44:13 +0000
commitbd8e9b9574137d509cae0fa35c8b82f146d054d7 (patch)
treeb76aa90b54e5ac9d46d1dfcec662fea6f49b6745 /create/postgresql/schema.sql
parent8032171a3262cb459405b84c1864a81025fe78f3 (diff)
downloadzabbix-bd8e9b9574137d509cae0fa35c8b82f146d054d7.tar.gz
zabbix-bd8e9b9574137d509cae0fa35c8b82f146d054d7.tar.xz
zabbix-bd8e9b9574137d509cae0fa35c8b82f146d054d7.zip
MInor changes.
git-svn-id: svn://svn.zabbix.com/trunk@2166 97f52cf1-0a1b-0410-bd0e-c28be96e8082
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,