internal/store/migrations/0010_diff_comments.up.sql

 1CREATE TABLE mr_diff_comments (
 2    id          INTEGER PRIMARY KEY,
 3    mr_id       INTEGER NOT NULL REFERENCES merge_requests(id) ON DELETE CASCADE,
 4    author_id   INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
 5    head_sha    TEXT NOT NULL,
 6    path        TEXT NOT NULL,
 7    side        TEXT NOT NULL DEFAULT 'new' CHECK (side IN ('new','old')),
 8    line        INTEGER NOT NULL,
 9    body        TEXT NOT NULL,
10    reply_to    INTEGER REFERENCES mr_diff_comments(id) ON DELETE CASCADE,
11    resolved_at TEXT,
12    resolved_by INTEGER REFERENCES users(id) ON DELETE SET NULL,
13    created_at  TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
14);
15CREATE INDEX mr_diff_comments_mr ON mr_diff_comments(mr_id);