audit-labs/gh-attest

GitHub Audit Evidence Extractor

clone: git clone https://gitbay.org/audit-labs/gh-attest.git

v1.0.3: migrations/0004_exports.sql · raw

 1CREATE TABLE exports (
 2  id TEXT PRIMARY KEY,           -- uuid
 3  installation_id INTEGER NOT NULL,
 4  framework TEXT NOT NULL,        -- 'soc2' | 'iso27001' | 'all'
 5  format TEXT NOT NULL,           -- 'csv' | 'pdf'
 6  status TEXT NOT NULL,           -- 'queued' | 'processing' | 'done' | 'error'
 7  r2_key TEXT,                    -- null until rendered
 8  error TEXT,                     -- populated on failure
 9  created_at TEXT NOT NULL,
10  completed_at TEXT,
11  FOREIGN KEY (installation_id) REFERENCES installations(installation_id)
12);
13
14CREATE INDEX idx_exports_installation ON exports(installation_id, created_at);