diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2004-09-10 17:47:32 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2004-09-10 17:47:32 +0000 |
| commit | f7f74958b31cb3c8009d5946497911bfcf00cac0 (patch) | |
| tree | 4555db9646840429880875d36cae0f8b0de13b2d /create/postgresql | |
| parent | d037e4b58b4c81f46d68c1dab66c22e130599d35 (diff) | |
| download | zabbix-f7f74958b31cb3c8009d5946497911bfcf00cac0.tar.gz zabbix-f7f74958b31cb3c8009d5946497911bfcf00cac0.tar.xz zabbix-f7f74958b31cb3c8009d5946497911bfcf00cac0.zip | |
- 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
Diffstat (limited to 'create/postgresql')
| -rw-r--r-- | create/postgresql/schema.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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 ); |