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.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 50d20dae..e6b489dd 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -20,6 +20,7 @@ CREATE INDEX hosts_status on hosts (status);
CREATE TABLE items (
itemid serial,
+ type int4 NOT NULL,
hostid int4 NOT NULL,
description varchar(255) DEFAULT '' NOT NULL,
key_ varchar(64) DEFAULT '' NOT NULL,