diff options
author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-28 11:56:06 +0000 |
---|---|---|
committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-28 11:56:06 +0000 |
commit | 865f524c0ce05acbcc119b7883a95ee619416401 (patch) | |
tree | 3155d3154fc48827131c8eb0796630a3397eb556 /upgrades/dbpatches | |
parent | 1cef19d4401063e21f125d44dad4acdc368361ab (diff) | |
download | zabbix-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/dbpatches')
-rw-r--r-- | upgrades/dbpatches/1.3/mysql/patch/config.sql | 3 |
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; |