icingaweb2-module-director/schema/pgsql-migrations/upgrade_80.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

14 lines
462 B
SQL

-- SPDX-FileCopyrightText: 2018 Icinga GmbH <https://icinga.com>
-- SPDX-License-Identifier: GPL-3.0-or-later
ALTER TABLE icinga_timeperiod_range
DROP CONSTRAINT icinga_timeperiod_range_timeperiod,
ADD CONSTRAINT icinga_timeperiod_range_timeperiod
FOREIGN KEY (timeperiod_id)
REFERENCES icinga_timeperiod (id)
ON DELETE CASCADE
ON UPDATE CASCADE;
INSERT INTO director_schema_migration
(schema_version, migration_time)
VALUES (80, NOW());