From dcafb4317aa97aaad0bd47b79cc94c21fb2cd5fb Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Sun, 8 Sep 2002 10:00:33 +0000
Subject: Postpone IT Helpdes.

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 89aa81ac..8392ebe0 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -186,7 +186,7 @@ CREATE TABLE functions (
   triggerid		int4		DEFAULT '0' NOT NULL,
   lastvalue		varchar(255),
   function		varchar(10)	DEFAULT '' NOT NULL,
-  parameter		int4		DEFAULT '0' NOT NULL,
+  parameter		varchar(255)	DEFAULT '0' NOT NULL,
   PRIMARY KEY (functionid),
   FOREIGN KEY (itemid) REFERENCES items,
   FOREIGN KEY (triggerid) REFERENCES triggers
@@ -382,5 +382,19 @@ CREATE TABLE sessions (
 	FOREIGN KEY (userid) REFERENCES users
 );
 
+--
+-- Table structure for table 'services_alarms'
+--
+
+CREATE TABLE service_alarms (
+  servicealarmid	serial,
+  serviceid		int4		DEFAULT '0' NOT NULL,
+  clock			int4		DEFAULT '0' NOT NULL,
+  value			int4		DEFAULT '0' NOT NULL,
+  PRIMARY KEY (servicealarmid)
+);
+
+CREATE INDEX services_alarms_serviceid_clock on service_alarms (serviceid,clock);
+CREATE INDEX services_alarms_clock on service_alarms (clock);
 
 VACUUM ANALYZE;
-- 
cgit 

