Skip to content

Modern Docker Management, Designed for Everyone

1.0 KB
Raw Blame
-- +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 TIMESTAMP 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;