icingaweb2-module-director/schema/pgsql-migrations/upgrade_102.sql
Eric Lippmann b6af283732 License source files as GPL-3.0-or-later
Add SPDX license headers and mark source files as GPL-3.0-or-later to
preserve the option to relicense under later GPL versions.
2026-03-24 11:30:06 +01:00

16 lines
489 B
SQL

-- SPDX-FileCopyrightText: 2018 Icinga GmbH <https://icinga.com>
-- SPDX-License-Identifier: GPL-3.0-or-later
UPDATE director_deployment_log SET startup_log = LEFT(startup_log, 20480) || '
[..] shortened '
|| (LENGTH(startup_log) - 40960)
|| ' bytes by Director on schema upgrade [..]
' || RIGHT(startup_log, 20480) WHERE LENGTH(startup_log) > 61440;
VACUUM FULL director_deployment_log;
INSERT INTO director_schema_migration
(schema_version, migration_time)
VALUES (102, NOW());