summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2001-06-19 06:39:16 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2001-06-19 06:39:16 +0000
commit4a1028be33431cddaadcc8645e5b78ecb6fe4a16 (patch)
tree30b1c9bf26be92ccc3b0e9938695c4d91e335940 /create/postgresql/schema.sql
parent9b0e385a4c92f2876a4c0a17620c8b3ff75ff8cd (diff)
downloadzabbix-4a1028be33431cddaadcc8645e5b78ecb6fe4a16.tar.gz
zabbix-4a1028be33431cddaadcc8645e5b78ecb6fe4a16.tar.xz
zabbix-4a1028be33431cddaadcc8645e5b78ecb6fe4a16.zip
Added column type for table items.
git-svn-id: svn://svn.zabbix.com/trunk@84 97f52cf1-0a1b-0410-bd0e-c28be96e8082
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,