From 3da79e6d41d7feb6eb2f6e61a1712fdeca4fb46c Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Sun, 8 Aug 2004 15:13:06 +0000
Subject:  - added housekeeping of trends (Alexei)  - added column items.trends
 (Alexei)  - added escaping of SQL statements where needed (Alexei)  - added
 src/zabbix_sucker/checks_agent.[h,c] (Alexei)  - added
 src/zabbix_sucker/checks_internal.[h,c] (Alexei)  - added
 src/zabbix_sucker/checks_snmp.[h,c] (Alexei)  - added
 src/zabbix_sucker/checks_simple.[h,c] (Alexei)

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 0b7216c7..646f25a9 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -52,7 +52,8 @@ CREATE TABLE items (
   description		varchar(255)	DEFAULT '' NOT NULL,
   key_			varchar(64)	DEFAULT '' NOT NULL,
   delay			int4		DEFAULT '0' NOT NULL,
-  history		int4		DEFAULT '0' NOT NULL,
+  history		int4		DEFAULT '90' NOT NULL,
+  trends		int4		DEFAULT '365' NOT NULL,
   lastdelete		int4		DEFAULT '0' NOT NULL,
   nextcheck		int4		DEFAULT '0' NOT NULL,
   lastvalue		varchar(255)	DEFAULT NULL,
-- 
cgit 

