diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-06 10:17:12 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-06 10:17:12 +0000 |
| commit | 6cd783048aba5ea9e4385bbd011c16f410f36bc3 (patch) | |
| tree | 4769b9cb9cc81cb6baa69bec52102b0744745468 /upgrades | |
| parent | 2c60c60586f351a6fdbc74e720ed39ec05c5df74 (diff) | |
| download | zabbix-6cd783048aba5ea9e4385bbd011c16f410f36bc3.tar.gz zabbix-6cd783048aba5ea9e4385bbd011c16f410f36bc3.tar.xz zabbix-6cd783048aba5ea9e4385bbd011c16f410f36bc3.zip | |
- added media_type.username, media_type.passwd (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@3794 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades')
| -rw-r--r-- | upgrades/dbpatches/1.3/mysql/patch/media_type.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/patch/media_type.sql b/upgrades/dbpatches/1.3/mysql/patch/media_type.sql index d2804a43..09b55dec 100644 --- a/upgrades/dbpatches/1.3/mysql/patch/media_type.sql +++ b/upgrades/dbpatches/1.3/mysql/patch/media_type.sql @@ -7,9 +7,11 @@ CREATE TABLE media_type_tmp ( smtp_email varchar(255) DEFAULT '' NOT NULL, exec_path varchar(255) DEFAULT '' NOT NULL, gsm_modem varchar(255) DEFAULT '' NOT NULL, + username varchar(255) DEFAULT '' NOT NULL, + passwd varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (mediatypeid) ) ENGINE=InnoDB; -insert into media_type_tmp select * from media_type; +insert into media_type_tmp select mediatypeid,type,description,smtp_server,smtp_helo,smtp_email,exec_path,gsm_modem,'','' from media_type; drop table media_type; alter table media_type_tmp rename media_type; |