summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2003-01-26 12:42:31 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2003-01-26 12:42:31 +0000
commitbe181cb0f782ee8770969b874bf69f4d176aca68 (patch)
tree43e339bc67029a2609772d7bb89a883157bae818 /create/postgresql/schema.sql
parentaa8cb9dde7a3e4c5e9b74c6cc38aecd63d913de1 (diff)
downloadzabbix-be181cb0f782ee8770969b874bf69f4d176aca68.tar.gz
zabbix-be181cb0f782ee8770969b874bf69f4d176aca68.tar.xz
zabbix-be181cb0f782ee8770969b874bf69f4d176aca68.zip
- 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
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql2
1 files changed, 2 insertions, 0 deletions
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)
);