From ee7af90ea57fd2a5e4b51c875164bf9e0e17900f Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Sat, 29 Nov 2003 20:06:45 +0000
Subject:  - added table 'trends' (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@1070 97f52cf1-0a1b-0410-bd0e-c28be96e8082
---
 create/postgresql/schema.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'create/postgresql/schema.sql')

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index e86ecdbf..760b1202 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -553,4 +553,18 @@ CREATE TABLE users_groups (
   FOREIGN KEY (userid) REFERENCES users
 );
 
+--
+-- Table structure for table 'trends'
+--
+
+CREATE TABLE trends (
+  itemid		int4		DEFAULT '0' NOT NULL,
+  clock			int4		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,
+  PRIMARY KEY (itemid,clock),
+  FOREIGN KEY (itemid) REFERENCES items
+);
+
 VACUUM ANALYZE;
-- 
cgit 

