CREATE TABLE `log_audit` (
`BuildGuid` char(64) NOT NULL
COMMENT 'FK to log_build_run or standalone audit',
`AuditMode` varchar(20) NOT NULL
COMMENT 'deps, config, secrets, or image',
`Target` varchar(255) NOT NULL
COMMENT 'What was scanned',
`Critical` int NOT NULL DEFAULT 0,
`High` int NOT NULL DEFAULT 0,
`Medium` int NOT NULL DEFAULT 0,
`Low` int NOT NULL DEFAULT 0,
`TotalFindings` int NOT NULL DEFAULT 0,
`AuditPassed` char(1) NOT NULL DEFAULT 'Y',
`ElapsedSeconds` decimal(10,1) DEFAULT NULL,
`Detail` text DEFAULT NULL,
`CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`BuildGuid`, `AuditMode`, `Target`(100)),
KEY `idx_mode` (`AuditMode`),
KEY `idx_passed` (`AuditPassed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE={collation}
COMMENT='Trivy security audit results';
SELECT
AuditMode, Target,
Critical, High, Medium, Low,
TotalFindings, AuditPassed,
ElapsedSeconds
FROM log_audit
WHERE BuildGuid = '{build_guid}'
ORDER BY AuditMode