internal/archesrv/sql/005_commit_signatures.sql
1CREATE TABLE IF NOT EXISTS commit_signatures (
2 commit_id BLOB PRIMARY KEY,
3 status TEXT NOT NULL, -- 'verified' | 'unknown_key' | 'invalid' | 'unsigned'
4 key_id TEXT NOT NULL DEFAULT '',
5 verified_at INTEGER NOT NULL DEFAULT 0
6);