Skip to content

Modern Docker Management, Designed for Everyone

885 B
Raw Blame
-- +goose Up
-- Backfill missing vulnerability scan settings defaults
INSERT INTO settings (key, value)
VALUES ('vulnerabilityScanEnabled', 'false')
ON CONFLICT (key) DO NOTHING;

UPDATE settings
SET value = 'false'
WHERE key = 'vulnerabilityScanEnabled'
  AND (value IS NULL OR btrim(value) = '');

INSERT INTO settings (key, value)
VALUES ('vulnerabilityScanInterval', '0 0 0 * * *')
ON CONFLICT (key) DO NOTHING;

UPDATE settings
SET value = '0 0 0 * * *'
WHERE key = 'vulnerabilityScanInterval'
  AND (value IS NULL OR btrim(value) = '');

-- Backfill missing auto-update excluded containers setting
INSERT INTO settings (key, value)
VALUES ('autoUpdateExcludedContainers', '')
ON CONFLICT (key) DO NOTHING;

UPDATE settings
SET value = ''
WHERE key = 'autoUpdateExcludedContainers'
  AND value IS NULL;

-- +goose Down
-- No-op: data backfill migration cannot be safely reversed.