From 4855aae12c151e6473922b2a5d3de5c7bafe9e48 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Sun, 12 May 2002 18:01:48 +0000
Subject:  - support for new trigger status - UNKNOWN (Alexei)

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index ae0d476f..3c6195d4 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -349,9 +349,11 @@ CREATE TABLE services (
 --
 
 CREATE TABLE services_links (
+  linkid		serial,
   serviceupid		int4		DEFAULT '0' NOT NULL,
   servicedownid		int4		DEFAULT '0' NOT NULL,
-  soft			int2		DEFAULT '0' NOT NULL
+  soft			int2		DEFAULT '0' NOT NULL,
+  PRIMARY KEY (linkid)
 );
 
 CREATE INDEX services_links_serviceupid on services_links (serviceupid);
-- 
cgit 

