Modern Docker Management, Designed for Everyone
Go composecontainer-managementcontainersdockerdocker-composedocker-managementgoself-hostedsveltekittypescriptweb-ui
-- +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;