From be181cb0f782ee8770969b874bf69f4d176aca68 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Sun, 26 Jan 2003 12:42:31 +0000
Subject:  - added support for SLA level in IT Services (Alexei)  - added
 fields services.showsla and services.goodsla (Alexei)

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index f024e836..10e6b05b 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -383,6 +383,8 @@ CREATE TABLE services (
   status		int2		DEFAULT '0' NOT NULL,
   algorithm		int2		DEFAULT '0' NOT NULL,
   triggerid		int4,
+  showsla		int4		DEFAULT '0' NOT NULL,
+  goodsla		int4		DEFAULT '99.9' NOT NULL,
   PRIMARY KEY (serviceid)
 );
 
-- 
cgit 

