summaryrefslogtreecommitdiffstats
path: root/create/postgresql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2003-06-09 18:44:36 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2003-06-09 18:44:36 +0000
commit62ebb086312e77f5f3b3d1785ace12b487c07f65 (patch)
tree33ae9ca515942597602bbf3f4f4c2ee55b9ab32a /create/postgresql
parent9c6cbde9ca8bd7dd8425b3c1b0a88387f60ee1b3 (diff)
downloadzabbix-62ebb086312e77f5f3b3d1785ace12b487c07f65.tar.gz
zabbix-62ebb086312e77f5f3b3d1785ace12b487c07f65.tar.xz
zabbix-62ebb086312e77f5f3b3d1785ace12b487c07f65.zip
- added columnt items.units (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@813 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql')
-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 f17c989a..8d3a26d0 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -61,6 +61,7 @@ CREATE TABLE items (
status int4 DEFAULT '0' NOT NULL,
value_type int4 DEFAULT '0' NOT NULL,
trapper_hosts varchar(255) DEFAULT '' NOT NULL,
+ units varchar(10) DEFAULT '' NOT NULL,
PRIMARY KEY (itemid),
FOREIGN KEY (hostid) REFERENCES hosts
);