ido/mysql: Fix IDO upgrade compliance against MySQL 5.7

[icinga2] / lib / db_ido_mysql / schema / upgrade / 2.2.0.sql

diff --git a/lib/db_ido_mysql/schema/upgrade/2.2.0.sql b/lib/db_ido_mysql/schema/upgrade/2.2.0.sql
index 50d44aa72978ca003a7b572df8cc9dff797d810c..155264f412003f8f2b5986dcd7544c8340e5e34a 100644 (file)
--- a/lib/db_ido_mysql/schema/upgrade/2.2.0.sql
+++ b/lib/db_ido_mysql/schema/upgrade/2.2.0.sql
@@ -9,8 +9,8 @@
 
 ALTER TABLE `icinga_programstatus` ADD COLUMN `program_version` varchar(64) character set latin1 collate latin1_general_cs default NULL;
 
-ALTER TABLE icinga_contacts MODIFY alias TEXT character set latin1  default '';
-ALTER TABLE icinga_hosts MODIFY alias TEXT character set latin1  default '';
+ALTER TABLE icinga_contacts MODIFY alias TEXT character set latin1;
+ALTER TABLE icinga_hosts MODIFY alias TEXT character set latin1;
 
 ALTER TABLE icinga_customvariables ADD COLUMN is_json smallint default 0;
 ALTER TABLE icinga_customvariablestatus ADD COLUMN is_json smallint default 0;