summaryrefslogtreecommitdiffstats
path: root/create/postgresql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2003-10-18 08:24:54 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2003-10-18 08:24:54 +0000
commit1783ca4c53a6afd95d0a4edec89f7e3742829d53 (patch)
tree17f3188b70998ae303c87da9008df8acd7501883 /create/postgresql
parent8bea529a3cc48fdeb9d8bcb440003a7e7c8fb6e8 (diff)
downloadzabbix-1783ca4c53a6afd95d0a4edec89f7e3742829d53.tar.gz
zabbix-1783ca4c53a6afd95d0a4edec89f7e3742829d53.tar.xz
zabbix-1783ca4c53a6afd95d0a4edec89f7e3742829d53.zip
Better support of delta functionality (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@998 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql')
-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 f6d09aef..f7987e2f 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -63,6 +63,8 @@ CREATE TABLE items (
trapper_hosts varchar(255) DEFAULT '' NOT NULL,
units varchar(10) DEFAULT '' NOT NULL,
multiplier int4 DEFAULT '0' NOT NULL,
+ delta int1 DEFAULT '0' NOT NULL,
+ prevorgvalue float8 DEFAULT '0.0',
PRIMARY KEY (itemid),
FOREIGN KEY (hostid) REFERENCES hosts
);