-- Transparency-log witnesses (oxygenhub#238): the last checkpoint this

-- hub cosigned for each log it witnesses, and how far each of this hub's

-- witnesses has cosigned its own log.

CREATE TABLE tlog_witnessed (

    origin     TEXT PRIMARY KEY,

    size       BIGINT NOT NULL,

    root       TEXT NOT NULL,

    updated_ms BIGINT NOT NULL

);

CREATE TABLE tlog_cosigned (

    witness    TEXT PRIMARY KEY,

    size       BIGINT NOT NULL,

    updated_ms BIGINT NOT NULL

);