-- Hub state that Oxygen has no object for (hub spec §1.4). History,

-- references, signatures and policy live in each repository's own store.

CREATE TABLE repositories (

    id               INTEGER PRIMARY KEY,

    owner            TEXT NOT NULL,

    name             TEXT NOT NULL,

    description      TEXT NOT NULL DEFAULT '',

    default_bookmark TEXT NOT NULL DEFAULT 'main',

    visibility       TEXT NOT NULL DEFAULT 'public' CHECK (visibility IN ('public', 'internal', 'private')),

    created_ms       INTEGER NOT NULL,

    updated_ms       INTEGER NOT NULL,

    UNIQUE (owner, name)

);

-- Every reference update the protocol server accepted or refused (§6.12).

CREATE TABLE pushes (

    id         INTEGER PRIMARY KEY,

    repo_id    INTEGER NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,

    at_ms      INTEGER NOT NULL,

    reference  TEXT NOT NULL,

    ok         INTEGER NOT NULL,

    reason     TEXT NOT NULL DEFAULT ''

);

CREATE INDEX pushes_by_repo ON pushes (repo_id, at_ms DESC);