-- Comments on a drop (oxygenhub#280): its readers', in Markdown; the

-- author, the drop's owner or a site administrator deletes one.

CREATE TABLE drop_comments (

    id         BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,

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

    author_id  BIGINT REFERENCES accounts(id) ON DELETE SET NULL,

    author     TEXT NOT NULL DEFAULT '',

    body       TEXT NOT NULL,

    created_ms BIGINT NOT NULL

);

CREATE INDEX drop_comments_by_drop ON drop_comments (repo_id, created_ms);