-- Repositories kept in their owner's bucket (oxygenhub#96, oxygen#68):

-- the store's URL, the credentials sealed under keys/secrets.key, and the

-- last check of the store.

CREATE TABLE repo_storage (

    repo_id      INTEGER PRIMARY KEY REFERENCES repositories(id) ON DELETE CASCADE,

    url          TEXT NOT NULL,

    credentials  BLOB NOT NULL,

    created_ms   INTEGER NOT NULL,

    checked_ms   INTEGER,

    check_result TEXT NOT NULL DEFAULT ''

);