internal/store/migrations/0013_milestones.up.sql

 1CREATE TABLE milestones (
 2    id          INTEGER PRIMARY KEY,
 3    repo_id     INTEGER NOT NULL REFERENCES repos(id) ON DELETE CASCADE,
 4    title       TEXT NOT NULL,
 5    description TEXT NOT NULL DEFAULT '',
 6    due_date    TEXT NOT NULL DEFAULT '',
 7    state       TEXT NOT NULL DEFAULT 'open' CHECK (state IN ('open','closed')),
 8    created_at  TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
 9    UNIQUE (repo_id, title)
10);
11ALTER TABLE issues ADD COLUMN milestone_id INTEGER REFERENCES milestones(id) ON DELETE SET NULL;
12ALTER TABLE merge_requests ADD COLUMN milestone_id INTEGER REFERENCES milestones(id) ON DELETE SET NULL;