From 97713f1b9da38b6848e144a9d4e776f03b178e8e Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Sun, 16 Feb 2003 14:28:23 +0000
Subject:  - fixed type of services.goodsla. It's float now. (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@699 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 10e6b05b..723ffa91 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -384,7 +384,7 @@ CREATE TABLE services (
   algorithm		int2		DEFAULT '0' NOT NULL,
   triggerid		int4,
   showsla		int4		DEFAULT '0' NOT NULL,
-  goodsla		int4		DEFAULT '99.9' NOT NULL,
+  goodsla		float8		DEFAULT '99.9' NOT NULL,
   PRIMARY KEY (serviceid)
 );
 
-- 
cgit 

