diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-05-26 13:55:39 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-05-26 13:55:39 +0000 |
| commit | 3d56e269f4dab81972078b072e4a28a50e50f3f4 (patch) | |
| tree | 241756d4f72ad9a76cb82361cc7acf8fcdd1fac9 /upgrades | |
| parent | 886b947428fc857dc0e238595a4f3e775f93cff7 (diff) | |
| download | zabbix-3d56e269f4dab81972078b072e4a28a50e50f3f4.tar.gz zabbix-3d56e269f4dab81972078b072e4a28a50e50f3f4.tar.xz zabbix-3d56e269f4dab81972078b072e4a28a50e50f3f4.zip | |
Minor change.
git-svn-id: svn://svn.zabbix.com/trunk@781 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades')
| -rw-r--r-- | upgrades/dbpatches/1.0beta8_to_1.0beta9/mysql/patch.sql | 4 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.0beta8_to_1.0beta9/postgresql/patch.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/upgrades/dbpatches/1.0beta8_to_1.0beta9/mysql/patch.sql b/upgrades/dbpatches/1.0beta8_to_1.0beta9/mysql/patch.sql index dcda557c..67935977 100644 --- a/upgrades/dbpatches/1.0beta8_to_1.0beta9/mysql/patch.sql +++ b/upgrades/dbpatches/1.0beta8_to_1.0beta9/mysql/patch.sql @@ -49,9 +49,9 @@ CREATE TABLE media_type ( ) type=InnoDB; alter table media drop type; -alter table media add mediatypeid int(4) DEFAULT '0' NOT NULL; +alter table media add mediatypeid int(4) DEFAULT '1' NOT NULL; alter table alerts drop type; -alter table alerts add mediatypeid int(4) DEFAULT '0' NOT NULL; +alter table alerts add mediatypeid int(4) DEFAULT '1' NOT NULL; insert into media_type (mediatypeid,type,description,smtp_server,smtp_helo,smtp_email,exec_path) values (1,0,'Email','localhost','localhost','zabbix@localhost',''); diff --git a/upgrades/dbpatches/1.0beta8_to_1.0beta9/postgresql/patch.sql b/upgrades/dbpatches/1.0beta8_to_1.0beta9/postgresql/patch.sql index 411e81c0..6e60a401 100644 --- a/upgrades/dbpatches/1.0beta8_to_1.0beta9/postgresql/patch.sql +++ b/upgrades/dbpatches/1.0beta8_to_1.0beta9/postgresql/patch.sql @@ -49,9 +49,9 @@ CREATE TABLE media_type ( ); alter table media drop type; -alter table media add mediatypeid int4 DEFAULT '0' NOT NULL; +alter table media add mediatypeid int4 DEFAULT '1' NOT NULL; alter table alerts drop type; -alter table alerts add mediatypeid int4 DEFAULT '0' NOT NULL; +alter table alerts add mediatypeid int4 DEFAULT '1' NOT NULL; insert into media_type (mediatypeid,type,description,smtp_server,smtp_helo,smtp_email,exec_path) values (1,0,'Email','localhost','localhost','zabbix@localhost',''); |