Skip to content

Modern Docker Management, Designed for Everyone

746 B
Raw Blame
-- +goose Up
-- v2.0.0: drop the Apprise notification service table and deprecated settings rows.
DROP TABLE IF EXISTS apprise_settings;

DELETE FROM settings WHERE key IN (
    'dockerPruneMode',
    'scheduledPruneContainers',
    'scheduledPruneImages',
    'scheduledPruneVolumes',
    'scheduledPruneNetworks',
    'scheduledPruneBuildCache',
    'authOidcConfig'
);

-- +goose Down
-- v2.0.0 rollback: recreate the apprise_settings table shape (data is not restored).
CREATE TABLE IF NOT EXISTS apprise_settings (
    id SERIAL PRIMARY KEY,
    api_url TEXT NOT NULL,
    enabled BOOLEAN NOT NULL DEFAULT FALSE,
    image_update_tag VARCHAR(255),
    container_update_tag VARCHAR(255),
    created_at TIMESTAMP,
    updated_at TIMESTAMP
);