- added column alarms.value (Alexei)

 - removed column alarms.istrue (Alexei)
 - added columns triggers.status (Alexei)
 - added columns triggers.value (Alexei)
 - removed column triggers.istrue (Alexei)


git-svn-id: svn://svn.zabbix.com/trunk@401 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 18 insertions, 0 deletions

diff --git a/upgrades/dbpatches/1.0beta3_to_1.0beta4/mysql/patch.sql b/upgrades/dbpatches/1.0beta3_to_1.0beta4/mysql/patch.sql
index eb81b048..4c2824c1 100644
--- a/upgrades/dbpatches/1.0beta3_to_1.0beta4/mysql/patch.sql
+++ b/upgrades/dbpatches/1.0beta3_to_1.0beta4/mysql/patch.sql
@@ -1,2 +1,20 @@
 update config set alert_history=alert_history/(24*3600);
 update config set alarm_history=alarm_history/(24*3600);
+
+alter table triggers add status int(4) DEFAULT '0' NOT NULL;
+alter table triggers add value int(4) DEFAULT '0' NOT NULL;
+
+update triggers set status=0 where istrue in (0,1,3);
+update triggers set status=1 where istrue in (2);
+update triggers set status=2 where istrue in (4);
+
+update triggers set value=0 where istrue in (0);
+update triggers set value=1 where istrue in (1);
+update triggers set value=2 where istrue in (2,3,4);
+
+alter table triggers drop istrue;
+
+alter table alarms add value int(4) DEFAULT '0' NOT NULL;
+update alarms set value=0 where istrue in (0);
+update alarms set value=1 where istrue in (1);
+update alarms set value=2 where istrue not in (0,1);