max / makenotwork

647 B · 18 lines History Blame Raw

1	-- Add scan status to items and versions
2	ALTER TABLE items ADD COLUMN scan_status TEXT NOT NULL DEFAULT 'pending';
3	ALTER TABLE versions ADD COLUMN scan_status TEXT NOT NULL DEFAULT 'pending';
4
5	-- Store scan results for audit trail
6	CREATE TABLE file_scan_results (
7	id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
8	s3_key TEXT NOT NULL,
9	scan_status TEXT NOT NULL,
10	scan_layers JSONB NOT NULL,
11	sha256 TEXT,
12	file_size_bytes BIGINT,
13	scanned_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
14	);
15
16	CREATE INDEX idx_file_scan_results_s3_key ON file_scan_results(s3_key);
17	CREATE INDEX idx_file_scan_results_sha256 ON file_scan_results(sha256);
18