AkurAI-Build / migrations/010_issue_links.sql

Latest change b9bf8c65e7cff19e76ae78f73b05d66f6a1b4729 - OLI-274: commits and pull requests link to the Paperclip issues they mention by Óli

CREATE TABLE issue_links (
    repository_id INTEGER NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,
    object TEXT NOT NULL CHECK (length(object) BETWEEN 1 AND 120),
    issue TEXT NOT NULL CHECK (length(issue) BETWEEN 3 AND 32),
    created_at INTEGER NOT NULL DEFAULT (unixepoch()),
    PRIMARY KEY (repository_id, object, issue)
) STRICT;