From 15f33d0a3cf634aeac1827bf2bc26ae7a8430d5f Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Mon, 9 Jun 2003 13:04:44 +0000
Subject:  - added table 'stats' (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@810 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 45d1122d..f17c989a 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -503,4 +503,18 @@ CREATE TABLE screens_items (
   PRIMARY KEY  (screenitemid)
 );
 
+--
+-- Table structure for table 'stats'
+--
+
+CREATE TABLE stats (
+  itemid		int4		DEFAULT '0' NOT NULL,
+  year			int4		DEFAULT '0' NOT NULL,
+  month			int4		DEFAULT '0' NOT NULL,
+  day			int4		DEFAULT '0' NOT NULL,
+  hour			int4		DEFAULT '0' NOT NULL,
+  value			float8		DEFAULT '0.0000' NOT NULL,
+  PRIMARY KEY (itemid,year,month,day,hour),
+);
+
 VACUUM ANALYZE;
-- 
cgit 

