pr_01m47d15m3e54sn21z27rpy5n9/services/work/migrations/0011_agent_messages.sql
| 1 | -- Messages people send an agent while it works on a pull request. The |
| 2 | -- sandbox takes the undelivered ones at each step of the agent's run. |
| 3 | CREATE TABLE agent_messages ( |
| 4 | id TEXT PRIMARY KEY, |
| 5 | pull_id TEXT NOT NULL, |
| 6 | author_id TEXT NOT NULL, |
| 7 | author_name TEXT NOT NULL, |
| 8 | body TEXT NOT NULL, |
| 9 | created_at TEXT NOT NULL, |
| 10 | delivered_at TEXT |
| 11 | ); |
| 12 | CREATE INDEX agent_messages_by_pull ON agent_messages (pull_id, created_at); |