From 31df2566aa416b3cb88010cf07b571e5644992dc Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Tue, 2 Apr 2002 06:25:48 +0000
Subject:  - column functions.lastvalue changed to varchar(255) (Alexei)  -
 column items.lastvalue changed to varchar(255) (Alexei)  - column
 items.prevvalue changed to varchar(255) (Alexei)  - changed definition of
 DebugLevel (Alexei)  - support for version[zabbix_agent] (Alexei)  - better
 validation of trigger expressions in validate_expression  (Alexei)  - common
 parser of config files in include/cfg.c (Alexei)

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 0dfed834..90b70c5c 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -34,9 +34,9 @@ CREATE TABLE items (
   history		int4		DEFAULT '0' NOT NULL,
   lastdelete		int4		DEFAULT '0' NOT NULL,
   nextcheck		int4		DEFAULT '0' NOT NULL,
-  lastvalue		float8		DEFAULT NULL,
+  lastvalue		varchar(255)	DEFAULT NULL,
   lastclock		int4		DEFAULT NULL,
-  prevvalue		float8		DEFAULT NULL,
+  prevvalue		varchar(255)	DEFAULT NULL,
   status		int4		DEFAULT '0' NOT NULL,
   PRIMARY KEY (itemid),
   FOREIGN KEY (hostid) REFERENCES hosts
@@ -180,7 +180,7 @@ CREATE TABLE functions (
   functionid		serial,
   itemid		int4		DEFAULT '0' NOT NULL,
   triggerid		int4		DEFAULT '0' NOT NULL,
-  lastvalue		float8		DEFAULT '0.0000' NOT NULL,
+  lastvalue		varchar(255)	DEFAULT '0.0000' NOT NULL,
   function		varchar(10)	DEFAULT '' NOT NULL,
   parameter		int4		DEFAULT '0' NOT NULL,
   PRIMARY KEY (functionid),
-- 
cgit 

