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

-- -----------------------------------------
-- upgrade path for Icinga 2.1.0
--
-- -----------------------------------------
-- 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!
-- -----------------------------------------

ALTER TABLE icinga_programstatus ADD COLUMN endpoint_name TEXT default NULL;

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

SELECT updatedbversion('1.11.7');
DB IDO: Add endpoint_name to programstatus table refs #6827 refs #6203 2014-08-13 10:47:38 -04:00			`-- -----------------------------------------`
			`-- upgrade path for Icinga 2.1.0`
			`--`
			`-- -----------------------------------------`
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`
DB IDO: Add endpoint_name to programstatus table refs #6827 refs #6203 2014-08-13 10:47:38 -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!`
DB IDO: Add endpoint_name to programstatus table refs #6827 refs #6203 2014-08-13 10:47:38 -04:00			`-- -----------------------------------------`

			`ALTER TABLE icinga_programstatus ADD COLUMN endpoint_name TEXT default NULL;`

			`-- -----------------------------------------`
			`-- update dbversion`
			`-- -----------------------------------------`

			`SELECT updatedbversion('1.11.7');`