summaryrefslogtreecommitdiffstats
path: root/create/mysql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2004-12-18 14:01:18 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2004-12-18 14:01:18 +0000
commit734d69b5e7cf19752e3f36396c499cbdb21aa6f9 (patch)
tree93a52166ccf111f23027ffa71876b5e1184baa4b /create/mysql
parent8d2c56ee22cd641a7dbab7b2b28b200a83031921 (diff)
downloadzabbix-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/mysql')
-rw-r--r--create/mysql/schema.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql
index 8ee64a70..747e45fa 100644
--- a/create/mysql/schema.sql
+++ b/create/mysql/schema.sql
@@ -177,6 +177,7 @@ CREATE TABLE alerts (
message blob DEFAULT '' NOT NULL,
status int(4) DEFAULT '0' NOT NULL,
retries int(4) DEFAULT '0' NOT NULL,
+ error varchar(128) DEFAULT '' NOT NULL,
PRIMARY KEY (alertid),
INDEX (actionid),
KEY clock (clock),
@@ -272,6 +273,7 @@ CREATE TABLE hosts (
-- If status=UNREACHABLE, host will not be checked until this time
disable_until int(4) DEFAULT '0' NOT NULL,
network_errors int(4) DEFAULT '0' NOT NULL,
+ error varchar(128) DEFAULT '' NOT NULL,
PRIMARY KEY (hostid),
UNIQUE (host),
KEY (status)
@@ -312,6 +314,7 @@ CREATE TABLE items (
snmpv3_privpassphrase varchar(64) DEFAULT '' NOT NULL,
formula varchar(255) DEFAULT '0' NOT NULL,
+ error varchar(128) DEFAULT '' NOT NULL,
PRIMARY KEY (itemid),
UNIQUE shortname (hostid,key_),