icinga2/lib/db_ido_pgsql/schema/upgrade/2.0.2.sql

-- -----------------------------------------
-- upgrade path for Icinga 2.0.2
--
-- -----------------------------------------
-- SPDX-FileCopyrightText: 2012 Icinga GmbH <https://icinga.com>
-- SPDX-License-Identifier: GPL-2.0-or-later
--
-- Please check https://docs.icinga.com for upgrading information!
-- -----------------------------------------

UPDATE icinga_objects SET name2 = NULL WHERE name2 = '';

-- -----------------------------------------
-- update dbversion
-- -----------------------------------------

SELECT updatedbversion('1.11.6');
Add MySQL/pgSQL upgrade files which fix name2 in the icinga_objects table fixes #6646 2014-07-23 04:25:26 -04:00			`-- -----------------------------------------`
			`-- upgrade path for Icinga 2.0.2`
			`--`
			`-- -----------------------------------------`
Replace all existing copyright headers with `SPDX` headers I've used the following command to replace the original copyright header lines in a C-style comment block: ``` $ find . \( -type d \( -name '\..' -o -name third-party -o -name scripts -o -name prefix -o -name malloc -o -name server -o -name docker -o -name build -o -name doc \) -prune \) -o -type f -exec perl -pi -e 's{/\[^]\(\sc\s\)\s(\d{4})\sIcinga\s+GmbH[^]\/}{// SPDX-FileCopyrightText: \1 Icinga GmbH <https://icinga.com>\n// SPDX-License-Identifier: GPL-2.0-or-later}gi' {} + ``` For files that use shell-style comments (#) like CMakeLists.txt, I've used this command: ``` $ find . \( -type d \( -name '\..' -o -name third-party -o -name scripts -o -name prefix -o -name malloc -o -name server -o -name docker -o -name build -o -name doc \) -prune \) -o -type f -exec perl -pi -e 's{#.\(\sc\s\)\s(\d{4})\sIcinga\s+GmbH.}{# SPDX-FileCopyrightText: \1 Icinga GmbH <https://icinga.com>\n# SPDX-License-Identifier: GPL-2.0-or-later}gi' {} + ``` And for SQL files: ``` $ find . \( -type d \( -name '\..' -o -name third-party -o -name scripts -o -name prefix -o -name malloc -o -name server -o -name docker -o -name build -o -name doc \) -prune \) -o -type f \( -name '.sql' \) -exec perl -pi -e 's{--.\(c\)\s(\d{4})\sIcinga\sGmbH.}{-- SPDX-FileCopyrightText: \1 Icinga GmbH <https://icinga.com>\n-- SPDX-License-Identifier: GPL-2.0-or-later}gi' {} + $ find . \( -type d \( -name '\..' -o -name third-party -o -name scripts -o -name prefix -o -name malloc -o -name server -o -name docker -o -name build -o -name doc \) -prune \) -o -type f \( -name '.sql' \) -exec perl -pi -e 's{-- Copyright \(c\)\s(\d{4})\sIcinga\s+Development\sTeam.*}{-- SPDX-FileCopyrightText: \1 Icinga GmbH <https://icinga.com>\n-- SPDX-License-Identifier: GPL-2.0-or-later}gi' {} + ``` 2026-01-27 09:06:40 -05:00			`-- SPDX-FileCopyrightText: 2012 Icinga GmbH <https://icinga.com>`
			`-- SPDX-License-Identifier: GPL-2.0-or-later`
Add MySQL/pgSQL upgrade files which fix name2 in the icinga_objects table fixes #6646 2014-07-23 04:25:26 -04:00			`--`
Replace http:// links with https:// links where a secure website exists Leave out tests and third party tools, and license strings fixes #5151 Signed-off-by: Michael Friedrich <michael.friedrich@icinga.com> 2017-04-06 16:20:20 -04:00			`-- Please check https://docs.icinga.com for upgrading information!`
Add MySQL/pgSQL upgrade files which fix name2 in the icinga_objects table fixes #6646 2014-07-23 04:25:26 -04:00			`-- -----------------------------------------`

			`UPDATE icinga_objects SET name2 = NULL WHERE name2 = '';`
Fix customvariables in DB IDO MySQL are not case sensitive fixes #6608 2014-07-23 12:06:57 -04:00
			`-- -----------------------------------------`
			`-- update dbversion`
			`-- -----------------------------------------`

			`SELECT updatedbversion('1.11.6');`