-- 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           BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,

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

    name         TEXT NOT NULL,

    size         BIGINT NOT NULL,

    hash         TEXT NOT NULL,

    content_type TEXT NOT NULL,

    uploader_id  BIGINT,

    created_ms   BIGINT NOT NULL

);

CREATE INDEX attachments_repo ON attachments (repo_id);

CREATE INDEX attachments_hash ON attachments (hash);