From 1a361d834ade415957a6b7f7f38e206759465009 Mon Sep 17 00:00:00 2001 From: Gunnar Beutner Date: Wed, 23 Jul 2014 10:25:26 +0200 Subject: [PATCH] Add MySQL/pgSQL upgrade files which fix name2 in the icinga_objects table fixes #6646 --- components/db_ido_mysql/schema/upgrade/.gitignore | 0 .../schema/upgrade/mysql-upgrade-2.0.2.sql | 10 ++++++++++ components/db_ido_pgsql/schema/upgrade/.gitignore | 0 .../schema/upgrade/pgsql-upgrade-2.0.2.sql | 10 ++++++++++ 4 files changed, 20 insertions(+) delete mode 100644 components/db_ido_mysql/schema/upgrade/.gitignore create mode 100644 components/db_ido_mysql/schema/upgrade/mysql-upgrade-2.0.2.sql delete mode 100644 components/db_ido_pgsql/schema/upgrade/.gitignore create mode 100644 components/db_ido_pgsql/schema/upgrade/pgsql-upgrade-2.0.2.sql diff --git a/components/db_ido_mysql/schema/upgrade/.gitignore b/components/db_ido_mysql/schema/upgrade/.gitignore deleted file mode 100644 index e69de29bb..000000000 diff --git a/components/db_ido_mysql/schema/upgrade/mysql-upgrade-2.0.2.sql b/components/db_ido_mysql/schema/upgrade/mysql-upgrade-2.0.2.sql new file mode 100644 index 000000000..8bd871b1a --- /dev/null +++ b/components/db_ido_mysql/schema/upgrade/mysql-upgrade-2.0.2.sql @@ -0,0 +1,10 @@ +-- ----------------------------------------- +-- upgrade path for Icinga 2.0.2 +-- +-- ----------------------------------------- +-- Copyright (c) 2014 Icinga Development Team (http://www.icinga.org) +-- +-- Please check http://docs.icinga.org for upgrading information! +-- ----------------------------------------- + +UPDATE icinga_objects SET name2 = NULL WHERE name2 = ''; diff --git a/components/db_ido_pgsql/schema/upgrade/.gitignore b/components/db_ido_pgsql/schema/upgrade/.gitignore deleted file mode 100644 index e69de29bb..000000000 diff --git a/components/db_ido_pgsql/schema/upgrade/pgsql-upgrade-2.0.2.sql b/components/db_ido_pgsql/schema/upgrade/pgsql-upgrade-2.0.2.sql new file mode 100644 index 000000000..8bd871b1a --- /dev/null +++ b/components/db_ido_pgsql/schema/upgrade/pgsql-upgrade-2.0.2.sql @@ -0,0 +1,10 @@ +-- ----------------------------------------- +-- upgrade path for Icinga 2.0.2 +-- +-- ----------------------------------------- +-- Copyright (c) 2014 Icinga Development Team (http://www.icinga.org) +-- +-- Please check http://docs.icinga.org for upgrading information! +-- ----------------------------------------- + +UPDATE icinga_objects SET name2 = NULL WHERE name2 = ''; -- 2.40.0