diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2002-06-05 08:48:28 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2002-06-05 08:48:28 +0000 |
| commit | 16ade8fbfde6ec3f6c899bab8a109db0b366acdb (patch) | |
| tree | 3b8839b3ed0bf10cadb9a141c17f354570fb4f96 /create/mysql/schema.sql | |
| parent | ca309d601413e7615cd322b235c41591e149dcb9 (diff) | |
| download | zabbix-16ade8fbfde6ec3f6c899bab8a109db0b366acdb.tar.gz zabbix-16ade8fbfde6ec3f6c899bab8a109db0b366acdb.tar.xz zabbix-16ade8fbfde6ec3f6c899bab8a109db0b366acdb.zip | |
- added index triggers.value and trigger.status (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@402 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/mysql/schema.sql')
| -rw-r--r-- | create/mysql/schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index d775da16..a756bdc3 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -295,7 +295,6 @@ CREATE TABLE triggers ( expression varchar(255) DEFAULT '' NOT NULL, description varchar(255) DEFAULT '' NOT NULL, url varchar(255) DEFAULT '' NOT NULL, --- istrue int(4) DEFAULT '0' NOT NULL, status int(4) DEFAULT '0' NOT NULL, value int(4) DEFAULT '0' NOT NULL, priority int(2) DEFAULT '0' NOT NULL, @@ -303,7 +302,8 @@ CREATE TABLE triggers ( dep_level int(2) DEFAULT '0' NOT NULL, comments blob, PRIMARY KEY (triggerid), - KEY (istrue) + KEY (status), + KEY (value) ); -- |