OXYGENHUB
# 8eae2f0e255c oxygenhub / crates / hub / migrations-pg / 0083_tlog_cosigned_notes.sql
354 B · SQL · last changed Trusted time on the hub: serve when witnesses first saw an entry 17 days ago source blame history raw
1
-- Trusted time (oxygenhub#240): each checkpoint the witnesses cosigned,
2
-- by its size, with the cosignatures it gathered, so a fetch can show when
3
-- a witness first saw an entry (Oxygen spec §14.8, integrated time).
4
CREATE TABLE tlog_cosigned_notes (
5
    size       BIGINT PRIMARY KEY,
6
    note       TEXT NOT NULL,
7
    updated_ms BIGINT NOT NULL
8
);