pr_01m47d15m3e54sn21z27rpy5n9/services/work/migrations/0007_timeline.sql
| 1 | -- What happened to an issue or a pull request, told in its conversation: |
| 2 | -- who was assigned, whose review was asked for, when it was closed. These |
| 3 | -- sit among the comments in the order they happened. |
| 4 | -- kind is 'comment' or 'event'. |
| 5 | ALTER TABLE comments ADD COLUMN kind TEXT NOT NULL DEFAULT 'comment'; |
| 6 | |
| 7 | -- The people a pull request is assigned to, and those whose review was |
| 8 | -- asked for: JSON arrays of usernames. `g1t-agent` among the reviewers |
| 9 | -- means a g1t agent was asked. |
| 10 | ALTER TABLE pulls ADD COLUMN assignees TEXT NOT NULL DEFAULT '[]'; |
| 11 | ALTER TABLE pulls ADD COLUMN reviewers TEXT NOT NULL DEFAULT '[]'; |