From 5876de7de8f176286860894296ef5e400ee362da Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Sat, 18 Oct 2003 09:24:08 +0000
Subject: More changes for delta support (Alexei)

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index f7987e2f..a99e8cf9 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -64,7 +64,7 @@ CREATE TABLE items (
   units			varchar(10)	DEFAULT '' NOT NULL,
   multiplier		int4		DEFAULT '0' NOT NULL,
   delta			int1		DEFAULT '0' NOT NULL,
-  prevorgvalue		float8		DEFAULT '0.0',
+  prevorgvalue		float8		DEFAULT NULL,
   PRIMARY KEY (itemid),
   FOREIGN KEY (hostid) REFERENCES hosts
 );
-- 
cgit 

