Skip to content

Modern Docker Management, Designed for Everyone

1.3 KB
Raw Blame
-- +goose Up
CREATE TABLE IF NOT EXISTS vulnerability_scan_items (
    id BIGSERIAL PRIMARY KEY,
    image_id TEXT NOT NULL REFERENCES vulnerability_scans(id) ON DELETE CASCADE,
    vulnerability_id TEXT NOT NULL,
    pkg_name TEXT NOT NULL,
    installed_version TEXT NOT NULL DEFAULT '',
    fixed_version TEXT NOT NULL DEFAULT '',
    severity TEXT NOT NULL,
    severity_rank INTEGER NOT NULL DEFAULT 0,
    pkg_class TEXT NOT NULL DEFAULT '',
    pkg_type TEXT NOT NULL DEFAULT '',
    title TEXT NOT NULL DEFAULT '',
    details TEXT
);

CREATE INDEX IF NOT EXISTS idx_vulnerability_scan_items_image_id ON vulnerability_scan_items(image_id);
CREATE INDEX IF NOT EXISTS idx_vulnerability_scan_items_severity ON vulnerability_scan_items(severity);
CREATE INDEX IF NOT EXISTS idx_vulnerability_scan_items_vulnerability_id ON vulnerability_scan_items(vulnerability_id);
CREATE INDEX IF NOT EXISTS idx_vulnerability_scan_items_severity_rank_id ON vulnerability_scan_items(severity_rank, id);

-- +goose Down
DROP INDEX IF EXISTS idx_vulnerability_scan_items_severity_rank_id;
DROP INDEX IF EXISTS idx_vulnerability_scan_items_vulnerability_id;
DROP INDEX IF EXISTS idx_vulnerability_scan_items_severity;
DROP INDEX IF EXISTS idx_vulnerability_scan_items_image_id;
DROP TABLE IF EXISTS vulnerability_scan_items;