summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
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,