-- Briefs (spec §12.1): the current text of each layer. Every change is a

-- brief.set event signed by the owner; the ledger holds the history.

CREATE TABLE briefs (

    layer    TEXT NOT NULL,               -- overall | project

    project  TEXT NOT NULL DEFAULT '',    -- the project, for the project layer

    text     TEXT NOT NULL,

    seq      INTEGER NOT NULL,

    PRIMARY KEY (layer, project)

);