From baf02ab977d8bb5a7cc9a16d4d440c359de4b73f Mon Sep 17 00:00:00 2001 From: hugetoad Date: Wed, 9 Jan 2002 07:16:10 +0000 Subject: - even more support for IT Services (Alexei) - added column status to table services (Alexei) git-svn-id: svn://svn.zabbix.com/trunk@276 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- create/mysql/schema.sql | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'create') diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index 9b82811b..989c50d6 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -5,8 +5,10 @@ CREATE TABLE services ( serviceid int(4) NOT NULL auto_increment, name varchar(128) DEFAULT '' NOT NULL, + status int(1) DEFAULT '0' NOT NULL, triggerid int(4), - PRIMARY KEY (serviceid) + PRIMARY KEY (serviceid), + KEY (triggerid) ); # @@ -18,7 +20,8 @@ CREATE TABLE services_links ( servicedownid int(4) DEFAULT '0' NOT NULL, soft int(1) DEFAULT '0' NOT NULL, KEY (serviceupid), - KEY (servicedownid) + KEY (servicedownid), + UNIQUE (serviceupid,servicedownid) ); # -- cgit