From 2d0d67b4c6c0f5e6953cca43d133eafabceb81e9 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Sun, 20 Jan 2002 09:36:35 +0000
Subject: Updated schemas and patches for 1.0beta1.

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 606dafd2..a07d931b 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -77,6 +77,7 @@ CREATE TABLE triggers (
   triggerid		serial,
   expression		varchar(255)	DEFAULT '' NOT NULL,
   description		varchar(255)	DEFAULT '' NOT NULL,
+  url			varchar(255)	DEFAULT '' NOT NULL,
   istrue		int4		DEFAULT '0' NOT NULL,
   priority		int2		DEFAULT '0' NOT NULL,
   lastchange		int4		DEFAULT '0' NOT NULL,
@@ -318,4 +319,32 @@ CREATE TABLE graphs_items (
   FOREIGN KEY (itemid) REFERENCES items
 );
 
+--
+-- Table structure for table 'services'
+--
+
+CREATE TABLE services (
+  serviceid		serial,
+  name			varchar(128)	DEFAULT '' NOT NULL,
+  status		int2		DEFAULT '0' NOT NULL,
+  triggerid		int4,
+  PRIMARY KEY (serviceid)
+);
+
+CREATE INDEX services_triggerid on services (triggerid);
+
+--
+-- Table structure for table 'services_links'
+--
+
+CREATE TABLE services_links (
+  serviceupid		int4		DEFAULT '0' NOT NULL,
+  servicedownid		int4		DEFAULT '0' NOT NULL,
+  soft			int2		DEFAULT '0' NOT NULL
+);
+
+CREATE INDEX services_links_serviceupid on services_links (serviceupid);
+CREATE INDEX services_links_servicedownid on services_links (servicedownid);
+CREATE UNIQUE INDEX services_links_upidownid on services_links (serviceupid, servicedownid);
+
 VACUUM ANALYZE;
-- 
cgit 

