summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2001-06-19 14:15:52 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2001-06-19 14:15:52 +0000
commiteb7a2dd83498fa83ad44c7da01362dba10c6d0f4 (patch)
tree8e94ac978cdc0a697d7daff7fb1bcf8eeb04b17b /create/postgresql/schema.sql
parent1532d158e6ffe62b16b2f78aa9a0121051e16fd3 (diff)
downloadzabbix-eb7a2dd83498fa83ad44c7da01362dba10c6d0f4.tar.gz
zabbix-eb7a2dd83498fa83ad44c7da01362dba10c6d0f4.tar.xz
zabbix-eb7a2dd83498fa83ad44c7da01362dba10c6d0f4.zip
Added columns items.snmp_oid and items.snmp_community.
git-svn-id: svn://svn.zabbix.com/trunk@86 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index e6b489dd..65e53fad 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -21,6 +21,8 @@ CREATE INDEX hosts_status on hosts (status);
CREATE TABLE items (
itemid serial,
type int4 NOT NULL,
+ snmp_community varchar(64) DEFAULT '' NOT NULL,
+ snmp_oid varchar(255) DEFAULT '' NOT NULL,
hostid int4 NOT NULL,
description varchar(255) DEFAULT '' NOT NULL,
key_ varchar(64) DEFAULT '' NOT NULL,