mirror of
https://github.com/Icinga/icingaweb2-module-director.git
synced 2026-06-05 06:43:11 -04:00
b6af283732
Add SPDX license headers and mark source files as GPL-3.0-or-later to preserve the option to relicense under later GPL versions.
17 lines
560 B
SQL
17 lines
560 B
SQL
-- SPDX-FileCopyrightText: 2022 Icinga GmbH <https://icinga.com>
|
|
-- SPDX-License-Identifier: GPL-3.0-or-later
|
|
|
|
DELETE FROM sync_run AS sr
|
|
WHERE EXISTS (
|
|
SELECT 1 FROM sync_rule AS s
|
|
WHERE s.id = sr.rule_id
|
|
AND s.object_type != 'datalistEntry'
|
|
AND sr.start_time > '2022-09-21 00:00:00'
|
|
) AND sr.last_former_activity = sr.last_related_activity;
|
|
|
|
DELETE FROM sync_run
|
|
WHERE (objects_created + objects_deleted + objects_modified) = 0;
|
|
|
|
INSERT INTO director_schema_migration
|
|
(schema_version, migration_time)
|
|
VALUES (182, NOW());
|