diff options
author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-03-07 22:08:48 +0000 |
---|---|---|
committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-03-07 22:08:48 +0000 |
commit | 1764bc0f7acc32c70564854cc9930cf9e04a1f48 (patch) | |
tree | d3a50047c57569046eca84db015ecbc5c6cef30d /upgrades | |
parent | 5323ada3a5d26df1b6633e56567cb1a9cdb7dfb2 (diff) | |
download | zabbix-1764bc0f7acc32c70564854cc9930cf9e04a1f48.tar.gz zabbix-1764bc0f7acc32c70564854cc9930cf9e04a1f48.tar.xz zabbix-1764bc0f7acc32c70564854cc9930cf9e04a1f48.zip |
- [DEV-136] changes in database upgrade script (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@5464 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades')
-rw-r--r-- | upgrades/dbpatches/1.6/mysql/patch/alerts.sql | 2 | ||||
-rw-r--r-- | upgrades/dbpatches/1.6/mysql/patch/node_configlog.sql | 2 |
2 files changed, 3 insertions, 1 deletions
diff --git a/upgrades/dbpatches/1.6/mysql/patch/alerts.sql b/upgrades/dbpatches/1.6/mysql/patch/alerts.sql index 9e248778..8bea58d0 100644 --- a/upgrades/dbpatches/1.6/mysql/patch/alerts.sql +++ b/upgrades/dbpatches/1.6/mysql/patch/alerts.sql @@ -1,4 +1,6 @@ +alter table alerts frop index alerts_3; alter table alerts drop triggerid; alter table alerts add eventid bigint(20) unsigned NOT NULL default '0'; +CREATE INDEX alerts_3 on alerts (eventid); update alerts set status=3 where retries>=2; diff --git a/upgrades/dbpatches/1.6/mysql/patch/node_configlog.sql b/upgrades/dbpatches/1.6/mysql/patch/node_configlog.sql index 8aa3064a..05301b54 100644 --- a/upgrades/dbpatches/1.6/mysql/patch/node_configlog.sql +++ b/upgrades/dbpatches/1.6/mysql/patch/node_configlog.sql @@ -1 +1 @@ -drop table node_configlog.sql; +drop table node_configlog; |