summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2003-11-29 20:27:54 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2003-11-29 20:27:54 +0000
commit654a42f1352c6acef831a5d32dbe4dfa08aa2429 (patch)
tree683e12409b4dacd2587cb302d7564ec74c41e6c4 /create/postgresql/schema.sql
parentee7af90ea57fd2a5e4b51c875164bf9e0e17900f (diff)
downloadzabbix-654a42f1352c6acef831a5d32dbe4dfa08aa2429.tar.gz
zabbix-654a42f1352c6acef831a5d32dbe4dfa08aa2429.tar.xz
zabbix-654a42f1352c6acef831a5d32dbe4dfa08aa2429.zip
Basic support of trends.
git-svn-id: svn://svn.zabbix.com/trunk@1071 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 760b1202..675b76b6 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -560,6 +560,7 @@ CREATE TABLE users_groups (
CREATE TABLE trends (
itemid int4 DEFAULT '0' NOT NULL,
clock int4 DEFAULT '0' NOT NULL,
+ num int2 DEFAULT '0' NOT NULL,
value_min float8 DEFAULT '0.0000' NOT NULL,
value_avg float8 DEFAULT '0.0000' NOT NULL,
value_max float8 DEFAULT '0.0000' NOT NULL,