-- Files attached to issues, comments and proposals (oxygenhub#350): kept by

-- content in the hub's assets store, as release assets are, and served

-- under the repository's read rules.

CREATE TABLE attachments (

    id           INTEGER PRIMARY KEY,

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

    name         TEXT NOT NULL,

    size         INTEGER NOT NULL,

    hash         TEXT NOT NULL,

    content_type TEXT NOT NULL,

    uploader_id  INTEGER,

    created_ms   INTEGER NOT NULL

);

CREATE INDEX attachments_repo ON attachments (repo_id);

CREATE INDEX attachments_hash ON attachments (hash);