From f7f74958b31cb3c8009d5946497911bfcf00cac0 Mon Sep 17 00:00:00 2001 From: hugetoad Date: Fri, 10 Sep 2004 17:47:32 +0000 Subject: - added support for custom multiplier (Alexei) - added column items.formula (Alexei) - added support of SNMPv3 (Alexei) - added columns snmpv3_* to table items (Alexei) git-svn-id: svn://svn.zabbix.com/trunk@1420 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- create/postgresql/schema.sql | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'create/postgresql') diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index ea246cac..48be44b0 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -66,6 +66,11 @@ CREATE TABLE items ( multiplier int4 DEFAULT '0' NOT NULL, delta int4 DEFAULT '0' NOT NULL, prevorgvalue float8 DEFAULT NULL, + snmpv3_securityname varchar(64) DEFAULT '' NOT NULL, + snmpv3_securitylevel int4 DEFAULT '0' NOT NULL, + snmpv3_authpassphrase varchar(64) DEFAULT '' NOT NULL, + snmpv3_privpassphrase varchar(64) DEFAULT '' NOT NULL, + formula varchar(255) DEFAULT '{.last(0)}' NOT NULL, PRIMARY KEY (itemid), FOREIGN KEY (hostid) REFERENCES hosts ); -- cgit