icingaweb2-module-director/schema/pgsql-migrations/upgrade_79.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
483 B
SQL

-- SPDX-FileCopyrightText: 2018 Icinga GmbH <https://icinga.com>
-- SPDX-License-Identifier: GPL-3.0-or-later
ALTER TABLE icinga_user_states_set
DROP CONSTRAINT icinga_user_states_set_pkey,
ADD PRIMARY KEY (user_id, property, merge_behaviour);
ALTER TABLE icinga_user_types_set
DROP CONSTRAINT icinga_user_types_set_pkey,
ADD PRIMARY KEY (user_id, property, merge_behaviour);
INSERT INTO director_schema_migration
(schema_version, migration_time)
VALUES (79, NOW());