-- Projections of who is who (spec §8): identities the ledger knows, by

-- role, and agents with their owner and delegation.

CREATE TABLE identities (

    key       TEXT PRIMARY KEY,           -- KeyId, hex

    role      TEXT NOT NULL,              -- owner | instance | agent

    name      TEXT NOT NULL,

    identity  BLOB NOT NULL,              -- the encoded identity object

    previous  TEXT,                       -- the identity it succeeds

    current   INTEGER NOT NULL DEFAULT 1, -- 0 once succeeded

    seq       INTEGER NOT NULL

);

CREATE TABLE agents (

    name         TEXT PRIMARY KEY,

    key          TEXT NOT NULL UNIQUE,

    owner        TEXT NOT NULL,           -- the owner's KeyId when added

    owner_name   TEXT NOT NULL,

    kind         TEXT NOT NULL,

    project      TEXT NOT NULL,

    home         TEXT NOT NULL,

    uid          INTEGER,

    learn_uid    INTEGER NOT NULL DEFAULT 0,

    scopes       TEXT NOT NULL,

    created_ms   INTEGER NOT NULL,

    disabled_ms  INTEGER,

    seq          INTEGER NOT NULL

);