arche / internal/archesrv/sql/005_commit_signatures.sql

commit 154431fd
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);