summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql3
1 files changed, 2 insertions, 1 deletions
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,