diff options
author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2002-01-09 07:16:10 +0000 |
---|---|---|
committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2002-01-09 07:16:10 +0000 |
commit | baf02ab977d8bb5a7cc9a16d4d440c359de4b73f (patch) | |
tree | 3567eafe63e43163cbd5f0190c56ee486a8e1649 /create/mysql | |
parent | 38d78876d1e4914a21682ae7a319fc1f98a6c4db (diff) | |
download | zabbix-baf02ab977d8bb5a7cc9a16d4d440c359de4b73f.tar.gz zabbix-baf02ab977d8bb5a7cc9a16d4d440c359de4b73f.tar.xz zabbix-baf02ab977d8bb5a7cc9a16d4d440c359de4b73f.zip |
- 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
Diffstat (limited to 'create/mysql')
-rw-r--r-- | create/mysql/schema.sql | 7 |
1 files changed, 5 insertions, 2 deletions
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) ); # |