From 734d69b5e7cf19752e3f36396c499cbdb21aa6f9 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
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 

