1 files changed, 14 insertions, 0 deletions
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;