From 734d69b5e7cf19752e3f36396c499cbdb21aa6f9 Mon Sep 17 00:00:00 2001 From: hugetoad Date: Sat, 18 Dec 2004 14:01:18 +0000 Subject: - added link to ZABBIX manual from all forms (Alexei) - icmppingsec to return '0' if cannot ping (Alexei) - added error reason for unsupported items (Alexei) - added error reason for unreachable hosts (Alexei) - added hosts.error (Alexei) - added items.error (Alexei) - added alerts.error (Alexei) - added error reason for undelivered alerts (Alexei) - added upgrades/dbpatches/1.1alpha3_to_1.1alpha4 (Alexei) - fixed empty macros in alert messages if '.' in key (Alexei) - do not show menu item if no permissions (Alexei) git-svn-id: svn://svn.zabbix.com/trunk@1539 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- create/postgresql/schema.sql | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'create/postgresql/schema.sql') diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index db50fd43..fc9ef9b9 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -32,6 +32,7 @@ CREATE TABLE hosts ( status int4 DEFAULT '0' NOT NULL, disable_until int4 DEFAULT '0' NOT NULL, network_errors int4 DEFAULT '0' NOT NULL, + error varchar(128) DEFAULT '' NOT NULL, PRIMARY KEY (hostid) ); @@ -72,6 +73,7 @@ CREATE TABLE items ( snmpv3_authpassphrase varchar(64) DEFAULT '' NOT NULL, snmpv3_privpassphrase varchar(64) DEFAULT '' NOT NULL, formula varchar(255) DEFAULT '{.last(0)}' NOT NULL, + error varchar(128) DEFAULT '' NOT NULL, PRIMARY KEY (itemid), FOREIGN KEY (hostid) REFERENCES hosts ); @@ -233,13 +235,14 @@ CREATE TABLE alerts ( alertid serial, actionid int4 DEFAULT '0' NOT NULL, clock int4 DEFAULT '0' NOT NULL, - status int4 DEFAULT '0' NOT NULL, - retries int4 DEFAULT '0' NOT NULL, -- type varchar(10) DEFAULT '' NOT NULL, mediatypeid int4 DEFAULT '0' NOT NULL, sendto varchar(100) DEFAULT '' NOT NULL, subject varchar(255) DEFAULT '' NOT NULL, message text DEFAULT '' NOT NULL, + status int4 DEFAULT '0' NOT NULL, + retries int4 DEFAULT '0' NOT NULL, + error varchar(128) DEFAULT '' NOT NULL, PRIMARY KEY (alertid), FOREIGN KEY (actionid) REFERENCES actions, FOREIGN KEY (mediatypeid) REFERENCES media_type -- cgit