diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-09-09 09:13:00 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-09-09 09:13:00 +0000 |
| commit | 36b34d4bf1b167ab8638c8b8dd4678c7e126e18a (patch) | |
| tree | 084e215432e55fd68d8e6ebd89d3990be18d9ad6 /create | |
| parent | bce463b114d46094f1e4a07a34fccb117d86cc17 (diff) | |
| download | zabbix-36b34d4bf1b167ab8638c8b8dd4678c7e126e18a.tar.gz zabbix-36b34d4bf1b167ab8638c8b8dd4678c7e126e18a.tar.xz zabbix-36b34d4bf1b167ab8638c8b8dd4678c7e126e18a.zip | |
- added table triger_depends
- calls to perror() were changed to syslog() where possible
- added status line to full screen version of form "Status of Triggers"
git-svn-id: svn://svn.zabbix.com/trunk@200 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create')
| -rw-r--r-- | create/mysql/schema.sql | 56 |
1 files changed, 34 insertions, 22 deletions
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index e53a9b63..56bee57e 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -222,11 +222,11 @@ CREATE TABLE items ( lastclock int(4) DEFAULT NULL, prevvalue double(16,4) DEFAULT NULL, status int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (itemid), - UNIQUE shortname (hostid,key_), - KEY (hostid), - KEY (nextcheck), - KEY (status) + PRIMARY KEY (itemid), + UNIQUE shortname (hostid,key_), + KEY (hostid), + KEY (nextcheck), + KEY (status) ); # @@ -234,13 +234,13 @@ CREATE TABLE items ( # CREATE TABLE media ( - mediaid int(4) NOT NULL auto_increment, - userid int(4) DEFAULT '0' NOT NULL, - type varchar(10) DEFAULT '' NOT NULL, - sendto varchar(100) DEFAULT '' NOT NULL, - active int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (mediaid), - KEY (userid) + mediaid int(4) NOT NULL auto_increment, + userid int(4) DEFAULT '0' NOT NULL, + type varchar(10) DEFAULT '' NOT NULL, + sendto varchar(100) DEFAULT '' NOT NULL, + active int(4) DEFAULT '0' NOT NULL, + PRIMARY KEY (mediaid), + KEY (userid) ); # @@ -248,16 +248,28 @@ CREATE TABLE media ( # CREATE TABLE triggers ( - triggerid int(4) NOT NULL auto_increment, - expression varchar(255) DEFAULT '' NOT NULL, - description varchar(255) DEFAULT '' NOT NULL, - istrue int(4) DEFAULT '0' NOT NULL, - lastcheck int(4) DEFAULT '0' NOT NULL, - priority int(2) DEFAULT '0' NOT NULL, - lastchange int(4) DEFAULT '0' NOT NULL, - comments blob, - PRIMARY KEY (triggerid), - KEY (istrue) + triggerid int(4) NOT NULL auto_increment, + expression varchar(255) DEFAULT '' NOT NULL, + description varchar(255) DEFAULT '' NOT NULL, + istrue int(4) DEFAULT '0' NOT NULL, + lastcheck int(4) DEFAULT '0' NOT NULL, + priority int(2) DEFAULT '0' NOT NULL, + lastchange int(4) DEFAULT '0' NOT NULL, + comments blob, + PRIMARY KEY (triggerid), + KEY (istrue) +); + +# +# Table structure for table 'trigger_depends' +# + +CREATE TABLE trigger_depends ( + triggerid_down int(4) DEFAULT '0' NOT NULL, + triggerid_up int(4) DEFAULT '0' NOT NULL, + PRIMARY KEY (triggerid_down, triggerid_up), + KEY (triggerid_down), + KEY (triggerid_up) ); # |