diff options
Diffstat (limited to 'upgrades/dbpatches/1.0beta3_to_1.0beta4/mysql/patch.sql')
| -rw-r--r-- | upgrades/dbpatches/1.0beta3_to_1.0beta4/mysql/patch.sql | 2 |
1 files changed, 2 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 e0cba5cb..00991240 100644 --- a/upgrades/dbpatches/1.0beta3_to_1.0beta4/mysql/patch.sql +++ b/upgrades/dbpatches/1.0beta3_to_1.0beta4/mysql/patch.sql @@ -6,6 +6,8 @@ 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; +alter table items add trapper_hosts varchar(255) DEFAULT '' 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); |