Modern Docker Management, Designed for Everyone
Go composecontainer-managementcontainersdockerdocker-composedocker-managementgoself-hostedsveltekittypescriptweb-ui
-- +goose Up
-- Add vulnerability_ignores table for storing ignored vulnerability records
CREATE TABLE IF NOT EXISTS vulnerability_ignores (
id TEXT PRIMARY KEY,
environment_id TEXT NOT NULL,
image_id TEXT NOT NULL,
vulnerability_id TEXT NOT NULL,
pkg_name TEXT NOT NULL,
installed_version TEXT NOT NULL,
reason TEXT,
created_by TEXT NOT NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);
-- Create indexes for efficient querying
CREATE INDEX IF NOT EXISTS idx_vulnerability_ignores_env ON vulnerability_ignores(environment_id);
CREATE INDEX IF NOT EXISTS idx_vulnerability_ignores_image ON vulnerability_ignores(image_id);
CREATE INDEX IF NOT EXISTS idx_vulnerability_ignores_vuln ON vulnerability_ignores(vulnerability_id);
CREATE INDEX IF NOT EXISTS idx_vulnerability_ignores_composite ON vulnerability_ignores(environment_id, image_id, vulnerability_id, pkg_name, installed_version);
-- +goose Down
-- Drop vulnerability_ignores table
DROP TABLE IF EXISTS vulnerability_ignores;