diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2004-12-18 14:01:18 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2004-12-18 14:01:18 +0000 |
| commit | 734d69b5e7cf19752e3f36396c499cbdb21aa6f9 (patch) | |
| tree | 93a52166ccf111f23027ffa71876b5e1184baa4b /create/postgresql/schema.sql | |
| parent | 8d2c56ee22cd641a7dbab7b2b28b200a83031921 (diff) | |
| download | zabbix-734d69b5e7cf19752e3f36396c499cbdb21aa6f9.tar.gz zabbix-734d69b5e7cf19752e3f36396c499cbdb21aa6f9.tar.xz zabbix-734d69b5e7cf19752e3f36396c499cbdb21aa6f9.zip | |
- 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
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 7 |
1 files changed, 5 insertions, 2 deletions
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 |