-- The transparency log's index (oxygenhub#238, docs/transparency.md):

-- which entry logged which object, so a proof can be given for it and an

-- object is logged once. The log itself is append-only files in the data

-- directory (tlog/); these rows only point into it.

CREATE TABLE tlog_entries (

    idx         BIGINT PRIMARY KEY,

    object      TEXT NOT NULL,

    kind        TEXT NOT NULL,

    repo_id     BIGINT REFERENCES repositories(id) ON DELETE SET NULL,

    received_ms BIGINT NOT NULL

);

CREATE UNIQUE INDEX tlog_entries_object ON tlog_entries(object, kind);

CREATE INDEX tlog_entries_repo ON tlog_entries(repo_id, idx);