summaryrefslogtreecommitdiffstats
path: root/upgrades
diff options
context:
space:
mode:
authoralex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-02-28 11:56:06 +0000
committeralex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-02-28 11:56:06 +0000
commit865f524c0ce05acbcc119b7883a95ee619416401 (patch)
tree3155d3154fc48827131c8eb0796630a3397eb556 /upgrades
parent1cef19d4401063e21f125d44dad4acdc368361ab (diff)
downloadzabbix-865f524c0ce05acbcc119b7883a95ee619416401.tar.gz
zabbix-865f524c0ce05acbcc119b7883a95ee619416401.tar.xz
zabbix-865f524c0ce05acbcc119b7883a95ee619416401.zip
Minor fixes of MySQL patch.
git-svn-id: svn://svn.zabbix.com/trunk@3852 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades')
-rw-r--r--upgrades/dbpatches/1.3/mysql/patch/config.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/patch/config.sql b/upgrades/dbpatches/1.3/mysql/patch/config.sql
index 438fd3b1..6f88f069 100644
--- a/upgrades/dbpatches/1.3/mysql/patch/config.sql
+++ b/upgrades/dbpatches/1.3/mysql/patch/config.sql
@@ -4,9 +4,10 @@ CREATE TABLE config_tmp (
event_history integer DEFAULT '0' NOT NULL,
refresh_unsupported integer DEFAULT '0' NOT NULL,
work_period varchar(100) DEFAULT '1-5,00:00-24:00' NOT NULL,
+ alert_usrgrpid bigint unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (configid)
) ENGINE=InnoDB;
-insert into config_tmp select 1,alert_history,alarm_history,refresh_unsupported,work_period from config;
+insert into config_tmp select 1,alert_history,alarm_history,refresh_unsupported,work_period,0 from config;
drop table config;
alter table config_tmp rename config;